[kalish]

Originally Posted by I need help xD

i got problem with my item to everytime i start my server up logg on my acc make a char than i try to do .additem 2000000 wich is the item id to my weap..i get it in BP but when i open the BP my weapon is a ? and each time i take the arrow over it i get error...woulden't mind with some help ....im useing antrix :/

You need a Displayid for the weapon, which is completely different from Add IDs. You can find them in some File at WoW-v.com in some downloads section.

[---free_kill---]

you have to delete you wow cache!!

[Zabitako]

sorry if its a noob question to ask, but where is the mysql? >.< also, each time i try to connect on localhost, it keeps saying:

1045 - Access denied for user 'mangos@localhost' (using password:YES)

plz help me!


edit:nvm, i got it working.

[Zabitako]

ok ive got another problem. i make the item, import it, and the game loads perfectly. but when i add the item into my inventory, i get either an item i never made, the item i made but with "This Item Begins A Quest" text, and it doesnt have the stats and everything else i put on it. can someone help me figure out my problem?

[muff3hkun]

1045 - Access denied for user 'mangos@localhost' (using password:YES)
i got this error message when i tried to set up the navicat connection, is there anything i've done wrong?
I have mysql running and everything, thanks

[Airwalk]

[Msg] [Imp] Import type - Text file
[Msg] [Imp] Import from - C:\Documents and Settings\Lee\My Documents\weapon.rtf
[Msg] [Imp] Import table [item_template]
[Err] [Imp] 1264 - Out of range value adjusted for column 'entry' at row 1
[Err] [Imp] insert into `item_template` (`entry`) values ('112520205700'),('5.41.15.150741020111222333'),('0')
[Msg] [Imp] Processed:3, Added:0, Updated:0, Deleted:0, Errors:3
[Msg] [Imp] Finished - Unsuccessfully


Thats the error message i got when i tryed to import my weapon
Please help if you do then for you:P

Thanks

~ Airwalk

[Archangel660]

I got this when i tried to import my weapon. How do I fix it?

