[Lua+SQL] Multi-NPC

Code:

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('99099', "Multi NPC", "", '', '0', '10', '0', '3', '0', '0', '   5488', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`, `summonguard`)
values ('99099', '255', '255', '7', '20000000', '30000000', '10000000', '1', '1', '1999', '0', '222222', '222222', '0', '0', '0', '0', '600000', '1000000', '0', '0', '0', '0', '0', '0', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0', '1');

Execute this SQL for the VIP Location Key (Only with this key you will can go to VIP Location)

Code:

INSERT INTO `items` VALUES (70016, 13, 0, -1, 'V.I.P. Lounge Key', 22477, 5, 64, 0, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 3366, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Grants entrance into the V.I.P. Lounge. Don't get too hammered.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0);

Step 3 : Restart your server, login in game and spawn the NPC using the next command in chat .npc spawn 99099

NOTE : The lua is not mine , only the sql and the tutorial .

nice man
And this works fr all cores and patches?

Thanks for posting this BHX, I will use this.
+rep

Ok, I'm guessing this is for Arcemu?

I'm looking one for Mangos - Scriptdev2. I've been on the forums, but I need a unique one

Nice job again blach.

It looks pretty ArcEmuish to me..

Thanks BlacheX it is working perfectly...
+rep
Thanks.

I get an error when I go to execute "INSERT INTO `items` VALUES (70016, 13, 0, -1, 'V.I.P. Lounge Key', 22477, 5, 64, 0, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 3366, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Grants entrance into the V.I.P. Lounge. Don't get too hammered.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0);" The error reads "SQL error (1064): You have an error in you SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't get too hammered.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0' at line one. Please help

Did you click the world database before you executed?

Yes

Your database is either outdated or has a newer vesion which is why it does not allow you to execute it. - You will need to update your database - If you do not know how to update a database, do not attempt as it can mess up your server - or enter the item values in manually or re-create the item.

I´m from sweden and not the best on english but can somone please show me how to execute the stuff and whats the HeidiSQL ?

zainudini wrote:I´m from sweden and not the best on english but can somone please show me how to execute the stuff and whats the HeidiSQL ?

HeidiSQL is a program that you can control the database of your server on it , you can make accounts , and fix alot of things. About stuff what exalcy you wanna know?

Blachex Great one , +rep

if somone can make a video how I execute don´t under stand what he means

Fixed!

be sure you click on "world" database before executing the file