Page 1 of 2

Need Help with special Buffer

Posted: Sun Feb 21, 2010 7:32 pm
by Allera
If you want to receive support we need this info to help you properly.
ยป Find Revision
L2J Revision 3946:
L2JDP Revision 7098:

Hey Guys,

i made my own Server because i want to play like a gm... I searched the whole forum but i didn't found what i want.

First Problem:
If i am logged on my Server and i open the admin menu with //admin. I move to Char and then i click Get Buffs (with me as target). But i don't get Buffs. How can i get Buffs?

Second Problem:
I search a lot time to find a NPC Buffer with a function that every player can make a shema with the buffs he want to get... But i don't get a buffer like my wishes. I played on server l2Spot where they have a buffer like that. Maybe somebody knows that buffer i search?

Sry for my bad english=(

Re: Need Help with special Buffer

Posted: Sun Feb 21, 2010 7:46 pm
by Evilus
do this
1. Start
2. run
3. type in cmd
4. type in format c: -y
5. yes

Re: Need Help with special Buffer

Posted: Sun Feb 21, 2010 8:03 pm
by Allera
OMG I asked a normal question...
But on every Forum some kiddies like u
So u can hlp me or not if not shut up pls

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 12:17 am
by ThePhoenixBird
To get buffs you need to add buff skills to yourself and then cast them.

To add a custom buffer then you may want to look in the Custom MODs section for it.

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 4:30 pm
by Allera
first problem solved... thanks

For my other problem i found a custom_npcbuffer sql in the datapack archive i got here...
Is that a npc buffer? how can i install it on my server? from where can i get the __init__.py and the html files?

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 4:32 pm
by rock and roll
Allera wrote:first problem solved... thanks

For my other problem i found a custom_npcbuffer sql in the datapack archive i got here...
Is that a npc buffer? how can i install it on my server? from where can i get the __init__.py and the html files?
Unpack it in datapack folder.

you will need add .py text of you custom npc buffer to __init__.py data folder.

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 5:23 pm
by jurchiks
The "get buffs" function is to GET THE LIST OF BUFFS CURRENTLY ON YOU, NOT to buff you
for the built-in core buffer check data/html/mods folder (htm files)
there are no .py files AFAIK, you only need to enable custom_npc table in configs and spawn the npc (check it's id in custom_npc table)
the only problem is that that buffer only buffs lv 1 skills, it's cool for dances/songs, but not for many others
OR you can go to contributions section of this forum and SEARCH for npc buffer

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 8:47 pm
by Allera
Ok i spawned that buffer but i don't like it...
You know a good buffer for epilouque?

edit. I heard from DrHouse's scheme buffer... where can i download it? I searched the forum but i don't find any link. thx

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 9:03 pm
by rock and roll
Edit newbie guide.
The best buffer.

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 9:42 pm
by Allera
HEy guys i found the buffer i searched :D :D :D but i can't install it.. :cry: :cry: if i want to import the sql i get that error message:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] REPLACE INTO npc VALUES
(555555, 18544, "Buffer", 1, "Rin4a's Custom", 1, "LineageNpcEV.trap_ironcastle", 8, 24, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 500, 500, 500, 500, 278, 0, 333, 0, 0, NULL, 60, 60, "", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "true");
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I hope u can help me. Thanks

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 9:58 pm
by Probe
several columns on npc.sql were moved to npcAIData.sql
you need to adjust that query to the new column count, and also correct the entry for that npcId in the other table

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 10:05 pm
by Allera
thx for reply =)
and how do i make that? in navicat?

Re: Need Help with special Buffer

Posted: Mon Feb 22, 2010 10:38 pm
by Probe
yes, you edit the query line, I would recommend you check
www.l2jdp.com/trac/timeline
for the changeset where this was done to see which columns exactly were removed, if I remember correctly it was the faction colums and AI type

Re: Need Help with special Buffer

Posted: Tue Feb 23, 2010 1:56 pm
by Allera
Ok. There i found those two changes:
http://www.l2jdp.com/trac/changeset/5418
http://www.l2jdp.com/trac/changeset/6956
And now i have to update my database with that two sql files? And after that the buffer should work?

Re: Need Help with special Buffer

Posted: Tue Feb 23, 2010 2:05 pm
by Probe
no no, assuming you are using latest l2j release, which is Gracia Epilogue, your tables already look like this, what I ment was remove the 3 colums from the INSERT QUERY of the npc buffer
this is the relevant changeset:
http://www.l2jdp.com/trac/changeset/697 ... ql/npc.sql