[2.0.13] Separate Announcements and Sticky

The cleanup is complete. This forum is now read only.

Rating:

Excellent!
50
75%
Very Good
8
12%
Good
4
6%
Fair
2
3%
Poor
3
4%
 
Total votes: 67

Aiencran
Registered User
Posts: 169
Joined: Fri Oct 01, 2004 10:10 am
Location: Italy
Contact:

Re: BINGOOO!!!

Post by Aiencran » Tue Nov 02, 2004 11:58 pm

skaloumbakas wrote: I have applied the Global announcement Hack by Niels and now the Separate Announce&Sticky 1.1.0 MOD works like a charm !!! :D

Ganam wrote: Forget it, it works now :)
Nice one.


I'm very happy to hear it :D :D
Aiencran

User avatar
GurlzLubme
Registered User
Posts: 880
Joined: Wed Sep 01, 2004 11:21 am
Location: New York

Post by GurlzLubme » Tue Nov 09, 2004 9:11 pm

You might want to check to see if the Separate Announcements and Sticky mod is compatible with the Topic Cement Mod.

I just recently installed this mod, and it seems to work fine. However my Topic Cement Mod doesnt. I see that both mods edit the same line in the viewforum.php file, so that might be the reason why my Topic Cement mod isnt functioning properly.

Please let me know if I'm correct...

User avatar
Bard
Registered User
Posts: 449
Joined: Fri Sep 10, 2004 9:49 am
Location: Texas
Contact:

Post by Bard » Wed Nov 10, 2004 5:59 am

I have it working great with Topic Cement. See here:
http://x.otr-tnt.com/phpBB2/viewforum.php?f=11

All 200 posts in this forum are prioritized with Topic Cement.
A computer once beat me at chess, but it was no match for me at kick boxing.
Old Time Radio Talk | Visit OTR Talk Town

User avatar
GurlzLubme
Registered User
Posts: 880
Joined: Wed Sep 01, 2004 11:21 am
Location: New York

Post by GurlzLubme » Wed Nov 10, 2004 10:01 am

Bard wrote: I have it working great with Topic Cement. See here:
http://x.otr-tnt.com/phpBB2/viewforum.php?f=11

All 200 posts in this forum are prioritized with Topic Cement.


Hmmm, I see.


Okay, so which did you install first? I installed the Separate Mod first, and in the viewforum.php file it says:

Code: Select all

# 
#-----[ FIND ]------------------------------------------ 
# 
AND t.topic_type = " . POST_ANNOUNCE . " 
ORDER BY t.topic_last_post_id DESC ";

# 
#-----[ REPLACE WITH ]------------------------------------
#
AND t.topic_type BETWEEN " . POST_STICKY . " AND " . POST_ANNOUNCE . "
ORDER BY t.topic_type DESC, t.topic_last_post_id DESC ";
and then when I got to the Topic Cement mod, it says:

Code: Select all

#
#-----[ FIND ]------------------------------------------ 
#
	ORDER BY t.topic_last_post_id DESC ";
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
ORDER BY 
#
#-----[ IN-LINE REPLACE WITH ]------------------------------------------ 
#
ORDER BY t.topic_priority DESC, 
then:

Code: Select all

#-----[ FIND ]------------------------------------------ 
#
	ORDER BY t.topic_type DESC, t.topic_last_post_id DESC 
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
t.topic_type DESC
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
, t.topic_priority DESC
How did you end up editing the lines?

User avatar
Bard
Registered User
Posts: 449
Joined: Fri Sep 10, 2004 9:49 am
Location: Texas
Contact:

Post by Bard » Wed Nov 10, 2004 10:08 am

I did topic cement first. Here are some code snippets:

Code: Select all

		AND t.topic_type BETWEEN " . POST_STICKY . " AND " . POST_ANNOUNCE . " 
	ORDER BY t.topic_priority DESC, t.topic_last_post_id DESC ";

Code: Select all

	ORDER BY t.topic_type DESC, t.topic_priority DESC, t.topic_last_post_id DESC
If you need more just yell!
A computer once beat me at chess, but it was no match for me at kick boxing.
Old Time Radio Talk | Visit OTR Talk Town

User avatar
GurlzLubme
Registered User
Posts: 880
Joined: Wed Sep 01, 2004 11:21 am
Location: New York

Post by GurlzLubme » Wed Nov 10, 2004 10:29 am

Bard wrote: I did topic cement first. Here are some code snippets:

Code: Select all

		AND t.topic_type BETWEEN " . POST_STICKY . " AND " . POST_ANNOUNCE . " 
	ORDER BY t.topic_priority DESC, t.topic_last_post_id DESC ";

Code: Select all

	ORDER BY t.topic_type DESC, t.topic_priority DESC, t.topic_last_post_id DESC
If you need more just yell!


*yell!* :)

Yeah, I'm seriously frustrated... I can't seem to get my topic cement mod to work. I copied the lines as exactly as you have it too. :T Any other lines I should take a look at?

