FYI: Issue with 524_rules_values_notes.sql
Just letting people know about this issue with this SVN file. Apostrophes are used to denote certain values which is fine if apostrophes weren't also used through out the file to show ownership (like Wizard's, Warrior's, etc) or conjunctions (and, weren't, aren't, you're) and it's going to cause SQL Syntax errors.
Code:
UPDATE `rule_values` SET notes = 'ms time until a player corpse is moved to a zone's graveyard:if one is specified for the zone' WHERE rule_name = 'Zone: GraveyardTimeMS'; |
Wasn't there supposed to be a "/" in front of apostrophes?
Quote:
|
Damn no edit button. :mad:
It's supposed to be: Quote:
|
Yeah, I fixed all mine already but just wanted to let people know about this.
|
Ah, I see. :)
I would use it, only there hasn't been any newer binaries posted since Rev497. :( For those that can't compile the sources like me, we're pretty much stuck with what ever version is posted. Can someone upload the newest binaries? I mean, come on. It's almost 40 revs behind. If there were nightly compiles available, that would be most awesome. Please? |
At least you can update binaries. Whenever I do it everyone loses their gear =P
|
Yeah, Shendare had already messaged me about this:
Quote:
|
Quote:
Quote:
So how about some updated binaries? LOL. :-D |
If you want, I can compile the latest revision and post the binaries.
|
Can I have your babies if you do?
|
|
Thanks for the updated binaries! :-D
Oh, and here's the updated rules_values_notes.sql file. There were some 's that were missed, so I'm not sure if Shendare caught all of them. :smile: Code:
ALTER TABLE `rule_values` ADD `notes` text NOT NULL AFTER `rule_value`; |
I got the file updated with all of the fixes. Thanks for the help guys. There were still a few missing from everyone's fixes, so I just went through them 1 by 1 lol. Finally got through it beep-free, so it looks good.
|
D'oh. As soon as you sad that and I went through it, I saw an error. :D
|
If we could only limit the source command to filter out success messages for huge sets like that. LOL.
"I don't need the 483 OK messages, I need the 14 error messages!" |
All times are GMT -4. The time now is 11:46 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.