Problem with RASP after Trackswitch

This forum is dedicated to the Aseco/Rasp 2 server records and control script by Flo and Assembler Maniac. Announcements and issues can be discussed in this forum.

Moderators: Flo, Assembler Maniac, f*ckfish, TM-Patrol

Post Reply
thebigguyconnor
cyclist
cyclist
Posts: 39
Joined: 25 Jun 2008 21:10
Owned TM-games: TMN TMU TMNF TMUF
Manialink(s): uns

Problem with RASP after Trackswitch

Post by thebigguyconnor » 12 Feb 2009 02:12

I get this in my logfile after a trackswitch - every time - sometimes if there's more than 4 users then all the users get disconnected.

Notice how after "Registering vote...." the users lose connection (because the problem in the RASP Syntax is somehow caused by saving the Karma - my friend says that when this happens, it gives you the dialog box that comes up in-game says what it says when you leave a server, and the people that it says are joining are actually people trying to get back on - but they can't for a few minutes... :shock:

Code: Select all

[02/11,19:54:37] [Lottery]Server has 1622 coppers left. the_alaskan won 20 coppers.
|...Calculating ranks
|...Done!
{RASP Jukebox} Setting Next Challenge to Ghost Driver $z(Island)
[02/11,19:54:39] [LocalDb] arturo won for the 2. time!
Registering vote....
[Autotime] Track=Ghost Driver, time=05:27.80, AuthorTime=00:59.39
[02/11,19:54:57] map changed [F1 Island Cross] >> [Ghost Driver]
[RASP Karma Error] Failed to select karma.  Error text=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
sql=Select goodkarma, badkarma from challenges WHERE Id=
[02/11,19:54:58] currently no record on Ghost Driver
[02/11,19:55:26] >> player 192 left the game [the_alaskan]
[02/11,19:55:27] >> player 188 left the game [correction_fluid]
[02/11,19:55:28] >> player 189 left the game [x530i]
[02/11,19:55:31] >> player 190 left the game [arturo]
[02/11,19:55:33] << player 186 joined the game [the_alaskan]
[02/11,19:55:40] >> player 200 left the game [thekunadiun]
[02/11,19:55:44] << player 185 joined the game [x530i]
[02/11,19:55:46] >> player 187 left the game [zac_co]
[02/11,19:55:55] << player 184 joined the game [zac_co]
[02/11,19:56:03] >> player 186 left the game [the_alaskan]
[02/11,19:56:08] << player 183 joined the game [dlimes13]
[02/11,19:56:12] << player 182 joined the game [the_alaskan]
[02/11,19:56:17] >> player 185 left the game [x530i]
[02/11,19:56:34] >> player 184 left the game [zac_co]
[02/11,19:56:41] << player 181 joined the game [zac_co]
[02/11,19:56:44] << player 180 joined the game [x530i]
[02/11,19:57:13] >> player 181 left the game [zac_co]
[02/11,19:57:16] >> player 180 left the game [x530i]
[02/11,19:57:22] << player 179 joined the game [zac_co]
[02/11,19:59:28] player 183 finished with 01:54.71 and took the 1. WR place!
Registering vote....
[02/11,20:00:44] >> player 179 left the game [zac_co]
[02/11,20:00:46] player 183 finished with 01:15.12 and took the 1. WR place!
[02/11,20:00:49] player 217 finished with 01:17.40 and took the 2. WR place!
[LocalDB] Transferring records to local database ...
 Done!
|...Calculating ranks
|...Done!
And then by end of round there was only 2 people online - me and dlimes13.

Any help on stuff to change???

Thanks

Aspie/Connor

thebigguyconnor
cyclist
cyclist
Posts: 39
Joined: 25 Jun 2008 21:10
Owned TM-games: TMN TMU TMNF TMUF
Manialink(s): uns

Re: Problem with RASP after Trackswitch

Post by thebigguyconnor » 12 Feb 2009 14:01

Hi again, in my plugin.rasp_karma.php I think this text may be messing things up, not sure though:

Code: Select all

	function getKarmaValues(&$challenge)
		{
		$query = 'Select goodkarma, badkarma from challenges WHERE Id=' . $challenge->data['DB_ID'];
		$res = mysql_query($query);
		if ( !$res )					// mysql_query returns false if there was an error
			{
			$errmsg = '[RASP Karma Error] Failed to select karma.  Error text=' . mysql_error() . CRLF . 'sql=' . $query;
			$this->Aseco->console_text($errmsg);
			return;
			}
So, this is both the part of the script that is causing the error, and as you can see, the error message written in the log also.

Thanks

Connor/Aspie

Post Reply