1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <?php
  3. $curdir = getcwd ();
  4. chdir('/forum');
  5. require_once('/global.php');
  6. chdir ($curdir);
  7. ?>
  8. <html xmlns="http://www.w3.org/1999/xhtml">
  9. <head>
  10. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  11. <title>Svex</title>
  12.  
  13. <?php include 'header.php'; ?> 
  14. <link rel="stylesheet" type="text/css" href="scripts/css/svex.css" /> 
  15. <script src="scripts/js/svexmenu.js" type="text/javascript"> </script>
  16.  
  17. <style type="text/css">
  18. <!--
  19. div.svexmenu  {color:#5B6275; font-family: Arial; font-size: 17px}
  20.  
  21. div.svexmenu a {color:#5B6275; font-family: Arial; font-size: 17px}
  22.  
  23. div.svexmenu a:hover {color:#3C404D; font-family: Arial; font-size: 17px}
  24.  
  25. div.svextitle  {color:#FFFFFF; font-family: Arial; font-size: 22px}
  26.  
  27. div.svextitle a {color:#FFFFFF; font-family: Arial; font-size: 22px}
  28.  
  29. div.svextitle a:hover {color:#5B6275; font-family: Arial; font-size: 22px}
  30.  
  31. div.svexuser  {color:#DCDFE1; font-family: Arial; font-size: 17px}
  32.  
  33. div.svexuser a {color:#DCDFE1; font-family: Arial; font-size: 17px}
  34.  
  35. div.svexuser a:hover {color:#5B6275; font-family: Arial; font-size: 17px}
  36.  
  37. .style34 {
  38. 	font-family: Arial;
  39. 	color: #5B6275;
  40. }
  41. a:link {
  42. 	color: #FFFFFF;
  43. }
  44. a:visited {
  45. 	color: #FFFFFF;
  46. }
  47. a:hover {
  48. 	color: #A8AEB8;
  49. }
  50. a:active {
  51. 	color: #FFFFFF;
  52. }
  53. .style36 {color: #000000}
  54. body,td,th {
  55. 	color: #FFFFFF;
  56. }
  57.  
  58.  
  59. -->
  60. </style>
  61. </head>
  62.  
  63. <body style="background-color: white;">
  64.  
  65. <div id="main" style="width: 900px; padding-left: 1px; margin: auto;"> 
  66. <div id="navigatorhead" style="width: 900px; height: 21px; background-image: url(images/svex/navigator.jpg);"
  67. >
  68. <div class= "svexmenu" style="width: 900px; height: 18px; padding-bottom: 3px; ">
  69. &nbsp;<span class="style49 style34">SVEX Navigator</span></div>
  70. </div>
  71. <div style="width: 900px; height: 1px;"></div>
  72. <div id="navigator"> </div>
  73. <div id="svexible" style="width: 748px; height: 46px; float: right; padding-top: 1px; background-image:url(images/svex/quicknav.jpg);"> 
  74.  
  75. <div class="style49" style="height: 18px; width: 700px; padding-left: 12px; padding-top: 13px;"><span class="style46">Simvision Exchange &nbsp; &nbsp; </span>   
  76.   <? 
  77.  
  78.  
  79. $url = $_SERVER['SERVER_NAME']; 
  80. $page = $_SERVER['php_SELF']; 
  81. $file = $_SERVER['REQUEST_URI'];
  82.  
  83.  
  84. ?>
  85. <?php
  86.  
  87.  
  88. // Delimiters may be slash, dot, or hyphen
  89. $contentsc = $file;
  90. list($pagenumber, $pagenum) = split('[=]', $contentsc);
  91.  
  92. ?>
  93. <?php 
  94.  
  95.  
  96.  
  97. if ( $pagenum <= 4 ) {
  98.  
  99.  
  100.  
  101. $count = 147; 
  102. $pv = $count / 6;
  103. $round = ceil($pv);
  104.  
  105. $pvn = 2;
  106. $tpn = 10;
  107.  
  108. for ( $pn = $pvn; $pn <= $round;  $pn += 1) { /* starting from a value */
  109.  
  110.  
  111. ?>
  112. <a href="http://simvision.net/tpp/svexy.php?pageid=<?php echo $pn ?>"><?php echo $pn ?></a>
  113. <?php
  114.  
  115.  if ($pn == $tpn) { /* breaking*/
  116.         break;    
  117.  
  118.  
  119. }
  120.  
  121. ?>
  122. &nbsp;
  123. <?php /* */
  124.  
  125. }
  126.  
  127.  
  128. } else {
  129.  
  130.  
  131.  
  132. $count = 147;  /* total bats */
  133. $pv = $count / 6; /* bats for each page*/
  134.  
  135. $lvv = $pagenum - 3;
  136. $ltpn = $pagenum - 1; 
  137.  
  138.  
  139.  
  140. for ( $lpn = $lvv; $lpn <= $pv;  $lpn += 1) { /* starting from a value */
  141.  
  142. ?>
  143. <a href="http://simvision.net/tpp/svexy.php?pageid=<?php echo $lpn ?>"><?php echo $lpn ?></a>
  144. <?php
  145.  
  146.  
  147.  if ($lpn == $ltpn) { /* breaking*/
  148.         break;    
  149.  
  150.  
  151. }
  152.  
  153. ?>
  154. &nbsp;
  155. <?php /* */
  156.  
  157. }
  158. ?>
  159. &nbsp;
  160. <?php
  161.  
  162. echo $pagenum;
  163. ?>
  164. &nbsp;
  165. <?php
  166. $pvn = $pagenum + 1; /* display previous two pages */
  167.  
  168. $tpn = $pvn + 5; /* display current page and next 5 pages */
  169.  
  170. $round = ceil($pv);
  171.  
  172. for ( $pn = $pvn; $pn <= $round;  $pn += 1) { /* starting from a value */
  173.  
  174.  
  175. ?>
  176. <a href="http://simvision.net/tpp/svexy.php?pageid=<?php echo $pn ?>"><?php echo $pn ?></a>
  177. <?php
  178.  
  179.  if ($pn == $tpn) { /* breaking*/
  180.         break;    
  181.  
  182.  
  183.  
  184. }
  185.  
  186. ?>
  187. &nbsp;
  188. <?php /* */
  189.  
  190. }
  191.  
  192.  
  193. }
  194.  
  195. ?>
  196. </div>
  197. </div>
  198.  
  199. <?php $host=""; // Host name 
  200. $username=""; // Mysql username 
  201. $password=""; // Mysql password 
  202. $db_name=""; // Database name 
  203. $tbl_name=""; // Table name 
  204.  
  205.  
  206. // Connect to server and select databse.
  207. mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
  208. mysql_select_db("$db_name")or die("cannot select DB");
  209.  
  210.  
  211. $sql = "SELECT * FROM   WHERE cat1 = 'SimCity 4' AND validator !='' ORDER BY id DESC LIMIT 0,6";
  212. $result=mysql_query($sql);
  213.  
  214. $rows=mysql_fetch_array($result);
  215.  
  216. $sql = "SELECT * FROM   WHERE cat1 = 'SimCity 4' AND validator !='' ORDER BY id DESC LIMIT 0,6";
  217. $query = mysql_query($sql);
  218. while($row = mysql_fetch_array($query)) {
  219.  
  220. ?>
  221. <div style="width:748px; height: 206px; float: left; background-color:#A8AEB8; "> 
  222. <div style="width: 748px; height: 21px; float: left; background-image:url(images/index/common/headblue.jpg);">&nbsp; <?php echo $row['cat2']; ?> > <?php echo $row['cat3']; ?> </div>
  223. <div style="width:748px; height:185px; float: left;">
  224. <div style="width: 270px; height: 200px; float: left; ">
  225. <div style="width: 261px; height: 148px; padding-left: 8px; padding-top: 12px;"><img src="<?php echo $row['thumburl1']; ?>" alt="" width="254" height="148" border="3" style="border-color: #5B6275;"
  226.  /></div> </div>
  227.  
  228. <div class="svextitle" style="width: 472px; padding-left: 6px; float: left; "><a href="http://simvision.net/svex.php?p=details&id=<?php echo $row['id']; ?> "><?php echo $row['name']; ?></a></div>
  229. <div class="svexuser" style="width: 472px; padding-left: 6px; float: left; "> <a href="http://www.simvision.net/svex.php?p=user&id=<?php echo $row['userid']; ?>">by <?php echo $row['username']; ?></a></div>
  230. <div style="width: 472px; padding-left: 6px; float: left; height: 98px;"> <?php echo substr($row['descrip'],0,125);  ?>...</div>
  231. <div style="width: 472px; height:34px; padding-left: 3px; height: 40px; background-color:#B5B5B5; float: left;">
  232. <div style="padding-top: 6px; padding-left: 6px; float: left;"> 
  233. <?=date("F j, Y",$row["dt"])?> | Views <?php echo $row['views']; ?> | Downloads: <?php echo $row['dls']; ?>  |  
  234.  
  235. <?php $score = $row['score'];
  236. $votes = $row['votes'];
  237.  
  238.  
  239. if ( $votes == 0 ) {
  240. 	echo "No Votes";
  241. } else {
  242.  
  243. $total = $score / $votes;
  244.  
  245.  
  246.  
  247. $stars = $total / 2;
  248.  
  249. $starstotal = ceil($stars);
  250.  
  251. switch ($starstotal){
  252. 	case "1":
  253. 		?> <img src="images/index/common/star.png" /><?php
  254. 		break;
  255. 	case "2":
  256. 	?><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /> <?php
  257. 		break;	
  258. 	case "3":
  259. 	?><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /> <?php
  260. 		break;	
  261. 	case "4":
  262. ?><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /> <?php
  263. 		break;
  264. 	case "5":
  265. 		?><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /> <?php
  266. 		break;	
  267. }
  268.  
  269. }
  270. ?>
  271. </div> 
  272.  
  273.  
  274.  
  275.  </div>
  276.  
  277.  
  278.   </div> 
  279. <div style="width: 748px; height: 8px; float: left; background-color: #FFFFFF; ">Testing 1..2..3 </div>
  280. </div>
  281. </div>
  282.  
  283. <span style="width: 900px; padding-left: 1px; margin: auto;">
  284. <?php } ?>
  285. </span>
  286. </body>
  287.  
  288. </html>
  289.