Help with a couple queries please
 

The above code works fine and prints out code when the user's status is active and their available impressions is at least 1. I want to modify it to also check if the user has posted within the past 24 hours. I don't know how to though as I am using my own table in the vbulletin database to store the banner information. As you see above the query that fetches the data I need is querying from the table banners. From my knowledge I would need to fetch the last post time from lastpostdate in the user table. But how would I add this to my query so all three of these are factored in when it gets the one random array ($banner[]) from the banner table?



This query is the one that gives users impressions upon new post. I would like to change it so that it gives a different amount of impressions according to whether it's a new post or a new thread. How would I go about doing this?

Is there nobody who can help with this. I am totally stuck (especially on the first hook).

Can someone at least tell me where the second hook is located (userdata_postsave)? I might be able to find out how to code the second oen myself if I knew the php document that this hook was in.