Check if table exsits.

erickvan · **Author**

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!

**Bugsy** · 05-29-2021 , 23:12 Re: Check if table exsits.

In your CREATE TABLE script, use the below to define steam_id:

Code:

steam_id varchar(34) UNIQUE

and then to INSERT or UPDATE, use REPLACE INTO. This will create new if not exists or over-write the data for a given steam id if it exists.

Code:

REPLACE INTO users_maps (steam_id, session_id, map) VALUES ('%s', '%s', '%s' );", steam, readMatchID, map_name);

erickvan · 05-30-2021 , 13:03 Re: Check if table exsits.

Quote:

Originally Posted by Bugsy

In your CREATE TABLE script, use the below to define steam_id:

Code:

steam_id varchar(34) UNIQUE

and then to INSERT or UPDATE, use REPLACE INTO. This will create new if not exists or over-write the data for a given steam id if it exists.

Code:

REPLACE INTO users_maps (steam_id, session_id, map) VALUES ('%s', '%s', '%s' );", steam, readMatchID, map_name);

Thanks i will try!

erickvan · 05-31-2021 , 02:23 Re: Check if table exsits.

Quote:

Originally Posted by Bugsy

In your CREATE TABLE script, use the below to define steam_id:

Code:

steam_id varchar(34) UNIQUE

and then to INSERT or UPDATE, use REPLACE INTO. This will create new if not exists or over-write the data for a given steam id if it exists.

Code:

REPLACE INTO users_maps (steam_id, session_id, map) VALUES ('%s', '%s', '%s' );", steam, readMatchID, map_name);

Ok i need another idea. Why? Becouse its deleting all data. I need just update if exsits or if not exsits create new. Any ideas?

**Bugsy** · *Last edited by Bugsy; 05-31-2021 at 11:00.*

If you did what I told you to do correctly it would do exactly what you want.

Something like this:

Code:

CREATE TABLE IF NOT EXISTS users_maps (ID INTEGER PRIMARY KEY AUTOINCREMENT, steam_id VARCHAR(34) UNIQUE, session_id VARCHAR(12), map VARCHAR(32));

Then

Code:

REPLACE INTO users_maps (steam_id, session_id, map) VALUES ('%s', '%s', '%s' );", steam, readMatchID, map_name);

Calling this would insert a new record for STEAM_0:0:12345
REPLACE INTO users_maps (steam_id, session_id, map) VALUES ('STEAM_0:0:12345', 'testID1', 'map1" );

Calling this would over-write STEAM_0:0:12345's existing record with testID2 and map2 (technically delete the old and insert new)
REPLACE INTO users_maps (steam_id, session_id, map) VALUES ('STEAM_0:0:12345', 'testID2', 'map2" );