Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #11  
Old 12-27-2011, 03:22 PM
AlexC's Avatar
AlexC AlexC is offline
Moderator
 
Join Date: Dec 2009
Location: Canada
Posts: 753
Gender: Unknown/Other
Credits: 66,345
AlexC is an unknown quantity at this point
Default

your code worked slightly better then mine did - when I tried to put it in, the whole site went dead - your code brought it back, except then the whole layout exploded. either I'm doing this wrong or my website hates me.
__________________
Reply With Quote
  #12  
Old 12-27-2011, 03:29 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,222
SilverDragonTears is on a distinguished road
Default

Did you add in the css that they give you to your current stylesheet? And the javascript to your template.html?
__________________

Check out SilvaTales
Reply With Quote
  #13  
Old 12-27-2011, 03:38 PM
AlexC's Avatar
AlexC AlexC is offline
Moderator
 
Join Date: Dec 2009
Location: Canada
Posts: 753
Gender: Unknown/Other
Credits: 66,345
AlexC is an unknown quantity at this point
Default

yes, I did.
__________________
Reply With Quote
  #14  
Old 12-27-2011, 03:39 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,222
SilverDragonTears is on a distinguished road
Default

Well, for one thing your links go down while mine go across. Send me template.html, your stylesheet and functions.php
__________________

Check out SilvaTales
Reply With Quote
  #15  
Old 12-27-2011, 03:40 PM
AlexC's Avatar
AlexC AlexC is offline
Moderator
 
Join Date: Dec 2009
Location: Canada
Posts: 753
Gender: Unknown/Other
Credits: 66,345
AlexC is an unknown quantity at this point
Default

do you want them via pm or just posted here?
__________________
Reply With Quote
  #16  
Old 12-27-2011, 03:42 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,222
SilverDragonTears is on a distinguished road
Default

You can post them here
__________________

Check out SilvaTales
Reply With Quote
  #17  
Old 12-27-2011, 03:47 PM
AlexC's Avatar
AlexC AlexC is offline
Moderator
 
Join Date: Dec 2009
Location: Canada
Posts: 753
Gender: Unknown/Other
Credits: 66,345
AlexC is an unknown quantity at this point
Default

css, template and function, in that order.

Code:
/*
      Created by Keith Donegan of Code-Sucks.com
	  
	  E-Mail: Keithdonegan@gmail.com
	  
	  You can do whatever you want with these layouts,
	  but it would be greatly appreciated if you gave a link
	  back to http://www.code-sucks.com
	  
*/

* { padding: 0; margin: 0; }

