Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Mary's Classifieds Details »
Mary's Classifieds
Mod Version: 6.6.1, by Christos Teriakis (Banned) Christos Teriakis is offline
Developer Last Online: Sep 2013 I like it Show Printable Version Email this Page

This thread is in the Modification Graveyard.
vB Version: 4.1.7 Rating: (31 votes - 4.87 average) Installs: 153
Released: 21 Jul 2011 Last Update: 10 Nov 2011 Downloads: 1349
Not Supported DB Changes Uses Plugins Auto-Template Additional Files Translations  

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

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	new-1.jpg
Views:	793
Size:	72.9 KB
ID:	132098   Click image for larger version

Name:	new-2.jpg
Views:	675
Size:	84.0 KB
ID:	132099   Click image for larger version

Name:	new-3.jpg
Views:	1963
Size:	127.2 KB
ID:	132100   Click image for larger version

Name:	new-4.jpg
Views:	1921
Size:	76.0 KB
ID:	132101  

Click image for larger version

Name:	new-5.jpg
Views:	1311
Size:	150.4 KB
ID:	132102   Click image for larger version

Name:	new-6.jpg
Views:	953
Size:	82.4 KB
ID:	132103   Click image for larger version

Name:	new-7.jpg
Views:	962
Size:	89.8 KB
ID:	132104   Click image for larger version

Name:	new-8.jpg
Views:	1132
Size:	91.6 KB
ID:	132105  

Show Your Support

  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Major Additions microCLASSIFIEDS (General Classifieds) MaryTheG(r)eek Modification Graveyard 216 27 Jul 2010 17:31

  #151  
Old 10 Aug 2011, 19:12
Christos Teriakis Christos Teriakis is offline
 
Join Date: Jul 2011
Real name: Christos
Originally Posted by fwulfers View Post
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.
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
Reply With Quote
  #152  
Old 10 Aug 2011, 21:22
dypsisdean dypsisdean is offline
 
Join Date: May 2007
Originally Posted by IPBvBxen View Post
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?
Reply With Quote
  #153  
Old 10 Aug 2011, 21:33
axg axg is offline
 
Join Date: Jul 2006
Will this work on older versions of VB? Like 4.1.3, 4.1.2?
Reply With Quote
  #154  
Old 10 Aug 2011, 21:40
remekk remekk is offline
 
Join Date: May 2010
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
Reply With Quote
  #155  
Old 10 Aug 2011, 22:45
maineGuy72's Avatar
maineGuy72 maineGuy72 is offline
 
Join Date: Dec 2007
Real name: Mike
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
Reply With Quote
  #156  
Old 10 Aug 2011, 22:49
maineGuy72's Avatar
maineGuy72 maineGuy72 is offline
 
Join Date: Dec 2007
Real name: Mike
Originally Posted by dypsisdean View Post
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.
Reply With Quote
  #157  
Old 10 Aug 2011, 23:16
dypsisdean dypsisdean is offline
 
Join Date: May 2007
Originally Posted by maineGuy72 View Post
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.
Reply With Quote
  #158  
Old 11 Aug 2011, 01:48
ndahiya ndahiya is offline
 
Join Date: Aug 2004
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
Reply With Quote
  #159  
Old 11 Aug 2011, 02:50
PBRiot PBRiot is offline
 
Join Date: Feb 2011
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?
Reply With Quote
  #160  
Old 11 Aug 2011, 02:53
PBRiot PBRiot is offline
 
Join Date: Feb 2011
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 : http://www.vbulletin.org/forum/showt...ght=classified
IP Address : 76.25.41.172
Username :
Classname : vB_Database
MySQL Version :
"
Reply With Quote
  #161  
Old 11 Aug 2011, 02:59
dypsisdean dypsisdean is offline
 
Join Date: May 2007
Originally Posted by ndahiya View Post
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
I don't understand. I must be missing something. I thought "free" classified was the only way to run this as is. I didn't intend to charge anything, nor did I see how to.
Reply With Quote
  #162  
Old 11 Aug 2011, 04:56
fwulfers fwulfers is offline
 
Join Date: Aug 2010
Real name: Frank Wulfers
Originally Posted by fwulfers View Post
When sending a message to a seller or a buyer, the PM is OK but there is no email notification like I have set for my other PM’s.
Does anyone else have this same issue? This is kind of important as you'll only know about the message if you actually visit the site. I think many advertisers will want to know as soon as they have a message.

I looked in the database and the only difference I can find is in the pmtext table. Messages send through the Classifieds don't have any values in the touserarray field. Not sure if this is the problem or not.
__________________
Saab World
Reply With Quote
  #163  
Old 11 Aug 2011, 05:51
Christos Teriakis Christos Teriakis is offline
 
Join Date: Jul 2011
Real name: Christos
Originally Posted by dypsisdean View Post
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?
This checkbox is visible only to those who have permission to Moderate, as a way to help them to promote an Ad which belongs to a user who does not belongs to a usergroup with priority 1. To remove such an from premiums, you need to edit and uncheck this.


Originally Posted by dypsisdean View Post
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.
I'll try to reproduce it.

Originally Posted by dypsisdean View Post
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?
As I said before, a user can't see that checkbox. Is visible only to moderators.

Chris
Reply With Quote
  #164  
Old 11 Aug 2011, 05:56
Christos Teriakis Christos Teriakis is offline
 
Join Date: Jul 2011
Real name: Christos
Originally Posted by fwulfers View Post
Does anyone else have this same issue? This is kind of important as you'll only know about the message if you actually visit the site. I think many advertisers will want to know as soon as they have a message.

I looked in the database and the only difference I can find is in the pmtext table. Messages send through the Classifieds don't have any values in the touserarray field. Not sure if this is the problem or not.
I can assume the reason. Mary didn't liked to use vB's datamanager as a way to keep her mods compatible with upcoming version. So in this case just added the message in the database (but in correct way) without to use datamanager, and thus I believe that this is the point. Without to be 100% sure, I believe that adding the message using datamanager the emails will send. I'll try and I'll be back to this soon.

Chris
Reply With Quote
  #165  
Old 11 Aug 2011, 06:02
Christos Teriakis Christos Teriakis is offline
 
Join Date: Jul 2011
Real name: Christos
Originally Posted by PBRiot View Post
MySQL Error : Unknown column 'language.phrasegroup_microclassifieds' in 'field list'
I think that this is a vB bug as it happen to me when I uninstalled the vB Project Tools. Seems that on uninstallation something is messing with the removal of cronjobs. Try to delete from vb_installation/includes/cron/ the file microclassifieds_cron.xml

Chris
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:35.

Layout Options | Width: Wide Color: