Icy Phoenix

English Chit Chat - [Idea] Advanced Rating For Topics

Sarakin [ Mon 27 Oct, 2008 04:36 ]
Post subject: [Idea] Advanced Rating For Topics

Well, I've been searching for info about the Icy Rating system and I'm quite surprised about the fact that the Ratings are not into the filter List ( Display topics from previous: All topics, last day, last week, etc ). I think it would be a good tool to stand out the real good topics. By the way, I think it would be good to have an "advanced Rating" system which should belong only to Moderators, who will decide to apply Quality Points to the Topics.

So, we'll have two Rankings, the popular one (standard) and the official (website one), and the first could be orientative to Moderators to find the candidates Topics to be awarded with Quality Points. Furthermore, it would be interesting to be able to tag the Topics with a Description (website ranking) like "Funny", "Intriguing", "Inspiring", "Important" and setting them to the Filter box too, where I also miss some possibilities like "X to Y views" or "X to Y replies". I guess all of this could be quite useful.

What do you think? Should Icy have this options or do you think they are superfluous?

That's all. I guess this should be placed on the Icy Customizations Forum, but I cannot create topics there. Till next time!

Chaotic [ Mon 27 Oct, 2008 05:35 ]
Post subject: Re: [Idea] Advanced Rating For Topics

From what I've seen, IDEA topics are going into the Off-Topic/English Chit-Chat forum.

I do like the idea you have!

Moving...

Sarakin [ Tue 28 Oct, 2008 01:33 ]
Post subject: Re: [Idea] Advanced Rating For Topics

Maybe the second Ranking could be made out allowing to set the Topic Description only for MODs and Admins, but I don't know if this is possible on default Icy. If not so, I suppose it would be better to develop a MOD in order to do that, and link it somehow to the "filter box".

Mighty Gorgon [ Thu 30 Oct, 2008 11:41 ]
Post subject: Re: [Idea] Advanced Rating For Topics

I think that this is the typical feature suitable for a mod.

I won't add it in default package.

Sarakin [ Thu 30 Oct, 2008 20:57 ]
Post subject: Re: [Idea] Advanced Rating For Topics

Yep, but there's so many things on Icy that are unknown to us in order to make this MOD and others we are planning to customize the forum. One example about the online userlist we're trying:

First we make the SQL query to obtain the data we want:

Code: [Hide]

//Added by Krator (Torre de Marfil - www.HeroesofMightandMagic.es)
 
$sql = "SELECT u.user_id, 				u.username, 						u.user_allow_viewonline, 			u.user_level, 					s.session_logged_in, 
 
	s.session_time, 
 
	s.session_page, 
 
	s.session_ip, 
 
	s.session_user_agent
 
	FROM " . USERS_TABLE . " u, " . SESSIONS_TABLE . " s
 
WHERE u.user_id = s.session_user_id
 
AND s.session_time >= " . ( time() - ONLINE_REFRESH ) . "
 
ORDER BY u.username ASC, s.session_ip ASC";

After that, we execute the query:

Code: [Hide]

if ( !($result = $db->sql_query($sql)) )
 
{
 
	message_die(GENERAL_ERROR, 'Could not obtain regd user/online information', '', __LINE__, __FILE__, $sql);
 
}

we give start the Counter variable and we try to keep all on an array this way::

Code: [Hide]

$cont = 0;
 
while($row = $db->sql_fetchrow($result))
 
{
 
	$user_act[$cont] = $row['username'];
 
            $cont++;
 
}
 
$template->assign_vars(array(
 
	'TEST_WIO_LIST' => $user_act	
 
));

Finally, we try to call all the users allocated on our custom {TEST_WIO_LIST} var, but when we call it on the TPL file, we only get the last user of the list, and not all ones. Any idea about what's failing? We've also tried with:

Code: [Hide]

$template->assign_block_vars('test', array(
 
	'TEST_WIO_LIST' => $user_act
 
)); 

and using {test.TEST_WIO_LIST} on the TPL, but got the same results. Wish you could help us, for HoMM's sake!

(joke)

Well, feel free to cut this message in order to make a new and specific thread if necessary... Till next time! (hope it will be sooner than later :P)

Mighty Gorgon [ Sun 16 Nov, 2008 10:04 ]
Post subject: Re: [Idea] Advanced Rating For Topics

What do you want to do with that script?

Please open a new topic in General Support by explaining what you want to achieve and what you did so far.