[Lua] Infinity Stone

[Ground Zero]

Infinity Lua Stone.

Features;
---[Player Control Panel]---
--[Reset Talents]--
--[Open Bank]--
--[Remove Resurrection Sickness]--
--[Gender Change]--
---[Weather Control Panel]---
--[Sunny]--
--[Foggy]--
--[Raining]--
--[Snowing]--
---[Buffs]---
---[Morphs]---
---[GM Option]---
- Checks if you've already applied the buffs so the players can't reapply the Damage Shield.

- Checks if your a GM so players can't use the GM Options.

I made this because I was bored and wanted to brush up on some Lua skills. Feel free to flame.

ArcEmu SQL for the Stone;
SQL pastebin - collaborative debugging tool

Lua Script:
Lua pastebin - collaborative debugging tool

Enjoy.

[Danne206]

Looks awsome, +2 for the effort.
Edit: Must spread, bah ;<

[Kiev]

Nice release.

Put alot of effort into this.

Must spread for rep >.<

[Vision1000]

this sux. like u.

make a lua mangos versior u noob.

edit: im gettin compile errors. wow. delete ur post this script blows

..........+Rep =)

[Ground Zero]

this sux. like u.

make a lua mangos versior u noob.

edit: im gettin compile errors. wow. delete ur post this script blows

..........+Rep =)

You suck, and you don't compile Lua Scripts.

[rikkycurtis]

looks 1337, however im noob at this. I have heidisql however how do i put this object into my DB? if you can help me then il +rep to ya

[Ground Zero]

You execute the SQL via the Query Option then run it.

Put the .Lua into your Servers Script folder.

[rikkycurtis]

i got an error saying incorrect table name :/

[Ground Zero]

Try putting it into items.

[rikkycurtis]

still same error

[Ground Zero]

Are you using ArcEmu?

[rikkycurtis]

yup, if you need more info on the issue then heres the code

/* Delimiter changed to ;. */
/* Connecting to localhost, username root, using password: Yes ... */
/* Connected. Thread-ID: 23 */
SELECT VERSION() ;
SHOW STATUS LIKE 'Uptime' ;
SHOW DATABASES ;
USE `world-pvp` ;
SHOW TABLES FROM `information_schema` ;
(SELECT TABLE_NAME AS `Name`, TABLE_TYPE AS `Type`, ENGINE AS `Engine`, VERSION AS `Version`, ROW_FORMAT AS `Row_format`, TABLE_ROWS AS `Rows`, AVG_ROW_LENGTH AS `Avg_row_length`, DATA_LENGTH AS `Data_length`, MAX_DATA_LENGTH AS `Max_data_length`, INDEX_LENGTH AS `Index_length`, DATA_FREE AS `Data_free`, AUTO_INCREMENT AS `Auto_increment`, CREATE_TIME AS `Create_time`, UPDATE_TIME AS `Update_time`, CHECK_TIME AS `Check_time`, TABLE_COLLATION AS `Collation`, CHECKSUM AS `Checksum`, CREATE_OPTIONS AS `Create_options`, TABLE_COMMENT AS `Comment` FROM `information_schema`.TABLES WHERE TABLE_SCHEMA = 'world-pvp') UNION (SELECT ROUTINE_NAME AS `Name`, ROUTINE_TYPE AS `Type`, NULL AS `Engine`, NULL AS `Version`, NULL AS `Row_format`, NULL AS `Rows`, NULL AS `Avg_row_length`, NULL AS `Data_length`, NULL AS `Max_data_length`, NULL AS `Index_length`, NULL AS `Data_free`, NULL AS `Auto_increment`, CREATED AS `Create_time`, LAST_ALTERED AS `Update_time`, NULL AS `Check_time`, NULL AS `Collation`, NULL AS `Checksum`, NULL AS `Create_options`, ROUTINE_COMMENT AS `Comment` FROM `information_schema`.ROUTINES WHERE ROUTINE_SCHEMA = 'world-pvp') ORDER BY `Name` ;
INSERT INTO `` VALUES (80000, 0, 8, -1, 'Infinity Stone', 7041, 4, 0, 0, 0, 0, 0, -1, -1, 255, 80, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 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, 33208, 0, 0, 0, 1141, 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, 'A Magical Stone', 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) ;
/* SQL Error: Incorrect table name '' */
USE `world-pvp` ;
SHOW /*!32332 FULL */ COLUMNS FROM `items` ;
SHOW KEYS FROM `items` ;
SELECT `entry`, `class`, `subclass`, `field4`, LEFT(`name1`, 256), `displayid`, `quality`, `flags`, `faction`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSpell`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `itemstatscount`, `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`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `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`, LEFT(`description`, 256), `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `randomsuffix`, `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`, `ArmorDamageModifier`, `existingduration`, `ItemLimitCategory/* large SQL query, snipped at 2,000 characters */
INSERT INTO `` VALUES (80000, 0, 8, -1, 'Infinity Stone', 7041, 4, 0, 0, 0, 0, 0, -1, -1, 255, 80, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 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, 33208, 0, 0, 0, 1141, 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, 'A Magical Stone', 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) ;
/* SQL Error: Incorrect table name '' */
world-pvp ;
/* SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'world-pvp' at line 1 */
INSERT INTO `` VALUES (80000, 0, 8, -1, 'Infinity Stone', 7041, 4, 0, 0, 0, 0, 0, -1, -1, 255, 80, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 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, 33208, 0, 0, 0, 1141, 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, 'A Magical Stone', 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) ;
/* SQL Error: Incorrect table name '' */
INSERT INTO `` VALUES (80000, 0, 8, -1, 'Infinity Stone', 7041, 4, 0, 0, 0, 0, 0, -1, -1, 255, 80, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 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, 33208, 0, 0, 0, 1141, 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, 'A Magical Stone', 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) ;
/* SQL Error: Incorrect table name '' */

[rikkycurtis]

oops double post ftl.

[Ground Zero]

Insert between `` on the Query the word "items" and your done.

[rikkycurtis]

OMG thx man!