function update_temp_member($id, $pdo) { // ตรวจสอบว่า เป็น สมาชิกคนที่ 2 หรือ 3 โดย เชคว่า แถวแรก มีค่าเป็น 0 หรือ ไม่ ถ้าเป้น0คือ เป็นมาชิกคนที่ 2 ถ้าไม่ก็คนที่ 3 if (check_position("2", $pdo)) { $sql = "UPDATE temp SET id =:id WHERE No = 2 "; $q = $pdo->prepare($sql); $q->execute(array(':id' => $id)); } else { $sql = "UPDATE temp SET id =:id WHERE No = 3 "; $q = $pdo->prepare($sql); $q->execute(array(':id' => $id)); } }
<div class="alert alert-danger alert-dismissable" align="center"> <strong>ขออภัย </strong> <a class="alert-link">สมาชิกเต็มแล้ว หากต้องการเพิ่ม โปรดติดต่อ อาจารย์ประจำวิชา</a> </div> <!-- </div> </div> --> <?php die; } $sth = $pdo->prepare("SELECT * FROM students WHERE Student_ID = :id"); $sth->bindParam(':id', $id, PDO::PARAM_STR); $sth->execute(); $found = 0; while ($row = $sth->fetch(PDO::FETCH_ASSOC)) { $found++; if (check_position("2", $pdo)) { $No = "2"; } else { $No = "3"; } ?> <!-- <div class="card" align="center"> --> <!-- <hr> --> <div class="row" style="padding-bottom: 15px;"> <br> <div class="col-lg-1" align="center"> <label>ลำดับที่</label> <div> <?php echo $No; ?>
function message_save($id = false) { global $_CLASS; if ($id) { $result = $_CLASS['core_db']->query('SELECT block_position FROM ' . BLOCKS_TABLE . ' WHERE block_id = ' . $id); $block = $_CLASS['core_db']->fetch_row_assoc($result); $_CLASS['core_db']->free_result($result); if (!$block) { redirect(generate_link('messages', array('admin' => true))); } check_position($block['block_position']); // need to validate data with the db type messages_get_data($data, $error); if ($error) { return message_edit($id, $data, $error); } $sql = 'UPDATE ' . BLOCKS_TABLE . ' SET ' . $_CLASS['core_db']->sql_build_array('UPDATE', $data) . ' WHERE block_id = ' . $id; $_CLASS['core_db']->query($sql); } else { messages_get_data($data, $error); if ($error) { return message_edit(false, $data, $error); } $result = $_CLASS['core_db']->query('SELECT MAX(block_order) as block_order FROM ' . BLOCKS_TABLE . ' WHERE block_position = ' . $data['block_position']); list($max_order) = $_CLASS['core_db']->fetch_row_num($result); $_CLASS['core_db']->free_result($result); $data['block_order'] = (int) $max_order + 1; $_CLASS['core_db']->query('INSERT INTO ' . BLOCKS_TABLE . ' ' . $_CLASS['core_db']->sql_build_array('INSERT', $data)); } $_CLASS['core_cache']->destroy('blocks'); $_CLASS['core_display']->meta_refresh('3', generate_link('messages', array('admin' => true))); trigger_error(sprintf($_CLASS['core_user']->lang['SAVED'], generate_link('messages', array('admin' => true)))); }
//Put this line's contents into the nodeinfo array for ($i = 0; $i < sizeof($line_array); $i++) { $node_info["{$current_position}:{$i}"] = $line_array[$i]; } //Get next position of \n, indicating we have another line to read $next_pos = strpos($contents, "\n"); $current_position++; } //Check each user input to make sure the condition is satisfied $node_info = check_position($node_info, $current_position, 1, trim($_GET['build']), $_GET['build_op']); $node_info = check_position($node_info, $current_position, 4, trim($_GET['port']), $_GET['port_op']); $node_info = check_position($node_info, $current_position, 5, trim($_GET['uptime']), $_GET['uptime_op']); $node_info = check_position($node_info, $current_position, 6, trim($_GET['storage']), $_GET['storage_op']); $node_info = check_position($node_info, $current_position, 7, trim($_GET['x_coord']), $_GET['x_coord_op']); $node_info = check_position($node_info, $current_position, 8, trim($_GET['y_coord']), $_GET['y_coord_op']); $node_info = check_position($node_info, $current_position, 9, trim($_GET['estimate']), $_GET['estimate_op']); $num_matching = 0; echo "<p />Matching nodes:<br />"; for ($i = 1; $i < $current_position; $i++) { if ($node_info["{$i}:0"] == true) { $one = "{$i}:1"; $two = "{$i}:2"; $three = "{$i}:3"; $four = "{$i}:4"; $five = "{$i}:5"; $six = "{$i}:6"; $seven = "{$i}:7"; $eight = "{$i}:8"; $nine = "{$i}:9"; $num_matching++; echo "{$num_matching} - {$node_info[$two]} {$node_info[$three]}:{$node_info[$four]}<br />";
</td> </tr> <tr> <th>Username</th><td colspan="2"><?php echo $rows->username; ?> </td> </tr> <tr> <th>User Status</th><td colspan="2"><?php echo check_status($rows->user_status); ?> </td> </tr> <tr> <th>User Position</th><td width="197"><?php echo check_position($rows->user_position); ?> </td> </tr> </tbody> </table> </div><!-- /.box-body --> </div><!-- /.box --> </div><!-- /.col --> </div><!-- /.row -->
function block_save($id = false) { global $_CLASS; if ($id) { $result = $_CLASS['core_db']->query('SELECT block_order, block_position, block_type FROM ' . BLOCKS_TABLE . ' WHERE block_id = ' . $id); $block = $_CLASS['core_db']->fetch_row_assoc($result); $_CLASS['core_db']->free_result($result); if (!$block) { return; } check_position($block['block_position']); // need to validate data with the db type block_get_data($data, $error, $block['block_type']); if ($error) { return block_add($id, $data, $error); } //update old position order if new position is not the same if ($block['block_position'] != $data['block_position']) { // Make an error msg, just incase this fails for some reason blocks_change_position($data['block_position'], $id); } $sql = 'UPDATE ' . BLOCKS_TABLE . ' SET ' . $_CLASS['core_db']->sql_build_array('UPDATE', $data) . ' WHERE block_id = ' . $id; } else { block_get_data($data, $error, get_variable('type', 'REQUEST', BLOCKTYPE_FILE)); if ($error) { return block_add(false, $data, $error); } $result = $_CLASS['core_db']->query('SELECT MAX(block_order) as block_order FROM ' . BLOCKS_TABLE . ' WHERE block_position = ' . $data['block_position']); list($max_order) = $_CLASS['core_db']->fetch_row_num($result); $_CLASS['core_db']->free_result($result); $data['block_order'] = (int) $max_order + 1; $sql = 'INSERT INTO ' . BLOCKS_TABLE . ' ' . $_CLASS['core_db']->sql_build_array('INSERT', $data); } $_CLASS['core_db']->query($sql); $_CLASS['core_cache']->destroy('blocks'); $_CLASS['core_display']->meta_refresh('3', generate_link('blocks', array('admin' => true))); trigger_error(sprintf($_CLASS['core_user']->lang['SAVED'], generate_link('blocks', array('admin' => true)))); }
function format_message($messages, $conf_positions) { $new_message = []; foreach ($messages as &$item) { $item['消息形式'] = check_msgform($item['消息形式']); $item['显示时长'] = intval($item['显示时长']); $item['固定显示'] = check_sticky($item['固定显示']); $item['消息类型'] = check_msgmod($item['消息类型']); $item['弹窗警示'] = check_before_open($item['弹窗警示']); $item['显示位置'] = check_position($item['显示位置'], $conf_positions); $new_message[] = $item; } return $new_message; }
function block_delete($id, $return_link = false) { global $_CLASS; $result = $_CLASS['core_db']->query('SELECT block_order, block_type, block_position FROM ' . BLOCKS_TABLE . ' WHERE block_id=' . $id); $block = $_CLASS['core_db']->fetch_row_assoc($result); $_CLASS['core_db']->free_result($result); if (!$block || $block['block_type'] == BLOCKTYPE_SYSTEM) { trigger_error($block ? 'BLOCK_NOT_DELETABLE' : 'BLOCK_NOT_FOUND'); } check_position($block['block_position']); if (display_confirmation()) { $_CLASS['core_db']->query('DELETE from ' . BLOCKS_TABLE . ' where block_id = ' . $id); $result = $_CLASS['core_db']->query('UPDATE ' . BLOCKS_TABLE . ' SET block_order = block_order-1 WHERE block_position=' . $block['block_position'] . ' AND block_order > ' . $block['block_order']); $_CLASS['core_cache']->destroy('blocks'); if ($return_link) { trigger_error('Block deleted<br/><a href="' . $return_link . '">Click here to return</a>'); } } if ($return_link) { redirect($return_link); } }
function block_content_cache($id, &$message) { global $_CLASS; $result = $_CLASS['core_db']->query('SELECT block_content, block_position, block_title, block_type FROM ' . CORE_BLOCKS_TABLE . ' WHERE block_id = ' . $id); $block = $_CLASS['core_db']->fetch_row_assoc($result); $_CLASS['core_db']->free_result($result); if (!$block) { trigger_error('BLOCK_NOT_FOUND'); } if ($block['block_type'] != BLOCKTYPE_FEED) { trigger_error('BLOCK_NO_CACHE'); } $message = $_CLASS['core_user']->get_lang('CACHE_REMOVED_FOR') . ' RSS Block<br/><i>' . $block['block_title'] . '<i>'; if ($block['block_content'] !== '') { check_position($block['block_position']); $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . " SET block_content = '' WHERE block_id = {$id}"); $_CLASS['core_cache']->destroy('blocks'); } }
function block_order($id, $option) { global $_CLASS; if (!in_array($option, array('down', 'up', 'bottom', 'top'))) { return; } $result = $_CLASS['core_db']->query('SELECT block_position, block_order FROM ' . CORE_BLOCKS_TABLE . ' WHERE block_id= ' . $id); $block = $_CLASS['core_db']->fetch_row_assoc($result); $_CLASS['core_db']->free_result($result); if (!$block) { trigger_error('BLOCK_NOT_FOUND'); } check_position($block['block_position']); settype($block['block_order'], 'integer'); switch ($option) { case 'down': $result = $_CLASS['core_db']->query('SELECT MAX(block_order) as block_order FROM ' . CORE_BLOCKS_TABLE . ' WHERE block_position=' . $block['block_position']); list($max_order) = $_CLASS['core_db']->fetch_row_num($result); $_CLASS['core_db']->free_result($result); if ($block['block_order'] < $max_order) { $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . ' SET block_order = block_order-1 WHERE block_position = ' . $block['block_position'] . ' AND block_order=' . ($block['block_order'] + 1)); $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . ' SET block_order = ' . ($block['block_order'] + 1) . ' WHERE block_id =' . $id); $_CLASS['core_cache']->destroy('blocks'); } break; case 'bottom': $result = $_CLASS['core_db']->query('SELECT MAX(block_order) as block_order FROM ' . CORE_BLOCKS_TABLE . ' WHERE block_position=' . $block['block_position']); list($max_order) = $_CLASS['core_db']->fetch_row_num($result); $_CLASS['core_db']->free_result($result); if ($block['block_order'] < $max_order) { $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . ' SET block_order = block_order-1 WHERE block_position=' . $block['block_position'] . ' AND block_order > ' . $block['block_order']); $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . ' SET block_order = ' . $max_order . ' WHERE block_id = ' . $id); $_CLASS['core_cache']->destroy('blocks'); } break; case 'up': if ($block['block_order'] && $block['block_order'] != 1) { $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . ' SET block_order = block_order+1 WHERE block_position=' . $block['block_position'] . ' AND block_order = ' . ($block['block_order'] - 1)); $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . ' SET block_order=' . ($block['block_order'] - 1) . ' WHERE block_id =' . $id); $_CLASS['core_cache']->destroy('blocks'); } break; case 'top': if ($block['block_order'] != 1) { $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . ' SET block_order = block_order+1 WHERE block_position=' . $block['block_position'] . ' AND block_order < ' . $block['block_order']); $result = $_CLASS['core_db']->query('UPDATE ' . CORE_BLOCKS_TABLE . ' SET block_order = 1 WHERE block_id = ' . $id); $_CLASS['core_cache']->destroy('blocks'); } break; } }