API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 1st, 2017
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 14.21 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $username = "spaeks_cards";
  5. $password = "LOL GET RUSED";
  6. $dbname = "spaeks_cards";
  7.  
  8. // Create connection
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. // Check connection
  11. if ($conn->connect_error) {
  12.     die("Connection failed: " . $conn->connect_error);
  13. }
  14.  
  15. $siteurl="http://spaeks.com/ungoro/";
  16. $sitetitle="Journey to Un'goro Cards";
  17. include 'config.php';
  18.  
  19. $sql = "SELECT * FROM cards WHERE id=$cardid";
  20. $result = $conn->query($sql);
  21.  
  22. while($row = $result->fetch_assoc()) {
  23.     $cardname = $row['name'];
  24.     $cardclass = $row['class'];
  25.     $cardtype = $row['type'];
  26.     $cardrarity = $row['rarity'];
  27.     $cardtext = $row['text'];
  28.     $cardimg = $row['imgname'];
  29. }
  30.  
  31. ?>
  32.  
  33. <!DOCTYPE html>
  34. <html lang="en">
  35. <head>
  36. <title>Journey to Un'goro - <?php echo $cardname; ?></title>
  37. <meta name="description" content="Check out the exciting new cards from the latest Hearthstone expansion, Journey to Un'goro. Rate and discuss the new cards with the community!">
  38. <meta name="viewport" content="width=device-width, initial-scale=1">
  39. <link rel="stylesheet" type="text/css" href="<?php echo $siteurl; ?>css/bootstrap.css" />
  40. <link rel="stylesheet" type="text/css" href="<?php echo $siteurl; ?>css/style.css" />
  41. <script type="text/javascript" src="<?php echo $siteurl; ?>js/jquery-3.1.1.min.js"></script>
  42. <script src="<?php echo $siteurl; ?>js/bootstrap.js" type="text/javascript"></script>
  43. </head>
  44. <body>
  45.  
  46. <nav class="navbar navbar-inverse navbar-fixed-top">
  47.   <div class="container">
  48.     <div class="navbar-header">
  49.       <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
  50.         <span class="sr-only">Toggle navigation</span>
  51.         <span class="icon-bar"></span>
  52.         <span class="icon-bar"></span>
  53.         <span class="icon-bar"></span>
  54.       </button>
  55.       <a class="navbar-brand" href="#">Un'goro Cards</a>
  56.     </div>
  57.  
  58.     <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
  59.       <ul class="nav navbar-nav">
  60.         <li class="active"><a href="#">Newly Released <span class="sr-only">(current)</span></a></li>
  61.         <li><a href="#">Neutrals</a></li>
  62.         <li class="dropdown">
  63.           <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Class <span class="caret"></span></a>
  64.           <ul class="dropdown-menu">
  65.             <li><a href="#">Druid</a></li>
  66.             <li><a href="#">Rogue</a></li>
  67.             <li><a href="#">Shaman</a></li>
  68.             <li role="separator" class="divider"></li>
  69.             <li><a href="#">Neutral</a></li>
  70.           </ul>
  71.         </li>
  72.       </ul>
  73.       <ul class="nav navbar-nav navbar-right">
  74.       <form class="navbar-form navbar-right">
  75.         <div class="input-group">
  76.           <input type="text" class="form-control" placeholder="Search for Cards...">
  77.       <span class="input-group-btn">
  78.         <button class="btn btn-default" type="button">Go!</button>
  79.       </span>
  80.         </div>
  81.       </form>
  82.       </ul>
  83.     </div>
  84.   </div>
  85. </nav>
  86.  
  87. <div class="container">
  88. <div class="page-header">
  89. <h1><?php echo $cardname; ?> <small><?php echo $cardclass; ?></small></h1>
  90. </div>
  91. <ol class="breadcrumb">
  92.   <li><a href="#">Home</a></li>
  93.   <li><a href="#">Cards</a></li>
  94.   <li class="active"><?php echo $cardname; ?></li>
  95. </ol>
  96.  
  97. <div class="row">
  98.   <div class="col-md-4 col-xs-12"><img class="img-responsive cardimg" src="<?php echo $siteurl; ?>img/<?php echo $cardimg; ?>" alt="<?php echo $cardname; ?>" /></div>
  99.   <div class="col-md-4 col-xs-12">
  100. <div class="panel panel-default">
  101.   <div class="panel-heading">
  102.     <h3 class="panel-title">Card Info</h3>
  103.   </div>
  104.   <div class="panel-body">
  105.     <b>Type</b>: <?php echo $cardtype; ?><br>
  106.     <b>Class</b>: <?php echo $cardclass; ?><br>
  107.     <b>Rarity</b>: <?php echo $cardrarity; ?><br>
  108.   </div>
  109. </div>
  110. <div class="panel panel-default">
  111.   <div class="panel-heading">
  112.     <h3 class="panel-title">Card text</h3>
  113.   </div>
  114.   <div class="panel-body">
  115.     <?php echo $cardtext; ?>
  116.   </div>
  117. </div>
  118. </div>
  119.  
  120.   <div id="cardratings" class="col-md-4 col-xs-12">
  121. <div class="panel panel-default">
  122.   <div class="panel-heading">
  123.     <h3 class="panel-title">Card Ratings</h3>
  124.   </div>
  125.   <div class="panel-body">
  126.     <b>Constructed</b><br>
  127. <div class="progress"><?php
  128.  
  129. $rating = array();
  130. $sql = "SELECT rating FROM ratings WHERE cardid=$cardid AND votetype=1";
  131. $result = $conn->query($sql);
  132.  
  133. while($row = $result->fetch_assoc()) {
  134.     $rating[] = $row['rating'];
  135. }
  136.  
  137. $average = array_sum($rating) / count($rating);
  138. if ($average < 3.5) {
  139. $color = "danger";
  140. } elseif ($average >= 3.5 AND $average < 7) {
  141. $color = "warning";
  142. } elseif ($average >= 7) {
  143. $color = "success";
  144. } else {
  145. $color = "danger";
  146. }
  147.  
  148. ?>
  149.   <div class="progress-bar progress-bar-<?php echo $color; ?>" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo $average * 10; ?>%">
  150.     <span><b><?php echo number_format($average, 1); ?></b>/10</span>
  151.   </div>
  152. </div>
  153. <div id="rating-1" class="btn-group btn-group-sm ratecard" role="group" aria-label="...">
  154.   <a href="#" id="r-1-1" type="button" class="btn btn-default">1</a>
  155.   <a href="#" id="r-1-2" type="button" class="btn btn-default">2</a>
  156.   <a href="#" id="r-1-3" type="button" class="btn btn-default">3</a>
  157.   <a href="#" id="r-1-4" type="button" class="btn btn-default">4</a>
  158.   <a href="#" id="r-1-5" type="button" class="btn btn-default">5</a>
  159.   <a href="#" id="r-1-6" type="button" class="btn btn-default">6</a>
  160.   <a href="#" id="r-1-7" type="button" class="btn btn-default">7</a>
  161.   <a href="#" id="r-1-8" type="button" class="btn btn-default">8</a>
  162.   <a href="#" id="r-1-9" type="button" class="btn btn-default">9</a>
  163.   <a href="#" id="r-1-10" type="button" class="btn btn-default">10</a>
  164. </div>
  165. <small><div id="mesij-1">&nbsp;</div></small>
  166. <hr />
  167.     <b>Arena</b><br>
  168. <div class="progress"><?php
  169.  
  170. $rating = array();
  171. $sql = "SELECT rating FROM ratings WHERE cardid=$cardid AND votetype=2";
  172. $result = $conn->query($sql);
  173.  
  174. while($row = $result->fetch_assoc()) {
  175.     $rating[] = $row['rating'];
  176. }
  177.  
  178. $average = array_sum($rating) / count($rating);
  179. if ($average < 3.5) {
  180. $color = "danger";
  181. } elseif ($average >= 3.5 AND $average < 7) {
  182. $color = "warning";
  183. } elseif ($average >= 7) {
  184. $color = "success";
  185. } else {
  186. $color = "danger";
  187. }
  188.  
  189. ?>
  190.   <div class="progress-bar progress-bar-<?php echo $color; ?>" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo $average * 10; ?>%">
  191.     <span><b><?php echo number_format($average, 1); ?></b>/10</span>
  192.   </div>
  193. </div>
  194. <div id="rating-2" class="btn-group btn-group-sm ratecard" role="group" aria-label="...">
  195.   <a href="#" id="r-2-1" type="button" class="btn btn-default">1</a>
  196.   <a href="#" id="r-2-2" type="button" class="btn btn-default">2</a>
  197.   <a href="#" id="r-2-3" type="button" class="btn btn-default">3</a>
  198.   <a href="#" id="r-2-4" type="button" class="btn btn-default">4</a>
  199.   <a href="#" id="r-2-5" type="button" class="btn btn-default">5</a>
  200.   <a href="#" id="r-2-6" type="button" class="btn btn-default">6</a>
  201.   <a href="#" id="r-2-7" type="button" class="btn btn-default">7</a>
  202.   <a href="#" id="r-2-8" type="button" class="btn btn-default">8</a>
  203.   <a href="#" id="r-2-9" type="button" class="btn btn-default">9</a>
  204.   <a href="#" id="r-2-10" type="button" class="btn btn-default">10</a>
  205. </div>
  206. <small><div id="mesij-2">&nbsp;</div></small>
  207. <hr />
  208.     <b>Design/Mechanics</b><br>
  209. <div class="progress"><?php
  210.  
  211. $rating = array();
  212. $sql = "SELECT rating FROM ratings WHERE cardid=$cardid AND votetype=3";
  213. $result = $conn->query($sql);
  214.  
  215. while($row = $result->fetch_assoc()) {
  216.     $rating[] = $row['rating'];
  217. }
  218.  
  219. $average = array_sum($rating) / count($rating);
  220. if ($average < 3.5) {
  221. $color = "danger";
  222. } elseif ($average >= 3.5 AND $average < 7) {
  223. $color = "warning";
  224. } elseif ($average >= 7) {
  225. $color = "success";
  226. } else {
  227. $color = "danger";
  228. }
  229.  
  230. $conn->close();
  231.  
  232. ?>
  233.   <div class="progress-bar progress-bar-<?php echo $color; ?>" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo $average * 10; ?>%">
  234.     <span><b><?php echo number_format($average, 1); ?></b>/10</span>
  235.   </div>
  236. </div>
  237. <div id="rating-3" class="btn-group btn-group-sm ratecard" role="group" aria-label="...">
  238.   <a href="#" id="r-3-1" type="button" class="btn btn-default">1</a>
  239.   <a href="#" id="r-3-2" type="button" class="btn btn-default">2</a>
  240.   <a href="#" id="r-3-3" type="button" class="btn btn-default">3</a>
  241.   <a href="#" id="r-3-4" type="button" class="btn btn-default">4</a>
  242.   <a href="#" id="r-3-5" type="button" class="btn btn-default">5</a>
  243.   <a href="#" id="r-3-6" type="button" class="btn btn-default">6</a>
  244.   <a href="#" id="r-3-7" type="button" class="btn btn-default">7</a>
  245.   <a href="#" id="r-3-8" type="button" class="btn btn-default">8</a>
  246.   <a href="#" id="r-3-9" type="button" class="btn btn-default">9</a>
  247.   <a href="#" id="r-3-10" type="button" class="btn btn-default">10</a>
  248. </div>
  249. <small><div id="mesij-3">&nbsp;</div></small>
  250.   </div>
  251. </div>
  252.  
  253. </div>
  254.  
  255. <hr>
  256.       <footer>
  257.         <p class="pull-right"><a href="#">top</a></p>
  258.         <p class="pull-left">
  259.         <small>
  260.         <a href="#">Home</a><br>
  261.         <a href="#">Cards</a><br>
  262.         <a  href="#">Contact</a>
  263.         </small>
  264.         </p>
  265.        
  266.     <center><p>Copyright &copy; Spaeks.com 2016</p></center>
  267.        
  268.       </footer>
  269.  
  270. </div>
  271.     <script>
  272. $(document).ready(function(){var a=$("a#r-1-1"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/1.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-2"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/2.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-3"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/3.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-4"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/4.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-5"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/5.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-6"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/6.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-7"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/7.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-8"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/8.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-9"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/9.php"),!1})}),$(document).ready(function(){var a=$("a#r-1-10"),b=$("#mesij-1");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-1/10.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-1"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/1.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-2"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/2.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-3"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/3.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-4"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/4.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-5"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/5.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-6"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/6.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-7"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/7.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-8"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/8.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-9"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/9.php"),!1})}),$(document).ready(function(){var a=$("a#r-2-10"),b=$("#mesij-2");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-2/10.php"),!1})});$(document).ready(function(){var a=$("a#r-3-1"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/1.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-2"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/2.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-3"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/3.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-4"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/4.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-5"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/5.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-6"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/6.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-7"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/7.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-8"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/8.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-9"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/9.php"),!1})}),$(document).ready(function(){var a=$("a#r-3-10"),b=$("#mesij-3");a.on("click",function(){var a=$(this);return a.data("target"),b.load("ratings-3/10.php"),!1})});
  273.     </script>
  274. </body>
  275. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!