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_'); }