i am new in l2 gamserver developing, and i am trying to add custom npc's to my server, the thing is that i have the sql file that needs to be imported but it gives me an error as there is no custom npc table in my database. i cant seem to find how can i create on that works with the right values for it to then be able to accept my custom sql file. could someone please assist me?
You always find a way to lower the bar.
Consistency matters.
I admire your dedication to being completely unaware of how little you matter.
at least you are not entirely useless you can always serve as a bad example
I already finished my panel for change name and gender, anyway need restart, im used schema
$stmt = $conn->prepare("EXEC lin_ChangeCharacterName2 ?, ?, ?");
for change name... also for change gender i used
if ($race == 5) // Kamael race ID; modify this value as per your database
{
$error = "Gender change is not allowed for Kamael race characters.";
}
else
{
$stmt = $conn->prepare("
UPDATE user_data
SET gender = ?, face_index = 0, hair_shape_index = 0, hair_color_index = 0
WHERE char_id = ? AND account_name = ?
");
Sorry no idea how to add cached update in myext64 about, not have any solution for this yet compatible to myext64 code.
This is my panel make in php http://177.73.143.43:8080/account/
Cool panel for me, without experience in any code. Without help from any people here 🙄
Question
immortal12
Hello there fellows members,
i am new in l2 gamserver developing, and i am trying to add custom npc's to my server, the thing is that i have the sql file that needs to be imported but it gives me an error as there is no custom npc table in my database. i cant seem to find how can i create on that works with the right values for it to then be able to accept my custom sql file. could someone please assist me?
thanks in advance
5 answers to this question
Recommended Posts