Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <a_samp>
- #include <a_mysql> // R38+
- #include <zcmd>
- #include <foreach>
- enum Players
- {
- Name,
- Time1, // Ore
- Time2, // Minute
- Time3 // Secunde
- }
- new Player[MAX_PLAYERS][Players]; new cH;
- forward OnPlayerLevel();
- stock CheckOnlineTime(playerid)
- {
- new query[128], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid, pName, 32);
- format(query, sizeof(query), "SELECT * FROM `levels`");
- mysql_query(cH, query);
- Player[playerid][Time1] = cache_get_field_content_int(0, "Ore");
- Player[playerid][Time2] = cache_get_field_content_int(0, "Minute");
- Player[playerid][Time3] = cache_get_field_content_int(0, "Secunde");
- printf("%s has recivied a %i ore, %i minute, %i secounde time.", pName, Player[playerid][Time1], Player[playerid][Time2], Player[playerid][Time3]);
- return 1;
- }
- public OnPlayerLevel()
- {
- foreach(Player, i)
- {
- if(IsPlayerConnected(i))
- {
- Player[i][Time3] += 1; // Update Time in secounds.
- if(Player[i][Time3] == 60)
- {
- Player[i][Time3] = 0;
- Player[i][Time2] += 1;
- }
- if(Player[i][Time2] == 60)
- {
- Player[i][Time3] = 0;
- Player[i][Time2] = 0;
- Player[i][Time1] += 1;
- }
- }
- }
- return 1;
- }
- public OnPlayerConnect(playerid)
- {
- new query[128], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid, pName, 32);
- format(query, sizeof(query), "SELECT * FROM `levels`");
- mysql_query(cH, query);
- CheckOnlineTime(playerid);
- SetTimer("OnPlayerLevel", 1000, true);
- return 1;
- }
- public OnPlayerDisconnect(playerid)
- {
- new query[256], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid, pName, 32);
- format(query, sizeof(query), "UPDATE `levels` SET `Ore`='%i',`Minute`='%i',`Secunde`='%i' WHERE `Name`='%s'", Player[playerid][Time1], Player[playerid][Time2], Player[playerid][Time3], pName);
- mysql_query(cH, query); // 1 = conectionHandle
- return 1;
- }
- public OnFilterScriptInit()
- {
- print("\n--------------------------------------");
- print("Load mysql level time system by sRk7.");
- print("-------------------------------------\n");
- cH = mysql_connect("127.0.0.1", "root", "tutorial", "", 3306, true, 2);
- return 1;
- }
- CMD:mytime(playerid, params[])
- {
- new time[128];
- format(time, 128, "Ai: %i ore %i minute %i secunde", Player[playerid][Time1], Player[playerid][Time2], Player[playerid][Time3]);
- SendClientMessage(playerid, -1, time);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement