<?php  
    require_once ('includes/config.php');  
                $sMySql = mysql_connect($host, $user, $passw) or die("Невозможно подключиться к базе данных : " . mysql_error());  
                mysql_query('SET  character_set_database  =  cp1251');    
                mysql_query('SET  NAMES  cp1251');         
       $content = mysql_query ("select sp.SpellName_ru_ru, id  
                      from armory.armory_spell sp  
                      join mangos.spell_disabled sd ON sp.id = sd.entry  
                      where sd.active = 1 or sd.ischeat_spell = 1");  
              // строим таблицу  
          $szTable = '<table border="1" align="center">';  
       $szTable .= '<tr><td align="center">Название</td></tr>';    
          
    while ($row = mysql_fetch_array($content))                             
                     {    
          $SpellName_ru_ru = $row['SpellName_ru_ru'];  
          $Spellid = $row['id'];  
             
       $szTable .= '<tr><td align="center"><a href = "http://www.wowhead.com/?spell='.$Spellid.'" target = "_blank">'.$SpellName_ru_ru.'</a></td>';  
                     }  
       $szTable .= '</table>';  
          $szTable .= '<br>';  
       $szTable .= '<br>';       
          $szTable .= '<div align="center"><font size="1">Список запрещённых заклинаний обновляется раз в 24 часа</font></div>';       
          
    $handler = fopen("spells.txt", "w+");  
       fwrite($handler, $szTable);  
       fclose($handler);  
    mysql_close($sMySql);       
  ?>