Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2013, 08:41 AM
Irreverent
The Solo Server
 
Join Date: May 2007
Posts: 416
Default lootdrop_entries => Disabled Chance? & zone => Type?

I just did a refresh to the DB and code and noticed that there was no .sql in the code nor DB sql folders that specified this change.

If you don't do a drop/define here is the fix:
Code:
ALTER TABLE `lootdrop_entries` ADD  `disabled_chance` FLOAT UNSIGNED NOT NULL DEFAULT  '0';
fix to zone table:
Code:
ALTER TABLE `zone` ADD COLUMN `type`  tinyint(3) NOT NULL DEFAULT 0 AFTER `suspendbuffs`;
I know there is quite a few moves to tools going on, but these two seemed to either missed or changed where they report the required DB updates (either in code /utils/sql or db /updates)

Was this an oops or should I start looking at other folders?
__________________
OP of Irreverent Server (The Solo Server)
Our Forums
Reply With Quote
  #2  
Old 02-17-2013, 09:58 AM
Irreverent
The Solo Server
 
Join Date: May 2007
Posts: 416
Default

FIX FIX! Couldn't edit message above, do not use it!

Use below:

Code:
ALTER TABLE `lootdrop_entries` ADD  `disabled_chance` FLOAT UNSIGNED NOT NULL DEFAULT  '0' after `chance`;
__________________
OP of Irreverent Server (The Solo Server)
Our Forums
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 07: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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3