0)
{
$query = "select site_id, site_links from sites where site_id=$site_id";
}
else
{
$query = "select site_id, site_links from sites";
}
$result = mysql_query($query);
if (!$result) {
die ('Invalid query: ' . mysql_error());
}
while ($tmp = mysql_fetch_row($result))
{
$cur_site = $tmp[0];
$cur_links = $tmp[1];
$outf = fopen("/home/saseo/www/links/codes/links".$cur_site.".txt", 'w');
if ($cur_links >0)
{
$query2 = "select link_code from link where link_siteid=$cur_site and link_start<=NOW() and (link_end>=NOW() or link_end=0)";
$result2 = mysql_query($query2);
if (!$result2) {
die ('Invalid query: ' . mysql_error());
}
while ($tmp = mysql_fetch_row($result2))
{
fwrite ($outf, stripslashes($tmp[0]) . "
\n");
}
}
fclose($outf);
}
$query = "select site_id, link_code from user_links";
$result = mysql_query($query);
while ($tmp = mysql_fetch_row($result))
{
$cur_site = $tmp[0];
$cur_link = stripslashes($tmp[1]);
$outf = fopen("/home/saseo/www/links/codes/links".$cur_site.".txt", 'a');
fwrite($outf, $cur_link."
\n");
fclose($outf);
}
mysql_close($my_connect);
}
?>