body {
 font-family: Arial, Helvetica, sans-serif;
 font-size: 13px;
}
#wrapper { 
 margin: 0 auto;
 width: 922px;
}
#faux {
 background: url(faux-2-2-col.gif);
 margin-bottom: 5px;
 overflow: auto; /* Paul O Brien Fix for IE www.pmob.co.uk */
 width: 100%
}
#header {
 color: #333;
 width: 902px;
 padding: 10px;
 height: 160px;
 margin: 10px 0px 5px 0px;
 background: #D1DBDB;
}
#navigation {
 color: #333;
 padding: 10px;
 margin: 0px 0px 5px 0px;
 background: #ABBEBE;
}
#rightcolumn { 
 display: inline;
 color: #333;
 margin: 10px;
 padding: 0px;
 width: 195px;
 float: right;
}
#leftcolumn { 
 float: left;
 color: #333;
 margin: 10px;
 padding: 0px;
 width: 683px;
 display: inline;
 position: relative;
}
#footer { 
 width: 902px;
 clear: both;
 color: #333;
 background: #ABBEBE;
 margin: 0px 0px 10px 0px;
 padding: 10px;
}
.clear { clear: both; background: #000000; }


img
{  border-style: none;
}
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:BROWSERTITLE:</title>
<link rel="stylesheet" type="text/css" href="templates/faux/main.css" />


</head>

<body>

   <!-- Begin Wrapper -->
   <div id="wrapper">
   
         <!-- Begin Header -->
         <div id="header">
		 
		       <center><a href="/"><img src="templates/faux/betabanner.png"></a></center>		 
			   
		 </div>
		 <!-- End Header -->
		 
		 <!-- Begin Navigation -->
         <div id="navigation">
		 

			   
		 </div>
		 <!-- End Navigation -->
		 
         <!-- Begin Faux Columns -->
		 <div id="faux">
		 
		       <!-- Begin Left Column -->
		       <div id="leftcolumn">

					
					 
					 <h1>:ARTICLETITLE:</h1>	 
					 
				     <p>
					 
					       :ARTICLECONTENT:			     
					  </p>
		       
			   <div class="clear"></div>
			   
		       </div>
		       <!-- End Left Column -->
		 
		       <!-- Begin Right Column -->
		       <div id="rightcolumn">
		 :SIDEFEED:
<br><br>
<hr>
<br><br>
:LINKSBAR:
		             
							
				<div class="clear"></div>
				
		       </div>
		       <!-- End Right Column -->
			   
         </div>	   
         <!-- End Faux Columns --> 

         <!-- Begin Footer -->
         <div id="footer">
		       
               This is the Footer		

         </div>
		 <!-- End Footer -->
		 
   </div>
   <!-- End Wrapper -->
</body>
</html>
Code:
<?php



// File ID: functions.php

// Purpose: Provides basic sitewide functions



include("config.php");



$GLOBALS['dbhost'] = $dbhost;      		//DB Hostname

$GLOBALS['dbuser'] = $dbuser;			//DB User

$GLOBALS['dbpass'] = $dbpass;			//DB Password

$GLOBALS['dbname'] = $dbname;    			//Your database name

$GLOBALS['domain'] = $domain;    			//Your domain name (No http, www or . )

$GLOBALS['scriptpath'] = $scriptpath;		//The folder you installed this script in

$GLOBALS['prefix'] = $prefix;



include("lang/lang.php");



//Connect to the database first

connect();

startup();

session_start();  



// clean all our data

$_POST = array_map('secure',$_POST);

$_GET = array_map('secure',$_GET);



$session = session_id();

$time = time();

$time_check = $time - 300; // Time check, delete after 300 seconds (5 minutes)

$result = runquery("SELECT * FROM {$GLOBALS['prefix']}online WHERE `session` = '{$session}'");

$count = mysql_num_rows($result);

$result2 = runquery("SELECT * FROM {$GLOBALS['prefix']}online WHERE `username` = '{$loggedinname}'");

$count2 = mysql_num_rows($result2);

if($isloggedin != "yes")

{

	$loggedinname = "Visitor";

}

if($count == 0 and $count2 == 0)

{

	runquery("INSERT INTO {$GLOBALS['prefix']}online VALUES('$loggedinname', '$session', '$time')");

}

else 

{

      runquery("UPDATE ".$GLOBALS['prefix']."online SET time=".$time.", session ='".$session."', username='".$loggedinname."' WHERE session = '".$session."'");

}

// if over 5 minute, delete session

$sql4="DELETE FROM ".$GLOBALS['prefix']."online WHERE time < ".$time_check;

$result4=runquery($sql4);







// Begin functions definition:



function runquery($query) {

	// next three lines may be commented out if debugging is unnessecary

	//$arr = debug_backtrace();

	//$GLOBALS['queries'] .= "<br /><strong>{$query}</strong> on line {$arr[0]["line"]} of {$arr[0]["file"]}.";

	//$GLOBALS['numberofqueries']++;

	$result = mysql_query($query);

	return $result;

}


function changecash($amount, $user, $startamount) {
	$newamount = $startamount + $amount;
	if ($newamount >= 0) {
		$GLOBALS['money'] = $newamount;
		runquery("UPDATE {$GLOBALS['prefix']}users SET `money` = '{$newamount}' WHERE `username` = '{$user}'");
		return true;
	}
	return false;
}


function clickreward($amount, $user, $startamount) {

    $addamount = explode(",",$amount);

	$randamount = rand($addamount[0], $addamount[1]);

    return $randamount;

}



function connect() {

	//This function simply connects us to the database

	$conn = mysql_connect($GLOBALS['dbhost'], $GLOBALS['dbuser'], $GLOBALS['dbpass']) or die ('Error connecting to MySQL');

	mysql_select_db($GLOBALS['dbname']);

}



function secure($data) {

	//This function performs security checks on all incoming form data

	if(is_array($data)) {

		die("Hacking Attempt!");

	}

	$data = htmlentities($data);

	$data = mysql_real_escape_string($data);

	$data = strip_tags($data, '');

	return $data;

}



function getsitecontent($page) {

	$query = "SELECT * FROM ".$GLOBALS['prefix']."content WHERE page = '$page'";

	$result = @runquery($query);

	$num = @mysql_num_rows($result);

		$title=@mysql_result($result,0,"title");

		$content=@mysql_result($result,0,"content");

		$title = stripslashes($title);

		$content = stripslashes($content);

	$value[content] = $content;

	$value[title] = $title;

	return $value;

}



function replace($old, $new, $template) {

	//This function replaces template values

	$template = str_replace($old, $new, $template);

	return $template;

}

function uidtousername ($id) {



$query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE uid='$id'";

$result = mysql_query($query);

$username=@mysql_result($result,0,"username"); 

return $username;

}



function usernametouid ($name) {



$query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username='$name'";

$result = mysql_query($query);

$uid=@mysql_result($result,0,"uid"); 



return $uid;

}

function usergroupidtoname($id) {


$query = "SELECT * FROM ".$GLOBALS['prefix']."groups WHERE gid='$id'";

$result = mysql_query($query);

$groupname=@mysql_result($result,0,"groupname"); 

return $groupname;

}

function usergroupnametoid($name) {


$query = "SELECT * FROM ".$GLOBALS['prefix']."groups WHERE groupname='$name'";

$result = mysql_query($query);

$gid=@mysql_result($result,0,"gid"); 

return $gid;

}

// NOTE - make sure this is only run once in a whole page load - not multiple times!

function logincheck() {

	//Set up our login info...

	$uid = "";

	$password = "";



	//Check for cookie

	if (isset($_COOKIE['auid']) and isset($_COOKIE['apass'])) {

		$uid = $_COOKIE['auid'];

		$password = $_COOKIE['apass'];

		$uid = secure($uid);

		$password = secure($password);



		//Run login operation

		$query = "SELECT * FROM ".$GLOBALS['prefix']."users, ".$GLOBALS['prefix']."groups WHERE uid = '$uid' LIMIT 1";

		$result = runquery($query);

		

		$GLOBALS['usersettings'] = mysql_fetch_array($result);

		$luid=@mysql_result($result, 0, $GLOBALS['prefix']."users.uid");

		$lpass=@mysql_result($result, 0, $GLOBALS['prefix']."users.password");

		$usergroup=@mysql_result($result, 0, $GLOBALS['prefix']."users.usergroup");



		if($uid == $luid and $password == $lpass) {

			$isloggedin = "yes";

		}

		else{

			if (isset($_COOKIE['auser'])) {

				$past = time() - 10; 

				setcookie("auid", $uid, $past);

			}

			if (isset($_COOKIE['apass'])) {

				$past = time() - 10; 

				setcookie("apass", $password, $past);

			}

			$isloggedin = "no";

		}

	}

	else {

		$isloggedin = "no";

	} 

	// return our user data

    $username = uidtousername($uid);

	$GLOBALS['isloggedin'] = $isloggedin;

	$GLOBALS['username'] = $username;

	$GLOBALS['loggedinname'] = $username; // MESSY - I'm unsure of which {username/loggedinname} is the correct one to use.

	$GLOBALS['money'] = $GLOBALS['usersettings']['money'];

	$GLOBALS['group'] = $usergroup;

}



function passencr($username, $password){

$pepper = '2/Fd4o42mMj*4P60s8N7';
$salt = grabanysetting("saltcode");

$password = md5($password);
$newpassword = sha1($username.$password);
$finalpassword = hash('sha512', $pepper.$newpassword.$salt);
return $finalpassword;
}   

function updatepass($username, $password){

$pepper = '2/Fd4o42mMj*4P60s8N7';
$salt = grabanysetting("saltcode");

$newpassword = sha1($username.$password);
$finalpassword = hash('sha512', $pepper.$newpassword.$salt);

return $finalpassword;
}  

function getcash($loggedinname){



//First we see if we are logged in or not



$isloggedin = $GLOBALS['isloggedin'];

$loggedinname = $GLOBALS['username'];



$query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username = '$loggedinname'";

$result = runquery($query);

$num = mysql_num_rows($result);

$mycash=@mysql_result($result,0,"money");



return $mycash;



}





function grabanysetting($where) {

	$value = stripslashes($GLOBALS['settings'][$where]);	

	return $value;

}



function getlinks() {

	$links = "";



	$query = "SELECT * FROM ".$GLOBALS['prefix']."links ORDER BY id ASC";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	//Loop out code

	$i=0;

	while ($i < $num) {

		$linktext=@mysql_result($result, $i,"linktext");

		$linkurl=@mysql_result($result, $i,"linkurl");

		$linktext = stripslashes($linktext);

		$links .= "<li><a href='".$linkurl."'>".$linktext."</a></li>";

		$i++;

	}

	return $links;

}



function getsidebar() {

	//This function determines what shows in the side bar of the template

	$isloggedin = $GLOBALS['isloggedin'];

	$loggedinname = $GLOBALS['loggedinname'];

	if($isloggedin == "yes") {

		$msgctr = "<a href='messages.php'>Read Messages</a>";

		$query = "SELECT * FROM ".$GLOBALS['prefix']."messages WHERE touser='".$loggedinname."' and status='unread'";

		$result = runquery($query);

		$num = mysql_num_rows($result);

		if($num > 0) {

		$msgctr = "<a href='messages.php'>Read Messages <b>(".$num.") new</b></a>";

		}

		$sidebar = "You have {$GLOBALS['money']} {$GLOBALS['settings']['cost']}.<br />

		<a href='donate.php'>Donate money to friends</a><br />

		<br /><strong>Your links:</strong><br />

		<ul><li><a href='myadopts.php'>See my Rats</a></li>

		<li><a href='breeding.php'>Breed Rats</a></li>

		<li><a href='trade.php'>Trade Rats</a></li>

		<li><a href='account.php'>Edit My Account</a></li>

		<li>".$msgctr."

		<li><a href='logout.php'>Log Out</a></li>";



           $query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username='".$loggedinname."' and usergroup='1'";

		   $result = runquery($query);

           $usercancp = mysql_num_rows($result);



		if($usercancp  != 0) {

			$sidebar .= "<br><br><li><a href='admin.php'>Admin Center</a></li><br />";

		}



        $query1 = runquery("SELECT * FROM ".$GLOBALS['prefix']."online WHERE username != 'Visitor'");

        $total1 = mysql_num_rows($query1);

        $query2 = runquery("SELECT * FROM ".$GLOBALS['prefix']."online WHERE username = 'Visitor'");

        $total2 = mysql_num_rows($query2);

		$sidebar .= "<a href='online.php'>This site has ".$total1." members and ".$total2." guests online.</a>";



		

		$sidebar .= "</ul>";

	}

	else {

		$sidebar = "<b><u>Member Login:</u></b><br />

		<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='Log In'>

		  </p>

		</form>Don't have an account?<br /><a href='register.php'>Register Free</a><br /><a href='forgotpass.php'>Forgot Password?</a>";

        $query1 = runquery("SELECT * FROM ".$GLOBALS['prefix']."online WHERE username != 'Visitor'");

        $total1 = mysql_num_rows($query1);

        $query2 = runquery("SELECT * FROM ".$GLOBALS['prefix']."online WHERE username = 'Visitor'");

        $total2 = mysql_num_rows($query2);

		$sidebar .= "<br />This site currently has ".$total1." members and ".$total2." guests.";



	}

	return $sidebar;

}

function dologin($username, $password) {

	$query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username = '$username'";

	$result = @runquery($query);

	$num = @mysql_num_rows($result);



	$luser=@mysql_result($result, 0,"username");

	$lpass=@mysql_result($result, 0,"password");

    $uid = usernametouid ($username);


	if($username == $luser and $password == $lpass) {

		$status = "success";

		//If the cookie already exists for some reason, delete it

		if (isset($_COOKIE['auid']) and isset($_COOKIE['apass'])) {

			$past = time() - 10; 

			setcookie("auid", $uid, $past);

			setcookie("apass", $password, $past);

		}

		// Set the cookie

		$Month = 2592000 + time();

		setcookie("auid", $uid, $Month);

		setcookie("apass", $password, $Month);

	}



	else{

		$status = "error";

	}



	return $status;

}



function getgroup() {

	$isloggedin = $GLOBALS['isloggedin'];

	$loggedinname = $GLOBALS['username'];



	if($isloggedin == "yes") {



    $query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username = '$loggedinname'";

    $result = @mysql_query($query);

    $num = @mysql_num_rows($result);

      $group=@mysql_result($result,0,"usergroup");

		return $group;

	}

	else {

		return 0;

	}

}



function cancp($usergroup) {

	//This function determines if a usergroup is allowed to access the Admin CP



    $query = "SELECT * FROM ".$GLOBALS['prefix']."groups WHERE gid = '$usergroup'";

    $result = @mysql_query($query);

    $num = @mysql_num_rows($result);

    $cancp=@mysql_result($result,0,"cancp");





	if($cancp == "" or $usergroup == 0) {

		$cancp = "no";

	}

	

	return $cancp;

}



function getadmlinks() {

	//This function shows special links to the site admin



	$links = "<li><a href='index.php'>Home</a></li>

	<li><a href='admin.php?set=adopts'>Change Adoptables</a></li>

	<li><a href='admin.php?set=content'>Change Content</a></li>

	<li><a href='admin.php?set=users'>Change Users</a></li>

	<li><a href='admin.php?set=settings'>Site Settings</a></li>

	<li><a href='admin.php?set=ads'>Manage Ads</a></li>";



	return $links;

}



function cando($usergroup, $do) {

	//This function determines if a usergroup is allowed to do a specific task

	$cando = $GLOBALS['usersettings'][$do];



	if($cando == "" or $usergroup == 0 or $usergroup == 5) {

		$cando = "no";

	}



	return $cando;

}



// QUERYPROBLEM

function canadopt($aid, $cond, $promocode, $row) {

	// This function determines if a user can adopt a specific adoptable...

	$isloggedin = $GLOBALS['isloggedin'];

	$loggedinname = $GLOBALS['username'];



	if($isloggedin != "yes" and $cond != "showing") {

		return "no";

	}



	// Now we check if our usergroup has permission to adopt the adoptable...

	$group = getgroup();

	$dbcanadpt = cando($group, "canadopt");



	if($dbcanadpt != "yes" and $cond != "showing") {

		return "no";

	}



	// Now we check if the adoptable requires a promo code and if the promo code submitted is correct...

	if($row['whenisavail'] == "promo" and $promocode != $row['promocode']) {

		return "no";

	}



	// Now we check those three conditions we have in the Admin CP

	if($row['whenisavail'] == "conditions") {

		// If we have a restriction on the number of times this can be adopted...

		if($row['freqcond'] == "enabled") {

			// Select from the database and determine how many times this adoptable type has been adopted

			$num = 0;



			$query = "SELECT * FROM ".$GLOBALS['prefix']."owned_adoptables WHERE type='$type'"; // QUERYPROBLEM

			$result = runquery($query);

			$num = mysql_num_rows($result);



			if($num > $number) {

				return "no";

			}

		}



		// Begin the date restriction check

		$today = date('Y-m-d');



		if($row['datecond'] == "enabled" and $row['date'] != $today) {

			return "no";

		}



		// We are checking to see how many of this adoptable a user owns

		// If they own more than the specifed number, they cannot adopt...

		if($row['moreless'] == "enabled") {

			$num = 0;



			$query = "SELECT * FROM ".$GLOBALS['prefix']."owned_adoptables WHERE owner='$loggedinname' and type='$type'";

			$result = runquery($query);

			$num = mysql_num_rows($result);



			if($num > $row['morelessnum']) {

				return "no";

			}

		}





		// Check if the user is of a specified usergroup...

		if($row['levelgrle'] == "enabled") {

			$ourgid = getgroup();



			// If the two numbers do not match, do not allow the adoption...

			if($ourgid != $row['grlelevel']) {

				return "no";

			}	

		}

	} // end conditions

	return "yes";

}



// MESSY

function isbanned($user){
  $banstatus = 0;
  $query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username='{$user}'";
  $result = runquery($query);  
  $row = mysql_fetch_array($result);
  if($row['usergroup'] == 5) $banstatus = 1;
  return $banstatus;
}

function getaltstatus($parentid, $childid, $childlevel) {

	// This function determines if we will use alternate images...

	$altstatus = "no";

	$run = "no";



	// First we need to see if this adoptable type has alternate images enabled...

	$query = "SELECT * FROM ".$GLOBALS['prefix']."adoptables WHERE id='$parentid'";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	$alternates=@mysql_result($result, 0,"alternates"); 

	$altoutlevel=@mysql_result($result, 0,"altoutlevel");

	$altchance=@mysql_result($result, 0,"altchance");

	

	// Let's see if the level we are on is the level that requires alternates

	if($alternates == "enabled") {

		if($childlevel == $altoutlevel) {

			$run = "yes";

		}

	}



	if($run == "yes") {

		$randnum = rand(1, $altchance);

		if( $randnum == 1) {

			$altstatus = "yes"; // If we pull a 1 as the random number, we use the alternate images :)

		}

	}

	return $altstatus;

}



// MESSY / QUERYPROBLEM

function getcurrentimage($id) {

	// This function determines which image we should use for a given adoptable...

	$image = "";



	// First we select the adoptable from the database and get some basic information...

	$query = "SELECT * FROM ".$GLOBALS['prefix']."owned_adoptables WHERE aid='$id'";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	$type=@mysql_result($result, 0,"type"); 

	$currentlevel=@mysql_result($result, 0,"currentlevel"); 

	$imageurl=@mysql_result($result, 0,"imageurl");

	$usealternates=@mysql_result($result, 0,"usealternates");



	if($imageurl != "") {

		// If we are using a custom image for this adoptable, use that

		$image = $imageurl;

	}

	else {

		// There is no custom image, so we must see if we are using an egg or a level image.

		if($currentlevel == 0 or $currentlevel == "0") {

			// Let's see what the egg image is...	

			$query = "SELECT * FROM ".$GLOBALS['prefix']."adoptables WHERE type='$type'";

			$result = runquery($query);

			$num = mysql_num_rows($result);



			$eggimage=@mysql_result($result, 0, "eggimage"); 



			$image = $eggimage; // Set the image URL equal to the egg image...

		}

		else {

			// We don't know the level or the image - we must find both.



			$query = "SELECT * FROM ".$GLOBALS['prefix']."levels WHERE adoptiename='$type' and thisislevel='$currentlevel'";

			$result = runquery($query);

			$num = mysql_num_rows($result);



			$primaryimage=@mysql_result($result, 0,"primaryimage"); 

			$alternateimage=@mysql_result($result, 0,"alternateimage");



			// If alternate images are enabled and an alternate image exists, use it

			if($usealternates == "yes" and $alternateimage != "") {

				$image = $alternateimage; // Use the alternate image

			}

			else{

				$image = $primaryimage; // Set the image equal to the primary image for the level

			}

		}



	}



	if($type == "" or $image == "") {

		// We did not settle on an image, so we show an error image...

		$image = "http://www.".$GLOBALS['domain']."".$GLOBALS['scriptpath']."/templates/icons/delete.gif";

	}

	return $image;

}



// QUERYPROBLEM - when is getcurrentlevel() actually used?

function getcurrentlevel($id) {

	// This function gets the current level of an adoptable...



	$query = "SELECT * FROM ".$GLOBALS['prefix']."owned_adoptables WHERE aid='$id'";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	$currentlevel=@mysql_result($result, 0,"currentlevel"); 



	if($currentlevel == "") {

		$currentlevel = "error"; // If the adoptable does not have a current level or does not exist, we return an error...

	}

	

	// Return the level

	return $currentlevel;

}



function getnextlevelexists($type, $currentlevel) {

	// This function determines if a higher level exists for an adopt, or if it is at max level.



	$query = "SELECT * FROM ".$GLOBALS['prefix']."levels WHERE adoptiename='$type' and thisislevel > '$currentlevel'";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	if($num > 0) {

		return "true";

	}

	return "false";

}



function convertidtotype($id) {

	// This function takes in an adoptable's ID and returns the type of adoptable it is...



	$query = "SELECT * FROM ".$GLOBALS['prefix']."owned_adoptables WHERE aid='$id'";

	$result = runquery($query);

	$num = mysql_num_rows($result);

	 

	$type=@mysql_result($result, 0,"type"); 



	if($type == "") {

		return "error";

	}

	

	return $type;

}



// MESSY - I have no idea what this function is supposed to do.

function converttypetoparentid($type) {

	// This function takes in an adoptable type and returns the ID of the parent

	

	$query = "SELECT * FROM ".$GLOBALS['prefix']."adoptables WHERE type='$type'";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	$id=@mysql_result($result, 0, "id"); 



	if($id == "") {

		$id = "error";

	}



	return $id;

}



// QUERYPROBLEM - this is being called (I believe) on every click page, and uses many too many queries.

function reward($id, $type, $currentlevel, $owner) {

	// This function determines if we are giving the user a reward or not...

	$query = "SELECT * FROM ".$GLOBALS['prefix']."levels WHERE adoptiename='$type' and thisislevel='$currentlevel'";

	$result = runquery($query);

	$num = mysql_num_rows($result);

	 

	$rewarduser=@mysql_result($result, 0,"rewarduser"); 

	$promocode=@mysql_result($result, 0,"promocode");



	if($rewarduser == "yes" and $promocode != "") {

		// We are sending out a reward...



		$mtitle = "You have received a reward!";

		$mtext = "Congratulations!  You have received a reward because one of your adoptables leveled up and the site admin has chosen to reward you for this.<br /><br />

		<b><u>Your reward is the following promo code:</u></b> ".$promocode."<br /><br />

		You may use this promo code on the <a href='promo.php?promocode=".$promocode."'>Promo Code Page</a> to receive a special exclusive or limited edition adoptable!<br /><br />

		Congratulations on your reward!";



		$mtext = mysql_real_escape_string($mtext);



		$date = date('Y-m-d');

		$query = "INSERT INTO ".$GLOBALS['prefix']."messages VALUES ('', 'SYSTEM', '$owner','unread','$date','$mtitle', '$mtext')";

		runquery($query);



		// Now we check if we are sending out an email to the user alerting them of the message...

		$query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username='".$owner."'";

		$result = runquery($query);

		$num = mysql_num_rows($result);



		$newmessagenotify=@mysql_result($result, 0,"newmessagenotify");

		$email=@mysql_result($result, 0,"email");



		if($newmessagenotify == 1) {

			// We are sending this user an email about the new message...

			$systememail = grabanysetting("systememail"); // QUERYPROBLEM - we should get the settings at the beginning so we never need to call for them after that.

			

			$headers = "From: ".$systememail."";



			$site_name = grabanysetting("sitename"); // QUERYPROBLEM - see, two queries for this message alone.



			$message = "Hello ".$owner.";\n\nYou have received a new Private Message from SYSTEM at ".$site_name." with the title ".$mtitle.".\n

			You can read this message at: http://www.".$GLOBALS['domain']."".$GLOBALS['scriptpath']."/messages.php\n

			Thank You.  The ".$site_name." team.";



			mail($email, $site_name." - You Have Received a Reward", $message, $headers);

		}

	}

	return $rewardstatus; // MESSY - where is the variable $rewardstatus used before this?

}



// MESSY - what is this function for?

function getadmimages() {

	$formcontent = "";



	$query = "SELECT * FROM ".$GLOBALS['prefix']."filesmap";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	$i=0;

	while ($i < $num) {

		$wwwpath=@mysql_result($result, $i,"wwwpath");

		$friendlyname=@mysql_result($result, $i,"friendlyname");

		$formcontent = $formcontent."<option value='".$wwwpath."'>".$friendlyname."</option>";

		$i++;

	}

	return $formcontent;

}



function deleteuser($user) {

	//This function deletes a user from the system...



	$user = secure($user);



	$query = "DELETE FROM ".$GLOBALS['prefix']."users WHERE username = '".$user."'";

	$result = runquery($query);



	$query = "DELETE FROM ".$GLOBALS['prefix']."owned_adoptables WHERE owner = '".$user."'";

	$result = runquery($query);

}



// MESSY - I believe this still runs if there are no ads. There should be an option to turn it off.

function getads($page) {

	// Function to display site advertisements

	

	if($page == "any") {

		$page = "";

	}



	$query = "SELECT * FROM ".$GLOBALS['prefix']."ads WHERE page = '".$page."' and status = 'active' ORDER BY RAND() LIMIT 1";

	$result = @runquery($query);

	$num = @mysql_num_rows($result);



	if($num > 0) {

		$value=@mysql_result($result, 0,"text");

		$value = stripslashes($value);

		$aid=@mysql_result($result, 0,"id");

		$actualimpressions=@mysql_result($result, 0,"actualimpressions");

		$impressions=@mysql_result($result, 0,"impressions");



		if($impressions == "") {

			$impressions = 0;

		}



		$actualimpressions = $actualimpressions + 1;



		//Update the impressions count

		$query = "UPDATE ".$GLOBALS['prefix']."ads SET actualimpressions='".$actualimpressions."' WHERE id='".$aid."'";

		runquery($query);



		//Check that ad is not over max impressions...

		if ($actualimpressions >= $impressions and $impressions != 0) {

			$query = "UPDATE ".$GLOBALS['prefix']."ads SET status='inactive' WHERE id='".$aid."'";

			runquery($query);

		}

	}

	else{

		$value = "";

	}

	return $value;

}



// NEW - mainly by Hall of Famer

function getabandonedimage($id) {

	// This function determines which image we should use for a given adoptable (which has been abandoned).

	$image = "";



	// First we select the adoptable from the database and get some basic information...

	$query = "SELECT * FROM ".$GLOBALS['prefix']."abandoned WHERE aid='$id'";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	$type=@mysql_result($result, 0,"type"); 

	$currentlevel=@mysql_result($result, 0,"currentlevel"); 

	$imageurl=@mysql_result($result, 0,"imageurl");

	$usealternates=@mysql_result($result, 0,"usealternates");



	if($imageurl != "") {

		// If we are using a custom image for this adoptable, use that

		$image = $imageurl;

	}

	else {

		// There is no custom image, so we must see if we are using an egg or a level image.

		if($currentlevel == 0 or $currentlevel == "0") {

			// Let's see what the egg image is...	

			$query = "SELECT * FROM ".$GLOBALS['prefix']."adoptables WHERE type='$type'";

			$result = runquery($query);

			$num = mysql_num_rows($result);



			$eggimage=@mysql_result($result, 0, "eggimage"); 



			$image = $eggimage; // Set the image URL equal to the egg image...

		}

		else {

			// We don't know the level or the image - we must find both.



			$query = "SELECT * FROM ".$GLOBALS['prefix']."levels WHERE adoptiename='$type' and thisislevel='$currentlevel'";

			$result = runquery($query);

			$num = mysql_num_rows($result);



			$primaryimage=@mysql_result($result, 0,"primaryimage"); 

			$alternateimage=@mysql_result($result, 0,"alternateimage");



			// If alternate images are enabled and an alternate image exists, use it

			if($usealternates == "yes" and $alternateimage != "") {

				$image = $alternateimage; // Use the alternate image

			}

			else{

				$image = $primaryimage; // Set the image equal to the primary image for the level

			}

		}



	}



	if($type == "" or $image == "") {

		// We did not settle on an image, so we show an error image...

		$image = "http://www.".$GLOBALS['domain']."".$GLOBALS['scriptpath']."/templates/icons/delete.gif";

	}

	return $image;

}



// NEW - again, I think by Hall of Famer

function canadoptab($aid, $cond, $promocode){

	$canadopt = "yes"; // The default status is that we CAN adopt, unless proven false...



	$isloggedin = $GLOBALS['isloggedin'];

	$loggedinname = $GLOBALS['username'];



	if($isloggedin != "yes" and $cond != "showing"){

		$canadopt = "no";

	}



	// Now we check if our usergroup has permission to adopt the adoptable...

	$group = getgroup();

	$dbcanadopt = cando($group, "canadopt");



	if($dbcanadopt != "yes" and $cond != "showing"){

		$canadopt = "no";

	}

	

	return $canadopt;

} 





// NEW - a function to set everything up on start so we don't need to keep using queries to get stuff

function startup() {

	// get all of our default settings, like title and stuff

	$result = runquery("SELECT * FROM ".$GLOBALS['prefix']."settings");

	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

		$GLOBALS['settings'][$row['name']] = $row['value'];

	}

	// set up our log in stuff so we always have it

	logincheck();

}



