示例#1
0
    }
}
/* Subscriber Details */
if ($pos == 'sbrfulldata') {
    $opSub = $myconn->prepare("SELECT \n\t\t\t\t\t\t\t\t\t\tS.*,\n\t\t\t\t\t\t\t\t\t\tSG.ID AS SGID, SG.group_name\n\t\t\t\t\t\t\t\t FROM \n\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "subscribers AS S,\n\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "subscriber_groups AS SG\n\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\tS.OID=" . set_org_id . " \n\t\t\t\t\t\t\t\t  AND \n\t\t\t\t\t\t\t\t\t\tS.ID=?\n\t\t\t\t\t\t\t\t  AND\n\t\t\t\t\t\t\t\t\t\t(SG.ID = S.GID)\n\t\t\t\t\t\t\t\t\t") or die(mysqli_error($myconn));
    $opSub->bind_param('i', $ID);
    $opSub->execute();
    $opSub->store_result();
    if ($opSub->num_rows == 0) {
        echo errMod(letheglobal_record_not_found, 'danger');
    } else {
        $sr = new Statement_Result($opSub);
        $jsonBld = new lethe();
        $jsonBld->OID = set_org_id;
        $opSub->fetch();
        $buildJSON = $jsonBld->buildJSON($sr->Get('ID'));
        $dataCont = '
				<table class="footable">
				  <thead>
					<tr>
						<th colspan="2">' . $sr->Get('subscriber_mail') . '</th>
					</tr>
				  </thead>
				  <tbody>
					<tr>
						<td width="200"><strong>' . subscribers_groups . '</strong></td>
						<td>' . showIn($sr->Get('group_name'), 'page') . '</td>
					</tr>
					<tr>
						<td><strong>' . letheglobal_name . '</strong></td>
						<td>' . ($sr->Get('subscriber_name') == '' ? '<span class="text-danger glyphicon glyphicon-ban-circle"></span>' : showIn($sr->Get('subscriber_name'), 'page')) . '</td>