printf("<p><strong>Invalid query string, which caused the SQL error:</strong></p>");
echo "<p> $sql_query </p>";
exit;
}
}
}
*/
require_once "{$include_dir}/domain_whois.php";
$whois_res = '';
$whois = '';
$list = "1";
// get list
$ext = "0";
// basic suffixes
$whois = new whois();
//new class
$whois_res0 = $whois->lookup($url, $ext, $list);
$ext = "1";
// extended list
$whois_res1 = $whois->lookup($url, $ext, $list);
unset($whois);
$whois_basic = preg_replace("/\\s+/", "", $whois_res0['answer']);
$whois_full = preg_replace("/\\s+/", "", $whois_res1['answer']);
echo "<div class='submenu cntr'>| Configuration Settings |</div>\n <div class='headline cntr'>Settings for Sphider-plus version {$plus_nr} based on original Sphider v. {$version_nr}</div>\n <br />\n ";
if (!$db_con || !$success || !$tables) {
echo "<center><span class='red sml'> MySQL database is not avaliable! <br />\n First define all required information in section 'Database' </span>\n </center><br />\n ";
}
if ($db_con && $success) {
$result = '';
$sql_query = "SELECT sum(click_counter) from " . $mysql_table_prefix . "links";
function approve_newsites()
{
global $db_con, $mysql_table_prefix, $show_categories, $debug, $dba_act, $add_auth;
global $sites_per_page, $sug_start, $whois_admin, $whois_ext, $include_dir;
// do we have categories defined by our Admin?
$category = '';
$sql_query = "SELECT * from " . $mysql_table_prefix . "categories";
$result = $db_con->query($sql_query);
if (!($rows = $result->num_rows)) {
$category = -1;
}
$sql_query = "SELECT * FROM `" . $mysql_table_prefix . "addurl` LIMIT 0 , 30";
$result = $db_con->query($sql_query);
if ($debug && $db_con->errno) {
$err_row = __LINE__ - 2;
printf("<p><span class='red'> MySQL failure: %s \n<br /></span></p>", $db_con->error);
if (__FUNCTION__) {
printf("<p><span class='red'> Found in script: " . __FILE__ . " row: {$err_row} in function(): " . __FUNCTION__ . " <br /></span></p>");
} else {
printf("<p><span class='red'> Found in script: " . __FILE__ . " row: {$err_row} <br /></span></p>");
}
printf("<p><span class='red'> Script execution aborted. <br /></span>");
printf("<p><strong>Invalid query string, which caused the SQL error:</strong></p>");
echo "<p> {$sql_query} </p>";
exit;
}
$count = 1;
if ($result->num_rows) {
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
$all[] = $row;
}
$links = '0';
$start = $sug_start;
$num_rows = $result->num_rows;
$pages = ceil($num_rows / $sites_per_page);
// Calculate count of required pages
if ($start > $pages) {
$start = $pages;
}
if ($start < 1) {
$start = '1';
}
// As $start is not yet well defined, this is required for the first result page
if ($start == '1') {
$from = '0';
// Also for first page in order not to multipy with 0
} else {
$from = ($start - 1) * $sites_per_page;
// First $num_row of actual page
}
$fromm = $from + 1;
$to = $num_rows;
// Last $num_row of actual page
$rest = $num_rows - $start;
if ($num_rows > $sites_per_page) {
// Display more then one page?
$rest = $num_rows - $from;
$to = $from + $rest;
// $to for last page
if ($rest > $sites_per_page) {
$to = $from + $sites_per_page;
}
// Calculate $num_row of actual page
}
// display result header
echo "\n <div class='submenu cntr'>| Sites for Approval |</div>\n <div class='tblhead'>\n <br /><br />\n <table width='97%'>\n <tr>\n <td class='tblhead sml'>Displaying suggested URLs " . $fromm . " - " . $to . " from " . $num_rows . "</td>\n </tr>\n </table>";
for ($i = $from; $i < $to; $i++) {
// prepare result for this new URL
$n = $i + 1;
$url = $all[$i]['url'];
$title = $all[$i]['title'];
$description = $all[$i]['description'];
$created = $all[$i]['created'];
$account = $all[$i]['account'];
$authent = $all[$i]['authent'];
if ($whois_admin) {
require_once "{$include_dir}/domain_whois.php";
// load the WHOIS class
$list = "";
$whois = new whois();
//new class
$whois_res = $whois->lookup($url, $whois_ext, $list);
unset($whois);
$whois_server = $whois_res['whoisserver'];
$whois_result = $whois_res['result'];
$whois_answer = $whois_res['answer'];
}
echo "\n <br />\n Site {$n} awaiting approval:<br /><br />\n <form action='admin.php' method='post'><input type='hidden' name='f' value='29' />\n <table width='80%'>\n <tr class='y3 odrow'>\n <td class='cntr' ></br>User suggestion:</td>\n <td> </td>\n </tr>\n <tr class='y3 odrow'>\n <td>\n URL:\n </td>\n <td class='left' ><input size='50' type='text' name=\"url\" value=\"{$url}\" />\n \n <a target=\"_blank\" href=\"{$url}\">visit</a>\n </td>\n </tr>\n <tr class='y3 odrow'>\n <td>Title:\n </td>\n <td class='left' ><textarea rows='1' name='title' cols='38'>{$title}</textarea>\n </td>\n </tr>\n <tr class='odrow'>\n <td>Description:\n </td>\n <td class='left' ><textarea rows='5' name='short_desc' cols='38'>{$description}</textarea>\n </td>\n </tr>";
if ($show_categories == '1' && $category != -1) {
echo "\n <tr class='y3 odrow'>\n <td>\n Category:\n </td>\n <td class='left' ><select name=\"cat\">\n ";
$category_id = $all[$i]['category_id'];
list_catsform(0, 0, "white", "", $category_id);
echo "\n </select>\n </td>\n </tr>\n ";
}
echo " <tr class='y3 odrow'>\n <td>suggested:\n </td>\n <td class='left' ><input size='50' type='text' name=\"created\" value=\"{$created}\" />\n </td>\n </tr>\n <tr class='odrow'>\n <td>by:\n </td>\n <td class='left' ><input size='50' type='text' name=\"dispatcher\" value=\"{$account}\" />\n </td>\n </tr>";
if ($add_auth == '1') {
echo "<tr class='y3 warn'>\n <td>Authentication code:\n </td>\n <td class='left' ><input size='50' type='text' name=\"authent\" value=\"{$authent}\" />\n Admin input required</td>\n </tr>";
}
if ($whois_admin) {
echo "<tr class='y3 odrow'>\n <td class='cntr' ></br>WHOIS report:</td>\n <td> </td>\n </tr>\n <tr class='y3 odrow'>\n <td>Result:\n </td>\n <td class='left' ><input size='50' type='text' name=\"whois_result\" value=\"{$whois_result}\" />\n </td>\n </tr>\n <tr class='y3 odrow'>\n <td>Server:\n </td>\n <td class='left' ><input size='50' type='text' name=\"whois_server\" value=\"{$whois_server}\" />\n </td>\n </tr>\n <tr class='odrow'>\n <td>Server answer:\n </td>\n <td class='left' ><textarea rows='5' name='whois_answer' cols='38'>{$whois_answer}</textarea>\n </td>\n </tr>";
}
echo "\n </table>\n <table width='80%'>\n <tr class='y3 cntr odrow sml'>\n <td>\n <input type='submit' name='approve' value='Approve' /> \n <input type='submit' name='delete' value='Reject' /> \n <input type='submit' name=\"bann\" value=\"Ban !\" />\n <input type='hidden' name=\"domain\" value=\"{$url}\" />\n </td>\n </tr>\n </table>\n </form>\n <br />";
}
}
echo "\n </div>";
if ($pages > 1) {
// If we have more than 1 result-page
echo "\n <div class='submenu cntr y5'>\n Result page: {$start} from {$pages}\n <br /><br />\n Page selection: \n ";
if ($start > 1) {
// Display 'First'
echo "<a href='admin.php?f=28&sug_start=1'>First</a> \n ";
if ($start > 5) {
// Display '-5'
$minus = $start - 5;
echo "<a href='admin.php?f=28&sug_start={$minus}'>- 5</a> \n ";
}
}
if ($start > 1) {
// Display 'Previous'
$prev = $start - 1;
echo "<a href='admin.php?f=28&sug_start={$prev}'>Previous</a> \n ";
}
if ($rest >= $sites_per_page) {
// Display 'Next'
$next = $start + 1;
echo "<a href='admin.php?f=28&sug_start={$next}'>Next</a> \n ";
if ($pages - $start > 5) {
// Display '+5'
$plus = $start + 5;
echo "<a href='admin.php?f=28&sug_start={$plus}'>+ 5</a> \n ";
}
}
if ($start < $pages) {
// Display 'Last'
echo "<a href='admin.php?f=28&sug_start={$pages}'>Last</a>\n ";
}
echo "\n </div>\n ";
}
}
// remove arguments
}
$title = $db_con->real_escape_string($title);
$description = $db_con->real_escape_string($description);
$url = cleaninput(cleanup_text(trim(substr($url, 0, 1024))));
$title = trim(substr($title, 0, 255));
$description = nl2br(trim(substr($description, 0, 255)));
$email = cleaninput(cleanup_text(trim(substr($email, 0, 255))));
$url_1 = stripslashes($url);
// make it human readable
// check URL
if ($whois_user) {
// perform a WHOIS check for suggested URL
require_once "{$include_dir}/domain_whois.php";
$list = "";
$whois = new whois();
//new class
$whois_res = $whois->lookup($url, $whois_ext, $list);
unset($whois);
$whois_server = $whois_res['whoisserver'];
$whois_result = $whois_res['result'];
$whois_answer = $whois_res['answer'];
if ($whois_result != "okay") {
echo " <h1>{$mytitle}</h1>\n <p> <p>\n <p class='warnadmin cntr'><br />Invalid URL input. <br />{$whois_answer}<br /><br /></p>\n <p> </p>\n <a class='bkbtn' href='addurl.php' title='Go back to Submission Form'>Back</a></p>\n </body>\n </html>\n ";
die('');
}
} else {
if (!$idna) {
// if not accepted internationalized URLs, do a standard check
$input = $url;
validate_url($input);
