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

[In Omnibus]

microclassifieds/datagrid/class/phpmydatagrid.class refuses to upload. The file continuously attempts to overwrite itself and times out on a peer connection refusal. As a result we've had to uninstall the product, however, upon so doing we are receiving the following database error:

Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT * FROM vb_microclassifieds_items WHERE active=1 AND sold=0 AND hidden=0 AND categoryid IN (1) AND adtype=1 AND logo<>'' ORDER BY starts DESC LIMIT 5;

MySQL Error : Table 'rhens1.vb_microclassifieds_items' doesn't exist
Error Number : 1146
Request Date : Wednesday, August 24th 2011 @ 07:18:49 AM
Error Date : Wednesday, August 24th 2011 @ 07:18:49 AM
Script : http://www.prosportsinteractive.net/forum.php
Referrer : http://www.prosportsinteractive.net/content/
IP Address : 74.65.81.4
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.91-log

The product has been uninstalled and all uploaded files have been manually deleted. All existing tables named "microclassifieds_" have also been deleted. Any help would be greatly appreciated.

[maineGuy72]

Originally Posted by ProSportsForums

The product has been uninstalled and all uploaded files have been manually deleted. All existing tables named "microclassifieds_" have also been deleted. Any help would be greatly appreciated.

your forum page is giving off dbase errors
http://www.prosportsinteractive.net/forum.php
you might need to correct this first. once that is fixed the classified section might work too

[Christos Teriakis]

Originally Posted by maineGuy72

i am still getting the blue bar

Mike I'll kill you The blue bar you want to change or to remove that padding from left and right? If you want to change the style you need to edit the templates:
microclassifieds_searchgrid
microclassifieds_browsegrid

<link type='text/css' rel='stylesheet' href='microclassifieds/datagrid/skins/lightgray/css/dgstyle.css' />

[maineGuy72]

i dont want to change the padding i want to change the color of the bar to match the style i am using. the templates make no reference to the color and i have changed both css sheets and nothing happens. i can change the font and font style but cant get rid of the stupid color. agghhh.

i will figure it out if it kills me. you dont need to dewl on it i will get it or die trying.

**i just changed the skin to greenday and its close enough for me to match the style. lol

[Christos Teriakis]

Originally Posted by maineGuy72

i dont want to change the padding i want to change the color of the bar to match the style i am using. the templates make no reference to the color and i have changed both css sheets and nothing happens. i can change the font and font style but cant get rid of the stupid color. agghhh.

i will figure it out if it kills me. you dont need to dewl on it i will get it or die trying.

I placed that "stupid" color there and is not color. If you do a right click on the header you'll see that it's a background image.
microclassifieds/datagrid/styles/lightgray/css/dgstyle.css

.dgHeader, .dg_dataTable .editTitle
{
     background: #7192a8 url(../icons/headerbg.png) repeat-x;
     border: 1px solid #5a7f97;
     color: #FFFFFF;
}

If you change only the color, you're doing a hole in the water. Nothing. You must remove the url(......

Chris

[maineGuy72]

i removed the url reference

.dgHeader, .dg_dataTable .editTitle    
    { 
        background-color: #545E4A;
        border: 1px solid #5a7f97;
        color: #FFFFFF;
    }

and it still didnt go away. im just gonna go with the greenday skin. not worth pulling my hair out for a background

[In Omnibus]

Originally Posted by maineGuy72

your forum page is giving off dbase errors
http://www.prosportsinteractive.net/forum.php
you might need to correct this first. once that is fixed the classified section might work too

Your modification is causing the error:

Database error in vBulletin 4.1.5:

Invalid SQL:
SELECT * FROM vb_microclassifieds_items WHERE active=1 AND sold=0 AND hidden=0 AND categoryid IN (1) AND adtype=1 AND logo<>'' ORDER BY starts DESC LIMIT 5;

MySQL Error : Unknown column 'hidden' in 'where clause'
Error Number : 1054
Request Date : Wednesday, August 24th 2011 @ 08:56:02 AM
Error Date : Wednesday, August 24th 2011 @ 08:56:02 AM
Script : http://www.prosportsinteractive.net/forum.php
Referrer : http://www.prosportsinteractive.net/content/
IP Address : 74.65.81.4
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.91-log

[maineGuy72]

i can get to the forum main page now but when i try the classified page it says page not found
what is the link to the classifieds?

it looks like this error is different from the last. i would try installing the xml file again with the overright option checked. maybe not all the tables we created correctly

[maineGuy72]

Originally Posted by NTMID8

Mike? Chris? Anyone?

what version of PHP, VB and MySQL are you using?

this is the error i am getting

Deprecated:  Assigning the return value of new by reference is deprecated in /home/cbinder/public_html/forum/classifieds.php on line 487

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/functions_databuild.php on line 2186

[maineGuy72]

i posted a message on the jquery site asking about the greek characters if i hear anything i will let you know