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

[Fabsboards]

Please consider adding sub categories to the next release.

[websiteking532]

wat a great mod but ian gettin the following error

[EmpireZ]

You need to set the user permissions in the admincp>usergroups.

[Expat]

I can't delete ads, but can edit them. I'm getting a java script error on the page.

[Fungsten]

Installed.

Question. Do you have to install the "Scheduled Tasks"? I prefer to not have an automatic closing of the threads. Thanks.

[Mazoo]

I'm running version 3.6.8 and I'm getting this error ..
could you advice a soulution ?

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_sr_classifieds AS phrasegroup_sr_classifieds,
language.phrasegroup_threadmanage AS phrasegroup_threadmanage,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_autopm_title AS phrasegroup_autopm_title,
language.phrasegroup_autopm_text AS phrasegroup_autopm_text,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 5, user.languageid))

WHERE user.userid = 168;

MySQL Error : Unknown column 'language.phrasegroup_sr_classifieds' in 'field list'
Error Number : 1054
Date : Saturday, September 15th 2007 @ 01:52:29 PM
Script : http://www.cksu.com/vb/sr_classifieds.php
Referrer :
IP Address : 87.101.158.83
Username :
Classname : vB_Database

[abjds.com]

I'm using this on my forum and so far it's working pretty well. However I'm having one small problem.

On a user's "feedback" page it lists their location. I want to add this to each "ad" page so that their location shows along with every ad, as I have international users who want to know where they're paying for shipping from without having to look the user up each time.

In the "feedback" template this is done like this:

<if condition="$user[field2] != '' ">
<div style="background-color:$stylevar[alt2_bgcolor]" class="smallfont">Location: $user[field2]</div>
</if>

So I figured to replicate this on the "ad" page, like so:

<if condition="$user[field2] != '' "><tr>
<td class="alt1">Location:</td>
<td class="alt2">$user[field2]</td>
</tr></if>

The problem is, it doesn't work. If I remove the 'if' conditional it shows the table row correctly with the word 'Location:' but doesn't show their location. So somehow it's just refusing to call $user[field2].

Does anyone have any idea why this might be? I just can't figure it out. I thought user profile fields could be called just about anywhere and since it works on the "feedback" page I don't understand why it doesn't work on the "ad" page as well.

Any help that anyone can provide would be greatly appreciated.

[pspmaster93]

great mod! but theres just one thing i need help with...



how can i change the unknown thing to say last activity @ "site name" shop instead of unknown location

[petacat]

Hello, I am looking to use something like this to run an internal classified/auction in a forum that is attached to an online game. We DO NOT want players to exchange real money but we do want them to exchange in-game items. There are basically three classes of items that are tradeable.

The question is ... can I take this hack and modify it or work with you to do it? I expect there would be a large but un-lucrative market for this :P

[ChU v2]

Just wondering if this version or the paid version on your site supports major credit cards? Or is it all PayPal only.

Also, can you do advanced searches like search by ISBN for a book?