Item Warp LUA

[Cloud79]

We tested this on a 3.03 WoTLK Server, the one you find in tutorials with the video guide (kinda edited a bit now...)

Basically, all you need is a simple LUA Script and 2 SQL Scripts, which I'm about to give you because I'm such a kind person XD.

Included is a rar file that contains the LUA, all you have to do then, is insert it into the Scripts folder of your ArcEmu based server.

Then open you world datbase (the one with the items table and the playercreateinfo_items and:

Paste this query into your query manager, and run it:

(MAKE SUREYOU READ THROUGH THIS QUERY AND CHANGE THE PARTS I'VE SAID TO CHANGE, OTHERWISE IT WILL LOOK SILLY IN-GAME :P)

INSERT INTO items
   (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ReqDisenchantSkill`, `unk2`)
VALUES
   (92341, 15, 0, -1, '<CHANGE TO ITEM NAME>', '', '', '', 35133, 1, 0, 0, 0, 0, -1, -1, 100, 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, 0, 0, 0, 0, 1500, 0, 0, 46642, 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, 1, '<CHANGE THIS TO ITEM COMMENT>', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 0, 0, 0, NULL, -1, 0);

That first script shall make it so you can spawn the item. With the item code 92341

Next, you might want to make it so when you make a new char it automatically gives you this item when you make any kind of new character (that's including the DK's)

INSERT INTO playercreateinfo_items
  (indexid, protoid, slotid, amount)
VALUES
(1, 92341, 27, 1),
(2, 92341, 27, 1),
(3, 92341, 27, 1),
(4, 92341, 27, 1),
(5, 92341, 27, 1),
(6, 92341, 27, 1),
(7, 92341, 27, 1),
(8, 92341, 27, 1),
(9, 92341, 27, 1),
(10, 92341, 27, 1),
(11, 92341, 27, 1),
(12, 92341, 27, 1),
(13, 92341, 27, 1),
(14, 92341, 27, 1),
(15, 92341, 27, 1),
(16, 92341, 27, 1),
(17, 92341, 27, 1),
(18, 92341, 27, 1),
(19, 92341, 27, 1),
(20, 92341, 27, 1),
(21, 92341, 27, 1),
(22, 92341, 27, 1),
(23, 92341, 27, 1),
(24, 92341, 27, 1),
(25, 92341, 27, 1),
(26, 92341, 27, 1),
(27, 92341, 27, 1),
(28, 92341, 27, 1),
(29, 92341, 27, 1),
(30, 92341, 27, 1),
(31, 92341, 27, 1),
(32, 92341, 27, 1),
(33, 92341, 27, 1),
(34, 92341, 27, 1),
(35, 92341, 27, 1),
(36, 92341, 27, 1),
(37, 92341, 27, 1),
(38, 92341, 27, 1),
(39, 92341, 27, 1),
(40, 92341, 27, 1),
(41, 92341, 27, 1),
(42, 92341, 27, 1),
(43, 92341, 27, 1),
(44, 92341, 27, 1),
(45, 92341, 27, 1),
(46, 92341, 27, 1),
(47, 92341, 27, 1),
(48, 92341, 27, 1),
(49, 92341, 27, 1),
(50, 92341, 27, 1),
(51, 92341, 27, 1),
(52, 92341, 27, 1),
(53, 92341, 27, 1),
(54, 92341, 27, 1),
(55, 92341, 27, 1),
(56, 92341, 27, 1),
(57, 92341, 27, 1),
(58, 92341, 27, 1),
(59, 92341, 27, 1),
(60, 92341, 27, 1),
(61, 92341, 27, 1),
(62, 92341, 27, 1),
(63, 92341, 27, 1),
(64, 92341, 27, 1),
(65, 92341, 27, 1);

Thanks ;)

[MentaL]

[badboystar]

Nice, gonna try this! ;D

[Cloud79]

I made a bit of a silly mistake in my syntax before it should work now, i missed out a comma and put an extra one somewhere on the second script (uber fail).

I'd also like to add, this has outland, azeroth and northrend locations (including the DK starting location)

[ghosthud1]

hopefully we will have more releases, where only just learning the code but this is start and it seems to work well on our server uber kwl ness

[Bloodshed2007]

just put it into my server but it only shows first page...if i click on the cities or any of the others it just stays on the initial page...

[Overseer79]

Yo, you made sure it's not being really laggy or sumthing, it works in mine fine, ermm if not, make sure u put all the scripts in right, and maybe if not, ur server dunt support it =/

[Bloodshed2007]

nope servers not laggy 0ms, my core was released just before this item was released so it should work....

[Cloud79]

Well, obviously the item is working for you, because it is spawning correct, that means, that it is something to do with the LUA, which works fine on my server, and Overseer's and Ghost's, ermm, maybe they changed the version of LUA and something in the code needs to be chnaged for the new versions... :S

[jordanmckeag]

i Autally like this nice job m8

[Bloodshed2007]

downloaded it again and now it works...might have been the add i put in to it...

[munkie]

So far it works perfectly! There is one thing I was wondering about though, is there a way to get rid of the mouse selection when you use the item, so that the menu comes up right away on right click?

[Overseer79]

Hmmm, I havn't been able to figure that out, sometimes it does do it straight away, other times not, if you can figure it out, or anyone else, please feel free to post, this is probably a big help to some people starting servers like fun servers etc