Major Additions - [DBTech] DragonByte Classifieds v1 (vB4)

DragonByte Classifieds: What is it?
DragonByte Classifieds allows items to be sold in a variety of ways by your users including Auctions and stock controlled Buy-it-Now listings. It works on vB versions 4.1.x and 4.2.x

Uses
Allowing your users to sell items has never been easier with a feature rich Classifieds system that allows for Auctions as well as stock controlled Buy-it-Now listings.

Integrated into vBulletin, DragonByte Classifieds also allows users to see current listings, create their own postage and address options for use with their own listings and upload pictures to be displayed along with the listings.

With a permissions system, automated bidding on auctions, customizable feedback system, fees and fully customizable categories and specifications, and featured and digital items, DragonByte Classifieds caters for a wide range of requirements.

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

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Priority support & Product Demos available at: http://www.dragonbyte-tech.com/
-------------------------------------------------------------------------------------------

Translations may be available @ Page Not Found - DragonByte Tech | vBulletin Mods & Addons
Support for translations handled by the translator in its respective threads only.

-------------------------------------------------------------------------------------------
Major Features

Multiple Listing Types: Auction, Buy-it-Now (with stock support) and Wanted Items Listings Types to allow your users to sell and barter for items in a variety of ways.

AJAX Integration: We used AJAX wherever we could to help reduce the page reloads, including bidding, checking for new bids as well as other areas.

Automatic Image Resizing: All images added to the classifieds system will be resized and have a thumbnails generated. This will help reduce the page load time but not having to dowload the full image when you just need the thumbnail.

Stock Control: Buy-it-Now listings have a complete stock control that can be adjusted and allows for multiple purchases by different users.

Postage and Address: Mulitple postage options can be added per user as well as a variety of addresses letting users choose where they want items delivered to and at whatever price they prefer.

Feedback System: Allow users to leave feedback about transactions including comments and a customizable ranking.

Watch Items, Save Searches and Users: Users can save items to their watch list and choose to store searches for easy reuse at a later time. Sellers and Buyers can also be added to lists so that their latest items can be found easily.

Categories and Specifications System: An unlimited amount of categories can be created, allowing for subcategories and specifications creating a huge range of options that can help users specify exactly what they are selling.

Payment Processors: Integrated payment processors, including PayPal, to allow users to pay for their items and their fees.

Featured Listings: Allow users to feature their items for an optional fee as well as allowing control over how many items they can feature.

Full Feature List
Payment Processors

• Payment Types
  • PayPal
  • Cash on Collection
  • Check/Cheque
  • Bank Transfer (manual transfers)
• Configure the description to display to your users when they checkout
• Configure your Merchant ID (such as PayPal email address)
• "Sandbox" Mode toggleable via vBulletin Options, for testing purposes

Listing Types

• Auction
  • AJAX Bidding
  • AJAX countdown timers
• Buy-it-Now
  • Adjustable Stock Control
• Wanted Items

Email and PM Notifications

• Users receive emails and PMs when items end, are sold, or are on their watch list
• Translatale phrases and email content

Categories and Specifications

• Categories can be added and assigned as subcategories
• Specifications can be added per category and used in multiple categories
• Options can be added to each specification and used in multiple specifications

Featured Listings

• Mark a listing as Featured to gain a higher position in the list
• Optionally add fees per usergroup to use the featured system
• Optionally add a limit on how many listings a user can feature via their usergroup permissions

Search

• In depth searching of:
  • Titles
  • Descriptions
  • Categories
  • Users
• Many Options to narrow down the search

Fees

• Custom Fees can be created
• Global or restricted to specific usergroups
• Charge for reserve prices, items initial listing and an items final price as well as for featuring items
• Choose from flatrate or percentage based values

Multiple Currencies

• Show prices in multiple currencies
• Set a tax rate for purchases in currencies other than your home currency
• Configurable exchange rate
• Choose a "Primary Currency" that your prices will be based on
• Automatical daily update of exchange rates via a Scheduled Task

Conditions

• Set the conditions of items

Returns

• Set the returns options

Country and State Codes

• Control the countries and states/counties that are available to be added to addresses

