API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 2nd, 2013
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.50 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.    if(isset($_POST['nev'] , $_SESSION['id'], $_POST['Token'])){
  3.    
  4.    mysql_select_db($authdb);
  5.    $ervenyes_e = mysql_query("SELECT account, sha_pass_hash FROM account WHERE account = '".$_SESSION['username']."' AND and sha_pass_hash = '".$_POST['Token']."'");
  6.    if(mysql_num_rows($ervenyes_e) == 1){
  7.    
  8.    mysql_select_db($charsdb);
  9.    $kar_van_e  mysql_query("SELECT account, name FROM caharcters WHERE account = '".$_SESSION['id']."' AND name = '".$_POST['nev']."'");
  10.    
  11.    
  12.    
  13.    mysql_select_db($charsdb);
  14.    $karaktervaltas_query = mysql_query("SELECT * FROM characters WHERE account='".$_SESSION['id']."' and name='".$_POST['nev']."'");
  15.    $karaktervaltas_query_row = mysql_fetch_array($karaktervaltas_query);
  16.    $karakterbok_karakterrace = $karaktervaltas_query_row['race'];
  17.    $awatar_osszefuzes = $karakterbok_karakterrace.'-'.$karaktervaltas_query_row['gender'];
  18.    // Update-elek a felhasználók táblába, hogy leváltsam a karaktert.
  19.       mysql_select_db($weboldaldb);
  20.    mysql_query("UPDATE felhasznalok SET avatar='$awatar_osszefuzes', karakternev='$karaktervaltas_query_row[name]', level='$karaktervaltas_query_row[level]', class='$karaktervaltas_query_row[class]', realm='$_SESSION[realmnev]' WHERE fiokid='$_SESSION[id]'");
  21.    }}
  22. /*$karakter_race_tomb = array(
  23. 1 => 'human',
  24. 2 => 'orc',
  25. 3 => 'dwarf',
  26. 4 => 'nightelf',
  27. 5 => 'scourge',
  28. 6 => 'tauren',
  29. 7 => 'gnome',
  30. 8 => 'troll',
  31. 10 => 'bloodelf',
  32. 11 => 'draenei');
  33.  
  34. $karakter_class_tomb = array(
  35. 1 => 'Warrior',
  36. 2 => 'Paladin',
  37. 3 => 'Hunter',
  38. 4 => 'Rogue',
  39. 5 => 'Priest',
  40. 6 => 'Death Knight',
  41. 7 => 'Shaman',
  42. 8 => 'Mage',
  43. 9 => 'Warlock',
  44. 11 => 'Druid');*/
  45.  
  46.  
  47. // Kiválasztjuk a charsdb-t mivel abból akarunk lekérni adatokat
  48. mysql_select_db($weboldaldb);
  49. // A seletected, amivel lekérdezzük az adatokat
  50. $character = "SELECT * FROM felhasznalok WHERE fiokid=$_SESSION[id]";
  51. // A mysql_query-vel végrehajtjuk a fentebb definiált SQL lekérdezést, ami az array nevű változóban visszaadja a SELECT eredményét ami egy két dimenziós tömb (mivel oszlopokból és sorokból áll)
  52. $character_array= mysql_query($character);
  53. $character_array_row = mysql_num_rows($character_array);
  54.  
  55. if (empty($character_array_row)){
  56. if($_SESSION['gmlevel']){
  57. $insert_sql_gm = "INSERT INTO felhasznalok (fiokid, avatar, blizz, karakternev, level, guild, realm) VALUES ('$_SESSION[id]', '0-0', '$_SESSION[gmlevel]', '', '0', '0', '0')";
  58. mysql_query($insert_sql_gm);
  59.  
  60. }else{
  61. $insert_sql = "INSERT INTO felhasznalok (fiokid, avatar, blizz, karakternev, level, guild, realm) VALUES ('$_SESSION[id]', '0-0', '0', '', '0', '0', '0')";
  62. mysql_query($insert_sql);
  63. }
  64.  
  65.                 }
  66.                            
  67.     mysql_select_db( "$authdb" );
  68.  
  69.     // Hány darab karakter tartozik a megadott fiókhoz ( realmcaharacter ), és melyik realmon van.
  70.     $fiokkarakter = "select * from realmcharacters WHERE acctid=$_SESSION[id]";
  71.     $fiokkaraktereredmeny = mysql_query($fiokkarakter);
  72.     if (!$fiokkaraktereredmeny) {
  73.         die("Hiba a lekérésbe: $sql " . mysql_error());
  74.     }
  75.     if (mysql_num_rows($fiokkaraktereredmeny) == 1) {
  76.     $realmid_tomb = mysql_fetch_assoc($fiokkaraktereredmeny);
  77.     $_SESSION['realmid'] = $realmid_tomb['realmid'];
  78.    
  79.     $realmnev_sql = "SELECT * FROM realmlist WHERE id=$_SESSION[realmid]";
  80.     $realm_lekeres = mysql_query($realmnev_sql);
  81.         $realmnev_tomb = mysql_fetch_assoc($realm_lekeres);
  82.         $_SESSION['realmnev'] = $realmnev_tomb['name'];
  83.  
  84.     /*class='card-character plate-alliance'
  85.     vagy
  86.     class='card-character plate-horde'
  87.     vagy
  88.     class='card-character plate-portrait'
  89.     vagy
  90.     class='card-character plate-gm'
  91.     /images/layout/cards-mop/charcard-gm.jpg*/
  92.     mysql_select_db($weboldaldb);
  93.     $karakterlekerdezes_valasztott = mysql_query("SELECT * FROM felhasznalok WHERE fiokid=$_SESSION[id]");
  94.     $karakterlekerdezes_valasztott_tomb = mysql_fetch_array($karakterlekerdezes_valasztott);
  95.    
  96.    
  97.     $kartya_hatterek = array("2-0", "2-1", "5-0", "5-1", "6-0", "6-1", "8-0", "8-1", "10-0", "10-1");
  98.    
  99.    
  100. if(in_array($karakterlekerdezes_valasztott_tomb['avatar'], $kartya_hatterek)){
  101.  
  102. $kartya_hatter = 'class="card-character plate-horde ajax-update"';
  103. $meta_wrapper = 'meta-horde';
  104.  
  105. }else{
  106.  
  107. $kartya_hatter = 'class="card-character plate-alliance ajax-update"';
  108. $meta_wrapper = 'meta-alliance';
  109.  
  110. }
  111.  
  112. ?>
  113.  
  114.  
  115. <div class='user-plate'>
  116. <a id='user-plate'
  117. <?php
  118.  
  119.  
  120.  
  121.  
  122. echo $kartya_hatter;
  123.  
  124. ?>  rel='np' href='<?php echo $kiindulomappa . 'kozosseg/karakter.php?profil=' . $karakterlekerdezes_valasztott_tomb['karakternev']; ?>'>
  125. <span class='card-portrait' style='background-image:url(<?php echo $kiindulomappa ?>megjelenes/<?php echo $tema; ?>/images/2d/avatar/<?php echo $karakterlekerdezes_valasztott_tomb['avatar']; ?>.jpg)'></span>
  126. </a>
  127. <div class='meta-wrapper <?php echo $meta_wrapper; ?> ajax-update'>
  128. <div class='meta'>
  129. <div class='player-name'><?php echo ucfirst($_SESSION['username']); ?></div>
  130. <div class='character'>
  131. <a class='character-name context-link text-small' rel='np' href='' data-tooltip='Change character' data-tooltip-options='{"location": "topCenter"}'>
  132. <?php if ($karakterlekerdezes_valasztott_tomb['karakternev']){ echo $karakterlekerdezes_valasztott_tomb['karakternev'];}else{ echo 'Nincs kiválasztva karakter';} ?>
  133. <span class="arrow"></span>
  134. </a>
  135. <div id='context-1' class='ui-context character-select'>
  136. <div class='context'>
  137. <a href='javascript:;' class='close' onclick='return CharSelect.close(this);'></a>
  138. <div class='context-user'>
  139. <strong><?php if ($karakterlekerdezes_valasztott_tomb['karakternev']){ echo $karakterlekerdezes_valasztott_tomb['karakternev'];}else{ echo 'Nincs kiválasztva karakter';} ?></strong>
  140. <br/>
  141. <span class='realm up'><?php echo ucfirst($karakterlekerdezes_valasztott_tomb['realm']);?></span>
  142. </div>
  143. <div class='context-links'>
  144. <a href='<?php echo $kiindulomappa . 'kozosseg/karakter.php?profil=' . $karakterlekerdezes_valasztott_tomb['karakternev']; ?>' title='Profile' rel='np' class='icon-profile link-first'>
  145. Profile
  146. </a>
  147. <a href='/wow/en/search?f=post&amp;a=Bravandvia%40Mazrigos&amp;sort=time' title='View my posts' rel='np' class='icon-posts'>
  148. </a>
  149. <a href='/wow/en/vault/character/auction/horde/' title='View auctions' rel='np' class='icon-auctions'>
  150. </a>
  151. <a href='/wow/en/vault/character/event' title='View events' rel='np' class='icon-events link-last'>
  152. </a>
  153. </div>
  154. </div>
  155. <div class='character-list'>
  156. <div class='primary chars-pane'>
  157. <div class='char-wrapper'>
  158.  
  159. <?php
  160.  
  161.     // A megadott fiókon lévő összes karakter lekérdezése
  162.                                     mysql_select_db( "$charsdb" );
  163.                                 $karakterlekerdezes = mysql_query("select * from characters WHERE account=$_SESSION[id] ORDER BY name");
  164.                                
  165.                                
  166.  
  167.                                 while($karakter = mysql_fetch_array($karakterlekerdezes))
  168.                                 {
  169.  
  170.                         $karakterrace = $karakter['race'];
  171.                         $karakterclass = $karakter['class'];
  172.                        
  173.    
  174.                        
  175.                        
  176.                         ?>
  177.  
  178.  
  179.  
  180.  
  181.                                     <!-- class='char pinned' vany pipa <- vagy -> class='char' nincs pipa -->
  182.                                     <a href="<?php
  183.                                     /* KARAKTERVALTAS */
  184.                                     //include('karaktervaltas.php');
  185.                                     /* KARAKTERVALTAS */
  186.                                     ?>
  187.                                    
  188.                                     "
  189.                                     <?php
  190.                                     if($karakterlekerdezes_valasztott_tomb['karakternev'] != $karakter['name']){
  191.                                     echo "class='char'";
  192.                                     }else{
  193.                                     echo "class='char pinned'";
  194.                                     }
  195.                                     ?>
  196.                                    
  197.                                      rel="np" onclick="Core.karvaltas('<?php echo $karakter['name'];?>')">
  198.  
  199. <span class='pin'></span>
  200. <span class='name'>
  201. <?php echo $karakter['name'];?>
  202. </span>
  203. <span <?php echo " class='class wow-class-" . $karakter['class'] . "'";?>>
  204. <?php echo $karakter['level'];?>
  205.  <?php echo $karakter_race_tomb[$karakterrace];?>
  206.  <?php echo $karakter_class_tomb[$karakterclass]; ?>
  207.  </span>
  208. <span class='realm up'>
  209. <?php echo strtolower($_SESSION['realmnev']);?>
  210. </span>
  211. </a>
  212.  
  213.  
  214. <?php
  215.     }
  216.  
  217. ?>
  218.  
  219. </div>
  220. </div>
  221. </div> </div>
  222. </div>
  223. </div>
  224. </div>
  225. </div> 
  226.  
  227. <?php
  228. }else{
  229. ?>
  230. <div class='user-plate'>
  231. <a id='user-plate' class='card-character plate-portrait ajax-update' rel='np' href='/wow/en/character/mazrigos/Bravandvia/'>
  232. <span class='card-portrait' style='background-image:url(https://eu.battle.net/static-render/eu/mazrigos/81/72230993-avatar.jpg?alt=/wow/static/images/2d/avatar/2-0.jpg)'></span>
  233. </a>
  234. <div class='meta-wrapper meta-horde ajax-update'>
  235. <div class='meta'>
  236. <div class='player-name'><?php echo strtolower($_SESSION['username']); ?></div>
  237. <div class='character'>
  238. <a class='character-name context-link text-small' rel='np'>
  239. Még nincs karaktered.
  240. </a>
  241. </div>
  242. </div>
  243. </div>
  244. </div>
  245.  
  246. <?php
  247. }
  248. ?>
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!