<?php
$tpl_link = mysql_connect("адресмускула", "имябазы", "пароль") or die("Could not connect: " . mysql_error());
//print ("Connected successfully");
mysql_select_db("magneto", $tpl_link) or die ("Database not found.");
mysql_query("SET CHARACTER SET 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
$tpl_offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `tpl_offset` FROM `tbl_base` ");
$tpl_offset_row = mysql_fetch_object( $tpl_offset_result );
$tpl_offset = $tpl_offset_row->tpl_offset;
$tpl_result = mysql_query( " SELECT NAZV, CODE, RAZMER, POSTER, VOTES, KAT, (SELECT NAZV FROM `tbl_kat` WHERE `tbl_base`.`KAT` = `tbl_kat`.`CODE`) AS KAT_STR FROM `tbl_base` LIMIT $tpl_offset, 1 " );
$tpl_row = mysql_fetch_assoc($tpl_result);
echo "<a href=\"http://dc.under-side.ru/topic.php?type=show&code=".$tpl_row["CODE"]."\" class=\"linkm1\"><b>".$tpl_row["NAZV"]."</b></a><br>
";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"5\">
";
echo "<tbody>
";
echo " <tr>
";
echo " <td align=\"center\">
";
echo " <a href=\"http://dc.under-side.ru/topic.php?type=show&code=".$tpl_row["CODE"]."\" title=\"".$tpl_row["NAZV"]."\">
";
echo " <img src=\"http://dc.under-side.ru/main/eskiz/".$tpl_row["POSTER"]."\" alt=\"Перейти на раздачу : ".$tpl_row["NAZV"]."\" border=\"0\" height=\"200\" width=\"100%\">
";
echo " </a>
";
echo " </td>
";
echo " </tr>
";
echo " <tr>
";
echo " <td align=\"center\">
";
echo " <a href=\"http://dc.under-side.ru/kat.php?type=showkat&type2=".$tpl_row["KAT"]."\">".$tpl_row["KAT_STR"]."</a><br>
";
echo " Размер: ".$tpl_row["RAZMER"]." МБ
";
echo " </td>
";
echo " </tr>";
echo "</tbody>
";
echo "</table>
";
mysql_close($tpl_link);
?>