Addresses

• Allow users to add multiple address
• Define default address for when selling or buying items

Postage Options

• Create unique postage options
• Can be done per user
• Currencies can be defined
• The countries that the postage is available for can be defined
• Create user specific or generally available postage options from within the Admin Control Panel

Attachments

• Upload images to the vBulletin Attachment Manager
• Thumbnails created and used on upload
• Mulitple images per listing

Digital Listings

• Mark a listing as digital to help users understand they aren't bidding for physical items
• Send links to users on completion of the listing

Feedback System

• Allow users to submit feedback about transactions
• Users can submit comments along with their feedback

Listing Control

• Archive listings that have expired or are completed
• Relist items

Invoices

• Buyers and sellers have access to invoices of of completed transactions

Advert Boxes

• Advert and listings boxes to display current, featured or watched listings
• Various locations
  • Forum Index/Home
  • Forum Display
  • Search Pages
  • Classifieds Home Page
  • View Listing Page

Contact Seller

• Link to contacts seller when viewing a listing

Form Control

• Customizable Form Controls
• Default settings

Moderation

• Approve or unapprove listings
• Usergroup settings to automatically place new listings in moderation queue
• Moderation queue for moderators and administrators

Pro Only

Feedback System

• Customizable feedback ranks to mark reliability

Advert Boxes

• Various locations
  • Showthread Pages

Link Control System

• Create unique links at the foot of Classifieds pages to whatever URL you need

Notes System

• Users can submit notes on their listings

Resolution Centre

• Create and respond to issues in listings either as the seller or the buyer.
• Change the issue's status
• View how many issues are active on a listing

Contact Seller

• PM Created with translatable title

Form Control

• Simple Form in Forum Sideblock for quick listing submitting

Moderation

• Number of items in moderation queue displayed

-------------------------------------------------------------------------------------------
This mod displays a copyright notification in the footer of all pages which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[DragonByte Tech]

Thanks for letting us know. I'll have a look at what's continuing to cause the issues.

Matt

[DragonByte Tech]

Originally Posted by milcollector

Thanks, I have Downloaded your latest 1.1.0b2 version and still getting the same error after try to leave a feedback.

The error you are getting suggests that your server hasn't run the upgrade script that came with the first Beta for v1.1.0. Can you check if in your database you have the columns:

dbtech_classifieds_feedbackleftcount
dbtech_classifieds_feedbackleftcount
dbtech_classifieds_itemwoncount
dbtech_classifieds_itemsoldcount
dbtech_classifieds_itemunsoldcount

In the table user

If not, then try setting your version number in your product to 1.0.3 and then reimport the latest Beta 2 import script and see what happens.

Regarding the other MySQL error caused when viewing threads via TapaTalk, I've a new version of Beta 2 and I'm hoping this fixes the issue.

[migratoria]

Regarding the other MySQL error caused when viewing threads via TapaTalk, I've a new version of Beta 2 and I'm hoping this fixes the issue.

We need to re-download the version 1.1.0b2 Matt?

[Nelson58]

I did the updated download.
It's still happening.

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
l.*,
l.userid AS luserid,
li.listingitemid,
a.*,
f.*
FROM dbtech_classifieds_listing AS l
LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN attachment AS a ON l.attachmentid = a.attachmentid
LEFT JOIN filedata AS f ON a.filedataid = f.filedataid
WHERE l.userid IN ()
AND l.enddate > 1393423414
AND l.startdate < 1393423414
AND l.ended = 0
AND l.active = 1

AND l.moderated = 0
GROUP BY l.listingid
ORDER BY l.listingid
LIMIT 0;

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 ')
AND l.enddate > 1393423414
AND l.startdate < 1393423414
AND l.ended =' at line 11
Error Number : 1064
Request Date : Wednesday, February 26th 2014 @ 09:03:34 AM
Error Date : Wednesday, February 26th 2014 @ 09:03:35 AM
Script : http://www.hobby-machinist.com/mobiquo/mobiquo.php
Referrer :
IP Address : 66.175.144.84
Username : usrjcro11
Classname : vB_Database
MySQL Version :

