[BLOCK] Unanswered Topics Block

[JPDeni]

Thank you for posting it! Now I can access the topic, but I appreciate your passing on the information when I couldn't.

[alhaudhie]

One thing..

when i change

Code Select Expand

$number_to_display = 2; // Change this if you want a different number to display. Use 0 to list all of them.

The number 2 to 1 - thats give me soo much topics iin block. not only 1

[JPDeni]

Rather than using the variables, just use the values in the code:

Code Select Expand


$query = db_query(
"SELECT m.subject, t.ID_TOPIC
FROM {$db_prefix}topics as t, {$db_prefix}messages as m, {$db_prefix}boards AS b
WHERE t.numReplies = 0
AND t.ID_FIRST_MSG = m.ID_MSG
AND t.ID_BOARD = b.ID_BOARD
AND $user_info[query_see_board]
ORDER BY RAND()
LIMIT 1", __FILE__, __LINE__)


[shengton]

I have "Reported Posts" and "Reported Messages" sections. All reported posts and messages are included in the block. What code should I add so that it won't be included anymore in the block.

Hope you can help me with this.

Thanks and God bless.

[JPDeni]

I just looked over the SMF code and when a post is reported to a moderator, nothing is written to the database. If the information isn't stored, it can't be retrieved, so what you're asking for isn't possible without a substantial modification to SMF. That would be beyond my ability.

[alhaudhie]

tq.. nice work.

How about we add overflow sroll.

Like i want to put 50 posts but i want it show only 5 post. Others 45 post we must scroll it down to look it.

[JPDeni]

You can probably work out how to do that if you investigate css. Lots and lots of stuff about that on the 'net.

[alhaudhie]

Can we use like useronline code...

Code Select Expand

<div style="width: 100%; ' , $online['num_users']>14 ? 'height: 23ex;overflow: auto;' : '' ,'">';

[JPDeni]

Why don't you give it a try?

[alhaudhie]

i try this... but not success...

Code Select Expand

echo   ' <div style="width: 100%; ' ' <img src="http://tbn0.google.com/images?q=tbn:pQBIIcIWd2dZQM:http://i.pbase.com/u16/sutha/upload/5123820.bullet.jpg" /> <a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '">' . $row['subject'] . 'height: 23ex;overflow: auto;' : >';