Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2006, 08:48 PM
mwmdragon's Avatar
mwmdragon
Discordant
 
Join Date: Apr 2003
Location: Winnipeg, Manitoba Canada
Posts: 270
Default Updating a 6.0dr2 to 6.2dr1 database

Has someone made an SQL file to Update a 6.0dr2 database to a 6.2dr1 database ?

I don't want to lose all my changes, and have not added any new items.

Hell... even better if someone has an update from a 6.0dr2 database to a 6.3dr1 would be great.

Thanks in advance
__________________
Thanks
MWMDRAGON

NeverQuest
http://neverquest.gotdns.com
Emucade
http://dragonsden.emuunlim.com
Reply With Quote
  #2  
Old 01-26-2006, 01:11 AM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default

Quote:
Originally Posted by mwmdragon
Has someone made an SQL file to Update a 6.0dr2 database to a 6.2dr1 database ?

I don't want to lose all my changes, and have not added any new items.

Hell... even better if someone has an update from a 6.0dr2 database to a 6.3dr1 would be great.

Thanks in advance
I tried to update several times...
All I managed to do was get a headache... and trashed databases....
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote
  #3  
Old 01-26-2006, 01:14 AM
kouhei
Hill Giant
 
Join Date: Mar 2005
Location: japan
Posts: 171
Default db

It is hard you have to go back and find all the changes they did in upgradeing the DB then would have to apply all of them.
__________________
http://www.hdrjapan.com/



Take a look you know you want to click on this site.
Reply With Quote
  #4  
Old 01-26-2006, 01:26 AM
Belfedia
Demi-God
 
Join Date: Jan 2005
Posts: 1,109
Default

You can read the Changelog.txt (from archive not the shot version),
You have all Sql modifications in but it was hard !
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
Reply With Quote
  #5  
Old 01-26-2006, 02:11 AM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default

Quote:
Originally Posted by Belfedia
You can read the Changelog.txt (from archive not the shot version),
You have all Sql modifications in but it was hard !
thats all good but i still have a few compile errors to figgure out...

inking...
mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol __ftol2
mysqlclient.lib(password.obj) : error LNK2001: unresolved external symbol __ftol2
mysqlclient.lib(ctype-simple.obj) : error LNK2001: unresolved external symbol __aulldvrm
mysqlclient.lib(ctype-ucs2.obj) : error LNK2001: unresolved external symbol __aulldvrm
../build/ZonePerl.exe : fatal error LNK1120: 2 unresolved externals
Error executing link.exe.
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote
  #6  
Old 01-26-2006, 03:29 AM
Ibix
Sarnak
 
Join Date: Jan 2006
Posts: 40
Default

I'm guessing you're building using Microsoft VC++?

Make sure you're following the directions at: http://www.eqemulator.net/wiki/wikka...a=DevVSExpress

Most notably, the little tidbit I added that links to:

http://msdn.microsoft.com/vstudio/ex...k/default.aspx

What has happened is you did not edit your .vsprops file to add some of the dependencies and as such the external resolution of those calls is failing.

Best of luck.
Reply With Quote
  #7  
Old 02-01-2006, 01:18 PM
mwmdragon's Avatar
mwmdragon
Discordant
 
Join Date: Apr 2003
Location: Winnipeg, Manitoba Canada
Posts: 270
Default wow, talk about a thread derailing lol

wow, talk about a thread derailing lol.


so does anyone have this kind of SQL. I don't need to know how hard it is even though i know you are trying to help. I have tried converting a few times by hashing together database edits/updates i have found everywhere but i can't seem to get the database converted correctly.

I have made a ton of changes and fixes to the PEQ Velious rc1 and do not want to loose em all.

Calling all you SQL gurus out there please help
__________________
Thanks
MWMDRAGON

NeverQuest
http://neverquest.gotdns.com
Emucade
http://dragonsden.emuunlim.com
Reply With Quote
  #8  
Old 02-01-2006, 03:13 PM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default Adding a command

Quote:
Originally Posted by mwmdragon
wow, talk about a thread derailing lol.


so does anyone have this kind of SQL. I don't need to know how hard it is even though i know you are trying to help. I have tried converting a few times by hashing together database edits/updates i have found everywhere but i can't seem to get the database converted correctly.

I have made a ton of changes and fixes to the PEQ Velious rc1 and do not want to loose em all.

Calling all you SQL gurus out there please help
wtf are you talking about this is about the c++6.0 compiles.
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote
  #9  
Old 02-03-2006, 10:43 AM
bushman77
Hill Giant
 
Join Date: May 2003
Location: In the bush
Posts: 129
Default the db

i thought he was talking about the db which was originally for the 60dr2 binaries, and he just wants this db (for which he has custom things on) to be compatible with the newer binaries. I dont think he wants to modify the binaries but only wants the db to be changed with sql script to be compatible with the binaniries
Reply With Quote
  #10  
Old 02-02-2006, 01:24 AM
Ibix
Sarnak
 
Join Date: Jan 2006
Posts: 40
Default

Quote:
Originally Posted by sdabbs65
wtf are you talking about this is about the c++6.0 compiles.
Actually....

Quote:
Originally Posted by mwmdragon
Has someone made an SQL file to Update a 6.0dr2 database to a 6.2dr1 database ?

I don't want to lose all my changes, and have not added any new items.

Hell... even better if someone has an update from a 6.0dr2 database to a 6.3dr1 would be great.

Thanks in advance
That was the original post in the thread, hence his refering to it as a thread derailment. Not that I don't think the thread has been useful to anyone, the thread just didn't really start out as a thread about compiling with c++6.0.
Reply With Quote
  #11  
Old 02-02-2006, 06:01 AM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default

Quote:
Originally Posted by Ibix
Actually....



That was the original post in the thread, hence his refering to it as a thread derailment. Not that I don't think the thread has been useful to anyone, the thread just didn't really start out as a thread about compiling with c++6.0.
Your right LOL I didnt bother to read that far ahead in the thread before posting hahhaha
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:21 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3