| 1 |
lars |
1 |
<?
|
|
|
2 |
require_once "connect2.php";
|
|
|
3 |
session_start();
|
|
|
4 |
// Artikelname holen
|
|
|
5 |
$query = "select kurzbezeichnung from artikel where ID = $_GET[ts_id]";
|
|
|
6 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
|
|
|
7 |
$r = mysql_fetch_array($result);
|
|
|
8 |
$kurzbezeichnung = $r[kurzbezeichnung];
|
|
|
9 |
// trigger_URL finden
|
|
|
10 |
$query = "select trigger_URL, Titel from Preisagentur where ID = $_GET[pa_id]";
|
|
|
11 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
|
|
|
12 |
$r = mysql_fetch_array($result);
|
|
|
13 |
$trigger_url = $r[trigger_URL];
|
|
|
14 |
$pa_titel = $r[Titel];
|
|
|
15 |
// Zeilen aus shop_log holen
|
|
|
16 |
$zeit_filter = "and shop_log.erstellt_am > date_sub(NOW(), INTERVAL $_GET[top_seller_zeitraum] DAY)";
|
|
|
17 |
$query = "select eintrag1 as link, date_format(erstellt_am,\"%d.%m.%Y, %H:%i\") as erstellt_am, eintrag4 from shop_log where shops_ID = $_SESSION[filter_shop] and eintrag2 = '$trigger_url' and eintrag3 = $_GET[ts_id] and erstellt_von = '(Preisagentur)' $zeit_filter and eintrag1 <> ''";
|
|
|
18 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
|
|
|
19 |
?>
|
|
|
20 |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
|
|
|
21 |
<html>
|
|
|
22 |
<head>
|
|
|
23 |
<title>Verweisausgabe für <? echo $kurzbezeichnung; ?>
|
|
|
24 |
</title>
|
|
|
25 |
<meta name="description" content="Redaktionssystem">
|
|
|
26 |
<meta name="author" content="Webagentur Niewerth">
|
|
|
27 |
<meta name="robots" content="noindex">
|
|
|
28 |
<link rel=stylesheet type="text/css" href="../styles/styles.php">
|
|
|
29 |
<style type="text/css">
|
|
|
30 |
<!--
|
|
|
31 |
.lightgray {color: #000000; background-color: #EEEEEE}
|
|
|
32 |
.darkgray {color: #000000; background-color: #CCCCCC}
|
|
|
33 |
.status_off {color: #000000;}
|
|
|
34 |
.status_red {color: #FFFFFF; background-color: #FF0000}
|
|
|
35 |
.status_yellow {color: #000000; background-color: #FFFF00}
|
|
|
36 |
.status_green {color: #000000; background-color: #00FF00}
|
|
|
37 |
-->
|
|
|
38 |
</style>
|
|
|
39 |
</head>
|
|
|
40 |
|
|
|
41 |
<body>
|
|
|
42 |
<?
|
|
|
43 |
// Ausgabe
|
|
|
44 |
// echo $query;
|
|
|
45 |
echo "Preisagentur: <b>$pa_titel</b><br>";
|
|
|
46 |
echo "Artikel: <b>$kurzbezeichnung</b><br>";
|
|
|
47 |
echo "Zeitraum (in Tage): <b>$_GET[top_seller_zeitraum]</b><br>";
|
|
|
48 |
echo "---------------------------------<br>";
|
|
|
49 |
?>
|
|
|
50 |
<table border="1" cellpadding="0" cellspacing="0">
|
|
|
51 |
<tr><td>Aufruflink</td><td>Browsersprache</td><td>Datum - Zeit</td></tr>
|
|
|
52 |
<?
|
|
|
53 |
while($r = mysql_fetch_array($result)){
|
|
|
54 |
echo "<tr><td><a href=\"$r[link]\" target=\"_blank\"><font color=#000000>$r[link]</font></a> </td><td>$r[eintrag4] </td><td>$r[erstellt_am]</td></tr>";
|
|
|
55 |
}
|
|
|
56 |
?>
|
|
|
57 |
</table>
|
|
|
58 |
</body>
|
|
|
59 |
</html>
|