Jump to content

maddog107_merged

Clients
  • Posts

    310
  • Joined

  • Last visited

1 Follower

Recent Profile Visitors

385,126 profile views

maddog107_merged's Achievements

  1. @Michael.J Since I paid for the custom development/creation of "Topic Attach Thumbnails" by any chance could you send me an updated version that works with 4.5? I see it on the marketplace but I haven't been able to get in touch via PMs. Thanks.
  2. @Stuart Silvester ^ Any update on ES7 support?
  3. @rebraf By any chance does this work on 4.4.x?
  4. Sorry, there is a problem We could not locate the item you are trying to view. Error code: 2D161/2
  5. Mine is 713G ibf_core_output_cache.ibd Just in case someone is wondering how to fix. If you are using Innodb and a file per tablespace is turned on you can do MariaDB [bellazon_v4]> optimize table ibf_core_output_cache; +-----------------------------------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------------------------+----------+----------+-------------------------------------------------------------------+ | abc_v4.ibf_core_output_cache | optimize | note | Table does not support optimize, doing recreate + analyze instead | | abc_v4.ibf_core_output_cache | optimize | status | OK | +-----------------------------------+----------+----------+-------------------------------------------------------------------+ 2 rows in set (12.177 sec) It dropped down to 340 MB!!!!! 340M Dec 8 10:57 ibf_core_output_cache.ibd
  6. Essentially sometimes our content is NSFW and Google Adsense does not like it when we show ads when there is that content. What I think I need is a DB query (or flag of some kind) which will not put this in the HTML (GlobalTemplate - <body> section). <script data-ad-client="ca-pub-6991445029332292" async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> So how I *think* it should work, is grab the URL, figure out what posts would be included on this particular page and then just search for the NSFW column we have in a table, and if adult<=3 on all of them it would print the code above in the <head> otherwise don't print anything. Here is a rough query I wrote that would accomplish this SELECT adult FROM zzz_ibf_core_attachments WHERE attach_id IN (SELECT attachment_id FROM `ibf_core_attachments_map` WHERE `id2` IN (SELECT * FROM (SELECT pid FROM `ibf_forums_posts` WHERE `topic_id` = 60196 and pid>=4518005 limit 20) temp_tab) ) Essentially its grabbing the first 20 posts from the topic 60196 starting from post 4518005 and then figuring out all the attachments associated with those posts and then joining to zzz_ibf_core_attachments which is where i have the "adult" column which is 1-5 where 4 or 5 is NSFW. Here is the result from the query above. adult 1 1 1 1 1 1 1 1 2 2 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 So in that case its OK to show ads, if any one of those is >=4 then we should not show the code. Please let me know if you think you could be of assistance and how much it would cost. Thank you. James
  7. cloudflare because of costs. Moving anywhere else to serve 30TB/mo is not feasible 😞
  8. Thanks for all the info in this post. We got banned from SES because of (I assume) this bug. They sent around 16k emails in an hour or so. Hopefully it will go back to normal after disabling this.
  9. Just enabled SES. Fingers crossed. Thanks!
  10. Seems like a good idea if its such an easy change.
  11. I sent you a PM but I would like to test as well. Thanks
  12. Is there an estimated release date with SES support @stoo2000 ?
×
×
  • Create New...