Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Development

Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum)

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2006, 10:43 PM
Coleshadowblades
Fire Beetle
 
Join Date: Jun 2006
Posts: 23
Default

Excuse me but I unlike MOST am sharing what I have learned with the devs if you paid attention to the changelog the upgrade to enable mysql 5 support IS done by one of the devs they however compile for MYSQL4 which means the default binaries DONT work with mysql 5. now let me put it to you in laymans terms mysql five executes queries far faster then 4 4 is about 2 years or so out of date. zones boot far faster and the emu loads astoundingly fast now. I am not splintering anything. Merely providing WORKING binaries for people who WANT to upgrade to mysql 5 because the devs wont/havent provide/ed them. So kindly refrain from throwing accusations at someone trying to actually be HELPFULL to the community unless you can substantially backup your accusations with something more then conjecture.

now I will be updating that download however it requires 3 changes to the database...

you need to :

Code:
As shown in latest build changelog
ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT
NULL DEFAULT '0'; 

needed edits found durring testing
ALTER TABLE accounts CHANGE `packencrypt` `packencrypt` BLOB NULL;
ALTER TABLE character_ CHANGE `extprofile` `extprofile` BLOB NULL;
(Which you should do ANYWAY when the field isnt being given a value anyway just as a coding standard)

~~~PLEASE NOTE!!!~~~ SPECIAL THANKS TO SESMAR For helping me get the binaries compiled!

I will also be putting the updated source files (Since the devs have yet to take unused file references out of the solution file) so people new to the emu and dont know that the files arent even used but present in the project can compile easily

Last edited by Coleshadowblades; 06-17-2006 at 07:36 AM..
Reply With Quote
  #2  
Old 06-16-2006, 10:57 PM
Coleshadowblades
Fire Beetle
 
Join Date: Jun 2006
Posts: 23
Default

Ok so 801 doesnt exactally work on windows so Sesmar and I (Mostly sesmar) Applied the mysql patch provided by Aza and did some tweaking of our own (Sesmar mostly) And came up with a MYSql 5.xx version of the binaries for windows users please note in order for new account and character correctiosn the mysql database edits outlined above must be implemented in order to work...

Here is the binaries

http://acashyasrealm.no-ip.org:90/EQ...800-mysql5.zip

there may be bugs we are still working on this but so far it seems stable and VERY VERY Fast when used with mysql 5.22

THANKS Sesmar for the assistance in the c++

EDIT: Also please backup your database/databases with mysql admin or some other tool before isntalling mysql 5 then import/restore the backup

Last edited by Coleshadowblades; 06-17-2006 at 07:11 AM..
Reply With Quote
Reply

Thread Tools
Display Modes

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 03:06 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