/** * Search for a member - by real_name or member_name by default. * * @return string */ public function member() { global $user_info, $context; $search = trim(Util::strtolower($_REQUEST['search'])) . '*'; $search = strtr($search, array('%' => '\\%', '_' => '\\_', '*' => '%', '?' => '_', '&' => '&')); require_once SUBSDIR . '/Members.subs.php'; // Find the member. $xml_data = getMember($search, !empty($context['search_param']['buddies']) ? $user_info['buddies'] : array()); return $xml_data; }
function signUp($member_data) { if (!addMember($member_data)) { return false; } $account = getMember($member_data["email"]); $member_data["member_id"] = $account["member_id"]; if (!addMemberInfo($member_data)) { return false; } return true; }
function getParticipation($project_id, $con, $scope, $where, $equal) { $sql_participation = "SELECT " . $scope . " FROM `participation` WHERE " . $where . "" . $equal; $result_participation = mysqli_query($con, $sql_participation); $num_of_rows = mysqli_num_rows($result_participation); if ($num_of_rows != null || $num_of_rows != 0) { $participation_table = array(); while ($row_participation = mysqli_fetch_array($result_participation)) { $participation = array("participation_id" => $row_participation['participation_id'], "project_id" => $row_participation['project_id'], "member_id" => $row_participation['member_id'], "role" => $row_participation['role'], "starting_date" => $row_participation['starting_date'], "ending_date" => $row_participation['ending_date'], "first_name" => getMember($row_participation['member_id'], 0, $con), "last_name" => getMember($row_participation['member_id'], 1, $con)); $participation_table[] = $participation; } return $participation_table; } else { return 0; } }
function getMembersInSchool($mysqli, $schoolId) { if (doesSchoolExist($mysqli, $schoolId)) { if ($stmt = $mysqli->prepare("SELECT member_id FROM members_schools WHERE school_id = ?")) { $stmt->bind_param("i", $schoolId); $stmt->execute(); $stmt->store_result(); $memberId = null; $stmt->bind_result($memberId); $result = array(); while ($stmt->fetch()) { array_push($result, getMember($mysqli, $memberId)); } return $result; } else { return "Faulty MYSQL Statement"; } } else { return "School does not exist"; } }
<?php /* 정통부 우편번호 INSERT TOOL * XLS 파일로 불러서 "우편번호 읍면동 리 도서 주소(전체)" 순으로 탭으로 구분 txt 파일로 저장 * 파일명 zipcode.txt로 같은 디렉토리에 위치시키고 실행시키면 됩니다. * - 읍면동이 빈값일경우 사서함입니다. * ZIPCODE SIDO GUGUN DONG RI BUNJI SIDO_ENG GUGUN_ENG DONG_ENG RI_ENG BUNJI_ENG */ include "_inc.php"; include "_inc.admin.php"; @set_time_limit(0); $filename = "zipcode.txt"; head("style:css/style.css"); getMember(); checkAdmin("god"); echo <<<END <div style='padding:15px; border-bottom:1px solid #ddd; margin-bottom:10px; font:12px dotum;'> \t<span class='word'><span style='font:bold 16px Georgia, tahoma'>the M</span></span>\t\t \t<span style='font:14px Georgia;'>zipcode</span><br /> \t<div style='border:1px solid #e1e1e1; margin-top:10px; padding:5px; background-color:#f0f0f0; line-height:1.5;'> \t\t우정사업본부에서 고시한 우편번호 DB를 이용할 수 있도록 설치합니다.<br /> \t\t- 최신 고시된 우편번호DB는 우정사업본부에서 다운로드 받으실 수 있습니다. <a href='http://www.koreapost.go.kr/' target='_blank'>[우정사업본부 바로가기]</a><br /> \t\t- 우편번호 DB 설치에는 많은 시간이 필요할 수 있습니다.<br /><br /> \t\t- 설치방법 \t\t<ul> \t\t\t<li style='list-style-type:decimal;'>우정사업본부에서 다운로드 받은 파일 중 xls파일을 엑셀로 엽니다.</li> \t\t\t<li style='list-style-type:decimal;'>우편번호, 시도, 시군구, 읍면동, 리, 도서, 번지, 아파트/건물명 순으로 배치합니다.</li> \t\t\t<li style='list-style-type:decimal;'>다른 이름으로 저장을 선택하여 파일 유형을 탭으로 구분한 txt 파일로 선택하고 "zipcode.txt"로 저장 합니다.</li> \t\t\t<li style='list-style-type:decimal;'>zipcode.txt 파일을 @zipcode.php 파일이 있는 미니보드 디렉토리에 업로드 합니다.</li> \t\t\t<li style='list-style-type:decimal;'>@zipcode.php 파일을 웹에서 접근 합니다. (http://자신의도메인/미니보드설치주소/@zipcode.php)</li>
</td> <th>WR</td> <th>CR</td> <th><?php echo $Lpodium[$lang]; ?> </td> <th><?php echo $Ldate[$lang]; ?> </td> </tr> </thead> <tbody> <?php getMember('Bronze'); ?> </tbody> </table> </div> <h3>One event missing</h5> <p><?php echo $aweccM[$lang]; ?> </p> <div class="table-responsive"> <table class="table table-striped table-hover table-responsive table-bordered"> <thead> <tr> <th>No.</td>
break; case 'partMember': $member_id = partMember($_REQUEST['op_id'], $_REQUEST['user_id']); $results['Members'] = getMember($_REQUEST['op_id']); echo json_encode($results); break; case 'getMember': $results = getMember($_REQUEST['op_id'], $_REQUEST['user_id']); echo json_encode($results); break; case 'delMember': delMember($_REQUEST['op_id'], $_REQUEST['user_id']); break; case 'saveShares': $member_id = saveShares($_REQUEST['op_id'], $_REQUEST['user_id'], $_REQUEST['shares']); $results['Members'] = getMember($_REQUEST['op_id']); echo json_encode($results); break; ///// ///// ///// ///// case 'savePayout': break; case 'getPayout': break; case 'delPayout': break; ///// ///// /////
<?php include_once "includes/functions.php"; include_once "includes/db_connect.php"; sec_session_start(); $userId = $_GET['id']; $member = getMember($mysqli, $userId); $schools = getUsersSchools($mysqli, $userId); $groups = getUsersGroups($mysqli, $userId); ?> <!DOCTYPE html> <html> <head> <title>After School</title> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="css/main.css" /> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script> <script src="js/schoolAjax.js"></script> </head> <body> <img src="<?php echo $member["image"]; ?> " height="150" width="150"> <h2><?php echo $member["firstName"] . ' ' . $member["lastName"]; ?> </h2>
<?php include_once 'includes/functions.php'; include_once 'includes/db_connect.php'; sec_session_start(); $id = $_GET['id']; $sortByClass = true; if (isset($_GET['class'])) { $sortByClass = $_GET['class']; } $school = getSchool($mysqli, $id); $schoolName = $school["name"]; $schoolLocation = $school["location"]; $user = getMember($mysqli, $_SESSION['user_id']); $members = getMembersInSchool($mysqli, $id); if ($sortByClass == "true") { $messages = getBoardMessagesWithGraduationYear($mysqli, $id, $user['graduationYear'], 'school'); } else { if ($sortByClass == "false") { $messages = getBoardMessages($mysqli, $id, 'school'); } } $groups = getGroups($mysqli, $id); ?> <!DOCTYPE html> <html> <head> <title>After School</title> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1">
function getLevelFourMenu($text) { global $pwds; $pwds = $text; $phoneNumber = "0" . substr(trim($_GET["phoneNumber"]), 3, 9); $result = getMember($phoneNumber); $name = $result['name']; $dob = $result['dob']; $location = $result['location']; $response = "Please confirm and reply back with:\n1. Its all good\n2. All is not well\nYour name (" . $name . "),\nDate of birth (" . $dob . "),\nLocation (" . $location . ")\n*TestingONLY* (" . $pwds . ")"; return $response; }