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;
}
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 view_result($idx)
{
global $URL;
$dbh = dbconnect();
/* 설문 내용 뽑기 */
$query = "select * from poll_data where poll_idx={$idx}";
$sth = dbquery($dbh, $query);
list($poll_idx, $question, $sdate, $edate, $status, $answer_no, $answer[1], $answer[2], $answer[3], $answer[4], $answer[5], $answer[6], $answer[7], $answer[8], $answer[9], $answer[10]) = dbselect($sth);
if (!$poll_idx) {
print_alert("잘못된 설문번호입니다. ", 'back');
exit;
}
/* 결과 뽑기 */
$query = "select answer,count(answer) from poll_result where poll_idx={$idx} group by answer";
$sth = dbquery($dbh, $query);
while (list($answer_num, $count) = dbselect($sth)) {
$RESULT[$answer_num] = $count;
$sum += $count;
}
/* 결과 화면 출력 */
print_header();
echo "\n<table border=1 bordercolor=white bordercolorlight=silver cellpadding=3 cellspacing=0 width=350>\n<tr><td colspan=2 bgcolor=f6f6f6 align=center><font size=2><b>설문 결과</b><br><br>{$question}</b></font></td></tr>\n";
for ($i = 1; $i <= $answer_no; $i++) {
$result_count = $RESULT[$i];
if (!$result_count) {
$result_count = 0;
}
if ($sum) {
$ratio = round($result_count / $sum * 100, 0);
$width = $ratio * 2;
} else {
$sum = 0;
$ratio = 0;
$width = 0;
}
echo "\n<tr><td width=300><font size=2>{$i}. {$answer[$i]}<br>\n <img src=\"{$URL['home']}/icon/bar{$i}.gif\" width='{$width}' height=10> ({$result_count})</font></td>\n <td width=50 align=right><font size=2 color=NAVY>{$ratio}%</font></td>\n</tr>\n";
}
echo "\n<tr><td colspan=2 bgcolor=f6f6f6 align=right><font size=2>총 투표 수 : {$sum}</font>\n</td></tr>\n</table>\n<center>\n<input type=button value=\" 닫 기 \" onClick=\"window.close();\">\n<!--a href=\"javascript:this.close();\">[닫기]</a-->\n";
print_footer();
}
회원관리 (회원정보 수정)
2001.06 by Jungjoon Oh
*/
require "db-lib.php";
require "mem-lib.php";
if (!$MemberID) {
header("Location: member_edit_form.php");
exit;
}
// 데이타 확인
$dbh = dbconnect();
$query = "select mem_id from member_data where mem_id='{$MemberID}'";
$sth = dbquery($dbh, $query);
if (!$sth) {
print_alert(mysql_error(), 'back');
}
list($mem_id) = dbselect($sth);
// 존재하지 않을때
if (!$mem_id) {
print_alert("존재하지 않는 ID 입니다.", 'back');
exit;
}
$query = "update member_data set " . "mem_pw='{$passwd}'," . "mem_name='{$name}'," . "mem_email='{$email}'," . "mem_url='{$url}'," . "mem_tel='{$tel}'," . "mem_hp='{$hp}'," . "mem_addr1='{$addr1}'," . "mem_addr2='{$addr2}'," . "mem_zip='{$zip1}-{$zip2}' " . "where mem_id='{$MemberID}'";
// Update
$sth = dbquery($dbh, $query);
if (!$sth) {
print_alert(mysql_error(), 'back');
} else {
print_alert("수정이 완료되었습니다. ", "url|mem_edit_form.php");
}
exit;
if (!$sth) {
print_alert(mysql_error(), 'back');
}
$data = dbselect($sth);
for ($i = 0; $i <= 16; $i++) {
$data[$i] = ereg_replace("\"", "'", $data[$i]);
}
list($nc_index, $nc_group, $nc_id, $nc_date, $nc_name, $nc_company, $nc_depart, $nc_title, $nc_tel, $nc_fax, $nc_hp, $nc_email, $nc_url, $nc_address, $nc_relation, $nc_note, $nc_pub) = $data;
// 존재하지 않을때
if (!$nc_index) {
print_alert("데이터가 존재하지 않습니다.", 'stop');
exit;
}
// 등록한 사람이 아닐때
if ($mem_id != $nc_id) {
print_alert("명함을 등록한 사람만 수정할수있습니다. ", 'back');
exit;
}
$name = "nc_pub" . $nc_pub;
${$name} = "checked";
$name = "nc_group" . $nc_group;
${$name} = "selected";
print_header("명함수정");
print_location_bar("명함수정");
?>
<script language="JavaScript">
<!--
function calLength(str)
<?php
/*
게시판 (글목록)
2001.06 by Jungjoon Oh
*/
require "db-lib.php";
require "bbs-lib.php";
if (!$db) {
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}";
if (!$id) {
$errmsg .= "* ID를 입력해주세요.\\n";
} elseif (!check_id($id)) {
$errmsg .= "* 이미 사용중인 ID입니다.\\n";
}
if (!$name) {
$errmsg .= "* 성명을 입력해주세요.\\n";
}
if (!$idnum1 || !$idnum2) {
$errmsg .= "* 주민등록번호를 입력해주세요.\\n";
} elseif (!check_idnum("{$idnum1}{$idnum2}")) {
$errmsg .= "* 이미 등록된 주민등록번호입니다.\\n";
}
if ($errmsg) {
$errmsg = "- 아래의 사항을 확인하세요\\n\\n" . $errmsg;
print_alert($errmsg, 'back');
}
$dbh = dbconnect();
if ($zip1 && $zip2) {
$zip = "{$zip1}-{$zip2}";
}
// Make Query
$query = "insert into member_data " . "(mem_id,mem_pw,mem_date,mem_name,mem_idnum,mem_email," . "mem_url,mem_tel,mem_hp,mem_addr1,mem_addr2,mem_zip) values " . "('{$id}','{$passwd}',sysdate(),'{$name}','{$idnum1}-{$idnum2}','{$email}'," . "'{$url}','{$tel}','{$hp}','{$addr1}','{$addr2}','{$zip}')";
$sth = dbquery($dbh, $query);
if (!$sth) {
$msg = "에러가 발생하였습니다.<br>\n" . mysql_error();
print_message($msg, "에러");
} else {
$msg = "\n<table width=500 align=center>\n<tr><td><center><b>등록이 완료되었습니다.</b></center><br><br>\n </td>\n</tr>\n</table>\n";
print_message($msg, "회원등록");
}
<div class="row">
<!-- TITULO DE GESTION DE USUARIOS -->
<div style="margin-top: 15px" class="col-md-10 col-md-offset-1">
<h1><strong><?php echo lang('user.gestion') ?></strong></h1><br />
<h2 style="color: #424242"><?php echo lang('user.watch') ?></h2>
<?php if($this->session->flashdata('success_delete')) : ?>
<?php print_alert('Usuario eliminado con éxito','success') ?>
<?php endif ?>
<?php if($this->session->flashdata('success_edit')) : ?>
<?php print_alert('Datos de usuario editados con éxito','success') ?>
<?php endif ?>
</div>
<!-- TABLA DE USUARIOS REGISTRADOS -->
<div class="col-md-10 col-md-offset-1 table-responsive" style="margin-top: 15px">
<table class="table table-bordered">
<thead>
<tr>
<th><a href=""><?php echo lang('id') ?></a></th>
<th><a href=""><?php echo lang('nombre') ?></a></th>
<th><a href=""><?php echo lang('rol') ?></a></th>
<th><a href=""><?php echo lang('status') ?></a></th>
<th><a href=""><?php echo lang('fecha_creacion') ?></a></th>
<th style="text-align: center"><a href=""><?php echo lang('eliminar') ?></a></th>
</tr>
</thead>
<tbody>
<?php if(isset($usuarios) && !empty($usuarios)) : ?>
<?php foreach($usuarios as $key => $user) : ?>
<?php
if($user->id_estado == 1) $color = '088A08';
###### Bei Reload variablen neu befüllen #######
foreach ($_POST as $key => $val) {
${$key} = $val;
}
}
}
print "\n<div class='popup'>\n\t<form action='index.php?" . $_SERVER['QUERY_STRING'] . "' method='post'>\n\t\t<div class='popup-head'>\n\t\t\t<i class='icon-popup'></i>" . v('CMT_HEADLINE_' . strtoupper($action));
if (isset($id)) {
print "<span># " . $id . "</span>";
}
print "\n\t\t</div><!-- /.popup-head -->\n\t\t<div class='popup-content'>";
if (isset($alert)) {
print print_alert('error', v('CMT_HEADLINE_SAVE_ERROR'), v('CMT_TEXT_SAVE_ERROR'));
}
if (isset($success)) {
print print_alert('success', v('CMT_HEADLINE_SAVE_SUCCESS'), v('CMT_TEXT_SAVE_SUCCESS'));
}
if (!isset($c_active)) {
$c_active = 1;
}
if (!isset($language)) {
$language = CMT_USER_LANGUAGE;
}
if (isset($update_parent)) {
$formdata['update_parent'] = array('type' => 'hidden', 'value' => 1);
}
$formdata['date'] = array('type' => 'datepicker', 'label' => v('CMT_DATE'), 'parent_class' => 'date', 'value' => array('date' => date('d.m.Y', $date), 'time' => date('H:i', $date)));
$formdata['title'] = array('type' => 'text', 'label' => v('CMT_TITLE'), 'style' => array('class' => "col-3_of_7"));
$formdata['content'] = array('type' => 'textarea', 'label' => v('CMT_CONTENT'));
$formdata['c_active'] = array('type' => 'checkbox', 'label' => v('CMT_ACTIVE'));
foreach ($formdata as $key => $val) {
}
// 데이타 가져오기
$dbh = dbconnect();
$query = "select * from member_data where mem_id='{$MemberID}'";
$sth = dbquery($dbh, $query);
if (!$sth) {
print_alert(mysql_error(), 'back');
}
$data = dbselect($sth);
for ($i = 0; $i <= 11; $i++) {
$data[$i] = ereg_replace("\"", "'", $data[$i]);
}
list($mem_id, $mem_pw, $mem_date, $mem_name, $mem_idnum, $mem_email, $mem_url, $mem_tel, $mem_hp, $mem_addr1, $mem_addr2, $mem_zip) = $data;
// 존재하지 않을때
if (!$mem_id) {
print_alert("존재하지 않는 ID 입니다.", 'back');
exit;
}
list($mem_zip1, $mem_zip2) = split("-", $mem_zip);
?>
<html>
<head>
<title>회원가입</title>
<script language="JavaScript">
<!--
function OpenZipcode(){
window.open("zip/zipcode.php?form=f&zip1=zip1&zip2=zip2&address=addr1","ZipWin","width=480,height=200,toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes");
}
print_alert(mysql_error(), 'back');
}
list($d_idx, $d_passwd, $d_filename) = dbselect($sth);
/* 존재하지 않을때 */
if (!$idx) {
print_alert("데이터가 존재하지 않습니다.", 'stop');
} elseif ($passwd != $d_passwd && $passwd != $admin_passwd) {
print_alert("비밀번호가 일치하지 않습니다. ", 'back');
}
/* 파일 등록 여부 확인 */
if ($d_filename) {
unlink("{$upload_path}/{$db}/{$d_filename}");
}
/* 글 삭제 */
$query = "delete from {$table_name} where idx={$idx}";
/* 첫번째 글이 아닌경우 */
if ($rn != 1) {
$query .= " and replynum={$rn}";
}
$sth = dbquery($dbh, $query);
if (!$sth) {
print_alert(mysql_error(), 'back');
} else {
print_alert("삭제가 완료되었습니다. ", "opener|{$url}");
}
exit;
function passwd_form($db, $idx, $rn, $back_url)
{
global $URL;
echo "\n<html>\n<head><title>비밀번호 확인</title>\n<script language=JavaScript>\nfunction check_form()\n{\n\tif (document.pwform.passwd.value =='')\n\t{\n\t\talert('비밀번호를 입력하세요. ');\n\t\treturn false;\n\t}\n\treturn true;\n}\n</script>\n</head>\n\n<body onLoad='document.pwform.passwd.focus();'>\n<center>\n<font size=2 color=NAVY>글 작성시 입력했던 비밀번호를 입력하세요.</font>\n<form method=POST name=pwform action='{$URL['delete']}' onSubmit='return check_form();'>\n<input type=hidden name=db value='{$db}'>\n<input type=hidden name=idx value='{$idx}'>\n<input type=hidden name=rn value='{$rn}'>\n<input type=hidden name=url value='{$back_url}'>\n<TABLE BORDER=0 CELLPADDING=1 CELLSPACING=1 WIDTH=300>\n<TR><TD ALIGN=center VALIGN=middle>\n <FONT SIZE=2><B>비밀번호</B></FONT> \n <INPUT TYPE=password NAME=passwd SIZE=15 MAXLENGTH=10>\n </TD>\n</TR>\n<TR><TD> </TD></TR>\n<TR><TD ALIGN=center VALIGN=middle>\n <INPUT TYPE=submit VALUE=' 삭제하기 '>\n <INPUT TYPE=button NAME=exitBtn VALUE=' 취소 '><br><br>\n <font size=2 color=RED>주의 : 답변이 있는 글은 답변까지 모두 지워집니다.</font>\n </TD>\n</TR>\n</TABLE>\n</body>\n</html>\n";
}
if (!$idx) {
header("Location: {$URL['list']}\n\n");
exit;
}
// 데이타 확인
$dbh = dbconnect();
$query = "select nc_index,nc_id from namecard where nc_index={$idx}";
$sth = dbquery($dbh, $query);
if (!$sth) {
print_alert(mysql_error(), 'back');
}
list($nc_index, $nc_id) = dbselect($sth);
// 존재하지 않을때
if (!$nc_index) {
print_alert("데이터가 존재하지 않습니다.", 'stop');
exit;
}
// 등록한 사람이 아닐때
if ($mem_id != $nc_id) {
print_alert("명함을 등록한 사람만 수정할수있습니다. ", 'back');
exit;
}
$query = "update namecard set " . "nc_group='{$nc_group}'," . "nc_name='{$nc_name}'," . "nc_company='{$nc_company}'," . "nc_depart='{$nc_depart}'," . "nc_title='{$nc_title}'," . "nc_tel='{$nc_tel}'," . "nc_fax='{$nc_fax}'," . "nc_hp='{$nc_hp}'," . "nc_email='{$nc_email}'," . "nc_url='{$nc_url}'," . "nc_address='{$nc_address}'," . "nc_relation='{$nc_relation}'," . "nc_note='{$nc_note}'," . "nc_pub='{$nc_pub}' " . "where nc_index={$nc_index}";
// Update
$sth = dbquery($dbh, $query);
if (!$sth) {
print_alert(mysql_error(), 'back');
} else {
print_alert("수정이 완료되었습니다. ", "url|{$url}");
}
exit;
<div id="page-wrapper">
<div class="col-lg-12">
<h1>Gestión de Continuidad del Negocio</h1>
<?php
echo $breadcrumbs;
$message = "Permite la gestión y elaboración de planes de acción, prevención y recuperación de los servicios del negocio en caso de desastres.";
print_alert($message);
?>
</div>
<div class="row">
<!-- <a href="<?php echo site_url('index.php/continuidad/backup') ?>">Respaldar Base de Datos</a> -->
<div class="col-lg-4 col-lg-offset-4">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="row">
<div class="col-xs-6">
<i class="fa fa-save fa-5x"></i>
</div>
<div class="col-xs-6 text-center">
<p class="announcement-text">Respaldar la Base de Datos del Sistema</p>
</div>
</div>
</div>
<a href="<?php echo site_url('index.php/continuidad/respaldos') ?>">
<div class="panel-footer announcement-bottom">
<div class="row">
<div class="col-xs-6">
Examinar
</div>
<div class="col-xs-6 text-right">
<i class="fa fa-arrow-circle-right"></i>
$success = true;
header('location: index.php?setup=success');
} else {
foreach ($_POST as $key => $val) {
${$key} = $val;
}
}
}
}
print "<div class='setup'>";
print "<form action='index.php?step=" . $step . "' method='post'>\n\t\t\t\t<div class='setup-head'>\n\t\t\t\t\t<i class='icon-setup'></i>SETUP\n\t\t\t\t</div><!-- /.setup-head -->\n\t\t\t\t<div class='setup-content'>";
if (isset($alert)) {
print print_alert('error', 'Speichervorgang fehlgeschlagen', 'Der Eintrag wurde nicht gespeichert.');
}
if (isset($success)) {
print print_alert('success', 'Speichervorgang erfolgreich', 'Der Eintrag wurde erfolgreich gespeichert.');
}
if ($step == 1) {
$formdata['db_dbname'] = array('type' => 'text', 'label' => 'Datenbankname', 'label_after' => '(Name der Datenbank)', 'style' => array('class' => "col-3_of_7"), 'settings' => array('attributes' => array('autofocus' => 'autofocus')));
$formdata['db_user'] = array('type' => 'text', 'label' => 'Benutzername', 'label_after' => '(MySQL Benutzername)', 'style' => array('class' => "col-3_of_7"));
$formdata['db_password'] = array('type' => 'password', 'label' => 'Passwort', 'label_after' => '(MySQL Passwort)', 'style' => array('class' => "col-3_of_7"));
$formdata['db_host'] = array('type' => 'text', 'label' => 'Datenbank Host', 'label_after' => '(z.B. localhost oder IP/Domain)', 'value' => 'localhost', 'style' => array('class' => "col-3_of_7"));
} elseif ($step == 2) {
$formdata['username'] = array('type' => 'text', 'label' => 'Benutzername', 'style' => array('class' => "col-3_of_7"));
$formdata['password'] = array('type' => 'password', 'label' => 'Passwort', 'style' => array('class' => "col-3_of_7"));
$formdata['first_name'] = array('type' => 'text', 'label' => 'Vorname', 'style' => array('class' => "col-3_of_7"));
$formdata['last_name'] = array('type' => 'text', 'label' => 'Nachname', 'style' => array('class' => "col-3_of_7"));
$formdata['street'] = array('type' => 'text', 'label' => 'Straße/Hausnummer', 'parent_class' => 'free_space', 'style' => array('width' => '292'));
$formdata['street_number'] = array('type' => 'text', 'style' => array('class' => "align-right", 'width' => '56'));
$formdata['zip'] = array('type' => 'text', 'label' => 'Postleitzahl/Ort', 'parent_class' => 'free_space', 'style' => array('width' => '196'));
$formdata['city'] = array('type' => 'text', 'style' => array('width' => '152'));
function print_form($formdata)
{
if (isset($formdata)) {
print "<div class='form'>";
foreach ($formdata as $key => $data) {
if (isset($data['label_head'])) {
print "<div class='form_label_head ";
if (isset($data['label'])) {
print "label";
}
print "'>" . $data['label_head'] . "</div>";
}
if (isset($data['label_key_head'])) {
print "<div class='form_label_key_head ";
if (isset($data['style']['class'])) {
print $data['style']['class'];
}
if (isset($data['label'])) {
print " label";
}
print "'>" . $data['label_key_head'] . "</div>";
}
if (isset($data['label_value_head'])) {
print "<div class='form_label_value_head ";
if (isset($data['style']['class'])) {
print $data['style']['class'];
}
if (isset($data['label'])) {
print "label";
}
print "'>" . $data['label_value_head'] . "</div>";
}
if (!isset($data['value'])) {
$data['value'] = NULL;
}
if (!isset($data['id'])) {
$data['id'] = $key;
}
if (!isset($data['class'])) {
$data['class'] = $key;
}
$data['style']['id'] = $data['id'];
if (isset($data['style']['class'])) {
$data['style']['class'] .= " " . $data['class'];
} else {
$data['style']['class'] = $data['class'];
}
if ($data['type'] != 'hidden') {
print "<div class='form_element ";
if (isset($data['parent_class'])) {
print $data['parent_class'] . " ";
}
if (isset($data['settings']['alert'])) {
if (is_array($data['settings']['alert'])) {
print $data['settings']['alert']['type'] . " ";
} else {
print $data['settings']['alert'] . " ";
}
}
print "'>";
if (isset($data['label'])) {
print "\n\t\t\t\t\t<div class='form_field_label'>\n\t\t\t\t\t\t<label for='" . $data['id'] . "'>" . $data['label'] . "</label>\n\t\t\t\t\t</div>";
}
print "<div class='form_field'>";
}
if (isset($data['label_before'])) {
print "<div class='form_label_before'>" . $data['label_before'] . "</div>";
}
if (!isset($data['settings'])) {
$data['settings'] = NULL;
}
switch ($data['type']) {
case 'hidden':
print form_hidden($key, $data['style'], $data['value']);
break;
case 'int':
print form_text($key, $data['style'], $data['value'], $data['settings']);
break;
case 'text':
print form_text($key, $data['style'], $data['value'], $data['settings']);
break;
case 'textarea':
print form_textarea($key, $data['style'], $data['value'], $data['settings']);
break;
case 'checkbox':
print form_checkbox($key, $data['style'], $data['value'], $data['settings']);
break;
case 'select':
print form_select($key, $data['style'], $data['value'], $data['settings']);
break;
case 'radio':
print form_radiogroup($key, $data['style'], $data['value'], $data['settings']);
break;
case 'password':
print form_password($key, $data['style'], $data['value'], $data['settings']);
break;
case 'filter-date':
filter_date($data['value'], $data['settings']);
break;
case 'datepicker':
datepicker($data['value'], $data['settings']);
break;
case 'input_add':
print form_text("key_" . $key, $data['style'], $data['value']['key'], $data['settings']);
print form_text("value_" . $key, $data['style'], $data['value']['value'], $data['settings']);
if (isset($data['settings']['number'])) {
print "<i class='icon-inputadd' id='" . $data['settings']['number'] . "'></i>";
}
break;
case 'upload':
print form_upload($key);
break;
}
if (isset($data['label_after'])) {
print "<div class='form_label_after'>" . $data['label_after'] . "</div>";
}
if ($data['type'] != 'hidden') {
print "\n\t\t\t\t\t</div>\n\t\t\t\t</div>";
if (isset($data['settings']['alert'])) {
if (is_array($data['settings']['alert'])) {
if (isset($data['settings']['alert']['text'])) {
print print_alert($data['settings']['alert']['type'], $data['settings']['alert']['label'], $data['settings']['alert']['text']);
} else {
print print_alert($data['settings']['alert']['type'], v('CMT_HEADLINE_' . $data['settings']['alert']['label'] . '_ERROR'), v('CMT_TEXT_' . $data['settings']['alert']['label'] . '_ERROR'));
}
} else {
print print_alert($data['settings']['alert'], v('CMT_HEADLINE_REQUIRED_ERROR'), v('CMT_TEXT_REQUIRED_ERROR'));
}
}
}
}
print "</div>";
}
}
<div class="row" style="margin-top: 25px">
<div class="col-lg-12">
<?php print_alert('Es altamente recomendable que al respaldar una base de datos, la descargue y la almacene en otro lugar para mayor seguridad','warning') ?>
</div>
</div>
<div class="row" style="margin-top: 25px">
<div class="col-lg-12">
<div class="panel panel-primary">
<div class="panel-heading">
<h3 class="panel-title">Listado de respaldos de la base de datos</h3>
</div>
<div class="panel-body">
<?php if(!isset($respaldos) OR empty($respaldos)) : ?>
<?php print_alert('<strong>No se ha realizado ningún respaldo. Debe respaldar la base de datos con urgencia.</strong>','danger') ?>
<?php else : ?>
<div class="table-responsive">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th>Descripción <i class="fa fa-sort"></i></th>
<th>Fecha de creación <i class="fa fa-sort"></i></th>
<th>Descargar</th>
</tr>
</thead>
<tbody>
<?php foreach($respaldos as $key => $respaldo) : ?>
<tr>
<td><?php echo character_limiter($respaldo->descripcion,25) ?></td>
<td><?php echo date('d-m-Y h:i A',strtotime($respaldo->fecha_creacion)) ?></td>
}
if ($userfile_name) {
if (!$userfile_size) {
print_alert("파일 업로드 실패", 'back');
exit;
}
/* 확장자 검색 */
$file_ext = strrchr($userfile_name, ".");
$file_ext = ereg_replace("\\.", "", $file_ext);
$file_ext = strtolower($file_ext);
if ($file_ext == 'php' || $file_ext == 'php3' || $file_ext == 'phtml' || $file_ext == 'inc') {
print_alert("PHP 프로그램 소스는 올릴수 없습니다. ", 'back');
}
$userfile_name = "[{$idx}-{$rn}]{$userfile_name}";
copy($userfile, "{$upload_path}/{$db}/{$userfile_name}");
if ($e_filename) {
unlink("{$upload_path}/{$db}/{$e_filename}");
}
$query_userfile = "filename='{$userfile_name}',";
}
/* Query 생성 */
$query = "update {$table_name} set " . "name='{$name}', email='{$email}', url='{$url}', type='{$type}'," . $query_userfile . " subject='{$subject}', note='{$note}' " . "where idx='{$idx}' and replynum='{$rn}'";
$sth = dbquery($dbh, $query);
if (!$sth) {
$msg = "에러가 발생하였습니다.<br><br>\n" . mysql_error();
print_message($msg);
} else {
print_alert("수정이 완료되었습니다. ", "url|{$return_url}");
}
?>
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1>Gestión de Continuidad del Negocio</h1>
<?php echo $breadcrumbs ?>
<h3>Listado de riesgos y Amenazas</h3>
</div>
</div>
<div class="row">
<div class="col-lg-12">
<?php
if($this->session->flashdata('alert_success')) print_alert($this->session->flashdata('alert_success'));
if($this->session->flashdata('alert_error')) print_alert($this->session->flashdata('alert_error'),'danger');
?>
</div>
</div>
<div class="row">
<div class="col-lg-9"></div>
<div class="col-lg-2" style="left: 71px">
<a href="<?php echo base_url() ?>index.php/continuidad/gestion_riesgos/riesgos/crear" class="btn btn-success">
<i class="fa fa-plus"></i> Agregar nuevo riesgo
</a>
</div>
</div>
<div class="row" style="margin-top: 25px">
<div class="col-lg-12">
<div class="table-responsive">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
$dbh = dbconnect();
$query = "select * from {$table_name} where idx={$idx} and replynum={$rn}";
$sth = dbquery($dbh, $query);
if (!$sth) {
print_alert(mysql_error(), 'back');
}
$data = dbselect($sth);
for ($i = 0; $i < 13; $i++) {
$data[$i] = ereg_replace("\"", "'", $data[$i]);
}
list($idx, $replynum, $name, $email, $url, $hit, $date, $passwd, $ip, $type, $filename, $subject, $note) = $data;
/* 존재하지 않을때 */
if (!$idx) {
print_alert("데이터가 존재하지 않습니다.", 'stop');
} elseif (!$passwd) {
print_alert("비밀번호가 입력되지 않은 글은 수정할수 없습니다. ", 'back');
}
$varname = "type" . $type;
${$varname} = "checked";
if ($filename) {
$current_file = "<br><font size=2>현재첨부파일:<font color=BLUE>{$filename}</font></font>";
} else {
$current_file = "<br><font size=2 color=RED>첨부파일이 없습니다.</font>";
}
require $header;
?>
<script language="JavaScript">
<!--
function checkForm(form)
{
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel">Eliminar estrategia</h4>
</div>
<div class="modal-body">
¿Está seguro que desea eliminar la estrategia de recuperación <strong><?php echo ucfirst($strat->denominacion) ?></strong>?<br />
Esto probablemente afecte a las dependencias de esta estrategia.<br />
Por favor proceda con cautela.
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Atras</button>
<a href="<?php echo base_url().'index.php/continuidad/estrategias/eliminar/'.$strat->id_estrategia ?>"
type="button" class="btn btn-danger">
Eliminar
</a>
</div>
</div>
</div>
</div>
<?php endforeach ?>
</tbody>
</table>
</div>
<?php else : ?>
<?php print_alert('No hay estrategias de recuperación creadas hasta el momento. Cree una nueva estrategia en el botón de arriba.','danger') ?>
<?php endif ?>
</div>
</div>
</div>
</div>
</div>
function do_login()
{
global $conn;
$login_error = false;
if (isset($_GET['logout'])) {
$logout = parse($_GET['logout'], 'int');
if ($logout == 1) {
do_logout();
}
}
if (isset($_POST['cmt_login'])) {
$username = parse($_POST['login_username'], 'string');
$password = parse($_POST['login_password'], 'string');
$sql = "SELECT password, password_salt, id FROM " . $_SESSION['TABLE_PREFIX'] . "cmt_accounts WHERE username = '******' AND c_active = '1'";
$result = db_mysql_query($sql, $conn);
if (db_mysql_num_rows($result)) {
if (!$username) {
$login_error = true;
}
if (!$password) {
$login_error = true;
}
$arr = db_mysql_fetch_array($result);
if ($arr['password'] == md5($arr['password_salt'] . $password)) {
$_SESSION['cmt_login'] = true;
$_SESSION['cmt_id'] = $arr['id'];
} else {
$login_error = true;
}
if ($login_error) {
$_SESSION['cmt_login'] = false;
return print_alert('error', v('CMT_HEADLINE_LOGIN_ERROR'), v('CMT_TEXT_LOGIN_ERROR'));
}
} else {
$_SESSION['cmt_login'] = false;
return print_alert('error', v('CMT_HEADLINE_LOGIN_ERROR'), v('CMT_TEXT_LOGIN_ERROR'));
}
}
}
</div>
<div class="row" style="margin-top: 25px">
<?php if(isset($planes_continuidad) && !empty($planes_continuidad)) : ?>
<div class="col-lg-12">
» <a href="<?php echo site_url('index.php/continuidad/validar_pcn/'.$val) ?>">Validar Planes de Continuidad del Negocio</a>
</div>
<?php endif ?>
<div class="col-lg-12" style="margin-top: 25px">
<div class="panel panel-primary">
<div class="panel-heading">
<h3 class="panel-title">Planes de continuidad del negocio para riesgos con valoración <?php echo $valoracion ?></h3>
</div>
<div class="panel-body">
<?php if(!isset($planes_continuidad) OR empty($planes_continuidad)) : ?>
<?php print_alert('<strong>No existe ningún Plan de Continuidad del Negocio para riesgos con valoración '.$valoracion.'. Puede crear uno dando click al botón de arriba.</strong>','danger') ?>
<?php else : ?>
<div id="loading"></div>
<div class="table-responsive">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th>Código <i class="fa fa-sort"></i></th>
<th>Denominación <i class="fa fa-sort"></i></th>
<!-- <th>Departamento <i class="fa fa-sort"></i></th> -->
<th>Responsable <i class="fa fa-sort"></i></th>
<th>Estado del PCN <i class="fa fa-sort"></i></th>
<th>Fecha de creación <i class="fa fa-sort"></i></th>
<th><span data-toggle="tooltip" title="Indica si el PCN fue verificado por la gerencia">Validado</span></th>
<th><span data-toggle="tooltip" title="Click para descargar PDF">PDF</span></th>
<th>Activar</th>
*/
require "db-lib.php";
require "poll-lib.php";
$sql_file1 = "./sql/poll_data.sql";
$sql_file2 = "./sql/poll_result.sql";
/* DB 접속 */
$dbh = dbconnect();
/* 첫번째 테이블 */
$fp = fopen($sql_file1, "r");
while ($line = fgets($fp, 1024)) {
$query1 .= $line;
$i++;
}
fclose($fp);
$sth = dbquery($dbh, $query1);
if (!$sth) {
print_message(mysql_error());
}
/* 두번째 테이블 */
$fp = fopen($sql_file2, "r");
while ($line = fgets($fp, 1024)) {
$query2 .= $line;
$i++;
}
fclose($fp);
$sth = dbquery($dbh, $query2);
if (!$sth) {
print_message(mysql_error());
} else {
print_alert("DB 설치가 완료되었습니다. ", "url|{$URL['poll']}");
}
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1>Gestión de Continuidad del Negocio</h1>
<?php
echo $breadcrumbs;
$message = "Gestión de amenazas, vulnerabilidades y riesgos que se pueden presentar en la organización";
print_alert($message,'info');
?>
<h3>Gestión de riesgos y amenazas</h3>
</div>
</div>
<div class="row">
<div class="col-lg-4">
<div class="panel panel-info">
<div class="panel-heading">
<div class="row">
<div class="col-xs-6">
<i class="fa fa-flash fa-5x"></i>
</div>
<div class="col-xs-6 text-center">
<p class="announcement-text">Listado de vulnerabilidades</p>
</div>
</div>
</div>
<a href="<?php echo site_url('index.php/continuidad/gestion_riesgos/vulnerabilidades');?>">
<div class="panel-footer announcement-bottom">
<div class="row">
<div class="col-xs-6">
Examinar
</div>
$table_name = "bbs_" . $db;
$from_string = "from={$from}&pn={$pn}";
if ($from == 'search') {
$from_string .= "&k={$k}&w={$w}";
}
/* 데이터 가져오기 */
$dbh = dbconnect();
$query = "select * from {$table_name} where idx={$idx} and replynum={$rn}";
$sth = dbquery($dbh, $query);
if (!$sth) {
print_message("{$query}");
}
list($idx, $replynum, $name, $email, $url, $hit, $date, $passwd, $ip, $type, $filename, $subject, $note) = dbselect($sth);
/* 존재하지 않을때 */
if (!$idx) {
print_alert("데이터가 존재하지 않습니다.", 'stop');
exit;
}
/* 조회수 증가 */
$query = "update {$table_name} set hit=hit+1 where idx={$idx} and replynum={$rn}";
dbquery($dbh, $query);
if ($email) {
$name = "<a href=\"mailto:{$email}\">{$name}</a>";
}
$button_line = "\n<a href=\"{$URL['edit_form']}?db={$db}&idx={$idx}&rn={$rn}&from={$from}&{$from_string}\">{$BUTTON['edit']}</a>\n<a href=\"#\" onClick=\"openPasswdForm();\">{$BUTTON['delete']}</a>\n<a href=\"{$URL['write_form']}?db={$db}&m=reply&idx={$idx}&dt={$dt}&rn={$rn}\">{$BUTTON['reply']}</a> \n<a href=\"{$URL['write_form']}?db={$db}\">{$BUTTON['write']}</a> \n<a href=\"{$URL[$from]}?db={$db}&{$from_string}\">{$BUTTON['list']}</a>\n";
/* 첨부파일 체크 */
if ($filename) {
$filesize = number_format(filesize("{$upload_path}/{$db}/{$filename}"));
$attach_file = "<tr><td colspan=2 bgcolor=#BBDDFF><font size=2>첨부파일:" . "<a href=\"{$URL['home']}/upload/{$db}/{$filename}\">{$filename}</a> " . "({$filesize} bytes)</font></td></tr>";
}
/* 답변 목록 체크 */
명함관리 (명함등록)
2001.06 by Jungjoon Oh
*/
require "db-lib.php";
require "nc-lib.php";
$mem_id = $REMOTE_USER;
if (!$nc_name) {
$errmsg .= "* 이름을 입력해주세요\\n";
}
if (strlen($nc_note) > 200) {
$errmsg .= "* 설명이 너무 깁니다. 한글100자 내로 입력하세요.\\n";
}
if ($errmsg) {
$errmsg = "- 아래의 사항을 확인하세요\\n\\n" . $errmsg;
print_alert($errmsg, 'back');
}
$dbh = dbconnect();
// Make Query
$query = "insert into namecard " . "(nc_group,nc_id,nc_date,nc_name,nc_company," . "nc_depart,nc_title,nc_tel,nc_fax,nc_hp,nc_email,nc_url," . "nc_address,nc_relation,nc_note,nc_pub) values " . "('{$nc_group}','{$mem_id}',sysdate(),'{$nc_name}','{$nc_company}'," . "'{$nc_depart}','{$nc_title}','{$nc_tel}','{$nc_fax}','{$nc_hp}','{$nc_email}'," . "'{$nc_url}','{$nc_address}','{$nc_relation}','{$nc_note}','{$nc_pub}')";
$sth = dbquery($dbh, $query);
if (!$sth) {
$msg = "에러가 발생하였습니다.\n" . mysql_error();
print_alert($msg, 'back');
} else {
$msg = "\n<table width=500 align=center>\n<tr><td><center><b>등록이 완료되었습니다.</b></center><br><br>\n </td>\n</tr>\n<tr><td align=center><font size=2><b>\n <a href=\"{$URL['list']}\">[목록]</a> \n <a href=\"{$URL['write_form']}\">[계속등록]</a> \n <a href=\"javascript:history.back();\">[같은회사 등록]</a> \n </b></font>\n </td>\n</tr>\n</table>\n";
print_message($msg, "명함등록");
}
?>
<?php
/*
방명록 (관리자 모드)
2001.06 by Jungjoon Oh
*/
require "gb-lib.php";
if (is_admin($PHP_AUTH_USER, $PHP_AUTH_PW)) {
print_alert("관리자 모드로 전환되었습니다. ", "url|{$URL['list']}");
} else {
header("WWW-Authenticate: Basic realm=\"방명록 관리자 화면\"");
header("HTTP/1.0 401 Unauthorized");
print_alert("관리자 접속이 취소되었습니다. ", 'back');
exit;
}
<?php echo $breadcrumbs ?>
<h3>Listado de Vulnerabilidades</h3>
</div>
</div>
<div class="row">
<div class="col-lg-12">
<?php
if($this->session->flashdata('alert_success')) print_alert($this->session->flashdata('alert_success'));
if($this->session->flashdata('alert_error')) print_alert($this->session->flashdata('alert_error'),'danger');
?>
</div>
</div>
<?php
print_alert('Muchas vulnerabilidades pasan por acciones y costumbres del día a día, generando desatención, lo que puede volverse en un riesgo potencial para la organización.
A continuación se presenta un listado de Vulnerabilidades genéricas que pueden ayudar a identificar las propias vulnerabilidades de la organización, para prevenir riesgos potenciales','info');
?>
<div class="row" style="margin-top: 25px">
<div class="col-lg-12">
<div class="table-responsive">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th>Descripción</th>
</tr>
</thead>
<tbody>
<?php foreach($vulnerabilidades as $key => $vuln) : ?>
<tr>
<td>
require "db-lib.php";
require "poll-lib.php";
if (!is_admin($PHP_AUTH_USER, $PHP_AUTH_PW)) {
header("Location: {$URL['login']}?url={$URL['new']}");
exit;
}
if ($m == 'register') {
/* Query 생성 */
$query = "insert into poll_data " . "(question,sdate,status,answer_no," . "answer1,answer2,answer3,answer4,answer5," . "answer6,answer7,answer8,answer9,answer10) values " . "('{$question}',now(),'1',{$answer_no}," . "'{$answer1}','{$answer2}','{$answer3}','{$answer4}','{$answer5}'," . "'{$answer6}','{$answer7}','{$answer8}','{$answer9}','{$answer10}')";
$dbh = dbconnect();
$sth = dbquery($dbh, $query);
if (!$sth) {
$msg = "에러가 발생하였습니다.<br><br>\n" . mysql_error();
print_message($msg);
} else {
print_alert("등록이 완료되었습니다. ", "url|{$URL['list']}");
}
} else {
new_form();
}
exit;
function new_form()
{
global $URL;
print_header();
?>
<script language="JavaScript">
<!--
function checkForm(form)
{
¿Está seguro que desea eliminar al <?php echo $person->cargo ?> <strong><?php echo ucfirst($person->nombre) ?></strong>?<br /> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Atras</button> <a href="<?php echo base_url().'index.php/cargar_datos/personal/eliminar/'.$person->id_personal ?>" type="button" class="btn btn-danger"> Eliminar </a> </div> </div> </div> </div> <?php endforeach ?> </tbody> </table> </div> <?php else : ?> <?php $msg = 'No se han cargado los datos del personal de el departamento '.ucfirst($dpto_actual->nombre).'. '; $link = '<a href="'.base_url().'index.php/cargar_datos/personal/cargar_personal/'.$id_departamento.'"><strong><u>Pulse aquí</u></strong></a> para ingresar personal a este departamento'; print_alert($msg.$link,'info'); ?> <?php endif ?> <?php endif ?> </div> </fieldset> </form> </div> </div> </div> </div>
