[KoreanPeople]

this code l4d2 dedicated server

// Player Save
public Action playerSaveDataLevelUp (int client) {
	int steamid = GetSteamAccountID(client);
	
	new String:g_checkuser[128];
	Format(g_checkuser, sizeof(g_checkuser), "SELECT * FROM cooperativeplayers WHERE steamid='%d'", steamid);
	DBResultSet g_queryHandle = SQL_Query(db, g_checkuser);
	
	if(g_queryHandle != INVALID_HANDLE) {
		if(g_queryHandle.FetchRow()) {
			new String:query2[128];
			Format(query2, sizeof(query2), "UPDATE cooperativeplayers SET lv='%d', exp='%d', statuspoint='%d', skillpoint='%d', lvupexp='%d' WHERE steamid='%d'", g_playerInfo[client][playerLv], g_playerInfo[client][playerExp], g_playerInfo[client][playerStatusPoint], g_playerInfo[client][playerSkillPoint], g_playerInfo[client][playerLvUpExp], steamid);
			g_queryHandle = SQL_Query(db, query2);
			
			if(g_queryHandle != INVALID_HANDLE) {
				PrintToServer("[COOP] User data update and save successful");
			} else {
				SQL_GetError(db, Error, sizeof(Error));
				PrintToChat(client, "[COOP] User data update and save failed : %s", Error);
			}
		} else {
			SQL_GetError(db, Error, sizeof(Error));
			PrintToChat(client, "\x05[COOP] \x01Server have not user data. can't load data.");
		}
	}
	return Plugin_Handled;
} 

// Player Load
public Action PlayerLoadData(int client) {
	new String:name[30];
	GetClientName(client, name, 30);
	int steamid = GetSteamAccountID(client);
	
	new String:query[255];
	Format(query, sizeof(query), "SELECT * FROM cooperativeplayers WHERE steamid='%d'", steamid);
	
	DBResultSet g_queryHandle = SQL_Query(db, query);
	if(g_queryHandle != INVALID_HANDLE) {
		if(g_queryHandle.FetchRow()) {
			PrintToChat(client, "\x05[COOP] \x01User data load successful!");
			g_playerInfo[client][playerLv] = g_queryHandle.FetchInt(2);
			g_playerInfo[client][playerExp] = g_queryHandle.FetchInt(3);
			g_playerInfo[client][playerGold] = g_queryHandle.FetchInt(4);
			g_playerInfo[client][playerStatusPoint] = g_queryHandle.FetchInt(5);
			g_playerInfo[client][playerSkillPoint] = g_queryHandle.FetchInt(6);
			g_playerInfo[client][stat_muscleEndurance] = g_queryHandle.FetchInt(7);
			g_playerInfo[client][stat_agility] = g_queryHandle.FetchInt(8);
			g_playerInfo[client][stat_concentration] = g_queryHandle.FetchInt(9);
			g_playerInfo[client][stat_health] = g_queryHandle.FetchInt(10);
			g_playerInfo[client][stat_observant] = g_queryHandle.FetchInt(11);
			g_playerInfo[client][playerLvUpExp] = g_queryHandle.FetchInt(12);
			g_playerInfo[client][playerStamina] = g_queryHandle.FetchFloat(13);
		}
		else {
		PrintToChat(client, "\x05[COOP] \x01Server have not user data. can't load data");
		InitPlayerData(client);
		new String:query1[512];
		Format(query1, sizeof(query1), "INSERT INTO cooperativeplayers (name, steamid, lv, exp, gold, statuspoint, skillpoint, stat_muscle, stat_agility, stat_concentration, stat_health, stat_observant, lvupexp, playerstamina) VALUES ('%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%f')", 
		name, steamid, g_playerInfo[client][playerLv], g_playerInfo[client][playerExp], g_playerInfo[client][playerGold], g_playerInfo[client][playerStatusPoint], g_playerInfo[client][playerSkillPoint], g_playerInfo[client][stat_muscleEndurance], g_playerInfo[client][stat_agility], g_playerInfo[client][stat_concentration], g_playerInfo[client][stat_health], g_playerInfo[client][stat_observant], g_playerInfo[client][playerLvUpExp], g_playerInfo[client][playerStamina]);
		
		g_queryHandle = SQL_Query(db, query1);
		if(g_queryHandle != INVALID_HANDLE) {
			PrintToChat(client, "\x05[COOP] \x01User first data save successful!");
		} else {
			SQL_GetError(db, Error, sizeof(Error));
			PrintToChat(client, "\x05[COOP] \x01User data save failed. There was a problem with DB");
			PrintToChat(client, "\x05[COOP] \x01DB Error : %s", Error);
			}
		}
	}
	return Plugin_Handled;
}

insert my data and another user data.
succesfully. yeah

but, steamid mysteamid save and 0 save ?? what is the 0..
and 0 steamid data = mysteamid data connected.
perhaps client index error ?

[CrazyHackGUT]

0 - user not authenticated.
Use IsClientAuthorized() native and OnClientAuthorized() forward for this checks.