function insertMember($host, $user, $pass, $database, $table)
{
$query = "INSERT INTO {$table} (ime,prezime,adresa,postnum,mjesto,telefon,email,skola,clan,auto,izlet,majica,boja,velicina,user,password) VALUES ('{$this->ime}', '{$this->prezime}', '{$this->adresa}', '{$this->brojPoste}', '{$this->mjesto}', '{$this->telefon}', '{$this->email}', '{$this->skola}', '{$this->clan}', '{$this->auto}', '{$this->izlet}', '{$this->majica}', '{$this->boja}', '{$this->velicina}', '{$this->username}', '" . md5($this->password) . "')";
try {
$conn = new mysqlConnection($host, $user, $pass, $database);
$conn->open();
mysql_query($query);
$success = true;
$conn->close();
unset($conn);
} catch (Exception $e) {
echo $e->getMessage();
$success = false;
}
return $success;
}
private static function initiateConnection()
{
// self::$conn = new mysqli('localhost', 'root', 'salam', 'newest');
self::$conn = new mysqli('localhost', 'newest', 'OZqXiGU&]D', 'newest');
if (self::$conn->connect_errno > 0) {
die('Unable to connect to database [' . self::$conn->connect_error . ']');
return false;
}
return true;
}
/**
dcCore constructor inits everything related to Dotclear. It takes arguments
to init database connection.
@param driver <b>string</b> Database driver name
@param host <b>string</b> Database hostname
@param db <b>string</b> Database name
@param user <b>string</b> Database username
@param password <b>string</b> Database password
@param prefix <b>string</b> DotClear tables prefix
@param persist <b>boolean</b> Persistent database connection
*/
public function __construct($driver, $host, $db, $user, $password, $prefix, $persist)
{
$this->con = dbLayer::init($driver, $host, $db, $user, $password, $persist);
# define weak_locks for mysql
if ($this->con instanceof mysqlConnection) {
mysqlConnection::$weak_locks = true;
}
$this->prefix = $prefix;
$this->error = new dcError();
$this->auth = $this->authInstance();
$this->session = new sessionDB($this->con, $this->prefix . 'session', DC_SESSION_NAME, '', null, DC_ADMIN_SSL);
$this->url = new urlHandler();
$this->plugins = new dcModules($this);
$this->rest = new dcRestServer($this);
$this->addFormater('xhtml', create_function('$s', 'return $s;'));
$this->addFormater('wiki', array($this, 'wikiTransform'));
}
function confCopy_options()
{
global $array;
$options = NULL;
$mysql = new mysqlConnection();
$mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_config\n\t\t\tWHERE board_id!='{$array['board_id']}'\n\t\t\tORDER BY name ASC\n\t\t");
if ($mysql->numRows() > 0) {
$options = "<option value=\"NONE\">게시판 선택</option>";
do {
$options .= "<option value=\"" . $mysql->fetch("board_id") . "\">" . $mysql->fetch("name") . " (" . $mysql->fetch("board_id") . ")</option>";
} while ($mysql->nextRec());
return $options;
} else {
return $options .= "<option value=\"NONE\">복사 대상 없음</option>";
}
}
/**
dcCore constructor inits everything related to Dotclear. It takes arguments
to init database connection.
@param driver <b>string</b> Database driver name
@param host <b>string</b> Database hostname
@param db <b>string</b> Database name
@param user <b>string</b> Database username
@param password <b>string</b> Database password
@param prefix <b>string</b> DotClear tables prefix
@param persist <b>boolean</b> Persistent database connection
*/
public function __construct($driver, $host, $db, $user, $password, $prefix, $persist)
{
if (defined('DC_START_TIME')) {
$this->stime = DC_START_TIME;
} else {
$this->stime = microtime(true);
}
$this->con = dbLayer::init($driver, $host, $db, $user, $password, $persist);
# define weak_locks for mysql
if ($this->con instanceof mysqlConnection) {
mysqlConnection::$weak_locks = true;
} elseif ($this->con instanceof mysqliConnection) {
mysqliConnection::$weak_locks = true;
}
# define searchpath for postgresql
if ($this->con instanceof pgsqlConnection) {
$searchpath = explode('.', $prefix, 2);
if (count($searchpath) > 1) {
$prefix = $searchpath[1];
$sql = 'SET search_path TO ' . $searchpath[0] . ',public;';
$this->con->execute($sql);
}
}
$this->prefix = $prefix;
$ttl = DC_SESSION_TTL;
if (!is_null($ttl)) {
if (substr(trim($ttl), 0, 1) != '-') {
// Clearbricks requires negative session TTL
$ttl = '-' . trim($ttl);
}
}
$this->error = new dcError();
$this->auth = $this->authInstance();
$this->session = new sessionDB($this->con, $this->prefix . 'session', DC_SESSION_NAME, '', null, DC_ADMIN_SSL, $ttl);
$this->url = new dcUrlHandlers();
$this->plugins = new dcPlugins($this);
$this->rest = new dcRestServer($this);
$this->meta = new dcMeta($this);
$this->log = new dcLog($this);
}
<?php
include "../../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$mysql = new mysqlConnection();
$method = new methodController();
$method->method_param("GET", "board_id,file");
$file = urldecode($file);
$filepath = __DIR_PATH__ . "modules/board/upload/" . $board_id . "/" . $file;
$filename = iconv("UTF-8", "EUC-KR", $file);
/*
게시물 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_data_{$board_id}\n\t\tWHERE file1='{$file}' OR file2='{$file}'\n\t");
$file1_name = $mysql->fetch("file1");
$file2_name = $mysql->fetch("file2");
/*
첨부된 파일이 file1 인지 file2 인지 확인
*/
if ($file1_name == $file) {
$file_tar = 'file1';
$td_tar = 'file1_cnt';
} else {
if ($file2_name == $file) {
$file_tar = 'file2';
$td_tar = 'file2_cnt';
} else {
exit;
}
}
/*
<?php
$tpl = new skinController();
$header = new skinController();
$loop = new skinController();
$footer = new skinController();
$mysql = new mysqlConnection();
$lib = new libraryClass();
$paging = new pagingClass();
$method = new methodController();
$method->method_param("GET", "page");
/*
페이징 설정
*/
$paging_query = "\n\t\tSELECT B.*,B.me_login_ip AS status_ip,A.guest_ip\n\t\tFROM toony_admin_member_online A\n\t\tLEFT OUTER JOIN toony_member_list B\n\t\tON A.me_idno=B.me_idno\n\t\tWHERE A.visitdate > DATE_SUB(now(), INTERVAL 55 MINUTE) AND (B.me_admin!='Y' OR B.me_admin IS NULL) AND B.me_drop_regdate IS NULL\n\t\tORDER BY A.visitdate DESC\n\t";
$mysql->select($paging_query);
$paging_query_no = $mysql->numRows();
$paging->page_param($page);
$total_num = $paging->setTotal($paging_query_no);
$paging->setListPerPage(10);
$sql = $paging->getPaggingQuery($paging_query);
$mysql->select($sql);
$array_total = $mysql->numRows();
/*
템플릿 로드
*/
$tpl->skin_file_path("admin/_tpl/connectingMember.html");
$header->skin_html_load($tpl->skin);
$header->skin_loop_header("[{loop_start}]");
$loop->skin_html_load($tpl->skin);
$loop->skin_loop_array("[{loop_start}]", "[{loop_end}]");
<?php
include_once __DIR_PATH__ . "modules/board/install/installCheck.php";
$tpl = new skinController();
$mysql = new mysqlConnection();
$method = new methodController();
$method->method_param("GET", "act,type");
/*
변수 처리
*/
if (!$type) {
$type = "new";
}
/*
수정 모드인 경우 기본 정보 로드
*/
if ($type == "modify") {
$mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_config\n\t\t\tWHERE board_id='{$act}'\n\t\t");
$mysql->fetchArray("write_point,read_point,skin,board_id,name,list_limit,length_limit,use_secret,use_comment,use_likes,use_category,category,use_reply,use_vote,use_file1,use_file2,use_list,file_limit,void_html,controll_level,write_level,read_level,secret_level,comment_level,array_level,reply_level,delete_level,top_file,bottom_file,thumb_width,thumb_height,articleIMG_width,articleIMG_height,article_length,ico_file,ico_mobile,ico_secret,ico_secret_def,ico_new,ico_new_def,ico_hot,ico_hot_def,tc_1,tc_2,tc_3,tc_4,tc_5");
$array = $mysql->array;
$mysql->htmlspecialchars = 0;
$mysql->nl2br = 0;
$array['top_source'] = $mysql->fetch("top_source");
$array['bottom_source'] = $mysql->fetch("bottom_source");
}
/*
홈페이지&모바일페이지 설정 값이 함께 기록되는 필드인 경우 분리
*/
$use_list_exp = explode("|", $array['use_list']);
$array['use_list'] = $use_list_exp[0];
$array['use_m_list'] = $use_list_exp[1];
function total_count()
{
$query = new mysqlConnection();
$query->select("select count(*) total_count from toony_admin_counter");
return number_format($query->fetch("total_count"));
}
<?php
include "include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$lib = new libraryClass();
$method = new methodController();
$mysql = new mysqlConnection();
$mailSender = new mailSender();
$validator = new validator();
$method->method_param("POST", "chk_agreement,chk_private,id,password,password02,nick,sex,phone,telephone");
$lib->security_filter("referer");
$lib->security_filter("request_get");
/*
검사
*/
if ($member['me_level'] < 10) {
$validator->validt_diserror("", "이미 회원가입이 되어 있습니다.");
}
$validator->validt_checked("chk_agreement", "이용약관에 동의해야 합니다.");
$validator->validt_checked("chk_private", "개인정보취급방침에 동의해야 합니다.");
$validator->validt_email("id", 1, "");
$validator->validt_password("password", 1, "");
if ($password != $password02) {
$validator->validt_diserror("password02", "");
}
$validator->validt_nick("nick", 1, "");
$validator->validt_phone("phone", 0, "");
$validator->validt_phone("telephone", 0, "");
$password_val = "password('{$password}')";
/*
이미 존재하는 아이디인지 검사
<?php
include "../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$lib = new libraryClass();
$mysql = new mysqlConnection();
$method = new methodController();
$fileUploader = new fileUploader();
$validator = new validator();
$method->method_param("POST", "href,depth,parent,forward,callName,type,org,module,page,name,class,title_img_ed,img_ed,img2_ed,del_title_img,del_img,del_img2,link,linkDoc,vtype,useMenu,useMenu_header_val,useMenu_side,useMenu_side_val");
$method->method_param("FILE", "title_img,img,img2");
$lib->security_filter("referer");
$lib->security_filter("request_get");
/*
변수 처리
*/
if (!$vtype) {
$vtype = "p";
}
if ($useMenu_side_val == "disabled" || $useMenu_side == "checked") {
$useMenu_side = "Y";
} else {
$useMenu_side = "N";
}
if ($useMenu_header_val == "disabled" || $useMenu == "checked") {
$useMenu = "Y";
} else {
$useMenu = "N";
}
/*
검사
<?php
include_once __DIR_PATH__ . "include/pageJustice.inc.php";
$tpl = new skinController();
$write_password = new skinController();
$skin_write = new skinController();
$method = new methodController();
$lib = new libraryClass();
$mysql = new mysqlConnection();
$session = new sessionController();
$method->method_param("GET", "mode,read,page,where,keyword,category");
$method->method_param("POST", "s_password");
$session->session_selector("__toony_member_idno");
/*
패스워드가 submit 된 경우 GET변수를 POST변수로 변환
*/
if ($s_password != "") {
$method->method_param("POST", "s_board_id,s_mode,s_read,s_password,s_page");
$board_id = $s_board_id;
$read = $s_read;
$mode = $s_mode;
$page = $s_page;
}
if (isset($HTTP_POST_VARS['keyword'])) {
$method->method_param("POST", "where,keyword");
}
/*
게시물 설정 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t");
$mysql->fetchArray("skin,title,use_comment,use_list,use_secret,use_category,category,use_reply,use_file1,use_file2,void_html,file_limit,list_limit,length_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,reply_level,controll_level,top_file,bottom_file,ico_secret_def,tc_1,tc_2,tc_3,tc_4,tc_5");
function getmanfullrevall($manid)
{
//printf('manid: '.$manid.'');
//$cloud = mysql_query("SELECT man_id, title_orig, genre, notes, stat_id, per_id, datesubmitted FROM tbl_manuscript WHERE man_id=$manid") or die(mysql_error());
$query = "SELECT man_id, title_orig, genre, notes, stat_id, per_id, datesubmitted FROM tbl_manuscript WHERE man_id={$manid} ORDER by dateSubmitted ASC";
if (!($res = mysqlConnection::getConnection()->query($query))) {
die('There was an error running the query [' . $query->error . ']');
}
$num_rows = $res->num_rows;
if ($num_rows < 1) {
printf("You do not have any active reviews currently assigned.<br /> See the left hand menu for your options.");
} else {
// $arr = mysql_fetch_assoc($cloud);
$arr = $res->fetch_assoc();
$title = $arr['title_orig'];
$genre = $arr['genre'];
$notes = $arr['notes'];
$statid = $arr['stat_id'];
$submitted = $arr['datesubmitted'];
$perid = $arr['per_id'];
$author = authname($perid);
printf('
<div id="review" style="border-top:1px solid #ccc;">
<table>
<tr><td style="width:105px">Manuscript ref:</td><td>#' . $arr['man_id'] . '  <a href="reviewmanuscript.php?manid=' . $arr['man_id'] . '">My Review</a></td></tr>
<tr><td>Author:</td><td>' . $author . '</td></tr>
<tr><td>Title:</td><td>' . $title . '</td></tr>
<tr><td>Genre:</td><td>' . $genre . '</td></tr>
<tr><td>Notes:</td><td>' . $notes . '</td></tr>');
getstatus($arr['stat_id']);
printf('<tr><td>Date submitted:</td><td>' . $submitted . '</td></tr>
</table></div>');
}
}
<?php
include "../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$lib = new libraryClass();
$mysql = new mysqlConnection();
$method = new methodController();
$validator = new validator();
$method->method_param("POST", "skinType,skinName");
$lib->security_filter("referer");
$lib->security_filter("request_get");
/*
홈페이지, 모바일페이지를 구분하여 DB update 구문 작성
*/
if ($skinType == "p") {
$update = "ad_site_layout='{$skinName}'";
} else {
$update = "ad_msite_layout='{$skinName}'";
}
/*
DB수정
*/
$mysql->query("\n\t\tUPDATE toony_admin_siteconfig SET\n\t\t{$update}\n\t");
/*
완료후 리턴
*/
$validator->validt_success("성공적으로 반영 되었습니다.", "");
<?php
include "../../../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$lib = new libraryClass();
$mysql = new mysqlConnection();
$method = new methodController();
$validator = new validator();
$method->method_param("POST", "type,board_id,skin,name,use_list,use_m_list,use_secret,use_comment,use_likes,use_reply,use_category,category,use_file1,use_file2,file_limit,list_limit,list_m_limit,length_limit,length_m_limit,array_level,write_level,secret_level,comment_level,delete_level,read_level,controll_level,reply_level,write_point,read_point,top_file,top_source,bottom_file,bottom_source,thumb_width,thumb_m_width,thumb_height,thumb_m_height,articleIMG_width,articleIMG_m_width,articleIMG_height,articleIMG_m_height,article_length,article_m_length,ico_file_p,ico_file_m,ico_mobile_p,ico_mobile_m,ico_secret_p,ico_secret_m,ico_secret_def,ico_new_p,ico_new_m,ico_new_def,ico_hot_def_v,ico_hot_def_r,ico_hot_def_type,ico_hot_p,ico_hot_m,tc_1,tc_2,tc_3,tc_4,tc_5");
$lib->security_filter("referer");
$lib->security_filter("request_get");
/*
검사
*/
if ($type == "new") {
$mysql->select("\n\t\t\tSELECT *\n\t\t\tFROM toony_module_board_config\n\t\t\tWHERE board_id='{$board_id}'\n\t\t");
if ($mysql->numRows() > 0) {
$validator->validt_diserror("board_id", "이미 존재하는 코드입니다.");
}
$validator->validt_idx("board_id", 1, "");
}
$validator->validt_null("name", "");
$validator->validt_number("list_limit", 1, 10, 1, "");
$validator->validt_number("list_m_limit", 1, 10, 1, "");
$validator->validt_number("length_limit", 1, 10, 1, "");
$validator->validt_number("length_m_limit", 1, 10, 1, "");
$validator->validt_number("file_limit", 1, 10, 1, "");
$validator->validt_number("article_length", 1, 10, 1, "");
$validator->validt_number("article_m_length", 1, 10, 1, "");
$validator->validt_number("write_point", 1, 10, 1, "");
$validator->validt_number("read_point", 1, 10, 1, "");
<?php
$tpl = new skinController();
$mysql = new mysqlConnection();
/*
레이아웃 스킨 템플릿 로드
*/
$tpl->skin_file_path("layoutskin/" . CALLED_LAYOUTDIR . "sub.html");
/*
서브페이지 네비게이션 선언
*/
if (CALLED_DEPTH == 1) {
$where = "callName='" . CALLED_ARTICLE . "'";
} else {
if (CALLED_DEPTH == 2) {
$where = "(callName='" . CALLED_ARTICLE . "') OR (class='" . CALLED_CLASS . "' AND depth=1)";
} else {
if (CALLED_DEPTH == 3) {
$where = "(callName='" . CALLED_ARTICLE . "') OR (class='" . CALLED_CLASS . "' AND depth=1) OR (idno='" . CALLED_PARENT . "' AND depth=2)";
}
}
}
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_admin_menuInfo\n\t\tWHERE vtype='" . CALLED_VIEWTYPE . "' AND drop_regdate IS NULL AND ({$where})\n\t\tORDER BY depth ASC\n\t");
$naviTxt = "<a href=\"{$site_config['ad_site_url']}" . CALLED_VIEWDIR . "\">{$site_config['ad_site_name']}</a>";
//depth가 1인 경우 1차 메뉴 출력
if (CALLED_DEPTH == 1) {
$naviTxt .= " > <a href=\"?article=" . $mysql->fetch("callName") . "\">" . $mysql->fetch("name") . "</a>";
//depth가 2 이상인 경우 2차 메뉴 출력
} else {
do {
$naviTxt .= " > <a href=\"?article=" . $mysql->fetch("callName") . "\">" . $mysql->fetch("name") . "</a>";
<?php
$tpl = new skinController();
$header = new skinController();
$loop = new skinController();
$footer = new skinController();
$mysql = new mysqlConnection();
$lib = new libraryClass();
$paging = new pagingClass();
$method = new methodController();
$method->method_param("GET", "page");
/*
페이징 설정
*/
$paging_query = "\n\t\tSELECT * \n\t\tFROM toony_admin_popupconfig\n\t\tORDER BY regdate DESC\n\t";
$mysql->select($paging_query);
$paging_query_no = $mysql->numRows();
$paging->page_param($page);
$total_num = $paging->setTotal($paging_query_no);
$paging->setListPerPage(10);
$sql = $paging->getPaggingQuery($paging_query);
$mysql->select($sql);
$array_total = $mysql->numRows();
/*
템플릿 로드
*/
$tpl->skin_file_path("admin/_tpl/popupList.html");
$header->skin_html_load($tpl->skin);
$header->skin_loop_header("[{loop_start}]");
$loop->skin_html_load($tpl->skin);
$loop->skin_loop_array("[{loop_start}]", "[{loop_end}]");
<?php
$tpl = new skinController();
$mysql = new mysqlConnection();
/*
기본 정보 로드
*/
$mysql->select("\n\t\tSELECT source\n\t\tFROM toony_admin_mailling_template\n\t\tWHERE type='mailling'\n\t");
$mysql->htmlspecialchars = 0;
$mysql->nl2br = 0;
$sourceCode = $mysql->fetch("source");
/*
템플릿 로드
*/
$tpl->skin_file_path("admin/_tpl/mailTplMailling.html");
/*
템플릿 치환
*/
$tpl->skin_modeling("[sourceCode]", $sourceCode);
echo $tpl->skin_echo();
<?php
$tpl = new skinController();
$header = new skinController();
$loop = new skinController();
$footer = new skinController();
$mysql = new mysqlConnection();
$lib = new libraryClass();
$paging = new pagingClass();
$method = new methodController();
$method->method_param("GET", "page,where,keyword,order,orderby");
/*
검색 키워드 설정
*/
if (trim($keyword) != "") {
$array_where = $where . " LIKE '%" . $keyword . "%' AND me_admin!='Y' AND me_drop_regdate IS NOT NULL";
} else {
$array_where = "me_admin!='Y' AND me_drop_regdate IS NOT NULL";
}
/*
정렬 기준 설정
*/
if (!$order) {
$order = "me_drop_regdate";
}
if (!$orderby) {
$orderby = "DESC";
}
$array_order = $order . " " . $orderby;
/*
페이징 설정
<?php
$tpl = new skinController();
$lib = new libraryClass();
$mysql = new mysqlConnection();
/*
검사
*/
if ($member['me_admin'] != "Y") {
$lib->error_alert_location("접근 권한이 없습니다.", $site_config[ad_site_url], "A");
}
/*
최고 운영자 기본 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_member_list\n\t\tWHERE me_admin='Y' AND me_level=1\n\t");
$mysql->fetchArray("me_id,me_nick,me_sex,me_phone,me_telephone,me_password,me_point");
$array = $mysql->array;
/*
템플릿 로드
*/
$tpl->skin_file_path("admin/_tpl/adminInfo.html");
/*
템플릿 함수
*/
function sex_checked_value_func($obj)
{
global $array;
switch ($array['me_sex']) {
case "M":
if ($obj == "M") {
return "checked";
<?php
include_once __DIR_PATH__ . "include/pageJustice.inc.php";
$tpl = new skinController();
$method = new methodController();
$lib = new libraryClass();
$mysql = new mysqlConnection();
$read_true_3 = new skinController();
$skin_read = new skinController();
$session = new sessionController();
$method->method_param("GET", "read,page,where,keyword,category");
$method->method_param("POST", "s_password");
/*
세션 로드
*/
$__toony_board_view = $session->session_selector('__toony_board_view_' . $board_id . '_' . $read);
//조회수 세션
/*
패스워드가 submit된 경우
*/
if ($s_password != "") {
$method->method_param("POST", "s_board_id,s_mode,s_read,s_password,s_page,where,keyword");
$board_id = $s_board_id;
$read = $s_read;
$mode = $s_mode;
$page = $s_page;
}
/*
게시물 설정 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t");
<?php
$tpl = new skinController();
$header = new skinController();
$loop = new skinController();
$footer = new skinController();
$mysql = new mysqlConnection();
$lib = new libraryClass();
$paging = new pagingClass();
$method = new methodController();
$method->method_param("GET", "page,where,keyword");
/*
검색 키워드 설정
*/
if (trim($keyword) != "") {
$array_where = $where . " LIKE '%" . $keyword . "%'";
} else {
$array_where = "1";
}
/*
페이징 설정
*/
$paging_query = "\n\t\tSELECT *\n\t\tFROM toony_admin_security_member\n\t\tWHERE {$array_where}\n\t\tORDER BY regdate DESC\n\t";
$mysql->select($paging_query);
$paging_query_no = $mysql->numRows();
$paging->page_param($page);
$total_num = $paging->setTotal($paging_query_no);
$paging->setListPerPage(10);
$sql = $paging->getPaggingQuery($paging_query);
$mysql->select($sql);
$array_total = $mysql->numRows();
<?php
$mysql = new mysqlConnection();
$lib = new libraryClass();
$tpl = new skinController();
$method = new methodController();
$method->method_param("POST", "submitVal");
/*
모듈이 설치되어 있는지 검사
*/
if ($mysql->is_table("toony_module_board_config")) {
$lib->error_location("?m=board&p=boardList", "A");
}
/*
POST 변수가 전달된 경우 모듈을 설치
*/
if ($submitVal) {
include __DIR_PATH__ . "modules/board/install/schema.php";
$mysql->query($db_toony_board_like);
$mysql->query($db_toony_board_config);
$mysql->query($db_insert_toony_board_config);
$mysql->query($db_toony_module_board_data_notice);
$mysql->query($db_toony_module_board_comment_notice);
$mysql->query($db_toony_module_board_data_notice_value);
$mysql->query($db_toony_module_board_data_webzine);
$mysql->query($db_toony_module_board_comment_webzine);
$mysql->query($db_toony_module_board_data_webzine_value);
$mysql->query($db_toony_module_board_data_gallery);
$mysql->query($db_toony_module_board_comment_gallery);
$mysql->query($db_toony_module_board_data_gallery_value);
$lib->error_alert_location("설치가 완료 되었습니다.", "?m=board&p=boardList", "A");
<?php
include "../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$lib = new libraryClass();
$mysql = new mysqlConnection();
$method = new methodController();
$validator = new validator();
$method->method_param("POST", "level_1,level_2,level_3,level_4,level_5,level_6,level_7,level_8,level_9");
$lib->security_filter("referer");
$lib->security_filter("request_get");
/*
레벨 POST변수 배열화
*/
$level['1'] = $level_1;
$level['2'] = $level_2;
$level['3'] = $level_3;
$level['4'] = $level_4;
$level['5'] = $level_5;
$level['6'] = $level_6;
$level['7'] = $level_7;
$level['8'] = $level_8;
$level['9'] = $level_9;
/*
검사
*/
for ($i = 1; $i <= 9; $i++) {
if (trim($level[$i]) == "") {
$validator->validt_diserror("level_" . $i, "");
}
}
<?php
include "../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$mysql = new mysqlConnection();
?>
<!DOCTYPE HTML>
<html>
<head>
<link type="text/css" rel="stylesheet" href="library/css/common.css" />
<link type="text/css" rel="stylesheet" href="library/css/visualize.jQuery.css" />
<style type="text/css">
body{ padding:0; margin:0; }
*{ font-size:11px; font-family:Arial; font-size:10px; }
.visualize{ margin-left:30px; margin-top:12px; }
.visualize-info{ margin-top:7px; }
.visualize-labels-x li .label{ width:30px; font-weight:bold; font-size:11px; }
.visualize-label-pos span{ font-family:Arial; }
.visualize-info *{ font-size:11px !important; }
</style>
<script type="text/javascript" src="library/js/jquery-1.7.1.js"></script>
<script type="text/javascript" src="library/js/visualize.jQuery.js"></script>
<!--[if IE]><script type="text/javascript" src="library/js/excanvas.compiled.js"></script><![endif]-->
<script type="text/javascript">
$(function(){
$('table').visualize({
type:'pie',
width:'343px',
height:'280px',
lineWeight:'2' ,
pieMargin: 10,
<?php
include "../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$lib = new libraryClass();
$mysql = new mysqlConnection();
$method = new methodController();
$validator = new validator();
$method->method_param("POST", "vtype,body_bgColor,body_txtColor,body_txtSize,link_txtColor,link_hoverColor,link_activeColor,link_visitedColor,link_txtSize,input_txtColor,input_txtSize,useDefault");
$lib->security_filter("referer");
$lib->security_filter("request_get");
/*
변수 처리
*/
if ($useDefault == "checked") {
$useDefault = "Y";
} else {
$useDefault = "N";
}
/*
검사
*/
$validator->validt_number("body_txtSize", 1, 10, 1, "");
$validator->validt_number("link_txtSize", 1, 10, 1, "");
$validator->validt_number("input_txtSize", 1, 10, 1, "");
/*
DB수정
*/
$mysql->query("\n\t\tUPDATE toony_admin_design_bodyStyle\n\t\tSET\n\t\tbody_bgColor='{$body_bgColor}',body_txtColor='{$body_txtColor}',body_txtSize='{$body_txtSize}',link_txtColor='{$link_txtColor}',link_hoverColor='{$link_hoverColor}',\n\t\tlink_activeColor='{$link_activeColor}',link_visitedColor='{$link_visitedColor}',link_txtSize='{$link_txtSize}',input_txtColor='{$input_txtColor}',input_txtSize='{$input_txtSize}',useDefault='{$useDefault}'\n\t\tWHERE vtype='{$vtype}'\n\t");
/*
완료 후 리턴
<?php
include "../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$lib = new libraryClass();
$mysql = new mysqlConnection();
$method = new methodController();
$fileUploader = new fileUploader();
$validator = new validator();
$method->method_param("POST", "type,name,memo,void_use,void_link,link,bleft,btop,target,img_ed,start_level,end_level,pop_article,pop_article_txt");
$method->method_param("FILE", "img");
$lib->security_filter("referer");
$lib->security_filter("request_get");
/*
검사
*/
//입력값 검사
if ($type == "new" || $type == "modify") {
$validator->validt_idx("name", 1, "");
$validator->validt_null("memo", "");
$validator->validt_number("btop", 0, 5, 1, "");
$validator->validt_number("bleft", 0, 5, 1, "");
if ($start_level < $end_level) {
$validator->validt_diserror("start_level", "최소 레벨이 최대 레벨보다 클 수 없습니다.");
}
if ($pop_article == "select" && trim($pop_article_txt) == "") {
$validator->validt_diserror("pop_article_txt", "");
}
}
//추가 모드인 경우 추가 입력값 검사
if ($type == "new") {
<?php
include "../../include/engine.inc.php";
include __DIR_PATH__ . "include/global.php";
$lib = new libraryClass();
$mysql = new mysqlConnection();
$method = new methodController();
$validator = new validator();
$lib->security_filter("referer");
$lib->security_filter("request_get");
$method->method_param("POST", "board_id,read_idno,mode");
/*
게시물 설정 정보 로드
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_config\n\t\tWHERE board_id='{$board_id}'\n\t");
$mysql->fetchArray("use_likes");
$c_array = $mysql->array;
/*
검사
*/
if ($c_array['use_likes'] == "N") {
$validator->validt_diserror("", "추천 기능 비활성 중입니다.");
}
if ($member['me_level'] > 9) {
$validator->validt_diserror("", "추천 권한이 없습니다.\n\n추천/비추천은 회원만 가능합니다.");
}
/*
이미 추천.비추천 했는지 검사
*/
$mysql->select("\n\t\tSELECT *\n\t\tFROM toony_module_board_like\n\t\tWHERE board_id='{$board_id}' AND read_idno='{$read_idno}' AND me_idno='{$member['me_idno']}'\n\t");
if ($mysql->numRows() > 0) {
<?php
header('Content-Type: application/json');
$rest_json = file_get_contents("php://input");
$_POST = json_decode($rest_json, true);
$_POST = parse_str($rest_json, $parameters);
$aResult = array();
include './model/mysqlConnection.php';
if ($parameters['arguments']['0'] == null) {
echo 'Wrong Parameters';
die;
// die('Wrong Parameters');
}
$query = "UPDATE tbl_people SET notify = 'No' where per_id = {$parameters['arguments']['0']}";
if (!($res = mysqlConnection::getConnection()->query($query))) {
die('There was an error running the query [' . $query->error . ']');
}
echo json_encode(array('id' => 3));
?>
/**
dcCore constructor inits everything related to Dotclear. It takes arguments
to init database connection.
@param driver <b>string</b> Database driver name
@param host <b>string</b> Database hostname
@param db <b>string</b> Database name
@param user <b>string</b> Database username
@param password <b>string</b> Database password
@param prefix <b>string</b> DotClear tables prefix
@param persist <b>boolean</b> Persistent database connection
*/
public function __construct($driver, $host, $db, $user, $password, $prefix, $persist)
{
$this->con = dbLayer::init($driver, $host, $db, $user, $password, $persist);
# define weak_locks for mysql
if ($this->con instanceof mysqlConnection) {
mysqlConnection::$weak_locks = true;
}
$this->prefix = $prefix;
$this->error = new dcError();
$this->auth = $this->authInstance();
$this->session = new sessionDB($this->con, $this->prefix . 'session', BP_SESSION_NAME, '', null, false);
$this->url = new urlHandler();
$this->rest = new dcRestServer($this);
# Create the Hyla_Tpl object
$this->tpl = new Hyla_Tpl();
$this->tpl->setL10nCallback('T_');
}
