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"; $result = $db_con->query($sql_query); if ($debug && $db_con->errno) {
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 "; } }
$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); $url = $input; } else {