I did everything like in guide. Im worried about one part tho. Executing Bath File. (.SQL file).
When right clicked on l2jdb i have only "Execute SQL file" option... Ok so i tried, and i get error while executing it.
__________
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, l' at line 2
I tried putting it manual, but i get something about wrong number in armor column i think or something. Tried putting 0 in there. I restarted the server, NPC spawns, but when i click to Buff me button i get msg that im not carrying quest item or i dont meet the criteria.
So is the problem in inserting that SQL file or something with the files?
I use L2jEqual Pack and btw about that "IF you have custom on ur server" step in NPC Buffer topic.. I guess i dont have any customs yet, i just installed the pack.
I used to run 400-600 players on a hetzner athlon server with 2gb ram back in the day and i used some really shitty scripts like rin4's buffer with memory leaks. Im only going to take seriously anyone that actually runs a server with these numbers when they tell you a vps isnt enough. The average vps CPU today is way better than an athlon from the late 2000s.
Try first with a decent vps and if you see it cant handle things have a plan to swap into a dedicated if you have to.
Looking for dsetup.dll can type unicode text I try to use old ver from assasin/crusade , source of frame is not working game can't open
Protocol High Elves: 464
https://www.mediafire.com/file/fh2ts4q8t9ywbcm/System_464_EU_v2.zip/file
old dsetup working all chonicle
https://www.mediafire.com/file/w9nnvd0ctwn25av/DSETUP.rar/file
Question
Flavio
So i tried to insert this buffer to my test server (im learning, newbie in all of these things)
http://www.maxcheaters.com/forum/index.php?topic=145079.0
I did everything like in guide. Im worried about one part tho. Executing Bath File. (.SQL file).
When right clicked on l2jdb i have only "Execute SQL file" option... Ok so i tried, and i get error while executing it.
__________
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, l' at line 2
[Err] INSERT INTO npc
(id, idTemplate, name, serverSideName, title, serverSideTitle, class, collision_radius, collision_height, level, sex, type, attackrange, hp, mp, hpreg, mpreg, str, con, dex, int, wit, men, exp, sp, patk, pdef, matk, mdef, atkspd, aggro, matkspd, rhand, lhand, armor, walkspd, runspd, faction_id, faction_range, isUndead, absorb_level, absorb_type)
VALUES
(121212, 31324, "Buffer", 1, "L2Emma", 1, "NPC.a_casino_FDarkElf", 8, 23, 70, "female", "L2Npc", 40, 3862, 1493, 11, 1, 40, 43, 30, 21, 20, 10, 0, 0, 1, 999, 1, 999, 99, 0, 333, 0, 0, 0, 55, 132, "NULL", 0, 0, 0, "LAST_HIT");
[Msg] Finished - Unsuccessfully
--------------------------------------------------
I tried putting it manual, but i get something about wrong number in armor column i think or something. Tried putting 0 in there. I restarted the server, NPC spawns, but when i click to Buff me button i get msg that im not carrying quest item or i dont meet the criteria.
So is the problem in inserting that SQL file or something with the files?
I use L2jEqual Pack and btw about that "IF you have custom on ur server" step in NPC Buffer topic.. I guess i dont have any customs yet, i just installed the pack.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts