Premium Classifieds Mod Support (Modzzz) - part 4

Have version 2.14. I set the date for the ads to expire at 120 days. They do not expire. Some ads are years old now... How do I get them to disappear after a set amount of time?

Hello?

An issue with expiration of free listings has been resolved. Download again and replace this file :

modules\modzzz\classified\classes\BxClassifiedDb.php

Worked perfectly. Also went ahead and did the 2.14 to 2.15 update.... Thank you...

New problem. Getting a ton of these sql errors...

Database error in TowTalk.net

Query:

SELECT `id`, `expiry_date`, `author_id` FROM `modzzz_classified_main` WHERE `status`='expired' AND `expiry_date` <=  AND `post_expire_notify`=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 `post_expire_notify`=0' at line 1

Found error in the file '/var/www/vhosts/towtalk.net/httpdocs/modules/modzzz/classified/classes/BxClassifiedDb.php' at line 877.
Called 'getAll' function with erroneous argument #0.


Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /var/www/vhosts/towtalk.net/httpdocs/inc/classes/BxDolDb.php
            [line] => 237
            [function] => error
            [class] => BxDolDb
            [object] => BxClassifiedDb Object
                (
                    [_oConfig] => BxClassifiedConfig Object
                        (
                            [_sPurchaseBaseUrl] => https://www.paypal.com/cgi-bin/webscr
                            [_sPurchaseCurrency] => USD
                            [_sPurchaseCallbackUrl] => http://towtalk.net/modules/?r=classified/paypal_process/
                            [_sFeaturedCallbackUrl] => http://towtalk.net/modules/?r=classified/paypal_featured_process/
                            [_sCurrencyCode] => USD
                            [_sCurrencySign] => $
                            [sReturnUrl] => http://towtalk.net/modules/?r=classified/view/
                            [_iId] => 217
                            [_sVendor] => modzzz.com
                            [_sClassPrefix] => BxClassified
                            [_sDbPrefix] => modzzz_classified_
                            [_sDirectory] => modzzz/classified/
                            [_sUri] => classified
                            [_sHomePath] => /var/www/vhosts/towtalk.net/httpdocs/modules/modzzz/classified/
                            [_sClassPath] => /var/www/vhosts/towtalk.net/httpdocs/modules/modzzz/classified/classes/
                            [_sHomeUrl] => http://towtalk.net/modules/modzzz/classified/
                            [_sBaseUri] => modules/?r=classified/
                            [_oDb] => BxClassifiedDb Object

And this as well. 38 times so far.

Cron <skyforum@server1> env php -q /var/www/vhosts/towtalk.net/httpdocs/periodic/cron.php

   <div style="border:2px solid red;padding:4px;width:600px;margin:0px auto;">
                    <div style="text-align:center;background-color:red;color:white;font-weight:bold;">Error</div>
                    <div style="text-align:center;">Database query error</div>
                            </div>

The following file has been updated :

modules\modzzz\classified\classes\BxClassifiedDb.php

For those who want to remove the "Why" section, see below :

In modules\modzzz\classified\classes\BxClassifiedFormAdd.php

Find and remove this block of code :

In modules\modzzz\classified\templates\base\unit.html and modules\modzzz\classified\templates\base\unit_admin.html

Find and remove this block of code :

Ok, I got a new one.... only twice. Have no idea why....

Database error in TowTalk.net

Query: SELECT * FROM `modzzz_classified_main` WHERE `id` =   LIMIT 1Mysql 
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 'LIMIT 1' at line 
1

Found error in the file 
'/var/www/vhosts/towtalk.net/httpdocs/inc/classes/BxDolTwigModuleDb.php' 
at line 53.
Called 'getRow' function with erroneous argument 
#0.

Im getting an sql error when trying to delete predefined values

trying to remove the 'type' values to only leave 'sale'.

If I remove any individual value in CategoryType, then save I get the error below, plus it removes the whole predifined value list for 'CategoryType'

Found error in the file '/home/public_html/yoursite/administration/preValues.php' at line 359.
Called 'db_res' function with erroneous argument #0.

@daihlo - You are having an issue with the predefined list functionality in Dolphin. That is not related to the Premium Classifieds module. It seems you have some sort of customization done to your predefined list that is causing you problems. In default Dolphin, the `sys_pre_values`database table should have a field called `Extra`but your error is saying that field has been removed from the table. PM me your CPanel login and I will take a look at your database for you.

I added the field and all working now thanks.

One other question, in the add classified page, there is a multi form with first part showing selectors for 'parent, category, and classified type'

I dont need thecategory type option at all.

Can you point me to what code to edit just to remove this option from displaying on add form?

Thanks

one more question,

what is supposed to happen when someone uses the action buttons 'inquire about' and 'buy'

I get the text input pages, and send but there is no notification in the sellers account or email that I can find.

 The messages are sent to the Profile Email of the classified poster.

In modules\modzzz\classified\classes\BxClassifiedModule.php 

Find :

 'classified_type' => array( 

   'type' => 'select',

   'name' => 'classified_type',

   'values' => $aTypes, 

   'caption' => _t('_modzzz_classified_form_caption_type_of_classified'), 

   'required' => true,

   'checker' => array (

'func' => 'avail',

'error' => _t ('_modzzz_classified_form_err_type_of_classified'),

   ),   

), 

 Replace with :

 'classified_type' => array( 

   'type' => 'hidden',

   'name' => 'classified_type',

   'value' => 'sale',  

), 

thanks.

Something I have found thats not working for me on this module,

whenI add a new classified, it shows in recent classifieds, aslo in my classified, and if I feature it, also shows in featured.

On classifieds home page though, where the featured and recent 'rss' blocks are, nothing shows there!

also the rss block on home page does not show!

any ideas?

Other modules RSS blocks are working fine on home page and module home pages.

Just seems to be a problem with this module.

Latest version just downloaded the other day

@daihlo - For the RSS Blocks that you created, what is the URL that you are using to fetch the feed ?

Im talking about the default 'featured' and 'recent' classifieds blocks that appear on classified home page andindex page.

sending pm with details thanks

 As I mentioned via PM, only items with public viewing access will show up in these blocks.

Thanks for the help.

Is it possible to get all 'inquire' and 'buy' actions where viewers click the action buttons, to email site admin instead of the classifieds owner?

Im needing to set this up as admin controlled.

Thanks

 Yes, the code would have to be adjusted specific for your site.

Version 2.1.6 released. (See patches/version_2.1.6 folder in zip file)

'Buy' button has been renamed to 'Make Offer'.
Offers and Inquiries are now delivered to the Classified Owner inbox as well as their Profile Email.

 Please let me know cost thanks.

If you are using this for Dolphin 7.1, re-download and update the following folder :
modules\modzzz\classified\classes

This module is now compatible with Dolphin 7.2 . For those upgrading from Dolphin 7.1, please check the upgrade folder for instructions.

Issue with 7.1

I have slid the block _modzzz_classified_block_my_classifieds on to the profile page but it is not showing on profile.

Can you please help Modzzz

I would like to buy this mod. The only thing is that I would like to keep the ads module on my site for my advertisers. Will this classifieds mod overide the ads module?

 No, you can use both modules together.

Hello modzz there is a text layout issue with evo template 7.2

 text needs to go into 2 rows when screen width is narrow ?

many thanks  

Lovely mod; one of the best yet. But i wish the developer would consider building a unique image slider...specifically for this mod. one that would also function on mobile devices.

it would be a dream come true...

i already engaged him for some custom work on this mod...specifically for students. This developer is a genius

Version 2.1.7 released. (See patches/version_2.1.7 folder in zip file)

Added option to allow admin to modify the number of columns used to display state listings on main page.

Hi Modzzz. 

I love this mod so much and  i can't wait for you to be done with the custom work we discussed. please reach me with the progress situation; just want to be sure you haven't  forgotten me etirely,  as you haven't responded  to  my mail of 5days today.

I am so desperate now as  the unveiling for my wbsite iso near:........ www.maikasuwa.com

Its going to be a classifieds platform for strictly sudents. So modzzz has gracefully agreed  to add some features for m.

Thanks sir!

 Nice mod. I am really  loving its functionality. But how can one delete fields that not required on the "Add listings" form; some of those fields aren't sometimes, and i would like to delete them...or replace them.

Hi Modzzz

Did you also update the 7.1 version as in the notes it still states 2.1.6

TIA

 No, the Dolphin 7.2 version was updated.

Hi Modzzz,

I'm upgraded to 7.2 but I noticed that the profile block is not showing, I have change the home directory to /modzzz/cnc/ as I am using this for a feature called click and collect, will this have an effect why the block did not show up.

Gew

Exactly how did you make the change ? Did you do a complete replacement throughout the script before installing it ?

 Hi Modzzz,

As far as I can see going through your mod, I have changed all references to modzzz/classified and /?r=classified in connection to a url.  The mod has installed without any errors except for the fact I can't get the profile block to show.

This is what I love about your mods, the ability to customise it for example I have linked your classified mod to a text message feature which will give users the option to receive requests to purchase by email or by SMS.

Hi Modzzz

Fixed this issue had to change the block from bx_import('BxDolService'); return BxDolService::call('classified', 'profile_block', array($this->oProfileGen->_iProfileID));

to

bx_import('BxDolService'); return BxDolService::call('cnc', 'profile_block', array($this->oProfileGen->_iProfileID));

Thanks for your help

Gew

An issue with submitting the "Buy Request" form is resolved. The following file is updated :

modules\modzzz\classified\classes\BxClassifiedItemBuyForm.php

Not one to ask questions that "should" have simple answers, so is there any documentation for this mod as to the proper ways to set it up?

I'm having issue finding a way to allow my paid members to post their first 3 classifieds for free.  Then additional ads can be purchased.  "Non-paid" standard members should get no free ads but be able to purchase them.

Also would like to know if it's possible to make the "pay for featured status" available while creating the ad so that it can be a single purchase.  I think having to create and purchase the ad, and then go to the ad itself and click "get featured" will prevent most people from doing so.  Hoping I'm just missing something simple here and it can be activated for option during creation.

@ray888fl - As a general rule of thumb, any option that you do not see in the settings section of the module does not exist. I will look into the possibility of adding the functionalities mentioned in your post.

@dreng - There will be no payment integration but this is planned for a separate shop module which will allow selling of physical products.

The post classified block on the classified main page has been updated along with other minor fixes. Re-upload files and clear cache.

 ...is this "Shop Module" ready yet? To be able to buy and sell physical products is a needed feature on Dolphin. Cant wait...

Some miscellaneous adjustments has been made including fix of layout issue with Wall/Outline integration. Re-upload the files, recompile the language for the module and clear cache.

Hi Modzzz,

When I share a classified advert to Facebook, my site's logo is imported and displayed on Facebook instead of the item I wish to advertise.

Please assist.

Please check if there with the default Dolphin modules (such as Events, Groups) to see if there is a difference in outcome.  Sharing is a global mechanism in Dolphin which my modules simply integrate with. The actual coding for sharing is in core Dolphin.