Hello folks. Can someone do for me? I cant figure it out. I have code:
PHP Code:
public SavePlayerSession()
{
new g_maxplayers;
g_maxplayers = get_maxplayers();
new p;
for(p = 1; p <= g_maxplayers; p++)
{
if(is_user_connected(p) && (1 <= get_user_team(p) <= 2))
{
new steam[64];
new szQuery[999];
new map_name[64];
get_mapname(map_name, 63)
get_user_authid(p, steam, 63);
new szDirectory[128];
get_configsdir( szDirectory, charsmax( szDirectory ) )
add( szDirectory, charsmax( szDirectory ), "/id.txt" )
new size = file_size( szDirectory, 1 )
new readMatchID[28], iLen
for ( new i = 0 ; i < size ; i++ )
{
read_file( szDirectory, i, readMatchID, charsmax( readMatchID ), iLen )
}
formatex(szQuery, 998, "INSERT INTO `users_maps` (`steam_id`, `session_id`, `map` ) VALUES ('%s', '%s', '%s' );", steam, readMatchID, map_name);
SQL_ThreadQuery( g_hTuple, "QuerySetData", szQuery);
}
}
return PLUGIN_HANDLED;
}
Can someone make it: If steam_id and readMatchID exsits in the database just update not INSERT into? Thanks!