| FrostSurf |
08-22-2015 18:24 |
How to store information in a database.
This plugin only stores information until map change. Am i able to make it store the information in my MySQL database so it saves it forever ?
Code:
public OnMapStart()
{
for (new i = 0; i < MAX_LEVEL-1; i++)
{
for (new client = 1; client < MAXPLAYERS; client++)
{
g_MapLevelBestTime[i][client] = 0.0;
}
}
}
public OnClientStartTouchLevel(client, level, lastlevel)
{
PrintTimeDiff(client, level, lastlevel);
}
public OnClientStartTouchBonusLevel(client, level, lastlevel)
{
PrintTimeDiff(client, level, lastlevel);
}
stock PrintTimeDiff(client, level, lastlevel)
{
if(level == lastlevel+1)
{
new bool:enabled = false;
new Float:time;
new jumps;
new fpsmax;
new String:buffer[32];
Timer_GetClientTimer(client, enabled, time, jumps, fpsmax);
if(enabled)
{
if(g_MapLevelBestTime[level][client] == 0.0)
{
Timer_SecondsToTime(time, buffer, sizeof(buffer), 2);
#if defined LEGACY_COLORS
CPrintToChat(client,"{red}[{green}Timer{red}]{green} Checkpoint {red}[{green}-00:00.00{red}]");
#else
#endif
g_MapLevelBestTime[level][client] = time;
}
else if(g_MapLevelBestTime[level][client] > time)
{
Timer_SecondsToTime(g_MapLevelBestTime[level][client]-time, buffer, sizeof(buffer), 2);
#if defined LEGACY_COLORS
CPrintToChat(client, "{red}[{green}Timer{red}]{green} Checkpoint {red}[{green}-%s{red}]", buffer);
#else
#endif
g_MapLevelBestTime[level][client] = time;
}
else if(g_MapLevelBestTime[level][client] == time)
{
#if defined LEGACY_COLORS
CPrintToChat(client, "{red}[{green}Timer{red}]{green} Checkpoint {red}[+00:00.00]");
#else
#endif
}
else if(g_MapLevelBestTime[level][client] < time)
{
Timer_SecondsToTime(time-g_MapLevelBestTime[level][client], buffer, sizeof(buffer), 2);
#if defined LEGACY_COLORS
CPrintToChat(client, "{red}[{green}Timer{red}]{green} Checkpoint {red}[+%s]", buffer);
#else
#endif
}
}
}
}
|
