Error pages on my home page ?

mrix · Client Joined: Dec 04, 2004 Posts: 490

Hello all, I unistalled a flash games module on my website, but now appears errors at the top of my fron page showing this..

Table nuke_flashgames_activeusers' doesn't exist
Table nuke_flashgames_activeusers' doesn't exist
Table nuke_flashgames_activeusers' doesn't exist
Table nuke_flashgames_activeusers' doesn't exist

I have deleted all the flash games tables in phpmyadmin etc but these errors are still on my home page still ?

cheers for any help
mrix

jakec · Posted: Thu Feb 21, 2008 6:54 am

It looks like some code somewhere is still trying to calling the flash games module.

Did you have to do any edits to the core files when you installed the module?

mrix · Client Joined: Dec 04, 2004 Posts: 490

Hello I have had to re-upload the tables again to stop the error apearing and yes come to think of it I did have to edit some files.. thanks for the idea I`ll get looking for changes now!
cheers
mrix

tinkertrain · New Member Joined: Apr 10, 2008 Posts: 8

Hi i am having this same problem can you please tell what you did to fix the problem ??

mrix · Client Joined: Dec 04, 2004 Posts: 490

To be honest I didnt fix it, I sql`ed the old tables back up in phpmyadmin so they didnt show as an error.
cheers
mrix

tinkertrain · New Member Joined: Apr 10, 2008 Posts: 8

i am also getting this too and i did not have this problem with php nuke at all when clantheme re did my site they put raven nuke on it so im getting that now and this

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in / *EDITED BY ADMIN* /htdocs/includes/sql_layer.php on line 238
Table 'dataname_install_120131222222.nuke_flashgames_activeusers' doesn't exist

tinkertrain · New Member Joined: Apr 10, 2008 Posts: 8

i tried that ,,I uninstalled all the old one a reuploaded them all still getting the same thing Sad

i even drop all the old ones in mysql

bumed out dude
this is the last thing i have to put on my page lol I new it would not go smooth lol can any one else help with this ??

jakec · Posted: Fri Apr 11, 2008 12:25 am

When is this message appearing? Any particular module, or just all the time?

tinkertrain · New Member Joined: Apr 10, 2008 Posts: 8

All the time and it shows up on the front page everyone can see it

there is a big space between the blocks then that messege but the flash games work fine even with that but tha code is showing up right smack in the middle of the site

that is not the data base name i changed it so no one could see it on here,, or the install number .. i have installed it over and over agian driving me nuts lol cuz i had itr working fine on 7.8 php then 8.0 this is a big thing on my site kids love them flash games do you want the site ?
thank you for answering me i hope you can help