// NEW - a function to get a page from the database

function getpage($name) {

	$query = "SELECT * FROM ".$GLOBALS['prefix']."content WHERE page='{$name}' LIMIT 1";	

	$result = runquery($query);

	$row = mysql_fetch_array($result);

	$GLOBALS['article_content'] = $row['content'];

	$GLOBALS['article_title'] = $row['title'];

	$GLOBALS['date'] = $row['date'];

	return;

}



// NEW - a function to show the page

function showpage($title, $content, $date, $profile="") {

	$theme = $GLOBALS['usersettings']['theme'];

	if ($theme == '') {

		$theme = grabanysetting("theme");

	}

	$themeurl = "templates/{$theme}/template.html";

	$patterns = array("/:ARTICLETITLE:/","/:ARTICLECONTENT:/", "/:ARTICLEDATE:/", "/:BROWSERTITLE:/", "/:SITENAME:/", "/:SLOGAN:/", "/:LINKSBAR:/", "/:SIDEFEED:/", "/:ADS:/");

	// if we have said we are in an admin area, don't show ads and show admin links


	if ($GLOBALS['admin']==true) {

		$replacements = array($title, $content, $date, grabanysetting("browsertitle")." ".$title, grabanysetting("sitename"), grabanysetting("slogan"), getadmlinks(), getsidebar(), "");

	}

	else {

		$replacements = array($title, $content, $date, grabanysetting("browsertitle")." ".$title, grabanysetting("sitename"), grabanysetting("slogan"), getlinks(), getsidebar(), getads("any"));

	}

	// now that we have our stuff, let's start making it all into a webpage

	$template = file_get_contents($themeurl);

	$template =  preg_replace($patterns, $replacements, $template);

	$template .= "";

	return $template;

}



