View Single Post
Author Message
xRENN1Ex
Junior Member
Join Date: Dec 2019
Old 12-28-2019 , 03:17   SQL Insert and Update Player Info
Reply With Quote #1

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

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

Code:
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);
Attached Files
File Type: sma Get Plugin or Get Source (playerInfoSaveDB.sma - 159 views - 2.1 KB)

Last edited by xRENN1Ex; 12-28-2019 at 03:17.
xRENN1Ex is offline