Isn't it perfectly safe for your server to update the ascent ? menu

Shout-Out

User Tag List

Results 1 to 12 of 12
  1. #1
    Wheeze201's Avatar Active Member
    Reputation
    51
    Join Date
    Apr 2007
    Posts
    660
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Isn't it perfectly safe for your server to update the ascent ?

    Well.. when i open up ADE ( Ascent Database Editor ) 1.0.4 it says that i should update my Database Structure manually ( I'm guessing it's the ascent.. but not sure though ).
    Is it totally safe to update to a different ascent rev ?
    Shouldn't i just save my .conf files somewhere else and then restore them when I've updated.

    And how can you know if your ascent rev is not the latest or not ?

    EDIT: And what if it is the database ? how can i update my database ? :S
    Doesn't that mean everything custom about my server ( spitfire ) will be gone ?

    Isn't it perfectly safe for your server to update the ascent ?
  2. #2
    Dryice's Avatar Contributor
    Reputation
    86
    Join Date
    Sep 2007
    Posts
    485
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmmmmm. Weird choice of were words go but ill do my best..
    1. Wrong! You database is a bunch of SQL files, to get to them download SQLyog or navicat, open them and double click your connection then scent and on the right side you will see a bunch of files, thats your database

    2. No updating your database will not necessarily delete everything. there are 2 ways to do this
    -The easy way - Will delete all custom Stuff
    -The way where you have to do something - Won't
    The easy way is Download NCDB and run the tool
    Harder way is to get SVN use it to download ascent, compile it and find BRANCHES > 2_4 Stable > SQL > Updates and add all that stuff in updates folder to your database
    Last edited by Dryice; 12-23-2007 at 08:37 AM.

  3. #3
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Wheeze201 View Post
    Well.. when i open up ADE ( Ascent Database Editor ) 1.0.4 it says that i should update my Database Structure manually ( I'm guessing it's the ascent.. but not sure though ).
    Is it totally safe to update to a different ascent rev ?
    Shouldn't i just save my .conf files somewhere else and then restore them when I've updated.

    And how can you know if your ascent rev is not the latest or not ?

    EDIT: And what if it is the database ? how can i update my database ? :S
    Doesn't that mean everything custom about my server ( spitfire ) will be gone ?
    latest DB structures are on ascent SVN;.. for the latest databases you have to go to the NCDB svn

    grtz

  4. #4
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Umm, What do you need to know?
    You should just learn to use Skills in SQL instead of Database editor Tool
    You will be more Experienced

  5. #5
    Wheeze201's Avatar Active Member
    Reputation
    51
    Join Date
    Apr 2007
    Posts
    660
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah i can use both.

    But i like ADE allot.
    And if there was a way to make it bug free, i would be able to fix allot of things in such a little amount of time.

    But if i update my database won't all my custom things be gone ?
    Last edited by Wheeze201; 12-23-2007 at 09:14 AM.

  6. #6
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    They will be but you can just use Navicat to DUMP the tables as a SQL File
    And the Execute it into your new Database

  7. #7
    Dryice's Avatar Contributor
    Reputation
    86
    Join Date
    Sep 2007
    Posts
    485
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    or you can just execute the SQL updates......

  8. #8
    Wheeze201's Avatar Active Member
    Reputation
    51
    Join Date
    Apr 2007
    Posts
    660
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Alright, but where might i get these SQL updates ?

  9. #9
    The Kingofbeast's Avatar Active Member
    Reputation
    38
    Join Date
    Oct 2007
    Posts
    306
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Here I uploaded them for you

    Filebeam - Free Fast File Hosting
    Got a question about your server? Message me!

    Don't forget +Rep when someone helps you

  10. #10
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    problem is when using repacks that repacks dont always have latest DB structure... ADE uses latest DB structures... i never had problems with it and i use NCDB database (one of the latest revs)....

    grtz

  11. #11
    Wheeze201's Avatar Active Member
    Reputation
    51
    Join Date
    Apr 2007
    Posts
    660
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Kindofbeast.. the files you uploaded create tables i already have.
    So i can't use them.

  12. #12
    Wheeze201's Avatar Active Member
    Reputation
    51
    Join Date
    Apr 2007
    Posts
    660
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well some of the sql updates you sent me worked though.
    But most of the errors were duplicate errors like "theres already a table called charters" or "duplicate colum dbinfo1" or something

Similar Threads

  1. Looking for GMs for your server?
    By ShortButStrong in forum World of Warcraft Emulator Servers
    Replies: 347
    Last Post: 07-21-2008, 10:39 AM
  2. How to create custom monsters for your server!
    By renitharis in forum WoW EMU Guides & Tutorials
    Replies: 13
    Last Post: 12-10-2007, 07:53 PM
  3. Custom Trianers For Your Server !!!
    By Chrispee in forum World of Warcraft Emulator Servers
    Replies: 18
    Last Post: 10-25-2007, 04:33 PM
  4. Starting Gear! For your Server!
    By Nextgenerationrepack! in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 10-22-2007, 05:24 AM
  5. Get Custom Npc/Mob for your server
    By Acespades in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 09-23-2007, 02:24 PM
All times are GMT -5. The time now is 07:33 AM. 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