Thread: Fatal Error...
View Single Post
  #8  
Old 11-09-2011, 03:37 PM
Tequila's Avatar
Tequila Tequila is offline
The Grim One
 
Join Date: Jan 2009
Location: Souther Tier, New York State
Posts: 1,356
Gender: Female
Credits: 99,359
Tequila is on a distinguished road
Default

I may just code the card page similar to the profile page. It'll work.

Now I just have to finish integrating the login portion to the rest of the site.

Edit
So I changed the way I want this to work, and have made my own version of profile.php to display cards.
It doesn't quite work...
http://crystalhollow.com/cards.php?deck=goodluckcharms

Any ideas where to fix this?
PHP Code:
<?php

include("inc/functions.php");
include(
"inc/bbcode.php");

//***************//
//  START SCRIPT //
//***************//

// Card Page Modification

$deck $_GET["deckname"];
$page $_GET["page"];

if(
$deck != "")
{

    
// We have specified a deck to view.
    // See if the user exists...

    
$query "SELECT * FROM {$prefix}cards WHERE deckname = '{$deck}'";
    
$result runquery($query);
    
$row mysql_fetch_array($result);

    if(
$row['deckname'] == $deck)
    {

        
$article_title "{$row['deckname']}";
$article_content "<p>{$row['deckdescription']}</p>
<center>
<img src='cards/
{$row['deckname']}01.png' /><img src='cards/{$row['deckname']}02.png' /><img src='cards/{$row['deckname']}03.png' /><img src='cards/{$row['deckname']}04.png' /><img src='cards/{$row['deckname']}05.png' /><br />
<img src='cards/
{$row['deckname']}06.png' /><img src='cards/{$row['deckname']}07.png' /><img src='cards/{$row['deckname']}08.png' /><img src='cards/{$row['deckname']}09.png' /><img src='cards/{$row['deckname']}10.png' />
<br /><img src='cards/
{$row['deckname']}11.png' /><img src='cards/{$row['deckname']}12.png' /><img src='cards/{$row['deckname']}13.png' /><img src='cards/{$row['deckname']}14.png' /><img src='cards/{$row['deckname']}15.png' />
</center>"
;

$article_content .= "</table><img src='cards/{$row['deckname']}-master.png' style='float:left;'/><p>The following users have mastered this deck.</p><p>{$row['deckmasters']}</p>";
}
    else
    {
        
        
// Not a deck

        
$article_title "Error!";
        
$article_content "Sorry but there is not a deck available under that name. Please try again.";
 
    }

}
else
{

    
// We did not specify a deck, so show the card list

$article_title "Decks to Collect";
$article_content "<table cellpadding='0' cellspacing='0' width='100%'>
<tr><th class='head'>deck name</th><th class='head'>description</th><th class='head'>class</th></tr>"
;

    
$query "SELECT COUNT(*) as cards FROM {$prefix}cards ORDER BY deckname ASC";
    
$result runquery($query);
    
$total mysql_fetch_array($result);

    
$rowsperpage 50;
    
$totalpages ceil($total['cards'] / $rowsperpage);

    if(
is_numeric($page))
    {
        
$currentpage $page;
    }
    else
    {
        
$currentpage 1;
    }
    if(
$currentpage $totalpages
    {     
        
$currentpage $totalpages;  
    }
    if(
$currentpage 1
    {    
        
$currentpage 1;  
    } 
    
$offset = ($currentpage 1) * $rowsperpage;  

    
$query "SELECT * FROM {$prefix}cards ORDER BY deckname ASC LIMIT {$offset}{$rowsperpage}";
    
$result runquery($query);

while (
$row mysql_fetch_array($result)) 


$article_content .= "<tr><td class='row'><a href='cards.php?deck={$row['deckname']}'>{$row['deckname']}</a></td><td class='row'>{$row['deckdescription']}</td><td class='row'>{$row['deckclass']}</td></tr>
"
;




$article_content .= "</table><br />";
    if(
$currentpage 1
    {
        
$newpage $currentpage 1;
        
$article_content .= "<strong><a href='profile.php?page={$newpage}'><img src='templates/icons/prev.gif' border=0> Previous Page</a></strong> ";
    }
    else
    {
        
$article_content .= "<strong><img src='templates/icons/prev.gif' border=0> Previous Page</strong> ";
    }
    if(
$currentpage $totalpages
    {
        
$newpage $currentpage 1;
        
$article_content .= " ::  <strong><a href='profile.php?page={$newpage}'>Next Page <img src='templates/icons/next.gif' border=0></a></strong> ";
    }
    else
    {
        
$article_content .= " ::  <strong>Next Page <img src='templates/icons/next.gif' border=0></strong>";
    }

}

//***************//
//  OUTPUT PAGE  //
//***************//

echo showpage($article_title$article_content$date);

?>
__________________
Artist. Designer. Gamer. Mother.
[portfolio] [tarot] [Rune Hollow] [freebies]

Last edited by Tequila; 11-09-2011 at 05:43 PM.
Reply With Quote