function getpostbar ($name) {

      $query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username='$name'";

	$result = runquery($query);

	$num = mysql_num_rows($result);



	$membersince=@mysql_result($result, 0,"membersince"); 

	$dollar=@mysql_result($result, 0,"money"); 

	$avatar=@mysql_result($result, 0,"avatar");

	$bio=@mysql_result($result, 0,"profile");

	$gender=@mysql_result($result, 0,"gender");

	$nickname=@mysql_result($result, 0,"nickname");



$postbar = " 

<table>

<span class='smalltext'> 

<tr>

<td>

<img src='{$avatar}'>

</td>

<td>

<b>Member Since: </b><br>{$membersince}<br> 

<b>Bio:</b><br>{$bio}<br> 

</td>

<td>

<b>Nickname:</b> {$nickname}<br> 

<b>Gender:</b> {$gender}<br>

<b>Cash:</b> <a href='forum.php?do=donate&from={$uid}&am={$dollar}'>{$dollar}</a><br> 

</td>

</span>

</table> 

"; 



return $postbar; 







}



function getonlinestatus($name) {



$query = "SELECT * FROM ".$GLOBALS['prefix']."online WHERE username='$name'";

$result = mysql_query($query);

$num = mysql_num_rows($result);





if($num == 0){

$onlinestatus = "<img src='templates/icons/user_offline.gif'>";

}

else{

$onlinestatus = "<img src='templates/icons/user_online.gif'>";

}



return $onlinestatus;

}



