SQL peak players HELP

[Yami]

Hi, I need help with one of my SQL script that's linked to my server's website. It grabs Peak Players from SQL then send the info to my website. I used it way back around 2+ years ago but it seems that it's not working anymore the SQL query is not getting created by the script . Can anyone help me to get this script to work again?

 

Here's the script

//Highest Peak
-	script	Highest Peak	-,{

OnPCLoginEvent:
	

	set .currentUsersOL,getusers(1); //Current Online Users
	
	//Query for the highest peak in the database
	query_sql("SELECT `num_users` FROM `cp_highest_peak` ORDER BY `num_users` LIMIT 1",.@numUsers);
	//Get the date
	set .date$,gettime(7)+"-"+gettime(6)+"-"+gettime(5);	
	
	set .highestPeak,.@numUsers[0]; //Highest Peak
	if(getarraysize(.@numUsers) == 0)
	{
		//If not data found Insert statement
		set .highestPeak,.currentUsersOL;
		query_sql("INSERT INTO `cp_highest_peak`(num_users,peak_date) VALUES("+.highestPeak+",'"+.date$+"')"); //Insert new highest Peak
	}
	else
	{
		if(.currentUsersOL>.highestPeak)
		{
			set .highestPeak,.currentUsersOL;		
			query_sql("UPDATE `cp_highest_peak`SET num_users='"+.highestPeak+"',peak_date='"+.date$+"'"); //Insert new highest Peak
		}
	}
end;

}

 

Thank you in advance!

[Chaos92]

24 minutes ago, Yami said:

Hi, I need help with one of my SQL script that's linked to my server's website. It grabs Peak Players from SQL then send the info to my website. I used it way back around 2+ years ago but it seems that it's not working anymore the SQL query is not getting created by the script . Can anyone help me to get this script to work again?

 

Here's the script

//Highest Peak
-	script	Highest Peak	-,{

OnPCLoginEvent:
	

	set .currentUsersOL,getusers(1); //Current Online Users
	
	//Query for the highest peak in the database
	query_sql("SELECT `num_users` FROM `cp_highest_peak` ORDER BY `num_users` LIMIT 1",.@numUsers);
	//Get the date
	set .date$,gettime(7)+"-"+gettime(6)+"-"+gettime(5);	
	
	set .highestPeak,.@numUsers[0]; //Highest Peak
	if(getarraysize(.@numUsers) == 0)
	{
		//If not data found Insert statement
		set .highestPeak,.currentUsersOL;
		query_sql("INSERT INTO `cp_highest_peak`(num_users,peak_date) VALUES("+.highestPeak+",'"+.date$+"')"); //Insert new highest Peak
	}
	else
	{
		if(.currentUsersOL>.highestPeak)
		{
			set .highestPeak,.currentUsersOL;		
			query_sql("UPDATE `cp_highest_peak`SET num_users='"+.highestPeak+"',peak_date='"+.date$+"'"); //Insert new highest Peak
		}
	}
end;

}

 

Thank you in advance!

it should already inside github for FluxCP.

https://github.com/rathena/FluxCP/blob/master/data/npc/PeakNPC.txt

 

Run/load it in your npc folder.

[Yami]

16 minutes ago, Amir Azman said:

it should already inside github for FluxCP.

https://github.com/rathena/FluxCP/blob/master/data/npc/PeakNPC.txt

 

Run/load it in your npc folder.

I'm not sure if this script will connect to the one I have for my website tho

[Chaos92]

3 hours ago, Yami said:

I'm not sure if this script will connect to the one I have for my website tho

make sure u already installed fluxcp latest version or run this SQL

https://github.com/rathena/FluxCP/blob/master/data/schemas/charmapdb/cp_onlinepeak.20131120120201.sql

[Yami]

Thank you will try this ASAP!