07.04.2013, 12:58
Лог mysql:
Авторизация:
Код выбора скина:
PHP код:
[14:58:43] >> mysql_query( Connection handle: 1 )
[14:58:43] CMySQLHandler::Query(SELECT unbandate FROM bans WHERE name = 'asdasdasas') - Successfully executed.
[14:58:43] >> mysql_store_result( Connection handle: 1 )
[14:58:43] CMySQLHandler::StoreResult() - Result was stored.
[14:58:43] >> mysql_num_rows( Connection handle: 1 )
[14:58:43] CMySQLHandler::NumRows() - Returned 0 row(s)
[14:58:43] >> mysql_fetch_row_format( Connection handle: 1 )
[14:58:43] >> mysql_query( Connection handle: 1 )
[14:58:43] CMySQLHandler::Query(SELECT unbandate FROM bans WHERE ip = '213.88.102.254') - Successfully executed.
[14:58:43] >> mysql_store_result( Connection handle: 1 )
[14:58:43] CMySQLHandler::StoreResult() - Result was stored.
[14:58:43] >> mysql_num_rows( Connection handle: 1 )
[14:58:43] CMySQLHandler::NumRows() - Returned 0 row(s)
[14:58:43] >> mysql_free_result( Connection handle: 1 )
[14:58:43] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:58:49] >> mysql_query( Connection handle: 1 )
[14:58:49] CMySQLHandler::Query(SELECT * FROM accounts WHERE name = 'asdasdasas') - Successfully executed.
[14:58:49] >> mysql_store_result( Connection handle: 1 )
[14:58:49] CMySQLHandler::StoreResult() - Result was stored.
[14:58:49] >> mysql_fetch_row_format( Connection handle: 1 )
[14:58:49] CMySQLHandler::FetchRow() - Return: 46|asdasdasas|123123|213.88.102.254|0|qwerty|123@123.com|3|1000000|0|0|05.04.2013|0|0|0|0|1|79|0|0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0|5000|0|0|0|1|0, 0, 0|0, 0, 0|0|0|0|0|None|None|70.0|0|0|0|0|0|None|123|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|100|0|100|0|0|0|0|0|0|0|0|1|0|100|0|462|4|200|0|0|1|0|0,0,0,0,0,0,0,0,0,0,0,0,0,0|3|0|0|0|0|0|
[14:58:49] >> mysql_free_result( Connection handle: 1 )
[14:58:49] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:58:51] >> mysql_query( Connection handle: 1 )
[14:58:51] CMySQLHandler::Query(SELECT password FROM accounts WHERE name = 'asdasdasas' LIMIT 1) - Successfully executed.
[14:58:51] >> mysql_store_result( Connection handle: 1 )
[14:58:51] CMySQLHandler::StoreResult() - Result was stored.
[14:58:51] >> mysql_fetch_row_format( Connection handle: 1 )
[14:58:51] CMySQLHandler::FetchRow() - Return: 123123
[14:58:51] >> mysql_free_result( Connection handle: 1 )
[14:58:51] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:58:51] >> mysql_query( Connection handle: 1 )
[14:58:51] CMySQLHandler::Query(SELECT ipcheck FROM accounts WHERE name = 'asdasdasas' LIMIT 1) - Successfully executed.
[14:58:51] >> mysql_store_result( Connection handle: 1 )
[14:58:51] CMySQLHandler::StoreResult() - Result was stored.
[14:58:51] >> mysql_fetch_row_format( Connection handle: 1 )
[14:58:51] CMySQLHandler::FetchRow() - Return: 0
[14:58:51] >> mysql_free_result( Connection handle: 1 )
[14:58:51] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:58:51] >> mysql_query( Connection handle: 1 )
[14:58:51] CMySQLHandler::Query(SELECT * FROM accounts WHERE name = 'asdasdasas' LIMIT 1) - Successfully executed.
[14:58:51] >> mysql_store_result( Connection handle: 1 )
[14:58:51] CMySQLHandler::StoreResult() - Result was stored.
[14:58:51] >> mysql_fetch_row_format( Connection handle: 1 )
[14:58:51] CMySQLHandler::FetchRow() - Return: 46|asdasdasas|123123|213.88.102.254|0|qwerty|123@123.com|3|1000000|0|0|05.04.2013|0|0|0|0|1|79|0|0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0|0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0|5000|0|0|0|1|0, 0, 0|0, 0, 0|0|0|0|0|None|None|70.0|0|0|0|0|0|None|123|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|100|0|100|0|0|0|0|0|0|0|0|1|0|100|0|462|4|200|0|0|1|0|0,0,0,0,0,0,0,0,0,0,0,0,0,0|3|0|0|0|0|0|
[14:58:51] >> mysql_free_result( Connection handle: 1 )
[14:58:51] CMySQLHandler::FreeResult() - Result was successfully free'd.
PHP код:
case D_LOGIN:
{
for(new i = strlen(inputtext); i != 0; --i)
switch(inputtext[i])
{
case 'А'..'Я', 'а'..'я', ' ':
return ShowPlayerDialog(playerid,D_ERRORPAS,DIALOG_STYLE_MSGBOX,"Ошибка!","{00FF21}Введенный вами пароль содержит русские буквы.\nСмените раскладку клавиатуры!","Повторить","");
}
if(response)
{
if(!strlen(inputtext))
{
format(string, 412, "{FF9900}~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\tДобро пожаловать на сервер {FF9900}HARD-RP{FFFFFF}\n\nАккаунт с именем: {FF9900}%s{FFFFFF} зарегестрирован\nПожалуйста пройдите авторизацию\nНаш сайт: {FF9900}HARD-RP.RU\n\n{FFFFFF}Введите пароль:\n{FF9900}~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~",PlayerInfo[playerid][pSendername]);
ShowPlayerDialog(playerid, D_LOGIN, 3, "{FFFFFF}Авторизация", string, "Готово","Отмена");
}
else if(!strcmp(inputtext, GetAccount(PlayerInfo[playerid][pSendername], "password"), true))
{
new ipcheckon = strval(GetAccount(PlayerInfo[playerid][pSendername], "ipcheck"));
new pip[32];
GetPlayerIp(playerid,pip,sizeof(pip));
if(ipcheckon == 1 && !strcmp(pip, GetAccount(PlayerInfo[playerid][pSendername], "ippassword"), true))
{
format(string, 256, " ==== Ваш IP адрес сменился ====\n=== Введите Ваш ключ безопасности ===",PlayerInfo[playerid][pSendername]);
ShowPlayerDialog(playerid, 12341, 3, "Введите ключ безопастности", string, "Принять","Отмена");
}
else
{
LoadAccount(playerid);
}
return 1;
}
else
{
new logtires = 3 - PlayerLogTries[playerid];
PlayerLogTries[playerid]++;
if(PlayerLogTries[playerid] == 4) { SendClientMessage(playerid,COLOR_LIGHTRED, "Вы были кикнуты по подозрению в взломе {ffffff}/q(uit)"); Kick(playerid); }
format(string,128,"{FF6347}Вы ввели неверный пароль уже {FFFFFF}%d/3 раз\n{FF6347}На 3 раз вы будете отключены от сервера",logtires);
ShowPlayerDialog(playerid, D_ERRORPAS,DIALOG_STYLE_MSGBOX,"Ошибка!",string,"Повтор","Выйти");
}
}
else { SendClientMessage(playerid, COLOR_LIGHTRED, ""PlayerNeedToLoggedForToPlay""); Kick(playerid); }
}
PHP код:
case D_SEX:
{
new sex[20];
switch(response)
{
case 1: { sex = "Мужской"; PlayerInfo[playerid][pSex] = 1; }
default: { sex = "Женский" ; PlayerInfo[playerid][pSex] = 2; }
}
ClothesRound[playerid] = 1;
PlayerLogged[playerid] = true;
SetHealth(playerid, 70);
SetSpawnInfo(playerid, 255, PlayerInfo[playerid][pModel], 0, 0, 0, 1.0, -1, -1, -1, -1, -1, -1);
SpawnPlayer(playerid);
//CreateAccount(playerid, PlayerInfo[playerid][pPassword]);
}