" . $time . " ORDER BY time DESC LIMIT 0,30"; $result = mysql_query($query, $userdb); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { print " \n"; print " " . $row['id'] . "\n"; print " " . $row['time'] . "\n"; print " " . str_replace("&", "&", $row['title']) . "\n"; print " " . htmlspecialchars($row['text']) . "\n"; print " " . $row['changesize'] . "\n"; print " " . $row['user'] . "\n"; print " " . number_format($row['spam'] * 100, 1) . "\n"; // Vandale? $result2 = mysql_query("SELECT count(*) FROM $vandal_table WHERE ip LIKE '" . $row['user'] . "'", $userdb); $row2 = mysql_fetch_array($result2, MYSQL_NUM); mysql_free_result($result2); if ($row2[0]>0) { print " \n"; } // Neuer Artikel? if (strpos($row['flag'], "N") !== false) print " \n"; print " \n"; } // Alte Aenderungen if ($time > 0) { $query = "SELECT * FROM $table_old WHERE time>" . $time . " LIMIT 0,50"; $result = mysql_query($query, $userdb); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { print " \n"; print " " . $row['id'] . "\n"; print " \n"; } } // Neue Vandalen if ($time > 0) { $query = "SELECT * FROM $vandal_table WHERE time>" . $time . " LIMIT 0,20"; $result = mysql_query($query, $userdb); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { print " \n"; print " " . $row['ip'] . "\n"; print " \n"; } } // Alte Vandalen if ($time > 0) { $query = "SELECT * FROM $vandal_table_old WHERE time>" . $time . " LIMIT 0,20"; $result = mysql_query($query, $userdb); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { print " \n"; print " " . $row['ip'] . "\n"; print " \n"; } } // End SOAP output soap_end(); // ========================================================================== // // SOAP FUNCTIONS // ========================================================================== // function soap_start() { header('Content-type: text/xml'); header("Cache-Control: no-cache, must-revalidate"); header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); print " "; } function soap_end() { print " "; } ?>