FUDforum: Bug Reports » sticky and announcement bug?

Home » FUDforum Development » Bug Reports » sticky and announcement bug?

Show: Today's Messages :: Polls :: Message Navigator

Re: sticky and announcement bug? [message #5411 is a reply to message #5376]

Mon, 02 September 2002 02:12

ezdb

Messages: 158
Registered: May 2002
Location: china

Karma:

Senior Member

prottoss wrote on Fri, 30 August 2002 10:40

Ah... I see now, I'll check this problem.

now i know why i can't set sticky and announcement as my thought!

/* De-announce expired announcments and sticky messages */
$r = q("SELECT k12_thread.id FROM k12_thread INNER JOIN k12_msg ON k12_thread.root_msg_id=k12_msg.thread_id WHERE k12_thread.forum_id=".$forum_id." AND is_sticky='Y' AND (k12_msg.post_stamp+k12_thread.orderexpiry)<".$tm);
while( list($tid) = db_rowarr($r) )
q("UPDATE k12_thread SET ordertype='NONE', is_sticky='N' WHERE id=".$tid);
qf($r);

these code auto delete all sticky and announcement when i post or edit post!

Report message to a moderator

[Message index]

		sticky and announcement bug? By: ezdb on Thu, 29 August 2002 05:35
		Re: sticky and announcement bug? By: Ilia on Thu, 29 August 2002 11:52
		Re: sticky and announcement bug? By: ezdb on Fri, 30 August 2002 01:37
		Re: sticky and announcement bug? By: Ilia on Fri, 30 August 2002 02:40
		Re: sticky and announcement bug? By: ezdb on Mon, 02 September 2002 02:12
		Re: sticky and announcement bug? By: Ilia on Tue, 03 September 2002 02:12
		Re: sticky and announcement bug? By: ezdb on Wed, 04 September 2002 02:10
		Re: sticky and announcement bug? By: Ilia on Wed, 04 September 2002 20:07

Previous Topic:	Trying to to Data Import into newly created forum
Next Topic:	bug in adm/admmassemail.php

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 16:37:38 GMT 2024

Total time taken to generate the page: 0.03481 seconds