Jump to content


Honored Contributor
  • Content Count

  • Joined

  • Last visited

  • Days Won


brian! last won the day on March 11

brian! had the most liked content!

Community Reputation

3433 Excellent

About brian!

  • Rank
    Senior Member

Recent Profile Visitors

58071 profile views
  1. bear is absolutely right - replies that you sent to users should be in tblticketreplies and so, if they exist and the search terms are valid, this report should find them... notes won't be included by default as it's a different table to search, plus complicated by the fact that a ticket thread could have multiple ticket notes and so outputting the results wouldn't be straightforward. although note that if you find a result in the replies search, then clicking on the "Reply Id" value in the results should open that ticket thread and allow you to view the thread and any available notes. I suspect you mean tblticketnotes rather than tblnotes as the latter table refers to client notes rather than ticket notes. SELECT * FROM `tblticketnotes` WHERE `message` LIKE '%123456%' Gary, i've replied to your email - i've included a Ticket Notes search report that you may find useful. 🙂
  2. a faded star - i've moved on to a happier life no longer thinking about WHMCS. 😎 is "PricingPlan" a third-party theme? if so, then contacting it's developer might be useful.. or perhaps add {debug} to the code within the relevant template (I guess it would be products.tpl) and refresh the page - it should generate a popup window of (most) of the available variables... hopefully the variable you want will be in there... and then don't forget to remove {debug} from the template code when you're finished. depending on the theme, this might be a case of editing the template (if the cycle options are shown via multiple IF statements), or reversing the array if it's a loop - I will no doubt have posted solutions previous to both options... perhaps do a search on "triennial" or "triennially" and using my author name as a search option... don't go to far back, i'm pretty sure the reversing the array option would have been posted in 2018-2020... I can remember it was for an Indian poster. if I was familiar with the theme you were mentioning, then I could give a more useful reply. I never got around to installing v8.4 - got the files, just not the inclination, or need, to install it - perhaps when v8.5 goes GA, i'll take a look at that version... or perhaps not. 🙂
  3. if you know the templated email is going to be sent automatically, maybe an EmailPreSend hook that intercepts that email before it's sent, sleeps for x minutes (php) and then allows it to be sent... or if it's not sent automatically, then a hook that uses the SendEmail APi to send it after x minutes... as the other brian suggested (you can't have too many brian's lol), if an existing solution doesn't exist, you might need to get a developer in to code this for you (that's not one for me before you ask!).
  4. I don't get email notifications any more for posts and/or mentions (I disabled them last year) - so mentioning me in a thread, in the hope that I will see it, is really not worth doing. here I am... hello everyone! I hope everyone is doing well - i've literally no idea what has been posted in this place over the last year... I enjoy living my life in ignorance of this place for the most part! 😎 yes - I knew two things... one of them i've sadly now forgotten and the second i've carelessly misplaced. 😜 others will be your best bet now... my time visiting this place on a regular basis ended last year and my knowledge is fading... and as much as I could get back into the habit of coming here, I won't as there are much more enjoyable things to do. 🏝️ all that said, many months ago I did get asked to code an action hook that completely rewrites the v8 admin menu into something more sensibly organised and useful.... works on v8.3 and as there were no admin changes, I assume it works on v8.4... and seeing no specific admin changes in the changelogs (though experience tells you that might not necessarily mean that there aren't any lol), it should probably work in v8.5.... screenshot below is a little overkill as all display options are enabled (which you wouldn't really do normally), but topbar / stats bar / menus can all be individually enabled or their content changed... the damn thing has over 1k+ lines of code, but should continue to work regardless of using WHMCS. the irony is that having written it, I no longer personally have any need to run v8 as I don't use it myself and am not actively answering questions in this place anymore. 🙄 perhaps when v8.5 goes GA (or I suppose if things haven't changed at WHMCS, I should probably wait for the first v8.5.1 maintenance release lol) and if the inclination hits me, i'll test it again and perhaps post it on GitHub. thanks to @DennisHermannsen for posting a solution.
  5. important to have mentioned the Lagom use.... once you use custom themes, then the options will be different. i'll add a font awesome icon to the Store menu..... <?php use WHMCS\View\Menu\Item as MenuItem; add_hook('ClientAreaPrimaryNavbar', 1, function(MenuItem $PrimaryNavbar) { if (!is_null($PrimaryNavbar->getChild('Store'))) { $PrimaryNavbar->getChild('Store')->setLabel('<i class="fas fa-shopping-cart"></i> '.Lang::trans('navStore')); } }); I would therefore assume you can use the <img> option instead of a FA icon in a setLabel - but no doubt you'll let me know if that doesn't work! it might also be simpler to use absolute paths to any images to ensure you're calling them. ...and with regards to adding "Home" to the home navbar icon, it's already there - but it's hidden by default in the CSS, so that should be a quick CSS fix to show it.
  6. you can always PM me - though there's no guarantee if or how quickly i'll be able to reply.
  7. as I said in another thread, I no longer need to work - so why spend my time constantly supporting failing software that I will never use? on the contrary, i'm genuinely finding it easy... I knew for the last 2 days, i'd be coming here today and I wasn't looking forward to it. I wish I had logged in today, found all/most the threads getting answered by others... in reality, I sadly find that despite not being here for two months, i'm still top of the monthly reputation leader board... that's ridiculous and shows you how dead this place has become. sadly, I no longer want to come here frequently and reply to questions.... I can still do it if I choose to, and I know i'm probably the best at it, but my heart is no longer in it (and that's not going to change).
  8. you can use an action hook...
  9. technically, that location is defined in the template - so you could move its location (the hookouput foreach) by editing the template, or use a more generic output hook point and use JS to define the ideal location you want.
  10. it's out there! that's where you copied *my* code from - it's not difficult to link to the original thread, rather than imply that you wrote it yourself! 🙄 then you get the hook to find the current theme name and react accordingly.... as I mention in the above thread! 🙄
  11. bear in mind that that is a private whois server and you will need to authorise your server IP with them before it will work correctly... e.g if you search for "google.es" it is showing as registered (correct), but if you search for "remiturandbrian.com.es", then that shows as registered too. ... but it's really available. ⚠️
  12. I could think of a couple if the data was complete and valid... sadly it's not, so not very useful.
  13. nature of the beast i'm afraid - in recent versions, the more TLDs you add, the slower those pages are. frankly, it would likely be quicker to reduce the number of TLDs offered than fundamentally fix WHMCS.
  14. as i'm finding whilst reading the backlog of hundreds of threads since my last visit.... thankfully I don't get emails about mentions, so i'm happily going through my whmcs-free life in ignorant bliss... i'll be back in November if I have the time (and inclination!). they still haven't reversed on this ??? disappointing , but sadly not unexpected.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated