Updat Query Login

[xLosT]

Updat Query Login Erro

function onLogin(cid)
db.executeQuery("UPDATE `players` SET `status` = '1' WHERE `id` = " .. getPlayerAccountId(cid) .. ";")
	return 1

end

 

[WarOfTheTitans]

function onLogin(cid) 
db.query("UPDATE `players` SET `status` = '1' WHERE `id` = " .. getPlayerAccountId(cid) .. ";") 
    return 1 

end

try this

 

[xLosT]

not work

the bug is here
getPlayerAccountId

ele nao deve pegar a account id, e sim pega o nome do character!
alguem sabe arrumar?

 

[Zisly]

Should be
WHERE `account_id` = " .. getPlayerAccountId(cid) .. ";")
If you're gonna use accountId.

 

[xLosT]

is 7.6
id in 7,6 is account
i need here
if i login
execute in mysql
UPDATE `mydb`.`players` SET `status` = '1' WHERE `players`.`id` =1254;

 

[xLosT]

bump

 

[Deleted member 148307]

function onLogin(cid) 
db.executeQuery("UPDATE `YOUR_DATABASE_NAME_HERE`.`players` SET `status` = '1' WHERE `id` = " .. getPlayerAccountId(cid) .. ";") 
    return 1 

end

Try this

 

[Korrex]

function onLogin(cid) 
db.executeQuery("UPDATE `YOUR_DATABASE_NAME_HERE`.`players` SET `status` = '1' WHERE `id` = " .. getPlayerAccountId(cid) .. ";") 
    return 1 

end

Try this

Don't full CAPS please. xD
Also, return true looks more legit than return 1

 

[Deleted member 148307]

i've used caps-rage cuz Poland draw with Greece, we had TO WIN!!
grr