Jump to content

kpedana

Member
  • Posts

    16
  • Joined

  • Last visited

About kpedana

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

kpedana's Achievements

Junior Member

Junior Member (1/3)

0

Reputation

  1. Ok, so I've been doing hourly backups (mysqldump) on our DB for... a while. Sadly, I think they are all useless to use though. Our charset is UTF-8, our DB collation is utf8mb4_general_ci, most of the tables collation are utf8_unicode_ci (actually, all of them are), and most of the tblclients columns are utf8_unicode_ci, some are just blank collation which I think is fine? So, I decided to take one of our backups, and take a look in it. I noticed each of the 4 credit card columns have what looks like your typical encoding issue (funky charactors), but I didn't think anything of it. However, I tried importing a row from tblclients anddddd... fail. After a few backups giving us the issue, I decide let me try WHMCS actual "database backup" that you can generate on the fly, from Utilities. That's when I started getting nervous. Even their sql has funky charactors, and using one of their INSERT statements for tblclients results in broken credit card details as well... So at this point, I'm unsure if there's an encoding issue something (most likely) or what exactly is going on. Update: I have set every possible option for chartype in my.cnf to utf-8, verified PHP is utf-8 and re-updated a client with a credit card. It offers me to enter the hash and view the full card, so it's definitely working in the DB. If I make another WHMCS backup (under Utilities), and delete that clients row, and insert it using the statement in the WHMCS backup... card details break again. configuration.php (and the cc_encryption_hash) has never changed on this installation since it was originally installed.
  2. I currently have products set to use the module Auto Release module, and if I manually click one of the 4 Module Commands my action hooks fire perfectly. However, if I manually add (as an admin) an order, regardless if I price override it to $0 or let it use the real price and then "Add Payment"... none of my action hooks fire. I am trying to use AfterModuleCreate as the hook, and I have the product(s) set to "Automatically setup the product as soon as the first payment is received" so I'm unsure if that's causing the issue or not. So, all of the variables that are available to "AfterModuleCreate", "AfterModuleSuspend", "AfterModuleUnsuspend" and "AfterModuleTerminate" are exactly what I need. What I'm looking to do is insert entries specific to the product in question, to a DB when a product is first "created" (and paid), update entries when a product is "suspended", update entries when a product is "unsuspended" and finally when a product is "terminated". All of them work great when I manually click the module commands, but I figured those same commands were all ran automatically at those points as well except they don't seem to? I hope I don't need to be using Invoice specific hooks, and then having to use other internal API functions to get all of the same info those 4 hooks provide juse to do this. :-/
  3. I suppose it might be our negligence, but we use the API to validate login and handle the sessions, but is there anyway to only allow one login per IP or even just one login per account at a time? The way it stands, if I shared my login info with 100 people, all 100 of us could be logged in at the same time.
  4. So I have two scenarios I'd like to accomplish and am somewhat stopped dead in my tracks with the implementation since I would need var's from certain templates, on other templates to implement it as far as I would know how to do. I have Product A, Product B and Product C. All are recurring subscritpions, all require customfields. Problem 1: I'm looking to only show Product B if a customer has Product A on their account. Problem 2: I'm also looking to have Product C be price X if they have Product A, but price Y if they have no other products. Can anyone throw any ideas off me for how I could best accomplish this? For problem 1, I'm not looking to have Product A replaced with Product B, in the sense of just having B, be the upgrade for A. So if someone had Product B, they would also have (need to have) Product A on their account as well.
  5. Hey guys, I have a page "sub.domain.com", that uses the API to validatelogin and start the session. I'm not actually doing any session_start or anything, I'm calling validatelogin, and then on my non-WHMCS pages I'm just using: define("CLIENTAREA", true); require("/www/domain.com/html/billing/init.php"); use WHMCS\Database\Capsule; $ca = new WHMCS_ClientArea(); $ca->initPage(); And everything seems to work great staying logged in on the non-WHMCS page. What I'm trying to do is when someone visits domain.com/billing it knows there's that session started already, which doesn't seem to be the case. Now, if I do put everything on the same domain it seems to work swimmingly. My php.ini has the cookie_domain as .domain.com so I'm unsure if it's cookie related -vs- something code-wise. Any help would be greatly appreciated.
  6. I'm a little late to the party but is there anyway to have it show the category name of the KB article instead of (what appears to be) the actual "number" of the article? Basically it's currently: /knowledgebase/1/TESTKB but you'd think it SHOULD be: /knowledgebase/CATNAME/TESTKB ----- Same with announcements, looks like it's using the same "number" system instead of simply announcements/3/TESTANNOUNCE.html it should be announcements/TESTANNOUNCE.html, no?
  7. Ok, so I've gone through the settings in WHMCS a few times and can't find a way to disable DUE/UNPAID invoices from being sent. At the least, I'd like to disable invoice emailing all together, at the most I'd love to be able to ONLY email PAID invoices. To me (and I'm sure it's got to be a setting somewhere) the whole emailing of unpaid/due invoices is somewhat weird to me purely because clients aren't forced to login and accept/submit the order to be processed it happens automatically so I think it would confuse customers more than anything.
  8. Oh no, my problem was someone signed up for something on the 9th (we're testing), the order form obviously auto-processed that "invoice". I then added a simple service to the account (same day) and it put the due date for the 10th. I seen the "Attempt Capture" option, but I figured it'd be a simple test to see if the system automatically tried processing it on the 10th. It didn't. I'm sure it's "related" to your situation, but in my situation the invoice for the 10th never ran at all, so it didn't decline to begin with.
  9. well id hope its setup issue. there's no way were the only two who run payments automatically.
  10. Ok, so I have the cron setup (I get the nightly emails), what I did was "add" a product to a customer on the 9th which made the invoice due on the 10th. I understand I could have manually "Attempt Capture" which would run the card, correct? I didn't want to try that instantly but let it go until the 10th when it ran it's cron overnight to see if it would process that invoice. It didn't, am I missing something or was it supposed to try authorizing that charge automatically on the 10th? Everything is setup correctly in the gateway and everything, according to the gateway log there was no failure/approval. According to the cron it didn't do anything, so outside of always manually "Attempt Capture" everytime we add a product to an existing customer, anyone have any ideas on why it wouldn't have tried authorizing the invoice?
  11. It seems as though WHMCS isn't being gzipped by the server (compression) before passing through to the browser. I don't know if it's related to ioncube or if WHMCS simply can't work with gzip due to the complexity of it or what. Everything else on my domain is being compressed before it hits the end-user.
  12. So, I'm pretty sure it's related specifically to WHMCS since the rest of our site is gzipped down to the browser, I just don't know if it's literally not possible due to the protections for the WHMCS code or if there's something I'm missing elsewhere?
  13. UK time possibly... It's the 7th here, 4, 5, 6, 7. 4 Days. EDIT: Blah, you are correct sir. Silly D/M/Y format. Sorry. Apparently I thought it was May as well.
  14. Hey Chris, PFY-967553, 05/04/2013 21:41. I didn't mean to bring this into the light, but yea I was worried about support. :-/
  15. So I don't know if there's some holiday in the UK or something, but I've had a ticket in for 4 days now (since the 4th) and no response. I can't blame other customers for not responding to a post I made in the client discussion sub-forum but even simple yes/no responses to my thread/ticket from support would be a start. I like the product, I really do but I feel as though once you pay for it support seems to be very lacking... :-/
×
×
  • 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