Oh wait''''' its not showing up in modules when i put up the center block on the webpage that when it shows up and i need that block in the center

mrix · Client Joined: Dec 04, 2004 Posts: 490

The " Table nuke_flashgames_activeusers' doesn't exist " could this be to do with a bug when you update. I had a user glitch the other day and run a script to sort the users out which fixed the problem. not sure where I got it from but its a known script.
cheers
mrix

tinkertrain · New Member Joined: Apr 10, 2008 Posts: 8

i think its the block block-FlashGames_Arcade.php it is only the one block i need,, all the rest of the blocks are working fine i think the block need to be re done some how,, i dont know scripts so i dont know how to do this something needs to be takeing out or added to this block all the game are working fine no error what so ever its just that d*** main block,,,,,
some thing in that block is conflicting with the raven nuke files:::

well so what you are saying is that its not reading the users on our Site ??

Could it bee Sentinel i dont know i,m confused

mrix · Client Joined: Dec 04, 2004 Posts: 490

no what um saying it there can be a general glitch where the normal users dont get updated right. And there was a script around that rectifies this.
So it got me thinking that maybe as the games uses the normal users maybe thats where the problem lies maybe. so if you run the repair checker script it maybe worth a go.
cheers
mrix

Guardian2003 · Posted: Fri Apr 11, 2008 1:27 pm

@ mrix - so you are all working now?
You mention the error showing between blocks? You might want to check header.php, footer.php and mainfile.php as it is likely calling something due to file edits you did to install the module.

@ itnkertrain - please copy the code from the block into a plain text file and post a link to the text file here, someone may be able to help.

tinkertrain · New Member Joined: Apr 10, 2008 Posts: 8

Code:

<?php
/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* pnFlashGames for PHPNUKE BLOCK */
/* Copyright (c) 2005 by Kent Patfield */
/* http://www.xbox-hq.com */
/* */
/* Note: If you need more than one flash games block, just copy this */
/* file with another name */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
if (eregi("block-FlashGames-Arcade.php",$_SERVER[PHP_SELF])) {
Header("Location: ../index.php");
die();
}

$usemarquee = 1;
$module_name = "Flash_Games";

global $prefix, $db, $dbi, $nukeurl;

// select random game code
$numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_flashgames_games"));
if ($numrows>1) {
$numrows = $numrows-1;
mt_srand((double)microtime()*1000000);
$bannum = mt_rand(0, $numrows);
} else {
$bannum = 0;
}

$content .= "<table width=\"100%\" border=0><tr><td width=\"33%\" align=center>";
$content .= "  Random Game: <center>";
// Latest Games

$a = 1;
$result = sql_query("select gid, gname, gdescription, gimage, hits from ".$prefix."_flashgames_games LIMIT $bannum,1", $dbi);
while(list($gid, $gname, $gdescription, $gimage, $hits) = sql_fetch_row($result, $dbi)) {
$ggid = ereg_replace("_", " ", $gid);
$gname = ereg_replace("_", " ", $gname);
$gimage = $gimage;
$gdescription = ereg_replace("_", " ", $gdescription);
$ghits = ereg_replace("_", " ", $hits);
 $content .= "<a href=\"modules.php?name=$module_name&func=play&gid=$gid\"><img src=\"modules/$module_name/images/screenshot/$gimage\" width=\"100\ height\"100\" border=0 alt=\"$gdescription\"></a> $gname ";
 $a++;



}
$content .= "High Score set by: ";

$result = sql_query("select gid, gamename, playername, playerscore, date from ".$prefix."_flashgames_hiscores WHERE gid=$ggid order by playerscore DESC limit 0,1", $dbi);
while(list($gid, $gamename, $playername, $playerscore, $date) = sql_fetch_row($result, $dbi)) {
$date = date("F j, Y",$date);
$content .= "<center><img src=\"modules/$module_name/images/stats/icon_award_gold.gif\">$playername $date [Score: $playerscore] ";
}
$content .= " This game has been played $ghits times.";

$content .= "</td><td width=\"33%\" align=center>";
$content .= "  Latest Games: <center>";
// Latest Games
if ($usemarquee == 1) {
$content .= "<Marquee Behavior=\"Scroll\" Direction=\"up\" Height=\"240\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"> ";
}
$a = 1;
$result = sql_query("select gid, gname, gdescription, gimage, hits from ".$prefix."_flashgames_games order by gid DESC limit 0,5", $dbi);
while(list($gid, $gname, $gdescription, $gimage, $hits) = sql_fetch_row($result, $dbi)) {
$gname = ereg_replace("_", " ", $gname);
$gimage = $gimage;
$gdescription = ereg_replace("_", " ", $gdescription);
 $content .= "<center><a href=\"modules.php?name=$module_name&func=play&gid=$gid\"><img src=\"modules/$module_name/images/screenshot/$gimage\" width=\"100\ height\"100\" border=0 alt=\"$gdescription\"></a> $gname ";
 $a++;
}
$content .= "</td>";
$content .= "<td width=\"33%\" align=\"center\">";

// Most Popular Games
$content .= "Most Popular Games: ";
if ($usemarquee == 1) {

 $content .= "<Marquee Behavior=\"Scroll\" Direction=\"up\" Height=\"240\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"> <center>";
}
$a = 1;
$result = sql_query("select gid, gname, gscore, gratings, hits from ".$prefix."_flashgames_games order by hits DESC limit 0,10", $dbi);
while(list($gid, $gname, $gscore, $gratings, $hits) = sql_fetch_row($result, $dbi)) {
$gname = ereg_replace("_", " ", $gname);
 $score = $gscore;
$ratings = $gratings;
if ($ratings != 0) {
$rate = substr($score / $ratings, 0, 4);
$r_image = round($rate);
if ($r_image == 1) {
 $the_image = "<img src=\"images/articles/stars-1.gif\" border=\"0\" alt=\"$gamename "._FGAMES_1STAR."\">";
} elseif ($r_image == 2) {
 $the_image = "<img src=\"images/articles/stars-2.gif\" border=\"0\" alt=\"$gamename "._FGAMES_2STAR."\">";
} elseif ($r_image == 3) {
 $the_image = "<img src=\"images/articles/stars-3.gif\" border=\"0\" alt=\"$gamename "._FGAMES_3STAR."\">";
} elseif ($r_image == 4) {
 $the_image = "<img src=\"images/articles/stars-4.gif\" border=\"0\" alt=\"$gamename "._FGAMES_4STAR."\">";
} elseif ($r_image == 5) {
 $the_image = "<img src=\"images/articles/stars-5.gif\" border=\"0\" alt=\"$gamename "._FGAMES_5STAR."\"> ";
}
}
 $content .= " $a- <a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$gname</a>     [Played: $hits times] $the_image ";
 $a++;
}
$content .= "</td>";
$content .= "</tr></table>";
$content .= " <center>5 Latest Hi-Scores</center> ";
$content .= "<table width=\"100%\" border=0><tr><td width=\"20%\">";
$content .= "Game</td><td width=\"20%\">Username</td><td width=\"20%\">Score</td><td width=\"20%\">Date";
$content .= "</td></tr></table>";
$content .= "<table width=\"100%\" border=0>";

$result = sql_query("select gid, gamename, playername, playerscore, date from ".$prefix."_flashgames_hiscores order by date DESC limit 0,5", $dbi);
while(list($gid, $gamename, $playername, $playerscore, $date) = sql_fetch_row($result, $dbi)) {
$gid = ereg_replace("_", " ", $gid);
$gamename = ereg_replace("_", " ", $gamename);
$date = ereg_replace("_", " ", $date);
$date = date("F j, Y",$date);
$playerscore = ereg_replace("_", " ", $playerscore);
$playername = ereg_replace("_", " ", $playername);
$content .= "<tr><td width=\"20%\"><a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$gamename</a></td><td width=\"20%\"><img src=\"modules/$module_name/images/stats/icon_member.gif\">$playername</td><td width=\"20%\">$playerscore</td><td width=\"20%\">$date</td></tr>";
}
$content .= "</table>";
$content .= " <center>Detailed Statistics</center> ";
$content .= "<table width=\"100%\" border=0><tr>";
$result = sql_query("select gid, gname, hits from ".$prefix."_flashgames_games order by hits DESC limit 0,1", $dbi);
while(list($gid, $gname, $hits) = sql_fetch_row($result, $dbi)) {
$gid = ereg_replace("_", " ", $gid);
$gamename = ereg_replace("_", " ", $gname);
$ghits = ereg_replace("_", " ", $hits);
$content .= "<td width=\"50%\" align=\"center\">Most Popular: <a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$gamename</a> with <a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$ghits</a> plays</td>";
}
$result = sql_query("select gid, gname, hits from ".$prefix."_flashgames_games order by hits ASC limit 0,1", $dbi);
while(list($gid, $gname, $hits) = sql_fetch_row($result, $dbi)) {
$gid = ereg_replace("_", " ", $gid);
$gamename = ereg_replace("_", " ", $gname);
$ghits = ereg_replace("_", " ", $hits);
$content .= "<td width=\"50%\" align=\"center\">Least Popular: <a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$gamename</a> with <a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$ghits</a> plays</td>";
}
// Total Downloads
$result = sql_query("select gid, gname,hits from ".$prefix."_flashgames_games", $dbi);
while(list($gid, $gname, $hits) = sql_fetch_row($result, $dbi)) {
$a = 1;
$total_hits = $total_hits + $hits;
$a++;
}
$total_served = $total_hits;

$content .= "</tr></table>";

$content .= "<table width=\"100%\" border=0><tr><td width=\"33%\" align=\"center\">";

// Total Games in Database
$result = sql_query("select * from ".$prefix."_flashgames_games", $dbi);
$games = sql_num_rows($result, $dbi);

// Total comments in Database
$result = sql_query("select * from ".$prefix."_flashgames_comments", $dbi);
$comments = sql_num_rows($result, $dbi);

$result = sql_query("select * from ".$prefix."_flashgames_activeusers WHERE module='$module_name'", $dbi);
$activemembers = sql_num_rows($result, $dbi);

$content .="<a href=\"http://www.xbox-hq.com/html/modules.php?name=Flash_Games&refferer=$nukeurl\"><img src=\"modules/$module_name/images/powered/powered_xboxhq.gif\" border=0 alt=\"Xbox-Hq.Com - pnFlashGames module for PHPNUKE\"></a></td><td>";

$content .="<center><a href=\"modules.php?name=$module_name\">Browse Categories</a> ";

if ($activemembers >1){
$content .="<center><a href=\"modules.php?name=Flash_Games&func=ActiveGamers\">$activemembers</a> Active Gamer";
}else{

$content .="<center><a href=\"modules.php?name=Flash_Games&func=ActiveGamers\">$activemembers</a> Active Gamers";
}

// Games Available and Games Served
$content .= "<center>Games Available: $games Games Served: $total_served Comments Available:$comments <a href=\"modules.php?name=$module_name&func=ViewAll\">View All Games</a></center>";

$content .="</td><td><a href=\"http://pnflashgames.com/linkback.php?type=phpnuke?refferer=$nukeurl\"><img src=\"modules/$module_name/images/powered/powered_pnflashgames.gif\" border=0></a></td></tr></table>";
// Show all Categories
$content .= "<Marquee Behavior=\"Scroll\" Direction=\"Left\" Height=\"10\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"> ";
$content .= "";

$result = sql_query("select cid, cname, hits from ".$prefix."_flashgames_cat order by cid ASC", $dbi);
while(list($cid, $cname, $hits) = sql_fetch_row($result, $dbi)) {
$cid = ereg_replace("_", " ", $cid);
$cname = ereg_replace("_", " ", $cname);
$chits = ereg_replace("_", " ", $hits);

$content .= "<a href=\"modules.php?name=Flash_Games&func=view&cid=$cid\">$cname</a> - ";
}
$content .= "";

?>

tinkertrain · New Member Joined: Apr 10, 2008 Posts: 8

No every thing else but this one block is working and its the one we need lol how do i run the script fix i pretty new at this stuuf if you cant tell lol

tinkertrain · New Member Joined: Apr 10, 2008 Posts: 8

I think im about ready to give up on the flash games they dont seem to be working right with raven;s nuke now im getting this error too

Warning: main(modules/admin/admin/language/lang-english.php) [function.main]: failed to open stream: No such file or directory in /hermes/web04/b2002/pow.XXXXXx/htdocs/admin/case/case.php on line 40

Warning: main() [function.include]: Failed opening 'modules/admin/admin/language/lang-english.php' for inclusion (include_path='.:/usr/local/lib/php-4.4.7/lib/php') in /hermes/web04/b2002/pow.XXXXXXX/htdocs/admin/case/case.php on line 40

do you guys have a eazy compatable flash game program that i can use easy to install and set up ?

Susann · Posted: Sat Jul 12, 2008 6:11 am

tinkertrain wrote:

do you guys have a eazy compatable flash game program that i can use easy to install and set up ?

I´m also looking for a newer and compatible version of flashgames wich I can use in RavenNuke because my own flashgames are for nuke 6 +.

dad7732 · Worker Joined: Mar 18, 2007 Posts: 218

The way to eliminate (easiest) the error is to determine which core files were modified for flash_games and then re-upload those original core files from the distro package. Then drop the tables.

The only "however" to this is IF you modified those same core files for other modules/blocks/whatever. In that case you will have to do a reverse-edit to take out the mods for flash_games. If you did a backup of the core files in question then you're pretty much in good shape, just rename 'em back to the original filename(s) prior to the flash_games edits.

Susann · Posted: Sat Jul 12, 2008 9:47 am

Thanks for the info but I don´t have an visible error. My module works since 3 years its just old and I´m looking for something newer without a high score list.
Maybe I use MiniClip instead.

dad7732 · Worker Joined: Mar 18, 2007 Posts: 218

Sorry, I should have specified that I was addressing "mrix" and "tinkertrain" with the error issue.

Cheers

Guardian2003 · Posted: Sat Jul 12, 2008 11:44 am

Code:

Warning: main(modules/admin/admin/language/lang-english.php) [function.main]: failed to open stream: No such file or directory in /hermes/web04/b2002/pow.XXXXXx/htdocs/admin/case/case.php on line 40

Warning: main() [function.include]: Failed opening 'modules/admin/admin/language/lang-english.php' for inclusion (include_path='.:/usr/local/lib/php-4.4.7/lib/php') in /hermes/web04/b2002/pow.XXXXXXX/htdocs/admin/case/case.php on line 40

Something looks wrong there the file paths are all wrong.
I recommend you re-install the script onto virgin files.
There should not be a directory modules/admin/admin/