PrivateTracker_Torrent_WebsiteScript/cover_view.php at main · ProGoogleNederland/PrivateTracker_Torrent_WebsiteScript · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<?php
require_once("include/bittorrent.php");
require_once("include/secrets.php");
global $mysql_host, $mysql_user, $mysql_pass, $mysql_db;
$con_link = mysqli_connect($mysql_host, $mysql_user, $mysql_pass, $mysql_db);
dbconn();
loggedinorreturn();


if (get_user_class() < UC_ADMINISTRATOR)
	site_error_message("Foutmelding", "Deze pagina is alleen voor de beheerder en hoger.");

site_header("Cover overzicht");

$cover_url = $BASEURL."/cover";

$start = 0 + @$_GET['start'];

$totaal = get_row_count("torrents","WHERE cover LIKE '" . $cover_url . "%'");
$per_pagina = 40;
$paginas = floor($totaal / $per_pagina);
if ($paginas * $per_pagina < $totaal)
  ++$paginas;

	$site_pager = "<font color=blue size=3>";
	for ($i = 0; $i < $paginas; ++$i)
		{
		$begin = $i*$per_pagina;
		if ($i > 0) $site_pager .= "&nbsp;-&nbsp;";
		$pagina = $i + 1;
		if ($start/$per_pagina == $i)
			$site_pager .= "" . $pagina . "";
		else
			$site_pager .= "<a href=cover_view.php?start=" . $begin . "><font color=blue size=3><b>" . $pagina . "</b></font></a>";
		}
		$site_pager .= "</font>";
tabel_start();
print $site_pager;

$fff = substr($cover_url,0,20);

$userid = $CURUSER['id'];
$res = mysqli_query($con_link, "SELECT name, cover, id FROM torrents WHERE cover LIKE '" . $cover_url . "%' LIMIT $start,$per_pagina") or sqlerr(__FILE__, __LINE__);

print("<table width=80% class=bottom border=0 cellspacing=0 cellpadding=0><tr><td class=embedded><center>");
print("<br>");
tabel_top("Overzicht gebruikte covers die geplaatst zijn op server");
print("<table background=pics/system/tabel_achtergrond.gif width=100% border=0 cellspacing=0 cellpadding=0>");
print("<tr>");
print("<td class=embedded><div align=center><br>");
print("<table class=outer border=1 cellspacing=0 cellpadding=5>");
print("<tr><td class=colheadsite>");
print("Gebruiker");
print("</td><td class=colheadsite>");
print("Covers");
print("</td>");
print("</tr>");

$color = "#CCCCCC";

while ($row = mysqli_fetch_assoc($res)) {

//if (substr($row['cover'],0,32) == $cover_url)
//	{
	print("<tr><td bgcolor=white>");
	print($row['name']);
	print("</td><td bgcolor=white>");
	print("<img height=250 src=" . $row['cover'] . ">");
	print("</td>");
	print("</tr>");
//	}
}
print("</td></tr></table>");

print("<br></td></tr></table>");
print("</td></table><br>");

print $site_pager;
print "<br><br>";
tabel_einde();
site_footer();

?>