problem query?

[N!ck]

SELECT thread.*, forum2.usergroupid FROM thread LEFT JOIN forumpermission AS forum2 ON (forum2.forumid = thread.forumid) WHERE forum2.usergroupid < 5 ORDER BY lastpost DESC LIMIT 30


This returns no results. There ARE threads in forums which aren't private. How can I modify this to make it work?

[TECK]

nick, please always post more details about your problem. nobody could solve properly a request or give help if the information is incomplete.

what you try to do? what is the exact segment of code you want to insert? and where?

your AS is not on the right place.

[N!ck]

mind telling me where it SHOULD go then? >:(

if my information is not sufficient, don't reply

[TECK]

i want to help. but if you dont help me help you, i cannot do more.

all the best,
nakkid.

[kreftt]

he tries to include a query that excludes private forums from this hack he posted:

https://vborg.vbsupport.ru/showthread.php?s=&threadid=36008