im try to get the last 5 Threads from forums 13/14/15/30

to show up @the top of the site

ive got this code but is fetches last 5 from the complete site

Anyone got any ideas plz >?

err i thought i had posted this already but it seems i hadnt.

Modify a last 5 threads hack would be my thoughts.
have it only pull where forumid = 1 AND forumid = 2
or create an array for foumids

your code says 0 for LIMIT also

might wanna change that if all you want is the last 5

hmm cant seem to find over @vb.org
Ive got a hack already installed for last 5 but it fetchs them from
all the forums & i want from the Races forum to show @the top

& when i know enuff top scanners/pubbers etc..

ok heres a quick and dirty fix

Your talking races which means your prolly using lockdown
Assuming you are using the lockdown from here,

Follow these steps:

in admincp/forum.php

Find:
change to:
Find:
Below add:
SAVE & CLOSE

in includes/init.php

Find:
Change To
Save And Close
I havent looked over this code much yet so cant tell you every instance but
In pax's lockdown you would need to change
for:
Repeat almost all this process

adding an admin cp option for race,
Lets say the option is:
Is this a race option? yes/no

The code above needs to be slightly edited to suit your needs:

Now the last bit of this code where you change paxtrax code is the bit you dont repeat

you need to add more

first alter your lockdown table and new field
raceforum smallint(1) default 0

in functions_newpost

ADD:

[/php]
if ($foruminfo['race'])
// assuming you have used race as your admin set option
{
$raceforum = 1;
}
[/php]

in the lockdown code same file find:

replace with

Ok thats the first bit overwith

now you want to retreive only your last 5 races in your index.php

somewhere near the end of the file

add the following:

in forumhome you would call $last5race
in last5race template you would call $last5racebits
last5racebits would look simmilar to below:
damn diddnt realise it was that big lol
Enjoy! hack pretty much written for you lol

thnx man u rock

yea im using pax lockdown but its heavly modded by some dude

I would advise adding a release field to lockdown,
Do that and with some work you can have last 5 races + mirrors.
As it is your gonna have to do some work to prevent you ending up with 5 threads that contain the same stuff as your race threads.

Other ways I guess would be a forum where the first post of a release is posted and no one else posts that release there lets call it 0-Sec forum ;) and then a normal forum for every other post of it.
Then you use raceforum only on the 0-Sec forum.

Grrr fscking errors

the line is
/me Sighs

would it not be easyer if i just grab the last 5 tops from forum id X & X ?
like the top5 hack does but im not sure how to get from the spefic forum

did you add the extra field to the lockdown ?

quote:
first alter your lockdown table and new field
raceforum smallint(1) default 0

Yes its possible to do what you say but again your going to have to do some work to prevent you just getting the last 5 threads.

Lets assume user 1 posts bla-RELEASE and user 2 also posts bla-RELEASE but 5 mins later
but in your last 5 races it would show as race1 and race2
add the extra field for release name and you could prevent that and at the same time you could create a mirrors hack.


oh btw getting from specific forum is simply
select form thread
WHERE forumid = 1 OR forumid = 2

yeah i inserted the table

* LiquidIce thinks lol

Attached Images

untitled.JPG (47.4 KB, 36 views)

try :
the space in working bothers me watch out for that.

I posted withought but here it has one make sure if you copy and paste you dont end up with a space there.