Page 5 of 5 FirstFirst 12345
Results 41 to 46 of 46

Thread: The Infraction System, Probation and Bans - Q&A and Explanation

  1. #41
    Paradox Sausage DaveW's Avatar
    Join Date
    Nov 2005
    Location
    Scotland, UK (NOT England)
    Posts
    5,550

    Default 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
    :If Str1=(the F word )
    :Then
    :"Smeg"->Str1
    :End
    Then i would have done it by now.

    -Dave
    Quote Originally Posted by jdbnsn
    Ideas are just knowledge soaked in alcohol.
    Quote Originally Posted by jdbnsn
    Did I just get in a Volvo? Volvo's don't have guns!

  2. #42
    ...What? progbuddy's Avatar
    Join Date
    Aug 2006
    Location
    Matthews, NC
    Posts
    1,672

    Default Re: The Infraction System, Probation and Bans - Q&A and Explanation

    Quote Originally Posted by DaveW View Post
    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.
    Coffee is love, coffee is life.

  3. #43
    Paradox Sausage DaveW's Avatar
    Join Date
    Nov 2005
    Location
    Scotland, UK (NOT England)
    Posts
    5,550

    Default Re: The Infraction System, Probation and Bans - Q&A and Explanation

    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
    Quote Originally Posted by jdbnsn
    Ideas are just knowledge soaked in alcohol.
    Quote Originally Posted by jdbnsn
    Did I just get in a Volvo? Volvo's don't have guns!

  4. #44
    read my comic already! (sig) xRyokenx's Avatar
    Join Date
    Dec 2006
    Location
    Bloomingburg, NY
    Posts
    4,416

    Default 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*

  5. #45
    Paradox Sausage DaveW's Avatar
    Join Date
    Nov 2005
    Location
    Scotland, UK (NOT England)
    Posts
    5,550

    Default 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
    Quote Originally Posted by jdbnsn
    Ideas are just knowledge soaked in alcohol.
    Quote Originally Posted by jdbnsn
    Did I just get in a Volvo? Volvo's don't have guns!

  6. #46
    read my comic already! (sig) xRyokenx's Avatar
    Join Date
    Dec 2006
    Location
    Bloomingburg, NY
    Posts
    4,416

    Default 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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •