phpBB.de

Code: Alles auswählen

<?php
function login(){
	global $ad_name, $pre;
	print "Login<br>
		<form method=\"post\" action=\"$ad_name\"> 
			<table cellspacing=\"0\" cellpadding=\"0\">
			  <tr>
				<td><input type=\"hidden\" name=\"action\" value=\"show\">User</td>
				<td><input type=\"text\" name=\"username\"></td>
			  </tr>
			  <tr>
				<td>Passwort </td>
				<td><input type=\"password\" name=\"password\"></td>
			  </tr>
			  <tr>
				<td>&nbsp;</td>
				<td><input type=\"submit\" value=\"Weiter\"></td>
			  </tr>
			</table>
		</form>";
}

session_start();
include "config.php";

if ($user == $username && $pass == $password){
	session_register("user");
	session_register("pass");
}

print "<div align=\"center\">";

if ($_SESSION[user] == $user && $_SESSION[pass] == $pass){
	$connect =  mysql_connect("localhost", $benutzer, $passwort );
	if (! $connect) die("Keine Verbindung zu MySQL");
	mysql_select_db($db, $connect) or die ("Konnte Datenbank \"$db\" nicht öffnen: ".mysql_error());
	
	
	if ($action == "delete") {
		mysql_query("DELETE FROM $tabelle WHERE ID='$id' LIMIT 1");
		print "	<font color=\"red\">Eintrag '$id' gelöscht!</font>";
	}
	
	if ($_GET[action] == "new") {
		mysql_query("INSERT INTO $tabelle (id, klicks, url) VALUES ('$id', '$_POST[klicks]', '$_POST[url]')");
		print "	<font color=\"green\">Eintrag eingefügt!</font>";
	}

	if ($_GET[action] == "optimize") {
		mysql_query("OPTIMIZE TABLE $tabelle");
		print "'$tabelle' optimiert!";
	}
	
	if ($_GET[action] == "edit_form") {		
		$sql = "SELECT * FROM $tabelle WHERE id = $id";
		$sql = mysql_query($sql);		
		$row = mysql_fetch_assoc($sql);		
		print "<br><form action=\"$ad_name$pre=update&id=$id&PHPSESSID=".session_id()."\" method=\"post\">
				URL: <input value=\"$row[url]\" name=\"url\" type=\"text\" size=\"30\" maxlength=\"250\">
				Klicks: <input name=\"klicks\" type=\"text\" value=\"$row[klicks]\" size=\"3\" maxlength=\"10\">
				<input type=\"submit\" value=\"Ändern\">
				</form>";
	}
	
	if ($_GET[action] == "update") {
		mysql_query("UPDATE $tabelle SET klicks = '$klicks', url = '$url' WHERE id = $id");
		print "Eintrag '$id' geändert!";
	}
	
	if ($_GET[action] == "neu") {
		print "<br><form action=\"$ad_name$pre=new&PHPSESSID=".session_id()."\" method=\"post\">
				URL: <input name=\"url\" type=\"text\" size=\"30\" maxlength=\"250\">
				Klicks: <input name=\"klicks\" type=\"text\" value=\"0\" size=\"3\" maxlength=\"10\">
				<input type=\"submit\" value=\"Eintragen\">
				</form>";
	}	

	if (empty($_GET[orderby])) {
		$orderby = "id";
	}
	$sql = "SELECT * FROM $tabelle ORDER BY $orderby DESC";
	$sql = mysql_query($sql);
	
	if (mysql_num_rows($sql) > 0){
		print "<table cellpadding=\"0\">
			   <tr>
			   <td width=\"40\" bgcolor=\"$ad_color1\"><strong><a href=\"$ad_name$pre=$_GET[action]&orderby=id&PHPSESSID=".session_id()."\">ID</a></strong></td>
			   <td width=\"350\" bgcolor=\"$ad_color1\"><strong>URL</strong></td>
			   <td width=\"60\" bgcolor=\"$ad_color1\"><strong><a href=\"$ad_name$pre=$_GET[action]&orderby=klicks&PHPSESSID=".session_id()."\">Klicks</a></strong></td>
			   <td width=\"80\" bgcolor=\"$ad_color1\"><strong>Aktion</strong></td>
			   </tr>";
	
		while( $row = mysql_fetch_assoc($sql) ) {
			$id = $row['id'];
			$klicks = $row['klicks'];
			$url = $row['url'];
			
			
			$color = ($i % 2) ? $ad_color2 : $ad_color3; 
			$i++;
					
			print " <tr>
					<td bgcolor=\"$color\"><strong>$id</strong></td>
					<td bgcolor=\"$color\"><a href=\"$url\" target=\"_blank\">";
			if (strlen($url) > 50) {
				$url = substr($url, 0, 50)."...";
			}
			print " $url</a></td>
					<td bgcolor=\"$color\">$klicks</td>
					<td bgcolor=\"$color\"><a href=\"$ad_name$pre=delete&id=$id&PHPSESSID=".session_id()."\">[delete]</a>
					<a href=\"$ad_name$pre=edit_form&id=$id&PHPSESSID=".session_id()."\">[edit]</a></td>
					</tr>";		
		}
		print "</table>";
	}

	else {
		print "Keine Einträge vorhanden!";
	}
	print "<br><a href=\"$ad_name$pre=neu&PHPSESSID=".session_id()."\">[neuen Eintrag einfügen]</a> 
	<a href=\"$ad_name$pre=optimize&PHPSESSID=".session_id()."\">[Tabelle optimieren]</a>
	<a href=\"$ad_name?PHPSESSID=".session_id()."\">[start]</a>
	<br>";
	mysql_close();
}
else {
	login();
}
print "<br>stuff24_cc by hacky || <a href=\"http://www.stuff24.de\" target=\"_blank\">stuff24.de</a></div>"; //Bitte nicht entfernen!
?>

