File: /var/www/web37/htdocs/websuche/adm/mod1/searchback.php
<?PHP
include "./inc/pfade.php";
include "./inc/funktionen.php";
db();
$meldung="";
$hinweis="";
// ----------- Navigation -------------------------
if(isset($_GET['tffz'])) { $tffz = $_GET['tffz']; }
if($tffz=="") { $tffz= 0; } $tffzx= $tffz*$t_pr;
$limit = $tffzx.",".$t_pr;
$loeschname = "";
if(isset($_GET['codex']) && $_GET['codex']== 22)
{
$id= $_GET['id'];
$loeschen_sql= mysql_query("SELECT name
FROM ".$dbtable02."
WHERE siteid='".NoI("$id")."' ");
$ROW=mysql_fetch_row($loeschen_sql);
$loeschname= $ROW[0];
if ($loeschname != "")
{
mysql_query("DELETE
FROM ".$dbtable02."
WHERE siteid='".NoI("$id")."' ");
$meldung = '<table cellpadding="5" cellspacing="0" WIDTH=760 class="fehlermelden">
<tr>
<TD WIDTH=700 valign="top" class="einsa">Der Eintrag "<b>'.$loeschname.'</b>" wurde aus der Datenbank gelöscht!
</td>
</tr>
</table><br>';
}
else
{
$meldung = '<table cellpadding="5" cellspacing="0" WIDTH=760 class="fehlermelden">
<tr>
<TD WIDTH=700 valign="top" class="einsa">Der Eintrag wurde nicht gefunden!
</td>
</tr>
</table><br>';
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<link rel="stylesheet" type="text/css" href="./inc/admin.css">
<TITLE>Administration</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0033CC" VLINK="#990099" ALINK="#FF0000" TOPMARGIN=0 LEFTMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<CENTER><br>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=981 class="menu_links">
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=60 COLSPAN=2 ALIGN=CENTER VALIGN=MIDDLE WIDTH=983><IMG HEIGHT=60 WIDTH=983 SRC="./gfx/logo.jpg" BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD ROWSPAN=2 WIDTH=200>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=200>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=8 HEIGHT=15><IMG SRC="./gfx/cpl.gif" WIDTH=8 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD></TD>
<TD WIDTH=9><IMG SRC="./gfx/cpl.gif" WIDTH=9 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=534></TD>
<TD WIDTH=183>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=183 HEIGHT=534 bgcolor="#F4FAFF" class="menu_links">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=183>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=28 COLSPAN=3 WIDTH=183>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=183 HEIGHT=28 bgcolor="#DEE3E7">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=183>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=183 HEIGHT=5><IMG SRC="./gfx/cpl.gif" WIDTH=183 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=183 class="einsb">
<P ALIGN=CENTER>
Menü Webkatalog
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=5 HEIGHT=8><IMG SRC="./gfx/cpl.gif" WIDTH=5 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD></TD>
<TD WIDTH=6><IMG SRC="./gfx/cpl.gif" WIDTH=6 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=498></TD>
<TD WIDTH=172>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=172 HEIGHT=498>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=172 NOF="LayoutBereich11">
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=172>
<P>
<?PHP include "./inc/menu.php";
?>
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=27 COLSPAN=3 WIDTH=200>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=200 HEIGHT=27>
<TR ALIGN=LEFT VALIGN=TOP>
<TD> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD HEIGHT=10></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=566 WIDTH=781>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=781>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=7 HEIGHT=19><IMG SRC="./gfx/cpl.gif" WIDTH=7 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD></TD>
<TD WIDTH=8><IMG SRC="./gfx/cpl.gif" WIDTH=8 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=520></TD>
<TD WIDTH=766>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766 HEIGHT=520>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=766 class="einsb">
<P><b>Eintrüge mit Backlink...</b><br>
<hr size="1" color="#aeaeae" width="99%"><form name="FormName" method="post" action="search.php">
<table cellpadding="0" width="100%">
<tr><td width="10%"></td>
<td width="23%" class="einsb">
<div align="center" class="einsb">
Suchen in den Einträgen:</div>
</td>
<td width="17%">
<div align="center">
<b><select name="nuco" size="1">
<option value="1" >Eintragsnummer</option>
<option value="2">in der Url</option>
<option value="3">im Titel</option>
<option value="4">im Text</option>
<option value="5" selected>ID suchen</option>
</select></b></div>
</td>
<td width="50%">
<div align="left">
<input type="text" name="suchwort" size="20" maxlength="20"> <input type="submit" class="submit" value="Suchen.."></div>
</td>
</tr>
</table>
</form><hr size="1" color="#aeaeae" width="99%">
<?PHP echo $meldung ?>
</P>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=484 WIDTH=766>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766 HEIGHT=484>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=766 class="einsa">
<P>
<table cellpadding="0" width="99%">
<tr>
<td width="50%">
<div align="center">
<?PHP
$coderr=0;
$suchwort = $_REQUEST['suchwort'];
$suchwortx = replaceu($suchwort);
$nuco= $_REQUEST['nuco'];
switch ($nuco)
{
case 1:
$query2=" WHERE nummer='".NoI("$suchwortx")."' ";
break;
case 2:
$query2=" WHERE url LIKE '%".NoI("$suchwortx")."%' ";
break;
case 3:
$query2=" WHERE name LIKE '%".NoI("$suchwortx")."%' ";
break;
case 4:
$query2=" WHERE beschreibung LIKE '%".NoI("$suchwortx")."%' ";
break;
case 5:
$query2=" WHERE siteid = '".NoI("$suchwortx")."' ";
break;
}
// Einträge zählen --------------------------------------
$eintragzahl_sql= mysql_query("SELECT COUNT(*) as 'anzahl'
FROM ".$dbtable02."
".$query2."
AND code= '1'
AND backlink ='ja' ");
$tr = mysql_result($eintragzahl_sql,0,'anzahl');
$blf= "searchback.php?suchwort=".$suchwort
."&nuco=".$nuco;
$navi= page($blf);
if ($tr == 0)
{
echo '<span class="einsa">Es wurde <b>kein Eintrag</b> gefunden der zu Ihrer Suchanfrage passt!</span>';
}
if ($tr == 1)
{
echo '<span class="einsa">Es wurde <b>1 Eintrag</b> gefunden der zu Ihrer Suchanfrage passt!</span>';
}
if ($tr >= 2)
{
echo '<span class="einsa">Es wurden <b>'.$tr.' Einträge</b> gefunden die zu Ihrer Suchanfrage passen!</span>';
}
echo "<br><br>".$navi;
?></div>
</td>
</tr>
</table>
<br>
<br>
<table cellpadding="0" width="99%" class="menu_links">
<tr>
<td width="60%" class="einsa">
<div align="left">
<b> Image Eintrag-Name und Beschreibung </b>(gekürzt)</div>
</td>
<td width="25%" class="einsb">
<div align="right">
<b>Bearbeiten </b></div>
</td>
<td width="15%" class="einsb">
<div align="right">
<b>Löschen </b></div>
</td>
</tr>
</table><br><br>
<?PHP
$eintrag_daten_sql= mysql_query("SELECT *
FROM ".$dbtable02."
".$query2."
AND code='1'
AND backlink ='ja'
ORDER BY siteid DESC LIMIT 8 ");
while($ROW=mysql_fetch_assoc($eintrag_daten_sql))
{
$nummer= $ROW['siteid'];
$name= $ROW['name'];
$image= $ROW['adminb'];
$backlink= $ROW['backlink'];
$commerz= $ROW['commerz'];
$linkx = $ROW['url'];
$besch = $ROW['beschreibung'];
$adme = $ROW['absender'];
$admpre ="";
if($adme == "adm")
{
$admpre = '<img src="./gfx/starpre.gif" border="0" width="13" height="13" alt="Admineintrag" title="Admineintrag">';
}
$besch = strip_tags($besch);
if (strlen($besch)> 150)
{
$besch= substr($besch,0,150);
$besch= $besch."...";
}
$anmeldung= 1;
$url = '<A HREF ="'.$linkx.'" target="_blank" class="content"><img src="./gfx/a_arr1.gif" border="0" target="content"> URL </a> /';
if ($backlink == "nein")
{
$backlink = 'Backlink: <span class= "alert">Nein</span>';
}
elseif ($backlink == "ja")
{
$backlink = 'Backlink: <span class="alert2">JA</span>';
}
if ($commerz == "ja")
{
$commerz = 'Premium: <span class= "alert2">JA</span>';
}
if ($commerz == "nein")
{
$commerz = 'Premium: <span class= "alert">NEIN</span>';
}
if (trim($image) =="" || trim($image) =="http://")
{
$image= "./gfx/nopic.gif";
}
else
{
$bsize = @getimagesize($image);
if($bsize[0] == 0)
{
$image="./gfx/picfehler.gif";
}
}
echo '<table cellpadding="3" width="99%" bgcolor="#FFFFFF" class="nopraemium">
<tr>
<td width="13%">
<div align="left"><img src="'.$image.'" border="0" width="80" align="left"></div>
</td>
<td width="57%">
<div align="left" class="einsa"><b>'.$name.'</b><br>'.$besch.'<br><br><iframe src="linkcheck.php?home_url='.$linkx.'" name="Fenster" frameBorder=0 noResize scrolling=no width="300" height="18" marginheight="0" marginwidth="0" align="left"></iframe></div>
</td>
<td width="15%">
<div align="right">
<img src="./gfx/a_arr1.gif" border="0"> <a href="look2.php?nummer='.$nummer.'" class="content">bearbeiten</a></div>
</td>
<td width="15%">
<div align="right">
<img src="./gfx/a_arr1.gif" border="0"> <a href="searchback.php?codex=22&suchwort='.$suchwort.'&nuco='.$nuco.'&id='.$nummer.'&tffz='.$tffz.'"><b>löschen</b></a> </div>
</td>
</tr>
<tr>
<td colspan=4><hr size="1" color="#aeaeae" width="95%">
</td>
</tr>
<tr>
<td colspan=4 class="einsa"> '.$admpre.' <b>ID: '.$nummer.'</b> / '.$url.' '.$commerz.' / '.$backlink.'
</td>
</tr>
</table><br>';
}
db_();
?><br>
<br><?PHP echo $hinweis ?>
<br>
<center><?PHP echo $navi ?></center>
<br>
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=27 COLSPAN=3 WIDTH=781>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=781 HEIGHT=27>
<TR ALIGN=LEFT VALIGN=TOP>
<TD> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<?PHP
include "./inc/footer.php";
?>
</TABLE>
</CENTER>
</BODY>
</HTML>