Need Code for block to pull Random Ads from my Classifieds

Worker Joined: Jan 06, 2009 Posts: 183

I tried a search and didn't quit find what I’m looking for. I tried to see if I could look through some of the other pre-installed blocks that display random headlines etc. But, I just couldn't decipher it.

So, what I’m trying to do is make a block that shows for example: Random Ad listings from my classifieds DB or just the last few new listings will work to.

I was hoping to be able to figure this out on my own by looking at already made blocks and just changing the DB tables that was being pulled. But, being a noob to this still; I hope that someone here could help me out.

Thanks for any help on this,
Rick Leigh

Posted: Tue Jan 27, 2009 2:23 pm

Are the classifieds DB tables in the same DB as the nuke tables?

Posted: Tue Jan 27, 2009 2:47 pm

No, the classifieds are in its own DB.

Posted: Tue Jan 27, 2009 2:56 pm

Then changing the tables that a block pulls won't work because it will be trying to pull them from the wrong database.

Posted: Tue Jan 27, 2009 3:00 pm

could there be a config file like the one for the donate-o-meter to tell it which DB to pull from?

Posted: Tue Jan 27, 2009 3:22 pm

I don't know how the classfieds script works, but you would need to incorporate it into the block.

Posted: Tue Jan 27, 2009 3:37 pm

It was a purchased script so I'm not sure what I'm allowed to post without getting into trouble. the creator is no longer around to get support. Their forums are down and the site acts like its been taken over by melware so I don't want to post it for anyone to get their computer messed up.

Posted: Tue Jan 27, 2009 3:40 pm

If you can setup an RSS Feed on your Classifieds site, you could display that feed in a block on your main site using nukePIE™

Posted: Tue Jan 27, 2009 3:51 pm

OK it will be difficult for anybody to advise without seeing the code.

Have you considered using the Nuke Classifieds module?

Posted: Tue Jan 27, 2009 3:51 pm

thats an idea; ill have to look into that