
07-24-2002, 09:05 PM
|
|
|
Join Date: Oct 2001
Location: New York
Posts: 1,834
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally posted by bad_madman
Search in file showthread.php for:
Code:
post.*".iif($bmpublicbrowse!="0",",SUM(bookmarks.public) AS bmcount","").",post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
and replace with:
Code:
post.*".iif($bmpublicbrowse!="0",",SUM(bookmarks.public) AS bmcount,SUM(bookmarks.counter) AS allhits","").",post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,".iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
and search in showthread.php for:
Code:
".iif ($bmpublicbrowse!="0","LEFT JOIN bookmarks ON bookmarks.userid=user.userid","")."
WHERE $postids
GROUP BY post.postid
and replace with:
Code:
".iif ($bmpublicbrowse!="0","LEFT JOIN bookmarks ON bookmarks.userid=user.userid AND bookmarks.public='1'","")."
WHERE $postids
GROUP BY post.postid
that's all
|
What does these changes do? Also, the first search and replace, there's 2 instances. Replace both?
|