foreach ($rows as $row) {
$pool_id = $row['pool_id'];
$network_name = $row['network_name'];
$channel_name = $row['channel_name'];
$nick_name = $row['nick_name'];
$message = $row['message'];
// remove this item from the pool now
// if anything goes wrong trying to merge it we won't keep trying every pool update
clean_pool($dbh, $pool_id);
$urls = get_urls($message);
if (count($urls) == 0) {
exit;
}
echo "pool_id={$pool_id}; ";
echo 'urls=' . count($urls) . ' ';
$network_id = get_network_id($dbh, $cache, $network_name);
if (!$network_id) {
exit;
}
echo "{$network_name}({$network_id}) ";
$channel_id = get_channel_id($dbh, $cache, $network_id, $channel_name);
if (!$channel_id) {
exit;
}
echo "{$channel_name}({$channel_id}) ";
$nick_id = get_nick_id($dbh, $cache, $network_id, $nick_name);
if (!$nick_id) {
exit;
}
echo "{$nick_name}({$nick_id}) ";
echo "\n";
function uninstall_network($networkid)
{
if (!check_network_installed($networkid)) {
global $errormessage;
$errormessage = 'This network does not seem to be installed. Unable to remove network.';
return false;
}
global $maindb;
$network_numeric_id = get_network_id($networkid);
mysql_query("DELETE from md_networks where network_identifier='{$networkid}'", $maindb);
/* Delete Network Campaigns*/
$campred = mysql_query("SELECT * FROM md_campaigns WHERE campaign_type='network' AND campaign_networkid='" . $network_numeric_id . "'", $maindb);
while ($camp_det = mysql_fetch_array($campred)) {
delete_campaign($camp_det['campaign_id']);
}
/*TODO: Delete Network Allocations*/
mysql_query("UPDATE md_zones set backfill_alt_1='' where backfill_alt_1='" . $network_numeric_id . "'", $maindb);
mysql_query("UPDATE md_zones set backfill_alt_2='' where backfill_alt_2='" . $network_numeric_id . "'", $maindb);
mysql_query("UPDATE md_zones set backfill_alt_3='' where backfill_alt_3='" . $network_numeric_id . "'", $maindb);
global $successmessage;
$successmessage = 'Network successfully removed.';
return true;
return true;
}
