Raggae1998

2

Jul 13th, 2012
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 9.88 KB | None | 0 0
  1. #include <a_samp>
  2.  
  3. #define MAXIMAL_PLAYERS 500
  4. #define DIALOG_LOGIN 0
  5. #define DIALOG_REGISTRATION 1
  6. #define WHITE "{FFFFFF}"
  7. #define DARK_WHITE "{BBBBBB}"
  8. #define RED "{FF0000}"
  9. #define DARK_RED "{BB0000}"
  10. #define GREEN "{00FF00}"
  11. #define DARK_GREEN "{00BB00}"
  12.  
  13. new DB:Database;
  14. new PlayerName[MAXIMAL_PLAYERS][30];
  15. new PlayerPassword[MAXIMAL_PLAYERS][30];
  16. new PlayerDateOfRegister[MAXIMAL_PLAYERS][20];
  17. new PlayerVisits[MAXIMAL_PLAYERS];
  18. new PlayerMoney[MAXIMAL_PLAYERS];
  19. new PlayerRespect[MAXIMAL_PLAYERS];
  20. new PlayerLevel[MAXIMAL_PLAYERS];
  21. new PlayerRespectToNextLevel[MAXIMAL_PLAYERS];
  22. new PlayerSuicides[MAXIMAL_PLAYERS];
  23. new PlayerDeaths[MAXIMAL_PLAYERS];
  24. new PlayerKills[MAXIMAL_PLAYERS];
  25. new PlayerRconAdministrator[MAXIMAL_PLAYERS];
  26. new PlayerHeadAdministrator[MAXIMAL_PLAYERS];
  27. new PlayerAdministrator[MAXIMAL_PLAYERS];
  28. new PlayerJuniorAdministrator[MAXIMAL_PLAYERS];
  29. new PlayerModerator[MAXIMAL_PLAYERS];
  30. new PlayerVip[MAXIMAL_PLAYERS];
  31. new PlayerLoggedIn[MAXIMAL_PLAYERS];
  32.  
  33. public OnGameModeInit()
  34. {
  35.     Database = db_open("Server.db");
  36.     return 1;
  37. }
  38. public OnGameModeExit()
  39. {
  40.     db_close(Database);
  41.     return 1;
  42. }
  43.  
  44. public OnPlayerConnect(playerid)
  45. {
  46.     new String[150];
  47.     GetPlayerName(playerid,PlayerName[playerid],30);
  48.     format(PlayerPassword[playerid],30," ");
  49.     format(PlayerDateOfRegister[playerid],20," ");
  50.     PlayerVisits[playerid] = 0;
  51.     PlayerMoney[playerid] = 0;
  52.     PlayerRespect[playerid] = 0;
  53.     PlayerLevel[playerid] = 0;
  54.     PlayerRespectToNextLevel[playerid] = 0;
  55.     PlayerSuicides[playerid] = 0;
  56.     PlayerDeaths[playerid] = 0;
  57.     PlayerKills[playerid] = 0;
  58.     PlayerRconAdministrator[playerid] = 0;
  59.     PlayerHeadAdministrator[playerid] = 0;
  60.     PlayerAdministrator[playerid] = 0;
  61.     PlayerJuniorAdministrator[playerid] = 0;
  62.     PlayerModerator[playerid] = 0;
  63.     PlayerVip[playerid] = 0;
  64.     PlayerLoggedIn[playerid] = 0;
  65.     format(String,150,"SELECT * FROM `Players` WHERE `PlayerName` = '%s'",PlayerName[playerid]);
  66.     new DBResult:DatabaseResult = db_query(Database,String);
  67.     if(db_num_rows(DatabaseResult)) ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Logowanie",""WHITE">>> Witaj ponownie na serwerze.\n"WHITE">>> Twój nick został znaleziony w naszej bazie danych.\n"WHITE">>> Wpisz poniżej hasło do konta podane podczas rejestracji.","Ok","Anuluj");
  68.     if(!db_num_rows(DatabaseResult)) ShowPlayerDialog(playerid,DIALOG_REGISTRATION,DIALOG_STYLE_PASSWORD,"Rejestracja",""WHITE">>> Witaj na serwerze.\n"WHITE">>> Twój nick nie został znaleziony w naszej bazie danych.\n"WHITE">>> Wpisz poniżej hasło do konta którego będziesz używał podczas logowania.","Ok","Anuluj");
  69.     db_free_result(DatabaseResult);
  70.     return 1;
  71. }
  72.  
  73. public OnPlayerDisconnect(playerid,reason)
  74. {
  75.     new String[150];
  76.     if(PlayerLoggedIn[playerid] == 1)
  77.     {
  78.         format(String,150,"UPDATE `Players` (`PlayerPassword`,`PlayerDateOfRegister`,`PlayerVisits`,`PlayerMoney`,`PlayerRespect`,`PlayerLevel`,`PlayerRespectToNextLevel`,`PlayerSuicides`,`PlayerDeaths`,`PlayerKills`,`PlayerRconAdministrator`,`PlayerHeadAdministrator`,`PlayerAdministrator`,`PlayerJuniorAdministrator`,`PlayerModerator`,`PlayerVip`) VALUES ('%s','%s','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d') WHERE `PlayerName` = '%s'",PlayerPassword[playerid],
  79.         PlayerDateOfRegister[playerid],PlayerVisits[playerid],PlayerMoney[playerid],PlayerRespect[playerid],PlayerLevel[playerid],PlayerRespectToNextLevel[playerid],PlayerSuicides[playerid],PlayerDeaths[playerid],PlayerKills[playerid],PlayerRconAdministrator[playerid],PlayerHeadAdministrator[playerid],PlayerAdministrator[playerid],PlayerJuniorAdministrator[playerid],PlayerModerator[playerid],PlayerVip[playerid]);
  80.         new DBResult:DatabaseResult = db_query(Database,String);
  81.         db_free_result(DatabaseResult);
  82.     }
  83.     return 1;
  84. }
  85.  
  86. public OnDialogResponse(playerid,dialogid,response,listitem,inputtext[])
  87. {
  88.     new String[150];
  89.     if(dialogid == DIALOG_LOGIN)
  90.     {
  91.         format(String,150,"SELECT (`PlayerDateOfRegister`,`PlayerVisits`,`PlayerMoney`,`PlayerRespect`,`PlayerLevel`,`PlayerRespectToNextLevel`,`PlayerSucides`,`PlayerDeaths`,`PlayerKills`,`PlayerRconAdministrator`,`PlayerHeadAdministrator`,`PlayerAdministrator`,`PlayerJuniorAdministrator`,`PlayerModerator`,`PlayerVip) FROM `Players` WHERE `PlayerName` = '%s' AND `PlayerPassword` = '%s'",PlayerName[playerid],PlayerPassword[playerid]);
  92.         new DBResult:DatabaseResult = db_query(Database,String);
  93.         if(response)
  94.         {
  95.             if(!db_num_rows(DatabaseResult))
  96.             {
  97.                 SendClientMessage(playerid,0,""RED">>> Podałeś nieprawidłowe hasło.");
  98.                 ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Logowanie",""WHITE">>> Witaj ponownie na serwerze.\n"WHITE">>> Twój nick został znaleziony w naszej bazie danych.\n"WHITE">>> Wpisz poniżej hasło do konta podane podczas rejestracji.","Ok","Anuluj");
  99.                 return 1;
  100.             }
  101.             new FieldDateOfRegister[20];
  102.             db_get_field_assoc(DatabaseResult,"PlayerDateOfRegister",FieldDateOfRegister,20);
  103.             format(PlayerDateOfRegister[playerid],20,"%s",strlen(FieldDateOfRegister));
  104.             db_free_result(DatabaseResult);
  105.             new FieldVisits[20];
  106.             db_get_field_assoc(DatabaseResult,"PlayerVisits",FieldVisits,20);
  107.             PlayerVisits[playerid] = strval(FieldVisits);
  108.             db_free_result(DatabaseResult);
  109.             new FieldMoney[20];
  110.             db_get_field_assoc(DatabaseResult,"PlayerMoney",FieldMoney,20);
  111.             PlayerMoney[playerid] = strval(FieldMoney);
  112.             db_free_result(DatabaseResult);
  113.             new FieldRespect[20];
  114.             db_get_field_assoc(DatabaseResult,"PlayerRespect",FieldRespect,20);
  115.             PlayerRespect[playerid] = strval(FieldRespect);
  116.             db_free_result(DatabaseResult);
  117.             new FieldLevel[5];
  118.             db_get_field_assoc(DatabaseResult,"PlayerLevel",FieldLevel,5);
  119.             PlayerLevel[playerid] = strval(FieldLevel);
  120.             db_free_result(DatabaseResult);
  121.             new FieldRespectToNextLevel[20];
  122.             db_get_field_assoc(DatabaseResult,"PlayerRespectToNextLevel",FieldRespectToNextLevel,20);
  123.             PlayerRespectToNextLevel[playerid] = strval(FieldRespectToNextLevel);
  124.             db_free_result(DatabaseResult);
  125.             new FieldSuicides[20];
  126.             db_get_field_assoc(DatabaseResult,"PlayerSuicides",FieldSuicides,20);
  127.             PlayerSuicides[playerid] = strval(FieldSuicides);
  128.             db_free_result(DatabaseResult);
  129.             new FieldDeaths[20];
  130.             db_get_field_assoc(DatabaseResult,"PlayerDeaths",FieldDeaths,20);
  131.             PlayerDeaths[playerid] = strval(FieldDeaths);
  132.             db_free_result(DatabaseResult);
  133.             new FieldKills[20];
  134.             db_get_field_assoc(DatabaseResult,"PlayerKills",FieldKills,20);
  135.             PlayerKills[playerid] = strval(FieldKills);
  136.             db_free_result(DatabaseResult);
  137.             new FieldRconAdministrator[1];
  138.             db_get_field_assoc(DatabaseResult,"PlayerRconAdministrator",FieldRconAdministrator,1);
  139.             PlayerRconAdministrator[playerid] = strval(FieldRconAdministrator);
  140.             db_free_result(DatabaseResult);
  141.             new FieldHeadAdministrator[1];
  142.             db_get_field_assoc(DatabaseResult,"PlayerHeadAdministrator",FieldHeadAdministrator,1);
  143.             PlayerHeadAdministrator[playerid] = strval(FieldHeadAdministrator);
  144.             db_free_result(DatabaseResult);
  145.             new FieldAdministrator[1];
  146.             db_get_field_assoc(DatabaseResult,"PlayerAdministrator",FieldAdministrator,1);
  147.             PlayerAdministrator[playerid] = strval(FieldAdministrator);
  148.             db_free_result(DatabaseResult);
  149.             new FieldJuniorAdministrator[1];
  150.             db_get_field_assoc(DatabaseResult,"PlayerJuniorAdministrator",FieldJuniorAdministrator,1);
  151.             PlayerHeadAdministrator[playerid] = strval(FieldJuniorAdministrator);
  152.             db_free_result(DatabaseResult);
  153.             new FieldModerator[1];
  154.             db_get_field_assoc(DatabaseResult,"PlayerModerator",FieldModerator,1);
  155.             PlayerModerator[playerid] = strval(FieldModerator);
  156.             db_free_result(DatabaseResult);
  157.             new FieldVip[1];
  158.             db_get_field_assoc(DatabaseResult,"PlayerVip",FieldVip,1);
  159.             PlayerVip[playerid] = strval(FieldVip);
  160.             db_free_result(DatabaseResult);
  161.             PlayerVisits[playerid] += 1;
  162.             PlayerLoggedIn[playerid] = 1;
  163.             SendClientMessage(playerid,0,""GREEN">>> Zalogowałeś się pomyślnie, życzymy miłej gry.");
  164.         }
  165.         if(!response)
  166.         {
  167.             format(String,150,""RED">>> Gracz "DARK_RED"%s (%d) "RED"został wyrzucony. Powód: Anulowanie logowania.",PlayerName[playerid],playerid);
  168.             SendClientMessageToAll(0,String);
  169.             Kick(playerid);
  170.         }
  171.     }
  172.     if(dialogid == DIALOG_REGISTRATION)
  173.     {
  174.         if(response)
  175.         {
  176.             if(strlen(inputtext) < 5)
  177.             {
  178.                 SendClientMessage(playerid,0,""RED">>> Wpisałeś nieprawidłowe hasło, minimalnie 5 znaków.");
  179.                 ShowPlayerDialog(playerid,DIALOG_REGISTRATION,DIALOG_STYLE_PASSWORD,"Rejestracja",""WHITE">>> Witaj na serwerze.\n"WHITE">>> Twój nick nie został znaleziony w naszej bazie danych.\n"WHITE">>> Wpisz poniżej hasło do konta którego będziesz używał podczas logowania.","Ok","Anuluj");
  180.                 return 1;
  181.             }
  182.             if(strlen(inputtext) > 20)
  183.             {
  184.                 SendClientMessage(playerid,0,""RED">>> Wpisałeś nieprawidłowe hasło, maksymalnie 20 znaków.");
  185.                 ShowPlayerDialog(playerid,DIALOG_REGISTRATION,DIALOG_STYLE_PASSWORD,"Rejestracja",""WHITE">>> Witaj na serwerze.\n"WHITE">>> Twój nick nie został znaleziony w naszej bazie danych.\n"WHITE">>> Wpisz poniżej hasło do konta którego będziesz używał podczas logowania.","Ok","Anuluj");
  186.                 return 1;
  187.             }
  188.             format(PlayerPassword[playerid],30,"%s",inputtext);
  189.             new Year,Month,Day;
  190.             getdate(Year,Month,Day);
  191.             format(PlayerDateOfRegister[playerid],20,"%02d/%02d/%d",Day,Month,Year);
  192.             PlayerVisits[playerid] = 1;
  193.             PlayerMoney[playerid] = 50000;
  194.             PlayerRespectToNextLevel[playerid] = 500;
  195.             PlayerLoggedIn[playerid] = 1;
  196.             format(String,150,""GREEN">>> Zarejestrowałeś się pomyślnie, twoje hasło to "DARK_GREEN"%s"GREEN". Życzymy miłej gry.",inputtext);
  197.             SendClientMessage(playerid,0,String);
  198.             format(String,150,"INSERT INTO `Players` (`PlayerName`,`PlayerPassword`) VALUES ('%s','%s');",PlayerName[playerid],inputtext);
  199.             new DBResult:DatabaseResult = db_query(Database,String);
  200.             db_free_result(DatabaseResult);
  201.         }
  202.     }
  203.     return 1;
  204. }
Advertisement
Add Comment
Please, Sign In to add comment