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!)

[blind-eddie]

Are you going to admincp via mod or admin....you need admin, also go to usergroups/Administrator Permissions...edit your permissions..see if that helps

[aktifnet]

good.

http://www.isimticaret.com/sr_classifieds.php?

[Merriweather]

Originally Posted by Merriweather

QuarterBore ~ Is there no way for a user to easily see all of the ads they've created? I've been looking around, but can't find anything. I believe this is a very important feature to have because when someone sells something, they should be able to quickly get back to their ad without having to remember where they posted it, etc.

Also, I've noticed that when you view an ad, it does not tell you anywhere on the ad what category you are in, nor does it give you a breadcrumb link back to that category. Is this something that could be added with a simple template change?

QB, are you still around?

[dizzy100]

Does anybody know how to display the latest advertisements on the forum home page ?

I've tried creating a plugin with the following -

PHP 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 $newadlimit
    ");

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


I enabled that under the forumhome_start hook and then added

PHP Code:

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


In my FORUMHOME template but i get an SQL error. What am i doing wrong ?

[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

[dizzy100]

Has anybody managed to get pagination working in this plugin ?

[joiner42]

how do i change the $ sign in paypal to the £ sign when i get to the payment page on paypal i get the $ sign instead of the £ sign

[blind-eddie]

in your admincp/srclassifieds

[touba]

hi all, i have a problem with date in my sr_classifieds page.

each date (joined date and created ads date) have a % before number :
ex : %08/%10%2006

why ?

what can i do ?
thanks for your support ! :up:

[RedGTiVR6]

Is there a version check URL?