[Zh3r0]

I couldn't find a proper tutorial or a filterscript that might help me out. Can i please, see a code, that saves 2 things with a value?
Also reading. I would appreciate this a lot!

[Calgon]

Код:

UPDATE <tableName> SET <fieldName> = '', <fieldName2> = '' WHERE <matchingCriteria> = ''

Example in use:

Код:

UPDATE playerAccounts SET playerName = 'Calg00ne', playerAdminLevel = 2 WHERE playerID = 6

Integers do not need to be wrapped in single quotes, format your query to set the values as necessary, then simply send it out with mysql_query (you *probably* won't need to thread this query).

[Zh3r0]

Quote:

Originally Posted by Calg00ne Код: UPDATE <tableName> SET <fieldName> = '', <fieldName2> = '' WHERE <matchingCriteria> = '' Example in use: Код: UPDATE playerAccounts SET playerName = 'Calg00ne', playerAdminLevel = 2 WHERE playerID = 6 Integers do not need to be wrapped in single quotes, format your query to set the values as necessary, then simply send it out with mysql_query (you *probably* won't need to thread this query).

So this sets admin level 2 on user with id 6 ?

I actually wanted a complete filterscript on how to do it, with everything, db_open, db_query and all these.
New to SQL so this is why ...

[Calgon]

Search, there's thousands of tutorials on the internet and there's thousands of tutorials explaining usage of the MySQL/SQLite functions.

[Finn]

Quote:

Originally Posted by Zh3r0 So this sets admin level 2 on user with id 6 ? I actually wanted a complete filterscript on how to do it, with everything, db_open, db_query and all these. New to SQL so this is why ...

SA-MP wiki to the rescue:

db_open
db_query
db_close

[Zh3r0]

Quote:

Originally Posted by Calg00ne Search, there's thousands of tutorials on the internet and there's thousands of tutorials explaining usage of the MySQL/SQLite functions.

Oh, so i can find stuff even on ****** about SQL? Okay then, thanks, i will see what i can learn from there.

[Finn]

Quote:

Originally Posted by Zh3r0 Oh, so i can find stuff even on ****** about SQL? Okay then, thanks, i will see what i can learn from there.

http://www.sqlite.org/
http://www.sqlite.org/lang.html

[Calgon]

....facepalm

[Zh3r0]

Quote:

Originally Posted by Calg00ne ....facepalm

Yeah, your sarcasm is always impressive. I never dealt with any databases, so please don't act like a smartass.
Thanks for the help....