Posted: Wed Nov 16, 2005 2:58 pm Post subject: Arcade Block sql error
I just downloaded the pnflashGames 0.06 (free version) and installed it on phpnuke 7.8.0.3.1. Works like a charm, Howeverm, there is a problem in the arcade game block. It referres to nuke_flashgame_activeusers table which I do not have. I had to use // to block the 2 lines it referred to , to get rid of the error. The install did not set up that table. Do I need that table and where would I get the sql for it??
Joined: May 22, 2003 Posts: 23945 Location: NSW, Australia
Posted: Wed Nov 16, 2005 3:26 pm Post subject:
hi sandman,
Quote:
I just downloaded the pnflashGames 0.06 (free version) and installed it on phpnuke 7.8.0.3.1. Works like a charm, Howeverm, there is a problem in the arcade game block. It referres to nuke_flashgame_activeusers table which I do not have. I had to use // to block the 2 lines it referred to , to get rid of the error. The install did not set up that table. Do I need that table and where would I get the sql for it??
All you have to do is open the block in a text editor and look for this line of code near the top:
Code:
$result = sql_query("select * from ".$prefix."_flashgames_activeusers WHERE module='$module_name'", $dbi);
$activemembers = sql_num_rows($result, $dbi);
DELETE THAT CODE..
If you have done this it should remove your error.
always keep a backup copy of anything before you edit.
If you want ACTIVE USERS just donate to become a VIP MEMBER and download the latest version with lots more features.. especially for those people who donate towards this evolving project.
That's odd. I commented out this code myself due to the "Active Gamers" not showing anything..no error, just blank. When I did that, it actually started working. I now have a number of active gamers here.
No problem really..I thought it was odd. I'm using the freebie version myself.
|
All times are GMT |Page 1 of 1
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum