PunBB Forums — Rate Topic 1.0

Re: Rate Topic 1.0

null@example.com (raptrex) — Mon, 04 Dec 2006 00:12:22 +0000

can you make it that the user can only vote once on a topic?

Re: Rate Topic 1.0

null@example.com (adjust) — Sun, 03 Dec 2006 12:45:05 +0000

Is there any demo?

Re: Rate Topic 1.0

null@example.com (virgildizon) — Sun, 03 Dec 2006 04:26:16 +0000

Awesome mod... I'm gonna try this to my site too.

Re: Rate Topic 1.0

null@example.com (Tubby) — Tue, 31 Oct 2006 18:09:51 +0000

i believe that the topics rating should have its own coloum in viewforum.php.....it would make everything less confusing.

Re: Rate Topic 1.0

null@example.com (elbekko) — Tue, 31 Oct 2006 12:41:12 +0000

Yeah, well, it's basically just a reputation mod for threads. And I took the pictures from that mod too

Re: Rate Topic 1.0

null@example.com (mystic) — Tue, 31 Oct 2006 12:24:55 +0000

@Kha0sK1d: aye its fine; you did a good job
@elbekko: i like your mod also; but there are some reasons make me think of it:
- ive pointed my link for rating from outside to the rate file in the Kha's mod. (so ppl can rate from outside) . however i can change it easily...
- i got the reputation mod add on my forum, and your mod looks the same with it; sometimes it makes ppl confuse u know
- and yeah i like stars

but after all both of u did a great job thx for that.

Re: Rate Topic 1.0

null@example.com (Kha0sK1d) — Mon, 30 Oct 2006 20:56:41 +0000

My mod wasn't intended for statistics, it was designed for ease of use and simplicity. I believe I have accomplished that and I will not make any further modifications. Sorry to disappoint you.

Re: Rate Topic 1.0

null@example.com (elbekko) — Sun, 29 Oct 2006 19:13:41 +0000

Use my mod, it makes it all alot easier.

Re: Rate Topic 1.0

null@example.com (mystic) — Sun, 29 Oct 2006 18:50:59 +0000

Kha0sK1d wrote:

It finally hit me earlier yesterday. The way I have it set up is all the ratings go in a commonpool.
##              +----------+------------------+------+-----+---------+-------+
##              | Field    | Type             | Null | Key | Default | Extra |
##              +----------+------------------+------+-----+---------+-------+
##              | rate     | tinyint(2)       |      |     | 0       |       |
##              | user_id  | int(10) unsigned |      |     | 0       |       |
##              | topic_id | int(10) unsigned |      |     | 0       |       |
##              +----------+------------------+------+-----+---------+-------+
The overall rating for a topic is not stored; only the individual ratings from a person. So if two people vote for the same topic, it is possible that it could show up twice. What you would have to do is select all distinct topic_id and then individually calculate the averages. To find top 5 you would have to store results in an array and do a lot more querying.

u gonna have a new release? i hope so... if will; i hope it will be included some functions or tables that can show the top rate

Re: Rate Topic 1.0

null@example.com (elbekko) — Mon, 23 Oct 2006 20:35:53 +0000

Almost done, just creating the readme now (sigh, that takes long even with the generator I made -.-).

Re: Rate Topic 1.0

null@example.com (mystic) — Mon, 23 Oct 2006 20:34:04 +0000

*my hope is coming back ... *

Re: Rate Topic 1.0

null@example.com (elbekko) — Mon, 23 Oct 2006 16:44:16 +0000

I have some free time on my hands; I suppose I can update your mod for you

EDIT: Or even better, I'll just recreate it

Re: Rate Topic 1.0

null@example.com (mystic) — Mon, 23 Oct 2006 15:55:37 +0000

aye thanks for reply.... i know nothing about mysql... so i think have to give up the top rate...

Re: Rate Topic 1.0

null@example.com (elbekko) — Mon, 23 Oct 2006 14:21:24 +0000

Or you could update your mod to do it decently

Make topic_id unique, and use an INSERT INTO ... ON DUPLICATE KEY UPDATE query.

Re: Rate Topic 1.0

null@example.com (Kha0sK1d) — Mon, 23 Oct 2006 10:46:20 +0000

It finally hit me earlier yesterday. The way I have it set up is all the ratings go in a commonpool.

##              +----------+------------------+------+-----+---------+-------+
##              | Field    | Type             | Null | Key | Default | Extra |
##              +----------+------------------+------+-----+---------+-------+
##              | rate     | tinyint(2)       |      |     | 0       |       |
##              | user_id  | int(10) unsigned |      |     | 0       |       |
##              | topic_id | int(10) unsigned |      |     | 0       |       |
##              +----------+------------------+------+-----+---------+-------+

The overall rating for a topic is not stored; only the individual ratings from a person. So if two people vote for the same topic, it is possible that it could show up twice. What you would have to do is select all distinct topic_id and then individually calculate the averages. To find top 5 you would have to store results in an array and do a lot more querying.