Major Additions - Mary's Classifieds

-----Not available any more------


*** VERY IMPORTANT NOTICE ***

By downloading and installing the new version 5.0.3, you automatically accept the following restrictions in use, which have been approved as legal from the Administrator Team of vB.org.

1. This version is 80% custom work for a client in Norway, who gots the permissions for exclusive use in Scandidavia (Norway, Sweden, Denmark, Finland). As a result of this legal agreement that I signed, installation of Mary's Classifieds is prohibited in domains (sites):
   1. With extention .no (Norway), .se (Sweden), .dk (Denmark) and .fi (Finland).
   2. In any site, having any tld extention (eg com, net etc etc), having as primary language:
      1. Norwegian
      2. Swedish
      3. Danish
      4. Finnish
2. Version 5.0.3 uses a thrid party Ajax Library from Guru Sistemas Ltd. This is a commercial library that I bought. Use of this libary out of the original directory (microclassifieds/datagrid/class/), even on the same domain, or including this library in any other module except Marys Classifieds is prohibited.
3. From this version and on there is my copyright link in the footer as all mods have. Please don't remove it. You can remove it legally by paying for it (not donating).

--------------------------------------------------------------------------

With 100+ support pages, its impossible for me to follow the posts her. That's why I opened in my site:

1. A Thread for Installation Issues
2. A Project for Bug Reports

I'll appreciate your understanding on the fact that this is a Free product, so don't expect superior level support, but I'll try my best with the help of Bug Tracker.

Also note that even if you can suggest new features, these features will be include in the upcoming CMPS style version which will be Commercial. No plans exist for adding new features in the Free version. Just bug fixes.
---------------------------------------------------------------------------

NEW VERSION 6.6.0

There are many new features to this version to list them now. Spend sometime to explore the new mod and you'll find them. The only that I want to mention is that the SEO rules that I've, are normal rules and not vbSeo rules.



How to upgrade:

1. Download the latest version 6.6.0. Please be aware that the regional restriction on use (Scandinavia) is still valid.
2. Upload *** ALL *** the files in your forum directory.
3. Import the product-microclassifieds.xml from your admincp, choosing overwrite.
4. Walk throught the General settinsg and usergroup permissions, as there are many new settings.

Thank you
Chris







1.- How it works

• A user posts an Ad. If the user hasn't post a profile before, the system auto creates one for him, populating it with any data there are in his forum profile.
• Members who are searching or browsing ads can see his ad. According the adtype (For-sale, Wanted, Auction), they can Buy it or Bid on it. The ad becomes invisible to public.
• System PMs seller about the sale. Seller can accept or decline the sale. In case of accept the ad is marking as pending payment. If seller declines the sale, the ad is activating again.
• When the payment is done, seller marks it as paid, the ad is removing from the server (with all related photos and attachments), and some data remain for history only.
• System PMs buyer that the sale has been finalized, and prompts him to rate and review the seller.
• In a time frame that admin has setup, seller and buyer can review each other. During this period reviews are hidden. When the time frame expires, the reviews become visible. Also with the help of a cron job, there is a check which activates reviews, even before the expiration, if both parties have post the review.

2.- Frontend Features

• 3 types of Classifieds (For-Sale, Wanted, Auction).
• Different look for each type.
• Powerfull Search engine
• What's New (Last 7, 14, 21, 30 days)
• Buyer can rate Seller, but also Seller can rate Buyer.
• Profile Information
• Full contact details
• Google Map Locator
• Value as Seller:
  • Rating
  • Total Sales
  • Total Amount of sold items
• Value as Buyer:
  • Rating
  • Total orders that he placed
  • Total amount of his orders
• Active Ads
• Sold Ads
• Reviews that he gots as Seller (from Buyers)
• Reviews that he gots as Buyer (from Sellers)
• Contact form
• Information Blocks in Main page:
  • Auctions to Expire
  • Random Classifieds
  • Premium Classifieds
  • Premium Profiles
  • Newest Idividual Ads
  • Newest Store Ads
  • Top Sellers (Rating)
  • Top Buyers (Rating)
  • Best Sellers (Amount of items that he sold)
  • Best Buyers (Amount of items that he bought)
• User can bookmark an Ad
• User can mark to follow a category, so he will get a PM for each new ad placed in that category (including subcategories).
• Logon user can:
  • Post an Ad (if it is permitting by his usergroup permissions).
  • Edit his profile
  • See the public view of his profile
  • My Classifieds section with:
    • Active Ads with options to Edit, Hide, Activate (if hidden) or Delete it
    • Hidden Ads with options to Activate or Delete
    • Accept Sales. List all Ads that have expired (if auction) or someone asked to buy them. Options: Accept sale, Reject sale, Delete Ad
    • Pending Ads, showing the ads awaiting to be paid. Options to close the sale (after payment), or to reactivate the ad
    • Sold Ads
  • My Bids
  • My Bookmarks
  • My Watch categories
  • My History, showing:
    • Items that I sold
    • Items that I bought
  • Attractive interface
  • Easy to understand and use by your members
  • Certified Memebrs

