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