Jump to content



  • Content Count

  • Joined

  • Last visited

  • Days Won


SJ77 last won the day on April 10

SJ77 had the most liked content!

About SJ77

  • Rank
    Community Regular

Recent Profile Visitors

8,397 profile views
  1. All of a sudden mine is working again, so I guess disregard. Thank you šŸ™‚ *shrug*
  2. I lost access to these important fixes now that I have to use 1.0.4 version. Can you help. Also just so you know the bug where blocked users can buy files is BACK.. Please help!!
  3. I use this as an application form to collect critical information and keep it on file. This includes images. Recently images are not loading. I just see a little 1 px spacer. I think this might have to do with lazy load being enabled but I am not sure. Not having this effects my business. Can you help? Thank you šŸ™‚
  4. Removed ability to upload images in album descriptions, as this presented a source of confusion for some users. Finally found it. I was searching for attachments and couldn't find anything.
  5. is this still needed in 4.4? or has this been solved by IPS?
  6. TOTAL OUTSTANDING CREDIT Got two final queries working that shows amount site owner owes to their members. (the amount of total site credit) It's here if others want to use it in their sql toolbox. Site total credit: SELECT SUM( GREATEST( CAST( JSON_UNQUOTE(JSON_EXTRACT( cm_credits,'$.USD' )) AS DECIMAL(20,2) ), 0 ) ) FROM core_members WHERE cm_credits IS NOT NULL; Site total credit by member: SELECT NAME, CAST( JSON_UNQUOTE(JSON_EXTRACT( cm_credits,'$.USD' )) AS DECIMAL(20,2) ) AS OWED FROM core_members WHERE cm_credits IS NOT NULL AND JSON_UNQUOTE(JSON_EXTRACT( cm_credits,'$.USD' )) > 0 order by OWED DESC
  7. figured it out. Have to use json unquote SELECT SUM( CAST( JSON_UNQUOTE(JSON_EXTRACT( cm_credits,'$.USD' )) AS DECIMAL(20,2) ) ) FROM core_members WHERE cm_credits IS NOT NULL
  8. Thanks @Mark This is a GREAT start. I think I can get something working here.
  9. No


  10. Hi, these are the settings to use along with Giphy. The exact error above will happen. Thank you šŸ™‚
  11. Adriano, I know you can do great queries. I was mostly asking if there is a very simple work around. Not in any way suggesting you can't do it. Sometimes complicated problems have simple solutions. Thank you for trying, that is very kind of you. This, I don't mind seeing output for my entire contributor group. I just need export to excel (CSV file) so I can figure out if I have enough reserves to pay money that I owe. As it is now, I have no idea how much of a buffer I need to have on hand to payout contributors. It's rather stressful if I am being honest.
  • Create New...