stock SavePlayerPos(playerid)
{
GetPlayerPos(playerid
, spawn_info
[playerid
][x
], spawn_info
[playerid
][y
], spawn_info
[playerid
][z
]); new query[MAX_PLAYER_NAME + 50];
format(query
, sizeof(query
), "SELECT id FROM positions WHERE name='%s'", account
[playerid
][name
]); new rows, Cache:result = mysql_query(connection_handle, query, true);
cache_get_row_count(rows);
if(rows)
{
new row_id;
cache_get_value_name_int(0, "id", row_id);
new query_string[200];
format(query_string
, sizeof(query_string
), "UPDATE positions SET x=%f,y=%f,z=%f,angle=%f,interior=%d,vw=%d WHERE id=%d",\
spawn_info[playerid][x],
spawn_info[playerid][y],
spawn_info[playerid][z],
spawn_info[playerid][angle],
spawn_info[playerid][interior],
spawn_info[playerid][vw],
row_id);
mysql_tquery(connection_handle, query_string, "", "");
cache_delete(result);
}
else
{
new query_string[175 + MAX_PLAYER_NAME];
format(query_string
, sizeof(query_string
), "INSERT INTO positions(name,x,y,z,angle,interior,vw)VALUES('%s',%f,%f,%f,%f,%d,%d)",\
account[playerid][name],
spawn_info[playerid][x],
spawn_info[playerid][y],
spawn_info[playerid][z],
spawn_info[playerid][angle],
spawn_info[playerid][interior],
spawn_info[playerid][vw]);
mysql_tquery(connection_handle, query_string, "", "");
}
}