Диалог:
case DLG_LOG: { if(!response) { SCM(playerid, COLOR_LIGHTRED, "Используйте /q чтобы покинуть сервер"); return Kick(playerid); } if(!strlen(inputtext)) { ShowLogin(playerid); return SCM(playerid, COLOR_RED, "[Ошибка] {FFFFFF}Введите пароль в поле ниже!"); } mysql_format(dbHandle, query, sizeof(query), "SELECT * FROM `users` WHERE `name` = '%s' AND `password` = '%s'", pInfo[playerid][NAME], inputtext); mysql_tquery(dbHandle, query, "UploadPlayerAcc", "i", playerid); }
UploadPlayerAcc:
public UploadPlayerAcc(playerid) { new rows; cache_get_row_count(rows); if(rows) { cache_get_value_name_int(0, "id", pInfo[playerid][ID]); cache_get_value_name_int(0, "race", pInfo[playerid][RACE]); cache_get_value_name_int(0, "gender", pInfo[playerid][GENDER]); cache_get_value_name_int(0, "age", pInfo[playerid][AGE]); cache_get_value_name_int(0, "skin", pInfo[playerid][SKIN]); cache_get_value_name_int(0, "admin", pInfo[playerid][ADMIN]); cache_get_value_name_int(0, "money", pInfo[playerid][MONEY]); cache_get_value_name_int(0, "level", pInfo[playerid][LEVEL]); SpawnPlayer(playerid); } else { SCM(playerid, COLOR_RED, "[Ошибка] {FFFFFF}Введён неверный пароль!"); return ShowLogin(playerid); } return 1; }