Guest User

Untitled

a guest
Oct 30th, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.89 KB | None | 0 0
  1. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  2. {
  3. if(dialogid == 0)
  4. {
  5. if(!response) return ShowPlayerDialog(playerid, 97, DIALOG_STYLE_INPUT, "[ideal-rp.pl]Logowanie ~~ Zmiana nicku", "Poniżej wpisz nick swojej postaci, następnie naciśnij przycisk \"Logowanie\":", "Logowanie", "Wyjdź");
  6. new str[312];
  7. new hashex[256];
  8. new salt[126];
  9. new password[126];
  10. format(str, sizeof(str), "SELECT `gid` FROM `mybb_game_chars` WHERE `name` = '%s' AND `surname` = '%s'", PlayerInfo[playerid][pName], PlayerInfo[playerid][pSurname]);
  11. mysql_query(str);
  12. mysql_store_result();
  13. mysql_fetch_row_format(str, "|");
  14. sscanf(str, "p<|>d", globaluid[playerid]);
  15. mysql_free_result();
  16. format(str, sizeof(str), "SELECT `password`, `salt`, `username` FROM `mybb_users` WHERE `uid` = '%d'", globaluid[playerid]);
  17. mysql_query(str);
  18. mysql_store_result();
  19. mysql_fetch_row_format(str, "|");
  20. sscanf(str, "p<|>s[126]s[126]s[126]", password, salt, globalnick[playerid]);
  21. mysql_free_result();
  22. printf("Informacje o koncie globalnym gracza[%d]: GID: %d || Salt: %s || Username: %s || Password: %s ", playerid, globaluid[playerid], salt, globalnick[playerid], password);
  23. format(hashex, sizeof(hashex), "%s%s", MD5_Hash(salt), MD5_Hash(inputtext));
  24. format(str, sizeof(str), "SELECT * FROM mybb_users WHERE password = md5('%s') AND uid = ('%d') LIMIT 1", hashex, globaluid[playerid]);
  25. mysql_query(str);
  26. mysql_store_result();
  27. if(mysql_num_rows())
  28. {
  29. new dowyrzucenias[255], dowyrzuceniad;
  30. format(str, sizeof(str), "UPDATE `mybb_game_chars` SET `Status` = '1' WHERE `name` = '%s' AND `surname` = '%s'", PlayerInfo[playerid][pName], PlayerInfo[playerid][pSurname]);
  31. mysql_query(str);
  32. queries++;
  33. format(str, sizeof(str), "SELECT * FROM `mybb_game_chars` WHERE `name` = '%s' AND `surname` = '%s'", PlayerInfo[playerid][pName], PlayerInfo[playerid][pSurname]);
  34. mysql_query(str);
  35. mysql_store_result();
  36. mysql_fetch_row_format(str, "|");
  37. sscanf(str, "p<|>dds[12]s[20]s[32]ddddddddddddddddddddddddddddddddddddddfffffds[32]s[32]ddddddddddd",
  38. PlayerInfo[playerid][pUID],
  39. globaluid[playerid],
  40. PlayerInfo[playerid][pName],
  41. PlayerInfo[playerid][pSurname],
  42. dowyrzucenias,
  43. PlayerInfo[playerid][pHours],
  44. PlayerInfo[playerid][pMinutes],
  45. dowyrzuceniad,
  46. PlayerInfo[playerid][pGrupa1],
  47. PlayerInfo[playerid][pGrupa1Rank],
  48. PlayerInfo[playerid][pGrupa1Upr][0],
  49. PlayerInfo[playerid][pGrupa1Upr][1],
  50. PlayerInfo[playerid][pGrupa1Upr][2],
  51. PlayerInfo[playerid][pGrupa1Upr][3],
  52. PlayerInfo[playerid][pGrupa1Upr][4],
  53. PlayerInfo[playerid][pGrupa1Upr][5],
  54. PlayerInfo[playerid][pGrupa1Upr][6],
  55. PlayerInfo[playerid][pGrupa1Upr][7],
  56. PlayerInfo[playerid][pGrupa1Title],
  57. PlayerInfo[playerid][pGrupa2],
  58. PlayerInfo[playerid][pGrupa2Rank],
  59. PlayerInfo[playerid][pGrupa2Upr][0],
  60. PlayerInfo[playerid][pGrupa2Upr][1],
  61. PlayerInfo[playerid][pGrupa2Upr][2],
  62. PlayerInfo[playerid][pGrupa2Upr][3],
  63. PlayerInfo[playerid][pGrupa2Upr][4],
  64. PlayerInfo[playerid][pGrupa2Upr][5],
  65. PlayerInfo[playerid][pGrupa2Upr][6],
  66. PlayerInfo[playerid][pGrupa2Upr][7],
  67. PlayerInfo[playerid][pGrupa2Title],
  68. PlayerInfo[playerid][pGrupa3],
  69. PlayerInfo[playerid][pGrupa3Rank],
  70. PlayerInfo[playerid][pGrupa3Upr][0],
  71. PlayerInfo[playerid][pGrupa3Upr][1],
  72. PlayerInfo[playerid][pGrupa3Upr][2],
  73. PlayerInfo[playerid][pGrupa3Upr][3],
  74. PlayerInfo[playerid][pGrupa3Upr][4],
  75. PlayerInfo[playerid][pGrupa3Upr][5],
  76. PlayerInfo[playerid][pGrupa3Upr][6],
  77. PlayerInfo[playerid][pGrupa3Upr][7],
  78. PlayerInfo[playerid][pGrupa3Title],
  79. PlayerInfo[playerid][pBW],
  80. PlayerInfo[playerid][pSkin],
  81. PlayerInfo[playerid][pPos_x],
  82. PlayerInfo[playerid][pPos_y],
  83. PlayerInfo[playerid][pPos_z],
  84. PlayerInfo[playerid][pAngle],
  85. PlayerInfo[playerid][pHP],
  86. PlayerInfo[playerid][pBan],
  87. dowyrzucenias,
  88. dowyrzucenias,
  89. PlayerInfo[playerid][pCash],
  90. PlayerInfo[playerid][pAdmin],
  91. PlayerInfo[playerid][pBlokada_OOC],
  92. PlayerInfo[playerid][pBlokada_Sprint],
  93. PlayerInfo[playerid][pBlokada_NiechlujnegoPisania],
  94. PlayerInfo[playerid][pBlokada_Pojazdow],
  95. PlayerInfo[playerid][pAJ],
  96. PlayerInfo[playerid][pSpawn],
  97. PlayerInfo[playerid][pObiekty],
  98. PlayerInfo[playerid][pBank]);
  99. mysql_free_result();
  100. format(str, sizeof(str), "Witaj %s, zostałeś pomyślnie zalogowany na serwerze! Miłej gry!", globalnick[playerid]);
  101. Info(playerid, str);
  102. GivePlayerMoney(playerid, PlayerInfo[playerid][pCash]);
  103. Logged[playerid] = 1;
  104. SetPlayerColor(playerid, 0xD1D1A7FF);
  105. SpawnPlayer(playerid);
  106. new ip[16], date[64], seconds, minute, hour, year, day, month, second2[10], minute2[10], hour2[10], month2[10], day2[10];
  107. if(seconds < 10)
  108. {
  109. format(second2, sizeof(second2), "0%d", seconds);
  110. }
  111. else if(seconds >= 10)
  112. {
  113. format(second2, sizeof(second2), "%d", seconds);
  114. }
  115. if(hour < 10)
  116. {
  117. format(hour2, sizeof(hour2), "0%d", hour);
  118. }
  119. else if(hour >= 10)
  120. {
  121. format(hour2, sizeof(hour2), "%d", hour);
  122. }
  123. if(day < 10)
  124. {
  125. format(day2, sizeof(day2), "0%d", day);
  126. }
  127. else if(day >= 10)
  128. {
  129. format(day2, sizeof(day2), "%d", day);
  130. }
  131. if(minute < 10)
  132. {
  133. format(minute2, sizeof(minute2), "0%d", minute);
  134. }
  135. else if(minute >= 10)
  136. {
  137. format(minute2, sizeof(minute2), "%d", minute);
  138. }
  139. if(month < 10)
  140. {
  141. format(month2, sizeof(month2), "0%d", month);
  142. }
  143. else if(month >= 10)
  144. {
  145. format(month2, sizeof(month2), "%d", month);
  146. }
  147. gettime(hour, minute, seconds);
  148. getdate(year, month, day);
  149. format(date, sizeof(date), "%d-%s-%s %s:%s:%s", year, month2, day2, hour2, minute2, second2);
  150. GetPlayerIp(playerid, ip, 16);
  151. format(str, sizeof(str), "INSERT INTO `mybb_game_logs_login` (`charid`, `gid`, `time`, `IP`) VALUES ('%d', '%d', %s', '%s'", PlayerInfo[playerid][pUID], globaluid[playerid], date, ip);
  152. mysql_query(str);
  153. queries++;
  154. }
  155. else
  156. {
  157. Logged[playerid] = 0;
  158. GameTextForPlayer(playerid, "~n~~n~~n~~r~~h~Podales bledne haslo!",5000,5);
  159. ShowPlayerDialog(playerid, 0, DIALOG_STYLE_INPUT, "{BCA592}Ideal Role Play ~~ {ffffff}Logowanie", "{ffffff}Witamy na {BCA592}Ideal Role Play! {ffffff}\nWpisz poniżej swoje hasło, aby się zalogować:", "Zaloguj", "Zmień nick");
  160. }
  161. mysql_free_result();
  162. }
Add Comment
Please, Sign In to add comment