Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- stock InitPlayerConnection( playerid )
- {
- new Query[ 128 ], Name[ MAX_PLAYER_NAME ], EscapedName[ MAX_PLAYER_NAME ];
- GetPlayerName( playerid, Name, sizeof( Name ) );
- mysql_real_escape_string( Name, EscapedName );
- #pragma unused Name
- format( Query, sizeof( Query ), "SELECT `UserID` FROM `Accounts` WHERE `Username` = '%s'", EscapedName );
- mysql_query( Query );
- printf(" SQL: %s",Query);
- mysql_store_result();
- if( mysql_num_rows() >= 1 )
- {
- if( mysql_num_rows() >= 2 )
- {
- mysql_free_result();
- SendClientMessage( playerid, COLOR_WHITE, "There seems to be duplicates of your account, please contact a high-level admin." );
- SendClientMessage( playerid, COLOR_WHITE, "Best to screenshot this and forum PM a scripter with your ingame name, then they will check it asap." );
- Kick( playerid );
- }
- else
- {
- PlayerInfo[playerid][pDatabaseID] = mysql_fetch_int();
- // Start shit
- new string[128];
- format( string, sizeof( string ), "{FFFFFF}Welcome, {00C0FF}%s{FFFFFF} !\n\nPuneti parola in casuta de mai jos.", GetPlayerNameEx(playerid) );
- ShowPlayerDialog( playerid, 1, DIALOG_STYLE_PASSWORD,"{FFFFFF}AliasGaming RolePlay{FFFFFF}",string, "Login", "Exit" );
- SetTimerEx("LogTimer", 60000, 0, "d", playerid);
- TogglePlayerSpectating(playerid, 1);
- gPlayerLogged[playerid] = 0;
- mysql_free_result();
- }
- }
- else
- {
- mysql_free_result();
- gPlayerLogged[playerid] = 0;
- ShowPlayerDialog( playerid, 2, DIALOG_STYLE_INPUT, "{6EF83C}Inregistrare{FFFFFF}", "Bine ai venit!\n\nTe rugam sa introduci o parola pentru a te inregistra.", "Register", "Cancel" );
- }
- return 1;
- }
- stock SavePlayerAccount( playerid )
- {
- new String[ 1024 ];
- if( gPlayerLogged[playerid] == 1 )
- {
- // Load normal stats 1
- format( String, sizeof( String ), "UPDATE `Accounts` SET `Password` = '%s', `Level` = '%d', `Admin` = '%d', `Banned` = '%d', `Sex` = '%d', `Tutorial` = '%d', `Bank` = '%d' WHERE `UserID` = '%d'"
- , PlayerInfo[playerid][pKey], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdministrator], PlayerInfo[playerid][pBan], PlayerInfo[playerid][pSex], PlayerInfo[ playerid ][ pTut ], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pDatabaseID]);
- mysql_query(String);
- // Load normal stats 2
- PlayerInfo[playerid][pCash] = GetPlayerCash(playerid);
- format( String, sizeof( String ), "UPDATE `Accounts` SET `Experience` = '%d', `Money` = '%d', `Skin` = '%d', `SpawnPoint` = '%d', `HouseKey` = '%d', `BizKey` = '%d' WHERE `UserID` = '%d'"
- ,PlayerInfo[playerid][pExp],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pSpawnPoint],PlayerInfo[playerid][pHouseKey],PlayerInfo[playerid][pBizKey],PlayerInfo[playerid][pDatabaseID]);
- mysql_query(String);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement