Traffic Exchange Site Errors

millionexchange · February 17, 2013

Hi.

I just uploaded the following traffic exchange, but, I've came across a few errors.

FOLLOWING ERRORS:

Unable to create account and add URL.

USER ACCOUNT ERROR:

Logged in with test account and unable to add URL to account.
- http://themillionsexchange.heliohost.org
- Login: henryb
- Password: 209mul
- Login is not being echoed.
- Surfbar doesn't work, nor shows username in browser.

Get the following error on the start.php page when I click on some links:
- "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"

and

- "Error in query: SELECT username, joindate from user where referral=. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"

ADMIN ACCOUNT ERROR:

Logged into http://themillionsexchange.heliohost.org/admin.
Login: admin
Password: password
- Only shows the link: "<<back to main menu" on the "admin/mainTemplate.php" page.
- When I click the link, it goes nowhere, so I can't edit my site, user, etc.

MY FTP INFO:

FTP server: ftp.themillionsexchange.heliohost.org

FTP and explicit FTPS port: 21

Login: traffic@themillionsexchange.heliohost.org

Password: d)D#wzvEeMCS

Edited February 17, 2013 by millionexchange

bayparkm · February 17, 2013

It would help if you could post some example code so we could see what is going on.

millionexchange · February 22, 2013

admin/mainTemplate.php:

<?php
session_start();
if (!isset($_SESSION['letmein']))
{
   header ("Location: index.php?invalid=PLEASE LOGIN");
}
require_once('Connections/dbConnect.php');
require_once('../include.inc');
mysql_select_db($database_dbConnect, $dbConnect);
$query_menuItems = "select * from adminMenu where active='y'";
$menuItems = mysql_query($query_menuItems, $dbConnect) or die(mysql_error());
$row_menuItems = mysql_fetch_assoc($menuItems);
$totalRows_menuItems = mysql_num_rows($menuItems);
?>
<html>
<head>
<title>  </title>
<link href="default.css" rel="stylesheet" type="text/css">
</head>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>

<body bgcolor="#EFEFEF">
<table bgcolor="WHITE" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
   <td width="800">
   <!---  top menu --->
   <TABLE bgColor="WHITE" border="0" cellPadding="0" cellSpacing="0" width="800">
     <TBODY>
       <TR>
         <TD bgColor="WHITE" width="75"></TD>
         <TD  width="650"><div align="center">ADMINISTRATION PANEL</div></TD>
         <TD bgColor="WHITE" width="75"> </TD>
       </TR>
       <TR>
         <TD bgColor="WHITE" width=75></TD>
         <TD align="CENTER" bgColor="WHITE" height=20 vAlign="MIDDLE" width="650">
           <P align=left>
             <span class="smallstatsText"> </span>
           </P>
         </TD>
         <TD bgColor="WHITE" width=75> </TD>
       </TR>
     </TBODY>
   </TABLE>
   <!---  top menu end --->
   </td>
 </tr>
 <tr>
   <td width="800">
     <table width="100%" border="0" align="center" cellpadding="4">
       <tr>
         <td width="20%" align="center" valign="top">
           <div align="center"> <br><br></div>
         </td>
         <td width="61%" valign="top"> <font color="#CCCCCC">
           <?php
           do
           {
               $Zoption=$row_menuItems['id'];
               $Zfile = $row_menuItems['adminFile'];

               switch ($option)
               {
                   case $Zoption:
                   require_once($Zfile);
                   break;
                   //default:
                   //require_once('adminMenu.php');
                   case XXXX:
                   require_once('adminMenu.php');
                   break;
               }
           }
           while ($row_menuItems = mysql_fetch_assoc($menuItems));
           ?>
             <span class="smallstatsText">
               <a href="mainTemplate.php?option=XXXX"><<back to main menu</a>
             </span><br>
                   </font>
                 </TD>
         <td width="19%" valign="top">  </TD>
       </TR>
     </TABLE>
     <!-- END body area --->
   </tr>
   <tr>
     <td width="800" align="center">
       <table>
         <TR>
           <td class="smallstatsText"> </td>
         </tr>
       </table>
     </td>
   </tr>