Code: Alles auswählen

<!--    stuff24_clickcounter by Hacky 
      visit http://www.stuff24.de to download this Script --> 
<?php 
include "stuff24_cc/config.php"; 

$url = $_GET['url']; 
$url2 = $_GET['url2']; 

$connect =  mysql_connect( "localhost", $benutzer, $passwort  ); 
if ( ! $connect ) die( "Keine Verbindung zu MySQL" ); 
mysql_select_db( $db, $connect ) or die ( "Konnte Datenbank \"$db\" nicht öffnen: ".mysql_error() ); 

if (isset($url2)) { 
   $abc = "SELECT * FROM $tabelle WHERE url = '".mysql_real_escape_string($url2). "'"; 
   $abc = mysql_query($abc); 
   $row = mysql_fetch_assoc($abc); 
   print $row['klicks']; 
} 

if (isset($url)) { 
   $sql = "SELECT * FROM $tabelle WHERE url='".mysql_real_escape_string($url). "'"; 
   $sql = mysql_query($sql); 
    
   $row = mysql_fetch_assoc($sql); 
   $id = $row['id']; 
   $klicks = $row['klicks']; 
   $url = $row['url']; 
    
   if (!isset($klicks)) { 
      if ($auto_in == "1") { 
         mysql_query("INSERT INTO cc_links (id, klicks, url) VALUES ('$id', '0', '" . mysql_real_escape_string($url). "')"); 
         print "Neuer Eintrag! <a href=\"$url\">Weiter></a><br>"; 
      } 
      else { 
         print "Falsche url übergeben! $url existiert nicht in der Datenbank.<a href=\"javascript:history.back();\">[Zur&uuml;ck]</a>"; 
      } 
   } 
    
   else { 
      $neu_klicks = $klicks + 1;       
      $update = "UPDATE $tabelle SET klicks = $neu_klicks WHERE url = '" . mysql_real_escape_string($url). "'"; 
      $update = mysql_query($update);    
header("Location:$url"); 

      /*print "<script language=\"javascript\"> 
      self.location.href='$_GET[url]' 
      </script>";*/ 

   } 
} 
mysql_close(); 
?>

Code: Alles auswählen

error_reporting(1+2+4+8);