Jump to content

evcz

Level 2 Member
  • Content count

    38
  • Joined

  • Last visited

Community Reputation

0 Neutral

About evcz

  • Rank
    Level 2 Member
  1. actually there's something (WHMCS api bug?) if the ticket submitted has an attachment when doing AddTicketNote the same attachment is also attached as a note (despite not populating that value when doing the local API call)
  2. for now hooked to `TicketOpen` and worked great. updating subject and also adding a note with additional infos from other systems.
  3. Ok, thank you. So I need to intercept, alter and save updated. cannot alter on the fly before saving (and before notifications are sent) Will give it a try, thank you Brian
  4. Hi I'm looking for some ideas to alter ticket subject during submission (want to append custom data to it based on IP that is submitting the ticket, only for a specific department) is there a hook I can use that can "filter" the ticket before submitting it into the DB?
  5. Pulled the trigger and did DELETE tbltickets, tblticketreplies FROM tbltickets RIGHT OUTER JOIN tblticketreplies ON tbltickets.id = tblticketreplies.tid WHERE tbltickets.userid = '0' AND tbltickets.status = 'Closed' and tbltickets.date < DATE_SUB(NOW(), INTERVAL 6 MONTH) to remove tickets from anonymous users older then 6 months, now just need to wait for the next WHMCS version for the auto pruning of attachments before doing the delete here and we should be fine 🙂
  6. ouch, didn't know that admin replies had userid 0 then this as a select makes more sense then SELECT * FROM tbltickets RIGHT OUTER JOIN tblticketreplies ON tbltickets.id = tblticketreplies.tid WHERE tbltickets.userid = '0' AND tbltickets.status = 'Closed' and tbltickets.date < DATE_SUB(NOW(), INTERVAL 1 MONTH) change the SELECT * with DELETE tbltickets, tbltitcketreplies and we should be good. how does it looks to you?
  7. hooking at the cronjob make sense, but my main question is running these two queries: DELETE FROM `tblticketreplies` WHERE `userid` = 0 AND `date` < DATE_SUB(NOW(), INTERVAL 1 MONTH) DELETE FROM `tbltickets` WHERE `userid` = '0' AND `lastreply` < DATE_SUB(NOW(), INTERVAL 1 MONTH) is safe to run and do not leave things broken behind the only thing left broken behind are the attachments, but those are taken care on 7.8 beta with automatic old attachments pruning another incosistency is removing a ticket before all tickets before their respective ticket replies are deleted, but that's not a big deal, just a metter of delayed days
  8. Hi, do you think having an SQL query to delete old (older then 1 month for example) tickets filled by anonymous users completely removed would be doable without breaking WHMCS? Basically we are talking about sales requests or similar things. It makes sense to retain tickets from account, but the ones from anonymous sources should be deleted in order to have the least possible personal data stored. Is there any example to start from or any already existing module? Thank you
  9. Hi, I'm looking for a hook to open a support ticket under user account in case of invoice overpayment Basically what I would like to do is: hook to addinvoicepayment everytime addinvoicepayment is called check if the invoice paid amount is > of the total amount. if it is: open a ticket to that user Is there some example code I could start with? (how do I check invoices amount and so on within hooks?) Thanks
  10. evcz

    VATMOSS & EU VAT changes

    Well, thanks for the post... is there an SQL that we can run to update all the countries with the correct % instead of having to do them all one by one?
  11. evcz

    VATMOSS & EU VAT changes

    Any news about EU vat addon being updated in order to automatically set all the EU values? or shall we not trust it anymore?
  12. evcz

    EU VAT addon

    Hi, starting for the 1st of january the whole VAT values must be changed http://www.foreigninvestments.eu/en/fdi/expert-topics/change-in-european-union-vat-rules-per-1-january-2015-for-telecommunications-broadcasting-and-electronic-services Is whmcs eu vat module already up-to-date?
  13. evcz

    Customer canceled at PayPal. Then what?

    the biggest is issue is the other way around (happening to us frequently) Customer cancel the service on whmcs but don't go on paypal to cancel the subscription. At that point you will then keep receiving the money not justified by any invoice, money is added to customer credit and if you re not quick enough no notice that cash flow the 45 days windond to return the money will be closed and you will also have to pay for the paypal fees to return it manually... - - - Updated - - - the biggest is issue is the other way around (happening to us frequently) Customer cancel the service on whmcs but don't go on paypal to cancel the subscription. At that point you will then keep receiving the money not justified by any invoice, money is added to customer credit and if you re not quick enough no notice that cash flow the 45 days windond to return the money will be closed and you will also have to pay for the paypal fees to return it manually...
  14. Ciao a tutti gli italiani!
  15. evcz

    Ajaxcart broken

    5 updates have been released but the ajax cart is still not working. I've been told they have planned to fix it in 5.4!!! 5 dot four!!!!!!! And in the meantime I should use another cart. Hilarious
×

Important Information

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