Jump to content


Level 2 Member
  • Content count

  • Joined

  • Last visited

  • Days Won


egrueda last won the day on November 15 2018

egrueda had the most liked content!

Community Reputation

5 Neutral

About egrueda

  • Rank
    Level 2 Member
  1. egrueda

    Schema rename column

    Hi all! I need to rename some columns when updating custom modules, but the Schema is giving me headache. I want to use renameColumn method, but can't find the way. This is what i tried: Capsule::schema()->table('custom_table', function ($table) { $table->renameColumn('field_from', 'field_to'); }); Then I get the error. Error: Class 'Doctrine\DBAL\Driver\PDOMySql\Driver' What am I missing? Is there any other way? Thanks all
  2. Absolutely, 10.2 is the current production loader version (10.2.7), you should use it.
  3. Great news! Everything looks better on friday 😄 Thanks for the confirmation
  4. I'm sorry update didn't fix it :-/ Also I'm glad that you can avoid the issue by disabling it. It's not the best solution but is a valid workaround. At least now we are sure Imunify360 is the prime suspect xD xD
  5. If you can make the update, please tell us if this fix works 😉
  6. Ok, so I'm 99% sure that's the problem. It looks like this has been an issue caused by the latest update to Imunify360. It looks like they've released an update that should resolve this behavior, however it has only just been released and isn't available on all the mirrors worldwide yet. Because of this, the following update may not be available to all of your servers, but you can try and apply this update by running the following command via SSH:
  7. Sounds familar, are you using CloudLinux or Imunify360?
  8. egrueda

    Help with converting SQL query to Laravel

    ...or you can even make a join between radip and radreply
  9. egrueda

    Help with converting SQL query to Laravel

    First, check this and this Then, the easy way: $ip = Capsule::table('radip')->where("allocated", $username )->value(); Capsule::table('radreply') ->where("value", '') ->where("username", $username) ->update(['value' => $ip]); Start from there before going into subselect queries
  10. Hi all, I have an issue using this simple code in a custom module (admin area) <input type="text" name="phone1" > As "Phone Numbers" is ticked in General Settings > Locations, WHMCS automatically adds a country code just before the field: My field updtes automagically, but it doesn't use the default country, and that's really annoying I'm looking for a solution to: a) Get my default country code selected or b) Bypass the automatic conversion of my field (can't change the name of the field) Do you have any idea? Thanks!
  11. You need to "re-issue license" from whmcs client area, then run again to sync your new ip/directory to the license. Anyway, IIRC, dev licenses cannot be re-issued manually lilke "real" licenses, you need to open a ticket to ask for reissue that specific license. Check here: https://www.whmcs.com/members/index.php/knowledgebase/82/How-can-I-reissue-my-development-license.html
  12. egrueda

    hook point for custom pages

    You cau use this sample as starting point: https://developers.whmcs.com/advanced/creating-pages/ See how it interacts with table tblclients: $clientName = Capsule::table('tblclients') ->where('id', '=', $ca->getUserID())->pluck('firstname'); And how it assigns values to template variables: $ca->assign('clientname', $clientName); Just use the table you need
  13. egrueda

    hook point for custom pages

    If you are creating a custom page, why do you need a hook? Why don't you simply get the promotions data you need directly from the code of the custom page? Otherwise you can use the ClientAreaPage hook and check if the current page is the one you want, but I think there's no need fot that in a custom page.
  14. @ju5t, maybe it's easier to replicate invoice data in an external table or database using hooks. For example, every time an invoice is created, run a script. Or everytime an invoice is modified or deleted, run another script. Those scripts will receive all invoice data and you will be able to do what you want, like storing them in another place. Quick, easy and update-safe 😄
  15. egrueda

    Bug in WHMCS

    I don't really thing $params can be catched, not by whmcs at least. Did you create a servers group?

Important Information

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