Question about tblsslorders

[HosseinKo]

Hi everyone

I am working on an ssl module for whmcs and I have a question about one of WHMCS, tblsslorders, table. could you please tell me what is the purpose of this table and how it should be used? I was not able to find any documentation about this table and its usage.

 

Best Regards

[PUQ]

The tblsslorders table in WHMCS is used to store information about SSL certificate orders. It contains a record for each SSL certificate that is ordered through WHMCS, including the status of the order and details about the certificate.

The table has the following structure:

CREATE TABLE `tblsslorders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL,
  `serviceid` int(10) unsigned NOT NULL,
  `remoteid` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `module` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `certtype` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `completiondate` datetime DEFAULT NULL,
  `csr` longtext COLLATE utf8_unicode_ci,
  `cert` longtext COLLATE utf8_unicode_ci,
  `ca_cert` longtext COLLATE utf8_unicode_ci,
  `fullchain` longtext COLLATE utf8_unicode_ci,
  `privatekey` longtext COLLATE utf8_unicode_ci,
  `configdata` longtext COLLATE utf8_unicode_ci,
  `crt_created` datetime DEFAULT NULL,
  `crt_expires` datetime DEFAULT NULL,
  `crt_date_installed` datetime DEFAULT NULL,
  `dec_csr` longtext COLLATE utf8_unicode_ci,
  `dec_privatekey` longtext COLLATE utf8_unicode_ci,
  `webservertype` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `domain` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `validation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sslconfigid` int(11) DEFAULT NULL,
  `domains` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

The id field is an auto-incrementing primary key that is used to uniquely identify each SSL certificate order.

The userid and serviceid fields contain the ID of the user and service (e.g. hosting account) associated with the order, respectively.

The remoteid field is used to store the unique ID of the SSL certificate as returned by the certificate authority (CA).

The module field contains the name of the module that was used to process the order.

The certtype field specifies the type of SSL certificate that was ordered.

The status field indicates the current status of the order (e.g. "Pending", "Active", "Expired", etc.). 

The completiondate field contains the date and time when the order was completed.

The csr field contains the certificate signing request (CSR) that was submitted with the order.

The cert, ca_cert, and fullchain fields contain the SSL certificate, the CA certificate, and the full certificate chain, respectively.

The privatekey field contains the private key associated with the certificate.

The configdata field contains any additional configuration data that was specified when the order was placed.

The crt_created, crt_expires, and crt_date_installed fields contain the dates and times when the certificate was created, when it expires, and when it was installed, respectively.

The dec_csr and dec_privatekey fields contain the decrypted versions of the CSR and private key, respectively.

The webservertype field indicates the type of web server for which the certificate is intended.

The domain field contains the domain name for which the certificate was issued.

The validation field indicates the type of validation that was performed to verify the certificate request.

The sslconfigid field contains the ID of the SSL configuration that was used to process the order.

The domains field contains a list of all the domains that are covered by the certificate.

In general, the tblsslorders table is used to store information about SSL certificate orders that are placed through WHMCS. This information can be used to track the status of orders, retrieve certificates and other data, and perform other operations related to SSL certificates.