MemHT Portal is a Free PHP CMS and Blog
It permit the creation and the management online of websites with few and easy steps.
It's completelly customizable, expandable and suitable for all needs.
Moderators: Moderators
Forum RSS feedReply
comment block
AuthorText
doulis
Senior Member
Avatar

Posts: 172
Contributes: 140

Gender: _MALE_
Online: No

Version: 4.0
Country: Greece
Languages: Greek & Little English
Date: 15/05/2008 10:50
comment block
#post7148
hi...

my site is www.midipart.gr/main
i use 3.7.5 memht version at windows.


My question is, how can i create a two differnt comment blocks (recent&popular comments blocks from the "News & Download" ) at the right or left side of my page!.

Many users suggest this block to me and make here my question Smile

thanks in advanced


Edited: 15/05/2008 10:53
GREEK MUSIC PORTAL:::
http://www.midipart.gr/main
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 5130
Contributes: 2473

Gender: _MALE_
Online: No
Date: 15/05/2008 13:40
Re: comment block
#post7151
Popular comments? There is no a value that count in any way the popularity of comments. I want to add some kind of thumb up/thumb down for comments in the future, but at the moment there is no way.
Delete Edit Quote
 
doulis
Senior Member
Avatar

Posts: 172
Contributes: 140

Gender: _MALE_
Online: No

Version: 4.0
Country: Greece
Languages: Greek & Little English
Date: 15/05/2008 13:45
Re: comment block
#post7153
i mean news or downloads with most comments..

for now its not way to do something with that?
GREEK MUSIC PORTAL:::
http://www.midipart.gr/main
Delete Edit Quote
 
mem
MemHT's Dad
Admin & Developer

Avatar

Posts: 5130
Contributes: 2473

Gender: _MALE_
Online: No
Date: 15/05/2008 14:29
Re: comment block
#post7156
ah. it's possible of course

News
code
SELECT n.id,n.nome,COUNT(c.id) AS ncomments FROM memht_news AS n JOIN memht_comments AS c ON n.id = c.wid WHERE c.whr = 3 GROUP BY n.id DESC ORDER BY ncomments DESC LIMIT 10


Top 10 commented news
title: title news
ncomments: num of comments

The same for downloads:
code
SELECT n.nome AS title,COUNT(c.id) AS ncomments FROM memht_download AS n JOIN memht_comments AS c ON n.id = c.wid WHERE c.whr = 4 GROUP BY n.id DESC ORDER BY ncomments DESC LIMIT 10
Delete Edit Quote
 
doulis
Senior Member
Avatar

Posts: 172
Contributes: 140

Gender: _MALE_
Online: No

Version: 4.0
Country: Greece
Languages: Greek & Little English
Date: 16/05/2008 02:23
Re: comment block
#post7167
mem...
Is it easy to write all the php code of the NEWS comments and DOWNLOAD comments?
Then i will copy-paste the codes to a new php files as i will see it from you!!


i tried but something make wrong and i dont know php routines Smile

GREEK MUSIC PORTAL:::
http://www.midipart.gr/main
Delete Edit Quote
 
Reply
Tags Cloud
Advertising
News Archive
Language
Help MemHT Portal
Navigator
Users Block
Hi Guest
IP: 38.103.63.59

Username
Password
New files
MemHT Wiki
Friends
MemHT Portal is a free software released under the GNU/GPL License by Miltenovik Manojlo