[Help]Account-System

[MrLoKi]

Hello Guys...

I want to create an account system !

I want this account system , To Support For +200 Player In Server !

Thank you for your help in this regard

 

[The_GTA]

Hello MrLoki,

1) what kind of help do you expect in this regard?
2) do you have any idea how your "account system" should work, look like, etc?
3) are there any examples of account systems you are thinking of?

[MrLoKi]

I want to send the information to the database That the submitted information does not cause the server to log shot !

I designed it this way:

function SetPlayerDb(Player,Data,Value)
            Tables[ID][Data] = Value
            dbExec(getMySQLC(),"UPDATE `UserAccount` SET `"..Data.."` = '"..Value.."' WHERE `User` = '"..tonumber(Tables[ID]["User"]).."'")
            return true
        end
end

Do you have an idea?

[The_GTA]

I see that your MySQL database query building is subject to SQL-injection attacks. You should use the dbPrepareString function to mitigate this issue, like so...

local conn = getMySQLC()
local sqlquery = dbPrepareString(conn,"UPDATE `UserAccount` SET `?` = '?' WHERE `User` = '?'", Data, Value, tonumber(Tables[ID]["User"]))
dbExec(conn, sqlquery)

 

[MrLoKi]

This script , +200 supports the Player ?!

You have a better offer ?

Edited January 24, 2022 by MrLoKi