vb.org Archive - Major Additions - [DBTech] DragonByte Classifieds v1 (vB4)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Major Additions - [DBTech] DragonByte Classifieds v1 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=307280)

Hi everyone,

This week brings the first major update of DragonByte Classifieds (v1.1.0 Beta 1) Which includes 9 major changes and features as well as some bug fixes to existing features. Among the key updates included are extra notifications using the vBulletin notification system, options for randomizing the listings appearing in the advert boxes, JavaScript rotation of listings appearing in any of the advert boxes, Listing Views tracking, and two new Pro only features, an optional Auto Post a New Thread/Post on submitting a listing and a Seller's Items box that can be set to appear in a user's post footer in forum threads.

The new features are designed to enhance some of the core content and make the listings more visible to user's across the forums. We have appreciated all the feedback and suggestions that have been posted and with more updates planned we hope to include made more of the excellent suggestions that have been made. Please note that this is a Beta release and so there may well be bugs that need addressing. Any feedback on functionality and issues that you can all provide will help us immensely.

The full list of changes in v1.1.0 Beta 1 can be found below.

Remember, we have installed the latest Beta of Classifieds here on DBTech. We have created some 'fake' items and have left PayPal in Sandbox mode so that no real money changes hands allowing anyone to test how the system works. We look forward to your feedback. Go here for the latest listings: View Listings - DragonByte Tech | vBulletin Mods & Addons.

To create a PayPal Sandbox account you need to head over to this page: https://developer.paypal.com/webapps...tions/accounts. Once you login with your regular PayPal account you can then create a sandbox testing account to use to 'purchase' the items on our Classifieds.

Bug Fixes And Issue Fixes:
Fixed: Issue where invalid listing lengths could be inserted into the page before submitting the listing that would not trigger an error
Fixed: Style issue with advert boxes on the top of the View Listings page
Fixed: Invalid plugin loading in Lite version
Fixed: Issue that would prevent the total featured items updating for a user on a buy-it-now listing
Fixed: Issue where fees could be created even when an item has gone unsold
Fixed: Problem where listings that hadn't been approved before their expiry time would still count in the moderated listings count
Fixed: Missing date details from My Classifieds feedback images (in the alt and title parts of the HTML)
Fixed: Sale Email/PM not being sent when purchasing a listing with a buy-it-now

Changes To Existing Features:
Change: Moved several settings to the new DragonByte Tech: Classifieds - Listing Settings group

Additions To Product From Feature Requests Or Just Something Else Added:
Feature: Listing Lengths now include usergroup controls to allow restriction to particular usergroups
Feature: Postbit Link to My Listings for users with currently active listings
Feature: Links to Usernames now link directly to a page displaying all the user's current listings
Feature: (Pro Only) Seller's Items box above signature in postbit
Feature: Views of Listings are now tracked and stored either immediately or via a Scheduled Task once an hour
Feature: Random Adverts for Classifieds and Featured boxes
Feature: New Notifications for Feedback left and received, Items won, Items Sold and Unsold
Feature: (Pro Only) New settings to Post a thread or post for each new listing submitted
Feature: JavaScript controlled rotation setting for the Advert boxes

Known Issues:
Equal Bids aren't correctly handled

Hi Matt

I have upgraded at last release 1.1.0b1
Works but vbulletin send me an error by mail

Bug: ERROR Syntax
Conflict: Tapatalk plugin Mobiquo

Code:

Database error in vBulletin 4.2.2:



Invalid SQL:



                        SELECT 

                                COUNT(*) AS count,

                                l.userid

                        FROM dbtech_classifieds_listing AS l

                        WHERE l.userid IN ()

                        AND l.enddate > 1392811597

                        AND l.startdate < 1392811597

                        AND l.ended = 0

                        AND l.active = 1

                        AND l.moderated = 0

                        GROUP BY l.userid;



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 > 1392811597

                        AND l.startdate < 1392811597

                        AND l.ended =' at line 5

Error Number  : 1064

Request Date  : Wednesday, February 19th 2014 @ 01:06:37 PM

Error Date    : Wednesday, February 19th 2014 @ 01:06:38 PM

Script        : http://localhost/forum/mobiquo/mobiquo.php

Referrer      : 

IP Address    : xx.xx.xxx.xxx

Username      : Test

Classname     : vB_Database

MySQL Version :

Solutions?

Thanks guys. Will look into it asap and get back to you.

Matt

Uploaded a fixed file for that error as well as a couple of others:

Fixed: MySQL error when viewing a thread in TapaTalk (In Beta 1 PL1)
Fixed: Watchlists items of other users being displayed for the user viewing the page (In Beta 1 PL1)
Fixed: Issue with random adverts not being correctly randomized (In Beta PL1)

Matt

Tanks...
when the fix will be available matt?

Quote:

Originally Posted by migratoria (Post 2482578)

Tanks...
when the fix will be available matt?

Quote:

Originally Posted by DragonByte Tech (Post 2482398)

:)

Matt

Patched the Beta 1 files to fix a SQL error that happens on the forumdisplay pages.

Matt

Matt, I've got people complaining that with this system we wont have history of what was being sold and traded on our forums. They are actually right.. We'd like to have some sort of a history page where they can view all items that were being sold/unsold.

Also, if there's a way users can interact with the seller publicly like posting a question on the item or asking about a discount...etc. Just a small chat box to be under each item visible for all users who are viewing the item.

Many thanks!

Hi Matt, I just installed your product on my two forums and on one I have a problem. In the forum where I use vBcover iBid, there is no button DBTech Classifieds in my admincp after installing. In one of the forums where I do not have vBcover iBid runs ok. Is it possible that your product is not compatibile with vBcover iBid? I want to uninstall iBid, but after some time, because there are still active listings...
Thanks!
Regards
Sasha

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01461 seconds Memory Usage 1,752KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: