Top 10 jucatori

Închis
Avatar utilizator
R3ktMeight
Nivel 1

Nivel 1
Mesaje: 112
Membru din: 14 Mai 2016, 11:10
Regat: Shinsoo
Aprecieri: 8  
Mulţumiri: 0
Medalii

Am modificat scriptul de top 10 jucatori (de la darkdev) ca sa i ordoneze dupa timp si acum arata mai mult de 10 jucatori


Cod: Selectaţi tot

<table border="0" align="center" cellpadding="0" cellspacing="0" width="90%" >

   <tr>

    <td colspan="3" height="5"></td>

    </tr>

  <tr class="top">

    <td>#</td>

    <td>NUME</td>

    <td align="center">Minute</td>

  </tr><?php 

 	$query = "SELECT * FROM player.player  WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[Own]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[SGM]%'  AND name NOT LIKE '[M2]%'   AND name NOT LIKE '[thc]%'   AND name NOT LIKE '[MoD]%'   AND name NOT LIKE '[TGM]%' AND name NOT LIKE '[SGM]%' ORDER BY playtime desc";

      $i = "0" ;

	  

	  

 $doQuery = mysql_query($query) or die(mysql_error());

while($getPlayers = mysql_fetch_object($doQuery))

   {

   $i = $i + 1 ;

  

   $cache_content .= '

 	<tr class="top">

    <td width="23">'.$i.'</td>

    <td width="141">'.$getPlayers->name.'</td>

    <td width="53" align="center">'.$getPlayers->playtime.'</td>

  	</tr>

	';



}



if ( !file_exists('see/player_cache.txt'))

 {

$q1_cache = fopen('see/player_cache.txt', 'w');

fwrite($q1_cache, $cache_content);

fclose($q1_cache);

 }

 else

 {

	 if (filemtime('see/player_cache.txt') < (time() - 18000))

	 {

		unlink('see/player_cache.txt');

		$q1_cache = fopen('see/player_cache.txt', 'w');

		fwrite($q1_cache, $cache_content);

		fclose($q1_cache);

	 }

	 else

	 {

		 $q1_cache = fopen('see/player_cache.txt', 'r');

		 $cache_content = fread($q1_cache, filesize('see/player_cache.txt') + 1);

		 fclose($q1_cache);

		 echo $cache_content;

	 }

 }

	





				?>  <tr>

    <td colspan="3" height="5"></td>

    </tr></table>

	
Avatar utilizator
Bgd
Nivel 2

Nivel 2
Mesaje: 269
Membru din: 13 Sep 2013, 11:52
Aprecieri: 170  
Mulţumiri: 160  
Discord: Copiază ID
Medalii

Uite aici (sa imi zici daca ceva nu merge ok ca sa ma uit dupa):

Cod: Selectaţi tot

<table border="0" align="center" cellpadding="0" cellspacing="0" width="90%" >

   <tr>

    <td colspan="3" height="5"></td>

    </tr>

  <tr class="top">

    <td>#</td>

    <td>NUME</td>

    <td align="center">Minute</td>

  </tr><?php 

    $query = "SELECT * FROM player.player  WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[Own]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[SGM]%'  AND name NOT LIKE '[M2]%'   AND name NOT LIKE '[thc]%'   AND name NOT LIKE '[MoD]%'   AND name NOT LIKE '[TGM]%' AND name NOT LIKE '[SGM]%' ORDER BY playtime desc limit 0,10";

      $i = "0" ;

     

     

 $doQuery = mysql_query($query) or die(mysql_error());

while($getPlayers = mysql_fetch_object($doQuery))

   {

   $i = $i + 1 ;

  

   $cache_content .= '

    <tr class="top">

    <td width="23">'.$i.'</td>

    <td width="141">'.$getPlayers->name.'</td>

    <td width="53" align="center">'.$getPlayers->playtime.'</td>

     </tr>

   ';



}



if ( !file_exists('see/player_cache.txt'))

 {

$q1_cache = fopen('see/player_cache.txt', 'w');

fwrite($q1_cache, $cache_content);

fclose($q1_cache);

 }

 else

 {

    if (filemtime('see/player_cache.txt') < (time() - 18000))

    {

      unlink('see/player_cache.txt');

      $q1_cache = fopen('see/player_cache.txt', 'w');

      fwrite($q1_cache, $cache_content);

      fclose($q1_cache);

    }

    else

    {

       $q1_cache = fopen('see/player_cache.txt', 'r');

       $cache_content = fread($q1_cache, filesize('see/player_cache.txt') + 1);

       fclose($q1_cache);

       echo $cache_content;

    }

 }

   





            ?>  <tr>

    <td colspan="3" height="5"></td>

    </tr></table>

   
Avatar utilizator
Yahiko
Membru Club

Membru Club
Mesaje: 3865
Membru din: 25 Mai 2015, 18:31
Aprecieri: 0
Mulţumiri: 4857  
Discord: Copiază ID
 Contact:
Medalii

Subiect inactiv de mai bine de 3 zile. Arhivat.
*Contact Discord: Yahiko#2936
*Doar SMS: 0749592613
*Grup discord: Click
Cu stimă,
Yahiko.

GL & HF
Afișează semnătura
Închis
Răspunsuri
2
Vizualizări
92
Răspunsuri
1
Vizualizări
258
Răspunsuri
1
Vizualizări
358
Răspunsuri
2
Vizualizări
386

Înapoi la “Arhivă”

  • Informaţie
  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 4 vizitatori