function getfriendgender($name) {



$query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username='$name'";

$result = mysql_query($query);

$gender=@mysql_result($result,0,"gender");





if($gender == "Male"){

$friendgender = "<img src='picuploads/m.png'>";

}

else if($gender == "Female"){

$friendgender = "<img src='picuploads/f.png'>";

}

else{

$friendgender = "";

}



return $friendgender;

}



function getfriendid ($name) {



$query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username='$name'";

$result = mysql_query($query);

$friendid=@mysql_result($result,0,"friends"); //friendlist



$friendidlist = explode(",",$friendid);

return $friendidlist; 



}



function getfriendnum ($name) {



$friendidlist = getfriendid ($name);



$query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username='$name'";

$result = mysql_query($query);

$friendid=@mysql_result($result,0,"friends"); //friendlist



if($friendid == ""){

$friendnum = "0";

}

else{

$friendnum = count($friendidlist);

}



return $friendnum; 



}



function deletefriend($id){

$friendidlist = getfriendid ($loggedinname);

  foreach($friendidlist as $friend){

    if($friend != $id){

    $newfriendidlist[] = $friend; 

    }

  }

$newfriendid = implode(",", $newfriendidlist);

return $newfriendid;

}

function classcheck($femaleclass, $maleclass){
  $canbreed = "no";
  foreach($femaleclass as $fclass){
    foreach($maleclass as $mclass){
      if($fclass == $mclass) $canbreed = "yes"; 
    }
  }  
  return $canbreed;
}

