Beiträge von mischalemaus

RewriteEngine On
RewriteCond %{HTTP_HOST} ^garnelen-hl.de$ [NC]
RewriteRule ^(.*) http://www.garnelen-hl.de/$1




RewriteCond %{QUERY_STRING} ^s=garnelen/red%20bee$
RewriteRule ^$ http://www.garnelen-hl.de/?s=garnelen/red_bee


RewriteCond %{QUERY_STRING} ^s=artikel/sansibar_rock$
RewriteRule ^$ http://www.garnelen-hl.de/?s=artikel/sansibar-rock-im-garnelenaquarium


RewriteCond %{QUERY_STRING} ^s=garnelen/gruene%20zwerggarnele$
RewriteRule ^$ http://www.garnelen-hl.de/?s=garnelen/gruene_zwerggarnele


RewriteCond %{QUERY_STRING} ^s=garnelen/white%252520pearl$
RewriteRule ^$ http://www.garnelen-hl.de/?s=garnelen/white_pearl


RewriteCond %{QUERY_STRING} ^s=start$
RewriteRule ^$ http://www.garnelen-hl.de/?


RewriteRule ^(.*).html$ /index.php?s=$1 [L]


RewriteCond %{QUERY_STRING} ^s=(.*)$
RewriteRule ^$ /%1.html? [L,R=301]

<?
$akt = $_GET['akt'];
    $pre = mysql_query("SELECT aid FROM user WHERE email='".$_GET['akt']."'");


if($pre !== $akt)
{ echo "Leider ist ein Fehler mit dem Link aufgetreten. Bitte setzten sie sich mit dem Admin in Verbindung!"; die (); }
mysql_query("update user set aktiv = '2' where (aid)='$akt'");
?>
<h2>Ihre Registrierung wurde erfolgreich abgeschlossen</h2>
<p>Sie können sich nun direkt einloggen</p>

include("config.php");


    $qry = mysql_query("SELECT * FROM uploads");

        while($row = mysql_fetch_array($qry))  {


        $deltime = $config['deltime'];
        $diff = $row['date'] - date(time());
        $count = $diff + ($deltime);    


        echo $count;

        }

<script type="text/javascript">
function FensterOeffnen (Adresse) {
  MeinFenster = window.open(Adresse, "Zweitfenster", "width=1024,height=768,scrollbars=yes");
  MeinFenster.focus();
}
</script>


<?php


    $ausgabe = '<h3><img src="images/logo3.jpg" alt="8pic" border="0" /> Deine hochgeladenen Fotos...</h3><table border="0" cellspacing="10">';


    if(isset($_SESSION['loggedin']) && !isset($_GET['action'])) {


        if(isset($_GET['del'])) {


            $qqry = mysql_query("SELECT * FROM uploads WHERE id = '".$_GET['del']."' ORDER BY id DESC LIMIT 1");
            $qrow = mysql_fetch_array($qqry);
            if($qrow['userid']==$_SESSION['loggedin']) {


                unlink("uploads/".$qrow['pic']);
                unlink("uploads/thumb5_".$qrow['pic']);
                unlink("uploads/thumb4_".$qrow['pic']);
                unlink("uploads/thumb3_".$qrow['pic']);
                unlink("uploads/thumb2_".$qrow['pic']);
                unlink("uploads/thumb1_".$qrow['pic']);
                mysql_query("DELETE FROM uploads WHERE id = '".$_GET['del']."'");
                linkindex("index.php?site=userpics");

            }

        }


        $qry = mysql_query("SELECT * FROM uploads WHERE userid = '".$_SESSION['loggedin']."'");
        while($row = mysql_fetch_array($qry))  {


            $ausgabe .= '<tr><td><img src="uploads/thumb5_'.$row['pic'].'" width="150" alt="" border="0"></td><td>'.$row['pic'].'<br /><br />
            <a href="index.php?site=userpics&del='.$row['id'].'" onClick="return confirm(\'Wirklich loeschen?\')">Dieses Bild l&ouml;schen</a><br /><br />
            <a href="code.php?id='.$row['id'].'" onclick="FensterOeffnen(this.href); return false">HTML Code einsehen</a>';

        }


        $ausgabe .= '</table>';
    }


    if(isset($_GET['action'])) {


        $ausgabe = '';


    }


?>

<script type="text/javascript">
function FensterOeffnen (Adresse) {
  MeinFenster = window.open(Adresse, "Zweitfenster", "width=1024,height=768,scrollbars=yes");
  MeinFenster.focus();
}
</script>


