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

[centralss]

I get this error message as soon as I try to import this to vBulletin version 3.5.4.

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Get Editor', 'editor_toolbar_start', 'if ($forumid == \'sr_classifieds\')\r\n{\r\n global $setting;\r\n $setting[\'allow_bbcode\'] = \'1\';\r\n $show[\'img_bbcode\'] = $setting[\'allow_imgcode\']; \r\n $toolbartype = $setting[\'allow_bbcode\'] ? is_wysiwyg_compatible(-1, $editor_type) : 0; \r\n $show[\'wysiwyg_compatible\'] = (is_wysiwyg_compatible(2, $editor_type) == 2);\r\n $show[\'editor_toolbar\'] = ($toolbartype > 0);\r\n $editor_template_name = ($toolbartype ? \'editor_toolbar_on\' : \'editor_toolbar_off\');\r\n\r\n}', 'sr_classifieds');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Tuesday, January 30th 2007 @ 06:37:31 PM

[akulion]

is the demo site running classifieds pro or lite?

because I find that many mods show a demo of the real deal and u end up with something else so asking beforehand

[blind-eddie]

Its running both, the link just takes you to lite version.
I am running the lite version of this mod on my site, Its only been active a few days, but seems to work just fine.

[akulion]

cool im installing as we speak

[akulion]

hi

i have a question

i want to place a sign (preferrably a graphic) BEFORE the adverts categories and the adverts themselves

what i wana put there is: DISCLAIMER: We do not take responsibility for any deals made via this website, we only offer an advertising fascility, the individual dealings and their mode is up to the users disgretion"

how can I do this?

[blind-eddie]

An image, Im not sure, but, Your can add text with ease.

admincp/vBulletin Options/SR Classifieds in Your advertisement code box add disired info to be added, click save, open classifieds and you will see it, look at my site.

[akulion]

aahh thanks

[Rickie3]

Originally Posted by centralss

I get this error message as soon as I try to import this to vBulletin version 3.5.4.

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Get Editor', 'editor_toolbar_start', 'if ($forumid == \'sr_classifieds\')\r\n{\r\n global $setting;\r\n $setting[\'allow_bbcode\'] = \'1\';\r\n $show[\'img_bbcode\'] = $setting[\'allow_imgcode\']; \r\n $toolbartype = $setting[\'allow_bbcode\'] ? is_wysiwyg_compatible(-1, $editor_type) : 0; \r\n $show[\'wysiwyg_compatible\'] = (is_wysiwyg_compatible(2, $editor_type) == 2);\r\n $show[\'editor_toolbar\'] = ($toolbartype > 0);\r\n $editor_template_name = ($toolbartype ? \'editor_toolbar_on\' : \'editor_toolbar_off\');\r\n\r\n}', 'sr_classifieds');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Tuesday, January 30th 2007 @ 06:37:31 PM

this hack is for 3.6 thats why you got that error but if you had read this page https://vborg.vbsupport.ru/showpost....17&postcount=2
you can install it with no problems:up:

[Quarterbore]

Sorry, I didn't get notice of posts here...

Originally Posted by centralss

I get this error message as soon as I try to import this to vBulletin version 3.5.4.

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Get Editor', 'editor_toolbar_start', 'if ($forumid == \'sr_classifieds\')\r\n{\r\n global $setting;\r\n $setting[\'allow_bbcode\'] = \'1\';\r\n $show[\'img_bbcode\'] = $setting[\'allow_imgcode\']; \r\n $toolbartype = $setting[\'allow_bbcode\'] ? is_wysiwyg_compatible(-1, $editor_type) : 0; \r\n $show[\'wysiwyg_compatible\'] = (is_wysiwyg_compatible(2, $editor_type) == 2);\r\n $show[\'editor_toolbar\'] = ($toolbartype > 0);\r\n $editor_template_name = ($toolbartype ? \'editor_toolbar_on\' : \'editor_toolbar_off\');\r\n\r\n}', 'sr_classifieds');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Tuesday, January 30th 2007 @ 06:37:31 PM

This is script was exported from a 3.6.x forum so to install on a 3.5.x website you need the following product file (which I also released):

See: https://vborg.vbsupport.ru/showthread.php?t=134603

[Quarterbore]

Originally Posted by akulion

hi

i have a question

i want to place a sign (preferrably a graphic) BEFORE the adverts categories and the adverts themselves

what i wana put there is: DISCLAIMER: We do not take responsibility for any deals made via this website, we only offer an advertising fascility, the individual dealings and their mode is up to the users disgretion"

how can I do this?

Everything is templated so can you post the graphic you would like displayed and give an idea where you want it to show and I can advise where to hack the templates...