[2007-09-03 17:38:45] [Msg] Import start
[2007-09-03 17:38:45] [Msg] Import type - Text file
[2007-09-03 17:38:45] [Msg] Import from - C:\Documents and Settings\HP_Administrator\Admin sword.txt
[2007-09-03 17:38:45] [Msg] Import table [items]
[2007-09-03 17:38:45] [Err] 1062 - Duplicate entry '0' for key 1
[2007-09-03 17:38:45] [Err] insert into `items` (`class`,`subclass`,`field4`,`name`,`name2`,`name3`,`name4`,`displayid`,`quality `,`flags`,`buyprice`,`sellprice`,`inventorytype`,`allowableclass`,`allowablerace `,`itemlevel`,`requiredlevel`,`RequiredSkill`,`RequiredSkillRank`,`RequiredSkill SubRank`,`RequiredPlayerRank1`,`RequiredPlayerRank2`,`RequiredFaction`,`Required FactionStanding`,`maxcount`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_ty pe2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_t ype5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_ type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dm g_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`,`arca ne_res`,`delay`,`ammo_type`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spell cooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigge r_2`,`spellcharges_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown _2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellcooldown_3`,`spellcatego ry_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`s pellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltr igger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycool down_5`,`bonding`,`description`,`page_id`,`page_language`,`page_material`,`quest _id`,`lock_id`,`lock_material`,`sheathID`,`randomprop`,`unk203_1`,`block`,`items et`,`MaxDurability`,`ZoneNameID`,`mapid`,`bagfamily`,`TotemCategory`,`socket_col or_1`,`unk201_3`,`socket_color_2`,`unk201_5`,`socket_color_3`,`unk201_7`,`socket _bonus`,`GemProperties`,`ItemExtendedCost`,`ReqDisenchantSkill`) values ('0','0','4',' name',' name2',' name3',' name4','0','0','0','0','0','0','0','0','0','0','0','0','0','1','2','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','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','2031','0','0','0','0',null,'0',nul l,'1','2013','2','2015','3','2017',null,null,null,'0')
[2007-09-03 17:38:45] [Err] 1264 - Out of range value adjusted for column 'field4' at row 1
[2007-09-03 17:38:45] [Err] insert into `items` (`class`,`subclass`,`field4`,`name`,`name2`,`name3`,`name4`,`displayid`,`quality `,`flags`,`buyprice`,`sellprice`,`inventorytype`,`allowableclass`,`allowablerace `,`itemlevel`,`requiredlevel`,`RequiredSkill`,`RequiredSkillRank`,`RequiredSkill SubRank`,`RequiredPlayerRank1`,`RequiredPlayerRank2`,`RequiredFaction`,`Required FactionStanding`,`maxcount`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_ty pe2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_t ype5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_ type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dm g_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`,`arca ne_res`,`delay`,`ammo_type`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spell cooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigge r_2`,`spellcharges_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown _2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellcooldown_3`,`spellcatego ry_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`s pellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltr igger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycool down_5`,`bonding`,`description`,`page_id`,`page_language`,`page_material`,`quest _id`,`lock_id`,`lock_material`,`sheathID`,`randomprop`,`unk203_1`,`block`,`items et`,`MaxDurability`,`ZoneNameID`,`mapid`,`bagfamily`,`TotemCategory`,`socket_col or_1`,`unk201_3`,`socket_color_2`,`unk201_5`,`socket_color_3`,`unk201_7`,`socket _bonus`,`GemProperties`,`ItemExtendedCost`,`ReqDisenchantSkill`) values ('2','7.','.','Admin o.O','Admin o.O','18583','6','0','10000','20000','13','-1','-1','100','1','0','0','0','0','0','0','0','999','999','1','10000','3','10000','4' ,'10000','5','10000','6','10000','7','10000','12','10000','13','10000','18','100 00','21','10000','9999','10000','0','9999','10000','1','9999','10000','5','9999' ,'10000','2','999','10000','4','0','10000','10000','10000','10000','10000','1000 0','1','0','0','17713','0','0','0','0','34696','2','0','0','0','0','18060','1',' 0','0','0','0','35844','1','0','0','0','0','18060','1','0','0','0','0','0','0',' 0','0','0','0','0','1','3','0','0','0','0','1000000','0','0','0','0','1','0','1' ,'0','1','0','2864','0','0','0','0','0')
[2007-09-03 17:38:45] [Msg] Processed:2, Added:0, Updated:0, Deleted:0, Errors:2
[2007-09-03 17:38:45] [Msg] Finished - Unsuccessfully

[Krondorian]

same error, something about password being wrong

Ok, I created an item, but when I log into the game I get "Item does not exist" error

[saltychp]

Access denied for user 'mangos@localhost' (using password:YES)

how do i fix this problem?

[Dreadly]

Im puzzled, Whenever I try and get my item it says "Invalid Item ID" What am I doing wrong >.<

[kc102]

Originally Posted by Krondorian

same error, something about password being wrong

Ok, I created an item, but when I log into the game I get "Item does not exist" error

Make sure your using the items entry ID and not the display ID.

Originally Posted by saltychp

Access denied for user 'mangos@localhost' (using password:YES)

how do i fix this problem?

Are you using WAMP?

Originally Posted by Chaotica15

Im puzzled, Whenever I try and get my item it says "Invalid Item ID" What am I doing wrong >.<

As above, make sure your using the items entry ID and not the display ID.

[deadbanana]

i make the wep i want and when i try to import the file it always comes up with the same errors...
why? i've tried a few different entry IDs adn stuff

[deadsteel]

ignore this post, I accidently multiposted

[deadsteel]

Im a new person to practically all programming, could someone please private message me and give me some help, The most I can do is speed and wall hack


Please help me...

[Bladevil]

This is great, i've made two weapons... it took a while for me to understand everything, but now suddently i get a error.. the window looks like this

