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