upsearch.php

make project on java

<?php
include'include/begin.php';
include'include/search.php';

$userp2[12]?null : echoerror(69);
$page = (int)$_GET['page'];
$list_l = $page * 1000;
$page++;
if ($page == 1) {
    mysql_query("ALTER TABLE {$db_prefix}search DROP INDEX `btitle`");
    mysql_query("truncate table {$db_prefix}search");

    $fp = fopen('./cache/searchoff.php', 'w');
    fwrite($fp, '0');
    fclose($fp);
} 

$result = mysql_query("select * from {$db_prefix}title  ORDER BY id LIMIT $list_l,1000", $myconn);
$num = mysql_num_rows($result);
if ($num < 1000) {
    $page = 0;
} while ($row = mysql_fetch_array($result)) {
    $row['html']?$row['title'] = @strip_tags($row['title']): null;
    $btitle = addslashes(searchstr($row['title']));
    $title = addslashes($row['title']);
    $author = $row['author'];
    $posttime = $row['posttime'];
    $fidx = $row['fid'];
    $tid = $row['cid'];
    $hits = $row['hits'];
    $replies = $row['replies'];
    $result2 = mysql_query("select * from {$db_prefix}posts where id='$row[cid]'", $myconn);
    $row2 = mysql_fetch_array($result2);
    $html = explode('|', $row2['html']);
    if ($html[0]) {
        $content = @strip_tags($row2['content']);
    } else {
        $content = content($row2['content']);
    } 
    $content = str_replace("\r", '', $content);
    $content = str_replace("\n", '', $content);
    $content = preg_replace("/\[ax([0-9]+)\]/eis", '', $content);
    $content = substrs($content, 240, '');
    $bcontent = addslashes(searchstr($content));
    $content = addslashes($content);
    mysql_query("insert into {$db_prefix}search  values('$tid','$title','$btitle','$content','$bcontent','$author','$posttime','$fidx','$hits','$replies')" , $myconn);
} 

if ($page != 0) {
    $reuser = 'Title:' . ($page * 1000) . '...';
    $reurl = "?page=$page";
    echoioy(42, false);
} 

$_all = 0;
$_sys = 0;
$_t = 0;
$_b = 0;
$result = mysql_query("select * from {$db_prefix}members", $myconn);
$_all = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {
    if ($row['admin'] != 0 || $row['forums'] != '') {
        $_sys++;
    } 
    if ($row['groups'] != '') {
        $_t++;
    } 
    if ($row['blank'] == 1) {
        $_b++;
    } 
} ;
$c62 = $_sys . ',' . $_t . ',' . $_b . ',' . $_all;
mysql_query("update {$db_prefix}config set value='$c62' where id='62'", $myconn);
mysql_query("update {$db_prefix}config set value='$time' where id='60'", $myconn);
mysql_query("ALTER TABLE {$db_prefix}search ADD FULLTEXT 'btitle' (`btitle`,`bcontent` )", $myconn);
mysql_query("update {$db_prefix}keyword set list='',ip=''", $myconn);
$reurl = 'search.php';

@unlink('./cache/searchoff.php');
echoioy(27);
exit;

?>