[xRENN1Ex]

Player info is registering MYSQL to update, but does not update. Can you help me?

(ip, name, authid, hp, alive or dead

new Handle:Query = SQL_PrepareQuery(SqlConnection, "INSERT INTO `playerlogger` (`ip`, `name`, `authid`, `hp`, `df_canli`) VALUES  ('%s','%s','%s','%i','%i') ON DUPLICATE KEY UPDATE `ip`=VALUES(`ip`), `name`=VALUES(`name`), `authid`=VALUES(`authid`), `hp`=VALUES(`hp`), `df_canli`=VALUES(`df_canli`);", szIP, szName, szAuthid, iL_HP, df_canli);

[Natsheh]

Do debugging and see where your code fails.

[^SmileY]

This query is totally wrong. Why you supposed to updated inserted record?

[xRENN1Ex]

Can you do the right thing?
Because players want to reflect the view. You can look here as an example

https://www.csduragi.com/monitor/cs8.csduragi.net

[Natsheh]

Use replace instead .

[xRENN1Ex]

Originally Posted by Natsheh Use replace instead .

can you give me information about how to use it?

[Bugsy]

You need to include a primary key in the statement otherwise it will work the same as insert. If any fields in the record have a value then you must include them in the statement, even if they are not being changed, otherwise they will be set to null. In the below example my primary key in the table is ID, set to auto-increment to make inserting new records easy.

Suppose I have the below record:

ID = 223
SteamID = STEAM_0:1:12345
PlayerName= bugsy
PlayTime= 555

I can then do the below to update PlayTime to 123. Fields SteamID & PlayerName will remain unchanged since I am including the existing values in the statement.

REPLACE INTO tblPlayerData (ID, SteamID, PlayerName, PlayTime) VALUES (223,'STEAM_0:0:12345','bugsy',123);

If I also have a column XPPoints in the table, it would be set to null with the above REPLACE INTO statement, unless I specify a value.

Assume these fields exist in a row:

ID = 223
SteamID = STEAM_0:1:12345
PlayerName= bugsy
PlayTime= 555
XPPoints = 555

REPLACE INTO tblPlayerData (ID, SteamID, PlayerName, PlayTime, XPPoints) VALUES (223,'STEAM_0:0:12345','bugsy',123,555);

This will retain XPPoints value of 555 (and leave SteamID & PlayerName as is), while changing PlayTime to 123.

When adding a new record, just exclude the ID field and it will add a new record, advancing ID to the next slot automatically.

REPLACE INTO tblPlayerData (SteamID, PlayerName) VALUES ('STEAM_0:0:555','bugsy2');

[xRENN1Ex]

Originally Posted by Bugsy You need to include a primary key in the statement otherwise it will work the same as insert. If any fields in the record have a value then you must include them in the statement, even if they are not being changed, otherwise they will be set to null. In the below example my primary key in the table is ID, set to auto-increment to make inserting new records easy. Suppose I have the below record: ID = 223 SteamID = STEAM_0:1:12345 PlayerName= bugsy PlayTime= 555 I can then do the below to update PlayTime to 123. Fields SteamID & PlayerName will remain unchanged since I am including the existing values in the statement. REPLACE INTO tblPlayerData (ID, SteamID, PlayerName, PlayTime) VALUES (223,'STEAM_0:0:12345','bugsy',123); If I also have a column XPPoints in the table, it would be set to null with the above REPLACE INTO statement, unless I specify a value. Assume these fields exist in a row: ID = 223 SteamID = STEAM_0:1:12345 PlayerName= bugsy PlayTime= 555 XPPoints = 555 REPLACE INTO tblPlayerData (ID, SteamID, PlayerName, PlayTime, XPPoints) VALUES (223,'STEAM_0:0:12345','bugsy',123,555); This will retain XPPoints value of 555 (and leave SteamID & PlayerName as is), while changing PlayTime to 123. When adding a new record, just exclude the ID field and it will add a new record, advancing ID to the next slot automatically. REPLACE INTO tblPlayerData (SteamID, PlayerName) VALUES ('STEAM_0:0:555','bugsy2');

thank you for the answer

so can you ask me to do this sma coding

I don't have many resources because I am Turkish so I will be forced

I need help because it has a different structure than php

[xRENN1Ex]

public RegisterUser(id){
    new szIP[32],szName[32],szAuthid[32],h_Healts,a_Alive;
    get_user_ip(id,szIP,charsmax(szIP), 1)
    get_user_name(id,szName,charsmax(szName))
    get_user_authid(id,szAuthid,charsmax(szAuthid))
    h_Healts = get_user_health(id)
    a_Alive = is_user_alive(id)
    
    new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511)
    if(SqlConnection == Empty_Handle)
        set_fail_state(g_Error)

  	new Handle:Query = SQL_PrepareQuery(SqlConnection, "INSERT INTO `playerlogger` (`ip`, `name`, `authid`, `h_Healts`, `a_Alive`) VALUES  ('%s','%s','%s','%i','%i') ON DUPLICATE KEY UPDATE `playerlogger` SET `h_Healts` = REPLACE(`h_Healts`, `h_Healts`, `99`);", szIP, szName, szAuthid, h_Healts, a_Alive);
    

    if(!SQL_Execute(Query)){
        SQL_QueryError(Query,g_Error,511)
        set_fail_state(g_Error)
    }
    
    SQL_FreeHandle(Query)
    SQL_FreeHandle(SqlConnection)
}

is this code block correct?