Advertisement
Guest User

Untitled

a guest
May 23rd, 2015
247
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.12 KB | None | 0 0
  1. stock InitPlayerConnection( playerid )
  2. {
  3. new Query[ 128 ], Name[ MAX_PLAYER_NAME ], EscapedName[ MAX_PLAYER_NAME ];
  4. GetPlayerName( playerid, Name, sizeof( Name ) );
  5. mysql_real_escape_string( Name, EscapedName );
  6. #pragma unused Name
  7. format( Query, sizeof( Query ), "SELECT `UserID` FROM `Accounts` WHERE `Username` = '%s'", EscapedName );
  8. mysql_query( Query );
  9. printf(" SQL: %s",Query);
  10. mysql_store_result();
  11. if( mysql_num_rows() >= 1 )
  12. {
  13. if( mysql_num_rows() >= 2 )
  14. {
  15. mysql_free_result();
  16. SendClientMessage( playerid, COLOR_WHITE, "There seems to be duplicates of your account, please contact a high-level admin." );
  17. SendClientMessage( playerid, COLOR_WHITE, "Best to screenshot this and forum PM a scripter with your ingame name, then they will check it asap." );
  18. Kick( playerid );
  19. }
  20. else
  21. {
  22. PlayerInfo[playerid][pDatabaseID] = mysql_fetch_int();
  23. // Start shit
  24. new string[128];
  25. format( string, sizeof( string ), "{FFFFFF}Welcome, {00C0FF}%s{FFFFFF} !\n\nPuneti parola in casuta de mai jos.", GetPlayerNameEx(playerid) );
  26. ShowPlayerDialog( playerid, 1, DIALOG_STYLE_PASSWORD,"{FFFFFF}AliasGaming RolePlay{FFFFFF}",string, "Login", "Exit" );
  27. SetTimerEx("LogTimer", 60000, 0, "d", playerid);
  28. //TogglePlayerSpectating(playerid, 1);
  29. //InterpolateCameraPos(playerid, 838.256958, -2255.666015, 28.207962, 795.577819, -1796.068237, 58.673408, 1000);
  30. //InterpolateCameraLookAt(playerid, 838.473815, -2250.677001, 27.958066, 796.360046, -1791.334350, 57.266872, 1000);
  31. gPlayerLogged[playerid] = 0;
  32. mysql_free_result();
  33. }
  34. }
  35. else
  36. {
  37. mysql_free_result();
  38. gPlayerLogged[playerid] = 0;
  39. SendClientMessage(playerid, COLOR_LIGHTRED, "Nu ai cont pe server! Te rog sa iti faci unu pe www.AliasGaming.Ro!");
  40. SetTimerEx("LogTimer", 6000, 0, "d", playerid);
  41. }
  42. return 1;
  43. }
  44.  
  45.  
  46. stock SavePlayerAccount( playerid )
  47. {
  48. new String[ 1024 ];
  49. if( gPlayerLogged[playerid] == 1 )
  50. {
  51. // Load normal stats 1
  52. format( String, sizeof( String ), "UPDATE `Accounts` SET `Password` = '%s', `Level` = '%d', `Admin` = '%d', `Banned` = '%d', `Sex` = '%d', `Tutorial` = '%d', `Bank` = '%d' WHERE `UserID` = '%d'"
  53. , PlayerInfo[playerid][pKey], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdministrator], PlayerInfo[playerid][pBan], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pDatabaseID]);
  54. mysql_query(String);
  55.  
  56. // Load normal stats 2
  57. PlayerInfo[playerid][pCash] = GetPlayerCash(playerid);
  58. format( String, sizeof( String ), "UPDATE `Accounts` SET `Experience` = '%d', `Money` = '%d', `Skin` = '%d', `SpawnPoint` = '%d', `HouseKey` = '%d', `Accent` = '%d', `BizKey` = '%d' WHERE `UserID` = '%d'"
  59. ,PlayerInfo[playerid][pExp],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pSkin],PlayerInfo[playerid][pSpawnPoint],PlayerInfo[playerid][pHouseKey],PlayerInfo[playerid][pAccent],PlayerInfo[playerid][pBizKey],PlayerInfo[playerid][pDatabaseID]);
  60. mysql_query(String);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement