Advertisement
Guest User

Untitled

a guest
Nov 18th, 2019
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. Server:CheckPlayerVerified(playerid)
  2. {
  3. new
  4. query[90];
  5.  
  6. SetPlayerCamera(playerid);
  7.  
  8. mysql_format(m_Handlezero, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '0' LIMIT 1");
  9. mysql_tquery(m_Handlezero, query, "SQL_CheckPlayerVerified", "i", playerid);
  10.  
  11. mysql_format(m_Handleone, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '1' LIMIT 1");
  12. mysql_tquery(m_Handleone, query, "SQL_CheckPlayerVerified", "i", playerid);
  13.  
  14. mysql_format(m_Handletwo, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '2' LIMIT 1");
  15. mysql_tquery(m_Handletwo, query, "SQL_CheckPlayerVerified", "i", playerid);
  16.  
  17. return true;
  18. }
  19.  
  20. Server:SQL_CheckPlayerVerified(playerid)
  21. {
  22.  
  23. if (cache_num_rows(m_Handlezero) == '1')
  24. {
  25. SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account exists in our database but isn't verified. Check {8CF00C}www.sunrise-rp.com {F27373}frequently");
  26. SendClientMessage(playerid, COLOR_ADM, "{F27373}to know when it's verfiied. For more information, email {8CF00C}admin@sunrise-rp.com");
  27. KickEx(playerid);
  28. } elseif (cache_num_rows(m_Handletwo) == '1')
  29. {
  30. SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account exists in our database but has been declined.");
  31. KickEx(playerid);
  32. } elseif (cache_num_rows(m_Handleone) == '1')
  33. {
  34. SendClientMessage(playerid, COLOR_ADM, "{F27373}verified check complete");
  35. ShowLoginDialog(playerid, "");
  36. } else {
  37. SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account was not found.");
  38. KickEx(playerid);
  39. }
  40. return true;
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement