Portal Software - [Chris] Classifieds

Classifieds
by Christos Teriakis
aka ChrisTERiS

Please note that from
11 Aug 2013
you can get support only in my site
http://www.teriakis.com

Demo: http://www.christeris.net/dev42/classifieds.php
Demo Accounts:
demouser1 / demopass1
demouser2 / demopass2
demouser3 / demopass3

1.- What's this mod?

Is better to say what is NOT this mod . For those who have used MarysClassifieds, I can say that they are 2 products which you can't compate. MarysClassifieds had dozens of features, but when I installed in my site I realized that I need only 10% of those features. Maybe less. This is SL Classifieds. A minimalist version of MarysClassifieds, but I bet that 70% of the webmasters will find this one more pretty, more usefull.

• It supports 4 types of Classifieds:
  • For Sale
  • Wanted
  • For Trade
  • Free Offers
• Supports unlimited categories
• Supports Extra fields (but not searchable)
• Has PM templates for:
  • PM user when admin approves his Classifieds
  • PM user when admin rejects Classified
  • PM seller when a user Makes an Offer
  • PM seller when a user clicks Buy it
  • PM seller when a use uses the contact form
• Supports 5 statuses:
  • Open
  • Hidden
  • Reserved
  • Expired
  • Sold
  • Please note that unlike my old mod, here nothing is automatic. The seller has to take care to switch between statuses.
• There are listings for:
  • Category classifieds
  • Timeframe (What's New) Classifieds
  • Seller Classifieds
  • Search Results
• In view Ad page the visitor can see also:
  • Other classifieds from the same seller
  • Similar classifieds from the same category
• In all pages there are available the follow blocks having the appearance of widgets:
  • Category Menu
  • Search Form
  • Statistics
  • Latest classifieds
  • Popular classifieds
  • Soon to expire classifieds.
• Version 1.5 additions:
  • Facebook Like Advanced (Shows users who liked it)
  • RSS Feeds of last 10 Classifieds
  • Seller has the ability to not mark a classifieds as reserved when a user clickc BuyNow, in case that he has stock of the same items and he wants to keep classifieds active.
  • Added description in extra fields appearing as help text in add/edit form.
  • In case that a category has no subcategories, beside the "No more categories" added an icon/link to previous category level.
    

2.- How you can make (a bit) money with it.

Using vBulletin's Subscriptions Manager you can set subscription which will upgrade the subscribers to a higher usergroup with more privilenges in SL Classifieds. eg:

• To restrict post in specific categories. The system works such a way that for each category you can set who can post:
  • All usergroups
  • None usergroup
  • Specific usergroup(s).
• To allow more days for postings. eg usergroup A can set a maximum of 15 days before the Ad will remove from the system, while usergroup B can set the Ad's duration for 45 days etc.
• Concurrent Ads. eg Register users can have only 1 active ad, while your VIP usergroup can has 5 ..or 10 ... or whatever you want.
• More photos per Ad

3.- Installation

1. Download and unzip the file Classifieds_XXXX.zip
2. Upload the content of upload folder to the directory where your vB installation is. As a check: classifieds.php must be on the same directoru as global.php, forum.php etc. SL Classifieds are not working out of vB installation directory.
3. CMOD 777 the directories:
   1. christeris/classifieds/photos
   2. christeris/classifieds/photos/thumbs
   3. christeris/classifieds/photos/tmp
4. Goto Admincp and import product-classifieds.xml. Double check before if you have another product with the same name.
5. Set the various settings in Classifieds->General settings
6. Set usergroup permissions
7. Check and modify if you want PM templates.
8. Set categories
9. Set Extra fields (in case that you want them).

4.- SEO URLs

• If you're using vbSeo open the file Classifieds_vBSEO_Custom_Rewrite_Rules.txt and add them to your vbSeo installation.
• If you're using .htaccasse file copy the contents of htaccess.txt and add it to your current .htaccess files. If you don't have such file and your server is compatible with such files, upload htaccess.txt to your vB directory and rename it to: .htaccess

5. CMS Widget / Forum Sidebar Block for Latest Classifieds

1. Shows latest 5 Classifieds. If you want to change the number to another value change at 1st line: $maxitems = 5;
2. Installation as CMS Widget
   1. Goto Admincp-> vBulletin CMS-> Widgets
   2. Click "Create New Widget" at the list bottom
   3. Set Widget Type: PHP Direct Execution
   4. Give a Title which appears at the widget. eg Last Classifieds, or.. Last 5 Classifieds etc
   5. Click SAVE
   6. Find in the list the new widget and click configure at the right side
   7. Replace the example code, with the code from Widget_Latest_Classifieds.txt
   8. Click Save
   9. Goto Layout and add it in any section you want
   10. Click Save (Layout)
3. Installation as Forum sidebar Block
   1. Goto Admincp-> Forums & Moderators -> Forum Block Manager
   2. Click Add Block
   3. In the next screen "Select block type: Custom HTML/PHP"
   4. Click Continue
   5. Title: Latest Classifieds
   6. Content Type: PHP
   7. Content: Copy & Paste the code from Widget_Latest_Classifieds.txt
   8. Click Save. The block will be now visible to your forum sidebar

6.- Copyright Link

Since the time that DBTech released their Copyright Manager, I've removed my own copyrights. I found their action insulting me to maximum. Their wording "Site is powered by vBulletin AddOns and Modules by Dragonbyte Tech" (and not "Some parts of this site"), means that everything there is their own work, ignoring on the worst way the fact that there are 100's of other coders and designers who are supporting this community for years. So, I'm letting the glory to them. No copyrights from my side.

Enjoy it
Christos Teriakis
aka ChrisTERiS

[CharlieDelta]

I have not fixed it but I do know what the issue is. If I have this mod enabled, https://vborg.vbsupport.ru/showthread.php?t=277323, there is some sort of JS conflict. I have contacted DBT to see if it something on their end. If I disable the DBT mod the editor displays and loads fine.

[CharlieDelta]

Chris I have two errors with the new upgrade;
When adding a description to an added field there is a db error

Warning: mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'description' in 'field list' in [path]/includes/class_core.php on line 1391

When upgrading the xml this error displays;
Attachment 144959

[Christos Teriakis]

Originally Posted by CharlieDelta

Chris I have two errors with the new upgrade;
When adding a description to an added field there is a db error

Warning: mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'description' in 'field list' in [path]/includes/class_core.php on line 1391

When upgrading the xml this error displays;
Attachment 144959

echhh.. s###... there was a missing double quote at the end of the query. Try to import this file and tell me if it works to update the zip file (assuming that you haven't added manually the field description in database).

[CharlieDelta]

With this file I get another db error

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'vbulletin.item_fields' doesn't exist in [path]/includes/class_core.php on line 1391

[Akangage]

Originally Posted by TheForumMarket

The problem is why that field didn't created by the product-classifieds.xml. Have you imported that file??. I seen the code and is correct:

Hi Chris,

Yes, i'm imported that file, i had done it 2 times, but still error thats why, i should manually add.

[Christos Teriakis]

Originally Posted by Akangage

Hi Chris,

Yes, i'm imported that file, i had done it 2 times, but still error thats why, i should manually add.

My apologies. There was a missing double quote to close the query at the end. I've released v.1.5.1 to fix it, but I think that is better to remove that manually created field and let the new xml to add them. Otherwise you'll have problems in furture updates.

[CharlieDelta]

The latest update gives me this db error and will not upgrade;

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'vbulletin.item_fields' doesn't exist in [path]/includes/class_core.php on line 1391

[sadiq6210]

Excellent work Chris
Keep it up :up:

[Christos Teriakis]

Originally Posted by CharlieDelta

The latest update gives me this db error and will not upgrade;

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'vbulletin.item_fields' doesn't exist in [path]/includes/class_core.php on line 1391

This is the results of stress. I wanted to have all done (fixes and new features) before noon so to be able to monitor and bug reports in the evening.

Try the attached file. Was missing the main part of the tables (classifieds_)

[DirtRider]

Get this database error when uploading the XML file

Database error
The TriumphTalk database has encountered a problem.
Please try the following:

Database error in vBulletin 4.2.1: Invalid SQL: ALTER TABLE items ADD flagreserved INT( 1 ) UNSIGNED DEFAULT '1' NOT NULL; MySQL Error : Table 'davem_vbulletin.items' doesn't exist Error Number : 1146 Request Date : Saturday, May 11th 2013 @ 04:26:11 PM Error Date : Saturday, May 11th 2013 @ 04:26:12 PM Script : http://www.triumphtalk.com/1cB8dN8ca...=productimport Referrer : http://www.triumphtalk.com/1cB8dN8ca...?do=productadd IP Address : 105.236.125.215 Username : DaveM Classname : vB_Database MySQL Version : 5.5.29-0ubuntu0.12.04.2