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!" |
I just noticed that the updates/Rev535.sql file on the projecteqdb SVN still has the unescaped single quotes problem.
|
It's been corrected.
|
Quick work, cavedude!
|
I don't mean to be the grammar nazi here but I had to edit out so many of these it's unreal...
Just as an FYI: When you are trying to concatenate 2 words together you use an apostrophe. For example: It's = It Is (it combines 2 words into one) When you are trying to make a word plural (more than one) you use it without. For example: zone = zones (more than one) It is not: zone's (that would equal zone is) such as is done in so many places in the database descriptions. Sorry it just kinda grates on my grammar nerves. |
I wonder if that's (that is) anything like necro'mancer?
|
It took you 3.5 years to come up with that?
|
Irony, you be a cruel bitch... never change!
Quote:
Quote:
|
Quote:
you be == you're Yes, I get your point. In fact, what makes it hysterical goes along with what lerxst2112 already pointed out. You both are responsible for the coffee projecting from my nose. |
We shouldn't be using apostrophes in descriptions anyway, unless they are terminated properly. I can't count the number of times a rogue apostrophe, comma, or exclamation point has messed up a query I ran. In cavedude's perfect world all strings would be lowercase using only periods. :)
|
Quote:
2.) What does a question end with?(oh shit a preposition) You lose. |
Quote:
|
All times are GMT -4. The time now is 02:17 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.