<?php
$sql_host="localhost";
$sql_id="tek902_tb";
$sql_pass="rewaser92";
$sql_db="tek902_tb";

	$link = @mysql_connect ("$sql_host", "$sql_id", "$sql_pass") or die ("Нема конекта");
	$link2 = @mysql_select_db("$sql_db") or die ("aaa");
	
mysql_query("SET NAMES 'utf8'");

$q =  explode(":", date('d:m:o'));
/** 
* Формируем заголовок новости
*/

$titleNews = 'Турнир  тыкв - окончание';
$top_q  = mysql_query("SELECT  `id` FROM `clans` ORDER BY `pumpkin` DESC LIMIT 30");
 while($top = mysql_fetch_assoc($top_q)){
	$alPos++;
$name_top = mysql_fetch_assoc(mysql_query("SELECT `id`,`name`, `pumpkin` FROM `clans` WHERE `id`='".$top['id']."' LIMIT 1"));

$topes_us.= '<div>'.$alPos.'. <a href=/clan?id='.$name_top['id'].'/> '.$name_top['name'].' </a> <img src=/images/hellowen/pumpkin.png width=16 height=16 alt=> '.$name_top['pumpkin'].' </div>';

	


 }

mysql_query("UPDATE `users`  SET `news_read`='1' WHERE `news_read`='0'");
mysql_query('INSERT INTO `forum_topic` (`sub`,
                                        `name`,
										`stick`,
                                        `user`,
                                        `text`,
                                        `time`) VALUES ("13",
                                                             "'.$titleNews.'",
                                                             "1",
                                                       "1",
                                                             "'.$topes_us.'",
                                                           "'.time().'")');

?>