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 11-02-2019, 11:07 PM
rabbet330
Sarnak
 
Join Date: May 2019
Posts: 31
Default Shutting off Halloween theme

How do we disable the Halloween theme that now comes with the PEQ?
Reply With Quote
  #2  
Old 11-02-2019, 11:18 PM
Dhaymion
Fire Beetle
 
Join Date: Apr 2018
Location: NC
Posts: 13
Default

Use the link below and run the halloween off Sql.

https://github.com/ProjectEQ/project...alloween_event
Reply With Quote
  #3  
Old 11-03-2019, 04:01 PM
rabbet330
Sarnak
 
Join Date: May 2019
Posts: 31
Default

Thanks. Heads up for anyone using Heidi - it's a bit of a pain to get it working. You'll have to remove the ` character in every REPLACE INTO step, until just before the word VALUES.
Reply With Quote
  #4  
Old 11-03-2019, 07:28 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Not sure what kind of problem you're having .. backticks (`) are part of the query language.

I use them extensively in all of my posted queries: http://www.eqemulator.org/forums/showthread.php?t=42678


Without digging into the issue and testing it, you may be running into problems with non-escaped backticks in the query data itself (i.e., ...)
Code:
('202006', 'Seer_Mal_Nae`Shi', ...
If that is the case, you may want to verify that data hasn't become corrupted.


EDIT: I use HeidiSQL to build and run all of my queries.
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #5  
Old 11-04-2019, 03:49 AM
rabbet330
Sarnak
 
Join Date: May 2019
Posts: 31
Default

Yeah I'm not quite sure what happened. I just know that when I ran the query as-is, it failed on the very first line. At first I replaced ALL the backticks with single quotes, which did cause massive non-escaped character issues, as well as non-matches since some NPC character names actually do have backticks rather than quotes.

For whatever reason, removing the backticks from only the UPDATE lines worked. I don't know if it's because I have an outdated version of Heidi or what. I will say that I am generally used to not using backticks for the table and field names, except when something could be misinterpreted as an SQL keyword ("range" comes to mind).

Upshot: if it works for others out of the box, awesome. I just had to goose it a little on my side.
Reply With Quote
  #6  
Old 11-04-2019, 07:54 AM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

Open up the sql file, (in an editor), put your cursor just before VALUES, do a carriage return, then save file.
__________________
Hanging out at Antonica.World
Reply With Quote
  #7  
Old 11-04-2019, 01:50 PM
rabbet330
Sarnak
 
Join Date: May 2019
Posts: 31
Default

That must have been it. I actually did the carriage returns to the left of VALUES first, because it would have been hard to replace the backticks in the UPDATE lines otherwise. Looks like no replacing was necessary. Thanks for pointing that out.
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:49 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