3.- Administrator Features

• Unlimited depth level of categories
• Option per category to allow posts to:
  • All Usergroups
  • None Usergroup
  • Specific Usergroup, or Usergroups
• Extra fields, global for all categories:
  • Text
  • Radio Button
  • Checkboxes
  • Droplist
  • Textarea
• Extra fields for Profiles (same options as above).
• Set expiration time (in days) for ads. A cronjob checks the ads and removes ads that have been expired (also removes related, bookmarks, bids etc).
• Can setup default currency for all ads, or can allow users to use any currency they want.
• Allow or disallow to user, to choose if he wants any expired ad, to be peplaced with a new one.
• Can setup where the text search will perform:
  • Title
  • Title and Keywords
  • Title, Keywords and Message body.
• In addition, he can setup how the search will works:
  • Looking for exact text
  • Looking for partial search
• Can choose to use or not Google Maps
• And many other common options (eg photo widths, allowed filetypes etc etc).

4.- Moderator Actions

• Approve New or Edited Ads
• Approve or Delete Reported Ads
• Add/Delete Certified Members. Certified Members is another way to promote some users that you want. You can change the word to anything you like. Some webmasters use it to show that a seller has proven his identity to him, others use it to promote good clients etc.

5.- Usergroup Permissions

• Can access the classified section
• Can post ads
• How many concurrent active ads
• How many photos per ad
• How many attachments per ad
• Priority on listings (1= Higher .... 9=Lower. Please note that usergroups with priority 1, Ads and Profiles appear in random, as Premium)
• Ads need approval? This is a commonly used permission, but I moved it to work per usergroup and not as general option.
• Can Moderate Ads and Reported Ads
• Can Moderate Certified Members

6.- New version 4.9.5

This version fixes all posted bugs and corrects any styling issued by using external css files (microclassifieds/includes/classifieds.css). It also replace the inline blocks (Buy Now etc) with modal popup windows.




7.- Upgrade to ver.4.9.5

1. Upload all file to your site overwriting the old ones
2. Import product-microclassifieds.xml from your admincp marking the overwrite checkbox

8.- New version 4.9.5a

1. New Feature:
   1. Added Social Network sharing buttons (facebook, Twitter etc)
2. Improvement:
   1. Added {vb:raw headinclude_bottom} in all templates
3. Bug fixes:
   1. Auctions PMs have empty text
   2. Wrong PM on close Auction when there was no bids
   3. Missing photo in Premium Sellers block
   4. Missing condition "Used" in listings
   5. Wrong date in PMs to contact seller
   6. Missing photo in Wanted Ads
   7. Database error when adding a category with apostrophe in title

9.- Upgrade to ver.4.9.5a

1. Upload all file to your site overwriting the old ones
2. Import product-microclassifieds.xml from your admincp marking the overwrite checkbox

10.- New version 4.9.5a

1. Bug fixes:
   1. Phrase in wrong phrase section caused empty PMs for Auctions.
   2. Wrong Mathematical formula in Search (expiration).

11.- Upgrade to ver.4.9.5a

1. Upload all file to your site overwriting the old ones
2. Import product-microclassifieds.xml from your admincp marking the overwrite checkbox

*** VERY IMPORTANT NOTICE ***

By downloading and installing the new version 5.0.3, you automatically accept the following restrictions in use, which have been approved as legal from the Administrator Team of vB.org.

1. This version is 80% custom work for a client in Norway, who gots the permissions for exclusive use in Scandidavia (Norway, Sweden, Denmark, Finland). As a result of this legal agreement that I signed, installation of Mary's Classifieds is prohibited in domains (sites):
   1. With extention .no (Norway), .se (Sweden), .dk (Denmark) and .fi (Finland).
   2. In any site, having any tld extention (eg com, net etc etc), having as primary language:
      1. Norwegian
      2. Swedish
      3. Danish
      4. Finnish
2. Version 5.0.3 uses a thrid party Ajax Library from Guru Sistemas Ltd. This is a commercial library that I bought. Use of this libary out of the original directory (microclassifieds/datagrid/class/), even on the same domain, or including this library in any other module except Marys Classifieds is prohibited.
3. From this version and on there is my copyright link in the footer as all mods have. Please don't remove it. You can remove it legally by paying for it (not donating).

[Christos Teriakis]

Originally Posted by fwulfers

Thanks for the update Chris. As long as you're confident this will be possible in a future version, I can switch over to this software and won't bug you about this. You're doing an awesome job with answering questions and supporting this mod. :up:

Sure it will be. The funny is that it will be in the Free version and not in the PRO as I've changed many things there. Promise that you'll have it next week.

Chris

[dypsisdean]

Originally Posted by IPBvBxen

Unlike Premium (Certified) Members where you can add/delete them, premium classifieds is an automatice procedure. When a user posts or edits an Ad, the system checks if the user belong to a usergroup which has priority 1. If yes, then mark the Ad as Premium. Removal from premium classifieds is done with the cronjob. In general you can't unmark an Ad from Premium list as long as the user still belongs to a usergroup with priority 1.

Chris

First, I want to add my thanks to you for attempting to make this a viable product. And I realize how much effort it is taking you. So thanks a lot.

But I still do not understand the premium ads. What is the purpose of the check box at the bottom of the ad to make it a premium ad if it is only automatic?

But, in addition, I have made the person that posted the ads I wish to make premioum a certified member, and I made sure their usergroup is set at "1," but the ads will still not appear in the premium section.

So it appears that once an ad is posted, the premium status (or lack thereof) can not be changed by editing the ad, or by adding the creator to the certified list, or by changing the usergroup settings - is this correct? In other words, if a person forgets to check the box when creating the ad, there is nothing that can be done to make it a premium. Do I understand this correctly?

[axg]

Will this work on older versions of VB? Like 4.1.3, 4.1.2?

[remekk]

Hi,
Today I installed product and I got an error:

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT AVG(microclassifieds_orders.sreviewrating) AS thisrating,
microclassifieds_profiles.* AS thisprofile
FROM microclassifieds_orders
JOIN microclassifieds_profiles
ON microclassifieds_profiles.userid=microclassifieds_ orders.sellerid
WHERE microclassifieds_orders.sreviewrating>0
GROUP BY microclassifieds_orders.sellerid
ORDER BY microclassifieds_orders.sreviewrating DESC
LIMIT 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS thisprofile
FROM microclassifieds_orders

vb 4.1.5
Username : Admin
Classname : vB_Database
MySQL Version : 5.5.14-log

Could you tell me how to fix it?

Regards
Remek

[maineGuy72]

i discovered a bug with the premium profiles at the bottom of the page. when clicking on a profile you get an invalid data error. looking at the link it appears that it using the wrong id in the link like its using ID instead of USERID in the microclassifieds_profiles table

[maineGuy72]

Originally Posted by dypsisdean

So it appears that once an ad is posted, the premium status (or lack thereof) can not be changed by editing the ad, or by adding the creator to the certified list, or by changing the usergroup settings - is this correct? In other words, if a person forgets to check the box when creating the ad, there is nothing that can be done to make it a premium. Do I understand this correctly?

i had to use phpmyadmin to change the premium settings for the profiles and items after they were posted.

[dypsisdean]

Originally Posted by maineGuy72

i had to use phpmyadmin to change the premium settings for the profiles and items after they were posted.

Ah, good to know. I hope I am smart enough to figure out how you did that. I'm assuming you edited some DB tables???

I'm sure Chris will get a fix going for that in his spare time. Just kidding Chris. You are doing a fantastic job. I am making, and will be sending you a list of some English phrases, etc. that could be changed to make things more "polished," in appreciation and as a little help for your project.

[ndahiya]

Chris,

I understand you are not looking to add new features at this time, but allowing "free" classifieds should be a easy mod to make for the product. that would be amazingly helpful to many members, incl me. Thanks!

ndahiya

[PBRiot]

Hello, I discovered that classifieds are unfortunately not suitable for my forum. I went to uninstall the mod, and now, I'm getting fairly consistent emailed vBulletin errors.

"Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_microclassifieds AS phrasegroup_microclassifieds,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_posting AS phrasegroup_posting,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_microclassifieds' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 10th 2011 @ 07:35:12 PM
Error Date : Wednesday, August 10th 2011 @ 07:35:13 PM
Script : http://www.pbriot.com/classifieds.ph...le&profileid=1
Referrer :
IP Address : 66.249.67.66
Username :
Classname : vB_Database
MySQL Version :
"


Any ideas on how to fix it?

[PBRiot]

And here's another one as well

"Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_microclassifieds AS phrasegroup_microclassifieds,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroupinfo AS lang_phrasegroupinfo,
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, 1, user.languageid))

WHERE user.userid = 30;

MySQL Error : Unknown column 'language.phrasegroup_microclassifieds' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 10th 2011 @ 07:51:03 PM
Error Date : Wednesday, August 10th 2011 @ 07:51:03 PM
Script : http://www.pbriot.com/classifieds.ph...le&profileid=1
Referrer : https://vborg.vbsupport.ru/showthrea...ght=classified
IP Address : 76.25.41.172
Username :
Classname : vB_Database
MySQL Version :
"