[geeklog-cvs] geeklog-1.3/public_html search.php,1.46,1.47
dhaun at geeklog.net
dhaun at geeklog.net
Thu Jan 9 04:30:39 EST 2003
Update of /usr/cvs/geeklog/geeklog-1.3/public_html
In directory internal.geeklog.net:/tmp/cvs-serv15942
Modified Files:
search.php
Log Message:
Fixed link to search results in poll comments.
Index: search.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/public_html/search.php,v
retrieving revision 1.46
retrieving revision 1.47
diff -C2 -d -r1.46 -r1.47
*** search.php 14 Dec 2002 20:50:42 -0000 1.46
--- search.php 9 Jan 2003 09:30:36 -0000 1.47
***************
*** 328,332 ****
$powhere .= "({$_TABLES['pollquestions']}.perm_anon IS NOT NULL)";
! $sql = "SELECT {$_TABLES['stories']}.sid,{$_TABLES['comments']}.title,comment,pid,{$_TABLES['comments']}.uid,type as comment_type,UNIX_TIMESTAMP({$_TABLES['comments']}.date) as day,'comment' as type FROM {$_TABLES['comments']} ";
$sql .= "LEFT JOIN {$_TABLES['stories']} ON (({$_TABLES['stories']}.sid = {$_TABLES['comments']}.sid) AND (" . $stsql . ")) ";
$sql .= "LEFT JOIN {$_TABLES['pollquestions']} ON ((qid = {$_TABLES['comments']}.sid) AND (" . $posql . ")) ";
--- 328,332 ----
$powhere .= "({$_TABLES['pollquestions']}.perm_anon IS NOT NULL)";
! $sql = "SELECT {$_TABLES['stories']}.sid,{$_TABLES['pollquestions']}.qid,{$_TABLES['comments']}.title,comment,pid,{$_TABLES['comments']}.uid,type as comment_type,UNIX_TIMESTAMP({$_TABLES['comments']}.date) as day,'comment' as type FROM {$_TABLES['comments']} ";
$sql .= "LEFT JOIN {$_TABLES['stories']} ON (({$_TABLES['stories']}.sid = {$_TABLES['comments']}.sid) AND (" . $stsql . ")) ";
$sql .= "LEFT JOIN {$_TABLES['pollquestions']} ON ((qid = {$_TABLES['comments']}.sid) AND (" . $posql . ")) ";
***************
*** 431,435 ****
$searchresults->set_var('data', '<a href="article.php?story=' . $C['sid'] . '">' . stripslashes($C['title']) . '</a>');
} else {
! $searchresults->set_var('data', '<a href="pollbooth.php?qid=' . $C['sid'] . '&aid=-1#comments">' . stripslashes($C['title']) . '</a>');
}
$searchresults->parse('data_cols','resultcolumn',true);
--- 431,435 ----
$searchresults->set_var('data', '<a href="article.php?story=' . $C['sid'] . '">' . stripslashes($C['title']) . '</a>');
} else {
! $searchresults->set_var('data', '<a href="pollbooth.php?qid=' . $C['qid'] . '&aid=-1#comments">' . stripslashes($C['title']) . '</a>');
}
$searchresults->parse('data_cols','resultcolumn',true);
More information about the geeklog-cvs
mailing list