executeMySQL

[Lloyd Logan]

Hey,

I have been struggling for ages, and i can't quite get this to work

So I am looking to update the players rank when he logs in (dont ask why), the rank in located in Localhost db = newser

structure(<--- I think thats what its called) = account, then it is under the players name then admin, here is what i have so far?

newserv = dbConnect( "mysql", "dbname=newserv;host=127.0.0.1", "root", "" ) 
  
function makeadminn (thePlayer) 
        executeSQLQuery("UPDATE `account` SET `**dont know what to put here`=?, WHERE `admin`=2", thePlayer) 
end 
addCommandHandler("makemeadmin", makeadminn) 

[Castillo]

executeSQLQuery is for SQLite only, you must use dbExec instead.

[Lloyd Logan]

executeSQLQuery is for SQLite only, you must use dbExec instead.

Ahh, so what would i do?

dbExec( connection, "UPDATE ?? SET ??=?", tableName, columnName, columnValue  

I don't understand what to replace with what?

[Castillo]

dbExec ( connection, "UPDATE `accounts` SET `admin` = '2' WHERE `accountName` = 'Lloyd Logan" ) 

[Lloyd Logan]

dbExec ( connection, "UPDATE `accounts` SET `admin` = '2' WHERE `accountName` = 'Lloyd Logan" ) 

Thank you so much!!! Where you have put "Lloyd Logan" how would I replace that with whoever has logged in?

Like getPlayerName? Then how would I implement this into the script?

Thanks Again

Lloyd

[Castillo]

dbExec ( connection, "UPDATE `accounts` SET `admin` = '2' WHERE `accountName` = ".. name .."" ) 

[Lloyd Logan]

dbExec ( connection, "UPDATE `accounts` SET `admin` = '2' WHERE `accountName` = ".. name .."" ) 

That simple? name = getPlayerName then the dnExec?

[Castillo]

Yes, that's right.

[Lloyd Logan]

Yes, that's right.

Thanks again Castillo!

[Castillo]

You're welcome.