<?php


    $ausgabe = '<h3><img src="images/logo3.jpg" alt="8pic" border="0" /> Deine hochgeladenen Fotos...</h3><table border="0" cellspacing="10">';


    if(isset($_SESSION['loggedin']) && !isset($_GET['action'])) {


        if(isset($_GET['del'])) {


            $qqry = mysql_query("SELECT * FROM uploads WHERE id = '".$_GET['del']."' ORDER BY id DESC LIMIT 1");
            $qrow = mysql_fetch_array($qqry);
            if($qrow['userid']==$_SESSION['loggedin']) {


                unlink("uploads/".$qrow['pic']);
                unlink("uploads/thumb5_".$qrow['pic']);
                unlink("uploads/thumb4_".$qrow['pic']);
                unlink("uploads/thumb3_".$qrow['pic']);
                unlink("uploads/thumb2_".$qrow['pic']);
                unlink("uploads/thumb1_".$qrow['pic']);
                mysql_query("DELETE FROM uploads WHERE id = '".$_GET['del']."'");
                linkindex("index.php?site=userpics");

                if(empty($qrow));
                {
                echo 'noch kein bild vohanden';
                }

            }

        }


        $qry = mysql_query("SELECT * FROM uploads WHERE userid = '".$_SESSION['loggedin']."'");
        while($row = mysql_fetch_array($qry))  {


            $ausgabe .= '<tr><td><img src="uploads/thumb5_'.$row['pic'].'" width="150" alt="" border="0"></td><td>'.$row['pic'].'<br /><br />
            <a href="index.php?site=userpics&del='.$row['id'].'" onClick="return confirm(\'Wirklich loeschen?\')">Dieses Bild l&ouml;schen</a><br /><br />
            <a href="code.php?id='.$row['id'].'" onclick="FensterOeffnen(this.href); return false">HTML Code einsehen</a>';

        }


        $ausgabe .= '</table>';
    }


    if(isset($_GET['action'])) {


        $ausgabe = '';


    }


?>

