Jump to content

pRieStaKos

Member
  • Posts

    737
  • Joined

  • Last visited

  • Days Won

    24

pRieStaKos last won the day on October 2 2023

pRieStaKos had the most liked content!

3 Followers

About pRieStaKos

Recent Profile Visitors

4483 profile views

pRieStaKos's Achievements

Senior Member

Senior Member (3/3)

  • Great Support Rare
  • Helpful Rare

Recent Badges

48

Reputation

8

Community Answers

  1. \WHMCS\Database\Capsule::table("tblhosting") ->join("tblclients", "tblhosting.userid", "=", "tblclients.id") ->join("tblproducts", "tblhosting.packageid", "=", "tblproducts.id") ->select("tblclients.email", "tblclients.phonenumber") ->whereIn("tblhosting.domainstatus", ["Cancelled", "Terminated"]) ->where("tblhosting.domain", "<>", "") ->whereIn("tblproducts.gid", [1, 2]) # Add product group id here ->get(); SELECT `tblclients`.`email`, `tblclients`.`phonenumber`, `tblproducts`.`name` FROM `tblhosting` INNER JOIN `tblclients` ON `tblhosting`.`userid` = `tblclients`.`id` INNER JOIN `tblproducts` ON `tblhosting`.`packageid` = `tblproducts`.`id` WHERE `tblhosting`.`domainstatus` ON ("Cancelled", "Terminated") AND `tblhosting`.`domain` <> "" AND `tblproducts`.`gid` in (1, 2) # Add product group id here You can always modify it, as your desire.
  2. AND `tblhosting`.`id` IN (2, 3) # Add here your service ids Replace `tblhosting`.`packageid` with `tblhosting`.`id`
  3. \WHMCS\Database\Capsule::table("tblhosting") ->join("tblclients", "tblhosting.userid", "=", "tblclients.id") ->select("tblclients.email", "tblclients.phonenumber") ->whereIn("tblhosting.domainstatus", ["Cancelled", "Terminated"]) ->where("tblhosting.domain", "<>", "") ->whereIn("tblhosting.packageid", [2, 3]) # Add here your product ids ->get(); # The above is actually this query SELECT `tblclients`.`email`, `tblclients`.`phonenumber` FROM `tblhosting` INNER JOIN `tblclients` ON `tblhosting`.`userid` = `tblclients`.`id` WHERE `tblhosting`.`domainstatus` IN ("Cancelled", "Terminated") AND `tblhosting`.`domain` <> "" AND `tblhosting`.`packageid` IN (2, 3) # Add here your product ids
  4. Check an email if it contains "value=". Or your check will fall to else. Query is OK. You message content you need to check.
  5. You have to use one of there hook indexes and you have invoiceid in both. Then you can call GetInvoice API for all invoice information.
  6. You need a hook to set `ordernum` on every new (or old) order. https://developers.whmcs.com/hooks-reference/shopping-cart/#overrideordernumbergeneration
  7. You need to use GetUsers. I you see the example results, you get his clients.
  8. Prices up, actual needed features down...
  9. I hope this was made on a staging/development environment...
  10. If you confirm that it's a hook and not a module, it's in includes/hooks. Just remove it or rename and add a `_` in front. If it's a addon module, you need to disable it first from the admin panel > Configuration > Addon Modules.
  11. Go to `modules/widgets/Support.php` and change the `limitnum` in $tickets $tickets = localApi('GetTickets', array('status' => 'Awaiting Reply', 'limitstart' => '0', 'limitnum' => '5'));
×
×
  • 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