[SQL] Full item DB (ArcEmu up to 3.3) menu

Shout-Out

User Tag List

Results 1 to 5 of 5
  1. #1
    silencer727's Avatar Member
    Reputation
    1
    Join Date
    Jan 2009
    Posts
    31
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [SQL] Full item DB (ArcEmu up to 3.3)

    I had the item grabber running for 4 days.
    And made a fully updated item Database.
    INCLUDING 3.3 items

    This is 99% bug less, I know its sounds ''To good to be true'' but this actually is good.

    To make sure this SQL fits your Database i suggest to run this query. To get the item DB with the latest structure.
    (100% Official ArcEmu)
    Code:
    ALTER TABLE `items`
      ADD COLUMN `faction` int(11) UNSIGNED DEFAULT '0' NOT NULL after `flags`;


    This SQL does not wipe your item DB. It only deletes the items that are in the SQL (ID 1-54015)

    Download Link:
    Rapidshare Traficshare download (no waiting time)


    REMEMBER ARCEMU ONLY!!!

    [SQL] Full item DB (ArcEmu up to 3.3)
  2. #2
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Altering the table will stop items working if the core is not set to work like that.

  3. #3
    theiscnp's Avatar Member
    Reputation
    1
    Join Date
    Mar 2009
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Awsome. Tanks.

    Why will the items "stop working"? Just beacuse you're altering the table?
    Last edited by theiscnp; 01-29-2010 at 04:58 PM.

  4. #4
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by theiscnp View Post
    Awsome. Tanks.

    Why will the items "stop working"? Just beacuse you're altering the table?
    Because the core loads a certain item table structure, if you then change the structure by altering the table it will no longer be able to read it.

  5. #5
    St4rf1sh's Avatar Sergeant
    Reputation
    9
    Join Date
    Jan 2010
    Posts
    56
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by stoneharry View Post
    Because the core loads a certain item table structure, if you then change the structure by altering the table it will no longer be able to read it.
    indeed ^^ theres not way a database would run on its own its just a place to store data (pretty common sense) then you use an external program to read it

Similar Threads

  1. [SQL] 3.3.2 Arcemu Mall Vendors V1
    By scyths in forum WoW EMU General Releases
    Replies: 6
    Last Post: 06-01-2010, 03:21 AM
  2. [SQL] 3.3.2 Arcemu Mall Vendors V1
    By Superpro in forum WoW EMU General Releases
    Replies: 14
    Last Post: 05-03-2010, 03:04 PM
  3. [SQL] Mass Replace values? (ArcEmu)
    By davidknag in forum WoW EMU Questions & Requests
    Replies: 8
    Last Post: 03-02-2010, 03:04 AM
  4. [SQL] All items for ArcEmu patch 3.0+
    By mmhelm in forum WoW EMU General Releases
    Replies: 1
    Last Post: 12-31-2009, 01:58 PM
  5. Every Item Broken - (ArcEMU) *STILL UNRESOLVED*
    By Ghosthopper in forum WoW EMU Questions & Requests
    Replies: 6
    Last Post: 04-08-2009, 09:36 AM
All times are GMT -5. The time now is 11:06 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search