Integrating classifieds question

[jtorral]

I run a forum with vbportal for a front end.
www.rangefinderforum.com

i would like to be able to show recent ads in the forum or on the front page. I could create a block for recent ads but how would I show them? Any ideas?

[Chuck S]

Our classifieds software has an inc_ads.php file. You could setup a center block in vbportal and include the file and echo the variable $classifiedsfeature to show the block.

[jtorral]

chuck, thanks for the heads up.

It partialy works. It shows the block with a title of "Featured Ads" but no pictures or content.

[Chuck S]

Remove this line in the file

Content visible to verified customers only.

[jtorral]

does not exist anywhere. i just did a

grep -i "Content visible" *.php

and nothing.

I also did from pp root

find . -depth -exec grep -i "content visible" /dev/null {} \;

[Chuck S]

You sure you are looking in our inc_ads.php file. That line explicitly does exist at line 110 of that file.

[jtorral]

below is line 110 and then some. look at the last line. its my vi info

while (list($pid,$puser,$puserid,$pcat,$ptitle,$product,$views) = mysql_fetch_row($result)) {

if ( $ViewPerm[$pcat] == 1 ) continue;

if ( cl_is_image($product) ) {
$temp_user = $puserid;
$productlen = strlen($product);
$theext = cl_get_ext($product);
$product_name = str_replace( $theext, "", $product );


$thumbtag = "{$cldata_dir}{$pcat}/thumbs/{$product}";
$image_stats = getimagesize( $thumbtag );
$width = $image_stats[0];
$height = $image_stats[1];

if ( $height > $width )
@
"inc_ads.php" 200 lines --55%-- 110,1 56%

[Chuck S]

Line 110 of our supported file in the download of classifieds is the line meantioned however the line I am telling you to remove is right there in your file although possibly line 113 of your file. You see it above remove the line.

Content visible to verified customers only.

[jtorral]

I just downloaded this the other day. would you like to log in?

[Chuck S]

Line 110 is the line I have posted in this thread. Just remove the line if you want to run this block in vbportal. The block works as supported on the vbulletin forumhome as coded. To use in vbportal though you need to remove the viewperm line

[jtorral]

chuck. I have just unzipped the zipfile again. looking at inc_ads.php there is no line that says.

Content visible to verified customers only.

Are you sure you dont want to look. you dont need to fix anything, just see for yourself.

JT

[jtorral]

here is the entire content of inc_ads.php straight from the zip file.

Content visible to verified customers only.

PLEASE DO NOT POST OUR CODE TO THE OPEN PUBLIC -- I have wrapped it in a code tag for you

[Chuck S]

Your not seeing the code I am posting because your not a verified customer hense your not looking for the correct line in the file since you can not see what I am posting. Read this thread to verify yourself

http://www.photopost.com/forum/before-you-buy/announcements.html

[Frank Woolf]

Hi Chuck,

I have been trying to get this working for a while. I am using vbPortal and have deleted the line as per your instructions.

I used the following code in the vbPortal module:
echo require "../classifieds/inc_ads.php";

When I preview I get these errors:
Content
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/asia/public_html/classifieds/inc_ads.php on line 56

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

[Frank Woolf]

Tried lots of variations including this one:
@include('/home/asia/public_html/classifieds/inc_ads.php');
print $classifiedfeature;

This does not return errors but dose not show anything on the page either.

If I remove the @ I get errors.

I just discovered that adding an s to make it $classifiedsfeature makes the module header show up on the page but there is no content

[Chuck S]

If you get mysql errors your issue is this as noted in the instructions for applying the inc_ads.php hack.

If you have PhotoPost and vB in different databases, you'll need to scroll to the script and uncomment the mysql_select_db() command (on line 26) and insert your Classifieds database name and uncomment the mysql_select_db on line 310 and add your vB3 database in quotes. If your username password is different to connect to the databases then you will need to uncomment the $link statement and fill in the proper variables for the host username and password to access the photopost database

[Frank Woolf]

Sorry I should have mentioned that vbPortal, vBulletin and PPClassifieds are all using the same database with vbp_ vp_ and pp_ prefixes.

My test page (link below) shows all is working together including skins but I can't get the ads from PPClassifieds to show (at the bottom of the page).
http://www.asia-classifieds.com/modu...ndex&name=test

[jtorral]

comment out this line of code.

if ( $ViewPerm[$pcat] == 1 ) continue;

[Frank Woolf]

Thanks but I already took out the line as per Chuck's advice earlier in this thread.

I looked at your site and was going to ask how you did it but removing the line of code did not solve the problem for me.

[Frank Woolf]

It might help to see what the errors are if I take out the @

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

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