07.07.2012, 16:48
Код:
#include <a_samp>
#include <a_mysql>
#include <sscanf2>
#include <streamer>
#include <zcmd>
#include <mxdate>
#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASS "12345"
#define SQL_DB "accounts"
#define DIALOG_LOGIN 1
#define DIALOG_REGISTER 2
#define DIALOG_WRONGPAS 3
#define COLOR_GREEN 0x33AA33AA
#define COLOR_RED 0xAA3333AA
enum pInfo
{
pID,
pName[MAX_PLAYER_NAME],
pPassword[15],
bool: pLogged,
pWrongPassword,
};
new PlayerInfo[MAX_PLAYERS][pInfo];
AntiDeAMX()
{
new a[][] =
{
"Unarmed (Fist)",
"Brass K"
};
#pragma unused a
}
main()
{
print("\n----------------------------------");
print(" 12345");
print("----------------------------------\n");
}
stock CheckMySQLConnection()
{
if(mysql_ping() == -1) mysql_reconnect();
return 1;
}
stock ConnectMySQL()
{
mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
switch(mysql_ping())
{
case 1: print("MySQL connection: Yes");
case -1: print("MySQL connection: No");
}
return 1;
}
stock DisconnectMySQL()
{
mysql_close();
print("MySQL connection closed.");
}
stock CreateAccount(playerid, password[])
{
new
query[128],
sqlname[MAX_PLAYER_NAME],
sqlpassword[15];
mysql_real_escape_string(PlayerInfo[playerid][pName], sqlname);
mysql_real_escape_string(password, sqlpassword);
format(query, sizeof(query), "INSERT INTO `accounts` (`name`, `password`) VALUE ('%s', '%s')", sqlname, sqlpassword);
mysql_query(query);
PlayerInfo[playerid][pID] = mysql_insert_id();
strmid(PlayerInfo[playerid][pPassword], password, 0, 15, 255);
PlayerInfo[playerid][pLogged] = true;
return 1;
}
stock LoadAccount(playerid, password[])
{
new
query[128],
sqlpass[32],
result[5+24+64],
dialog[128];
mysql_real_escape_string(password, sqlpass);
format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `password` = '%s' AND `id` = '%i'", sqlpass, PlayerInfo[playerid][pID]);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1)
{
mysql_fetch_row_format(result, "|");
sscanf(result, "p<|>is[24]s[32]",
PlayerInfo[playerid][pID],
PlayerInfo[playerid][pName],
PlayerInfo[playerid][pPassword],
PlayerInfo[playerid][pLogged] = true );
mysql_free_result();
}
else
{
if(PlayerInfo[playerid][pWrongPassword] == 4)
{
SendClientMessage(playerid, COLOR_RED, "Вы 3 раза ввели неверный пароль и были отключены от сервера.");
Kick(playerid);
return 1;
}
PlayerInfo[playerid][pWrongPassword] ++;
format(dialog, sizeof(dialog),
"Вы ввели неверный пароль.\n\
У Вас осталось %i/3 попыток ввода.", 3 - PlayerInfo[playerid][pWrongPassword]);
ShowPlayerDialog(playerid, DIALOG_WRONGPAS, DIALOG_STYLE_MSGBOX, "Ошибка.", dialog, "Повтор", "Отмена");
}
return 1;
}
stock GetAccountID(playerid)
{
new
query[128];
format(query, sizeof(query),"SELECT `ID` FROM `accounts` WHERE `name` = '%s'", PlayerInfo[playerid][pName]);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1)
{
PlayerInfo[playerid][pID] = mysql_fetch_int();
mysql_free_result();
return PlayerInfo[playerid][pID];
}
return 0;
}
stock SaveAccount(playerid)
{
if(PlayerInfo[playerid][pLogged] == true)
{
CheckMySQLConnection();
new
query[186],
sqlname[MAX_PLAYER_NAME],
sqlpass[64];
mysql_real_escape_string(PlayerInfo[playerid][pName], sqlname);
mysql_real_escape_string(PlayerInfo[playerid][pPassword], sqlpass);
format(query, sizeof(query), "UPDATE `accounts` SET `name` = '%s', `password` = '%s' WHERE `id` = '%i'", sqlname, sqlpass, PlayerInfo[playerid][pID]);
mysql_query(query);
}
return 1;
}
stock RemovePlayerInfo(playerid)
{
PlayerInfo[playerid][pWrongPassword] = 0;
PlayerInfo[playerid][pID] = 0;
PlayerInfo[playerid][pLogged] = false;
return 1;
}
public OnGameModeInit()
{
AntiDeAMX();
SetGameModeText("Role Play");
return 1;
}
public OnGameModeExit()
{
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
return 1;
}
public OnPlayerConnect(playerid)
{
GetPlayerName(playerid, PlayerInfo[playerid][pName], MAX_PLAYER_NAME);
if(GetAccountID(playerid))
{
new dialog[128+MAX_PLAYER_NAME];
format(dialog, sizeof(dialog),
"Добро пожаловать на Сервер!\n\
Этот аккаунт зарегистрирован.\n\n\
Логин: %s\n\
Введите пароль:", PlayerInfo[playerid][pName]);
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Авторизация.", dialog, "Войти", "Отмена");
}
else
{
new dialog[344+MAX_PLAYER_NAME];
format(dialog, sizeof(dialog),
"Добро пожаловать на Сервер!\n\
Этот аккаунт не зарегистрирован.\n\n\
Логин: %s\n\
Введите пароль и нажмите \"Далее\".\n\n\
Примечания:\n\
- Длина пароля от 6 до 15 символов.\n", PlayerInfo[playerid][pName]);
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Регистрация.", dialog, "Далее", "Отмена");
}
RemovePlayerInfo(playerid);
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
if(PlayerInfo[playerid][pLogged] == true) SaveAccount(playerid);
return 1;
}
public OnPlayerSpawn(playerid)
{
return 1;
}
public OnPlayerDeath(playerid, killerid, reason)
{
return 1;
}
public OnVehicleSpawn(vehicleid)
{
return 1;
}
public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}
public OnPlayerText(playerid, text[])
{
if(PlayerInfo[playerid][pLogged] == false) return 0;
return 1;
}
public OnPlayerCommandText(playerid, cmdtext[])
{
return 1;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}
public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}
public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}
public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}
public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}
public OnRconCommand(cmd[])
{
return 1;
}
public OnPlayerRequestSpawn(playerid)
{
return 1;
}
public OnObjectMoved(objectid)
{
return 1;
}
public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}
public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}
public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}
public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}
public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}
public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}
public OnPlayerExitedMenu(playerid)
{
return 1;
}
public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}
public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}
public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}
public OnPlayerUpdate(playerid)
{
return 1;
}
public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}
public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}
public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}
public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case DIALOG_LOGIN:
{
if(!response)
{
SendClientMessage(playerid, COLOR_GREEN, "Введите /q, чтобы выйти из игры!");
Kick(playerid);
return 1;
}
if(!strlen(inputtext))
{
new dialog[134+MAX_PLAYER_NAME];
format(dialog, sizeof(dialog),
"Добро пожаловать на Сервер!\n\
Этот аккаунт зарегистрирован.\n\n\
Логин: %s\n\
Введите пароль:", PlayerInfo[playerid][pName]);
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Авторизация.", dialog, "Войти", "Отмена");
return 1;
}
LoadAccount(playerid, inputtext);
}
case DIALOG_REGISTER:
{
if(!response)
{
SendClientMessage(playerid, COLOR_GREEN, "Введите /q, чтобы выйти из игры!");
Kick(playerid);
return 1;
}
if(!strlen(inputtext) || strlen(inputtext) < 6 || strlen(inputtext) > 15)
{
new dialog[380+24+10];
format(dialog, sizeof(dialog),
"Добро пожаловать на Сервер!\n\
Этот аккаунт не зарегистрирован.\n\n\
Логин: %s\n\
Введите пароль и нажмите \"Далее\".\n\n\
Примечания:\n\
- Длина пароля от 6 до 15 символов.\n", PlayerInfo[playerid][pName]);
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Регистрация.", dialog, "Далее", "Отмена");
return 1;
}
CreateAccount(playerid, inputtext);
PlayerInfo[playerid][pLogged] = true;
}
case DIALOG_WRONGPAS:
{
if(response)
{
new dialog[134+MAX_PLAYER_NAME];
format(dialog, sizeof(dialog),
"Добро пожаловать на Сервер!\n\
Этот аккаунт зарегистрирован.\n\n\
Логин: %s\n\
Введите пароль:",
PlayerInfo[playerid][pName]);
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Авторизация.", dialog, "Войти", "Отмена");
return 1;
}
else
{
Kick(playerid);
return 1;
}
}
}
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}
