-
Notifications
You must be signed in to change notification settings - Fork 0
/
virtengine_db.php
126 lines (114 loc) · 4.26 KB
/
virtengine_db.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?php
function fetchFieldByName( $name, $userid ){
if( empty($name) || empty($userid) )
return false;
$query = "SELECT cfv.value FROM tblcustomfieldsvalues cfv INNER JOIN tblcustomfields cf ON cfv.fieldid = cf.id
WHERE cfv.relid = '".$userid."' AND cf.fieldname = '".$name."'";
$res = full_query($query);
if( mysql_num_rows($res) > 0 ) {
$row = mysql_fetch_assoc($res);
return $row['value'];
}
return false;
}
function fetch_data_by_id($tbl, $id ) {
if(empty($id))
return false;
$query = "SELECT * FROM ".$tbl." WHERE id = '".$id."'";
$res = full_query($query);
if( mysql_num_rows($res) > 0 ) {
$row = mysql_fetch_assoc($res);
return $row;
}
return false;
}
function fetch_data_invoiceItems($tbl, $id ) {
if(empty($id))
return false;
$query = "SELECT * FROM ".$tbl." WHERE invoiceid = '".$id."'";
$res = full_query($query);
if( mysql_num_rows($res) > 0 ) {
$row = mysql_fetch_assoc($res);
return $row;
}
return false;
}
function fetch_order_by_user_id($tbl, $id, $invoice_id) {
$result = select_query($tbl, "", array("userid" => $id));
$apiresults = array();
while ($data = mysql_fetch_array($result)) {
$id = $data['id'];
$ordernum = $data['ordernum'];
$userid = $data['userid'];
$contactid = $data['contactid'];
$date = $data['date'];
$nameservers = $data['nameservers'];
$transfersecret = $data['transfersecret'];
$renewals = $data['renewals'];
$promocode = $data['promocode'];
$promotype = $data['promotype'];
$promovalue = $data['promovalue'];
$orderdata = $data['orderdata'];
$amount = $data['amount'];
$paymentmethod = $data['paymentmethod'];
$invoiceid = $data['invoiceid'];
$status = $data['status'];
$ipaddress = $data['ipaddress'];
$fraudmodule = $data['fraudmodule'];
$fraudoutput = $data['fraudoutput'];
$notes = $data['notes'];
if ($invoiceid == $invoice_id || $invoiceid == 0) {
$apiresults['orders']['order'][] = array(
"orderid" => $id,
"invoiceid" => $invoiceid,
);
}
}
return $apiresults;
}
function getClientProducts($client_id, $order_id) {
$where = array();
if ($client_id) {
$where["tblhosting.userid"] = $client_id;
}
$result = select_query("tblhosting", "COUNT(*)", $where, "", "", "", "tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblproductgroups ON tblproductgroups.id=tblproducts.gid");
$data = mysql_fetch_array($result);
$totalresults = $data[0];
$limitstart = (int)$limitstart;
$limitnum = (int)$limitnum;
if (!$limitnum) {
$limitnum = 999999;
}
$result = select_query("tblhosting", "tblhosting.*,tblproducts.name AS productname,tblproductgroups.name AS groupname,(SELECT CONCAT(name,'|',ipaddress,'|',hostname) FROM tblservers WHERE tblservers.id=tblhosting.server) AS serverdetails,(SELECT tblpaymentgateways.value FROM tblpaymentgateways WHERE tblpaymentgateways.gateway=tblhosting.paymentmethod AND tblpaymentgateways.setting='name' LIMIT 1) AS paymentmethodname", $where, "tblhosting`.`id", "ASC", "" . $limitstart . "," . $limitnum, "tblproducts ON tblproducts.id=tblhosting.packageid INNER JOIN tblproductgroups ON tblproductgroups.id=tblproducts.gid");
$apiresults = array();
while ($data = mysql_fetch_array($result)) {
$id = $data['id'];
$userid = $data['userid'];
$orderid = $data['orderid'];
$pid = $data['packageid'];
$name = $data['productname'];
$groupname = $data[''];
$promoid = $data['promoid'];
$ipaddress = $data['ipaddress'];
$dedicatedip = $data['dedicatedip'];
$assignedips = $data['assignedips'];
$diskusage = $data['diskusage'];
$disklimit = $data['disklimit'];
$bwusage = $data['bwusage'];
$bwlimit = $data['bwlimit'];
$lastupdate = $data['lastupdate'];
$serverdetails = $data['serverdetails'];
$serverdetails = explode("|", $serverdetails);
if ($order_id == $orderid) {
$apiresults['products']['product'][] = array(
"id" => $id,
"clientid" => $userid,
"orderid" => $orderid,
"pid" => $pid,
"name" => $name,
);
}
}
return $apiresults;
}
?>