</table>
</body>
</html>

/start.php

<?
session_start();
require 'include.inc';
if (!isset($_SESSION['letmein'])){
   header ("Location: index.php?invalid=PLEASE LOGIN");
                 }


?>
<SCRIPT language=JavaScript type=text/javascript>
 <!--
 if(window != window.top)
 {
     top.location.href=location.href;
 }
 // -->
 </SCRIPT>
<?php

$option=$_GET['option'];
//$userid=$_GET['userid'];
//$id=$_GET['id'];
?>
<?php include("common.php"); ?>

<? pageHeader($title, $bgColor, $styleSheet); ?>
<style type="text/css">
<!--
.style1 {
   font-family: Verdana, Arial, Helvetica, sans-serif;
   font-size: large;
   color: #CC0000;
   font-weight: bold;
}
body {
   background-image: url(images/bluegradient.gif);
}
a:link {
   color: #000066;
   text-decoration: none;
}
a:visited {
   text-decoration: none;
   color: #000066;
}
a:hover {
   text-decoration: underline;
   color: #FF9900;
}
a:active {
   text-decoration: none;
   color: #000066;
}
-->
</style>
<body>
<table bgcolor="#FFFFFF" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr>
   <td width="700">
         <!---  top menu --->
         <DIV align=left>
           <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
                 <tbody>
                   <tr>
                         <td  width="650" height="24"><div align="center" class="style1"><a href="index.php">
                           <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="780" height="200">
                                 <param name="movie" value="traffic.swf">
                                 <param name="quality" value="high">
                                 <embed src="traffic.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="780" height="200"></embed>
                           </object>
                         </a></div></td>
                   </tr>
                   <tr>
                         <td class="coolFont" align="center" bgcolor="#333333" height="20" valign="middle" width="650"><p align="center" >
                                 <script type="text/javascript"><!--
google_ad_client = "pub-<?php echo $google ?>";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text_image";
google_ad_channel ="";
google_color_border = "333333";
google_color_bg = "333333";
google_color_link = "ffffff";
google_color_text = "999999";
google_color_url = "CCCCCC";
//--></script>
                                 <script type="text/javascript"
 src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
                 </script>
                         </p></td>
                   </tr>
                 </tbody>
           </table>
         </DIV>
         <!---  top menu end --->
   </td>
 </tr>
 <tr>
   <td width="700"> <table width="100%" border="0" align="center" cellpadding="4">
           <tr>
                 <td width="20%" align="center" valign="top">
                   <? navigation($id, $headerColor, $tableColor2); ?>
                   <br>
                   <br>
                   <div align="center">
                         <? startSurfing($id, $username, $headerColor, $tableColor2); ?>
                         <BR>
                         <BR>
                         <? if ($sellPoints == 'true') {
                                                                 purchasePoints($headerColor, $tableColor2);}
                                 ;?>

                         <br>
                   </div></td>
                 <td width="61%" valign="top">
                   <table class="supermenuNoShadow" border=0 cellpadding="2" cellspacing="0" bgcolor="<? echo $tableColor; ?>">
                         <TR>
                           <TD valign="top" bgcolor="<? echo
$tableColor2; ?>" width="645">
                                 <B>Welcome, <? echo $username; ?></B> <font color="<? echo $alertColor; ?>"><B><? print $option; ?>:</b></font>
                                 <BR>
                                 <BR>
                                 <?
switch ($option) {

       case 'Url Deleted':
   urlDelete($id, $webid);
   personalStats($id, $username);
   break;
       case 'personal stats':
   personalStats($id, $username);
   break;
       case 'personal link':
   personalLink($id, $title, $siteUrl);
   break;
       case "Top25":
   top25();
   break;
   case "purchase banner ads":
   include("ba.php");
   break;
       case "purchase points":
   include("pp.php");
   break;
       case "frequently asked questions":
   faq();
   break;
       case "thank you for purchasing points":
   $bodyFile = "ty.php";
   break;

       default:
   mainStats($id,$username);        
   }
