Updating item on the DB menu

User Tag List

Results 1 to 3 of 3
  1. #1
    malahmen's Avatar Member
    Reputation
    7
    Join Date
    May 2020
    Posts
    20
    Thanks G/R
    11/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Updating item on the DB

    Went to try and update some item on the DB.
    Pretty straight forward with the mysql workbench, and SQL is not an issue.

    The issue is that after committing the changes in the DB and restarting the server, I add the item to my character and it's stats are unchanged.

    What steps am I missing here?

    Before you ask, I'm using the world DB, the item_template table.

    These ads disappear when you log in.

  2. #2
    malahmen's Avatar Member
    Reputation
    7
    Join Date
    May 2020
    Posts
    20
    Thanks G/R
    11/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    On the worldserver.conf file be sure to set: DBC.EnforceItemAttributes = 0
    Delete the cache folder in the client.

    But still, editing the item won't show any change in game.

    Supposedly it shouldn't be needed to create a patch for a simple edit on an existing item (for example changing the value of an existing attribute), but since I'm going nowhere, I suppose its faster to query the DB for all the items I want to edit (I am not thinking of creating new ones, but editing existing ones to scale with level without being heirlooms) and make a damn patch with them.

    If anyone has a better idea, I would appreciate it.
    Last edited by malahmen; 10-18-2020 at 12:52 AM. Reason: updated information.

  3. #3
    malahmen's Avatar Member
    Reputation
    7
    Join Date
    May 2020
    Posts
    20
    Thanks G/R
    11/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Conclusion:
    - for simple properties like strength and stamina, SQL is enough.

    But after editing the properties:
    - completely shut down your client.
    - delete the client cache folder
    - kill your server process
    - restart the server processes
    - restart the client
    - use the .additem ### command to check the item you edited (you should see the changes)

    After a while, it worked for me.
    I was logging out and back in so the cache was always being written with what the client had in its memory (in my case the unedited item).

Similar Threads

  1. [Guide] How To Get your Items on The Auction house SOLD FAST!
    By XC4T4LY5TX in forum World of Warcraft Guides
    Replies: 5
    Last Post: 01-24-2010, 01:06 AM
  2. Added items in the DB but i cant add them in ingame
    By Nadromar in forum WoW EMU Questions & Requests
    Replies: 6
    Last Post: 04-13-2009, 06:00 AM
  3. Replies: 3
    Last Post: 08-10-2008, 10:38 AM
  4. Replies: 13
    Last Post: 04-12-2008, 10:48 AM
  5. Reselling items on the AH (saving money) Common sense?
    By wowkid in forum World of Warcraft Guides
    Replies: 6
    Last Post: 01-03-2008, 03:05 PM
All times are GMT -5. The time now is 09:32 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search