<?php		


	/**
	 *	Main / frontpage script
	 * 
	 *	@package 	ClassAd
	 *	@author 	cts projects&software <classad@projects-and-software.de>
	 *	@copyright 	cts projects&software 2002-2006
	 *	@copyright	All rights reserved
	 *	@version	4.00
	 * 
	 */


	// Include everything classAd needs
	require "inc/includer.inc.php";


	
	//
	// Init variables
	//
	$WelcomeString = "";
	$CatTable = "";

	// Build header information
	$PageTitle = GetPageTitle(LANG_TTLCATSELECT);
	$CacheTag = "";

	// Send header
	include "inc/header.inc.php";

	// Open Database
	$DB = new SQLDatabase();
	$DB->dbconnect();
	if($DB==false)	{
		echo LANG_DBCONNECTERRORCUST;
		die();
	}

	// Do maintenance work
	if(!GetConfig('CRONJOB'))	{

		$iRand = (int)rand(1,(integer)GetConfig('MAINTAIN_PROBABILITY'));
		if($iRand==1)		{

			require_once("inc/maintain.inc.php");
			$oMaintain = new Maintain();

			if(GetConfig('AUTODELETEOUTDATED'))		{
				$oMaintain->DeleteOutdatedAds();
			}

			$oMaintain->DeleteInactiveUsers();
			$oMaintain->DeleteAlterPasswords();
			$oMaintain->UpdateCache();
		}
	}


	// Userdata
	// Indexpage
	if(isset($_SESSION['s_UserInfo']) && is_array($_SESSION['s_UserInfo']) 
		&& !empty($_SESSION['s_UserInfo']['userid']))		{

		$WelcomeString = ParseIn(LANG_INDEXUSERWELCOME, $_SESSION['s_UserInfo']['userrealname'],
			$_SESSION['s_UserInfo']['username'])."&nbsp;<br>".
			ParseIn(LANG_INDEXNEWARTICLES,AddSinceDate($_SESSION['s_UserInfo']['userlastlogin']));
	} else { 
		$WelcomeString = LANG_INDEXUSERUNKNOWN;
	}


	// Get user security
	if(GetConfig('SEC_HIDE_AGEREST_CATS') && GetConfig('SEC_FORCE_AGE_REST'))	{
		// Check user security
		if(isset($_SESSION['s_UserInfo']) && $_SESSION['s_UserInfo']['useragechecked'])	{
			// User checked ok
			$SecurityCheck = FALSE;
		} else {
			// User not authenticated or has proper rights
			$SecurityCheck = TRUE;	
		}
	} else {
		// Show all category entries
		$SecurityCheck = FALSE;	
	}




	// Reread Variables

	if(GetConfig('OP_SIMPLE_CATS'))		{


		$TotalArticles = ParseIn(LANG_SHOWADSARTICLECOUNT, GetArticlesInDB());

		// Read categories and sort them
		$sql = "SELECT * from cf_categories WHERE catprev IS NULL";

		switch(GetConfig('LY_SORT_ORDER_CATS'))	{
			case "2":
				// Sort by Name
				$sql.= " ORDER BY catname";
				break;
			case "3":
				// Sort by name descending
				$sql.= " ORDER BY catname DESC";
				break;
			default:
				// default sorter
				$sql.= " ORDER BY catid";
				break;
		}

		// Query database
		$data = $DB->dbselect($sql);
		if(!is_array($data))	{
			// No data or connection failed!
			echo LANG_DBEMPTYCATS;
			echo "<p><a href=\"admin.php\">".LANG_LINKTOADMINNOCATS."</a>";
			die();	
		}

		// Show categories
		$CatTable = "<div class=\"headline\">".
			LANG_HEADLINECATSELECT.
			"</div>".
			"<div class=\"subheadline\">".
			$TotalArticles.
			"</div>";


		$CatTable.= "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"classad\">";

		// All categories loop
		foreach($data as $element)		{

			// Ageresticted cats should be hidden
			if(($element['catagerestricted']==1 && !$SecurityCheck) || 
				$element['catagerestricted']==0)	{

				// Build some variables
				$strRestrictedPic = "<img src= \"".GetConfig('PD_SCRIPTGRAPHICS')."alert.gif\" ".
					"alt=\"".LANG_INDEXNEWARTICONAGE."\">";
				$strNewPic = "<img src= \"".GetConfig('PD_SCRIPTGRAPHICS')."new.gif\" ".
					"alt=\"".LANG_INDEXNEWARTICONNEW."\">";	

				// Get latest entry / last user visit
				$dtLatestIn = GetLatestArticlesPerCat($element['catid']);	
				$bNew = FALSE;	
				if(isset($_SESSION['s_UserInfo']['userlastlogin']))		{
					$bNew = ($dtLatestIn >= $_SESSION['s_UserInfo']['userlastlogin']?TRUE:FALSE);	
				}	

 				// Add logo
				$CatTable .= "<tr>".
					(!empty($element['caticonlink'])?"<td width=\"5%\" class=\"previewimage\">".
						"<img src=\"".GetConfig('PD_DIRCATLOGOS').$element['caticonlink']."\" ".
						"alt=\"".$element['catname']."\"></td>":"");



				// Add category title
				$CatTable.= "<td width=\"25%\" class=\"catblock\">".
					"<a href=\"showads.php?catid=".$element['catid']."\">".$element['catname']."</a>".
					"</td>";

				// Add category description
				$CatTable.= "<td width=\"60%\"class=\"catblock\">".
					(GetConfig('SEC_FORCE_AGE_REST') && $element['catagerestricted']==1?$strRestrictedPic:"").
					$element['catdesc'].
					"</td>";

				// Add category information
				$CatTable .= "<td width=\"15%\" class=\"catblock\" align=\"right\">".
					ParseIn(LANG_SHOWADSARTICLECOUNT,GetArticlesPerCat($element['catid'])).
					"<br>".($bNew?$strNewPic:"").FormatDate($dtLatestIn)."</td>".
					"</tr>";				
			}
		}
		$CatTable .= "</table>";

	} else {

		//
		// Build complex category overview
		//

		// Beachtet noch nicht Agestricted ***************************
		$oSCM = new SimpleCategoryManager(NULL);
		$CatArray = $oSCM->GetCategoryOverview();

		$TotalArticles = ParseIn(LANG_SHOWADSARTICLECOUNT, GetArticlesInDB());

		if(!is_array($CatArray) || sizeof($CatArray)==0)	{			
			// No category data or connection failed!
			echo LANG_DBEMPTYCATS;
			echo "<p><a href=\"admin.php\">".LANG_LINKTOADMINNOCATS."</a>";
			die();	
		}

		// Division of cats to columns	
		$CatsNo = $oSCM->GetLevel0CategoryCount();

		$PartArray=array();
		for($i=0;$i<GetConfig('OP_COMPLEX_CATS_COLS');$i++)	{
			$PartArray[$i] = ceil($CatsNo / (GetConfig('OP_COMPLEX_CATS_COLS')-$i));
			$CatsNo = $CatsNo - $PartArray[$i];
		}

		// Build display table
		$CatTable = "".

		$CatTable.= "";


		// Build columns
		for($row=0;$row<$PartArray[0];$row++)	{				// Row counter

			$CatTable .= "";
			// Cycle through columns and build main cat tables
			for($col=0;$col<sizeof($PartArray);$col++)		{	// Col counter

				if(GetConfig('OP_COMPLEX_CATS_BUILD_ORDER')=="1")	{
					$ArrayIndex = ($row * sizeof($PartArray))+ $col;
				} else { 
					$ArrayIndex = ($col * $PartArray[0]) + $row; 
				}


				$CatTable .= "";
				if($ArrayIndex > (sizeof($CatArray)-1))	{
					// Create blind table cell
					$CatTable.= "<table width=\"100%\"></table></td>";

				} else {


					// Get category object
					$oCategory = $CatArray[$ArrayIndex]['ELEMENT'];
					$arrSubs = $CatArray[$ArrayIndex]['SUBCATS'];
					$iCatId = $oCategory->iId;

					// Mark categories as age restricted
					if(GetConfig('SEC_FORCE_AGE_REST') && GetConfig('SEC_HIDE_AGEREST_CATS') && 
						$oCategory->bAgeRestricted)	{
						$AgeRestIcon = "&nbsp;<img src= \"".GetConfig('PD_SCRIPTGRAPHICS').
							"alert.gif\" alt=\"".LANG_INDEXNEWARTICONAGE."\">";
					} else { 
						$AgeRestIcon=""; 
					}


					// Logoworkx
					$PicLink = "";


					if(empty($oCategory->strIcon))	
					{ 
						$PicLink = "<td rowspan=\"2\" valign=\"middle\" align=\"left\">".
							"&nbsp;</td>";
					} else {
						$PicLink = "<td rowspan=\"2\" valign=\"middle\" align=\"left\">".
							"<img src=\"".GetConfig('PD_DIRCATLOGOS').$oCategory->strIcon."\" alt=\"".$oCategory->strName."\">";	
						$CatTable .= $PicLink."</td>";
					}


					
					// Mark new categories as NEW!
					$LatestIn = $oCategory->dtLastInCum;

					$NewPic = "";	
					if(isset($_SESSION['s_UserInfo']) && is_array($_SESSION['s_UserInfo']))	{
						// Known user / logged in			
						if($LatestIn >= $_SESSION['s_UserInfo']['userlastlogin']) {
							$NewPic = "<img src= \"".GetConfig('PD_SCRIPTGRAPHICS')."new.gif\" alt=\"".
								LANG_INDEXNEWARTICONNEW."\">";	
						} 
					} 

					$CatTable .= " <li><a href=\"showads.php?catid=".$oCategory->iId."\">".
						$oCategory->strName." ".
						"(".($oCategory->iAdCountCum + $oCategory->iAdCount).")".
						"".$NewPic."</a></li>".
						"".
						"";
				}
			}
			$CatTable .= "\r\n";
		}
		$CatTable .= "";
	}

	// Process featured article function
	if(GetConfig('OP_BUILD_FEATURED_ADS'))	{


		$FeaturedTable = "<div class=\"headline\">".
			LANG_HEADLINETTLFEATURED.
			"</div>"."<br>";


		$FeaturedTable.= "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\" class=\"classad\">".
			"<tr>".
			"<th width=\"7%\">".LANG_HEADLINEPICROW."</th>".
			"<th width=\"48%\">".LANG_HEADLINETITLEROW."</th>".
			"<th width=\"30%\">".LANG_HEADLINEWRITERROW."</th>".
			"<th width=\"10%\">".LANG_HEADLINEDATEROW."</th>".
			"<th width=\"5%\" align=\"right\">".LANG_HEADLINEADVIEWS."</th>".
			"</tr>";

		// Get featured ads from database
		$data = GetFeaturedArticles(GetConfig('OP_BUILD_FEATURED_NO_ADS'), TRUE, $SecurityCheck);


		if($data)	{

			$PrintLine=0;
			foreach($data as $element)		{

				$PrintLine++;
				$HighlightTag = ($PrintLine%2==0?"highlighted":"nonhighlighted");	

				// add thumbnails
				$ThumbPic="";
				if(!empty($element['adpiclink']))	{
					$ThumbPic = "<a href=\"showad.php?adid=".$element['adid']."\">".
						"<img src=\"".GetConfig('PD_USERGRAPHICS')."tn_".$element['adpiclink']."\" alt=\"".$element['adtitle']."\"></a>";
				} else {
					$ThumbPic = "<img src=\"".GetConfig('PD_SCRIPTGRAPHICS')."no_image.jpg\" ".
						"alt=\"".LANG_NOPICAVAILABLE."\">";	
				}
				if($element['adagerestricted']==true && GetConfig('SEC_FORCE_AGE_REST'))	{
					$AgeRestIcon = "<img src= \"".GetConfig('PD_SCRIPTGRAPHICS')."alert.gif\" ".
						"alt=\"".LANG_INDEXNEWARTICONADAGE."\"> ";
				} else { 
					$AgeRestIcon = ""; 
				}

				// add tabledata
				$FeaturedTable .= "<tr class=\"".$HighlightTag."\">".
					"<td width=\"7%\" class=\"previewimage\">".$ThumbPic."</td>".
					"<td width=\"48%\">".$AgeRestIcon." <a href=\"showad.php?adid=".$element['adid']."\">".$element['adtitle']."</a>".
						"<br><span class=\"smallsubtitle\">".DecodeAdType($element['adtype'])."</span></td>".
					"<td width=\"30%\">".$element['adname']."<br>(".(!empty($element['adzip'])? $element['adzip']." " : "").$element['adcity'].")".
					"</td>";

				// add a picture, if this ad was entered after users last visit
				$NewPic = "";

				if(isset($_SESSION['s_UserInfo']) && is_array($_SESSION['s_UserInfo']))	{

					// Known / logged in user
					if($element['adindate'] >= $_SESSION['s_UserInfo']['userlastlogin']) {
						$NewPic = "<img src= \"".GetConfig('PD_SCRIPTGRAPHICS')."new.gif\">";	
					} 
				} 

				$FeaturedTable .= "<td width=\"10%\">".FormatDate($element['adindate']).$NewPic."</td>".
					"<td width=\"5%\" align=\"right\">".$element['adviewed'].
					"</td></tr>";
			}

		} else {
				// No data or connection problems 
			$FeaturedTable .="<tr><td colspan=\"5\"><div align=\"center\">".LANG_NODATAENTRY."</div></td></tr>"; 
		}

		$FeaturedTable.= "</table>";

	} else {
		$FeaturedTable = "&nbsp;";
	}


	//
	// Latest in
	//	
	if(GetConfig('OP_BUILD_LATEST_ADS'))		{

		$data = GetLatestArticles(GetConfig('OP_BUILD_LATEST_NO_ADS'), $SecurityCheck);



		// Get featured ads from database
		if($data)	{

			$PrintLine=0;
			foreach($data as $element)		{

				$PrintLine++;
				$HighlightTag = ($PrintLine%2==0?"highlighted":"nonhighlighted");	

				// add thumbnails
				$ThumbPic="";
				if(!empty($element['adpiclink']))	{
					$ThumbPic = "<a href=\"showad.php?adid=".$element['adid']."\">".
						"<img src= \"".GetConfig('PD_USERGRAPHICS')."tn_".$element['adpiclink']."\" alt=\"".$element['adtitle']."\"></a>";
				} else {
					$ThumbPic = "<img src=\"".GetConfig('PD_SCRIPTGRAPHICS')."no_image.jpg\" alt=\"".LANG_NOPICAVAILABLE."\">";	
				}
				if($element['adagerestricted']==true && GetConfig('SEC_FORCE_AGE_REST'))	{
					$AgeRestIcon = "<img src= \"".GetConfig('PD_SCRIPTGRAPHICS')."alert.gif\" alt=\"".LANG_INDEXNEWARTICONADAGE."\"> ";
				} else { 
					$AgeRestIcon = ""; 
				}

				// add tabledata
				$LastInTable.= "<tr class=\"".$HighlightTag."\">".DecodeAdType($element['adtype'])." vom ".
				    "<td width=\"10%\">".FormatDate($element['adindate'])."</td>"."<br><br>".
					"<td width=\"48%\">".$AgeRestIcon." <a href=\"showad.php?adid=".$element['adid']."\">".$element['adtitle']."</a>"."<br><br>".
					"<td width=\"7%\" class=\"previewimage\">".$ThumbPic."</td>".
					"<td width=\"30%\">"."<br>in ".(!empty($element['adzip'])? $element['adzip']." " : "").$element['adcity']."".
					"</td>"."<br><br><img src= \"http://www.garnelen-hl.de/zuverschenken/css/images/neueste_foot.jpg\"><br><br>";

			}

		} else {
				// No data or connection problems 
			$LastInTable.="<tr><td colspan=\"5\"><div align=\"center\">".LANG_NODATAENTRY."</div></td></tr>"; 
		}

		// Close surrounding table
		$LastInTable.= "</table>";

	} else {
		$LastInTable = "&nbsp;";
	}

	// Categorytemplate
	include "templates/".$GLOBALS['ACTIVELANGUAGE']."/index.tpl.php";
	include "inc/footer.inc.php";

?>