whats up? i need some help

[arcan3]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:3695
L2JDP Revision Number:6775

Right to the point? tryna get the scheme buffer in my server half way there and need a lil help.

this is prolly a uber noob question ... but ive figured out how to do most of this stuff on my own and i cant seem to find a good turtorial on how to implement a npc scheme buffer... i downloaded the script and everything from viewtopic.php?f=73&t=14469&p=71049&hili ... fer#p71049 , now i followed most of the steps in the download file its self, the only problem i seem to come across is when it says to create a table, now i know how to create the table... the problem im having is that when i create table i only have one slot available to edit =/ i know how to creat the table but how do i create the tabs within the table or where do i even put this cuz i thought i use this in navicat .... cuz its talkn bout tables... sry for such the noobness.

CREATE TABLE IF NOT EXISTS `scheme_buffer_profiles` (
`charId` int(10) unsigned NOT NULL, <--- char i dont have a tab for that when i create a table -_-
`profiles` varchar(45) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `scheme_buffs` (
`buff_name` varchar(45) CHARACTER SET latin1 COLLATE latin1_spanish_ci DEFAULT NULL,
`buff_id` int(10) DEFAULT NULL,
`buff_lvl` int(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `scheme_char_buffs` (
`charId` int(10) unsigned NOT NULL,
`profiles` varchar(45) DEFAULT NULL,
`buff_name` varchar(45) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[knoppix]

If the only thing you need is to create a table with those values ... you can do it from "Navicat" for example, and then go to the "source view" or code i don't remember exactly and see where is the error...

It's an idea =)

[arcan3]

Okay ima see if i can figure out what ur saying... and see if it works ... just when i make a table it only gives me one tab.. lol.. but ill try again in a lil bit.. thx for ur help bro.

[knoppix]

If you use Navicat you gonna see this:

Yo can create the table and avoid that part of the script since the table is gonna be already created.



Hope it works!

See ya!

[janiii]

you dont need to create the table by hand. just run the sql query. in the query window of the database.

[arcan3]

thx alot man =]