?>]
__________________

Last edited by SilverDragonTears; 12-27-2011 at 03:50 PM.
Reply With Quote
  #18  
Old 12-27-2011, 03:52 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,222
SilverDragonTears is on a distinguished road
Default

Did you remove what you'd already tried?
__________________

Check out SilvaTales
Reply With Quote
  #19  
Old 12-27-2011, 03:57 PM
AlexC's Avatar
AlexC AlexC is offline
Moderator
 
Join Date: Dec 2009
Location: Canada
Posts: 753
Gender: Unknown/Other
Credits: 66,345
AlexC is an unknown quantity at this point
Default

yes, it was ruining my whole site.
__________________
Reply With Quote
  #20  
Old 12-27-2011, 04:01 PM
SilverDragonTears's Avatar
SilverDragonTears SilverDragonTears is offline
I am your Nemesis.
 
Join Date: Jun 2011
Posts: 1,113
Gender: Female
Credits: 81,222
SilverDragonTears is on a distinguished road
Default

css

Code:
/*
      Created by Keith Donegan of Code-Sucks.com
	  
	  E-Mail: Keithdonegan@gmail.com
	  
	  You can do whatever you want with these layouts,
	  but it would be greatly appreciated if you gave a link
	  back to http://www.code-sucks.com
	  
*/