?>
                                 <center>
                                 </center></td>
                         </tr>
                   </table>              </TD>
           </TR>
         </TABLE>

 </tr>
 <tr>
   <td width="700" align="center">
         <? footer("$contact_email"); ?>
   </td>
 </tr>
</table>
</body>
</html>

index.php

<?php ob_start(); ?>
<?php include("common.php"); ?>
<?
session_start();
// Unset all of the session variables.
session_unset();
// Finally, destroy the session.
session_destroy();
/*
if ($_GET('signup')) {
error("SIGNUP");
  echo "Error Checking<br>";
  while(list($name, $value) = each($signup)) {
     echo "$name - $value<br>";
  }
}
*/
  require 'include.inc';
   if ($signup) {

  	if ($signup[repassword] != $signup[password]) {
  		$err_msg = "Your passwords do not match.";
error($err_msg);
  	}

  	if(!eregi("^[_\.0-9a-z-]+$",$signup[username])) {
  		$err_msg = "Invalid Username! Usernames can consist of letters and numbers only.";
error($err_msg);   	
}
  	if(!eregi("^[_\.0-9a-z-]+$",$signup[password])) {
  	   $err_msg = "Invalid Password!  Passwords can consist of letters and numbers only.";
  	}
     if(!$signup[password] || !$signup[username] || !$signup[email] || !$signup[username])
           $err_msg = "Oops! You forgot some important fields!";


     if (!$err_msg) {
$usercheck = @mysql_query("INSERT INTO user values(
     	'NULL','$signup[fname]','$signup[lname]',
     	'$signup[username]','$signup[password]','$signup[email]', 1, ".$pointInc.", '$signup[referral]', NOW(), 'n', 'y')");
     	
     	  // done, you are entered correctly, Now Enter the points and URL info


      		$sql = "Select id from user where username='$signup[username]'";

	$result = mysql_query( $sql );
		if ( $result != false )
			{
		while ( $data = mysql_fetch_assoc( $result ) )
		{
			$point_set = $data['id'];
	
			}
		} else {
			echo mysql_error();
		}	
	// add rerral points

if ($signup[referral])	{
  $referralSql="UPDATE points SET points=points+ ".$refPoints . " WHERE userid=".$signup[referral];
  $result = mysql_query( $referralSql );
				if ( $result != false )
					{
				} else {
					echo mysql_error();
					}
       }							
	
	
// add URL	

$sql="INSERT INTO url_table ( userid, website, active, datechanged) VALUES ($point_set,'".$signup[site_url]."','n', '".date("Ymd")."')";

  $result = mysql_query( $sql );
				if ( $result != false )
					{
				} else {
					echo mysql_error();
				}
// add points
      	$sql="INSERT INTO points (userid, username, points) VALUES ($point_set,' ',$signPoints)";
  $result = mysql_query( $sql );
				if ( $result != false )
					{
				} else {
					echo mysql_error();
					}
       }
        echo mysql_errno().": ".mysql_error()."<br>";





              	if (!$usercheck) {
     	   $err_msg = "Database error:<br>There was an error entering your account.<br>It is possible that username already exists, please try another one.<br>";
       	 }   else {
       	 	include ("reg.php"); 
       	 	exit;
       	 	}
        }
        if (!$err_msg) {
           // done, you are entered correctly



        }
  pageHeader($title, $bgColor, $styleSheet);
