| RESULTSET |
| Portal Whitelabel - query |
| |
DOMAIN |
FOOTER_FILE |
FOOTER_FILE_HEIGHT |
FOOTER_FILE_WIDTH |
FOOTER_IMAGE_ID |
HEADER_FILE |
HEADER_FILE_HEIGHT |
HEADER_FILE_WIDTH |
HEADER_IMAGE_ID |
ID |
NAME |
PHONE1 |
SUPPORTEMAIL |
SUPPORTEMAIL_BGCOLOR |
SUPPORTEMAIL_HEADER |
SUPPORTEMAIL_SIGNATURE |
| 1 |
my.alltheleads.com
|
/img/portal_whilelabels/atl/footer_ATL-243x120x144dpi-white.png
|
283
|
594
|
2
|
/img/portal_whilelabels/atl/header_ATL-NEW-594x283-300dpi-trans.png
|
283
|
594
|
1
|
1
|
All The Leads
|
(844) 532-3369
|
support@alltheleads.com
|
rgb(211, 229, 229)
|
<table border="0" cellspacing="0" width="100%" style="min-width:100%; background-color: rgb(1, 60, 195); border-bottom: 5px solid rgb(242, 158, 25); text-align: center;">
<tr>
<td style="padding: 10px; text-align:center;">
<a href="https://www.alltheleads.com" target="_blank"><img alt="All The Leads" src="https://my.alltheleads.com/img/logos/ATL-logo-white-on-blue.png"></a>
</td>
</tr>
</table>
|
Your ATL Customer Support Team
|
|
| SQL |
SELECT p.id, p.name, p.domain, p.phone1, p.supportemail, p.supportemail_signature, p.supportemail_header, p.supportemail_bgcolor, p.header_image_id, p.footer_image_id,
concat(h.file_path,h.file_name) as header_file, h.width AS header_file_width, h.height AS header_file_height,
concat(f.file_path,f.file_name) as footer_file, f.width AS footer_file_width, f.height AS footer_file_height
FROM portal_whitelabels p
LEFT JOIN images AS h ON p.header_image_id = h.image_id
LEFT JOIN images AS f ON p.footer_image_id = f.image_id
WHERE 1=1
AND p.id = ? |
