API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 19th, 2017
121
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.11 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="de" lang="de">
  3. <head>
  4. <title>Tiamat Game Portal</title>
  5. <meta charset="UTF-8">
  6. </head>
  7. <body bgcolor="#212121" oncontextmenu="return false" onselectstart="return false" topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" style="font-family: Tahoma; font-size: 9pt; color: #FFFFFF">
  8. <?php
  9. include('auth.php');
  10.  
  11.  
  12. function connect(){
  13. require("conf.php");
  14.  
  15. $connect = sqlsrv_connect($serverName, $connectionInfo);
  16. if (!$connect) {
  17. echo "<script type='text/javascript' language='javascript'> ";
  18. echo "alert('Problem.') ";
  19. echo "</script>";
  20. }
  21. return $connect;
  22. }
  23.  
  24. $username = $_SESSION['usr'] ;
  25. $password = $_SESSION['pwd'] ;
  26. $account_id = $_SESSION['sid'] ;
  27. $playername = $_SESSION['player'] ;
  28. $_SESSION['title']="Tiamat Shop" ;
  29. $cat_nr = 0;
  30. $refcnt=$_SESSION['refcnt'];
  31. $_SESSION['idx'] = $_GET['idx'] ;
  32.  
  33. if (is_null($refcnt)){
  34. $refcnt=0;
  35. }
  36.  
  37. $referer = $_SERVER["HTTP_REFERER"];
  38. $hostname = $_SERVER['HTTP_HOST'];
  39. $path = dirname($_SERVER['PHP_SELF']);
  40.  
  41. $db = connect();
  42.  
  43. $char_check ="SELECT s.punkte, s.gesamt_punkte, s.shop_points, s.shop_points_total,c.name from Telecaster.dbo.user_points s join Telecaster.dbo.Character c on s.account = c.account_id WHERE s.account = $account_id AND c.login_time > c.logout_time";
  44. $check_character_points = sqlsrv_query($db,$char_check);
  45. if( $check_character_points === false) {
  46. die( print_r( sqlsrv_errors(), true) );
  47. }
  48. $punkte = null;
  49. while( $row = sqlsrv_fetch_array( $check_character_points, SQLSRV_FETCH_ASSOC) ) {
  50. $punkte = $row['punkte'];
  51. $gesamt_punkte = $row['gesamt_punkte'];
  52. $charname = $row['name'];
  53. $shoppoints = $row['shop_points'];
  54. $shoppoints_total = $row['shop_points_total'];
  55.  
  56. }
  57.  
  58. if(is_null($punkte)){
  59. $punkte = 0;
  60. }
  61.  
  62. if(is_null($gesamt_punkte)){
  63. $gesamt_punkte = 0;
  64. }
  65.  
  66. if(is_null($shoppoints)){
  67. $shoppoints = 0;
  68. }
  69.  
  70. if(is_null($shoppoints_total)){
  71. $shoppoints_total = 0;
  72. }
  73.  
  74. $_SESSION['punkte'] = $punkte;
  75. $_SESSION['gesamt_punkte'] = $gesamt_punkte;
  76. $_SESSION['charactername'] = $charname;
  77. $_SESSION['shoppoints'] = $shoppoints;
  78. $_SESSION['shoppointstotal'] = $shoppoints_total;
  79. $sorter = $_SESSION['online_sort'];
  80. if($sorter == null)
  81. {
  82. $sorter = 'DESC';
  83. }
  84.  
  85. include 'header_portal.php';
  86.  
  87.  
  88. echo '<div id="content_portal_bg">';
  89. echo '<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="1000" height="565" bordercolor="#808080" background="img/mainbg_portal.jpg">';
  90. echo '<tr>';
  91. echo '<td width="280" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" valign="top">';
  92. //-- HauptFrame LINKS mit 720 PX Breite
  93.  
  94. $db = connect();
  95.  
  96. $ranking_query =" select cc.name,cc.lv,cc.exp,cc.job,cc.jlv,cc.permission,cc.login_time,cc.pkc,ISNULL((SELECT name from Telecaster.dbo.Guild as G where G.sid = (SELECT guild_id from Telecaster.dbo.GuildMember where player_id=cc.sid)),'None') as guild,cast((cast(((CAST(cc.exp - (select l.exp from Arcadia.dbo.LevelResource l Join Telecaster.dbo.Character c on c.lv -1 = l.level where c.name = cc.name) as decimal(30,2)))* 100) /(cast(need.exp - (select l.exp from Arcadia.dbo.LevelResource l Join Telecaster.dbo.Character c on c.lv -1 = l.level where c.name = cc.name) as decimal(30,2))) as decimal (30,2)))as nvarchar(max)) as exp_perc from Telecaster.dbo.Character cc join Arcadia.dbo.LevelResource need on cc.lv = need.level JOIN Auth.dbo.Accounts as A on A.account_id= cc.account_id join arcadia.dbo.stringresource s on cc.job+10000 = s.code where cc.lv < 180 and A.block!=1 and cc.lv >= 1 and cc.name not like '%@%' and cc.permission = 1 and cc.login_time > cc.logout_time order by cc.exp DESC"; //where C.permission != 100 and C.name not like '@%' and C.lv < 192 and A.block!=1 order by C.exp desc
  97.  
  98. $ranking = sqlsrv_query($db,$ranking_query);
  99. if( $ranking === false) {
  100. die( print_r( sqlsrv_errors(), true) );
  101. }
  102. $counter=1;
  103.  
  104. echo '<table width="105%" height="20" style="border-bottom:1px solid #808080; border-collapse: collapse" bgcolor="#000000">
  105. <tr align="center">
  106. <th ><font color="#FF9900" size="2" face="Tahoma"><b>Who is Online?</b></font></td></table>';
  107. echo '<div STYLE=" height: 535px; width: 295px; font-size: 12px; overflow: auto;"><table cellpadding="0" width="93%" height="10">';
  108.  
  109. // echo' <p style="text-align: center; margin: auto; margin-top: 10px; "><input type="submit" value="Ascending" onClick="window.location.reload()" '.$_SESSION['online_sort'] = 'ASC'.' style="margin:5px 10px -25px;" /></p>';
  110. // echo' <p style="text-align: center; margin: auto; "><input type="submit" value="Descending" onClick="window.location.reload()" '.$_SESSION['online_sort'] = 'DESC'.' style="margin:-28px 0px 0px 138px;" /></p>';
  111. //echo' <p style="text-align: center; margin: auto; margin-top: 10px; "><input type="submit" value="Ascending" style="margin:10px 10px -25px;" /></p>';
  112.  
  113. while( $Row = sqlsrv_fetch_array( $ranking, SQLSRV_FETCH_ASSOC) ) {
  114.  
  115. echo '<table cellpadding="0" width="92%" height="25" align="center">';
  116. echo '<tr>';
  117. echo '<td colspan="5" height="5" bgcolor="#000000">';
  118. echo '</td>';
  119. echo '</tr>';
  120. echo '<tr>';
  121. echo '<td height="20" align="center" width="140" bgcolor="#25140D">';
  122. if($Row["permission"] == 100 )
  123. {
  124. echo '<b><font color="#F30404" size="1" face="Tahoma">'.$Row["name"].'</font></b></td>';
  125. }
  126. else
  127. {
  128. echo '<b><font color="#FFFFFF" size="1" face="Tahoma">'.$Row["name"].'</font></b></td>';
  129. }
  130. echo '<td height="20" align="center" width="18" bgcolor="#25140D">';
  131.  
  132. switch ($Row["job"])
  133. {
  134. case 100 : echo "<div align='center'><img src='img/class/100.jpg' title='Rogue'>"; break;
  135. case 101 : echo "<div align='center'><img src='img/class/101.jpg' title='Fighter'>"; break;
  136. case 110 : echo "<div align='center'><img src='img/class/110.jpg' title='Champion'>"; break;
  137. case 120 : echo "<div align='center'><img src='img/class/120.jpg' title='Berserker'>"; break;
  138. case 200 : echo "<div align='center'><img src='img/class/200.jpg' title='Guide'>"; break;
  139. case 201 : echo "<div align='center'><img src='img/class/201.jpg' title='Holy Warrior'>"; break;
  140. case 210 : echo "<div align='center'><img src='img/class/210.jpg' title='Knight'>"; break;
  141. case 211 : echo "<div align='center'><img src='img/class/211.jpg' title='Soldier'>"; break;
  142. case 220 : echo "<div align='center'><img src='img/class/220.jpg' title='Templar'>"; break;
  143. case 221 : echo "<div align='center'><img src='img/class/221.jpg' title='Mercenary'>"; break;
  144. case 300 : echo "<div align='center'><img src='img/class/300.jpg' title='Stepper'>"; break;
  145. case 301 : echo "<div align='center'><img src='img/class/301.jpg' title='Strider'>"; break;
  146. case 310 : echo "<div align='center'><img src='img/class/310.jpg' title='Assassin'>"; break;
  147. case 320 : echo "<div align='center'><img src='img/class/320.jpg' title='Slayer'>"; break;
  148. case 321 : echo "<div align='center'><img src='img/class/321.jpg' title='Deadeye'>"; break;
  149. case 311 : echo "<div align='center'><img src='img/class/311.jpg' title='Shadow Hunter'>"; break;
  150. case 121 : echo "<div align='center'><img src='img/class/121.jpg' title='Marksman'>"; break;
  151. case 111 : echo "<div align='center'><img src='img/class/111.jpg' title='Archer'>"; break;
  152. case 112 : echo "<div align='center'><img src='img/class/112.jpg' title='Druid'>"; break;
  153. case 113 : echo "<div align='center'><img src='img/class/113.jpg' title='Battle Kahuna'>"; break;
  154. case 102 : echo "<div align='center'><img src='img/class/102.jpg' title='Kahuna'>"; break;
  155. case 122 : echo "<div align='center'><img src='img/class/122.jpg' title='Magus'>"; break;
  156. case 123 : echo "<div align='center'><img src='img/class/123.jpg' title='War Kahuna'>"; break;
  157. case 202 : echo "<div align='center'><img src='img/class/202.jpg' title='Cleric'>"; break;
  158. case 312 : echo "<div align='center'><img src='img/class/312.jpg' title='Chaos Magician'>"; break;
  159. case 313 : echo "<div align='center'><img src='img/class/313.jpg' title='Warlock'>"; break;
  160. case 302 : echo "<div align='center'><img src='img/class/302.jpg' title='Dark Magician'>"; break;
  161. case 222 : echo "<div align='center'><img src='img/class/222.jpg' title='Cardinal'>"; break;
  162. case 223 : echo "<div align='center'><img src='img/class/223.jpg' title='Oracle'>"; break;
  163. case 212 : echo "<div align='center'><img src='img/class/212.jpg' title='Bishop'>"; break;
  164. case 213 : echo "<div align='center'><img src='img/class/213.jpg' title='Priest'>"; break;
  165. case 322 : echo "<div align='center'><img src='img/class/322.jpg' title='Void Mage'>"; break;
  166. case 323 : echo "<div align='center'><img src='img/class/323.jpg' title='Corruptor'>"; break;
  167. case 324 : echo "<div align='center'><img src='img/class/324.jpg' title='Overlord'>"; break;
  168. case 214 : echo "<div align='center'><img src='img/class/214.jpg' title='Soul Breeder'>"; break;
  169. case 224 : echo "<div align='center'><img src='img/class/224.jpg' title='Master Breeder'>"; break;
  170. case 303 : echo "<div align='center'><img src='img/class/303.jpg' title='Sorcerer'>"; break;
  171. case 314 : echo "<div align='center'><img src='img/class/314.jpg' title='Battle Summoner'>"; break;
  172. case 203 : echo "<div align='center'><img src='img/class/203.jpg' title='Breeder'>"; break;
  173. case 124 : echo "<div align='center'><img src='img/class/124.jpg' title='Beast Master'>"; break;
  174. case 103 : echo "<div align='center'><img src='img/class/103.jpg' title='Spell Singer'>"; break;
  175. case 114 : echo "<div align='center'><img src='img/class/114.jpg' title='Evoker'>"; break;
  176. }
  177.  
  178. echo '</div></td>';
  179. echo '<td height="20" align="center" width="80" bgcolor="#25140D">';
  180. echo '<font color="#FFFFFF" size="1" face="Tahoma">Level: '.$Row["lv"].'</font></td>';
  181. echo '</tr>';
  182. echo '<tr>';
  183. echo '<td colspan="5" height="5" bgcolor="#000000" style="border-style: none; border-width: medium; ">';
  184. echo '</td>';
  185. echo '<tr>';
  186. $counter++;
  187. }
  188.  
  189. echo '</table>';
  190.  
  191.  
  192.  
  193.  
  194.  
  195. echo '</td>';
  196. echo '<td width="720" align="center" valign="top" style="border-left-style: solid; border-left-width: 1px; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: none; border-bottom-width: medium" background="img/input-bghover.png">';
  197. //-- NebenFrame RECHTS mit 280 PX Breite für Infos und Beschreibungen
  198.  
  199. include 'ranking.php';
  200.  
  201.  
  202. echo '</td>';
  203. echo '</tr>';
  204. echo '</table>';
  205. ?>
  206. <table border="0" bordercolor="#999999" height="25" width="1000" background="img/footer_portal.jpg" cellspacing="0" cellpadding="0" style="border-collapse: collapse; border-style: solid; border-width: 1px">
  207. <tr>
  208. <td>
  209. </td>
  210. </tr>
  211. </table>
  212. </body>
  213. </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!