Ejemplo n.º 1
0
function show_links($site_id)
{
    global $db_con, $mysql_table_prefix, $debug;
    $sql_query = "SELECT site_id, url, title, short_desc, indexdate from " . $mysql_table_prefix . "sites where site_id={$site_id}";
    $result = $db_con->query($sql_query);
    if ($debug && $db_con->errno) {
        $err_row = __LINE__ - 2;
        printf("<p><span class='red'>&nbsp;MySQL failure: %s&nbsp;\n<br /></span></p>", $db_con->error);
        if (__FUNCTION__) {
            printf("<p><span class='red'>&nbsp;Found in script: " . __FILE__ . "&nbsp;&nbsp;row: {$err_row}&nbsp;&nbsp;in function():&nbsp;" . __FUNCTION__ . "&nbsp;<br /></span></p>");
        } else {
            printf("<p><span class='red'>&nbsp;Found in script: " . __FILE__ . "&nbsp;&nbsp;row: {$err_row}&nbsp;<br /></span></p>");
        }
        printf("<p><span class='red'>&nbsp;Script execution aborted.&nbsp;<br /></span>");
        printf("<p><strong>Invalid query string, which caused the SQL error:</strong></p>");
        echo "<p> {$sql_query} </p>";
        exit;
    }
    $row = $result->fetch_array(MYSQLI_ASSOC);
    $result->free_result;
    $url = replace_ampersand($row['url']);
    //      Headline for Show links
    echo "<div class='submenu cntr'>| Show all Pages of Url ' {$url} ' |</div>\n            ";
    //      Get all links of this Url.
    $sql_query = "SELECT * from " . $mysql_table_prefix . "links where site_id = '{$site_id}'";
    $res = $db_con->query($sql_query);
    if ($debug && $db_con->errno) {
        $err_row = __LINE__ - 2;
        printf("<p><span class='red'>&nbsp;MySQL failure: %s&nbsp;\n<br /></span></p>", $db_con->error);
        if (__FUNCTION__) {
            printf("<p><span class='red'>&nbsp;Found in script: " . __FILE__ . "&nbsp;&nbsp;row: {$err_row}&nbsp;&nbsp;in function():&nbsp;" . __FUNCTION__ . "&nbsp;<br /></span></p>");
        } else {
            printf("<p><span class='red'>&nbsp;Found in script: " . __FILE__ . "&nbsp;&nbsp;row: {$err_row}&nbsp;<br /></span></p>");
        }
        printf("<p><span class='red'>&nbsp;Script execution aborted.&nbsp;<br /></span>");
        printf("<p><strong>Invalid query string, which caused the SQL error:</strong></p>");
        echo "<p> {$sql_query} </p>";
        exit;
    }
    $num_rows = $res->num_rows;
    if ($num_rows) {
        while ($this_link = $res->fetch_array(MYSQLI_ASSOC)) {
            $links[] = $this_link;
        }
    }
    $class = "evrow";
    if (!$num_rows) {
        print "<br /><div id =\"result_report\" class='cntr'>The search didn't match any indexed links</div>";
    } else {
        //      Display header row and all results
        echo "<div class='panel'>\n                    <table width='90%' class='cntr'>\n                    <tr>\n                        <td class='headline'>Count</td>\n                        <td class='headline'>Page Url</td>\n                        <td class='headline'>Last indexed</td>\n                        <td class='headline'>Page size</td>\n                    </tr>\n                ";
        for ($i = 0; $i < $num_rows; $i++) {
            $url2 = $links[$i]['url'];
            $indexed = $links[$i]['indexdate'];
            $page_size = $links[$i]['size'];
            $count = $i + 1;
            if ($class == "evrow") {
                $class = "odrow";
            } else {
                $class = "evrow";
            }
            echo "<tr class='{$class}'>\n                        <td>{$count}</td>\n                        <td><a href='{$url2}' target='_blank' title='Visit in new window'>{$url2}</a></td>\n                        <td>{$indexed}</td>\n                        <td>{$page_size} kB</td>\n                        </tr>\n                    ";
        }
        echo "</table>\n                    <a class='bkbtn' href='admin.php?f=20&amp;site_id={$site_id}' title='Go back to Site Options'>Back</a>\n                ";
    }
}
Ejemplo n.º 2
0
function show_links($site_id)
{
    $result = mysql_query("SELECT site_id, url, title, short_desc, indexdate from " . TABLE_PREFIX . "sites where site_id={$site_id}");
    if (DEBUG > '0') {
        echo mysql_error();
    }
    $row = mysql_fetch_array($result);
    $url = replace_ampersand($row[url]);
    // Headline for Show links
    echo "<div class='submenu cntr'>\r\n\t\t\t\t<ul>\r\n\t\t\t\t\t<li>Show all Pages of Url ' {$url} '</li>\r\n\t\t\t\t\t<li><a class='bkbtn' href='" . WEBROOT_DIR . "/admin/?f=20&amp;site_id={$site_id}' title='Go back to Site Options'>Back</a></li>\r\n\t\t\t\t</ul>\r\n\t\t\t</div>\n";
    // Get all links of this Url.
    $res = mysql_query("select * from " . TABLE_PREFIX . "links where site_id = '{$site_id}'");
    if (DEBUG > '0') {
        echo mysql_error();
    }
    $num_rows = mysql_num_rows($res);
    $class = "evrow";
    if ($num_rows == 0) {
        print "<br /><div id =\"result_report\" class='cntr'>The search didn't match any indexed links</div>";
    }
    if ($num_rows > 0) {
        //      Display header row and all results
        echo "<div class='panel'>\r\n\t\t\t<table width='90%' class='cntr'>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td class='headline'>Count</td>\r\n\t\t\t\t\t<td class='headline'>Page Url</td>\r\n\t\t\t\t\t<td class='headline'>Last indexed</td>\r\n\t\t\t\t\t<td class='headline'>Page size</td>\r\n\t\t\t\t</tr>\r\n\t\t";
        for ($i = 0; $i < $num_rows; $i++) {
            $url2 = mysql_result($res, $i, "url");
            $indexed = mysql_result($res, $i, "indexdate");
            $page_size = mysql_result($res, $i, "size");
            $count = $i + 1;
            if ($class == "evrow") {
                $class = "odrow";
            } else {
                $class = "evrow";
            }
            echo "<tr class='{$class}'>\r\n                    <td>{$count}</td>            \r\n                    <td><a href='{$url2}' target='_blank' title='Visit in new window'>{$url2}</a></td>            \r\n                    <td>{$indexed}</td>            \r\n                    <td>{$page_size} kB</td>                     \r\n                    </tr>\r\n                ";
        }
        echo "</table>\r\n            ";
    }
}
Ejemplo n.º 3
0
function siteScreen($site_id, $message)
{
    global $mysql_table_prefix;
    $result = mysql_query("SELECT site_id, url, title, short_desc, indexdate from " . $mysql_table_prefix . "sites where site_id={$site_id}");
    echo mysql_error();
    $row = mysql_fetch_array($result);
    $url = replace_ampersand($row[url]);
    if ($row['indexdate'] == '') {
        $indexstatus = "<font color=\"red\">Not indexed</font>";
        $indexoption = "<a href=\"admin.php?f=index&url={$url}\">Index</a>";
    } else {
        $site_id = $row['site_id'];
        $result2 = mysql_query("SELECT site_id from " . $mysql_table_prefix . "pending where site_id ={$site_id}");
        echo mysql_error();
        $row2 = mysql_fetch_array($result2);
        if ($row2['site_id'] == $row['site_id']) {
            $indexstatus = "Unfinished";
            $indexoption = "<a href=\"admin.php?f=index&url={$url}\">Continue indexing</a>";
        } else {
            $indexstatus = $row['indexdate'];
            $indexoption = "<a href=\"admin.php?f=index&url={$url}&reindex=1\">Re-index</a>";
        }
    }
    ?>

		<div id="submenu">
		</div>
		<?php 
    print $message;
    ?>
			<br/>

		<center>
		<div style="width:755px;">
		<div style="float:left; margin-right:0px;">
		<div class="darkgrey">
		<table cellpadding="3" cellspacing="0">

			<table  cellpadding="5" cellspacing="1" width="640">
			  <tr >
				<td class="grey" valign="top" width="20%" align="left">URL:</td>
				<td class="white" align="left"><a href="<?php 
    print $row['url'];
    print "\">";
    print $row['url'];
    ?>
</a></td>
			  </tr>
			<tr>
				<td class="grey" valign="top" align="left">Title:</td>
				<td class="white" align="left"><b><?php 
    print stripslashes($row['title']);
    ?>
</b></td>
			</tr>
			  <tr>
				<td class="grey" valign="top" align="left">Description:</td>
				<td width="80%" class="white"  align="left"><?php 
    print stripslashes($row['short_desc']);
    ?>
</td>
			  </tr>
			  <tr>
				<td class="grey" valign="top" align="left">Last indexed:</td>
				<td class="white"  align="left"><?php 
    print $indexstatus;
    ?>
</td>
			  </tr>
			</table>
		</div>
		</div>
		<div id= "vertmenu">
		<ul>
		 <li><a href=admin.php?f=edit_site&site_id=<?php 
    print $row['site_id'];
    ?>
>Edit</a></li>
		<li><?php 
    print $indexoption;
    ?>
</li>
		<li><a href=admin.php?f=21&site_id=<?php 
    print $row['site_id'];
    ?>
>Browse pages</a></li>
		<li><a href=admin.php?f=5&site_id=<?php 
    print $row['site_id'];
    ?>
 onclick="return confirm('Are you sure you want to delete? Index will be lost.')">Delete</a></li>
		<li><a href=admin.php?f=19&site_id=<?php 
    print $row['site_id'];
    ?>
>Stats</a></li>
		</div>
		</ul>
		</div>
		</center>
		<div class="clear">
		</div>
		<br/>
	<?php 
}
Ejemplo n.º 4
0
function siteScreen($site_id, $message)
{
    global $mysql_table_prefix;
    $result = mysql_query("SELECT site_id, url, title, short_desc, indexdate from " . $mysql_table_prefix . "sites where site_id={$site_id}");
    echo mysql_error();
    $row = mysql_fetch_array($result);
    $url = replace_ampersand($row[url]);
    if ($row['indexdate'] == '') {
        $indexstatus = "<font color=\"red\">没有索引</font>";
        $indexoption = "<a href=\"admin.php?f=index&url={$url}\">索引</a>";
    } else {
        $site_id = $row['site_id'];
        $result2 = mysql_query("SELECT site_id from " . $mysql_table_prefix . "pending where site_id ={$site_id}");
        echo mysql_error();
        $row2 = mysql_fetch_array($result2);
        if ($row2['site_id'] == $row['site_id']) {
            $indexstatus = "Unfinished";
            $indexoption = "<a href=\"admin.php?f=index&url={$url}\">继续索引</a>";
        } else {
            $indexstatus = $row['indexdate'];
            $indexoption = "<a href=\"admin.php?f=index&url={$url}&reindex=1\">重新索引</a>";
        }
    }
    ?>

		<div id="submenu">
		</div>
		<?php 
    print $message;
    ?>
			<br/>

		<center>
		<div style="width:755px;">
		<div style="float:left; margin-right:0px;">
		<div class="darkgrey">
		<table cellpadding="3" cellspacing="0">

			<table  cellpadding="5" cellspacing="1" width="640">
			  <tr >
				<td class="grey" valign="top" width="20%" align="left">网址:</td>
				<td class="white" align="left"><a href="<?php 
    print $row['url'];
    print "\">";
    print $row['url'];
    ?>
</a></td>
			  </tr>
			<tr>
				<td class="grey" valign="top" align="left">标题:</td>
				<td class="white" align="left"><b><?php 
    print stripslashes($row['title']);
    ?>
</b></td>
			</tr>
			  <tr>
				<td class="grey" valign="top" align="left">简介:</td>
				<td width="80%" class="white"  align="left"><?php 
    print stripslashes($row['short_desc']);
    ?>
</td>
			  </tr>
			  <tr>
				<td class="grey" valign="top" align="left">上次索引:</td>
				<td class="white"  align="left"><?php 
    print $indexstatus;
    ?>
</td>
			  </tr>
			</table>
		</div>
		</div>
		<div id= "vertmenu">
		<ul>
		 <li><a href=admin.php?f=edit_site&site_id=<?php 
    print $row['site_id'];
    ?>
>编辑</a></li>
		<li><?php 
    print $indexoption;
    ?>
</li>
		<li><a href=admin.php?f=21&site_id=<?php 
    print $row['site_id'];
    ?>
>页面浏览</a></li>
		<li><a href=admin.php?f=5&site_id=<?php 
    print $row['site_id'];
    ?>
 onclick="return confirm('你真的要删除? 索引将丢失。')">删除</a></li>
		<li><a href=admin.php?f=19&site_id=<?php 
    print $row['site_id'];
    ?>
>统计</a></li>
		</div>
		</ul>
		</div>
		</center>
		<div class="clear">
		</div>
		<br/>
	<?php 
}