function login($id, $passwd, $url) { $dbh = dbconnect(); $query = "select mem_id,mem_pw from member_data where mem_id='{$id}'"; $sth = dbquery($dbh, $query); if (!$sth) { print_msg(mysql_error()); } list($mem_id, $mem_pw) = dbselect($sth); dbclose($dbh); if (!$mem_id) { print_alert("해당 ID가 없습니다. ", 'back'); } elseif ($mem_pw != $passwd) { print_alert("비밀번호가 틀립니다. ", 'back'); } else { setcookie("MemberID", $mem_id); header("Location: {$url}"); } return; }
function check_idnum($idnum) { if (!check_idnum_syntax($idnum)) { print_msg("주민등록가 잘못되었습니다.<br>정확히 입력하세요.", 'check_idnum', -1); } $dbh = dbconnect(); $idnum2 = substr($idnum, 0, 6) . "-" . substr($idnum, 6, 7); $query = "select mem_idnum from member_data where mem_idnum='{$idnum2}'"; $sth = dbquery($dbh, $query); if (!$sth) { print_msg(mysql_error()); } list($mem_idnum) = dbselect($sth); dbclose($dbh); if ($mem_idnum == $idnum2) { return false; } else { return true; } }
function check_passwd($db, $idx, $rn, $passwd) { /* 데이타 확인 */ $dbh = dbconnect(); $table_name = "bbs_" . $db; $query = "select idx,replynum,passwd from {$table_name} where idx={$idx} and replynum={$rn}"; $sth = dbquery($dbh, $query); if (!$sth) { print_message(mysql_error()); } list($c_idx, $c_replynum, $c_passwd) = dbselect($sth); dbclose($dbh); /* 존재하지 않을때 */ if (!$c_idx) { return -1; } /* 비밀번호 확인 */ if ($passwd == $admin_passwd || $passwd == $c_passwd) { return 1; } return 0; }
} // HTML code to display the graph echo "<TABLE BORDER=\"0\" CELLPADDING=\"10\" CELLSPACING=\"0\" WIDTH=\"100%\">"; echo "<TR>"; echo " <TD ALIGN=\"CENTER\"><IMG SRC=\"" . IMAGES_DIR . "mailscannerlogo.gif\" ALT=\"MailScannr Logo\"></TD>"; echo "</TR>"; echo "<TR>"; // Check Permissions to see if the file has been written and that apache to read it. if (is_readable($filename)) { echo " <TD ALIGN=\"CENTER\"><IMG SRC=\"" . $filename . "\" ALT=\"Graph\"></TD>"; } else { echo "<TD ALIGN=\"CENTER\"> File isn't readable. Please make sure that " . CACHE_DIR . " is readable and writable by MailWatch."; } echo "</TR>"; echo "<TR>"; echo "<TD ALIGN=\"CENTER\">"; echo "<TABLE WIDTH=\"500\">"; echo "<TR BGCOLOR=\"#F7CE4A\">"; echo "<TH>Domain</TH>"; echo "<TH>Count</TH>"; echo "<TH>Size</TH>"; echo "</TR>"; for ($i = 0; $i < count($data); $i++) { echo "<TR BGCOLOR=\"#EBEBEB\">\n <TD>{$data_names[$i]}</TD>\n <TD ALIGN=\"RIGHT\">" . number_format($data[$i]) . "</TD>\n <TD ALIGN=\"RIGHT\">" . format_mail_size($data_size[$i]) . "</TD>\n</TR>\n"; } echo "\n </TABLE>\n </TD>\n</TR>\n</TABLE>"; // Add footer html_end(); // Close any open db connections dbclose();
function retGUI() { global $CMD; global $OUTJSON; global $DBH; global $STDIN; global $APPL; global $ini; if (!isset($OUTJSON['cmd'])) $OUTJSON['cmd']=array(); endWin(); if (count($CMD)) { foreach($CMD as $a) $OUTJSON['cmd'][]= $a; } header("Content-Type: application/json; charset=UTF-8",true); header("X-Sid: ".session_id()); fclose($STDIN); if (isset($ini['db']))dbclose($DBH); exit(json_encode($OUTJSON)); }
print_alert("DB를 지정하셔야 합니다.", 'back'); exit; } if (!$m) { $m = 'list'; } /* Table 이름 지정 */ $table_name = "bbs_" . $db; if (!$pn) { $pn = 1; } /* DB접속 */ $dbh = dbconnect(); $from_string = "from=list"; $start_num = ($pn - 1) * $max_list; $end_num = $pn * $max_list; /* 전체 글수 */ $query = "select count(idx) from {$table_name}"; $sth = dbquery($dbh, $query); list($total_count) = dbselect($sth); /* 데이터 $max_list 만큼 뽑아서 @LIST_DATA 에 저장. */ $query = "select {$column} from {$table_name} order by idx desc,replynum limit {$start_num},{$max_list}"; $sth = dbquery($dbh, $query); $i = 0; $LIST_DATA = array(); while ($field = dbselect($sth)) { array_push($LIST_DATA, "{$field['0']}|{$field['1']}|{$field['2']}|\n\t\t{$field['3']}|{$field['4']}|{$field['5']}|{$field['6']}|{$field['7']}"); $i++; } dbclose($dbh); include "show_list.php";
WGSession(); $startFile=WGHTTPRedirection(); if ($lockIntUri) { header("Location: /",true); exit("Access denied by HTTP policy."); } } if (!$lockIntUri or isset($ini['logon'])) $_SESSION=array(); header("Content-Type: text/html; charset=UTF-8",true,200); EWGCacheFont(); if ($DBH) dbclose($DBH); ?><!doctype html> <html> <head> <meta charset="utf-8"/> <title><?php echo htmlspecialchars(@$ini['webgui']['title'], ENT_QUOTES); ?> </title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <? if (@$ini['webgui']['cookie']) echo "<script src=\"/sys/cookie.js\"></script>\n"; ?> <link rel="stylesheet" href="/sys/win.css"> <?
echo $row["groupid"]; ?> </td><td><?php echo $row["groupname"]; ?> </td><td><?php echo $row["content"]; ?> </td><td><?php echo $row["timewhen"]; ?> </td></tr> <?php //$i++; } ?> <tr><td colspan=7>Total: <?php echo $number_of_queries; ?> records.</td></tr> <?php } else { echo "0 results"; } ?> </table> </center> <?php dbclose($con);
} $word = ''; $phonetic = ''; $definitions = ''; $n = 0; $db = dbcreate('./ev.db'); $fp = fopen('ev.src', 'r'); while ($s = fgets($fp)) { if (preg_match('|^@([^/]+)(/([^/]+)/)?|', $s, $m)) { if ($word != '') { if (strpos($word, '00-database-') === 0) { // TODO: // Database info } else { $n++; dbsave($db, $word, $phonetic, $definitions); echo "Count = {$n}\r"; } $definitions = ''; } list($sw, $word, $sp, $phonetic) = $m; } else { $definitions .= $s; } } if ($word != '') { dbsave($db, $word, $phonetic, $definitions); } fclose($fp); dbclose($db);
while ($row = mysqli_fetch_assoc($res)) { $mood = new Weekly(); $mood->date = $row['iter']; $mood->val = getMood($row['mood'], $row['count']); $moods[] = $mood; } /* $moods=array(); $i=0; for($i=0; $i<3; $i++) { $mood = new Weekly(); $mood->date = $i; $mood->val = $i*20; $moods[] = $mood; } */ echo json_encode($moods); } switch ($type) { case "day": dayAnalysis(); break; case "hourly": hourlyAnalysis(); break; case "week": weekAnalysis(); break; } dbclose($conn);
function doit($input) { global $fp; if (!($fp = popen($input, 'r'))) { die("Cannot open pipe"); } dbconn(); $lines = 1; while ($line = fgets($fp, 2096)) { // Reset variables unset($parsed, $postfix, $_timestamp, $_host, $_type, $_msg_id, $_relay, $_dsn, $_status, $_delay); $parsed = new syslog_parser($line); $_timestamp = mysql_real_escape_string($parsed->timestamp); $_host = mysql_real_escape_string($parsed->host); // Postfix if ($parsed->process == 'postfix/smtp' && class_exists('postfix_parser')) { $postfix = new postfix_parser($parsed->entry); if (DEBUG) { print_r($postfix); } $_msg_id = mysql_real_escape_string($postfix->id); // Milter-ahead rejections if (preg_match('/Milter: /i', $postfix->raw) && preg_match('/(rejected recipient|user unknown)/i', $postfix->entries['reject'])) { $_type = mysql_real_escape_string('unknown_user'); $_status = mysql_real_escape_string(get_email($postfix->entries['to'])); } // Unknown users if (preg_match('/user unknown/i', $postfix->entry)) { // Unknown users $_type = mysql_real_escape_string('unknown_user'); $_status = mysql_real_escape_string($postfix->raw); } // you can use these matches to populate your table with all the various reject reasons etc., so one could get stats about MTA rejects as well // example if (preg_match('/NOQUEUE/i', $postfix->entry)) { if (preg_match('/Client host rejected: cannot find your hostname/i', $postfix->entry)) { $_type = mysql_real_escape_string('unknown_hostname'); } else { $_type = mysql_real_escape_string('NOQUEUE'); } $_status = mysql_real_escape_string($postfix->raw); } // Relay lines if (isset($postfix->entries['relay']) && isset($postfix->entries['status'])) { $_type = mysql_real_escape_string('relay'); $_delay = mysql_real_escape_string($postfix->entries['delay']); $_relay = mysql_real_escape_string(get_ip($postfix->entries['relay'])); $_dsn = mysql_real_escape_string($postfix->entries['dsn']); $_status = mysql_real_escape_string($postfix->entries['status']); } } if (isset($_type)) { dbquery("REPLACE INTO mtalog VALUES (FROM_UNIXTIME('{$_timestamp}'),'{$_host}','{$_type}','{$_msg_id}','{$_relay}','{$_dsn}','{$_status}','{$_delay}')"); } $lines++; } dbclose(); pclose($fp); }
function dbtest() { if ($dbc = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)) { if (!mysql_select_db(DB_NAME)) { $error_str = "Error: Could not select database: " . dberror(); } else { dbclose($dbc); return true; } } else { $error_str = "Error: Could not connect to database: " . dberror(); } return false; }
function set_start($idx) { global $URL, $pn; $dbh = dbconnect(); $query = "select poll_idx,status from poll_data where poll_idx={$idx}"; $sth = dbquery($dbh, $query); list($poll_idx, $edate) = dbselect($sth); if (!$poll_idx) { print_alert("존재하지 않는 데이터입니다. ", 'back'); exit; } elseif ($status == 1) { print_alert("현재 설문중입니다. ", 'back'); exit; } /* 설문 재개 */ $query = "update poll_data set status='1' where poll_idx={$idx}"; $sth = dbquery($dbh, $query); if (!$sth) { $msg = "에러가 발생하였습니다.<br><br>\n" . mysql_error(); print_message($msg); } else { header("Location: {$URL['list']}?pn={$pn}"); exit; } dbclose($dbh); exit; }