You needa click "Show All"
You needa click "Show All"
Message me for Basic Private Server Setup help.
there is a easier way can't remeber the site....
if this is the "easy way" then whats the hard way?
i can't find the Items_template Table in my database, why?
do i have to download and reinstall Navicat or what?
have navicat installed via the Antrix 2.1.x-guide do i have to uninstall that one and install this one or what?
Video games dont cause violence... Lag does (thanks to the guy i got it from on this forum ^^)
[Err] [Imp] 1062 - Duplicate entry '0' for key 1
[Err] [Imp] insert into `item_template` (`class`,`subclass`,`unk0`,`name`,`displayid`,`Quality`,`Flags`,`BuyCount`,`BuyP rice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,` RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`requiredhono rrank`,`RequiredCityRank`,`RequiredReputationFaction`,`RequiredReputationRank`,` maxcount`,`stackable`,`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`,`RangedModRange`,`spellid_1`,`spelltrigger_1`,`spellcharge s_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,` spelltrigger_2`,`spellcharges_2`,`spellcooldown_2`,`spellcategory_2`,`spellcateg orycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellcooldown_3`,` spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellch arges_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_ 5`,`spelltrigger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcategory_5`,`spellc ategorycooldown_5`,`bonding`,`description`,`PageText`,`LanguageID`,`PageMaterial `,`startquest`,`lockid`,`Material`,`sheath`,`RandomProperty`,`RandomSuffix`,`blo ck`,`itemset`,`MaxDurability`,`area`,`map`,`BagFamily`,`TotemCategory`,`socketCo lor_1`,`socketContent_1`,`socketColor_2`,`socketContent_2`,`socketColor_3`,`sock etContent_3`,`socketBonus`,`GemProperties`,`ExtendedCost`,`RequiredDisenchantSki ll`,`ArmorDamageModifier`,`ScriptName`) values ('0','0','0',' name','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','1','1','2','2','3','3','4','4','5','5','6','6','7','7','8','8','9','9 ','10','10','1','1','1','2','2','2','3','3','3','4','4','4','5','5','5','0','0', '0','0','0','0','0','0','0','0','1','1','1','1','1','1','2','2','2','2','2','2', '3','3','3','3','3','3','4','4','4','4','4','4','5','5','5','5','5','5','0',' description','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1' ,'1','2','2','3','3','0','0','0','0','0',' ScriptName'),('2','7','0','32837','5','0','0','150001212','10101','13','70','70' ,'0','0','0','0','0','0','0','2','1','0','3','500','7','500','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','0','1500','1500','0','1500','1500','5' ,'1500','1500','2','0','0','0','0','0','0','0','100','100','100','100','100','10 0','10000','0','0','17713','1','0','0','0','0','18060','1','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0',' 0','0','0','0','1','3','0','0','0','0','500','0','0','0','0','1','0','2','0','4' ,'0','90','0','0','0','0','0','0','0','')
[Msg] [Imp] Processed:2, Added:0, Updated:0, Deleted:0, Errors:2
[Msg] [Imp] Finished - Unsuccessfully
------------------------------------------------------------------------------------------
Somebody pls, i always get that f... msg when i do tthat..
i use the ReaperMangos 4577 with DB Silvermoon v18..
for WoW TBC 2.2.3 ...
ok i figured it out u just put the rest from the ("ItemID"-part(minus the () ) in the Lower MsgBox and and put it in a notepad-doc and just import it into the Items Database. just make sure u have a Unique ID coz if u dont it wont be created. I know ppl have said it before but i summ it all up to make it a little easier. :P
Video games dont cause violence... Lag does (thanks to the guy i got it from on this forum ^^)
MY EMAIL IS davemustaine_ @hotmail .com plz man can u explain me how to add the custom weps cuz the problem its not to make them but i cant connect to a server with the mysql... i just got one of the programs....the other that u told here " Download the crack file I have attatched and replace the navicat.exe in your main folder with the one in there." i could not find...so man can u plz help me with it i really need.... ah just one thing i dont have a server .... do i need to own a server to add the weps? im gm on a server....
so thats it man i hope u help me...thats it...thx
Hey i was just wondering, and it would probably be very helpful to a lot more people out there, but how do you give your custom item a custom buyprice unit, such as marks of honor?
For example, I want the item to cost X amount of marks of honor.
If anyone knows the answer to this question, lemme know asap.
Thanks in advance.
hi, ive probably asked this in a number of places by now but,
see i made my custom weapons and gear, but i realized after adding them that i had a couple errors. i changed the errors in the .sql files, deleted the originals in mysql, then re-executed the modified files. the new entries show up perfect in mysql, but when i log into my server i get the old items instead of the new ones.
ive tried ".reload items" and ive definitely saved the changes in mysql, and i restarted my server after updating the items table in mysql.
i dont know what else is wrong, do you think i need to somehow transfer the mysql info to some other file/location? i didnt have to do it when i first loaded the items. if i cant figure it out, i guess i will just make the same items again with diff entry numbers cuz man this isnt worth the effort :P
thank you.
ähhm he tell me at page 6 from step 20 it says : Dokument: No field selected
What now?
ok now it worked but when i click start it says :
[2013-01-30 19:19:09] [Msg] Import start
[2013-01-30 19:19:09] [Msg] Import type - Text file
[2013-01-30 19:19:09] [Msg] Import from - F:\dd+.txt
[2013-01-30 19:19:09] [Msg] Import table [item_template]
[2013-01-30 19:19:09] [Err] 1062 - Duplicate entry '0' for key 1
[2013-01-30 19:19:09] [Err] INSERT INTO `item_template` (`class`,`subclass`,`displayid`,`Quality`,`Flags`,`BuyPrice`,`SellPrice`,`Invent oryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredS kill`,`RequiredSkillRank`,`requiredspell`,`maxcount`,`ContainerSlots`,`stat_type 1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_typ e4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_ty pe7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_t ype10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`d mg_type2`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`a rcane_res`,`delay`,`ammo_type`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`sp ellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltri gger_2`,`spellcharges_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycoold own_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellcooldown_3`,`spellcat egory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4` ,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spel ltrigger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategoryc ooldown_5`,`bonding`,`description`,`PageMaterial`,`lockid`,`RandomSuffix`,`block `,`itemset`,`MaxDurability`,`BagFamily`,`TotemCategory`,`socketColor_1`,`socketC olor_2`,`socketColor_3`,`socketBonus`,`GemProperties`,`ArmorDamageModifier`) VALUES ('0','0','0','0','0','e','ee','ee','e','ee','eee','eeee','ee','ee','eee','0','e' ,'e1','e1','e2','e2','e3','e3','e4','e4','e5','e5','e6','e6','e7','e7','e8','e8' ,'e9','e9','e10','e10','1','1','e1','2','2','e2','0','e','ee','ee','e','e','ee', 'e','e','e1','ee1','ee1','e1','ee1','ee1','e2','ee2','ee2','e2','ee2','ee2','e3' ,'ee3','ee3','e3','ee3','ee3','e4','ee4','ee4','e4','ee4','ee4','e5','ee5','ee5' ,'e5','ee5','ee5','0',' description','ee','0','0','0','ee','0','0','ee','e1','e2','e3','e','eee','ee')
[2013-01-30 19:19:09] [Err] 1062 - Duplicate entry '0' for key 1
[2013-01-30 19:19:09] [Err] INSERT INTO `item_template` (`class`,`subclass`,`displayid`,`Quality`,`Flags`,`BuyPrice`,`SellPrice`,`Invent oryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredS kill`,`RequiredSkillRank`,`requiredspell`,`maxcount`,`ContainerSlots`,`stat_type 1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_typ e4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_ty pe7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_t ype10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`d mg_type2`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`a rcane_res`,`delay`,`ammo_type`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`sp ellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltri gger_2`,`spellcharges_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycoold own_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellcooldown_3`,`spellcat egory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4` ,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spel ltrigger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategoryc ooldown_5`,`bonding`,`description`,`PageMaterial`,`lockid`,`RandomSuffix`,`block `,`itemset`,`MaxDurability`,`BagFamily`,`TotemCategory`,`socketColor_1`,`socketC olor_2`,`socketColor_3`,`socketBonus`,`GemProperties`,`ArmorDamageModifier`) VALUES ('2','15','5','0','10E19','10E19','13','8','16','999','1','0','0','0','0','0','7 ','99999','1','99999','31','99999','3','99999','4','99999','36','99999','32','99 999','7','99999','38','99999','38','99999','9999999999','9999999999','4','999999 9999','9999999999','2','0','99999999','99999999','99999999','99999999','99999999 ','99999999','0000001','0','0','1','0','0','0','0','18060','1','0','0','0','0',' 18060','1','0','0','0','0','18060','1','0','0','0','0','18060','1','0','0','0',' 0','0','0',' 0','0','1','0','0','0','0','0','0','0','0','0','0','0','0')
[2013-01-30 19:19:09] [Msg] Processed:2, Added:0, Updated:0, Deleted:0, Errors:2
[2013-01-30 19:19:09] [Msg] Finished - Unsuccessfully
Whats wrong?
i use the ReaperMangos 4577 with DB Silvermoon v18..
Antrix 2.1.x
Lol, just a little old xD
Good times.