if ($str[0] == '-') {
$not = 'NOT ';
$str = substr($str, 1);
} else {
$not = '';
}
if ($i > 0) {
$sql_where_like .= $op . $not;
}
if ($_POST['opt_0'] == 0) {
$sql_where_like .= "(r.topic LIKE{$binary} '%{$str}%' OR r.comment LIKE{$binary} '%{$str}%') ";
} else {
$sql_where_like .= "r.topic LIKE{$binary} '%{$str}%' ";
}
}
$sql_where = $slog->sqlinboards('r.board', 1, $boards) . " ";
if (count($used) > 0) {
$sql_where .= "({$sql_where_like}) ";
}
if (isset($rname)) {
if (count($used) > 0) {
$sql_where .= "AND ";
}
$sql_where .= "r.name = '{$rname}' ";
}
if (strxlen($_POST['name']) >= $config['searchminlength']) {
$used[] = $_POST['name'];
} else {
$ignored[] = $_POST['name'];
}
$having = '';
// Header of feeds
$rss = new UniversalFeedCreator();
$rss->encoding = $lang->phrase('charset');
$rss->setDir("feeds/topics_");
$rss->useCached($action, '', $h);
$rss->title = $config['fname'];
$rss->description = $config['fdesc'];
$rss->link = $config['furl'] . "/forum.php";
$rss->language = $lang->phrase('rss_language');
$rss->ttl = $config['rssttl'];
$rss->copyright = $config['fname'];
$rss->lastBuildDate = time();
$rss->editor = $config['fname'];
$rss->editorEmail = $config['forenmail'];
$sqllimit = 15;
$sqlwhere = "r.tstart = '1' AND f.invisible != '2' AND f.active_topic = '1' AND f.opt != 'pw' " . $slog->sqlinboards('t.board');
$sqlorder = "t.date DESC";
$sqljoin = $sqlfields = '';
($code = $plugins->load('external_query')) ? eval($code) : null;
// Get the last 15 topics
$result = $db->query("\nSELECT r.dowords, r.comment, r.guest, f.name as forum, u.name as uname, u.mail as umail, r.name as gname, r.email as gmail, t.topic, t.id, t.board, t.date, t.status {$sqlfields} \nFROM {$db->pre}topics AS t LEFT JOIN {$db->pre}replies AS r ON t.id = r.topic_id \n\tLEFT JOIN {$db->pre}user AS u ON r.name=u.id \n\tLEFT JOIN {$db->pre}forums AS f ON t.board=f.id \n\t{$sqljoin}\nWHERE {$sqlwhere} \nORDER BY {$sqlorder} \nLIMIT {$sqllimit}\n", __LINE__, __FILE__);
// Loop through them if the site is not offline
if ($config['foffline'] == 0) {
while ($row = $db->fetch_object($result)) {
// Formats the data
if ($row->guest == 0) {
$row->email = $row->umail;
$row->name = $row->uname;
} else {
$row->email = $row->gmail;
$row->name = $row->gname;
// Header of feeds
$rss = new UniversalFeedCreator();
$rss->encoding = $lang->phrase('charset');
$rss->setDir("feeds/topics_");
$rss->useCached($action, '', $h);
$rss->title = $config['fname'];
$rss->description = $config['fdesc'];
$rss->link = $config['furl'] . "/forum.php";
$rss->language = $lang->phrase('rss_language');
$rss->ttl = $config['rssttl'];
$rss->copyright = $config['fname'];
$rss->lastBuildDate = time();
$rss->editor = $config['fname'];
$rss->editorEmail = $config['forenmail'];
// Get the last 15 topics
$result = $db->query("\nSELECT r.dowords, r.comment, c.name as forum, u.name as uname, u.mail as umail, r.name as gname, r.email as gmail, t.topic, t.id, t.board, t.date, t.status \nFROM {$db->pre}topics AS t LEFT JOIN {$db->pre}replies AS r ON t.id = r.topic_id LEFT JOIN {$db->pre}user AS u ON r.name=u.id LEFT JOIN {$db->pre}cat AS c ON t.board=c.id \nWHERE r.tstart = '1' AND c.opt != 'pw' {$statustype} " . $slog->sqlinboards('t.board') . "\nORDER BY t.date DESC \nLIMIT 15\n", __LINE__, __FILE__);
// Loop through them if the site is not offline
if ($config['foffline'] == 0) {
while ($row = $db->fetch_object($result)) {
// Formats the data
if (!$row->gmail) {
$row->email = $row->umail;
$row->name = $row->uname;
} else {
$row->email = $row->gmail;
$row->name = $row->gname;
}
$bbcode->setSmileys(0);
if ($config['wordstatus'] == 0) {
$row->dowords = 0;
}
if ($str[0] == '-') {
$not = 'NOT ';
$str = substr($str, 1);
} else {
$not = '';
}
if ($i > 0) {
$sql_where_like .= $op . $not;
}
if ($_POST['opt_0'] == 0) {
$sql_where_like .= "(r.topic LIKE{$binary} '%{$str}%' OR r.comment LIKE{$binary} '%{$str}%') ";
} else {
$sql_where_like .= "r.topic LIKE{$binary} '%{$str}%' ";
}
}
$sql_where = $slog->sqlinboards('r.board', 1) . " ";
if (count($used) > 0) {
$sql_where .= "({$sql_where_like}) ";
}
if (isset($rname)) {
if (count($used) > 0) {
$sql_where .= "AND ";
}
$sql_where .= "r.name = '{$rname}' ";
}
if (strxlen($_POST['name']) >= $config['searchminlength']) {
$used[] = $_POST['name'];
} else {
$ignored[] = $_POST['name'];
}
$having = '';
// Header of feeds
$rss = new UniversalFeedCreator();
$rss->encoding = $lang->phrase('charset');
$rss->setDir("feeds/topics_");
$rss->useCached($action, '', $h);
$rss->title = $config['fname'];
$rss->description = $config['fdesc'];
$rss->link = $config['furl'] . "/forum.php";
$rss->language = $lang->phrase('rss_language');
$rss->ttl = $config['rssttl'];
$rss->copyright = $config['fname'];
$rss->lastBuildDate = time();
$rss->editor = $config['fname'];
$rss->editorEmail = $config['forenmail'];
$sqllimit = 15;
$sqlwhere = "r.tstart = '1' AND c.opt != 'pw' " . $slog->sqlinboards('t.board');
$sqlorder = "t.date DESC";
$sqljoin = $sqlfields = '';
($code = $plugins->load('external_query')) ? eval($code) : null;
// Get the last 15 topics
$result = $db->query("\nSELECT r.dowords, r.comment, r.guest, c.name as forum, u.name as uname, u.mail as umail, r.name as gname, r.email as gmail, t.topic, t.id, t.board, t.date, t.status {$sqlfields} \nFROM {$db->pre}topics AS t LEFT JOIN {$db->pre}replies AS r ON t.id = r.topic_id \n\tLEFT JOIN {$db->pre}user AS u ON r.name=u.id \n\tLEFT JOIN {$db->pre}cat AS c ON t.board=c.id \n\t{$sqljoin}\nWHERE {$sqlwhere} \nORDER BY {$sqlorder} \nLIMIT {$sqllimit}\n", __LINE__, __FILE__);
// Loop through them if the site is not offline
if ($config['foffline'] == 0) {
while ($row = $db->fetch_object($result)) {
// Formats the data
if ($row->guest == 0) {
$row->email = $row->umail;
$row->name = $row->uname;
} else {
$row->email = $row->gmail;
$row->name = $row->gname;
