i looked at your code kura.. the way is set now will also show to everyone the posts made in a private forum (if you have a private forum). you need to add some perms in there... just a thought.

you cant have only 2 queries because for every thread it will do one. so if it shows 10 threads or posts, you will have 10 queries.. and so on...

That's nonsense.

It takes 1 query to extract the firstposts of X amount of different threads on the newsforum you specify, and 1 query to extract all the threads-overview info.

You can increase the amount of newsposts listed, but it won't affect the query count.

Nakkid, if you read post #8 in this thread, you'll see that I already commented on that. :)

(I'm not capable of adding permissions myself yet, still too much of a n00b for that, but I'm working on it :))

try this for perms:
https://vborg.vbsupport.ru/showthrea...threadid=38355

i didnt test it, i just put it togheter... let me know if it can help you out. :)
about the queries.. if i'm correct, for every thread,forum that is checked the script will perform a query. the more forums you have the more queries you will add, etc. goes the same way with the threads. i know element that have an impressive 108 queries on his page. over 40queries your server gets on its knees if it's a busy board..

Thanks, I'll have a look into it and see what I can work out. :)

:up:

No, that's only the case if you run two queries per output, one to select the forum and thread, one to extract the post.

However, my query (in the newsportal.php file) uses a JOIN so that it can extract as many firstposts from a single (or multiple, if you want) forum, with only 1 single query. The JOIN worked perfectly fine in phpMyAdmin, but it seems to have a random bug when put in use through vB itself. It's still just 1 query though, trust me. :)

ok. thanks for the info. :)

Kura does it like we wish all of those type of scripts were made. Efficient. Nice example for vBportal etc.

Yeah I've seen a vbPortal site that had 199 queries run. :eek:

[high]* KuraFire goes dive into adding permissions to this script, now.. :)[/high]

we all know that VbPortal sucks :)

I think your script is pretty nice man ;)
I like VbIndex a bit more (when you edit it well :D) because of it's menu...
oh, well, yours is cool too, if you don't have a high-end server ;)