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

Development::Feature Requests Post suggestions/feature requests here.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2009, 10:49 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Yeah, I am just trying to figure out the way to make it easiest to edit directly in the table. Otherwise, without a tool to do the work or an in game command to do the work, it might be hard to set properly. It woudn't be too hard to do 0 to 255 for each color to get the mix you want. Unless someone changes the #npcedit command to take the 3 values and combine them into the single field. I will try to see if I can get it at least basically working and if anyone wants to help make it better, feel free. Though, before putting it on the SVN with SQL changes and all, it would be nice to have the DB changes finalized. Maybe I can look at how the items table handles tint.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #2  
Old 05-12-2009, 09:31 PM
KingMort
Banned
 
Join Date: Sep 2006
Posts: 841
Default

My items table is from 2003 so yeah lol :(

I wonder if there is a safe way for me to update it ?

King
Reply With Quote
  #3  
Old 05-12-2009, 09:56 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

I recently updated my own database to be current with PEQ. I have a ton of custom items, so I just sourced in the PEQ items table on top of my existing one. That just fills in the ones that are missing and gives a warning about ones that already exist. It wouldn't correct any you already have in your database, but it would give you access to a TON more items from Live.

All I did was source the PEQ DB into it's own database, then dump just the items table. Then, open that .sql file and remove the top part that deletes and recreates the table. You don't want it to rebuild the table or you lose the custom stuff. Last, just source in that newly edited .sql file and you will be current up to Live, or at least very close. Every item I checked from Live is in the current PEQ DB, so it seems to be pretty complete.

IMPORTANT NOTE FOR WINDOWS USERS:
When you source in the items table from PEQ on top of your items table, it will beep 1 time for EVERY line in there!!! This is extremely annoying and would make sourcing the whole thing take hours. Since it beeps out of your PC speaker, you can't adjust it. BUT, I quickly found (with the help of google) that you can go into your device manager and click "view" at the top and select "show hidden devices". This will make a new field visible called "System Devices". Scroll down until you see "System speaker" and double click it. Then, on the general tab, simply use the drop down box at the bottom named "Device Usage" and change it from "Use this device (enable)" to "Do not use this device (disable)". Then click OK and close out of device manager. This will shut your PC speaker off for good! And, not only that, but since it no longer has to beep for every error while sourcing, it finishes the whole thing in a few seconds instead of hours!!! So, if you use windows, this is some extremely important stuff to know. I run my server on Linux, but I manage it from Windows, which is why I had to figure this out.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #4  
Old 05-12-2009, 10:15 PM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

You can also start the mysql prompt with -b to disable the beep =p

ex:
c:\>mysql -b -u user -p
Reply With Quote
  #5  
Old 05-12-2009, 10:24 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Nice one KLS lol I am still glad to know you can disable the system speaker from within windows though :P
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
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 09:45 AM.


 

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