http://www.icyphoenix.com/viewtopic.php?f=28&t=6181
-----------------------------------
DWho
Sun 26 Jul, 2009 13:05

[Mod Release 1.3] Topic Cement
-----------------------------------
This mod will allow the moderator to set a priority for any topic.
The default priority is zero; all topics with a priority of zero
are sorted as they always have been: First by type, and then by
descending topic id.  This mod inserts a new sort: First by type, 
then by priority (Descending), and then topic id (descending).
It adds a text field in the moderator control panel to assign 
or remove priority from any topic.
			
The intent of this mod is to be used in a forum of announcements or,
in my case, a forum dedicated to distributing official attachments.
The users can reply to my attachment post, but I don't want the order
of the posts to change, so this mod "cements" the order.  Or think of
it as moderator-definable stickiness!

[url=http://www.icyphoenix.co.uk/dload.php?action=file&file_id=13]Please Download Here

Enjoy


-----------------------------------
Yros
Sun 30 Aug, 2009 13:29

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
Hii **
I just would check something : during the installation, I found it for modcp.php :
[code]#
#-----[ FIND ]------------------------------------------ 
#

			ORDER BY t.topic_type DESC, p.post_time DESC LIMIT $start, " . $board_config['topics_per_page'];

#
#-----[ AFTER, ADD ]------------------------------------------ 
#

			ORDER BY t.topic_type DESC, t.topic_priority DESC, p.post_time DESC LIMIT $start, " . $board_config['topics_per_page'];[/code]

Isn't it :
[code]#
#-----[ FIND ]------------------------------------------ 
#

			ORDER BY t.topic_type DESC, p.post_time DESC LIMIT $start, " . $board_config['topics_per_page'];

#
#-----[ REPLACE WITH ]------------------------------------------ 
#

			ORDER BY t.topic_type DESC, t.topic_priority DESC, p.post_time DESC LIMIT $start, " . $board_config['topics_per_page'];[/code]

Regards,


-----------------------------------
DWho
Sun 30 Aug, 2009 13:47

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
I do not follow you the code you posted is exactly the same both times...

 :mrgreen:  :mrgreen:


-----------------------------------
spydie
Sun 30 Aug, 2009 18:43

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
Mike where are your glasses ??

the point is in AFTER  and Replace


-----------------------------------
Yros
Sun 30 Aug, 2009 20:04

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
[quote user="spydie" post="43845"]Mike where are your glasses ??[/quote]
You are here =D
And yes the difference is that it's not " after, add " but " replace with " ^^
Because when I saw where it was placed, it seemed strange to me to have 2 time that kind of line =/ See : default modcp.php part which is interesting us :
[code]WHERE t.forum_id = $forum_id
				AND p.poster_id = u.user_id
				AND t.topic_poster = u2.user_id
				AND p.post_id = t.topic_last_post_id
				AND p2.post_id = t.topic_first_post_id $where_type
			ORDER BY t.topic_type DESC, p.post_time DESC LIMIT $start, " . $board_config['topics_per_page'];[/code]

What you tell us to do ( " after, add " ) will does that :
[code]WHERE t.forum_id = $forum_id
				AND p.poster_id = u.user_id
				AND t.topic_poster = u2.user_id
				AND p.post_id = t.topic_last_post_id
				AND p2.post_id = t.topic_first_post_id $where_type
			ORDER BY t.topic_type DESC, p.post_time DESC LIMIT $start, " . $board_config['topics_per_page'];
                        ORDER BY t.topic_type DESC, t.topic_priority DESC, p.post_time DESC LIMIT $start, " . $board_config['topics_per_page']; [/code]

What I think is right ( " replace with " ) :
[code]WHERE t.forum_id = $forum_id
				AND p.poster_id = u.user_id
				AND t.topic_poster = u2.user_id
				AND p.post_id = t.topic_last_post_id
				AND p2.post_id = t.topic_first_post_id $where_type
                        ORDER BY t.topic_type DESC, t.topic_priority DESC, p.post_time DESC LIMIT $start, " . $board_config['topics_per_page'];[/code]

No ? **


-----------------------------------
DWho
Mon 31 Aug, 2009 11:54

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
doh.. :oops: . yep sorry... was just looking at the code... did not see the replace and after...

thanks for pointing that out i will update the download...

 :mrgreen:  :mrgreen:


-----------------------------------
Aerosmith
Sun 22 Nov, 2009 12:50

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
Excuse me, translated with Google

Thanks for the MOD

A proved very helpful  :up: 

I have a question

This mod is only for administrators?

My moderators can not be used, why?

Thanks

___________________


Me disculpan, traducido con Google

Gracias por el MOD

A sido de mucha utilidad  :up: 

Tengo una duda

Este MOD es solo para administradores?

Mis moderadores no lo pueden usar, ¿porque?

Gracias


-----------------------------------
DWho
Sun 22 Nov, 2009 14:59

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
Hi

I have checked my test site with a moderator and they can use the topic cement feature...

do you moderators have access to that forum..?

 :mrgreen:  :mrgreen:


-----------------------------------
Aerosmith
Sun 22 Nov, 2009 15:58

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
hi.

Yes, they have access to these forums.

The moderators do not see this option in the forums that control, left two images

[IMG]http://i233.photobucket.com/albums/ee293/rekcah2002/panelmoderador.jpg[/IMG]

[IMG]http://i233.photobucket.com/albums/ee293/rekcah2002/permisos.jpg[/IMG]

This option, I see on the panel moderators at the end of each topic.

Thanks for responding


_______________

Hola.

Si, ellos tienen acceso a esos foros.

Los moderadores no ven esta opción, en los foros que controlan, dejo dos imágenes.

Esta opción, yo la veo en el panel de moderadores al final de cada tema.

Gracias por responder.


-----------------------------------
DWho
Sun 22 Nov, 2009 16:07

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
so as admin you can see the changes....?


-----------------------------------
Aerosmith
Sun 22 Nov, 2009 16:55

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
hi

Edit all files for third time, got on the FTP, delete the forum cache, delete browser cache (use one for Administrator, one for moderator and one for user, for fast access), check permissions.

And finally seen both as Administrators Moderators.

I think my problem was with the browser and the cache.

Thanks DWho,

I'm sorry for the inconvenience. :oops:  :oops: 
____________________

hola

Edite todos los archivos por tercera ves, los subí a FTP, borre cache del foro, borre cache de exploradores (uso uno para Administrador, uno para Moderador y uno para usuario, para acceso rápido), revise permisos.

Y finalmente se ve tanto para Moderadores como Administradores.

Yo creo que mi problema era con el explorador y el cache.

Gracias DWho.

Discúlpame por las molestias. :oops:  :oops:


-----------------------------------
DWho
Sun 22 Nov, 2009 18:46

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
No problem glad you got it sorted  :mrgreen:  :mrgreen:


-----------------------------------
nazbox
Fri 18 Mar, 2011 18:57

Re: [Mod Release 1.3] Topic Cement
-----------------------------------
Hi,

I have installed this mod but for some reason i cant see the priority on the moderate page.

When I click on "moderate this forum" i can set the priority but after I set it and go back into "moderate this forum" to change the priority I can't see the priority I have already set and so I don't know the number i have used.

The Mod works fine but I just can't see the current priority numbers in "moderate this forum".


Can anyone help?