How to store information in a database.

FrostSurf · **Author**

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
			}
		}
	}
}