Go Back   EQEmulator Home > EQEmulator Forums > General > General::Server Discussion

General::Server Discussion Discussion about emulator servers.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2022, 06:01 PM
argybargy
Fire Beetle
 
Join Date: Sep 2022
Posts: 5
Default not working in 2022

Thank you for the update! I am having some issues with the witches and their quests. I noticed that in the quests lines like this one

"NSERT INTO `tasks` VALUES (7003, 2, 0, 0, 'Troublesome Iksar [ Level 6 ]', 'The Iksar usually leave us be, but there is a group in the Field of Bone that are giving us some grief. Go there and slay some Iksar Footpads. They will then begin to fear us. You will get one of the following...<br><br>Kerran Tribal Headband<br>Johanius Stake of Slaying<br>Kejekan Tribal Headband<br>Jedah\'s Brass Choker<br>Luclinite Mallet<br>Kilt of the Northmen<br>Magician Belt<br>Lost Adventurer\'s Trinket<br><br>If you want a different one from the list, then give this back to the Sister who gave it to you and she will give you a different reward.', 'Kerran Tribal Headband', 1063, 538, 12500, 0, 0, 0, 1, 0, '');"

no longer worked as the new db has 5 more columns at the end. I was able to get these working by adding extra zeroes at the end to fields that are not used.

However on the part with statements like this one
"INSERT INTO `task_activities` VALUES (7681, 0, 0, 1, 'Sister Ruskal', 'Algae Covered Flesh', '-1', '0', '', 1736, 0, 1, 800009, '2', 0);"

I noticed we are many columns short of what task_activities has. task_activities now has 28 columns and I am having trouble matching up these fields.

Has anyone gotten this to work with the new DB? If you can you post in your updated SQL?

Thanks in advance for any help!

Last edited by argybargy; 09-20-2022 at 06:01 PM.. Reason: tidy up
Reply With Quote
  #2  
Old 09-20-2022, 07:16 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,332
Default

Quote:
Originally Posted by argybargy View Post
Has anyone gotten this to work with the new DB? If you can you post in your updated SQL?

Thanks in advance for any help!
I found an older, clean database of mine, vs 9178, which seem to take that sql query for the solo server no problem. Then I updated the whole thing to db version 9200.
You DON'T NEED TO source that sql file in from the solo package here, but you will need the rest of the script files.

You can download that database here:

https://tinyurl.com/solo-server9200
Reply With Quote
  #3  
Old 09-20-2022, 08:44 PM
argybargy
Fire Beetle
 
Join Date: Sep 2022
Posts: 5
Default

Thank you so much!

So just to clarify, I do a fresh install with the installer suite on this site and then add your DB?
Reply With Quote
  #4  
Old 10-18-2022, 10:24 PM
/dev/pie
Fire Beetle
 
Join Date: Oct 2022
Location: us
Posts: 11
Default

Quote:
Originally Posted by Huppy View Post
I found an older, clean database of mine, vs 9178, which seem to take that sql query for the solo server no problem. Then I updated the whole thing to db version 9200.
You DON'T NEED TO source that sql file in from the solo package here, but you will need the rest of the script files.

You can download that database here:

https://tinyurl.com/solo-server9200
Hello so im new to this whole server thing. I was browsing the forums when I came upon this thread. The sound of a solo friendly server just seems awesome. However I am unsure about where to start.

Atm I am able to install, setup basic settings and play on my server. But that is the limit of my knowledge. Would you be able to guide me threw that process of getting this to work? If not I fully understand. If you can id be willing to use discord to make it easier.

Thanks
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 09:41 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