?>
<style type="text/css">
<!--
.style1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: large;
font-weight: bold;
color: #CC0000;
}
body {
background-image: url(images/bluegradient.gif);
}
a:link {
color: #000066;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #000066;
}
a:hover {
text-decoration: underline;
color: #FF9900;
}
a:active {
text-decoration: none;
color: #000000;
}
.style2 {color: #000066}
-->
</style>
<body>
<table bgcolor="#FFFFFF" border="0" align="center" cellpadding="0" cellspacing="0">
 <tr> 
   <td width="780"> 
     <TABLE width="100%" border="0" align="center" cellPadding="0" cellSpacing="0" bgColor="<? echo $tableColor; ?>">
       <TBODY>
         <TR> 
           <TD  width="100%" height="46"><div align="center" class="style1">
             <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="780" height="200">
               <param name="movie" value="traffic.swf">
               <param name="quality" value="high">
               <embed src="traffic.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="780" height="200"></embed>
             </object>
           </div></TD>
         </TR>
         <TR> 
           <TD class="coolFont" align="CENTER" bgColor="#FFCC00" height=20 vAlign="MIDDLE" width="100%"> 
             <P><center >                            <script type="text/javascript"><!--
google_ad_client = "pub-<?php echo $google ?>";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text_image";
google_ad_channel ="";
google_color_border = "ffcc00";
google_color_bg = "ffcc00";
google_color_link = "000066";
google_color_text = "999999";
google_color_url = "ffffff";
//--></script>
           <script type="text/javascript"
 src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
     </script>
             </center>
           </P></TD>
         </TR>
       </TBODY>
     </TABLE>

   </td>
 </tr>
 <tr> 
   <td width="780"> <table width="100%" border="0" align="center" cellpadding="4">
       <tr> 
         <td width="50%" valign="top"><TABLE bgcolor="<? echo $tableColor2; ?>" cellPadding=2 cellSpacing=0 class="supermenu" width=100%>
             <TR> 
               <TD class="coolFont"> 
                  <font color="red"><B><?php print 
$_GET['invalid']; ?></b></font>                </TD>
             </TR>
             <TR> 
               <TD   vAlign="MIDDLE" bgColor="<? echo $headerColor; ?>"  class="menuHeader">member 
                 login  </TD>
             </TR>
             <TR> 
               <TD  colSpan="2"> <form name="login" method="post" action="validate.php">
                   <table class="font" border=0 align="center">
                     <tr> 
                       <td>User ID: </td>
                       <td><input name="uname" type="text" size="10"></td>
                     </tr>
                     <tr> 
                       <td> Password: </td>
                       <td><input name="password" type="password" size="10"></td>
                     </tr>
                     <tr> 
                       <td colspan=2><div align="right"> 
                           <input name="submit" type="submit" value="Login">
                         </div></td>
                     </tr>
                     <tr> 
                       <td colspan=2><div align="right"><a href="reset.php">Lost 
                           Password</a></div></td>
                     </tr>
                   </table>
                 </form></TD>
             </TR>
           </TABLE>
           <div align="center"><?php
		$sql = "SELECT * from rightBlock where active='y' and position='l'";
$result = mysql_query( $sql );
if ( $result != false )
{
	while ( $data = mysql_fetch_assoc( $result ) )
	{
	$title=$data['title'];
	$bodyText=$data['body'];
	
	?>
	    <TABLE bgcolor="<? echo $tableColor2; ?>"  class="supermenu" cellPadding=4 cellSpacing=0  width=100%>
             <TR> 
               <TD class="menuheader" bgColor="<? echo $headerColor; ?>"  vAlign="MIDDLE"> <? echo $title; ?>                </TD>
             </TR>
             <TR> 
               <TD height="32" colSpan="2" valign="top" > 
                 <table border=0>
                   <tr> 
                     <td valign="top" width="392" class="font"><? echo $bodyText; ?></td>
                   </tr>
                 </table></TD>
             </TR>
           </TABLE><BR>
           <?php	

	}
} else {
	echo mysql_error();
}

?><br>
             <br>
         </div></td>
         <td width="50%" align="right" valign="top"><table width=100% border=0 align="right"  cellpadding=2 cellspacing=0>
             <tr> 
               <td width="100%"  colspan="2" align="CENTER"></td>
             </tr>
             <tr> 
               <td colspan=2 valign="TOP"><Table width=100% cellpadding="2" cellspacing="0" class="supermenuNoshadow"><TR><TD>
<?php echo $mainText; ?>
</td></tr></table>

                 <form name="form"  action="<? echo $PHP_SELF; ?>" method="post">
<input type="hidden" name="signup" value="true">                   
<table bgcolor="<? echo $tableColor2; ?>" class="signupTable" width=100% cellpadding="2" cellspacing="0" align=center>
                     <tr> 
                       <td class="menuheader" bgColor="<? echo $headerColor; ?>" colspan=2> 
                         <? if ($err_msg) echo "<font color=red size=2>$err_msg</font><br>"; ?>
                         <b>Please Enter Your Information:</b></td>
                     <tr valign="top"> 
                       <td>First Name:</td>
                       <td> 
                         <blockquote> 
                           <input type="text" name="signup[fname]" maxlength="36" size="25" value="<? echo ($signup[fname])?$signup[fname]:""; ?>">
                         </blockquote></td>
                     </tr>
                     <tr valign="top"> 
                       <td> Last Name:</td>
                       <td> 
                         <blockquote> 
                           <input type="text" name="signup[lname]" maxlength="36" size="25" value="<? echo ($signup[lname])?$signup[lname]:""; ?>">
                         </blockquote></td>
                     </tr>
                     <tr valign="top"> 
                       <td> E-mail:</td>
                       <td> 
                         <blockquote> 
                           <input type="text" name="signup[email]" maxlength="255" size="25" value="<? echo ($signup[email])?$signup[email]:""; ?>">
                         </blockquote></td>
                     </tr>
                     <tr> 
                       <td class="menuheader" bgColor="<? echo $headerColor; ?>"  colspan = 2> <b>Please supply a Username and Password.</b></td>
                     </tr>
                     <tr valign="top"> 
                       <td> Username:</td>
                       <td> 
                         <blockquote> 
                           <input type="text" name="signup[username]" maxlength="10" size="25" value="<? echo ($signup[username])?$signup[username]:""; ?>">
                         </blockquote></td>
                     </tr>
                     <tr valign="top"> 
                       <td> Password:</td>
                       <td> 
                         <blockquote> 
                           <input type="password" name="signup[password]" maxlength="10" size="25">
                         </blockquote></td>
                     </tr>
                     <tr valign="middle"> 
                       <td> Re-Enter Password:</td>
                       <td> 
                         <blockquote> 
                           <input type="password" name="signup[repassword]" size="25">
                         </blockquote></td>
                     </tr>
                     <tr valign="top"> 
                       <td> URL to your site:</td>
                       <td> 
                         <blockquote> 
                           <input type="text" name="signup[site_url]" maxlength="255" size="25" value="<? echo ($signup[site_url])?$signup[site_url]:"http://"; ?>">
                         </blockquote></td>
                     </tr>
                     <tr valign="top"> 
                       <td> Referral ID:</td>
                       <td> 
                         <blockquote> 
                           <?php print $_GET['referral']; ?><input type="hidden" name="signup[referral]" maxlength="10" size="25" value="<? echo ($signup[referral])?$signup[referral]:"$referral"; ?>">
                         </blockquote></td>
                     </tr>
                     <tr> 
                       <td class="yell" colspan=2>Please be patient as we process your account. Thank you. </td>
                     </tr>
                     <tr> 
                       <td colspan=2> <input name="submit2" type="submit" value="Signup">                        </td>
                     </tr>
                   </table>
                 </form></td>
             </tr>
             <tr>
               <td colspan=2 valign="TOP"><? 
switch ($option) {
case "Contact Me":
contactMe($contact_email);
break;
case "frequently asked questions":
faq();
break;
case "marketing resources":
marketingResources($clickBank, $title);
break;
default:
			}
?></td>
             </tr>
         </table>			</TD>
       </TR>
     </TABLE>
   </tr>
 <tr> 
   <td width="100%" align="center"> 
     <? footer("$contact_email"); ?>    </td>
 </tr>
</table>
</body>
</html>

Sign In

Traffic Exchange Site Errors

Recommended Posts

millionexchange

Link to comment

Share on other sites

bayparkm

Link to comment

Share on other sites

millionexchange

Link to comment

Share on other sites

Join the conversation

HelioHost

Donate

Forums

Activity