$result2 = select($query);
if ( mysql_num_rows($result2) > 0 ) {
$row2 = mysql_fetch_row($result2);
if ( empty($row2[0]) or $row2[0] == 'NULL' ) {
$query = 'UPDATE hash SET rss="'.$rss_hash.'" WHERE user_item_id="'.$user_item_id.'";';
$success_update = select($query);
$success = $success and $success_update;
}
} else {
$query = 'INSERT INTO hash SET user_item_id="'.$user_item_id.'", rss="'.$rss_hash.'";';
$success_insert = insert($query);
$success = $success and $success_insert;
}
}
unset($extra_array['RSS_HASH_ARRAY']);
$extra_string = Array2XML($extra_array);
$query = 'UPDATE room SET extras="'.addslashes($extra_string).'" WHERE item_id="'.$item_id.'";';
$success_room = select($query);
$success = $success and $success_room;
update_progress_bar($count);
}
} else {
echo('<br/>nothing to do');
}
// end of execution time
$time_end = getmicrotime();
$time = round($time_end - $time_start,3);
echo "<br/>Execution time: ".mb_sprintf("%02d:%02d:%02d", (int)($time/3600), (int)(fmod($time,3600)/60), (int)fmod(fmod($time,3600), 60))."\n";
function echoXML($xml) {
XMLheader();
if (is_array($xml)) {
echo Array2XML($xml);
} else {
echo $xml;
}
}
function Array2XML($data, $name = null, $elements = array(), $indent = 1)
{
if (!is_array($data)) {
return;
}
$output = array();
$ind = str_repeat("\t", $indent);
foreach ($data as $k => $data) {
if (is_numeric($k) && $name != null) {
if (is_array($data) && isset($data[0]) && ($data[0] = 'call')) {
$output[] = '<' . $name . '><![CDATA[' . call_user_func_array($data[1], $data[2]) . ']]></' . $name . '>';
} else {
$output[] = '<' . $name . '>';
$output[] = ' ' . Array2XML($data, null, $elements, $indent++);
$output[] = '</' . $name . '>';
}
} elseif (is_numeric($k)) {
fatal_lang_error('arcade_internal_error', false);
} else {
if (!empty($elements) && !(in_array($k, $elements) && !is_array($data) || isset($elements[$k]) && is_array($data))) {
continue;
}
if (is_array($data)) {
$output[] = '<' . $k . '>';
$output[] = ' ' . Array2XML($data, null, $elements[$k], $indent++);
$output[] = '</' . $k . '>';
} else {
if ($data === false) {
$data = 0;
} elseif ($data === true) {
$data = 1;
}
if (!is_numeric($data)) {
$output[] = '<' . $k . '><![CDATA[' . $data . ']]></' . $k . '>';
} else {
$output[] = '<' . $k . '>' . $data . '</' . $k . '>';
}
}
}
}
return implode("\n", $output);
}
