comment block | Forum | MemHT Portal

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.

Site demo

Download MemHT Portal

Home > Forum > MemHT Portal > General > comment block

Forum

Home > MemHT Portal > General > comment block

Moderators: mem paulo89 adminik

comment block

Author

Text

doulis
Junior Member

Posts: 87
Contributes: 53

Gender: _MALE_

Online: No

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 thanks in advanced Edited: 15/05/2008 10:53

mem
MemHT's Dad
Admin / Developer

Posts: 3984
Contributes: 1264

Gender: _MALE_

Online: Yes

Languages: English, Italian, Macedonian, Serbian

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. MemHT Portal - Free PHP CMS and Blog "Great works are performed, not by strength, but by perseverance." Samuel Johnson READ THIS before posting your support question in the forum!

doulis
Junior Member

Posts: 87
Contributes: 53

Gender: _MALE_

Online: No

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?

mem
MemHT's Dad
Admin / Developer

Posts: 3984
Contributes: 1264

Gender: _MALE_

Online: Yes

Languages: English, Italian, Macedonian, Serbian

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

MemHT Portal - Free PHP CMS and Blog

"Great works are performed, not by strength, but by perseverance."
Samuel Johnson

READ THIS before posting your support question in the forum!

doulis
Junior Member

Posts: 87
Contributes: 53

Gender: _MALE_

Online: No

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