User avatar
Bard
Registered User
Posts: 449
Joined: Fri Sep 10, 2004 9:49 am
Location: Texas
Contact:

Post by Bard » Wed Nov 10, 2004 10:40 am

I know you have done plenty of mods. If you missed any thing in the sql you should be getting errors.

The only thing that comes to mind is modcp.php. Compare yours to the topic cement instructs and see if it is not just a typo. I can give you mine if you need it.

But if you're not getting sql errors then that part is ok. And it is showing up so the .tpl is ok. Your viewforum sounds ok. Let's tear apart the modcp.php and see if it is there.
A computer once beat me at chess, but it was no match for me at kick boxing.
Old Time Radio Talk | Visit OTR Talk Town

User avatar
GurlzLubme
Registered User
Posts: 880
Joined: Wed Sep 01, 2004 11:21 am
Location: New York

Post by GurlzLubme » Wed Nov 10, 2004 10:45 am

Bard wrote: I know you have done plenty of mods. If you missed any thing in the sql you should be getting errors.

The only thing that comes to mind is modcp.php. Compare yours to the topic cement instructs and see if it is not just a typo. I can give you mine if you need it.

But if you're not getting sql errors then that part is ok. And it is showing up so the .tpl is ok. Your viewforum sounds ok. Let's tear apart the modcp.php and see if it is there.


nope, no SQL errors... I'll take a closer look at the modcp.php...

and yes, i have done PLENTY of mods. hehe over 30 last time i checked... and this seems to be giving me trouble. *shrugs* I'll be back...

User avatar
Bard
Registered User
Posts: 449
Joined: Fri Sep 10, 2004 9:49 am
Location: Texas
Contact:

Post by Bard » Wed Nov 10, 2004 11:06 am

ycl6 wrote: MOD Updated to version 1.1.0
See first post for Download Link


I used the original and it works fine. Is the only difference the support for Global Announcements?
A computer once beat me at chess, but it was no match for me at kick boxing.
Old Time Radio Talk | Visit OTR Talk Town

User avatar
GurlzLubme
Registered User
Posts: 880
Joined: Wed Sep 01, 2004 11:21 am
Location: New York

Post by GurlzLubme » Wed Nov 10, 2004 11:14 am

Bard wrote: The only thing that comes to mind is modcp.php. Compare yours to the topic cement instructs and see if it is not just a typo. I can give you mine if you need it.



OMG! OMG! OMG!

Thank you for making me check the modcp.php again! I realize that the

Code: Select all

default:
that I was adding that block of code before wasn't the right "default:". I realized that I was adding it in Username Color Mod section. DOH! *slaps forehead*

NOW the topic cement works (in conjunction with Separate Mod)!! Back to batting 1000 now. haha thanks, Bard!

User avatar
Bard
Registered User
Posts: 449
Joined: Fri Sep 10, 2004 9:49 am
Location: Texas
Contact:

Post by Bard » Wed Nov 10, 2004 11:16 am

I am glad you got it working... :D
A computer once beat me at chess, but it was no match for me at kick boxing.
Old Time Radio Talk | Visit OTR Talk Town

skaloumbakas
Registered User
Posts: 179
Joined: Wed Sep 25, 2002 11:26 am
Location: Athens Hellas

Post by skaloumbakas » Wed Nov 10, 2004 11:59 am

PC's are the damnest things on earth... :wink:

Aiencran
Registered User
Posts: 169
Joined: Fri Oct 01, 2004 10:10 am
Location: Italy
Contact:

Post by Aiencran » Wed Nov 10, 2004 4:47 pm

Bard wrote:
ycl6 wrote:MOD Updated to version 1.1.0
See first post for Download Link


I used the original and it works fine. Is the only difference the support for Global Announcements?

New version supports the Global Announcements and orders topics in "Ann&Sticky" block by topic_type, that is.. first the Announcements and then the Sticky Topics...
Unfortunately I don't know if it's compatible with Topic Cement (I never tried this MOD) but it seems they can be applied together :wink:
Great work, Bard!
Aiencran

User avatar
Makc666
Registered User
Posts: 358
Joined: Fri Mar 07, 2003 12:03 pm
Location: MSK-RU
Name: Maxim
Contact:

Post by Makc666 » Fri Nov 12, 2004 10:40 am

//Separate Announcements & Sticky
$lang['Announcements_and_Sticky'] = 'Announcements and Sticky Topics';
$lang['Global_Announcements'] = 'Global Announcements';


This is the right way of code for lang_main.php !!!


Also, HOW 'Global_Announcements' WORKS ??
I can't understand!

Aiencran
Registered User
Posts: 169
Joined: Fri Oct 01, 2004 10:10 am
Location: Italy
Contact:

Post by Aiencran » Sat Nov 13, 2004 5:24 pm

Whay do you mean? I can't understand your question...
it's just a definition of a string for GlobalAnn section... it works even if you don't have installed Global Announcements' MOD
Aiencran

Post Reply

Return to “[2.0.x] MOD Database Cleanup”