Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
HDiddy Posted August 6, 2022 Posted August 6, 2022 @Adriano Faria Downloads issue with points is working as expected. Cheers Mate!! The only thing I saw which is bugged in this update is the member shop is throwing the following error, I tried refreshing the site cache and it is still showing up. [[Template membersshop/front/shop/index is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] and The Statistics Page is still not loading.
Adriano Faria Posted August 6, 2022 Posted August 6, 2022 What shows in the log? I didn’t touch the statistics page yet.
403 - Forbiddeen Posted August 6, 2022 Posted August 6, 2022 Great job with this new update. But i have a question, it's possible to allow two style to widget? I prefer the old version, without the bank information. Only show the title (GCoins) and the options to buy more gcoins.
HDiddy Posted August 6, 2022 Posted August 6, 2022 5 hours ago, Adriano Faria said: What shows in the log? I didn’t touch the statistics page yet. There were 2 entries in the log SELECT membersshop_items.*, author.* FROM `membersshop_items` LEFT JOIN `core_members` AS `author` ON author.member_id = membersshop_items.member WHERE ( membersshop_items.id IN(10,12,13,14) ) ORDER BY position asc IPS\Db\Exception: Unknown column 'membersshop_items.member' in 'on clause' (1054) #0 /var/www/html/107017/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*r304709::r304...', Array, true) #1 /var/www/html/107017/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 [internal function]: IteratorIterator->rewind() #4 /var/www/html/107017/system/Helpers/Table/Content.php(355): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator)) #5 /var/www/html/107017/init.php(927) : eval()'d code(159): IPS\Helpers\Table\_Content->getRows(Array) #6 /var/www/html/107017/system/Helpers/Table/Table.php(494): IPS\Helpers\Table\hook243->getRows(Array) #7 /var/www/html/107017/init.php(927) : eval()'d code(177): IPS\Helpers\Table\_Table->__toString() #8 /var/www/sitefiles/r304709/applications/membersshop/modules/front/shop/main.php(169): IPS\Helpers\Table\hook243->__toString() #9 /var/www/html/107017/system/Dispatcher/Controller.php(107): IPS\membersshop\modules\front\shop\_main->shopItems() #10 /var/www/sitefiles/r304709/applications/membersshop/modules/front/shop/main.php(20): IPS\Dispatcher\_Controller->execute() #11 /var/www/html/107017/system/Dispatcher/Dispatcher.php(153): IPS\membersshop\modules\front\shop\_main->execute() #12 /var/www/html/107017/index.php(13): IPS\_Dispatcher->run() #13 {main} and SELECT membersshop_items.*, author.* FROM `membersshop_items` LEFT JOIN `membersshop_item_categories` ON membersshop_items.cat_id=membersshop_item_categories.id LEFT JOIN `core_members` AS `author` ON author.member_id = membersshop_items.member WHERE ( membersshop_items.id IN(14,13,12,10,9,6,3,2,1) ) ORDER BY id DESC Unknown column 'membersshop_items.member' in 'on clause' 2 minutes ago, HDiddy said: There were 2 entries in the log SELECT membersshop_items.*, author.* FROM `membersshop_items` LEFT JOIN `core_members` AS `author` ON author.member_id = membersshop_items.member WHERE ( membersshop_items.id IN(10,12,13,14) ) ORDER BY position asc IPS\Db\Exception: Unknown column 'membersshop_items.member' in 'on clause' (1054) #0 /var/www/html/107017/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*r304709::r304...', Array, true) #1 /var/www/html/107017/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 [internal function]: IteratorIterator->rewind() #4 /var/www/html/107017/system/Helpers/Table/Content.php(355): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator)) #5 /var/www/html/107017/init.php(927) : eval()'d code(159): IPS\Helpers\Table\_Content->getRows(Array) #6 /var/www/html/107017/system/Helpers/Table/Table.php(494): IPS\Helpers\Table\hook243->getRows(Array) #7 /var/www/html/107017/init.php(927) : eval()'d code(177): IPS\Helpers\Table\_Table->__toString() #8 /var/www/sitefiles/r304709/applications/membersshop/modules/front/shop/main.php(169): IPS\Helpers\Table\hook243->__toString() #9 /var/www/html/107017/system/Dispatcher/Controller.php(107): IPS\membersshop\modules\front\shop\_main->shopItems() #10 /var/www/sitefiles/r304709/applications/membersshop/modules/front/shop/main.php(20): IPS\Dispatcher\_Controller->execute() #11 /var/www/html/107017/system/Dispatcher/Dispatcher.php(153): IPS\membersshop\modules\front\shop\_main->execute() #12 /var/www/html/107017/index.php(13): IPS\_Dispatcher->run() #13 {main} and SELECT membersshop_items.*, author.* FROM `membersshop_items` LEFT JOIN `membersshop_item_categories` ON membersshop_items.cat_id=membersshop_item_categories.id LEFT JOIN `core_members` AS `author` ON author.member_id = membersshop_items.member WHERE ( membersshop_items.id IN(14,13,12,10,9,6,3,2,1) ) ORDER BY id DESC Unknown column 'membersshop_items.member' in 'on clause' I ended up just deleting all my Member Shop Items as I was going to redo them anyway. That seem to bring things back.
Adriano Faria Posted August 6, 2022 Posted August 6, 2022 46 minutes ago, 403 - Forbiddeen said: I prefer the old version Edit the widget template and leave it as you want. 42 minutes ago, HDiddy said: There were 2 entries in the log SELECT membersshop_items.*, author.* FROM `membersshop_items` LEFT JOIN `core_members` AS `author` ON author.member_id = membersshop_items.member WHERE ( membersshop_items.id IN(10,12,13,14) ) ORDER BY position asc IPS\Db\Exception: Unknown column 'membersshop_items.member' in 'on clause' (1054) #0 /var/www/html/107017/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*r304709::r304...', Array, true) #1 /var/www/html/107017/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #2 [internal function]: IPS\Db\_Select->rewind() #3 [internal function]: IteratorIterator->rewind() #4 /var/www/html/107017/system/Helpers/Table/Content.php(355): iterator_to_array(Object(IPS\Patterns\ActiveRecordIterator)) #5 /var/www/html/107017/init.php(927) : eval()'d code(159): IPS\Helpers\Table\_Content->getRows(Array) #6 /var/www/html/107017/system/Helpers/Table/Table.php(494): IPS\Helpers\Table\hook243->getRows(Array) #7 /var/www/html/107017/init.php(927) : eval()'d code(177): IPS\Helpers\Table\_Table->__toString() #8 /var/www/sitefiles/r304709/applications/membersshop/modules/front/shop/main.php(169): IPS\Helpers\Table\hook243->__toString() #9 /var/www/html/107017/system/Dispatcher/Controller.php(107): IPS\membersshop\modules\front\shop\_main->shopItems() #10 /var/www/sitefiles/r304709/applications/membersshop/modules/front/shop/main.php(20): IPS\Dispatcher\_Controller->execute() #11 /var/www/html/107017/system/Dispatcher/Dispatcher.php(153): IPS\membersshop\modules\front\shop\_main->execute() #12 /var/www/html/107017/index.php(13): IPS\_Dispatcher->run() #13 {main} and SELECT membersshop_items.*, author.* FROM `membersshop_items` LEFT JOIN `membersshop_item_categories` ON membersshop_items.cat_id=membersshop_item_categories.id LEFT JOIN `core_members` AS `author` ON author.member_id = membersshop_items.member WHERE ( membersshop_items.id IN(14,13,12,10,9,6,3,2,1) ) ORDER BY id DESC Unknown column 'membersshop_items.member' in 'on clause' This version adds this new column. Not sure why it didn’t add to your install. 43 minutes ago, HDiddy said: I ended up just deleting all my Member Shop Items as I was going to redo them anyway. That seem to bring things back Is it working after re enter the items?
HDiddy Posted August 6, 2022 Posted August 6, 2022 1 hour ago, Adriano Faria said: Edit the widget template and leave it as you want. This version adds this new column. Not sure why it didn’t add to your install. Is it working after re enter the items? No still gives an error trying to add any new item
Adriano Faria Posted August 6, 2022 Posted August 6, 2022 34 minutes ago, HDiddy said: No still gives an error trying to add any new item Send a message with your board URL and an admin account. I’ll try to take a look before Monday morning.
EmpireKicking Posted August 7, 2022 Posted August 7, 2022 Show points in topics and whatnot doesn't show on all themes 🙂 So if you ahve the same proplem then you need to contact your theme guy or do it yourself.
Adriano Faria Posted August 7, 2022 Posted August 7, 2022 14 minutes ago, EmpireKicking said: Show points in topics and whatnot doesn't show on all themes 🙂 So if you ahve the same proplem then you need to contact your theme guy or do it yourself. The theme must be compatible with IPS 4.6 at least.
EmpireKicking Posted August 7, 2022 Posted August 7, 2022 6 hours ago, Adriano Faria said: The theme must be compatible with IPS 4.6 at least. It is
Adriano Faria Posted August 7, 2022 Posted August 7, 2022 It adds the points beside the number of posts, so it should be compatible with any theme.
James101 Posted August 8, 2022 Posted August 8, 2022 Hi @Adriano Faria, I had two questions - https://prnt.sc/GxuQUzWngnc1 1. Can we add some text next to it which tells the limit [if set]? For example - You will gain 25% interest per month with a max limit of 50,000 Points. 2. I set the max interest to 50,000 yet it shows I will earn 106,250 Points in interest. Shouldn't it show 50,000?
Adriano Faria Posted August 8, 2022 Posted August 8, 2022 2 minutes ago, James101 said: Can we add some text next to it which tells the limit [if set]? Edit the template. 2 minutes ago, James101 said: I set the max interest to 50,000 yet it shows I will earn 106,250 Points in interest. Shouldn't it show 50,000? I have no idea, mate. I don't use this app as you know. I've developed exactly what you requested and paid and confirmed it was ok. If it isn't, explain here and I'll take a look when I'll have to update it again.
Adriano Faria Posted August 9, 2022 Posted August 9, 2022 (edited) On 8/6/2022 at 12:01 PM, 403 - Forbiddeen said: I prefer the old version, without the bank information. Here goes the old template: {{if $member->member_id}} <div class='ipsBox'> <div class='ipsPad_half'> <div class='ipsType_center ipsAreaBackground_light ipsPad_half'> <h3 class='ipsType_sectionHead'>{$pointsName}</h3><br> <ul class='ipsList_inline ipsSpacer_top ipsSpacer_half'> {$points} </ul><br /> {{if \IPS\Settings::i()->ms_enable_point_sale}} <a href="{url='app=membersshop&module=shop&controller=main&do=purchasePoints'}" data-ipsDialog data-ipsDialog-title='{lang="ms_buy_points"}' data-ipsDialog-size='medium' class='ipsButton ipsButton_small ipsButton_fullWidth ipsButton_primary'>{lang="ms_buy_points"}</a> {{endif}} </div> </div> </div> {{endif}} Change it in your install. Template membersshop -> front -> widgets -> memberpoints Edited August 9, 2022 by Adriano Faria
403 - Forbiddeen Posted August 10, 2022 Posted August 10, 2022 On 8/9/2022 at 8:31 AM, Adriano Faria said: {{if $member->member_id}} <div class='ipsBox'> <div class='ipsPad_half'> <div class='ipsType_center ipsAreaBackground_light ipsPad_half'> <h3 class='ipsType_sectionHead'>{$pointsName}</h3><br> <ul class='ipsList_inline ipsSpacer_top ipsSpacer_half'> {$points} </ul><br /> {{if \IPS\Settings::i()->ms_enable_point_sale}} <a href="{url='app=membersshop&module=shop&controller=main&do=purchasePoints'}" data-ipsDialog data-ipsDialog-title='{lang="ms_buy_points"}' data-ipsDialog-size='medium' class='ipsButton ipsButton_small ipsButton_fullWidth ipsButton_primary'>{lang="ms_buy_points"}</a> {{endif}} </div> </div> </div> {{endif}} You rock, thanks a lot. Adriano Faria 1
adik Posted August 10, 2022 Posted August 10, 2022 (edited) On 9/30/2021 at 1:49 PM, adik said: @Adriano Fariawhen adding a new "rank/usergroup upgrade" item and setting the duration to permanent, saving the item produces an error asking to verify the values. Opening an existing rule with the duration set to permanent, the same error is displayed. When an existing user purchases and uses the aforementioned item, it works, however, only until the forum or the plugin rechecks or validates entries ( seems to be done every hour ) and then the rank dissapears from the user profile, defaulting back to the rank the user had before. @Adriano Faria You said that the update fixed the bug I reported with the rank dissapearing after a short period of time, so I paid to update the plugin. Now do I not only not have the feature working, still, and I also lost money. How come? 😞 Edited August 10, 2022 by adik
Adriano Faria Posted August 10, 2022 Posted August 10, 2022 56 minutes ago, adik said: You said that the update fixed the bug I reported with the rank dissapearing after a short period of time, so I paid to update the plugin. Do you have FTP access to your server to upload a couple of files (fix)?
Adriano Faria Posted August 10, 2022 Posted August 10, 2022 On 8/6/2022 at 12:01 PM, 403 - Forbiddeen said: Great job with this new update. But i have a question, it's possible to allow two style to widget? I prefer the old version, without the bank information. Only show the title (GCoins) and the options to buy more gcoins. Added as option in the widget: If you choose NO, then the old template is back. 403 - Forbiddeen 1
adik Posted August 11, 2022 Posted August 11, 2022 13 hours ago, Adriano Faria said: Do you have FTP access to your server to upload a couple of files (fix)? Yes
Adriano Faria Posted August 11, 2022 Posted August 11, 2022 19 minutes ago, adik said: Yes I already uploaded the fix and requested urgency in the review. I’m just waiting IPS to reply. If it can’t be approved now (and have to wait the queue), then I’ll attach the files.
BradTBP Posted August 27, 2022 Posted August 27, 2022 I like this app that Adriano took over, but it is now lacking blocks that can be added around the site to display items available in the store. Please consider adding functionality of blocks to show items available. Thank you.
jinnie Posted September 3, 2022 Posted September 3, 2022 I looked around on my admincp to see if this was possible but I couldn't find anything...are we able to the display custom items we create in the same place under the user info panel/postbit? Similar to how the trophies and medals application are displayed when purchased.
Adriano Faria Posted September 5, 2022 Posted September 5, 2022 On 9/3/2022 at 8:11 AM, jinnie said: are we able to the display custom items we create Users doesn't create custom items; you do, as admin, on Admin CP. If you mean the items a user purchased, no. Only the points are showed there.
Recommended Posts