* { padding: 0; margin: 0; }

body {
 font-family: Arial, Helvetica, sans-serif;
 font-size: 13px;
}
#wrapper { 
 margin: 0 auto;
 width: 922px;
}
#faux {
 background: url(faux-2-2-col.gif);
 margin-bottom: 5px;
 overflow: auto; /* Paul O Brien Fix for IE www.pmob.co.uk */
 width: 100%
}
#header {
 color: #333;
 width: 902px;
 padding: 10px;
 height: 160px;
 margin: 10px 0px 5px 0px;
 background: #D1DBDB;
}
#navigation {
 color: #333;
 padding: 10px;
 margin: 0px 0px 5px 0px;
 background: #ABBEBE;
}
#rightcolumn { 
 display: inline;
 color: #333;
 margin: 10px;
 padding: 0px;
 width: 195px;
 float: right;
}
#leftcolumn { 
 float: left;
 color: #333;
 margin: 10px;
 padding: 0px;
 width: 683px;
 display: inline;
 position: relative;
}
#footer { 
 width: 902px;
 clear: both;
 color: #333;
 background: #ABBEBE;
 margin: 0px 0px 10px 0px;
 padding: 10px;
}
.clear { clear: both; background: #000000; }


img
{  border-style: none;
}
#sddm
{	margin: 0;
	padding: 0;
	z-index: 30}

#sddm li
{	margin: 0;
	padding: 0;
	list-style: none;
	float: left;
	font: bold 11px arial}

#sddm li a
{	display: block;
	margin: 0 1px 0 0;
	padding: 4px 10px;
	width: 60px;
	background: #5970B2;
	color: #FFF;
	text-align: center;
	text-decoration: none}

#sddm li a:hover
{	background: #49A3FF}

#sddm div
{	position: absolute;
	visibility: hidden;
	margin: 0;
	padding: 0;
	background: #EAEBD8;
	border: 1px solid #5970B2}

	#sddm div a
	{	position: relative;
		display: block;
		margin: 0;
		padding: 5px 10px;
		width: auto;
		white-space: nowrap;
		text-align: left;
		text-decoration: none;
		background: #EAEBD8;
		color: #2875DE;
		font: 11px arial}

	#sddm div a:hover
	{	background: #49A3FF;
		color: #FFF}
template.html
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:BROWSERTITLE:</title>
<link rel="stylesheet" type="text/css" href="templates/faux/main.css" />
<script type="text/javascript">// Copyright 2006-2007 javascript-array.com

var timeout	= 500;
var closetimer	= 0;
var ddmenuitem	= 0;

// open hidden layer
function mopen(id)
{	
	// cancel close timer
	mcancelclosetime();

	// close old layer
	if(ddmenuitem) ddmenuitem.style.visibility = 'hidden';

	// get new layer and show it
	ddmenuitem = document.getElementById(id);
	ddmenuitem.style.visibility = 'visible';

}
// close showed layer
function mclose()
{
	if(ddmenuitem) ddmenuitem.style.visibility = 'hidden';
}

// go close timer
function mclosetime()
{
	closetimer = window.setTimeout(mclose, timeout);
}

// cancel close timer
function mcancelclosetime()
{
	if(closetimer)
	{
		window.clearTimeout(closetimer);
		closetimer = null;
	}
}

// close layer when click-out
document.onclick = mclose; 
</script>

</head>

<body>

   <!-- Begin Wrapper -->
   <div id="wrapper">
   
         <!-- Begin Header -->
         <div id="header">
		 
		       <center><a href="/"><img src="templates/faux/betabanner.png"></a></center>		 
			   
		 </div>
		 <!-- End Header -->
		 
		 <!-- Begin Navigation -->
         <div id="navigation">
		 

			   
		 </div>
		 <!-- End Navigation -->
		 
         <!-- Begin Faux Columns -->
		 <div id="faux">
		 
		       <!-- Begin Left Column -->
		       <div id="leftcolumn">

					
					 
					 <h1>:ARTICLETITLE:</h1>	 
					 
				     <p>
					 
					       :ARTICLECONTENT:			     
					  </p>
		       
			   <div class="clear"></div>
			   
		       </div>
		       <!-- End Left Column -->
		 
		       <!-- Begin Right Column -->
		       <div id="rightcolumn">
		 :SIDEFEED:
<br><br>
<hr>
<br><br>
:LINKSBAR:
		             
							
				<div class="clear"></div>
				
		       </div>
		       <!-- End Right Column -->
			   
         </div>	   
         <!-- End Faux Columns --> 

         <!-- Begin Footer -->
         <div id="footer">
		       
               This is the Footer		

         </div>
		 <!-- End Footer -->
		 
   </div>
   <!-- End Wrapper -->
</body>
</html>
Try that with the code that I gave you before and see what happens, then don't do anything but post when you're one. I want to see it on your site.
__________________

Check out SilvaTales

Last edited by SilverDragonTears; 12-27-2011 at 04:03 PM.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to edit both menu's? Skaiya Questions and Supports 6 04-01-2014 03:03 PM
Modifying Dropdown Menu Hwona Questions and Supports 3 02-19-2014 04:30 PM
Dropdown's suggestion Zeref Suggestions and Feature Requests 5 08-23-2012 02:45 PM
Tab Slide Out Menu..? Alaric Questions and Supports 0 06-18-2012 06:11 AM
Avatar in menu SilverDragonTears Questions and Supports 16 04-25-2012 08:03 AM


All times are GMT -5. The time now is 03:37 PM.

Currently Active Users: 448 (0 members and 448 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636