Latest X new threads on forumhome (not so advanced)

Here a nice new hack Follow the txt and it will work

[Dutchy]

Thanks Niels,

Just the one i need ;-)

[Senna]

little question Niels, does it show you links to post in sections you normally can't see?
(wouldn't be too good if everyone saw what is happening in the modlounge or so or when mods talk about certain members :p)

Originally Posted by Ike013

little question Niels, does it show you links to post in sections you normally can't see?
(wouldn't be too good if everyone saw what is happening in the modlounge or so or when mods talk about certain members :p)

Mmm look like I've been stupid again :o

[Senna]

nah, I allready made the same mistake :p

Originally Posted by Ike013

nah, I allready made the same mistake :p

Anyway here is my fix replace the plugin with this code:

You must first be a registered member to view any code.

Picked it from search.php :knockedou

Edit:
if you want to show that threads wich can't be searched but can be viewed remove this:

You must first be a registered member to view any code.

[ruizit0]

hi.
i tryied to add this hack but .. .
when i active the plugin this happen

There seems to have been a problem with the Trancepsicadelico Forum database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM thread ORDER BY threadid DESC LIMIT 0,5;

MySQL Error : Table 'ddesign_forum.thread' doesn't exist
Error Number : 1146
Date : Saturday, October 8th 2005 @ 03:56:47 AM
Script : http://ddesign.org/forum/index.php?
Referrer : http://ddesign.org/forum/admincp/index.php?do=head
IP Address : 21*.1*9.**1.***
Username : **************
Classname : vb_database

MySQL Error : Table 'ddesign_forum.thread' doesn't exist

dont get the point .. . also tested with plugin code correcion and the same happens...
why?

[Gold_Hunter]

Originally Posted by ruizit0

hi.
i tryied to add this hack but .. .
when i active the plugin this happen



MySQL Error : Table 'ddesign_forum.thread' doesn't exist

dont get the point .. . also tested with plugin code correcion and the same happens...
why?

change

You must first be a registered member to view any code.

to

$threads = $db->query_read("SELECT * FROM your_forum_thread_table WHERE open = '1' $ja ORDER BY threadid DESC LIMIT 0,$number");

or try :

You must first be a registered member to view any code.

Originally Posted by Gold_Hunter

change

You must first be a registered member to view any code.

to

$threads = $db->query_read("SELECT * FROM your_forum_thread_table WHERE open = '1' $ja ORDER BY threadid DESC LIMIT 0,$number");

or try :

You must first be a registered member to view any code.

This will work for you:

You must first be a registered member to view any code.

I'll add the table prefix as soon as possible to my hack Sorry for that.

[ruizit0]

ahhhh .ii see the lighttt!! :p
. i discovered why the hack give that error. . .
when i installed the forum .. in config.php i set a prefix for tables "forum_"
is why all hacks give me that error :S
i made a fresh install without the table prefix and the hack works already with the original code :p
thnaks Gold_Hunter

yes Niels .. its a god point to add it.. .for now im fixed .. fresh install with no prefix.
but im at the beggining of my board.. maybe some people couldnt do a fresh install like i did..

but in 3 hacks in this site they all give the same prefix error. .no one suport it errr ...

well problem solved thanks all