channels_list.php
<?php
include_once(“connection.php”);
$db = new dbObj();
$connString = $db->getConnstring();
$channels = array(
array(),
array(),
array(),
array(),
array()
);
$canale = “SELECT * FROM
ttp_tspORDER BY id ASC LIMIT 0, 100”;$result = mysqli_query($connString, $canale)or die(mysqli_error());
if (mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
$channels[0] = $row[‘canale’];
}
}
$canale = “SELECT * FROM
ttp_tspORDER BY id ASC LIMIT 100, 100”;$result = mysqli_query($connString, $canale)or die(mysqli_error());
if (mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
$channels[1] = $row[‘canale’];
}
}
$canale = “SELECT * FROM
ttp_tspORDER BY id ASC LIMIT 200, 100”;$result = mysqli_query($connString, $canale)or die(mysqli_error());
if (mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
$channels[2] = $row[‘canale’];
}
}
$canale = “SELECT * FROM
ttp_tspORDER BY id ASC LIMIT 300, 100”;$result = mysqli_query($connString, $canale)or die(mysqli_error());
if (mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
$channels[3] = $row[‘canale’];
}
}
$canale = “SELECT * FROM
ttp_tspORDER BY id ASC LIMIT 400, 100”;$result = mysqli_query($connString, $canale)or die(mysqli_error());
if (mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
$channels[4] = $row[‘canale’];
}
}
?>
connection.php
<?php
Class dbObj{
/ Database connection start /
var $servername = “localhost”;
var $username = “username”;
var $password = “password”;
var $dbname = “dbname”;
var $conn;
function getConnstring() {
$con = mysqli_connect($this->servername, $this->username, $this->password, $this->dbname) or die("Connection failed: " . mysqli_connect_error());
/ check connection /
if (mysqli_connect_errno()) {
printf(“Connection failed: %s\n”, mysqli_connect_error());
exit();
} else {
$this->conn = $con;
}
return $this->conn;
}
}
?>
index.php
<?php ini_set(‘display_errors’, ‘On’);
error_reporting(E_ALL); ?>
<html>
<head>
<script type=“text/javascript” src=“./js/jquery-1.10.1.min.js”></script>
<script type=“text/javascript” src=“./js/function.js”></script>
<script type=“text/javascript” src=“https://code.jquery.com/jquery-1.12.4.min.js”></script>
<script data-ad-client=“ca-pub-1504328409663488” async src=“https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js”></script>
<link rel=“stylesheet” href=“./css/font-awesome/css/font-awesome.min.css”>
<link rel=“stylesheet” href=“./css/style.css”>
</head>
<body>
<?php
include(“lista_canali_prova.php”);
// inizio a chiamare le API
foreach($channels as $chans){
$callAPI = implode(‘&user_login=’, $chans);
$url=“https://api.twitch.tv/helix/streams?user_login=” . $callAPI;
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
‘Client-ID: c533u8ntdp29h42xxzwfe0pf5v66dm’
));
$result = curl_exec($ch);
$i = curl_getinfo($ch);
curl_close($ch);
// preparo le stamp per le API
$str = json_decode($result, true);
if ($i[‘http_code’] == 200) {
// play print API
// do stuff with $str has chnanels
} else {
// non 200 do somethign with the error
// do stuff with $str has error message
}
// fine chiamata API
// Print test, lo uso solo per testare degli script
print_r($url);
echo $str[‘data’];
}
?>
<div class=“center”>
<div><center><img src=“./img/TPS-logo.webp” alt=“Logo TSP” height=“150” width=“150” style=“padding: 13px;”></center></div>
<?php if(is_array($str[‘data’])){ ?>
<div class=“twitch-online” align=“center”>
</div>
<?php
$TopRaid = “SELECT canale FROM ttp_tsp WHERE raid=‘Si’”;
$risraid = mysqli_query($connString, $TopRaid)or die(mysqli_error());
while($row = mysqli_fetch_array($risraid)){
$canaleraid = $row[‘canale’];
}
?>
<div class=“divTable”>
<div class=“divTableBody”>
<div class=“divTableRow”>
<div class=“divTableCell cella1” style=“background-color:red;”><h2><b>RAID IN EVIDENZA  </b> <p hidden id=“TopHOST”>/host <?php echo $canaleraid; ?></p><button onclick=“copyToClipboard(‘TopHOST’)” class=“button button_primary”>Fai da HOST</button> <p hidden id=“TopRAID”>/raid <?php echo $canaleraid; ?></p><button onclick=“copyToClipboard(‘TopRAID’)” class=“button button_primary”>Fai il RAID</button></h2></div>
</div>
<div class=“divTableRow”>
<div class=“divTableCell” style=“width:100%;”>
<div id=“twitch-embed”></div>
<script src=“https://embed.twitch.tv/embed/v1.js”></script>
<script type=“text/javascript”>
var embed = new Twitch.Embed(“twitch-embed”, {
width: 500,
height: 400,
channel: “<?php echo $canaleraid; ?>”,
layout: “video”,
autoplay: false
});
embed.addEventListener(Twitch.Embed.VIDEO_READY, () => {
var player = embed.getPlayer();
player.play();
});
</script>
</div>
</div>
</div>
</div>
<br><br>
<div id=“update”>
<div class=“twitch-online” align=“center”>
<h2>CHANNELS LIVE NOW: <?php $online = count($str[‘data’]); echo $online; ?><br><br></h2>
</div>
<div class=“divTable”>
<div class=“divTableBody”>
<div class=“divTableRow”>
<div class=“divTableCell cella1”><h2><b>CHANNEL NAME</b><h2></div>
<div class=“divTableCell cella2”><h2><b><i class=“fa fa-users” aria-hidden=“true”></i></b><h2></div>
<div class=“divTableCell cella3”><h2><b>ACTIONS</b><h2></div>
</div>
<?php
foreach($str[‘data’] as $mydata){
if($mydata != null) {
$name = $mydata[‘user_name’];
$views = $mydata[‘viewer_count’];
?>
<div class=“divTableRow table-row”>
<div class=“divTableCell”><?php echo “<h3>” . $name .“</h3>”; ?></div>
<div class=“divTableCell”><?php echo “” . $views .“”; ?></div>
<div class=“divTableCell”><?php echo “<a href=‘https://twitch.tv/“  . $name . ”‘ target=’_blank’ ><button class=‘button button_primary’>WATCH</button></a>“; ?>&nbsp;&nbsp;<p hidden id=”<?php echo $name; ?>">/raid <?php echo $name; ?></p><button onclick="copyToClipboard('<?php echo $name; ?>’)” class=“button button_primary”>RAID</button></div>
</div>
<?php
}else{
echo “<p>test</p>”;
} } }
?>
</div>
</div>
</div>
<?php
if($str[‘data’] == null or $str[‘data’] == “0”){
?>
<div id=“twitch-embed” class=“twitch-embed”>
<?php
echo “<p><h2>No one in live.</h2></p>”;
}
?>
</div>
</body>
</html>