Can anyone find what I did wrong here?

Discussion in 'PHP' started by Grimmfang, Feb 26, 2011.

  1. #1
    I'm trying to convert:
    $pop = '<div><u>Popular Games</u></div><div>';
    
    $sql->mySQLresult = @mysql_query("SELECT game_id, game_filename, game_title, game_category, game_description, date_added, times_played, round((times_played / ((".(time())." - date_added)/86400)),2) as popularity FROM ".MPREFIX."arcade_games WHERE game_enable=1".$rest." ORDER BY times_played DESC LIMIT 0, 3");
    $rows = $sql->db_Rows();
    
    for ($i = 0; $i < $rows; $i++) {
    	$row = $sql->db_Fetch();
    
    	$pop .= "<br/><a style=\"text-decoration: none;\" href='play.php?catid=".$row['game_category']."&gameid=".$row['game_id']."'><img width='60' height='60' src='".e_PLUGIN."kroozearcade_menu/games/".$row['game_filename'].".gif'><br>".$row['game_title']."</a><br/>";
    
    }
    
    $pop .= "</div>";
    
    // DISPLAY IT
    echo '<p><br/></p><div style="float: left;">'.$info.'</div><div style="text-align:center; font-size:75%">'.$pop.'</div><div style="clear:both;"></div>';
    PHP:
    Into:
    <?php
    
    // Menu for printing out highly rated games
    
    
    if(file_exists(e_PLUGIN."kroozearcade_menu/language/".e_LANGUAGE.".php")){
    	require_once(e_PLUGIN."kroozearcade_menu/language/".e_LANGUAGE.".php");
    }
    else{
    	require_once(e_PLUGIN."kroozearcade_menu/language/English.php");
    }
    
    // GET CATEGORIES USER IS ALLOWED TO SEE
    $sql->mySQLresult = @mysql_query("SELECT category_userclass, cat_id FROM ".MPREFIX."arcade_categories");
    $catrows = $sql->db_Rows();
    
    $rest = "";
    for ($i = 0; $i < $catrows; $i++) {
    	$row = $sql->db_Fetch();
    
    	if ($row['category_userclass'] == e_UC_ADMIN) {
    		if (!ADMIN) {
    		$display = "NO"; // Not in userclass so dont display
    		$rest1 = "game_category != ".$row['cat_id'];
    		} else {
    		$display = "YES";
    		}
    	} elseif ($row['category_userclass'] == e_UC_MEMBER) {
    		if (!USER) {
    		$display = "NO";
    		$rest1 = "game_category != ".$row['cat_id'];
    		} else {
    		$display = "YES";
    		}
    	} elseif ($row['category_userclass'] == 255) {
    		$rest1 = "game_category != ".$row['cat_id'];
    		} elseif ($row['category_userclass'] == '' || $row['category_userclass'] == 0) {
    		$display = "YES";
    	} else {
    		$userc = @mysql_query("SELECT user_class FROM ".MPREFIX."user WHERE user_id='".USERID."'");
    		$userc = mysql_fetch_array($userc);
    		$break = explode(",", $userc['user_class']);
    
    		if (!in_array($row['category_userclass'], $break)) {
    		$display = "NO";
    		$rest1 = "game_category != ".$row['cat_id'];
    		} else {
    		$display = "YES";
    		}
    	}
    
    	if ($display != YES) {
    	$rest .= " AND ".$rest1;
    	}
    }
    
    $sql->mySQLresult = @mysql_query("SELECT game_id, game_filename, game_title, game_category, game_description, date_added, times_played, round((times_played / ((".(time())." - date_added)/86400)),2) as popularity FROM ".MPREFIX."arcade_games WHERE game_enable=1".$rest." ORDER BY times_played DESC LIMIT 0, 3");
    $rows = $sql->db_Fetch();
    $text = "<br/><a style=\"text-decoration: none;\" href='play.php?catid=".$row['game_category']."&gameid=".$row['game_id']."'><img width='60' height='60' src='".e_PLUGIN."kroozearcade_menu/games/".$row['game_filename'].".gif'><br>".$row['game_title']."</a><br/>";
    
    $title = KROOZEARCADE_MENU_12;
    $ns -> tablerender($title, $text);
    ?>
    
    PHP:
    All that is output in the menu is a broken image, along with a broken url link. What did I do wrong?
     
    Last edited: Feb 26, 2011
    Grimmfang, Feb 26, 2011 IP
  2. eleetgeek

    eleetgeek Peon

    Messages:
    129
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    use the following :

    $text = "<a style=\"text-decoration: none;\" href=\"play.php?catid=$row['game_category']&gameid=$row['game_id']\"><img width='60' height='60' src=".e_PLUGIN."kroozearcade_menu/games/".$row['game_filename']."gif><br>$row['game_title']"</a>
    PHP:

    and also tell what you get as display :)
     
    eleetgeek, Mar 7, 2011 IP
  3. Grimmfang

    Grimmfang Member

    Messages:
    191
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    30
    #3
    didnt work at all just printed out an error
     
    Grimmfang, Mar 9, 2011 IP
  4. eleetgeek

    eleetgeek Peon

    Messages:
    129
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    What was the error? Please paste it here.

    This is and if any error, print it here.
     
    eleetgeek, Mar 9, 2011 IP