[SCRIPT] Список героев в текущем месяце

Тема в разделе "Веб скрипты (WEB)", создана пользователем root, 30 сен 2014.

  1. root

    root Administrator Команда форума Administrator Moderator Developers Team

    Регистрация:
    23 авг 2014
    Сообщения:
    254
    Симпатии:
    58
    Баллы:
    11
    Код:
    <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>