| rosepose |
03-12-2009 06:23 PM |
RE: Tables in myadoptables.php
PHP Code:
<?php
// Easy Adoptables Script by Brandon Rusnak
// Get our includes out of the way
include("inc/functions.php");
include("inc/levels.php");
include("inc/config.php");
include("inc/settings.php");
include("inc/nbbc.php"); // BBCODE Parser
$bbcode = new BBCode;
// Connect to our database
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql database!');
mysql_select_db($dbname);
//Set up our login info...
$username = "";
$password = "";
//Check for cookie
if (isset($_COOKIE['adoptu']) and isset($_COOKIE['adoptp'])){
$username = $_COOKIE['adoptu'];
$password = $_COOKIE['adoptp'];
$username = preg_replace("/[^a-zA-Z0-9\\040.]/", "", $username);
$password = preg_replace("/[^a-zA-Z0-9s]/", "", $password);
//Run login operation
$query = "SELECT * FROM users WHERE username = '$username'";
$result = mysql_query($query);
$num = mysql_numrows($result);
//Loop out code
$i=0;
while ($i < 1) {
$luser=@mysql_result($result,$i,"username");
$lpass=@mysql_result($result,$i,"password");
$i++;
}
if($username == $luser and $password == $lpass){
$isloggedin = "yes";
}
else{
if (isset($_COOKIE['adoptu'])){
$past = time() - 10;
setcookie("adoptu",$username,$past);
}
if (isset($_COOKIE['adoptp'])){
$past = time() - 10;
setcookie("adoptp",$password,$past);
}
$isloggedin = "no";
}
}
else
{
//User is not logged in
$isloggedin = "no";
}
// Define our Template File
$file = $current_theme;
// Get our content for the index page
if($isloggedin != "yes"){
//User cannot have any adoptables because they are a guest
$article_title = "Permission Denied";
$article_date = date('Y-m-d');
$article_content = "We're sorry, but guests cannot adopt creatures. Please <a href='login.php'>login</a> or <a href='register.php'>register</a> to get your very own free adoptable.";
}
else{
//User IS logged in...
$article_title = $username."'s Adoptables";
$article_date = date('Y-m-d');
$article_content = "This page shows all of your current adoptables. Here you can view their progress, level them up, generate
HTML and BBCODEs to show them off to your friends, and more!<br>
<table style='width: 580px' class='vamid'><tr><th>Picture</th><th>Name</th><th>Level</th><th>Get Code</th><th> </th><th>Kill</th><th>Level</th><th>Clicks</th></tr>";
//Begin looping out our data................
$query = "SELECT * FROM owned_adoptables WHERE owner = '$username'";
$result = mysql_query($query);
$num = mysql_numrows($result);
//Loop out code
$i=0;
while ($i < $num) {
$id=@mysql_result($result,$i,"uid"); // Adoptable ID
$name=@mysql_result($result,$i,"name");
$imageurl=@mysql_result($result,$i,"imageurl");
$currentlevel=@mysql_result($result,$i,"currentlevel");
$totalclicks=@mysql_result($result,$i,"totalclicks");
if($currentlevel == 0){
$neededclicks = $level1c - $totalclicks;
$neededclicks = $neededclicks + 1;
}
if($currentlevel == 1){
$neededclicks = $level2c - $totalclicks;
$neededclicks = $neededclicks + 1;
}
if($currentlevel == 3){
$neededclicks = $level2c - $totalclicks;
$neededclicks = $neededclicks + 1;
}
if($currentlevel == 4){
$neededclicks = $level3c - $totalclicks;
$neededclicks = $neededclicks + 1;
}
if($currentlevel == 5){
$neededclicks = $level4c - $totalclicks;
$neededclicks = $neededclicks + 1;
}
if($currentlevel == 6){
$neededclicks = $level5c - $totalclicks;
$neededclicks = $neededclicks + 1;
}
if($currentlevel == 7){
$neededclicks = $level6c - $totalclicks;
$neededclicks = $neededclicks + 1;
}
if($currentlevel == 8){
$neededclicks = $level7c - $totalclicks;
$neededclicks = $neededclicks + 1;
}
if($neededclicks == ""){
$neededclicks = 0;
}
if($neededclicks < 0){
$neededclicks = "0 (Max Level)";
}
//Begin our content output...
$article_content=$article_content."
<tr><td><img src='".$imageurl."' border='0'></td>
<td><b><u>".$name.":</u></b></td>
<td><a href='levelup.php?id=".$id."'>LevelUp</a></td>
<td><a href='manage.php?id=".$id."&action=bbcode'>Get Code</a></td>
<td> </td><td><a href='manage.php?id=".$id."&action=delete'>Kill</a></td>
<td><b> ".$currentlevel."</b> </td>
<td><b> ".$totalclicks."</b> </td> <br>";
/*
//This isn't done yet
<a href='manage.php?id=".$id."&action=rename'>Click Here to rename ".$name.".</a> <br>
<a href='manage.php?id=".$id."&action=kill'>Click Here to kill ".$name.".</a>";
*/
$i++;
}
$article_content = $article_content."</table>";
}
// Should we show the extra pages in the nav bar?
$link1 = "";
if($show_extra_page1 == "yes"){
$link1 = "<li><a href='$extra_page1_link'>$extra_page1_name<span class='tab-l'></span><span class='tab-r'></span></a></li>";
}
$link2 = "";
if($show_extra_page2 == "yes"){
$link2 = "<li><a href='$extra_page2_link'>$extra_page2_name<span class='tab-l'></span><span class='tab-r'></span></a></li>";
}
// Do the template changes and echo the ready template
$template = file_get_contents($file);
$template = replace(':SITETITLE:',$site_title,$template);
$template = replace(':SITENAME:',$site_name,$template);
$template = replace(':ARTICLETITLE:',$article_title,$template);
$template = replace(':ARTICLEDATE:',$article_date,$template);
$template = replace(':ARTICLECONTENT:',$article_content,$template);
$template = replace(':LINK1:',$link1,$template);
$template = replace(':LINK2:',$link2,$template);
$template = replace(':LINK3:',$link3,$template);
//Get the featured adoptable...
$featured = getfeatured();
$template = replace(':FEATURED:',$featured,$template);
//Ad Management
$header = @file_get_contents("ads/header.txt");
$footer = @file_get_contents("ads/footer.txt");
$tower = @file_get_contents("ads/tower.txt");
$header = stripslashes($header);
$footer = stripslashes($footer);
$tower = stripslashes($tower);
$template = replace(':HEADERAD:',$header,$template);
$template = replace(':FOOTERAD:',$footer,$template);
$template = replace(':TOWERAD:',$tower,$template);
//Is the user logged in?
//$isloggedin = "no";
if ($isloggedin == "yes"){
$template = replace(':WELCOMEORREGISTER:','<u>Welcome Back:</u>',$template);
$template = replace(':LOGINORACCT:', 'Welcome back '.$username.'. <br><br><a href="account.php">Click here to view or edit your account.</a><br><br><a href="logout.php">Log Out</a>' ,$template);
}
else{
//User is not logged in
$template = replace(':WELCOMEORREGISTER:','<u>Member Login:</u>',$template);
$loginform = "<form name='form1' method='post' action='login.php'>
<p>Username:
<input name='username' type='text' id='username'>
</p>
<p>Password:
<input name='password' type='password' id='password'>
</p>
<p>
<input type='submit' name='Submit' value='Submit'>
</p>
<p>Don't have an account?<br>
<a href='register.php'>Register Free</a> </p>
</form>
";
$template = replace(':LOGINORACCT:', $loginform ,$template);
}
echo $template;
?>
That's it. That's the one that I would be using, if it would work :3 |
