Random Thread

[GWLiaR]

English:
What Does it?:This hack will add to Navbar Random Thread :).

Install:
+Go to admin Cp
+Plugin System -> Manage Products -> [Add/Import Product] -> Select
+'product-random_thread.xml' then İmport.

Find Navbar:
<if condition="$show['pmwarning']"><div><strong><phrase 1="$vbphrase[pmpercent_nav_compiled]">$vbphrase[your_pm_box_is_x_full]</phrase></strong></div></if>Add Below:
$rthreadMark As Installed (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=193061)

[GWLiaR]

*Reserved

[TilkiBey]

pls renew ur ss with supporting file types (jpg,jpeg etc.)

bmp desteklenmiyor inferno,direkt g?z?kmesi daha hoş olur demo g?r?nt?n?n;)

[GWLiaR]

pls renew ur ss with supporting file types (jpg,jpeg etc.)

bmp desteklenmiyor inferno,direkt g?z?kmesi daha hoş olur demo g?r?nt?n?n;)

D?zelttim..
Added JPEG Demo :)

[NAZIA]

reserved...

[noppid]

That query will/could bring a forum to it's knees running every page view.


mysql> explain Select * From thread order by rand() DESC LIMIT 1
-> ;
+----+-------------+--------+------+---------------+------+---------+------+------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+------+---------------+------+---------+------+------+---------------------------------+
| 1 | SIMPLE | thread | ALL | NULL | NULL | NULL | NULL | 6026 | Using temporary; Using filesort |
+----+-------------+--------+------+---------------+------+---------+------+------+---------------------------------+
1 row in set (0.03 sec)



As you can see, a full table walk.

Here's a better way.


60*60 == 3600
3600*24 == 14400
14400*30 == 432000
1223479602 - 432000 == 1223047602

mysql> explain Select * From thread where dateline >= 1223047602 order by dateline DESC limit 1;
+----+-------------+--------+-------+---------------+----------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+-------+---------------+----------+---------+------+------+-------------+
| 1 | SIMPLE | thread | range | dateline | dateline | 4 | NULL | 104 | Using where |
+----+-------------+--------+-------+---------------+----------+---------+------+------+-------------+
1 row in set (0.00 sec)



See the difference? Gotta use those indexes. Rand() is bad.

[ahtapod]

It runs wrong.

When used, it transfers users to wrong thread. :(

[MrZeropage]

Attention - this does not take care of hidden forums or forumpermissions, means it could also bring up a thread from your internal hidden administrator-forum...

[noppid]

Add "AND forumid not in(1,2,3)" to the query.

This hack needs a lot of work.

[yousellstuff]

whats the point of this

[tirol07]

D?zelttim..
Added JPEG Demo :)

bi sorum olacaktı arkadaşım bunu vb sayfası hari? g?sterme imanımız varmi?

Mesela vbulletin haric bir sayfada 5 rastgele konu g?stermek istiyorum! m?mk?nm? bu?

[GWLiaR]

bi sorum olacaktı arkadaşım bunu vb sayfası hari? g?sterme imanımız varmi?

Mesela vbulletin haric bir sayfada 5 rastgele konu g?stermek istiyorum! m?mk?nm? bu?
Evet M?mk?n...Mysal ile Yapabilirsin:)

[tirol07]

Evet M?mk?n...Mysal ile Yapabilirsin:)

Peki nasıl yaplıyor bu mysal dediğin?

Detaylı anlatabilirmisin sana zahmet, ?ok uğraştım yapamadım?

[KrisP]

It runs wrong.

When used, it transfers users to wrong thread. :(

In plugin change

$ryaz.="<a href=showthread.php?p=$veri[threadid]>$baslik</a>";

to

$ryaz.="<a href=showthread.php?t=$veri[threadid]>$baslik</a>";

[Brandon Sheley]

It would be handy if this worked properly, I could use it.
Does anyone know of a 3.8 version?

PS... I think the rules say you have to speak in english, or at least have an english version.

[valdet]

Sorry to bump this thread.

That query will/could bring a forum to it's knees running every page view.


mysql> explain Select * From thread order by rand() DESC LIMIT 1
-> ;
+----+-------------+--------+------+---------------+------+---------+------+------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+------+---------------+------+---------+------+------+---------------------------------+
| 1 | SIMPLE | thread | ALL | NULL | NULL | NULL | NULL | 6026 | Using temporary; Using filesort |
+----+-------------+--------+------+---------------+------+---------+------+------+---------------------------------+
1 row in set (0.03 sec)

As you can see, a full table walk.

Here's a better way.


60*60 == 3600
3600*24 == 14400
14400*30 == 432000
1223479602 - 432000 == 1223047602

mysql> explain Select * From thread where dateline >= 1223047602 order by dateline DESC limit 1;
+----+-------------+--------+-------+---------------+----------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------+-------+---------------+----------+---------+------+------+-------------+
| 1 | SIMPLE | thread | range | dateline | dateline | 4 | NULL | 104 | Using where |
+----+-------------+--------+-------+---------------+----------+---------+------+------+-------------+
1 row in set (0.00 sec)


See the difference? Gotta use those indexes. Rand() is bad.

Can you please let me know how would I optimize this query so it doesn't overload the database as much as with rand() function.

Also how to add the limitations so it does not opens threads from private forums?

Thanks