query($sql) ) { // error msg } // later in upgrade.php $table_name = TABLE_PREFIX.'mod_form_settings'; $field_name = 'perpage_submissions'; $description = "INT NOT NULL DEFAULT '10' AFTER `max_submissions`"; if(!$database->field_exists($table_name,$field_name)) { $database->field_add($table_name, $field_name, $description); } $FTAN = $admin->getFTAN(''); ?>ami_group_member('1') ) { ?>


query($sql)) { $num_fields = $oFields->numRows(); if($num_fields) { ?>
fetchRow(MYSQLI_ASSOC)) { $sFielIdkey = $admin->getIDKEY($aFields['field_id']); ?>
  ID POS
^ up down X


query($sql)) { ?>
numRows() > 0) { // List submissions $emailUser = (function ($userid=0) use ($database) { $retval = ''; if ($userid!='0') { $sql = 'SELECT `email` FROM `'.TABLE_PREFIX.'users` ' . 'WHERE `user_id`=\' '.$userid.'\' '; $retval = $database->get_one($sql); } return $retval; }); while($submission = $oSubmissions->fetchRow(MYSQLI_ASSOC)) { $submission['display_name'] = (($submission['display_name']!=null) ? $submission['display_name'] : $TEXT['GUEST']); $sBody = $submission['body']; $submission['email'] = $emailUser($submission['submitted_by']); if ($submission['email']==''){ $regex = "/[a-z0-9\-_]?[a-z0-9.\-_]+[a-z0-9\-_]?@[a-z0-9.-]+\.[a-z]{2,}/i"; preg_match ($regex, $sBody, $output); // workout if output is empty $submission['email'] = (isset($output['0']) ? $output['0'] : ''); } $sSubmissionIdkey = $admin->getIDKEY($submission['submission_id']); ?>
  ID        
<?php echo $TEXT['OPEN']; ?>     X  

get_error().'
'; echo $sql; }