Re: The Infraction System, Probation and Bans - Q&A and Explanation
That's not valid MySQL.
I'm finishing my 3rd year of a Software Engineering degree. The last program i worked on was a fully comprehensive instant messenger with file transfers and profiles, built up on fully encrypted client server communications architecture.
Honestly, if it was as simple as
Quote:
:If Str1=(the F word )
:Then
:"Smeg"->Str1
:End
Then i would have done it by now.
-Dave
Re: The Infraction System, Probation and Bans - Q&A and Explanation
Quote:
Originally Posted by
DaveW
That's not valid MySQL.
I'm finishing my 3rd year of a Software Engineering degree. The last program i worked on was a fully comprehensive instant messenger with file transfers and profiles, built up on fully encrypted client server communications architecture.
Honestly, if it was as simple as
Then i would have done it by now.
-Dave
I know, but any language has to have an "if" statement.
Re: The Infraction System, Probation and Bans - Q&A and Explanation
Quote:
I know, but any language has to have an "if" statement.
SQL: Structured Query Language.
You have 3 basic commands:
SELECT [fields you want to select]
FROM [table to select from]
WHERE [conditions]
So say you wanted to know the ages of all the dogs called charlie. You would say...
SELECT Name, Age
FROM Dog
WHERE Name='Charlie'
This would return a result with this data. If you wanted to do something like what you're doing, then you would use a modified version using the update statement. But SQL queries are cumbersome and difficult to structure when you start using things like UPDATE, DISTINCT, UNION, etc.
The alternative option is to create a PHP script which runs through the database looking for substrings with the fword. The database is nearly 100Megs of Text, so you can imagine the server load involved in that; PHP is notoriously inefficient at things like this. Of course, in practical terms, the script would probably complete in about 5 minutes or so, but the chance of me getting the correct SQL statement first time is fairly slim: about 80% i'd say. It's really not worth the effort.
VBulletin handles this by changing it when you try to submit. Single operation. So if turn it on, we should be fairly safe. But the VBulletin documentation is quite frankly awful concerning this and i'm not 100% certain about the implications of turning it on.
I'm still considering it though. :)
-Dave
Re: The Infraction System, Probation and Bans - Q&A and Explanation
Hey, you still haven't changed the color/font scheme on the rules yet.
Let's get crackin'! Chop chop! Mach Schnell (sp?)! Tally ho! Oh crap, I have to get to work! *Runs out of room and forgets to change into his uniform, and then realizes that he needs it right as he's going out the door, runs back in, changes, and somehow makes it to work with time to eat something before starting his shift*
Re: The Infraction System, Probation and Bans - Q&A and Explanation
Ach! Gimme a break!
Airbozo, AJ, can one of you guys take care of this one for me? :p
-Dave
Re: The Infraction System, Probation and Bans - Q&A and Explanation
I'm just messing with ya. :p If anybody needs a break at the moment it's me... damned people eating buffet for an extra half hour after it's supposed to close, I feel like somebody parked a car on me for the past four and a half hours...