PhotoPost Classifieds... Random or Most Recent ads on Front Page of Vbulletin?

Chris@TSE · October 31st, 2005, 06:09 AM

Is there a way to display recently added or random photopost classifieds products on the main forum display in vbulletin?

If so... How?

thanks so very much!

Chuck S · October 31st, 2005, 06:44 AM

Hello

You can use this file linked here in conjunction with our Classifieds Product

http://www.photopost.com/members/for...89#post1114289

Chris@TSE · October 31st, 2005, 09:24 AM

You've got mail

Chuck S · October 31st, 2005, 10:33 AM

Hello look at the instructions you need to uncomment the $link and mysql_select_db statements and fill them in correctly

That would be your issue

Chris@TSE · October 31st, 2005, 10:57 AM

actually... no. I did this yet it did not work and undid the changes hoping for professional assistance

I re-installed the modifications and my issue is this:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/inc_ads.php on line 56

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /classifieds/inc_ads.php on line 108

this is being displayed on the vb forums after your instructions, please advise.

Chuck S · October 31st, 2005, 11:03 AM

Your issue is exactly as I have stated

Chris@TSE · October 31st, 2005, 11:05 AM

well please use the information I emailed you to advise, I uncommented the sections and filled in our DB information yet this is what we are getting

Chris@TSE · October 31st, 2005, 11:07 AM

"uncomment the mysql_select_db on line 310 and add your vB3 database in quotes."

also, I do not see a line "310"

I see what you are referencing at line 192 and I unquoted it and entered our db name. still getting the same error.

Chuck S · October 31st, 2005, 11:10 AM

Do you have the proper table prefix for classifieds entered in your edit integration settings

Chris@TSE · October 31st, 2005, 11:13 AM

im sorry but I do not follow..... please be a bit more "php for dummies"

thank you lol

all I know is I miraculously got it working flawlessly with vbulletin.

this little mod I thought should be a breeze in comparison!

Chris@TSE · October 31st, 2005, 11:19 AM

yes..... pp_

this is probably a simple issue you could spot in a heartbeat, please use the information I provided, im really at a loss as to why this is not working.

the integration with vb works fine, i would think if this was incoreect I would have had many issues before.....

Chuck S · October 31st, 2005, 11:33 AM

Doesn't look to me like you have placed $classifiedsfeature in your FORUMHOME TEMPLATE

Chris@TSE · October 31st, 2005, 11:36 AM

Its showing up now, but rather screwy....

all messed up, red x's in with the thumbnails, bad links........

*pulls hair out*

Chuck S · October 31st, 2005, 11:44 AM

you need to overlay images

redownload the mod and upload the two image files to your classifieds images directory

Chris@TSE · October 31st, 2005, 11:49 AM

what mod? all that was included in your zip was a inc php file.......

which images are you talking about, and how do I get it linking to the right location. right now it is linking the showimage links right off the forum instead of forum\classifieds\ like it should...

so close!

Chris@TSE · October 31st, 2005, 11:58 AM

well I searched for overlay files on google and happened to find something that worked. where they originally came from and why they were set to use it I have no idea. all I know is its working...

I only have two problems...

They are linking to forums\showproduct.php? instead of forums\classifieds\showproduct.php? where it should.

Also, what file do I edit to adjust how the featured ad part is displayed, I'd like to perhaps trim it down a bit for a bettter "fit"

Also, is there a way to change the actual text from "Featured Ads" to something else? Thanks so very much!!!!!!!!!

Chuck S · October 31st, 2005, 12:01 PM

As suggested you would need to redownload the build and upload those files.

You can alter the file itself and changed the wording to match what you want.

Chris@TSE · October 31st, 2005, 12:05 PM

Could you try being a bit more specific? I am obviously not as knowledgable as you, which is why I am asking.....

Download and replace WHAT files?

Alter WHAT file?

It is working fine, no red x's.... but the hyperlinks are pointing one directory back.........

You've been a great help, but I'm trying very hard to understand what you are saying here......

It is like you are not reading my posts.

Chris@TSE · October 31st, 2005, 12:09 PM

again, i fixed the images!

Ill repeat myself.... Please be a bit more specific, I need to know how to edit this so the hyperlinks point correctly

I only have two problems...

They are linking to forums\showproduct.php? instead of forums\classifieds\showproduct.php? where it should.

Also, what file do I edit to adjust how the featured ad part is displayed, I'd like to perhaps trim it down a bit for a bettter "fit"

Also, is there a way to change the actual text from "Featured Ads" to something else? Thanks so very much!!!!!!!!!

Chris@TSE · October 31st, 2005, 12:13 PM

I figured out where to change the name "featured ads" in the inc php file.....

as for fixing the links, i am still clueless..... they still point a directory back