readpoppel/index.php at main · jannebeta/readpoppel · 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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
<?php
require_once("configuration.php");

if (!isset($_SESSION["LOGIN_USER"]))
{
	header('Location: http://' . $_SERVER['SERVER_NAME'] . '/subscription_block');
	exit;
}

include("includes/header.php");

?>
<script>
loadRandomPapers();
</script>
			<div class="jumbotron" style="background-image: url(/assets/images/illustrations/syksy002.jpg); background-size: 100%;">
			<a href="#" onclick="loadRandomPapers(); return false;">PÄIVITÄ</a>
				<h2 style="color: white;">
					Satunnaisia lehtiä
				</h2>
				<h4 style="color: white;">
			     satunnaisesti valikoituja lehtiä menneiltä vuosilta
				</h4>
				<p id="randomPapersContainer">
					<?php
/*
$dataquery = "SELECT DISTINCT paperBrand, paperID, paperTitle FROM papers ORDER BY rand() LIMIT 8";

$dataresult = $dataconnection->query($dataquery);

if ($dataresult->num_rows > 0)
{
	while($randomPapers = $dataresult->fetch_assoc())
	{
		echo '<a href="/paper/' . $randomPapers["paperBrand"] . '/read/' . $randomPapers["paperID"] . '"><img src="http://www.e-pages.dk/' . $randomPapers["paperBrand"] . '/' . $randomPapers["paperID"] . '/pic/tm1.jpg" style="height: 130px; margin-right: 20px;" onError="imageError(this);" id="randomPaper" data-toggle="tooltip" title="' . $randomPapers["paperTitle"] . '"></a>';
	}
}
*/
?>
				</p>
				<p>

				</p>
			</div>
		</div>
	</div>
	<h2>
					Lehdet
				</h2>
	<div class="row">
	<?php

$dataquery = "SELECT brandCode, brandName, logoIMG, platform, archived FROM paper_brands WHERE archived = '0' ORDER BY brandName ASC";

$dataresult = $dataconnection->query($dataquery);

if ($dataresult->num_rows > 0)
{
	while($papbrand = $dataresult->fetch_assoc())
	{
		switch ($papbrand["platform"])
		{
			case "visiolink_epages":
			{
				$paperResult = $dataconnection->query("SELECT * FROM papers WHERE paperBrand = '" . $papbrand["brandCode"] . "' ORDER BY paperPublished DESC LIMIT 1");
			$paperData = $paperResult->fetch_assoc();
	echo '<div class="col-lg-2 col-md-4 col-xs-6 thumb">
                <a class="thumbnail" href="/paper/' . $papbrand["brandCode"] . '">
				' . ($papbrand["archived"] == 1 ? '<div class="attention"><div class="rotation"><center>vain</center> arkisto</div></div>' : '') . '
                    <img class="img-responsive" style="height: 180px;" src="http://www.e-pages.dk/' . $paperData["paperBrand"] . '/' . $paperData["paperID"] . '/pic/tm1.jpg" onerror="imageError(this);" alt="">
			   </a>
            </div>';
			break;
			}
			case "readpoppel_envsafe":
			{
					$paperResult = $dataconnection->query("SELECT * FROM papers WHERE paperBrand = '" . $papbrand["brandCode"] . "' ORDER BY paperPublished DESC LIMIT 1");
			$paperData = $paperResult->fetch_assoc();

				echo '<div class="col-lg-2 col-md-4 col-xs-6 thumb">
                <a class="thumbnail" href="/paper/' . $papbrand["brandCode"] . '">
                    <img class="img-responsive" style="height: 180px;" src="" onerror="imageError(this);" alt="">
                </a>
            </div>';
				break;
			}

	}


	}
}
	?>
</div>

<?php
include("includes/footer.php");
?>