showthread_query hook sql

[Andreas]

[sql]SELECT user.userid, banners.title, banners.ext, banners.width, banners.height
FROM " . TABLE_PREFIX . "user AS user
INNER JOIN " . TABLE_PREFIX . "bannners AS banners USING (userid)
WHERE user.lastpost > UNIX_TIMESTAMP(NOW())-86400 AND banners.status = 'active' AND banners.available >= 1
ORDER BY RAND()
LIMIT 1
[/sql]

If this is what you want.

[Nullifi3d]

Nevermind. It was a simple fix, just had to replace the decimals with commas. I didn't look at the code close enough the first time.

[Andreas]

I don't know why I had "." instead ",", but should be fixed now.

[Nullifi3d]

Yea I saw that right after I posted. Thanks for the code it works. You're the greatest!