mam problem v install.php prepis tabulky pomoc

<?

include("common.php"); 
$link = mysql_connect($dbhost, $dbuser, $dbpassword)
        or die("Could not connect: " . mysql_error());
          mysql_select_db($dbname);
          
mysql_query("DROP TABLE IF EXISTS `t_Banners`") or die("Oops: ".mysql_error());

mysql_query("CREATE TABLE `t_Banners` (
  `n_ID` bigint(20) NOT NULL auto_increment,
  `n_UserID` bigint(20) default NULL,
  `b_Authorised` tinyint(4) default '0',
  `s_URL` char(80) default NULL,
  `s_Graphic` char(80) default NULL,
  `n_Category` int(11) default NULL,
  `n_Displays` bigint(20) default '0',
  `n_Clicks` bigint(20) default '0',
  `n_ExpireViews` bigint(20) default '0',
  `n_ExpireClicks` bigint(20) default '0',
  `b_Paid` tinyint(4) default '0',
  PRIMARY KEY  (`n_ID`)
) TYPE=MyISAM;") or die("Oops: ".mysql_error());

mysql_query("DROP TABLE IF EXISTS `t_Categories`") or die("Oops: ".mysql_error());
mysql_query("CREATE TABLE `t_Categories` (
  `n_ID` int(11) NOT NULL auto_increment,
  `n_ParentID` int(11) default NULL,
  `s_Name` char(32) default NULL,
  `b_Selectable` tinyint(4) default NULL,
  PRIMARY KEY  (`n_ID`)
) TYPE=MyISAM;") or die("Oops: ".mysql_error());

mysql_query("DROP TABLE IF EXISTS `t_Stats`") or die("Oops: ".mysql_error());
mysql_query("CREATE TABLE `t_Stats` (
  `n_ID` int(11) NOT NULL default '0',
  `s_Name` varchar(32) NOT NULL default '',
  `s_Description` varchar(64) NOT NULL default '',
  `n_Value` bigint(20) NOT NULL default '0',
  UNIQUE KEY `n_ID` (`n_ID`)
) TYPE=MyISAM;") or die ("Oops: ".mysql_error());

mysql_query("INSERT INTO `t_Stats` VALUES (0, 'totalviews', 'Banners served to date', 0);") or die ("Oops: ".mysql_error());

mysql_query("DROP TABLE IF EXISTS `t_Users`") or die("Oops: ".mysql_error());
mysql_query("CREATE TABLE `t_Users` (
  `n_ID` bigint(20) NOT NULL auto_increment,
  `s_Username` char(16) default NULL,
  `s_Password` char(16) default NULL,
  `n_Credits` float(20,2) default NULL,
  `s_Email` char(32) default NULL,
  `n_Views` bigint(20) default NULL,
  `n_Clicks` bigint(20) default NULL,
  `n_Rand` int(11) default NULL,
  `b_Authedban` tinyint(4) default '0',
  `b_Admin` tinyint(4) default '0',
  `b_Newsletter` tinyint(4) default NULL,
  `b_Activated` tinyint(4) default '0',
  `n_RefererID` bigint(20) default NULL,
  `logged_ip` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`n_ID`)
) TYPE=MyISAM;") or die ("Oops: ".mysql_error());

mysql_query("INSERT INTO `t_Users` VALUES (1, 'admin', 'admin', '10000000.00', 'neo@cyberia.ca', 0, 0, 905, 0, 1, 1, 1, 1, 1);") or die ("Oops: ".mysql_error());

$q1 = "DROP TABLE IF EXISTS job_banners_m";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE job_banners_m (
  bc char(1) NOT NULL default '')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "DROP TABLE IF EXISTS job_banners_t";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE job_banners_t (
  b_id varchar(10) NOT NULL default '',
  fn varchar(100) NOT NULL default '',
  burl varchar(100) NOT NULL default '',
  alt varchar(255) default NULL)";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

echo "installation completed successfully!";

?>

<?
include("common.php");
if(!$username && !$password)
{
include("header.php");
?><center>
<h3>Log in to the <?=$bannerexchangename?></h3>
<form name=login method=post action=login.php>
<table>
<tr>
<td align=right>
    Username:
</td>
<td>
    <input name=username type=text size="15">
</td>
</tr>
<tr>
<td align=right>
    Password:
</td>
<td>
    <input name=password type=password size="15">
</td>
</tr>
<tr>
<td colspan=2 align=center>
   <input type=submit value="Log in">
</td>
</table>
</form>

<?
include ("footer.php");
}
else
{
$link = mysql_connect($dbhost, $dbuser, $dbpassword)
or die("Could not connect: " . mysql_error());
  mysql_select_db($dbname,$link);
  $sSQL="select n_ID, s_Password, n_Rand, b_Activated from t_Users where s_Username=\"".stripjunk($username)."\"";
  $results=mysql_query($sSQL);
  if(mysql_num_rows($results)>0)
  {
list($id, $pwd, $rand, $b_Activated)=mysql_fetch_row($results);
    if($b_Activated<>1)
    {
    include ("header.php");
        echo "Your account is not active yet, please click the link in the welcome email to activate it (you can't log in until it's active)";
    }
    elseif($pwd==$password)
    {
    setcookie("bannerexchangename", $username,0,"/");
    setcookie("bannerexchangerand", $rand,0,"/");
    setcookie("bannerexchangeid", $id,0,"/");

   // Here Update the logged in IP to the user

   $ip = $_SERVER['REMOTE_ADDR'];
    $qry = "update t_Users set logged_ip='$ip' where n_ID='$id'";
    mysql_query($qry);


   // Also set a cookie with the id as referral id so as to block user creating user duplicate accounts..

   setcookie("user_referral",$id,0,"/");

   echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=./account.php?action=account\">";
    }
    else
    {
    echo "Password incorrect, if you're sure this is your account and have forgotten your password, please click <a href=./forgotpwd.php?username=".stripjunk($username).">here</a> to have your password emailed to you.";
    }
  }
  else
  {
    include ("header.php");
     echo "The specified username does not exist";

 }
  
mysql_close();
}

include ("footer.php");
?>

$sSQL="select * from t_Banners where n_UserID=".stripjunk($n_ID)." and b_Authorised=1";