Windows_8
Умник
Добрый день.
В общем, при регистрации сохраняется только Логин и Пароль, остальные переменные не сохраняются.
В общем, при регистрации сохраняется только Логин и Пароль, остальные переменные не сохраняются.
PHP:
stock SaveAccount(playerid)
{
new query[256];
format(query, sizeof query, "UPDATE `users` SET \
`age` = '%d', `admins` = '%d', `donatem` = '%d', `muted` = '%d', `warn` = '%d', `jail` = '%d', `jailtime` = '%d', `skin` = '%d' \
WHERE `id` = '%d' LIMIT 1",
Player[playerid][age],
Player[playerid][id],
Player[playerid][admins],
Player[playerid][donatem],
Player[playerid][muted],
Player[playerid][warn],
Player[playerid][jail],
Player[playerid][jailtime],
Player[playerid][skin]);
mysql_function_query(connect, query, false, "", "");
return 1;
}
PHP:
public PlayerLogin(playerid)
{
new rows, fields, temp[128];
cache_get_data(rows, fields);
if(rows)
{
cache_get_field_content(0, "id", temp), Player[playerid][id] = strval(temp);
cache_get_field_content(0, "age", temp),Player[playerid][age] = strval(temp);
cache_get_field_content(0, "admins", temp),Player[playerid][admins] = strval(temp);
cache_get_field_content(0, "donatem", temp),Player[playerid][donatem] = strval(temp);
cache_get_field_content(0, "muted", temp),Player[playerid][muted] = strval(temp);
cache_get_field_content(0, "warn", temp),Player[playerid][warn] = strval(temp);
cache_get_field_content(0, "jail", temp),Player[playerid][jail] = strval(temp);
cache_get_field_content(0, "jailtime", temp),Player[playerid][jailtime] = strval(temp);
cache_get_field_content(0, "skin", temp),Player[playerid][skin] = strval(temp);
SetSpawnInfo(playerid, 255, Player[playerid][skin], 0, 0, 0, 1.0, -1, -1, -1, -1, -1, -1);
SetPVarInt(playerid, "Logged", 1) ;
DeletePVar(playerid, "WrongPassword");
if(Player[playerid][age] != 0)
{
SpawnPlayer(playerid);
format(temp, sizeof(temp), "~w~Welcome ~n~~g~ %s", PlayerName[playerid]);
GameTextForPlayer(playerid, temp, 5000, 1);
}
else ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Возраст","Введите ваш игровой возраст\n","Готово","Назад");
}
else
{
if(GetPVarInt(playerid, "WrongPassword" ) == 4)
{
GKick(playerid);
return 1;
}
SetPVarInt(playerid, "WrongPassword", GetPVarInt(playerid, "WrongPassword") + 1);
ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Авторизация", "Добро пожаловать на сервер Industrial-Game.\nВведите ваш пароль", "Вход", "");
}
return 1;
}
PHP:
public CheckPlayerRegistered(playerid)
{
new rows, fields;
cache_get_data(rows, fields);
if(rows)
{
ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Авторизация", "Добро пожаловать на сервер Industrial-Game.\nВведите ваш пароль", "Вход", "");
}
else
{
ShowPlayerDialog( playerid, 0, DIALOG_STYLE_PASSWORD, "Регистрация", "Добро пожаловать на сервер Industrial-Game.\nПридумайте пароль для аккаунта", "Ввод", "");
}
return 1;
}
PHP:
case 0:
{
new query[144], temp[32];
mysql_real_escape_string(inputtext, temp);
format(query, sizeof query, "INSERT INTO `users` ( `login`, `password`, `age`, `skin` ) VALUES ( '%s', '%s', '%s', '%s' )", PlayerName[playerid], temp, Player[playerid][age], Player[playerid][skin]);
mysql_function_query(connect, query, false, "", "");
format(query, sizeof query, "SELECT * FROM `users` WHERE `login` = '%s' AND `password` = '%s' LIMIT 1", PlayerName[playerid], temp);
mysql_function_query(connect, query, true, "PlayerLogin", "i", playerid);
}
case 1:
{
new query[144], temp [32];
mysql_real_escape_string(inputtext, temp);
format(query, sizeof query, "SELECT * FROM `users` WHERE `login` = '%s' AND `password` = '%s' LIMIT 1", PlayerName[playerid], temp);
mysql_function_query(connect, query, true, "PlayerLogin", "i", playerid);
}
