Code:
public client_connect(id)
{
firstspawn[id] = true
finishlvl[id] = false
switch(get_pcvar_num(cvar_savetype))
{
case 1:
{
get_user_authid(id, key[id], 63)
}
case 2:
{
get_user_ip(id, key[id], 63)
}
case 3:
{
get_user_name(id, key[id], 63)
}
}
if(sqlv_key_exists_ex(vault, key[id], "level"))
{
playerlvl[id] = sqlv_get_num_ex(vault, key[id], "level")
stars[id] = sqlv_get_num_ex(vault, key[id], "stars")
new completetime = sqlv_get_num_ex(vault, key[id], "finish")
if(completetime > mapstart)
finishlvl[id] = true
}
else
{
playerlvl[id] = 1
stars[id] = 0
new name[64]
get_user_name(id, name, 63)
sqlv_set_data_ex(vault, key[id], "name", name)
sqlv_set_num_ex(vault, key[id], "level", playerlvl[id])
sqlv_set_num_ex(vault, key[id], "stars", stars[id])
sqlv_set_num_ex(vault, key[id], "finish", 0)
}
for(new i = 1; i <= 3; i++)
{
completed[id][i] = 0
completelvl[id][i] = false
}
return PLUGIN_CONTINUE
}