nelson@hobby-machinist.com nelson@hobby-machinist.com
9:05 AM (23 minutes ago)

to nelson
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
l.*,
l.userid AS luserid,
li.listingitemid,
a.*,
f.*
FROM dbtech_classifieds_listing AS l
LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN attachment AS a ON l.attachmentid = a.attachmentid
LEFT JOIN filedata AS f ON a.filedataid = f.filedataid
WHERE l.userid IN ()
AND l.enddate > 1393423521
AND l.startdate < 1393423521
AND l.ended = 0
AND l.active = 1

AND l.moderated = 0
GROUP BY l.listingid
ORDER BY l.listingid
LIMIT 0;

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 ')
AND l.enddate > 1393423521
AND l.startdate < 1393423521
AND l.ended =' at line 11
Error Number : 1064
Request Date : Wednesday, February 26th 2014 @ 09:05:21 AM
Error Date : Wednesday, February 26th 2014 @ 09:05:21 AM

[DragonByte Tech]

Uploaded a fix for that MySQL error Nelson as well as another MySQL error that was happening because of a missing column in the user table.

For the second fix to work, download the package and reupload the files. Before importing the XML, change the version number of the DragonByte Classifieds product in the Admin Control Panel > Plugins & Products > Manage Products > DragonByte Tech: Classifieds (Pro) or (Lite) > Edit to 1.0.3 and save the product.

Then reimport the XML which should add the missing column in the user table.

We will include this fix in the Beta 3 upgrade files, but this fix is there for users who want to apply these fixes before Beta 3 is ready.

Matt

[Nelson58]

Matt:

The error came back even though table entries were modified.


nelson@hobby-machinist.com nelson@hobby-machinist.com
4:00 PM (0 minutes ago)

to nelson
Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
l.*,
l.userid AS luserid,
li.listingitemid,
a.*,
f.*
FROM dbtech_classifieds_listing AS l
LEFT JOIN dbtech_classifieds_listing_item AS li ON l.listingid = li.listingid
LEFT JOIN attachment AS a ON l.attachmentid = a.attachmentid
LEFT JOIN filedata AS f ON a.filedataid = f.filedataid
WHERE l.userid IN ()
AND l.enddate > 1393448403
AND l.startdate < 1393448403
AND l.ended = 0
AND l.active = 1

AND l.moderated = 0
GROUP BY l.listingid
ORDER BY l.listingid
LIMIT 0;

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 ')
AND l.enddate > 1393448403
AND l.startdate < 1393448403
AND l.ended =' at line 11
Error Number : 1064
Request Date : Wednesday, February 26th 2014 @ 04:00:03 PM
Error Date : Wednesday, February 26th 2014 @ 04:00:04 PM
Script : http://www.hobby-machinist.com/mobiquo/mobiquo.php
Referrer :
IP Address : 50.175.76.112
Username : nmasi
Classname : vB_Database
MySQL Version :

[Nelson58]

I got rid of it finally. I had to delete the old files. Then download fresh, & install. Then reinstall after changing the version number. That did it.

[DragonByte Tech]

Thanks for updating us Nelson.

Matt

[xony]

Hi, I have the pro version, and since the last update when I click http://www.zzz.com/dbtclassifieds.php?do=user&action=feedbacklist reviews gives me a database error:

Database error in vBulletin 4.2.2:

Invalid SQL:

UPDATE xxxuser
SET
dbtech_classifieds_feedbackleftcount = 0,
dbtech_classifieds_feedbackreccount = 0
WHERE userid = 1;

MySQL Error : Unknown column 'dbtech_classifieds_feedbackreccount' in 'field list'
Error Number : 1054
Request Date : Thursday, February 27th 2014 @ 01:09:04 PM
Error Date : Thursday, February 27th 2014 @ 01:09:04 PM
Script : http://www.zzz.com/dbtclassifieds.php?do=user&action=feedbacklist
Referrer : http://www.zzz.com/dbtclassifieds.php?do=listing&action=viewlisting&l istingid=4
IP Address : 37.15.182.202
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.5.35-cll

[ozzy47]

Questions regarding the Pro mod, needs to be asked on their site in the pro support forum for the mod.