[Msg] [Imp] Import start
[Msg] [Imp] Import start
[Msg] [Imp] Import type - Text file
[Msg] [Imp] Import from - Cocuments and SettingsHP_EierSkrivebordCustom ItemsCustom WeaponsThe ItemPure_Destroyer-1000003.sql
[Msg] [Imp] Import table [items]
[Err] [Imp] 1062 - Duplicate entry '0' for key 1
[Err] [Imp] insert into `items` (`entry`,`class`,`subclass`,`field4`,`name`,`name2`,`name3`,`name4`,`displayid`, `quality`,`flags`,`buyprice`,`sellprice`,`inventorytype`,`allowableclass`,`allow ablerace`,`itemlevel`,`requiredlevel`,`RequiredSkill`,`RequiredSkillRank`,`Requi redSkillSubRank`,`RequiredPlayerRank1`,`RequiredPlayerRank2`,`RequiredFaction`,` RequiredFactionStanding`,`Unique`,`maxcount`,`ContainerSlots`,`stat_type1`,`stat _value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`sta t_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`st at_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`,`spel lcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigg er_4`,`spellcharges_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldow n_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcateg ory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`page_id`,`page_languag e`,`page_material`,`quest_id`,`lock_id`,`lock_material`,`sheathID`,`randomprop`, `unk203_1`,`block`,`itemset`,`MaxDurability`,`ZoneNameID`,`mapid`,`bagfamily`,`T otemCategory`,`socket_color_1`,`unk201_3`,`socket_color_2`,`unk201_5`,`socket_co lor_3`,`unk201_7`,`socket_bonus`,`GemProperties`,`ItemExtendedCost`,`ReqDisencha ntSkill`,`unk2`) values ('0','0','0','4',' name',' name2',' name3',' name4','0','0','0','0','0','0','0','0','0','0','0','0','0','1','2','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','2031','0','0','0','0',null,'0',nul l,'1','2013','2','2015','3','2017',null,null,null,'0','2')
[Err] [Imp] 1062 - Duplicate entry '1000003' for key 1
[Err] [Imp] insert into `items` (`entry`,`class`,`subclass`,`field4`,`name`,`name2`,`name3`,`name4`,`displayid`, `quality`,`flags`,`buyprice`,`sellprice`,`inventorytype`,`allowableclass`,`allow ablerace`,`itemlevel`,`requiredlevel`,`RequiredSkill`,`RequiredSkillRank`,`Requi redSkillSubRank`,`RequiredPlayerRank1`,`RequiredPlayerRank2`,`RequiredFaction`,` RequiredFactionStanding`,`Unique`,`maxcount`,`ContainerSlots`,`stat_type1`,`stat _value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`sta t_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`st at_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`,`spel lcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigg er_4`,`spellcharges_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldow n_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcateg ory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`page_id`,`page_languag e`,`page_material`,`quest_id`,`lock_id`,`lock_material`,`sheathID`,`randomprop`, `unk203_1`,`block`,`itemset`,`MaxDurability`,`ZoneNameID`,`mapid`,`bagfamily`,`T otemCategory`,`socket_color_1`,`unk201_3`,`socket_color_2`,`unk201_5`,`socket_co lor_3`,`unk201_7`,`socket_bonus`,`GemProperties`,`ItemExtendedCost`,`ReqDisencha ntSkill`,`unk2`) values ('1000003','2','7','-1','Pure Destroyer','Pure Destroyer','Pure Destroyer','Pure Destroyer','45481','6','0','2000000000','1500000000','13','-1','-1','200','70','0','0','0','0','0','0','0','1','1','0','7','400','4','200','3','2 00','12','200','13','200','14','200','35','200','19','340','28','340','16','340' ,'578','612','0','365','386','1','365','386','2','365','386','3','365','386','4' ,'0','120','120','120','120','120','120','100','0','0','17713','1','0','0','0',' 0','17713','1','0','0','0','0','17713','1','0','0','0','0','34696','2','0','0',' 0','0','34696','2','0','0','0','0','1','The guy who wield this weapon is SICK!','0','0','0','0','0','1','3','0','0','0','0','20000','0','0','0','0','1',' 0','1','0','1','0','1585','0','0','0','0')
[Msg] [Imp] Processed:2, Added:0, Updated:0, Deleted:0, Errors:2
[Msg] [Imp] Finished - Unsuccessfully

The main errors are

[Err] [Imp] 1062 - Duplicate entry '0' for key 1
[Err] [Imp] insert into `items`
[Err] [Imp] 1062 - Duplicate entry '1000003' for key 1
[Err] [Imp] insert into `items`

Any ideas?