View Full Version : Update on 0.3.0. PLEASE READ
Shawn319
04-04-2002, 03:25 AM
This weekend (if everything goes on schedule) 0.3.0 will get released. This release will have new DB table structures and will **REQUIRE** you to drop the database and create a new one.
Along with the release, all Loginserver account will be cleared. You will need to register a new one at that time and a link will be given on day of release.
What do you do when 0.3.0 gets release? You would open mySQL.exe, type "drop database eq; " without the quotes and hit enter. then type "create database eq; " without the quotes and hit enter. Then copy the 0.3.0 db.sql to your mysql/bin folder and then type "source db.sql" without the quotes, and hit enter..
As always, read README.TXT for further setup instrctions if you are doing a new setup.
-- Added By Hogie --
We will be testing a new Loadsharing/redundant login server soon(tm) before the release, so please bear with us so we can get this all worked out and have everything going smooth again.
-- End of Add --
--Shawn319 and Dev team
theCoder
04-04-2002, 07:17 AM
Excellent!
As a side note, for those of you running mysql on Linux, here's a script I've written that uses the information in your db.ini file to create and populate the database. It's meant to be run on the mysql server machine. It assumes the following things are already set up:
* db.ini is correct (correct username, password, database name) and the database name in db.ini isn't already in the database
* The data to populate the database is located in .sql files in a data subdirectory and they have no errors (like duplicate keys)
Anyway, here's the script:
$ cat makedb
#!/bin/bash
DBNAME=`cat db.ini | grep database | awk -F= '{print $2}'`
DBUSER=`cat db.ini | grep user | awk -F= '{print $2}'`
DBPASS=`cat db.ini | grep password | awk -F= '{print $2}'`
# first create the DB
echo "Creating database $DBNAME... enter mysql root password if prompted"
echo \
"create database $DBNAME;
grant all on $DBNAME.* TO $DBUSER IDENTIFIED BY '$DBPASS';" | mysql -uroot -p
# now populate it
echo "Populating database $DBNAME..."
cat data/*.sql | mysql -u$DBUSER -p$DBPASS $DBNAME
Ariak
04-04-2002, 02:09 PM
Old Databases won't be obsolete, will they?
DeletedUser
04-04-2002, 02:14 PM
Yea :P
Ariak
04-04-2002, 02:25 PM
If you're serious, this will be my last week using the emulator.
I have fun with spawns. I like to go into a zone and kill stuff. Using #spawn to make a mob is tedious and cumbersome; rebuilding a HUGE DB would be a monumental task that I don't want to do.
mByte
04-04-2002, 02:44 PM
If you're serious, this will be my last week using the emulator.
I have fun with spawns. I like to go into a zone and kill stuff. Using #spawn to make a mob is tedious and cumbersome; rebuilding a HUGE DB would be a monumental task that I don't want to do.
I doubt you data will be obsolete - just import the usable data and fill in the blanks. It not hard to recreate certain things such as items and spawns. Just make sure to create a file you can import from
mysqldump -h localhost eq > eq.sql
This will create a file in your mysql\bin directory for you to use to save your information before you drop the database. Once you have the new table struct in the database import it back accordingly
Note you may have to tweak how the data goes back but I know its possable its a database.
or just dont upgrade :p
/shrug
mByte
04-04-2002, 02:45 PM
I hope you added forage and archery! :P
Merkur
04-04-2002, 04:15 PM
You can import old data. I think Ly wrote a programm/script for it, look at the devforum. BTW On Spuds Server (eros) runs a (nearly) actual version with all spawns up.
DeletedUser
04-05-2002, 03:55 AM
We added fields to make the emu better. If you feel that we can't do this, why should we continue working on the project? I understand that you might be upset that "all your hard work" is for nothing, but if you have read the other posts in the forums about the upgrade, you would know it is basically the same format with more fields added (like faces, npc abilities, etc). If you do a simple find/replace on your dumped databases (to add the column names to the insert) you can reimport your database (I did...).
If you dont want us to do anymore coding. Im sure most of us have better things to do with our time....
Drawde
04-05-2002, 04:53 AM
What tables will be modified, other than npc_types and characters? Any modifications to the loot table, merchants or factions?
NPC/spawn table modifications will be no problem for me to fix since I'll just need to rewrite my parser. However the above ones I created by hand so will take some time to modify if the tables have been changed.
Sh4d0w
04-05-2002, 09:52 AM
I can see why ariak got upset, i would be too if i thought that all the stuff i had done to my database would have to poof when i upgraded. He just didn't realize that there are ways to keep it. I don't change my db all that much so its no biggie for me. Im really excited for the new release and hope to see some good changes in it. Sounds like its going to be cool from what i hear. Keep up the good work guys!! :D
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.