Secret Experience

Setokaiba · 09-08-2013, 06:10 PM

Lista de heróis do mês atual.

Você visualizará dessa forma:

[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

Código: [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

<html>
  <head>
    <title>Heroes</title>
    <style>
    body {
      margin: 0px;
      padding: 0px;
      background: #2E0601;
      color: #ffffff;
      font-family: tahoma, verdana;
      font-size: 8pt;        
    }
    
    td {
      font-family: tahoma, verdana;
      font-size: 8pt;
      margin: 0;
      color: #ffffff;
    }
    
    b {
      font-weight: bold;
      color: #84c3f8;
    }
    
    A {
      color: #ffe155;
      text-decoration: none;
    }
    
    A:link { color: #ffe155; }
    A:visited { color:#e8a400; }
    A:active { color: #ffff99; }
    A:hover { color: #ffff99; text-decoration: underline; }
    
    .tabletitle {
      color: #FFFFFF;
      background-color: #4B150E;
      border-width: 2; border-style: solid;
      border-color: #000000;
    }
    </style>
  </head>
  <body>
    <center>
    <table class='info'>
      <tr class='info'><td align='center'><b>Current Heros</b></td></tr>
    </table>
<? 

$class_list=array(
    0=>"Fighter",1=>"Warrior",2=>"Gladiator",3=>"Warlord",4=>"Knight",5=>"Paladin",6=>"Dark Avenger",7=>"Rogue",
    8=>"Treasure Hunter",9=>"Hawkeye",10=>"Mage",11=>"Wizard",12=>"Sorcerer",13=>"Necromancer",14=>"Warlock",15=>"Cleric",
    16=>"Bishop",17=>"Prophet",18=>"Elven Fighter",19=>"Elven Knight",20=>"Temple Knight",21=>"Swordsinger",22=>"Elven Scout",23=>"Plains Walker",
    24=>"Silver Ranger",25=>"Elven Mage",26=>" Elven Wizard",27=>" Spellsinger",28=>"Elemental Summoner ",29=>"Oracle",
        30=>"Elder",31=>"Dark Fighter",32=>"Palus Knightr",33=>"Shillien Knight",34=>"Bladedancer",35=>"Assasin",36=>"Abyss Walker",
        37=>"Phantom Ranger",38=>"Dark Mage",39=>"Dark Wizard",40=>"Spellhowler",41=>"Phantom Summoner",42=>"Shillien Oracle",43=>"Shilien Elder",
    44=>"Orc Fighter",45=>"Orc Raider",46=>"Destroyer",47=>"Orc Monk",48=>"Tyrant",49=>"Orc Mage",50=>"Orc Shaman",51=>"Overlord",
    52=>"Warcryer",53=>"Dwarven Fighter",54=>"Scavenger",55=>"Bounty Hunter",56=>"Artisan", 57=> "Warsmith",
        88=>"Duelist",89=>"Dreadnought",90=>"Phoenix Knight",91=>"Hell Knight",92=>"Sagittarius",93=>"Adventurer",94=>"Archmage",95=>"Soultaker",
        96=>"Arcana Lord",97=>"Cardinal",98=>"Hierophant",99=>"Evas Templar",100=>"Sword Muse",101=>"Wind Rider",102=>"Moonlight Sentinel",
        103=>"Mystic Muse",104=>"Elemental Master",105=>"Evas Saint",106=>"Shillien Templar",107=>"Spectral Dancer",108=>"Ghost Hunter",
        109=>"Ghost Sentinel",110=>"Storm Screamer",111=>"Spectral Master",112=>"Shillien Saint",113=>"Titan",114=>"Grand Khavatari",
        115=>"Dominator",116=>"Doomcryer",117=>"Fortune Seeker",118=>"Maestro",
        123=>"Male Soldier",124=>"Female Soldier",125=>"Trooper",126=>"Warder",127=>"Berserker",
        128=>"Male Soulbreaker",129=>"Female Soulbreaker",130=>"Arbalester",131=>"Doombringer",
        132=>"Male Soulhound",133=>"Female Soulhound",134=>"Trickster",135=>"Inspector",136=>"Judicator"
);



// db config
$CONFIG['worlddbname'] = "lin2world";           // Database Name
$CONFIG['dbaddress'] = "";        // MSSQL IP
$CONFIG['dbuser'] = "";                       // MSSQL User
$CONFIG['dbpass'] = "";     // MSSQL Password

// db connection!
$dbconnect = @mssql_connect ($CONFIG['dbaddress'], $CONFIG['dbuser'], $CONFIG['dbpass']); 
@mssql_select_db ($CONFIG['worlddbname'], $dbconnect) or die (mysql_error()); 

function do_query($query) {
  $arr = array();
  $result = mssql_query($query) or die("Error SQL: ".mssql_get_last_message());
  for ($x=0; $arr[$x] = mssql_fetch_assoc($result); $x++);
  unset($arr[count($arr)-1]);
  return $arr;
}

$query = "
USE lin2world
SELECT char_name,subjob0_class,pledge.name as 'pname',alliance.name as 'aname',pledge.crest_id as 'pcrest',alliance.crest_id as 'acrest',win_count,race
FROM user_data
LEFT JOIN pledge ON pledge.pledge_id = user_data.pledge_id
INNER JOIN user_nobless ON user_nobless.char_id = user_data.char_id
LEFT JOIN alliance ON alliance.id = pledge.alliance_id
WHERE hero_type > 0
AND win_count > 0
AND builder = 0 
AND account_id > 0
ORDER BY subjob0_class
";

$heroes_actuales = do_query($query);

if (sizeof($heroes_actuales) == 0) echo "No heros found.";
else {
  echo "
  <table class='info'><tr bgcolor='333333' align='center'>\n 
  <tr bgcolor='333333' align='center'>
  <td width='24%' align='left'><b>Name</b></td>
  <td width='24%' align='left'><b>Class</b></td>
  <td width='24%' align='left'><b>Pledge</b></td>
  <td width='24%' align='left'><b>Alliance</b></td>
  <td width='4%' align='left'><b>#</b></td>
  </tr>
  ";
  
  $i=0;
  foreach($heroes_actuales as $hero) {
    if (!($i%2)) echo "<tr bgcolor='000000' align='center'>";
    else echo "<tr bgcolor='333333' align='center'>";
    
    echo "
    <td align='left'>".$hero['char_name']."</td>
    <td align='left'>".$class_list[$hero['subjob0_class']]."</td>
    <td align='left'>
    ";
    if ($hero['pcrest'] != 0) echo "<img height='12' src='crest.php?id=".$hero['pcrest']."'> ";
    echo $hero['pname']."</td><td align='left'>";
    if ($hero['acrest'] != 0) echo "<img height='12' src='crest.php?id=".$hero['acrest']."'> ";
    echo $hero['aname']."</td><td align='left'>".$hero['win_count']."</td></tr>";
      
    $i++;
  }
  
  echo "</table>";
}

?>

  <body>
</html>

Senha Para Descompactar:

Senha: www.secretexperience.net

Este script faz necessidade do uso deste outro:
[Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

Desenvolvido por: FidoW