echo "</option>\n<option"; if ($status == "Active Recurring") { echo " selected"; } echo ">"; echo $aInt->lang("status", "activerecurring"); echo "</option>\n<option"; if ($status == "Completed Recurring") { echo " selected"; } echo ">"; echo $aInt->lang("status", "completedrecurring"); echo "</option>\n</select></td></tr>\n</table>\n<img src=\"images/spacer.gif\" height=\"10\" width=\"1\"><br>\n<DIV ALIGN=\"center\"><input type=\"submit\" value=\""; echo $aInt->lang("global", "searchfilter"); echo "\" class=\"button\"></DIV>\n\n</form>\n\n </div>\n</div>\n\n<br />\n\n"; $aInt->sortableTableInit("id", "DESC"); $where = array(); if ($status == "Uninvoiced") { $where['invoicecount'] = 0; } else { if ($status == "Invoiced") { $where['invoicecount'] = array("sqltype" => ">", "value" => "0"); } else { if ($status == "Recurring") { $where['invoiceaction'] = 4; } else { if ($status == "Active Recurring") { $where['invoiceaction'] = 4; $where['invoicecount'] = array("sqltype" => "<", "value" => "recurfor"); } else { if ($status == "Completed Recurring") {
/** * * @ WHMCS FULL DECODED & NULLED * * @ Version : 5.2.15 * @ Author : MTIMER * @ Release on : 2013-12-24 * @ Website : http://www.mtimer.cn * **/ define("ADMINAREA", true); require "../init.php"; $aInt = new WHMCS_Admin("View WHOIS Lookup Log"); $aInt->title = $aInt->lang("system", "whois"); $aInt->sidebar = "utilities"; $aInt->icon = "logs"; $aInt->sortableTableInit("date"); $numrows = get_query_val("tblwhoislog", "COUNT(*)", ""); $result = select_query("tblwhoislog", "", "", "id", "DESC", $page * $limit . "," . $limit); while ($data = mysql_fetch_array($result)) { $id = $data['id']; $date = $data['date']; $domain = $data['domain']; $ip = $data['ip']; $tabledata[] = array(fromMySQLDate($date, true), "<a href=\"#\" onclick=\"\$('#frmWhoisDomain').val('" . addslashes($domain) . ("');\$('#frmWhois').submit();return false\">" . $domain . "</a>"), "<a href=\"http://www.geoiptool.com/en/?IP=" . $ip . "\" target=\"_blank\">" . $ip . "</a>"); } $content = $aInt->sortableTable(array($aInt->lang("fields", "date"), $aInt->lang("fields", "domain"), $aInt->lang("fields", "ipaddress")), $tabledata); $content .= "\n<form method=\"post\" action=\"whois.php\" target=\"_blank\" id=\"frmWhois\">\n<input type=\"hidden\" name=\"domain\" value=\"\" id=\"frmWhoisDomain\" />\n</form>\n"; $aInt->content = $content; $aInt->display();
$fieldsarray = call_user_func($params['moduletype'] . "_AdminServicesTabFields", $params); if (is_array($fieldsarray)) { foreach ($fieldsarray as $k => $v) { $tbl->add($k, $v, 1); } } } } $hookret = run_hook("AdminClientServicesTabFields", array("id" => $id)); foreach ($hookret as $hookdat) { foreach ($hookdat as $k => $v) { $tbl->add($k, $v, 1); } } $addonshtml = ""; $aInt->sortableTableInit("nopagination"); $service = new WHMCS_Service($id); $addons = $service->getAddons(); foreach ($addons as $vals) { $tabledata[] = array($vals['regdate'], $vals['name'], $vals['pricing'], $vals['status'], $vals['nextduedate'], "<a href=\"" . $PHP_SELF . "?userid=" . $userid . "&id=" . $id . "&aid=" . $vals['id'] . "\"><img src=\"images/edit.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Edit\"></a>", "<a href=\"#\" onClick=\"doDeleteAddon('" . $vals['id'] . "');return false\"><img src=\"images/delete.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Delete\"></a>"); } $addonshtml = $aInt->sortableTable(array($aInt->lang("addons", "regdate"), $aInt->lang("addons", "name"), $aInt->lang("global", "pricing"), $aInt->lang("fields", "status"), $aInt->lang("fields", "nextduedate"), "", ""), $tabledata); $tbl->add($aInt->lang("addons", "title"), $addonshtml . "<div style=\"padding:5px 25px;\"><a href=\"clientsservices.php?userid=" . $userid . "&id=" . $id . "&aid=add\"><img src=\"images/icons/add.png\" border=\"0\" align=\"top\" /> Add New Addon</a></div>", 1); $customfields = getCustomFields("product", $packageid, $id, true); foreach ($customfields as $customfield) { $tbl->add($customfield['name'], $customfield['input'], 1); } $tbl->add($aInt->lang("services", "overrideautosusp"), $frm->checkbox("overideautosuspend", $aInt->lang("services", "nosuspenduntil"), $overideautosuspend) . " " . $frm->date("overidesuspenduntil", $overidesuspenduntil), 1); $tbl->add($aInt->lang("services", "endofcycle"), $frm->checkbox("autoterminateendcycle", $aInt->lang("services", "reason"), $autoterminateendcycle) . " " . $frm->text("autoterminatereason", $autoterminatereason, "60"), 1); $tbl->add($aInt->lang("fields", "adminnotes"), $frm->textarea("notes", $notes, "4", "100%"), 1); echo $tbl->output();
echo ": "; echo formatCurrency($data[0]); echo "</td><td>"; echo $aInt->lang("transactions", "totalfees"); echo ": "; echo formatCurrency($data[1]); echo "</td><td>"; echo $aInt->lang("transactions", "totalout"); echo ": "; echo formatCurrency($data[2]); echo "</td><td><B>"; echo $aInt->lang("fields", "balance"); echo ": "; echo formatCurrency($data[3]); echo "</B><br></td></tr></table>\n\n<br>\n\n"; $aInt->sortableTableInit("date", "DESC"); $result = select_query("tblaccounts", "COUNT(*)", array("userid" => $userid)); $data = mysql_fetch_array($result); $numrows = $data[0]; $result = select_query("tblaccounts", "", array("userid" => $userid), $orderby, $order, $page * $limit . ("," . $limit)); while ($data = mysql_fetch_array($result)) { $ide = $data['id']; $date = $data['date']; $date = fromMySQLDate($date); $gateway = $data['gateway']; $description = $data['description']; $amountin = $data['amountin']; $fees = $data['fees']; $amountout = $data['amountout']; $transid = $data['transid']; $invoiceid = $data['invoiceid'];
echo "?processwindow=true&id="; echo $id; echo "&failed=true\"><input type=\"hidden\" name=\"cchash\" value=\""; echo $cchash; echo "\"><input type=\"submit\" value=\"Failed\" class=\"button\"></form>\n"; } } $content = ob_get_contents(); ob_end_clean(); $aInt->content = $content; $aInt->displayPopUp(); exit; } ob_start(); $jscode = "function openCCDetails(id) {\nvar winl = (screen.width - 500) / 2;\nvar wint = (screen.height - 400) / 2;\nwinprops = 'height=400,width=500,top='+wint+',left='+winl+',scrollbars=no'\nwin = window.open('" . $_SERVER['PHP_SELF'] . "?processwindow=true" . generate_token("link") . "&id='+id, 'ccdetails', winprops)\nif (parseInt(navigator.appVersion) >= 4) { win.window.focus(); }\n}"; $aInt->sortableTableInit("duedate", "ASC"); $gatewaysarray = getGatewaysArray(); $query = "SELECT tblinvoices.*,tblclients.firstname,tblclients.lastname,tblclients.companyname,tblclients.groupid FROM tblinvoices INNER JOIN tblclients ON tblclients.id=tblinvoices.userid WHERE paymentmethod='offlinecc' AND tblinvoices.status='Unpaid' ORDER BY "; if ($orderby == "clientname") { $query .= "firstname " . db_escape_string($order) . ", lastname"; } else { $query .= db_escape_string($orderby); } $query .= " " . db_escape_string($order); $numresults = full_query($query); $numrows = mysql_num_rows($numresults); $query .= " LIMIT " . (int) $page * $limit . "," . (int) $limit; $result = full_query($query); while ($data = mysql_fetch_array($result)) { $id = $data['id']; $userid = $data['userid'];
insert_query("tblconfiguration", array("setting" => "ModuleDebugMode", "value" => "on")); } $CONFIG['ModuleDebugMode'] = "on"; } if ($disable) { check_token("WHMCS.admin.default"); update_query("tblconfiguration", array("value" => ""), array("setting" => "ModuleDebugMode")); $CONFIG['ModuleDebugMode'] = ""; } if ($reset) { check_token("WHMCS.admin.default"); delete_query("tblmodulelog", "id!=''"); redir(); } if (!$id) { $aInt->sortableTableInit("id"); $numrows = get_query_val("tblmodulelog", "COUNT(*)", "", "id", "DESC"); $result = select_query("tblmodulelog", "", "", "id", "DESC", $page * $limit . "," . $limit); while ($data = mysql_fetch_array($result)) { $id = $data['id']; $date = $data['date']; $module = $data['module']; $action = $data['action']; $request = $data['request']; $response = $data['response']; $arrdata = $data['arrdata']; if ($arrdata) { $response = $arrdata; } $date = fromMySQLDate($date, "time"); $tabledata[] = array("<a href=\"?id=" . $id . "\">" . $date . "</a>", $module, $action, "<textarea rows=\"5\" style=\"width:100%;\">" . htmlentities($request) . "</textarea>", "<textarea rows=\"5\" style=\"width:100%;\">" . htmlentities($response) . "</textarea>");
update_query("tblclients", array("credit" => "+=" . $amount), array("id" => $clientid)); logActivity("Processed Affiliate Commissions Withdrawal to Credit Balance - User ID: " . $clientid . " - Amount: " . $amount); } } redir("action=edit&id=" . $id); exit; } if ($sub == "delete") { check_token("WHMCS.admin.default"); delete_query("tblaffiliates", array("id" => $ide)); logActivity("Affiliate " . $ide . " Deleted"); redir(); } ob_start(); if ($action == "") { $aInt->sortableTableInit("clientname", "ASC"); $query = "FROM `tblaffiliates` INNER JOIN tblclients ON tblclients.id=tblaffiliates.clientid WHERE tblaffiliates.id!=''"; if ($client) { $query .= " AND concat(firstname,' ',lastname) LIKE '%" . db_escape_string($client) . "%'"; } if ($visitors) { $visitorstype = $visitorstype == "greater" ? ">" : "<"; $query .= " AND visitors " . $visitorstype . " '" . db_escape_string($visitors) . "'"; } if ($balance) { $balancetype = $balancetype == "greater" ? ">" : "<"; $query .= " AND balance " . $balancetype . " '" . db_escape_string($balance) . "'"; } if ($withdrawn) { $withdrawntype = $withdrawntype == "greater" ? ">" : "<"; $query .= " AND withdrawn " . $withdrawntype . " '" . db_escape_string($withdrawn) . "'";
redir(); exit; } if ($sub == "delete") { check_token("WHMCS.admin.default"); delete_query("tbllinks", array("id" => $id)); redir(); exit; } ob_start(); if (!$action) { $aInt->deleteJSConfirm("doDelete", "global", "deleteconfirm", "?sub=delete&id="); echo "\n<p>The Link Tracking system allows you to track how people are arriving at your site (what links they are clicking on) and then how many conversions you get from people who have clicked on that link.</p>\n\n<p><b>Options:</b> <a href=\""; echo $PHP_SELF; echo "?action=manage\">Add a New Link</a></p>\n\n"; $aInt->sortableTableInit("id", "ASC"); $result = select_query("tbllinks", "COUNT(*)", "", $orderby, $order); $data = mysql_fetch_array($result); $numrows = $data[0]; $result = select_query("tbllinks", "", "", $orderby, $order, $page * $limit . ("," . $limit)); while ($data = mysql_fetch_array($result)) { $id = $data['id']; $name = $data['name']; $link = $data['link']; $clicks = $data['clicks']; $conversions = $data['conversions']; $displaylink = $link; if (40 < strlen($displaylink)) { $displaylink = substr($link, 0, 40) . "..."; } $conversionrate = @round($conversions / $clicks * 100, 2);
$pagetitle = $aInt->lang("services", "listother"); } else { $pagetitle = $aInt->lang("services", "title"); } } } } $aInt->title = $pagetitle; $aInt->sidebar = "clients"; $aInt->icon = "products"; $aInt->requiredFiles(array("clientfunctions", "customfieldfunctions", "gatewayfunctions")); ob_start(); if (listtype) { $filter = "true"; } $aInt->sortableTableInit("domain", "ASC"); $query = "FROM tblhosting INNER JOIN tblclients ON tblclients.id=tblhosting.userid INNER JOIN tblproducts ON tblhosting.packageid=tblproducts.id WHERE tblhosting.id!='' "; if ($clientname) { $query .= "AND concat(firstname,' ',lastname) LIKE '%" . db_escape_string($clientname) . "%' "; } if ($listtype) { $query .= "AND tblproducts.type='" . db_escape_string($listtype) . "' "; } if ($package) { $query .= "AND tblproducts.id='" . db_escape_string($package) . "' "; } if ($billingcycle) { $query .= "AND tblhosting.billingcycle='" . db_escape_string($billingcycle) . "' "; } if ($server) { $query .= "AND tblhosting.server='" . db_escape_string($server) . "' ";
echo ">"; echo $aInt->lang("promos", "activepromos"); echo "</a> | <a href=\"configpromotions.php?view=expired\""; if ($view == "expired") { echo " style=\"font-weight:bold\""; } echo ">"; echo $aInt->lang("promos", "expiredpromos"); echo "</a> | <a href=\"configpromotions.php?view=all\""; if ($view == "all") { echo " style=\"font-weight:bold\""; } echo ">"; echo $aInt->lang("promos", "allpromos"); echo "</a></p>\n\n"; $aInt->sortableTableInit("code", "ASC"); if ($view == "all") { $where = ""; } else { if ($view == "expired") { $where = "(maxuses>0 AND uses>=maxuses) OR (expirationdate!='0000-00-00' AND expirationdate<'" . date("Ymd") . "')"; } else { $where = "(maxuses<=0 OR uses<maxuses) AND (expirationdate='0000-00-00' OR expirationdate>='" . date("Ymd") . "')"; } } $result = select_query("tblpromotions", "COUNT(*)", $where); $data = mysql_fetch_array($result); $numrows = $data[0]; $result = select_query("tblpromotions", "", $where, "code", "ASC", $page * $limit . ("," . $limit)); while ($data = mysql_fetch_array($result)) { $pid = $data['id'];
} if ($action == "getticketlog") { check_token("WHMCS.admin.default"); $access = validateAdminTicketAccess($id); if ($access) { exit; } $totaltickets = get_query_val("tblticketlog", "COUNT(id)", array("tid" => $id)); $qlimit = 10; $offset = (int) $offset; if ($offset < 0) { $offset = 0; } $endnum = $offset + $qlimit; echo "<div style=\"padding:0 0 5px 0;text-align:left;\">Showing <strong>" . ($offset + 1) . "</strong> to <strong>" . ($totaltickets < $endnum ? $totaltickets : $endnum) . "</strong> of <strong>" . $totaltickets . " total</strong></div>"; $aInt->sortableTableInit("nopagination"); $result = select_query("tblticketlog", "", array("tid" => $id), "date", "DESC", "" . $offset . "," . $qlimit); while ($data = mysql_fetch_array($result)) { $tabledata[] = array(fromMySQLDate($data['date'], 1), "<div style=\"text-align:left;\">" . $data['action'] . "</div>"); } echo $aInt->sortableTable(array($aInt->lang("fields", "date"), $aInt->lang("permissions", "action")), $tabledata); echo "<table width=\"80%\" align=\"center\"><tr><td style=\"text-align:left;\">"; if (0 < $offset) { echo "<a href=\"#\" onclick=\"loadTab(" . $target . ",'ticketlog'," . ($offset - $qlimit) . ");return false\">"; } echo "« Previous</a></td><td style=\"text-align:right;\">"; if ($endnum < $totaltickets) { echo "<a href=\"#\" onclick=\"loadTab(" . $target . ",'ticketlog'," . $endnum . ");return false\">"; } echo "Next »</a></td></tr></table>"; exit;
redir("userid=" . $userid); exit; } else { if ($sub == "delete") { check_token("WHMCS.admin.default"); checkPermission("Delete Client Notes"); delete_query("tblnotes", array("id" => $id)); logActivity("Deleted Note - User ID: " . $userid . " - ID: " . $id); redir("userid=" . $userid); exit; } } } $aInt->deleteJSConfirm("doDelete", "clients", "deletenote", "clientsnotes.php?userid=" . $userid . "&sub=delete&id="); ob_start(); $aInt->sortableTableInit("created", "ASC"); $result = select_query("tblnotes", "COUNT(*)", array("userid" => $userid), "created", "ASC", "", "tbladmins ON tbladmins.id=tblnotes.adminid"); $data = mysql_fetch_array($result); $numrows = $data[0]; $result = select_query("tblnotes", "tblnotes.*,(SELECT CONCAT(firstname,' ',lastname) FROM tbladmins WHERE tbladmins.id=tblnotes.adminid) AS adminuser", array("userid" => $userid), "modified", "DESC"); while ($data = mysql_fetch_array($result)) { $noteid = $data['id']; $created = $data['created']; $modified = $data['modified']; $note = $data['note']; $admin = $data['adminuser']; if (!$admin) { $admin = "Admin Deleted"; } $note = nl2br($note); $note = autoHyperLink($note);
echo ">On Hold</option>\n<option"; if ($stage == "Accepted") { echo " selected"; } echo ">Accepted</option>\n<option"; if ($stage == "Lost") { echo " selected"; } echo ">Lost</option>\n<option"; if ($stage == "Dead") { echo " selected"; } echo ">Dead</option>\n</select></td><td class=\"fieldlabel\">Validity Period</td><td class=\"fieldarea\">"; echo "<s"; echo "elect name=\"validity\"><option value=\"\">Any</option><option>Valid</option><option>Expired</option></select></td></tr>\n</table>\n\n<img src=\"images/spacer.gif\" height=\"10\" width=\"1\"><br>\n<DIV ALIGN=\"center\"><input type=\"submit\" value=\"Filter\" class=\"button\"></DIV>\n\n</form>\n\n </div>\n</div>\n\n<br />\n\n"; $aInt->sortableTableInit("lastmodified", "DESC"); $where = array(); if ($stage) { $where['stage'] = $stage; } if ($validity == "Valid") { $where['validuntil'] = array("sqltype" => ">", "value" => date("Ymd")); } if ($validity == "Expired") { $where['validuntil'] = array("sqltype" => "<=", "value" => date("Ymd")); } if ($userid) { $where['userid'] = $userid; } if ($subject) { $where['subject'] = array("sqltype" => "LIKE", "value" => $subject);
insert_query("tblemailmarketer", array("name" => $name, "type" => $type, "settings" => $settings, "disable" => $disable, "marketing" => $marketing)); } redir(); } if ($action == "delete") { check_token("WHMCS.admin.default"); delete_query("tblemailmarketer", array("id" => $id)); redir(); } ob_start(); if (!$action) { $aInt->deleteJSConfirm("doDelete", "global", "deleteconfirm", "?action=delete&id="); echo "\n<p>The email marketer tool allows you to schedule automated emails to be sent out to your clients when certain events and/or criteria are met.</p>\n\n<p><b>Options:</b> <a href=\""; echo $PHP_SELF; echo "?action=manage\">Create New</a></p>\n\n"; $aInt->sortableTableInit("name", "ASC"); $result = select_query("tblemailmarketer", "COUNT(*)", ""); $data = mysql_fetch_array($result); $numrows = $data[0]; $result = select_query("tblemailmarketer", "", "", $orderby, $order, $page * $limit . ("," . $limit)); while ($data = mysql_fetch_array($result)) { $id = $data['id']; $name = $data['name']; $type = $data['type']; $disable = $data['disable']; $marketing = $data['marketing']; $type = $type == "client" ? "Client" : "Product/Service"; $disable = $disable ? "<img src=\"images/icons/disabled.png\">" : "<img src=\"images/icons/tick.png\">"; $tabledata[] = array($id, $name, $type, "<div align=\"center\">" . $disable . "</a>", "<a href=\"" . $PHP_SELF . "?action=manage&id=" . $id . "\"><img src=\"images/edit.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Edit\"></a>", "<a href=\"#\" onClick=\"doDelete('" . $id . "');return false\"><img src=\"images/delete.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"Delete\"></a>"); } echo $aInt->sortableTable(array("ID", "Name", "Type", "Active", "", ""), $tabledata);