Major Additions - SR Classifieds 1.0.5 Light

**Background**

This is a reposting of SR Classifieds 1.0.2 Posted by Gio~logist. I purchased the rights to this script as well as the premium version.

**Copyright**

This script cannot be redistributed, reproduced, or published in any way unless given written permission by myself. Modifying this script and sharing your modification elsewhere without the author's knowledge is not allowed as well. The following text on the script is not to be taken off:

Powered by SR Classifieds
Copyright ? 2007, vBClassified.com

**Before Making An Add on **

Please visit the forum for SR Classifieds at vBClassified.com. The forum is open to discuss issues as well as to provide a place for coders to share their work. By posting there, it will make it easiser for me to monitor the logic and try to ensure that hacks being posted are as safe as possible.

**About This Script **

What does this do?
This hack gives you a classified ad system. Multiple categories can be created and users can post ads in these categories. Other users can then rate them and give them feedback accordingly.

**DEMO **
http://www.vbclassified.com/sr_classifieds.php

What features does this hack provide?

• Main page with statistics, categories, recent activity, etc.
• Ability to arrange ads in categories
• Categories can have their own images
• See how many total, closed, and open ads are in each category.
• Ratings and category counts are automatically rebuilt
• After the timeframe of the ad is up, the ad is closed
• Add new classified ads with images, description, title, and more!
• Users have their own page where feedback and such shows.
• Paypal button is automatically generated if the user enters a paypal email address. Clicking this button will allow the user to buy whatever the other user is selling.
• Add extra fields to ads
• Ability to edit and delete ads
• Control everything from the amount of results showing per page in searches, to the size of thumbnails.
• GIF, JPG, and PNG images are supported.
• Search through ads
• And much much more!

What does this hack require?
Template Edits: 3
Products Imported: 1

6 Easy Steps
Step 1. Import the following product: product-sr_classifieds.xml
Step 2. Upload the files in the upload folder.
Step 3. CHMOD the sr_classifieds/uploaded folder and sr_classifieds/uploaded/thumbnails folder to 777
Step 4. Do the edits located below
Step 5. Update newly added usergroup permissions and options
Step 6. Enjoy the hack.

**THE ORIGINAL THREAD**

I have asked that the old thread be removed because I can not update that thread and it is impossible for me to support the product there. I have made a PDF file which is at the following PATH that hs all of the information from Gio's original thread in case anyone needed to see old issues that were reported.

http://www.vbclassified.com/sr_class...inalthread.zip

**UPDATES**

Feb 1 2007 3:30 PM EST
Version 1.0.4.

Changes:

Replaced Paypal payment forms in category and search listings and replaced it with icon.
Added code to allow seller or Admin to CLOSE and REOPEN ADS
Added new PayPal button along with paypal FORM to inside the listing
Made Paypal link so it is only visable when the listing is open
Cached 'sr_classifieds_viewad_extra_fields' template
Added code to send PRIVATE MESSAGE in addition to e-mail to seller

Feb 3 2007 1:00 AM EST
Version 1.0.5.

Changes:

Fixed Cron, sr_classifieds.php, and templates so that CLOSED ads is always "0" (Script used 0 and 2 before)
Fixed code to Open and Close ads to update category counts
Fixed layout of category display
Made closed Ads show "CLOSED" in time column instead of negative numbers.
Fixed layout issues in View Ad template
Added NEW Cron that will delete listings, uploaded images, and image table from database after ad has been closed for 90-days
NOTE - Webmasters can edit 90-days in the new CRON FILE (Line is adequately commented!)

[IAWBody]

This is just a suggestion, something that I wouldn't mind. Is there anyway that the users that start an ad can put a link to their ad in their signature? Or some way of automatically putting a link in the postbit, or signature area?

How else are people going to know there are new classifieds in the SR Classifieds? Besides clicking on SR Classifieds in the Navbar every time they visit the forum?

