API tools faq
paste
Guest User

Untitled

a guest
Feb 27th, 2014
154
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 14.31 KB | None | 0 0
raw download clone embed print report
  1. #include <a_samp>
  2. #include <zcmd>
  3. #include <a_mysql>
  4. #include <sscanf2>
  5. #include <OPSP>
  6.  
  7. new Text:Site;
  8. new gTeam[MAX_PLAYERS];
  9.  
  10. #define TEAM_CITIZEN 0
  11. #define TEAM_COP 1
  12.  
  13. native WP_Hash(_buffer[], len, const str[]);
  14.    
  15. #define DIALOG_REGISTER 1
  16. #define DIALOG_LOGIN 2
  17.  
  18. #define COLOR_WHITE 0xFFFFFFAA
  19.  
  20. #define MySQL_Host ""
  21. #define MySQL_Username "server_739"
  22. #define MySQL_Password ""
  23. #define MySQL_Database "server_739"
  24.  
  25. enum pInfo
  26. {
  27.     pScore,
  28.     pAdmin,
  29.     pVip,
  30.     pTrusted,
  31.     pHighest,
  32.     pMoney,
  33.     pKills,
  34.     pDeaths
  35. }
  36. new PlayerInfo[MAX_PLAYERS][pInfo];
  37.  
  38. new connection;
  39. new MySQL_Query[1800];
  40.  
  41. new PasswordAttempts[MAX_PLAYERS];
  42. new IsPlayerLoggedIn[MAX_PLAYERS char];
  43.  
  44. forward LoggedIn(playerid, const password[]);
  45. forward CheckPasswordAttempts(playerid);
  46. forward IsRegistered(playerid);
  47.  
  48. //==============================================================================
  49.  
  50. main()
  51. {
  52.     print("\n----------------------------------");
  53.     print(" San Fierro Cops and Robbers!");
  54.     print("----------------------------------\n");
  55. }
  56. public OnGameModeInit()
  57. {
  58.     AddPlayerClass(105,-183.5194,1090.8673,19.7422,52.6484,0,0,0,0,0,0);    
  59.     AddPlayerClass(282,1607.0870,1815.6981,10.8203,193.8336,0,0,0,0,0,0);
  60.     connection = mysql_connect(MySQL_Host, MySQL_Username, MySQL_Database, MySQL_Password);
  61.     if(!mysql_errno(connection)) print("MySQL Connection Success");
  62.     else print("MySQL Connection Failed");
  63.  
  64.     SetGameModeText("CnR[0.3z][New!]");
  65.        
  66.     return 1;
  67. }
  68.  
  69. public OnGameModeExit()
  70. {
  71.     mysql_close(connection);
  72.     return 1;
  73. }
  74.  
  75.  
  76. public OnPlayerConnect(playerid)
  77. {
  78.     format(MySQL_Query, sizeof(MySQL_Query), "SELECT * FROM `Accounts` WHERE Username = '%s'", EscapeText(PlayerName(playerid)));
  79.     mysql_function_query(connection, MySQL_Query, true, "IsRegistered", "i", playerid);
  80.     TextDrawShowForAll(Site);
  81.     return 1;
  82. }
  83.  
  84. public OnPlayerDisconnect(playerid, reason)
  85. {
  86.     if(IsPlayerLoggedIn{playerid} == 1)
  87.     {
  88.         PlayerInfo[playerid][pMoney] = GetPlayerMoney(playerid);
  89.         PlayerInfo[playerid][pScore] = GetPlayerScore(playerid);
  90.         format(MySQL_Query, sizeof(MySQL_Query), "UPDATE `Accounts` SET Score = '%i' , Admin = '%i' , Vip = '%i' , Trusted_Players = '%i' , Highest_Donator = '%i' , Money = '%i', Kills = '%i', Deaths = '%i' WHERE Username = '%s'",
  91.         PlayerInfo[playerid][pScore], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pVip], PlayerInfo[playerid][pTrusted], PlayerInfo[playerid][pHighest], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], EscapeText(PlayerName(playerid)));
  92.         mysql_function_query(connection, MySQL_Query, false, "", "");
  93.     }
  94.  
  95.     PlayerInfo[playerid][pAdmin] = 0;
  96.     PlayerInfo[playerid][pVip] = 0;
  97.     PlayerInfo[playerid][pScore] = 0;
  98.     PlayerInfo[playerid][pTrusted] = 0;
  99.     PlayerInfo[playerid][pHighest] = 0;
  100.     PlayerInfo[playerid][pMoney] = 0;
  101.     return 1;
  102. }
  103.  
  104. public OnPlayerSpawn(playerid)
  105. {
  106.     return 1;
  107. }
  108.  
  109. public OnPlayerDeath(playerid, killerid, reason)
  110. {
  111.     if(killerid != INVALID_PLAYER_ID) return 1;
  112.    
  113.     PlayerInfo[playerid][pDeaths] += 1;
  114.     PlayerInfo[killerid][pKills] += 1;
  115.     return 1;
  116. }
  117.  
  118. public OnVehicleSpawn(vehicleid)
  119. {
  120.     return 1;
  121. }
  122.  
  123. public OnVehicleDeath(vehicleid, killerid)
  124. {
  125.     return 1;
  126. }
  127.  
  128. public OnPlayerText(playerid, text[])
  129. {
  130.     return 1;
  131. }
  132.  
  133. /*public OnPlayerCommandText(playerid, cmdtext[])
  134. {
  135.     if (strcmp("/mycommand", cmdtext, true, 10) == 0)
  136.     {
  137.         // Do something here
  138.         return 1;
  139.     }
  140.     return 0;
  141. }*/
  142.  
  143. public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
  144. {
  145.     return 1;
  146. }
  147.  
  148. public OnPlayerExitVehicle(playerid, vehicleid)
  149. {
  150.     return 1;
  151. }
  152.  
  153. public OnPlayerStateChange(playerid, newstate, oldstate)
  154. {
  155.     return 1;
  156. }
  157.  
  158. public OnPlayerEnterCheckpoint(playerid)
  159. {
  160.     return 1;
  161. }
  162.  
  163. public OnPlayerLeaveCheckpoint(playerid)
  164. {
  165.     return 1;
  166. }
  167.  
  168. public OnPlayerEnterRaceCheckpoint(playerid)
  169. {
  170.     return 1;
  171. }
  172.  
  173. public OnPlayerLeaveRaceCheckpoint(playerid)
  174. {
  175.     return 1;
  176. }
  177.  
  178. public OnRconCommand(cmd[])
  179. {
  180.     return 1;
  181. }
  182.  
  183. public OnPlayerRequestClass(playerid)
  184. {
  185.     return 1;
  186. }
  187. SetPlayerTeamFromClass(playerid, classid)
  188.  
  189.  
  190. public OnPlayerShootPlayer(Shooter,Target,Float:HealthLost,Float:ArmourLost)
  191. {
  192.     SetPlayerWantedLevel(Shooter,1);
  193.     SendClientMessage(Shooter,-1, "You have received Wanted level for commiting a crime!");
  194.     return 1;
  195. }
  196.  
  197. public OnObjectMoved(objectid)
  198. {
  199.     return 1;
  200. }
  201.  
  202. public OnPlayerObjectMoved(playerid, objectid)
  203. {
  204.     return 1;
  205. }
  206.  
  207. public OnPlayerPickUpPickup(playerid, pickupid)
  208. {
  209.     return 1;
  210. }
  211.  
  212. public OnVehicleMod(playerid, vehicleid, componentid)
  213. {
  214.     return 1;
  215. }
  216.  
  217. public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
  218. {
  219.     return 1;
  220. }
  221.  
  222. public OnVehicleRespray(playerid, vehicleid, color1, color2)
  223. {
  224.     return 1;
  225. }
  226.  
  227. public OnPlayerSelectedMenuRow(playerid, row)
  228. {
  229.     return 1;
  230. }
  231.  
  232. public OnPlayerExitedMenu(playerid)
  233. {
  234.     return 1;
  235. }
  236.  
  237. public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
  238. {
  239.     return 1;
  240. }
  241.  
  242. public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
  243. {
  244.     return 1;
  245. }
  246.  
  247. public OnRconLoginAttempt(ip[], password[], success)
  248. {
  249.     return 1;
  250. }
  251.  
  252. public OnPlayerUpdate(playerid)
  253. {
  254.     return 1;
  255. }
  256.  
  257. public OnPlayerStreamIn(playerid, forplayerid)
  258. {
  259.     return 1;
  260. }
  261.  
  262. public OnPlayerStreamOut(playerid, forplayerid)
  263. {
  264.     return 1;
  265. }
  266.  
  267. public OnVehicleStreamIn(vehicleid, forplayerid)
  268. {
  269.     return 1;
  270. }
  271.  
  272. public OnVehicleStreamOut(vehicleid, forplayerid)
  273. {
  274.     return 1;
  275. }
  276.  
  277. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  278. {
  279.     if(dialogid == DIALOG_REGISTER)
  280.     {
  281.         if(!response)
  282.         {
  283.             Kick(playerid);
  284.             return 1;
  285.         }
  286.  
  287.         if(!strlen(inputtext))
  288.         {
  289.             SendClientMessage(playerid, -1, "Enter a password.");
  290.             ShowRegisterScreen(playerid);
  291.             return 1;
  292.         }
  293.  
  294.         if(strlen(inputtext) < 5)
  295.         {
  296.             SendClientMessage(playerid, -1, "Enter a password with more than 5 characters.");
  297.             ShowRegisterScreen(playerid);
  298.             return 1;
  299.         }
  300.  
  301.         if(strlen(inputtext) >= 5)
  302.         {
  303.             new IP[20], hashedpass[200];
  304.             GetPlayerIp(playerid, IP, sizeof(IP));
  305.             WP_Hash(hashedpass, sizeof(hashedpass), inputtext);
  306.  
  307.             new querystring[1800];
  308.  
  309.             strcat(querystring, "INSERT INTO `Accounts` (`ID`, `Username`, `Password`, `Admin`, `Vip, `Money`, `Kills`, `Deaths`, `Trusted_Player`, `Highest_Donator`)");
  310.             strcat(querystring, " VALUES");
  311.  
  312.             format(MySQL_Query, sizeof(MySQL_Query), "%s (NULL, '%s', '%s', '0', '0', '0', '0', '0', '0', '0')", querystring, EscapeText(PlayerName(playerid)), EscapeText(hashedpass));
  313.             mysql_function_query(connection, MySQL_Query, false, "", "");
  314.         }
  315.         IsPlayerLoggedIn{playerid} = 1;
  316.         return 1;
  317.     }
  318.  
  319.     if(dialogid == DIALOG_LOGIN)
  320.     {
  321.         if(!response)
  322.         {
  323.             Kick(playerid);
  324.             return 1;
  325.         }
  326.  
  327.         if(!strlen(inputtext))
  328.         {
  329.             SendClientMessage(playerid, -1, "Enter a password.");
  330.             ShowLoginScreen(playerid);
  331.         }
  332.  
  333.         if(strlen(inputtext) < 5)
  334.         {
  335.             SendClientMessage(playerid, -1, "Enter a password with more than 5 char.");
  336.             ShowLoginScreen(playerid);
  337.         }
  338.  
  339.         if(strlen(inputtext) >= 5)
  340.         {
  341.             format(MySQL_Query, sizeof(MySQL_Query), "SELECT * FROM `Accounts` WHERE Username='%s'", EscapeText(PlayerName(playerid)));
  342.             mysql_function_query(connection, MySQL_Query, true, "LoggedIn", "is", playerid, inputtext);
  343.         }
  344.         return 1;
  345.     }
  346.     return 1;
  347. }
  348.  
  349. public OnPlayerClickPlayer(playerid, clickedplayerid, source)
  350. {
  351.     return 1;
  352. }
  353.  
  354. public LoggedIn(playerid, const password[])
  355. {
  356.     new ppassword[500];
  357.     new hashedpass[500];
  358.  
  359.     WP_Hash(hashedpass, sizeof(hashedpass), password);
  360.     cache_get_field_content(0, "Password", ppassword, connection);
  361.  
  362.     if(!strcmp(hashedpass, ppassword))
  363.     {
  364.         if(IsPlayerLoggedIn{playerid} != 1)
  365.         {
  366.             new tempfetch[500];
  367.             cache_get_field_content(0, "Score", tempfetch, connection),             PlayerInfo[playerid][pScore] = strval(tempfetch);
  368.             cache_get_field_content(0, "Admin", tempfetch, connection),             PlayerInfo[playerid][pAdmin] = strval(tempfetch);
  369.             cache_get_field_content(0, "Vip", tempfetch, connection),               PlayerInfo[playerid][pVip] = strval(tempfetch);
  370.             cache_get_field_content(0, "Trusted_Player", tempfetch, connection),    PlayerInfo[playerid][pTrusted] = strval(tempfetch);
  371.             cache_get_field_content(0, "Highest_Donator", tempfetch, connection),   PlayerInfo[playerid][pHighest] = strval(tempfetch);
  372.             cache_get_field_content(0, "Money", tempfetch, connection),             PlayerInfo[playerid][pMoney] = strval(tempfetch);
  373.             cache_get_field_content(0, "Kills", tempfetch, connection),             PlayerInfo[playerid][pKills] = strval(tempfetch);
  374.             cache_get_field_content(0, "Deaths", tempfetch, connection),            PlayerInfo[playerid][pDeaths] = strval(tempfetch);
  375.  
  376.             IsPlayerLoggedIn{playerid} = 1;
  377.  
  378.             SendClientMessage(playerid, -1, "{8EC7DC}[INFO] {FFFFFF}Your statistics have been restored.");
  379.             return 1;
  380.         }
  381.     }
  382.     else
  383.     {
  384.         CheckPasswordAttempts(playerid);
  385.         ShowLoginScreen(playerid);
  386.     }
  387.     return 1;
  388. }
  389.  
  390. public CheckPasswordAttempts(playerid)
  391. {
  392.     if(PasswordAttempts[playerid] == 0)
  393.     {
  394.         SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}You have entered an incorrect password. [1/3]");
  395.         PasswordAttempts[playerid] ++;
  396.         return 1;
  397.     }
  398.  
  399.     if(PasswordAttempts[playerid] == 1)
  400.     {
  401.         SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}You have entered an incorrect password. [2/3]");
  402.         PasswordAttempts[playerid] ++;
  403.         return 1;
  404.     }
  405.  
  406.     if(PasswordAttempts[playerid] == 2)
  407.     {
  408.         new string[128];
  409.         SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}You have entered an incorrect password. [3/3]");
  410.  
  411.         format(string,sizeof(string),"{208DD6}[SERVER] {FFFFFF}%s[%d] has been kicked from the server. (Max password attempts)",PlayerName(playerid),playerid);
  412.         SendClientMessageToAll(COLOR_WHITE,string);
  413.  
  414.         Kick(playerid);
  415.         return 1;
  416.     }
  417.     return 1;
  418. }
  419.  
  420. public IsRegistered(playerid)
  421. {
  422.     new rows, fields;
  423.  
  424.     cache_get_data(rows, fields, connection);
  425.  
  426.     if(rows)
  427.     {
  428.         ShowLoginScreen(playerid);
  429.     }
  430.     else
  431.     {
  432.         ShowRegisterScreen(playerid);
  433.     }
  434.     return 1;
  435. }
  436.  
  437. public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
  438. {
  439.     printf("Error ID: %i", errorid);
  440.     printf("Error: %s", error);
  441.     printf("callback: %s", callback);
  442.     printf("query: %s", query);
  443.     return 1;
  444. }
  445.  
  446. stock EscapeText(text[])
  447. {
  448.     new EscapedData[200];
  449.     mysql_real_escape_string(text, EscapedData, connection);
  450.     return EscapedData;
  451. }
  452.  
  453. stock ShowLoginScreen(playerid)
  454. {
  455.     new string[128];
  456.     format(string, sizeof(string), "Before playing you must login\n\nUsername: %s\n\nEnter your password below and click login",PlayerName(playerid));
  457.     ShowPlayerDialog(playerid,DIALOG_LOGIN,3,"{EDDC57}Login required",string,"Login","Cancel");
  458. }
  459.  
  460. stock ShowRegisterScreen(playerid)
  461. {
  462.     new string[128];
  463.     format(string, sizeof(string), "This server requires you to register an account before playing\n\nUsername: %s\n\nEnter your desired password below then click ok",PlayerName(playerid));
  464.     ShowPlayerDialog(playerid,DIALOG_REGISTER,3,"{EDDC57}Registration required",string,"Register","Cancel");
  465. }
  466.  
  467. stock PlayerName(playerid)
  468. {
  469.     new name[21];
  470.     GetPlayerName(playerid, name, sizeof(name));
  471.     return name;
  472. }
  473.  
  474. CMD:kill(playerid,params[])
  475. {
  476.     SetPlayerHealth(playerid, 0);  
  477.     if(!IsPlayerConnected(playerid))
  478.         return SendClientMessage(playerid, COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}You Must be Logged In!");
  479.     return 1;
  480. }
  481. CMD:setlevel(playerid,params[])
  482. {
  483.     new string[128], ID, level;
  484.  
  485.     if(PlayerInfo[playerid][pAdmin] < 6) // change this to owner level
  486.         return SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}You don't have access to this command.");
  487.  
  488.     if(sscanf(params,"ii",ID,level))
  489.         return SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}USAGE: /setlevel [playerid] [Level]");
  490.  
  491.     if(!IsPlayerConnected(ID))
  492.         return SendClientMessage(playerid, COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}The requested playerid is not connected to the server.");
  493.  
  494.     if(PlayerInfo[playerid][pAdmin] <= PlayerInfo[ID][pAdmin])
  495.         return SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF} This has no effect on the current playerid.");
  496.  
  497.     if(PlayerInfo[ID][pAdmin] == level)
  498.     {
  499.         format(string,sizeof(string),"{B30000}[ERROR] {FFFFFF}%s[%d] is already at the Administrator level: %d",PlayerName(ID),ID,level);
  500.         SendClientMessage(playerid,COLOR_WHITE,string);
  501.         return 1;
  502.     }
  503.  
  504.     if(playerid == ID)
  505.         return SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}You cannot set your own Administrator level.");
  506.  
  507.     if(PlayerInfo[ID][pAdmin] < level)
  508.     {
  509.         format(string, sizeof(string), "{46A4E3}[ADMIN] {FFFFFF}%s[%d] has promoted %s[%d] to level %d.",PlayerName(playerid),playerid,PlayerName(ID),ID,level);
  510.         SendClientMessageToAll(COLOR_WHITE,string);
  511.     }
  512.  
  513.     else if(PlayerInfo[ID][pAdmin] > level)
  514.     {
  515.         format(string, sizeof(string), "{46A4E3}[ADMIN] {FFFFFF}%s[%d] has demoted %s[%d] to level %d.",PlayerName(playerid),playerid,PlayerName(ID),ID,level);
  516.         SendClientMessageToAll(COLOR_WHITE,string);
  517.     }
  518.  
  519.     PlayerInfo[ID][pAdmin] = level;
  520.  
  521.     return 1;
  522. }
  523.  
  524. CMD:setscore(playerid,params[])
  525. {
  526.     new string[128], ID, score;
  527.  
  528.     if(PlayerInfo[playerid][pAdmin] < 6) // change to owner rank
  529.         return  SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}You don't have access to this command.");
  530.  
  531.     if(sscanf(params,"ii",ID,score))
  532.         return SendClientMessage(playerid, COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}The requested playerid is not connected to the server.");
  533.  
  534.     if(!IsPlayerConnected(ID))
  535.         return SendClientMessage(playerid, COLOR_WHITE,"{B30000}[ERROR] {FFFFFF}The requested playerid is not connected to the server.");
  536.  
  537.     if(PlayerInfo[playerid][pAdmin] < PlayerInfo[ID][pAdmin])
  538.          return SendClientMessage(playerid,COLOR_WHITE,"{B30000}[ERROR] {FFFFFF} This has no effect on the current playerid.");
  539.  
  540.     format(string,sizeof(string),"{46A4E3}[ADMIN] {FFFFFF}%s[%d] has set %s[%d]'s score to %d.",PlayerName(playerid),playerid,PlayerName(ID),ID,score);
  541.     SendClientMessageToAll(COLOR_WHITE,string);
  542.  
  543.     SetPlayerScore(ID, score);
  544.     PlayerInfo[ID][pScore] = score;
  545.     return 1;
  546. }
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!