} } /* 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>