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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
| <?php
/*Do not modify this PHP code when editing the page design.
The following fields are available from the database, and can be accessed as variables using...
<?php echo $row["name"]; ?>
<?php echo $row["flag_filename"]; ?>
<?php echo $row["map_filename"]; ?>
<?php echo $row["picture_1_filename"]; ?>
<?php echo $row["picture_2_filename"]; ?>
<?php echo $row["description"]; ?>
<?php echo $row["other_page_text"]; ?>
<?php echo $row["world_factbook_link"]; ?>
<?php echo $row["newsfeed"]; ?>
<?php echo $row["ad"]; ?>
<?php echo "Updated: ".$row["created_date"]; ?>
<?php echo $youtube_id; ?>
<?php echo $page; ?>
<?php echo $creator; ?>
<?php printCountryList('view') ?>
*/
include("/printCountryList.php");
//Connect to the database
include("/database.php");
$name = $_GET['name'];
$language = $_GET['lang'];
$sql = "SELECT `language`,`name`,`flag_filename`,`map_filename`,`picture_1_filename`,`picture_2_filename`,`description`,`other_page_text`,`world_factbook_link`,`newsfeed`,`ad`,`created_by`,`created_date` FROM `countries` WHERE `removed`='0' AND `language`='$language' AND `name`='$name'";
$result = $conn->query($sql);
if (mysqli_num_rows($result) == 0) {
//echo 'Unknown Country or Language trying for that country in English';
$sql = "SELECT `language`,`name`,`flag_filename`,`map_filename`,`picture_1_filename`,`picture_2_filename`,`description`,`other_page_text`,`world_factbook_link`,`newsfeed`,`ad`,`created_by`,`created_date` FROM `countries` WHERE `removed`='0' AND `language`='en' AND `name`='$name'";
$result = $conn->query($sql);
if (mysqli_num_rows($result) == 0) {
?>
<html>
<head>
<title>Unknown Country Page</title>
<META http-equiv="refresh" content="5;URL=http://www.saveaslave.com">
</head>
<body bgcolor="#ffffff">
<center>The country page you are looking for does not exist. You will be redirected to the main page in 5 seconds.
</center>
</body>
</html>
<?php
break;
}
}
$row = $result->fetch_assoc();
// Get the latest video
$page = strtolower($name).".html";
$sql = "SELECT `url` FROM `links` WHERE `url` LIKE '%youtu%' AND `page` LIKE '%$page%' AND `video` = '1' AND `visible` = '1' AND `removed` = '0' ORDER BY date_added DESC LIMIT 1";
$result_youtube = $conn->query($sql);
if (mysqli_num_rows($result_youtube) == 0) {
//echo 'No video for that country';
$sql = "SELECT `url` FROM `links` WHERE `url` LIKE '%youtu%' AND `page` = 'index.html' AND `video` = '1' AND `visible` = '1' AND `removed` = '0' ORDER BY date_added DESC LIMIT 1";
$result_youtube = $conn->query($sql);
}
$row_youtube = $result_youtube->fetch_assoc();
// strip the url to get the YouTube video ID
if ($location = strpos($row_youtube["url"],"v=")) {
$youtube_id = substr($row_youtube["url"], $location+2);
} else {
$location = strpos($row_youtube["url"],"youtu.be/");
$youtube_id = substr($row_youtube["url"], $location+9);
}
// Get the name of the person who last edited the page
$created_by_id = $row["created_by"];
$sql = "SELECT `name` FROM `volunteers` WHERE `give_credit` = '1' AND `id` = '$created_by_id'";
$result_credit = $conn->query($sql);
if (mysqli_num_rows($result_credit) == 0) {
$creator = "Hidden";
} else {
$row_credit = $result_credit->fetch_assoc();
$creator = $row_credit["name"];
}
$conn->close();
?>
<!-- -----------It is safe to change the code below this line.-------------- -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>--------------------- <?php echo $row["name"]; ?></title>
<link href="css/style.css" media="screen" rel="stylesheet" type="text/css" />
<meta name="description" content="The goal of Save A Slave is to inform and educate the world about modern day slavery and to encourage former slaves." />
<meta name="keywords" content="---------------, <?php echo $row["name"]; ?>, ---------------r" />
</head>
<body>
<div align="center">
<div id="content">
<img src="https://www.cyberforum.ru/images/header.png" /><br />
<div id="arttext">
<hr />
<table width="100%" cellpadding="5px"><tr><td width="40%" align="left" valign="top">
<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_top">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="HD9MBDFHBLNFA">
<input type="image" src="https://www.cyberforum.ru/images/sas_button.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form><br />
Select another country to view: <?php printCountryList('view') ?>
<br /><br />
<br />
<?php echo $row["newsfeed"]; ?><br />
<br />
<br />
<iframe width="600" height="338" src="https://www.youtube.com/embed/<?php echo $youtube_id; ?>" frameborder="0" allowfullscreen></iframe>
<p> </p></td>
<td width="60%" align="left" valign="top">
<h1><?php echo $row["name"]; ?><img src="https://www.cyberforum.ru/images/countrymap/<?php echo $row["flag_filename"]; ?>" align="right" height="72" width="100" /></h1>
<?php echo $row["description"]; ?>
<p>See more info for this country at "<a href="<?php echo $row["world_factbook_link"]; ?>" target="_blank">World Factbook</a>".</p>
<p><img src="https://www.cyberforum.ru/images/countrymap/<?php echo $row["map_filename"]; ?>" align="right"/></p></td>
</tr>
<tr>
<td colspan="2"><table style="width:100%">
<tr>
<td valign="top">
<iframe src="http://www.---------.com/listlink.php?page=<?php echo $page; ?>" width="600" height="480">
<p>Your browser does not support iframes.</p>
</iframe>
</td>
<td width="300" valign="top">
<iframe src="http://www.------------.com/addlink.php?page=<?php echo $page; ?>" width="300" height="480">
<p>Your browser does not support iframes.</p>
</iframe>
</td>
</tr>
</table>
</br>
<?php echo $row["other_page_text"]; ?></td></tr>
</table>
</div>
<div id="footer"><hr /><?php echo "Last Updated: ".$row["created_date"]; ?> by <?php echo $creator; ?>
© 2015 -------- | <a href="mailto:---------------?Subject=Contact%20from%20------------">Contact</a> | <a href="index.html">Home</a>| <a href="disclaimer.html">Disclaimer</a> </div>
</div>
</body>
</body>
</html>
<!-- text below generated by server. PLEASE REMOVE --><!-- Counter/Statistics data collection code --><script language="JavaScript" src="http://l.yimg.com/d/lib/smb/js/hosting/cp/js_source/whv2_001.js"></script><script language="javascript">geovisit();</script><noscript><img src="http://visit.webhosting.yahoo.com/visit.gif?us1438692253" alt="setstats" border="0" width="1" height="1"></noscript><script type="text/javascript" src="https://s.yimg.com/mi/vs4/ywa.js"></script><script type="text/javascript">try {var YWAGTracker = YWA.getTracker("10001849413879", "VSCALE4");YWAGTracker.setDocumentName("WPAGE");YWAGTracker.setDocumentGroup("YSBW");YWAGTracker.setCF(7, "saveaslave.com");YWAGTracker.setCF(8, "w48");YWAGTracker.submit();} catch (eYWATCUnavailable) {}</script><script type="text/javascript">(function (d, w) {var x = d.getElementsByTagName('SCRIPT')[0];var f = function () {var s = d.createElement('SCRIPT');s.type = 'text/javascript';s.async = true;s.src = "//np.lexity.com/embed/YW/6802b2324951b9a4d1cfdfbe6d18e508?id=b2393dd6f942";x.parentNode.insertBefore(s, x);};w.attachEvent ? w.attachEvent('onload',f) :w.addEventListener('load',f,false);}(document, window));</script> |
(
