[Lua+SQL] Multi-NPC

Go down

[Lua+SQL] Multi-NPC

Post  Blachex on Sun Jul 04, 2010 3:47 pm

Multi-NPC

========================================================================

Features

-Horde/Alliance Mall Locations
-Main Citys-
-Leveling Road-
-VIP Lounge - Requires VIP Key-
-World Locations-
-Buff Up-
-Change the Weather (clientside)-
-Max All Skills-
-Reset Talent Points-
-Remove Rez Sickness


========================================================================

Screenshoot



========================================================================

How To Setup

Step 1 : Get the lua script from here ----> [You must be registered and logged in to see this link.]
Copy it in notepad then save it as .lua then add it in scripts folder found in your server repack.


Step 2 : Copy again the next .sql script in notepad and save it as .sql . Then run your server and execute this sql file (using HeidiSQL : Double click on the .sql file , login to database then press F9 to execute the file)

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 .




Last edited by Blachex on Tue Aug 03, 2010 1:42 am; edited 2 times in total

_________________
[You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.]
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  bajas2 on Sun Jul 04, 2010 7:15 pm

nice man Very Happy
And this works fr all cores and patches?

_________________
World of Warcraft Retail MoD

Ventrilo info:
eurovent1.gameservers.com
4601

avatar
bajas2
Power User (Special)
Power User (Special)

Posts Posts : 184
Location Location : Norway
Reputation Reputation : 29
Warning :

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  Broken. on Mon Jul 05, 2010 3:08 am

Thanks for posting this BHX, I will use this. Smile
+rep
avatar
Broken.
Member
Member

Posts Posts : 37
Location Location : Sweden
Reputation Reputation : 3

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  Lewis on Mon Jul 05, 2010 11:32 pm

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 Smile

Nice job again blach.
avatar
Lewis
TwistGaming Admin
TwistGaming Admin

Posts Posts : 198
Location Location : United Kingdom
Reputation Reputation : 26
Warning :

http://www.TwistGaming.com

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  bajas2 on Tue Jul 06, 2010 8:28 pm

It looks pretty ArcEmuish to me..

_________________
World of Warcraft Retail MoD

Ventrilo info:
eurovent1.gameservers.com
4601

avatar
bajas2
Power User (Special)
Power User (Special)

Posts Posts : 184
Location Location : Norway
Reputation Reputation : 29
Warning :

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  FailZorD on Fri Jul 09, 2010 5:29 am

Thanks BlacheX it is working perfectly...
+rep
Thanks.
avatar
FailZorD
Power User (Special)
Power User (Special)

Posts Posts : 82
Location Location : Athens
Reputation Reputation : 23
Warning :

http://www.lord-kings.co.nr

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  axelminion on Sat Jul 10, 2010 6:38 am

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

axelminion
Member
Member

Posts Posts : 6
Reputation Reputation : 0

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  bajas2 on Sat Jul 10, 2010 6:44 am

Did you click the world database before you executed?

_________________
World of Warcraft Retail MoD

Ventrilo info:
eurovent1.gameservers.com
4601

avatar
bajas2
Power User (Special)
Power User (Special)

Posts Posts : 184
Location Location : Norway
Reputation Reputation : 29
Warning :

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  axelminion on Sat Jul 10, 2010 11:19 am

Yes

axelminion
Member
Member

Posts Posts : 6
Reputation Reputation : 0

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  Lewis on Sat Jul 10, 2010 8:00 pm

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.
avatar
Lewis
TwistGaming Admin
TwistGaming Admin

Posts Posts : 198
Location Location : United Kingdom
Reputation Reputation : 26
Warning :

http://www.TwistGaming.com

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  zainudini on Tue Aug 03, 2010 3:10 am

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 ?
avatar
zainudini
Member
Member

Posts Posts : 26
Reputation Reputation : 0

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  giorgos on Tue Aug 03, 2010 4:12 am

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?


Last edited by giorgos on Sun Aug 22, 2010 5:47 pm; edited 1 time in total
avatar
giorgos
Super Moderator
Super Moderator

Posts Posts : 330
Location Location : Greece.
Reputation Reputation : 13
Warning :

http://www.twistgaming.com

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  giorgos on Tue Aug 03, 2010 4:13 am

Blachex Great one , +rep
avatar
giorgos
Super Moderator
Super Moderator

Posts Posts : 330
Location Location : Greece.
Reputation Reputation : 13
Warning :

http://www.twistgaming.com

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  zainudini on Tue Aug 03, 2010 4:17 am

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

Posts Posts : 26
Reputation Reputation : 0

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  erikhelenius on Sun Aug 22, 2010 5:45 pm

Fixed!


Last edited by erikhelenius on Sun Aug 22, 2010 10:38 pm; edited 1 time in total
avatar
erikhelenius
Member
Member

Posts Posts : 7
Reputation Reputation : 0
Warning :

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  Blachex on Sun Aug 22, 2010 5:46 pm

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

_________________
[You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.] | [You must be registered and logged in to see this link.]
avatar
Blachex
TwistGaming Admin
TwistGaming Admin

Posts Posts : 375
Location Location : Romania
Reputation Reputation : 38
Warning :

http://www.twistgaming.com

Back to top Go down

Re: [Lua+SQL] Multi-NPC

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum