Unable to connect to database"); } $dbselect = @mysql_select_db("heyppl_db"); //-------------------------------------------------------------- $refer = $HTTP_REFERER; $url = getenv("REQUEST_URI"); $browser = $HTTP_USER_AGENT; $ip = $REMOTE_ADDR; if ($url !== '/multimania/fr/heyppl/hits.php3') { $query = @mysql_query("INSERT INTO visitors (time, referer, browser, ip, page) VALUES (now(),'$refer','$browser','$ip','$url');"); } if ($id) { $query = mysql_query("SELECT username,password FROM users WHERE id='$id'"); while ($row = mysql_fetch_array($query)) { $password = $row[password]; $username = $row[username]; } } if ($signout) { setcookie("id"); $username = ""; $password = 0; $signout = 0; $id = ""; } if (!$username and !$password) { $nothing = "true"; } if (!$signout) { if ($id !== '') { $password = md5($password); } if ($username) { $query = mysql_query("SELECT id,username,password FROM users"); while ($row = mysql_fetch_array($query)) { if (!strcasecmp($username,$row[username])) { if (!strcasecmp($password,$row[password])) { $id = $row[id]; if ($permanent) { $id = $row[id]; setcookie("id", "$id", time() + 1209600); } } Else { $nousername = "true"; } } Else { $nopassword = "true"; } } } } include("head.php"); if (!$page) { include("main.php3"); } elseif ($page == "main") { include("main.php3"); } elseif ($page == "editfile") { //PHP script //begin file editing script //------------------------------ if ($done) { $admin = mysql_query("SELECT admin FROM users WHERE ID='$id'"); $admin2 = mysql_result($admin,0); if (!strpos($admin2,"A")) { echo ("You do not have the correct permissions to access this page"); exit(include("bottom.php3")); } $contents = str_replace("[b]", "", $contents); $contents = str_replace("[/b]", "", $contents); $contents = str_replace("[u]", "", $contents); $contents = str_replace("[/u]", "", $contents); $contents = str_replace(" ", "
", $contents); $file = fopen($filename,"w"); $write = fputs($file , $contents, strlen($contents)); fclose($file); echo (" File written to \"") . $contents . ("\""); } echo ("
Filename:

Contents:


"); } //end script elseif ($page == "newuser") { include("newuser.php3"); } elseif ($page == "quote") { include("quote.php3"); } elseif ($page == "search") { include("search.php3"); } elseif ($page == "newuser2") { include("newuser2.php3"); } elseif ($page == "hits") { $date = date("Y-m-d"); $datey = date("Y"); $datem = date("m"); $dated = date("d") - 1; $date2 = $datey . "-" . $datem . "-" . $dated; $datey = date(Y); $datem = date(m); $date3 = $datey . "-" . $datem; $query1 = mysql_query("SELECT COUNT(*) FROM visitors WHERE time LIKE '%$date%' AND page='/multimania/fr/heyppl/index.php3'"); $query2 = mysql_query("SELECT COUNT(*) FROM visitors WHERE page='/multimania/fr/heyppl/index.php3' OR page='/heyppl/index.php3'"); $query4 = mysql_query("SELECT COUNT(*) FROM visitors WHERE time LIKE '%$date3%' AND page='/multimania/fr/heyppl/index.php3'"); $quer1 = mysql_result($query1,0); $quer2 = mysql_result($query2,0); $quer4 = mysql_result($query4,0); echo ("

Our counter is on $quer2 hits.
"); echo ("Today we have had $quer1 hits
"); echo ("This month we have had $quer4 hits.

"); } elseif ($page == "list") { include("list.php3"); } elseif ($page == "addsite") { include("addsite.php3"); } elseif ($page == "recommend") { include("recommend.php3"); } elseif ($page == "signup") { include("main.php3"); } elseif ($page == "changepassword") { echo ("Please enter the password you want to change to:

Please type in your password again:

"); if ($done) { if ($password1 == $password2) { $password1 = md5($password1); $query = mysql_query("UPDATE users SET password='$password1' WHERE id='$id'"); echo ("Your password has been changed"); } Else { echo (" The two passwords you entered do not match"); } } } elseif ($page == "admin") { if ($id) { $admin = mysql_query("SELECT admin FROM users WHERE ID='$id'"); $admin2 = mysql_result($admin,0); } if (strpos($admin2,"A")) { include("admin.php3"); } Else { echo ("You do not have the correct permissions to access this page"); } } else { echo ("


404: Page not found

"); } include("bottom.php"); ?>