Shutting off Halloween theme

[rabbet330]

How do we disable the Halloween theme that now comes with the PEQ?

[Dhaymion]

Use the link below and run the halloween off Sql.

https://github.com/ProjectEQ/projecteqquests/tree/master/halloween_event

[rabbet330]

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.

[Uleat]

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., ...)
('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.

[rabbet330]

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.

[Huppy]

Open up the sql file, (in an editor), put your cursor just before VALUES, do a carriage return, then save file. ;)

[rabbet330]

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.