Database update menu

User Tag List

Results 1 to 12 of 12
  1. #1
    predattak's Avatar Active Member
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    537
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database update

    Hello i have an problem .. me and my friends maked some custom housez and things some time ago on an 3.0.3 arcemu server.. now i want to put the housez on my 3.3.0a arcemu server but the gameobject tables are out of date so can anyone help me with an update or something pls ? :wave:
    Homosexuals are gay

    Database update
  2. #2
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You will need to get a database that has the correct dated tables, and then add the Game object again, simply by finding the displayid and the type used to spawn it, i.e 6502 (Displayid) and 5 (type). The rest you can fill out without help




  3. #3
    predattak's Avatar Active Member
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    537
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well even if i do that and it will take some years lol the gameobject_spawns table is out of date so i will have the game objects but i will have to make all the custom stuff again so it's useless .. but thx
    Homosexuals are gay

  4. #4
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It wont take that long, there is only about 10 custom objects that you can really build with. Then you just spawn them ingame?




  5. #5
    predattak's Avatar Active Member
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    537
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    u don't understand .. we did an custom city ! that's alloot of housez and allot of things in housez u know .. beds pillows lights tables drapes doors books plates etc etc etc full equiped housez u know ...that's ... ALLOT and belive me when i say allot it's really allot
    Last edited by predattak; 01-18-2010 at 10:46 AM.
    Homosexuals are gay

  6. #6
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well you could dump the SQL File, and edit it manually... But that would still take time.




  7. #7
    predattak's Avatar Active Member
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    537
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah... i will search for an database update .. if not .. oh well ..
    Homosexuals are gay

  8. #8
    Ground Zero's Avatar ★ Elder ★
    Reputation
    1132
    Join Date
    Aug 2008
    Posts
    3,504
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There is a lazy way, just count the column amounts in the current Gameobject_names and compare it to your old gameobject_names and just add/remove extra columns to make it match.

  9. #9
    predattak's Avatar Active Member
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    537
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    wo.. that will take ages hehe but it's a solution..
    Homosexuals are gay

  10. #10
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What GZ said will take a lot less time than you might think. All you need to do is add/drop a few colums to make it compatible.




  11. #11
    predattak's Avatar Active Member
    Reputation
    27
    Join Date
    Jul 2008
    Posts
    537
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    it worked with collums adding thx alot guys i can't +rep u
    Homosexuals are gay

  12. #12
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Its alright. Your welcome




Similar Threads

  1. Database update On mongos
    By minipopov in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 04-28-2014, 06:30 AM
  2. [Trinity] [Question] World Database Update Issue
    By Ulec in forum WoW EMU Questions & Requests
    Replies: 7
    Last Post: 04-06-2014, 05:24 PM
  3. [Database] help needed with databases update
    By networkmoneky in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 01-03-2013, 12:54 AM
  4. Database update question
    By logicd22 in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 01-26-2008, 11:37 AM
  5. [Release] Precompiled, Latest Ascent REVs + scripts + databases (updated regular)
    By latruwski in forum World of Warcraft Emulator Servers
    Replies: 67
    Last Post: 12-14-2007, 07:47 AM
All times are GMT -5. The time now is 12:47 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search