Installing Buffer [IL]

[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.

 

[reyhanbjk]

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.

 

 

 

Add the SQL manually..

[Flavio]

"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."

 

I did try, i got error that i put wrong number in armor column. (I just put the 0 like in most of the rest NPCs in the list).

 

By the way, every NPC i add manually something is wrong, like no enough columns, or there are columns without any number. I dont know am I missing them or the .sql file is missing some numbers.

___

 

 

I definitely need someone with TeamViwer and experience to help me, every NPC i input, there's something wrong. So i think the problem is in me ^^

 

 

+ Forget this topic, i posted a new. Mod lock this one. TY

+ http://www.maxcheaters.com/forum/index.php?topic=187486.new#new

[Furiosus]

Forget this topic, i posted a new. Mod lock this one. TY

 

Locked.