BAJI26 Posted October 6, 2015 Share Posted October 6, 2015 Is it possible to open a support ticket by just entering the info into the DB and which info is needed for this ticket to appear in WHMCS admin. I'm trying different stuff and none seem to work! 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 6, 2015 Share Posted October 6, 2015 Is it possible to open a support ticket by just entering the info into the DB and which info is needed for this ticket to appear in WHMCS admin. I just manually added a ticket to our v6 dev by adding a new row into the database table (tbltickets) - it appeared in the admin area... though I haven't tested replying etc to it. I would guess (not tested) that as long as the ticketid is unique, it should be fine - but I don't know what the minimum information required would be, I just used the last row in the table as a template and added slightly different entries. I would expect the official way to create a ticket would be to use the API rather than add an entry to the table directly. http://docs.whmcs.com/API:Open_Ticket 0 Quote Link to comment Share on other sites More sharing options...
BAJI26 Posted October 6, 2015 Author Share Posted October 6, 2015 Can you take a screenshot of your tblticket where you enter the info so I can compare it to mine please!? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 6, 2015 Share Posted October 6, 2015 http://i.imgur.com/WBeg3Vo.png 0 Quote Link to comment Share on other sites More sharing options...
BAJI26 Posted October 6, 2015 Author Share Posted October 6, 2015 Ok! The "c" did you put "eY9Gw1AF" in there? eY9Gw1AF or better yet what exactly did you manually entered? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 6, 2015 Share Posted October 6, 2015 the row in that image is a genuine ticket, I had already deleted the 'faked' ticket. for "c", I just entered "12345678" and it worked - not sure of its purpose, but it seemingly must be 8 characters... I deleted that value of "c", and the ticket was still showing in the admin area. it's either going to be a random string or generated from existing values elsewhere... not sure which. 0 Quote Link to comment Share on other sites More sharing options...
BAJI26 Posted October 6, 2015 Author Share Posted October 6, 2015 Does it need a userid to display? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 6, 2015 Share Posted October 6, 2015 Does it need a userid to display? apparently not - I just entered a new row with no userid (0) and no value for "c" - ticket is available in the admin area. http://i.imgur.com/BXnfWfL.png http://i.imgur.com/6FHDoAC.png obviously with no userid passed, the ticket will not be linked to any client account. 0 Quote Link to comment Share on other sites More sharing options...
BAJI26 Posted October 6, 2015 Author Share Posted October 6, 2015 Wonder y mine not showing 0 Quote Link to comment Share on other sites More sharing options...
BAJI26 Posted October 6, 2015 Author Share Posted October 6, 2015 I just notice that the "status" must say "open" 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 6, 2015 Share Posted October 6, 2015 I think the status can be any of the statuses, but only those set as to be shown in Active tickets will appear in the default list. http://docs.whmcs.com/Support_Ticket_Statuses 0 Quote Link to comment Share on other sites More sharing options...
BAJI26 Posted October 6, 2015 Author Share Posted October 6, 2015 Yea... Another question THe Logo URL in the Settings >> General should display the logo in emails correct? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 6, 2015 Share Posted October 6, 2015 Another questionTHe Logo URL in the Settings >> General should display the logo in emails correct? yes - if they aren't, paste the URL into the browser and see if it displays there. 0 Quote Link to comment Share on other sites More sharing options...
BAJI26 Posted October 6, 2015 Author Share Posted October 6, 2015 Shows in browser but not in Emails... does it require the full http:// .... just the http://www.... or can it work with just the domain.com/images/logo.png ? 0 Quote Link to comment Share on other sites More sharing options...
sentq Posted October 7, 2015 Share Posted October 7, 2015 Shows in browser but not in Emails... does it require the full http:// .... just the http://www.... or can it work with just the domain.com/images/logo.png ? you need to specify full image URL ( ex.: http://www.whmcs-installation.com/images/our-logo.png ) 0 Quote Link to comment Share on other sites More sharing options...
BAJI26 Posted October 7, 2015 Author Share Posted October 7, 2015 I need now for when the ticket opens it sends and email to the email address that's in the ticket and also sends an email to support personnel that's in that department! Any suggestions? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted October 7, 2015 Share Posted October 7, 2015 I need now for when the ticket opens it sends and email to the email address that's in the ticket and also sends an email to support personnel that's in that department! Any suggestions? I think you're entering into the realms of using API and/or hooks... http://forum.whmcs.com/showthread.php?106870-Open-a-support-ticket&p=439074#post439074 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.