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; }