Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
mrix
Client


Joined: Dec 04, 2004
Posts: 757

PostPosted: Thu Feb 21, 2008 3:29 am Reply with quote

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
 
View user's profile Send private message Visit poster's website
jakec
Site Admin


Joined: Feb 06, 2006
Posts: 3048
Location: United Kingdom

PostPosted: Thu Feb 21, 2008 6:54 am Reply with quote

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?
 
View user's profile Send private message
mrix
PostPosted: Thu Feb 21, 2008 6:57 am Reply with quote

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
New Member


Joined: Apr 10, 2008
Posts: 10

PostPosted: Thu Apr 10, 2008 3:59 pm Reply with quote

Hi i am having this same problem can you please tell what you did to fix the problem ??
 
View user's profile Send private message
mrix
PostPosted: Thu Apr 10, 2008 4:01 pm Reply with quote

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
PostPosted: Thu Apr 10, 2008 4:31 pm Reply with quote

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
PostPosted: Thu Apr 10, 2008 4:45 pm Reply with quote

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
PostPosted: Fri Apr 11, 2008 12:25 am Reply with quote

When is this message appearing? Any particular module, or just all the time?
 
tinkertrain
PostPosted: Fri Apr 11, 2008 1:00 am Reply with quote

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
PostPosted: Fri Apr 11, 2008 3:26 am Reply with quote

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
PostPosted: Fri Apr 11, 2008 10:46 am Reply with quote

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 Confused
 
mrix
PostPosted: Fri Apr 11, 2008 1:24 pm Reply with quote

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
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Fri Apr 11, 2008 1:27 pm Reply with quote

@ 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.
 
View user's profile Send private message Send e-mail
tinkertrain
PostPosted: Fri Apr 11, 2008 6:07 pm Reply with quote

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 .= "&nbsp;&nbsp;<b><u>Random Game</u></b>:<Br><br><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><br><B>$gname</b><br><Br>";
     $a++;
    
    

}
$content .= "<i>High Score set by</i>:<br><br>";

$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\"><b>$playername</b><br><i>$date</i><br>[Score: <b>$playerscore</b>]<br>";
}
$content .= "<br>This game has been played <b>$ghits</b> times.";

$content .= "</td><td width=\"33%\" align=center>";
$content .= "&nbsp;&nbsp;<b><u>Latest Games</u></b>:<br><br><center>";
// Latest Games
if ($usemarquee == 1) {
   $content .= "<Marquee Behavior=\"Scroll\" Direction=\"up\" Height=\"240\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"><br>";
}
$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><br><b>$gname</b><br><Br><br>";
     $a++;
}
$content .= "</td>";
$content .= "<td width=\"33%\" align=\"center\">";

// Most Popular Games
$content .= "<b><u>Most Popular Games</u></b>:<br><br>";
if ($usemarquee == 1) {
      
      $content .= "<Marquee Behavior=\"Scroll\" Direction=\"up\" Height=\"240\" ScrollAmount=\"2\" ScrollDelay=\"100\" onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\"><br><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 .= "&nbsp;$a- <a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$gname</a><br>&nbsp;&nbsp;&nbsp;&nbsp;[Played: <b>$hits</b> times]<br>$the_image<br><br>";
     $a++;
}
$content .= "</td>";
$content .= "</tr></table>";
$content .= "<br><center><b>5 Latest Hi-Scores</b></center><br>";
$content .= "<table width=\"100%\" border=0><tr><td width=\"20%\">";
$content .= "<i>Game</i></td><td width=\"20%\"><i>Username</i></td><td width=\"20%\"><i>Score</i></td><td width=\"20%\"><i>Date</i>";
$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\"><b>$playername</b></td><td width=\"20%\">$playerscore</td><td width=\"20%\">$date</td></tr>";     
      }
$content .= "</table>";
$content .= "<br><center><b>Detailed Statistics</b></center><br>";
$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><br><i>with <b><a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$ghits</a></b> plays</i></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><br><i>with <b><a href=\"modules.php?name=$module_name&func=play&gid=$gid\">$ghits</a></b> plays</i></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><br><Br>";

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

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

// Games Available and Games Served
$content .= "<center>Games Available: <b>$games</b><br>Games Served: <B>$total_served</b><br>Comments Available:<B>$comments</b><br><br><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()\"><br>";
$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
PostPosted: Fri Apr 11, 2008 6:38 pm Reply with quote

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
PostPosted: Sat Apr 12, 2008 4:12 pm Reply with quote

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
Moderator


Joined: Dec 19, 2004
Posts: 3191
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Sat Jul 12, 2008 6:11 am Reply with quote

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 +.
 
View user's profile Send private message
dad7732
RavenNuke(tm) Development Team


Joined: Mar 18, 2007
Posts: 1242

PostPosted: Sat Jul 12, 2008 9:23 am Reply with quote

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.
 
View user's profile Send private message
Susann
PostPosted: Sat Jul 12, 2008 9:47 am Reply with quote

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
PostPosted: Sat Jul 12, 2008 10:31 am Reply with quote

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

Cheers
 
Guardian2003
PostPosted: Sat Jul 12, 2008 11:44 am Reply with quote

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/
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
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 can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©