Otherwise I think this is a really awesome mod! I have replaced my classifieds forums for this!

[auctionguy]

Are you going to have the ability to have a multiple item ad or an inventory in an ad in the future?? Is it even possible?? What I really need myself is an ad that I can sell one particular thing that never goes away when someone buys it so that it can be sold again and again without having to relist the ad!

[KSMatic]

nm guys, i fixed it by reinstalling the product. It was weird.

[KSMatic]

Originally Posted by dizzy100

OK solved

Create a plugin and hook it to global_start (i wanted my ads to appear at the top of every forum),

Insert the following code

$newads_get = $vbulletin->db->query_read("
        SELECT classified.classifiedid AS classifiedid, classified.categoryid AS categoryid, classified.userid AS userid, 
        classified.dateline AS dateline, classified.timeframe AS timeframe, classified.title AS title, classified.price AS price, 
        classified.type AS type, user.*,
        upload.classifiedid, upload.image AS image
        FROM " . TABLE_PREFIX . "sr_classifieds AS classified
        LEFT JOIN " . TABLE_PREFIX . "sr_classifieds_uploads AS upload ON (upload.classifiedid=classified.classifiedid)
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid=classified.userid)
        ORDER BY dateline DESC
        LIMIT 7
    ");

    while($newad = $vbulletin->db->fetch_array($newads_get)){
    $newad[dateline] = vbdate($vbulletin->options['dateformat'], $newad['dateline'], '', '');
    eval('$newadbit .= "' . fetch_template('sr_classifieds_newadbit') . '";');
    }

The RED is how many new Adverts you wish to list.

The add in your NAVBAR template (At the bottom)

<table cellpadding="5" cellspacing="$stylevar[sellcellspacing]" width="100%" >
<tr><td colspan="7" class="thead">Latest Classified Ads</td></tr>
<tr>
$newadbit</tr>
</table>

Hope that helps somebody.

EDIT. I changed mine to display in just FORUMHOME (paste the last bit of Code under $navbar in FORUMHOME) and modify the hook on the first to forumhome_start). Seems better

nice script, I tried this but it shows on a new ad per row, anyway to make it show on the same row?

Like right now it has a huge space on top with 5 ads while the sides are all empty

[akulion]

is there a way to use this for adverts for penpals/e-pals as well?

I mean some adverts are FOR SALE, BUYING etc...but then 2 categories are E-PALS and PEN PALS and these 2 dont contain the payment options but other options

would this be possible?

[jellybaby]

I wonder if anyone can help. I have the problem that when someone has bought an item the item bought is still staying live and can be bought again

How do I end the sale on purchase?

Thanks

[KSMatic]

Originally Posted by jellybaby

I wonder if anyone can help. I have the problem that when someone has bought an item the item bought is still staying live and can be bought again

How do I end the sale on purchase?

Thanks

probably have to do it manually. The non-light version which cost 49.99 will have this feature.

[imported_Alpine]

Has anyone managed to put them side by side rather than down the page.

Like the photoplog ones on ForumHome.

[dizzy100]

Originally Posted by KSMatic

nice script, I tried this but it shows on a new ad per row, anyway to make it show on the same row?

Like right now it has a huge space on top with 5 ads while the sides are all empty

try editing your

sr_classifieds_newadbit

and replace its contents with

 <td><a href="sr_classifieds.php?do=ad&id=$newad[classifiedid]">
<img src="$vboptions[bburl]/sr_classifieds/uploaded/thumbnails/$newad[image]" border="0">
</a></td>

This is from memory though as i no longer use the mod, far too buggy. This should however, if your using the code i posted, align them next to each other.

[imported_Alpine]

That worked lovely for my Forum home, But now the prob is reversed in the Actual Classified section, Looks like I will have to live with it,



Can someone please post up the original sr_classifieds_newadbit code, As per the instructions above I over wrote it and the disk I saved it on is corrupt.