[Question] Items

[BrantX]

Hey, Why arn't my items working? Like they are, and i can add them to my inventory and my character, but when i create a item, it doesn't say i have it in my database

Can someone help me out?

[~ViVo~]

Core?
DB?
Tell meh more..

[**Sweeny**]

Did you make them with wow-v? DBE? tru db? that thing happend to me when I switched from SQLyog to navicat.

P.S. cant wait for your repack 99.99%!!!!!

[TheSpidey]

Like they are, and i can add them to my inventory and my character, but when i create a item, it doesn't say i have it in my database

Huh? They work but they don't work? Elaborate on when you get those messages.

[BrantX]

-_-, The items in the database that were added regularly can be used, but the one i create, GM Staff etc. won't add to my guy... it says it cant be found or its a invalid ID....

Ascent Database - 1149
Ascent Repack - 4197

[CairiFEA]

When you create an item the database needs to be reloaded.

This can be done 2 ways.

1. Server (ascent) restart
2. Have an admin or a GM with the command .reload to type
.reload items

this will reload the Items table in ascent, and your new weapons will be usable.

It will either say that is was reloaded successfully, or Failed.
This allows for on-the-fly weapon adding.

NOTE: if you have an item, and then modify it, reloading the database will work; but your character wont see the change until you /exit and delete your cache WDB folder in your Cache Wow directory.

Hope this helps.

Cairi,
gmtricks.com - Home

[BrantX]

Ok, I know how to do the stupid .reload thing, but when i did it didn't work, so i restarted my database, didn't work, deleted my Cache, didn't work.... Any help?

[~ViVo~]

Mines doing it now too.. Jinx

[BrantX]

/slap
/stangle
/stab
/snap-neck
/point
You hurt my feelings

[mager1794]

U may have set the item number to high i made a item with number 800900 and it didn't work til i lower it to 80090 it can only have 5 digits i think maybe thats it????

[~ViVo~]

Hey, Try this.

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 (99887,1,0,-1,"ViVoWoW Donator Bag","ViVoWoW Donator Bag","ViVoWoW Donator Bag","ViVoWoW Donator Bag",33942,5,0,00000,100000000,18,-1,-1,70,70,0,0,0,0,0,0,0,0,1,28,  1,50,  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,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,1,"Given For Donating to ViVoWoW",0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

Could be your code..
If that works.. I think I know your problem.

[BrantX]

Nope, If it was to high it would've given me an error saying "blah blah blah is to high" or something like that... So thats not the prop.

[CairiFEA]

Can you post some of the entries you made for the item?
It may be a value bug, OR you are creating the item in the wrong database.

When you reload, does it give an error
(reload failed)
or does it complete the reload?

I think we need a little more information to help you with this.

Cairi,

[BrantX]

Hey, Try this.

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 (99887,1,0,-1,"ViVoWoW Donator Bag","ViVoWoW Donator Bag","ViVoWoW Donator Bag","ViVoWoW Donator Bag",33942,5,0,00000,100000000,18,-1,-1,70,70,0,0,0,0,0,0,0,0,1,28,  1,50,  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,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,1,"Given For Donating to ViVoWoW",0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

Could be your code..
If that works.. I think I know your problem.

Nope, Didn't work.... Anything else?

"Sorry for Double post"

[~ViVo~]

Wow, if that didn't work. I know what will.
Give me a minute.. I got the perfect Idea.