I have created , some Godlike Weapons and Armor.
I have the sql for the items. But not the Vendors.
10000-100082 is the item ids.
Filebeam - Free Fast File Hosting
Printable View
I have created , some Godlike Weapons and Armor.
I have the sql for the items. But not the Vendors.
10000-100082 is the item ids.
Filebeam - Free Fast File Hosting
Can you post some stats please? Also, Is the T7 balanced godlike in all the classes or can one class own another? And some pictures of what the characters look like with them on?Quote:
Originally Posted by REV2K6
Thanks.
-Kiteal.
I updated your SQL for you because some items are not supposed to be in there, like the flying broomstick for example :-)
I specfically got an error for item # 33622, which is why i edited the file, let me know!
http://www.ackholegames.com/Download...%20Ackhole.zip
Revision .1
Post some pic pls?
filefront mirror offline ^^
thanks man !Quote:
Originally Posted by Ackhole
Well it is Godlike , Warrior is T3 , Rogue is T2 Recolored,Pally T2,Shamn Merc,Hunter Merc,Priest t3,druid merc,lock merc.
Ya, but I mean like is the..Classes balances out for the Godlike armor, or can one god own another?Quote:
Originally Posted by REV2K6
Thanks.
-Kiteal.
i feel noobie to ask
but how do i add them? :blushing:
If you already have a DB loaded, jus right click your DB's name in SQLyog and then click "Import from SQL Dump".Quote:
Originally Posted by Vermathrax
Hope that helped.
-Kiteal
Quote:
Originally Posted by Kiteal
that gives an error :S
yeah,when i try to restore from sql dump it says sql dump import error
You may have to edit them to fit into your server, just open it up and change what needs to be changed by reading the error log. If you tell me what DB you are using I can fix it up for you, or send me the link to download it.Quote:
Originally Posted by Vermathrax
-Kiteal
Ok, I have redone this to include a creature_names database input and a creature_proto input, as well as a vendor input. Which basically means that you "Restore from SQL Dump" these four sql files, spawn the vendor, and it should work.
Attention: As when always doing database updates, make sure to backup your information FIRST.!
Check bottem posts by me for new link...
'Mmm, thanks again man. Helps out a lot. Since I am lazy Dx. Anyways, Thanks.Quote:
Originally Posted by Ackhole
-Kiteal
I still get an error when trying to import Vendors and items...
Query:
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`, `ItemExtendedCost`, `ReqDisenchantSkill`, `unk2`) values('9000002','2','7','-1','Red Lightsaber','Red Lightsaber','Red Lightsaber','Red Lightsaber','19997','4','0','0','0','21','-1','-1','152','70','0','0','0','0','0','0','0','1','0','0','4','33','7','42','15','100','12','100','1','0','1','0','1','0','1','0','1','0','1','0','117','187','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','25','0','25','5','5','1900','0','0','0','0','0','0','0','0','2767','2','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2','The Darkside','0','0','0','0','0','1','3','0','0','0','0','125','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')
Error occured at:2007-11-02 06:14:53
Line no.:2
Error Code: 1146 - Table 'mangos.items' doesn't exist
Query:
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`, `ItemExtendedCost`, `ReqDisenchantSkill`, `unk2`) values('9000002','2','7','-1','Red Lightsaber','Red Lightsaber','Red Lightsaber','Red Lightsaber','19997','4','0','0','0','21','-1','-1','152','70','0','0','0','0','0','0','0','1','0','0','4','33','7','42','15','100','12','100','1','0','1','0','1','0','1','0','1','0','1','0','117','187','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','25','0','25','5','5','1900','0','0','0','0','0','0','0','0','2767','2','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2','The Darkside','0','0','0','0','0','1','3','0','0','0','0','125','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')
Error occured at:2007-11-02 06:19:04
Line no.:2
Error Code: 1146 - Table 'mangos.items' doesn't exist
Query:
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`, `ItemExtendedCost`, `ReqDisenchantSkill`, `unk2`) values('9000002','2','7','-1','Red Lightsaber','Red Lightsaber','Red Lightsaber','Red Lightsaber','19997','4','0','0','0','21','-1','-1','152','70','0','0','0','0','0','0','0','1','0','0','4','33','7','42','15','100','12','100','1','0','1','0','1','0','1','0','1','0','1','0','117','187','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','25','0','25','5','5','1900','0','0','0','0','0','0','0','0','2767','2','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2','The Darkside','0','0','0','0','0','1','3','0','0','0','0','125','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')
Error occured at:2007-11-02 06:20:37
Line no.:2
Error Code: 1146 - Table 'mangos.items' doesn't exist
Query:
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`, `ItemExtendedCost`, `ReqDisenchantSkill`, `unk2`) values('9000002','2','7','-1','Red Lightsaber','Red Lightsaber','Red Lightsaber','Red Lightsaber','19997','4','0','0','0','21','-1','-1','152','70','0','0','0','0','0','0','0','1','0','0','4','33','7','42','15','100','12','100','1','0','1','0','1','0','1','0','1','0','1','0','117','187','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','25','0','25','5','5','1900','0','0','0','0','0','0','0','0','2767','2','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2','The Darkside','0','0','0','0','0','1','3','0','0','0','0','125','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')
Error occured at:2007-11-03 09:01:29
Line no.:2
Error Code: 1146 - Table 'mangos.items' doesn't exist
Query:
DELETE FROM `vendors` WHERE `vendorGuid` IN (1337666)
Error occured at:2007-11-03 09:01:43
Line no.:1
Error Code: 1146 - Table 'mangos.vendors' doesn't exist
Query:
DELETE FROM `vendors` WHERE `vendorGuid` IN (1337666)
Error occured at:2007-11-03 09:01:46
Line no.:1
Error Code: 1146 - Table 'mangos.vendors' doesn't exist
Query:
DELETE FROM `vendors` WHERE `vendorGuid` IN (1337666)
Error occured at:2007-11-03 09:04:05
Line no.:1
Error Code: 1146 - Table 'mangos.vendors' doesn't exist
It would seem im missing something... :S
Sry for the long post..
Phoenixdk