$sr = dirname(dirname(__FILE__));
include($sr . '/gallery/config/config.inc.php');
include($sr . '/ads/config/config.inc.php');
@mysql_connect(G_HOST, G_DBUSER, G_DBPASSWD);
@mysql_select_db(G_DBNAME);
@mysql_query("SET NAMES cp1251");
$res4 = mysql_query("SELECT count(*) FROM `gallery_photo` WHERE accept='1'");
$row4 = mysql_fetch_array($res4);
mysql_free_result($res4);
if ($row4[0])
{
while (!$row2)
{
$res2 = mysql_query("SELECT id, user_id, album_id, theme_id, name, type FROM `gallery_photo` WHERE accept='1' LIMIT " . rand(0, $row4[0]) . ", 1");
$row2 = mysql_fetch_array($res2);
mysql_free_result($res2);
}
$ref = $row2['user_id'] . ":" . $row2['album_id'] . ":";
@mysql_connect(ADS_HOST, ADS_DBUSER, ADS_DBPASSWD);
@mysql_select_db(ADS_DBNAME);
@mysql_query("SET NAMES cp1251");
$res1 = mysql_query("SELECT login, name FROM `portal_users` WHERE id='" . $row2['user_id'] . "'");
$row1 = mysql_fetch_array($res1);
mysql_free_result($res1);
@mysql_connect(G_HOST, G_DBUSER, G_DBPASSWD);
@mysql_select_db(G_DBNAME);
@mysql_query("SET NAMES cp1251");
$res3 = mysql_query("SELECT name FROM `gallery_theme` WHERE id='" . $row2['theme_id'] . "'");
$row3 = mysql_fetch_array($res3);
mysql_free_result($res3);
print "
";
}
?>