whats wrong with this line...

notexistant · **Posted:** Sat Dec 27, 2008 9:19 am

Code:

    DB_RS.Open "SELECT char FROM banned WHERE `char`='" & Char & "'", DB_Conn, adOpenStatic, adLockOptimistic

Server crashes on that line... tells me to "use proper sql synax where select char from banned where char = you".

notexistant · **Posted:** Sat Dec 27, 2008 10:08 am

Ok... its not just that line it's every line that has anything to do with the database.

Spodi · **Posted:** Sat Dec 27, 2008 12:00 pm

Nothing syntactically wrong with that, though you might want to make it a habit of always escaping your fields to avoid keyword/reserved word conflict:

Code:

SELECT `char` FROM `banned` WHERE `char`='value'

notexistant · **Posted:** Sat Dec 27, 2008 1:20 pm

fixed:

thanks to darkfrost for pointing out 2 errors

had an extra quote and well the other one i have no clue what did replaced char with a *.

notexistant · **Posted:** Sat Dec 27, 2008 3:47 pm

Code:

    'Check if the character exists
    DB_RS.Open "SELECT users FROM users WHERE 'name'='" & Char & "'", DB_Conn, adOpenStatic, adLockOptimistic
    If DB_RS.EOF Then
        'does not exist
        Data_Send ToIndex, UserIndex, cMessage(98).Data
        DB_RS.Close
        Exit Sub
    End If

how about this one i fail at mysql queries i seem to not understand them fully... this one works but it always says the character doesn't exist even when they do...

Sephiroth187 · **Posted:** Sat Dec 27, 2008 7:09 pm

Is users a field in the table users?

anyhow it should be
DB_RS.Open "SELECT `users` FROM `users` WHERE 'name'='" & Char & "'", DB_Conn, adOpenStatic, adLockOptimistic

It may also be a good idea to include the database name

DB_RS.Open "SELECT `users` FROM `databasenamehere`.`users` WHERE 'name'='" & Char & "'", DB_Conn, adOpenStatic, adLockOptimistic

You can't just define it to select a table from a table, you have to choose the fields.

notexistant · **Posted:** Sat Dec 27, 2008 7:18 pm

Yeah already found that but still doesn't work...

Code:

    'Check if the character exists
    DB_RS.Open "SELECT `name` FROM `users` WHERE 'name'='" & Char & "'", DB_Conn, adOpenStatic, adLockOptimistic
    If DB_RS.EOF Then
        'does not exist
        Data_Send ToIndex, UserIndex, cMessage(98).Data
        DB_RS.Close
        Exit Sub
    End If

Sephiroth187 · **Posted:** Sat Dec 27, 2008 9:03 pm

Its because you have

DB_RS.Open "SELECT `name` FROM `users` WHERE 'name'='" & Char & "'", DB_Conn, adOpenStatic, adLockOptimistic

It shoudl be

DB_RS.Open "SELECT `name` FROM `users` WHERE `name`='" & Char & "'", DB_Conn, adOpenStatic, adLockOptimistic

*i've bolded the changes
Think of it something like this

things encased in ` ` are you objects, things encased in ' ' are your values.

notexistant · **Posted:** Sat Dec 27, 2008 9:31 pm

OMFG its fixed thank you seph

vbGore Free Online RPG Engine

whats wrong with this line...