Go Back   EQEmulator Home > EQEmulator Forums > Support > Spell Support

Spell Support Broken Spells? Want them Fixed? Request it here.

Reply
 
Thread Tools Display Modes
  #16  
Old 07-15-2009, 09:38 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

If it ran for that long, there should have been some progress indicated. On my laptop it loads 500 spells in 3 seconds. I cannot comment adversely otherwise without more details

Please backup your table first, before running this

Also, in addition, how do you all create the table? -- it should have 215 fields for SOF

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//

Last edited by GeorgeS; 07-16-2009 at 05:46 AM..
Reply With Quote
  #17  
Old 07-15-2009, 10:14 PM
Krugus
Sarnak
 
Join Date: Dec 2005
Location: the Void
Posts: 40
Default ...

the .sql for the spell table file is located in the eqemu/utils/sql/svn/ then look for the file 230_spells_table.sql that will be the sql needed to create the table for SoF.

Its listed in the change log as well as the directions on how to import spells via the perl script
Reply With Quote
  #18  
Old 07-15-2009, 10:49 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

For those who use Ti, the program supports Ti spells.
Select the option for Ti when exporting, or if you select SOF when using a Ti spell set, it will export to SOF compatibility


GeorgeS


-- the above SQL is what I used. I hope everyone uses the same file
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #19  
Old 07-15-2009, 11:10 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

GeorgeS,

There isn't a need for Titanium exporting, only for Titanium importing. The spell files are backwards compatible, meaning that a Titanium client can use a SoF client spell file perfectly fine. The only problem is that it is not forward compatible, so an SoF client cannot use a Titanium client spell file. For any server wanting to share a customized spell file or a single spell file to use for both clients, they should only be sharing the SoF version, since it will work with both types. IMO, there isn't any need to export into Titanium format. The only possible use of it would be to slightly reduce the file size. The only other difference between the clients as far as the spell files go is that Titanium can only load spell IDs up to 9999, where SoF has a much higher limit (currently I am not aware of what the max is, but it should be at least 20K+).
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #20  
Old 07-15-2009, 11:37 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

Ti export is for just re-creating the Ti spell file. You have the choice of exporting it to a SOF compat. format. I'll leave that end to the user to determine, but in any event, it should cover all bases.

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #21  
Old 07-16-2009, 12:07 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Yeah, no harm in leaving the option. Just wanted to give a heads-up mostly.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #22  
Old 07-17-2009, 12:40 AM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

Nice! I am looking forward to trying this out as soon as I done with Rev updates
Reply With Quote
  #23  
Old 07-30-2009, 09:04 PM
rizzen
Fire Beetle
 
Join Date: Jun 2009
Location: Michigan
Posts: 17
Default

I also tried to run the application, it ran my processor at 100% until I killed it.
Reply With Quote
  #24  
Old 07-31-2009, 10:13 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

Yes, the importation of that much data takes 100% of your CPU. Let it run till it's done.

It takes up to 5 min on my pc

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #25  
Old 08-21-2009, 01:30 AM
Yeormom
Discordant
 
Join Date: Apr 2004
Location: 127.0.0.1
Posts: 402
Default

Grabbed the new version from your site tonight and it ran very well for exporting. The only note if no importance I can make is you can't export without at least having a blank spells_us.txt file. However, with one, all Titanium spells dumped, across the Internet, in less than 5 seconds, including extra latency from my port remapper since the MySQL port isn't configurable through your front-ends.

Saved me a few hours work so thanks George!
__________________
Yeorwned
Bane of Life [Custom Classic/PvP]
Reply With Quote
  #26  
Old 08-22-2009, 12:51 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

Glad you like the tool!

Saves me quite some time as well when I make custom spells.

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #27  
Old 11-08-2009, 09:32 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

Do you still have to use the import_spells.pl to get new spells on your server? I noticed I'm already having trouble with it again and I want to know if you can still just use a spells_us for spells on your server.
Reply With Quote
  #28  
Old 11-08-2009, 09:50 PM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

Quote:
Originally Posted by Randymarsh9 View Post
Do you still have to use the import_spells.pl to get new spells on your server? I noticed I'm already having trouble with it again and I want to know if you can still just use a spells_us for spells on your server.
in spdat.h Find this (around line 42)
Code:
//#define NEW_LoadSPDat
#define DB_LoadSPDat    //load from DB vs spells_us.txt. for now, we're piggybacking NEW_LoadSPDat, so it will take precedence
change it to this
Code:
#define NEW_LoadSPDat
//#define DB_LoadSPDat  //load from DB vs spells_us.txt. for now, we're piggybacking NEW_LoadSPDat, so it will take precedence
Then it will use the spell file like it used to...
Reply With Quote
  #29  
Old 11-08-2009, 10:38 PM
Randymarsh9
Dragon
 
Join Date: Dec 2007
Posts: 658
Default

Awesome, changed that, compiled. and now my toon has his 75 spells. Thanks again, lol
Reply With Quote
  #30  
Old 11-09-2009, 12:44 AM
ChaosSlayerZ's Avatar
ChaosSlayerZ
Demi-God
 
Join Date: Mar 2009
Location: Umm
Posts: 1,492
Default

i really wish they would have made that part into a rule, rather than define option...
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 04:47 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3