function createAdmin()
{
$db = new CTextDB(PLUGIN_MOVIEVIEWER_COMMU_DIR . "/data/admin.txt");
$result = $db->select('$id==\'1\'');
$id = $result[0]['value'];
$result = $db->select('$id==\'2\'');
$hashedPassword = $result[0]['value'];
$object = new MovieViewerCommuAdmin();
$object->id = $id;
$object->firstName = "Admin";
$object->lastName = "Commu";
$object->hashedPassword = $hashedPassword;
return $object;
}
function edit_form($page, $postdata, $digest = FALSE, $b_template = TRUE)
{
global $script, $vars, $rows, $cols, $hr, $function_freeze;
global $_btn_preview, $_btn_repreview, $_btn_update, $_btn_cancel, $_msg_help;
global $whatsnew, $_btn_template, $_btn_load, $load_template_func;
global $notimeupdate;
global $qhm_access_key;
global $qblog_defaultpage, $style_name, $date_format, $qblog_default_cat;
$qt = get_qt();
//accesskey setting
$accesskey = array();
foreach (array('r', 'p', 's', 'c') as $v) {
$accesskey[$v] = $qhm_access_key ? 'accesskey="' . $v . '"' : '';
}
// Newly generate $digest or not
if ($digest === FALSE) {
$digest = md5(join('', get_source($page)));
}
$refer = $template = $headertitle = '';
// Add plugin
$addtag = $add_top = '';
if (isset($vars['add'])) {
global $_btn_addtop;
$addtag = '<input type="hidden" name="add" value="true" />';
$add_top = isset($vars['add_top']) ? ' checked="checked"' : '';
$add_top = '<input type="checkbox" name="add_top" ' . 'id="_edit_form_add_top" value="true"' . $add_top . ' />' . "\n" . ' <label for="_edit_form_add_top" class="checkbox">' . '<span class="small">' . $_btn_addtop . '</span>' . '</label>';
}
if ($load_template_func && $b_template) {
$pages = array();
foreach (get_existpages() as $_page) {
if ($_page == $whatsnew || check_non_list($_page)) {
continue;
}
$s_page = htmlspecialchars($_page);
$pages[$_page] = ' <option value="' . $s_page . '">' . $s_page . '</option>';
}
ksort($pages);
$s_pages = join("\n", $pages);
$template = <<<EOD
<select name="template_page">
<option value="">-- {$_btn_template} --</option>
{$s_pages}
</select>
<input type="submit" name="template" value="{$_btn_load}" {$accesskey['r']} />
<br />
EOD;
}
//新規作成の場合、ページ名を大見出しとして挿入する
if (isset($vars['refer']) && $vars['refer'] != '') {
$headertitle = "\n\n" . '* ' . strip_bracket($page) . "\n\n";
}
$r_page = rawurlencode($page);
$s_page = htmlspecialchars($page);
$s_digest = htmlspecialchars($digest);
$s_postdata = htmlspecialchars($refer . $headertitle . $postdata);
$s_original = isset($vars['original']) ? htmlspecialchars($vars['original']) : $s_postdata;
$b_preview = isset($vars['preview']);
// TRUE when preview
$btn_preview = $b_preview ? $_btn_repreview : $_btn_preview;
// Checkbox 'do not change timestamp'
$add_notimestamp = '';
if ($notimeupdate != 0) {
global $_btn_notchangetimestamp;
$checked_time = isset($vars['notimestamp']) ? ' checked="checked"' : '';
// Only for administrator
if ($notimeupdate == 2) {
$add_notimestamp = ' ' . '<input type="password" name="pass" size="12" />' . "\n";
}
$add_notimestamp = '<label for="_edit_form_notimestamp" class="checkbox"><input type="checkbox" name="notimestamp" ' . 'id="_edit_form_notimestamp" value="true"' . $checked_time . ' tabindex="9" />' . "\n" . ' ' . '<span class="small">' . $_btn_notchangetimestamp . '</span></label>' . "\n" . $add_notimestamp . ' ';
}
$buttons_align = 'left';
$blog_cancel_button = 'right';
if (is_bootstrap_skin()) {
$buttons_align = 'right';
$blog_cancel_button = 'left';
} else {
//Bootstrap の読み込み
$include_bs = '
<link rel="stylesheet" href="skin/bootstrap/css/bootstrap-custom.min.css" />
<script type="text/javascript" src="skin/bootstrap/js/bootstrap.min.js"></script>';
$qt->appendv_once('include_bootstrap_pub', 'beforescript', $include_bs);
}
// !ブログ用編集フォーム
if ($page !== $qblog_defaultpage && is_qblog()) {
//メタデータを取得
$data = get_qblog_post_data($page);
$data['title'] = isset($vars['title']) ? $vars['title'] : $data['title'];
$data['category'] = isset($vars['category']) ? $vars['category'] : $data['category'];
$data['image'] = isset($vars['image']) ? $vars['image'] : $data['image'];
$date = get_qblog_date($date_format, $page);
if (isset($vars['qblog_date']) && $date !== trim($vars['qblog_date'])) {
$dates = array_pad(explode('-', $vars['qblog_date'], 3), 3, 0);
$valid = checkdate($dates[1], $dates[2], $dates[0]);
$date = $valid ? trim($vars['qblog_date']) : $date;
}
$category = isset($data['category']) && strlen(trim($data['category'])) > 0 ? $data['category'] : '';
$qblog_categories = array_keys(get_qblog_categories());
$qblog_cat_json = json_encode($qblog_categories);
$h_qblog_cat_json = h(json_encode($qblog_categories));
$qblog_cat_list = '<ul id="qblog_categories_selector" class="qblog_categories collapse">';
foreach ($qblog_categories as $cat) {
$qblog_cat_list .= '<li>' . h($cat) . '</li>';
}
$qblog_cat_list .= '</ul>';
$h2title = '新規投稿';
if (is_page($page)) {
$h2title = $data['title'] . 'の編集';
}
$s_h2title = h($h2title);
$s_blog_title = h($data['title']);
$body = <<<EOD
<link rel="stylesheet" href="js/datepicker/css/datepicker.css" />
<link rel="stylesheet" href="plugin/qblog/qblog.css" />
<script src="js/datepicker/js/bootstrap-datepicker.js"></script>
<script tyle="text/javascript">
\$(function(){
\t\$('#qblog_datepicker').datepicker({
\t\tlanguage: "japanese"
//\t\tformat: "yyyy/mm/dd"
\t});
\tif (\$("input[name=category]").val().length == 0) {
\t\t\$('#qblog_cat_trigger').click();
\t}
\tif (\$('h2.title').length == 0) {
\t\t\$("#edit_form_main").before('<h2 class="title">{$s_h2title}</h2>');
\t}
\t\$('h2.title').text('{$s_h2title}');
\t\$('a.show-thumbnail').click(function(){
\t\tif (\$(this).next().is(':visible')) {
\t\t\t\$(this).next().hide();
\t\t}
\t\telse {
\t\t\t\$(this).next().show();
\t\t}
\t\treturn false;
\t});
});
</script>
<div class="qblog_edit_form">
<form action="{$script}" method="post" class="form-horizontal" id="edit_form_main">
{$template}
{$addtag}
<input type="hidden" name="cmd" value="edit" />
<input type="hidden" name="page" value="{$s_page}" />
<input type="hidden" name="digest" value="{$s_digest}" />
<fieldset>
<div class="form-group">
<label class="control-label col-sm-2">日付</label>
<div class="controls col-sm-10"><input type="text" name="qblog_date" id="qblog_datepicker" tabindex="1" class="datepicker form-control" size="16" value="{$date}" data-date="{$date}" data-date-format="yyyy-mm-dd" class="form-control" /></div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">タイトル</label>
<div class="controls col-sm-10"><input type="text" name="title" value="{$s_blog_title}" tabindex="2" class="form-control" /></div>
\t</div>
<div class="form-group">
<label class="control-label col-sm-2">カテゴリ</label>
<div class="controls col-sm-10">
<div class="input-group">
<input type="text" name="category" value="{$category}" placeholder="{$qblog_default_cat}" tabindex="3" class="form-control" data-provide="typeahead" data-source="{$h_qblog_cat_json}" autocomplete="off" />
<span class="input-group-btn">
<button type="button" id="qblog_cat_trigger" class="btn btn-default qhm-btn-default" data-toggle="collapse" data-target="#qblog_categories_selector" style="color:#333">
カテゴリ
<span class="caret"></span>
</button>
</span>
</div>
{$qblog_cat_list}
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2">記事の内容</label>
<div class="controls col-sm-10">
<textarea name="msg" id="msg" tabindex="4" rows="20" class="form-control">{$s_postdata}</textarea>
\t\t</div>
\t</div>
<div class="form-group">
<div class="controls col-sm-10 col-sm-offset-2">
\t \t\t<a class="show-thumbnail" href="#">サムネイルを指定する >></a>
\t\t\t<div class="set-thumbnail">
\t\t\t\t<small>自動で本文の画像が使われます。<br />特別に指定したい場合、画像を画像名またはURLで指定してください。</small>
<p style="color:#333;">画像名またはURL：<input type="text" name="image" value="{$data['image']}" tabindex="5" class="form-control" /></p>
\t\t\t\t<p><small><span class="swfu"><a href="swfu/index_child.php">>>QHMのファイル管理（SWFU）を使って画像をアップする</a></span></small></p>
\t\t\t</div>
<!-- \t\t\t<span class="swfu"><a href="swfu/index_child.php"><i class="icon-picture"></i>SWFU</a><span>
\t\t\t<p class="help-block">SWFUの画像を使う場合、画像詳細画面の<b>URL</b>をコピペしてください。</p>
-->
\t\t</div>
\t</div>
<div class="form-group">
<div class="col-sm-10 col-sm-offset-2">
<div style="float:{$buttons_align};">
<input type="submit" name="preview" value="{$btn_preview}" tabindex="6" class="qhm-btn-default"/>
<input type="submit" name="write" value="{$_btn_update}" tabindex="7" class="qhm-btn-primary"/>
\t\t{$add_notimestamp}
{$add_top}
\t\t<textarea name="original" rows="1" cols="1" style="display:none">{$s_original}</textarea>
</div>
<div style="float:{$buttons_align};">
<input type="submit" name="cancel" value="{$_btn_cancel}" tabindex="8" class="btn-link"/>
</div>
</div>
\t</div>
</fieldset>
</form>
</div>
EOD;
} else {
$body = <<<EOD
<div class="edit_form">
<form action="{$script}" method="post" style="margin-bottom:0px;" id="edit_form_main">
{$template}
{$addtag}
<input type="hidden" name="cmd" value="edit" />
<input type="hidden" name="page" value="{$s_page}" />
<input type="hidden" name="digest" value="{$s_digest}" />
<div class="form-group">
<textarea name="msg" id="msg" rows="{$rows}" cols="{$cols}" tabindex="2" class="form-control">{$s_postdata}</textarea>
</div>
<div style="float:{$buttons_align};">
<input type="submit" name="preview" value="{$btn_preview}" tabindex="4" class="qhm-btn-default"/>
<input type="submit" name="write" value="{$_btn_update}" tabindex="5" class="qhm-btn-primary"/>
{$add_top}
{$add_notimestamp}
</div>
<textarea name="original" rows="1" cols="1" style="display:none">{$s_original}</textarea>
</form>
<form action="{$script}" method="post" style="margin-top:0px;margin-left:5px;float:{$buttons_align};" id="edit_form_cancel">
<input type="hidden" name="cmd" value="edit" />
<input type="hidden" name="page" value="{$s_page}" />
<input type="submit" name="cancel" value="{$_btn_cancel}" tabindex="6" class="btn-link"/>
</form>
<div style="clear:both;"></div>
</div>
EOD;
}
$addscript = <<<EOD
<script data-qhm-plugin="edit">
\$(function(){
if (\$("h2.title").length == 0) {
\$(".edit_form").before('<h2 class="title">{$s_page} の編集</h2>');
}
\$("h2.title").css({fontSize: "14px", marginBottom: '15px'});
\$("#editboxlink").on("click", function(){
if (\$(".qblog_edit_form").length) {
QHM.scroll(".qblog_edit_form", 300);
}
else {
QHM.scroll("h2.title", 300);
}
\$("#msg").focus();
return false;
});
if (\$("#preview_body").length) {
}
else {
\$(".qhm-eyecatch").hide();
setTimeout(function(){
\$("html, body").animate({scrollTop: \$("h2.title").offset().top}, 300);
\$("#msg").focus();
}, 25);
}
});
</script>
EOD;
$qt->appendv_once("plugin_edit_form_script", 'lastscript', $addscript);
// List of attached files to the page by hokuken.com
$attaches = exist_plugin_action('attach') ? attach_filelist(true) : '';
if ($attaches !== '') {
$body .= <<<EOD
<script type="text/javascript" src="js/yahoo.js"></script>
<script type="text/javascript" src="js/event.js"></script>
<script type="text/javascript" src="js/dom.js"></script>
<style type="text/css">
.yui-tt {
\tposition: absolute;
\tpadding: 5px;
\tbackground-color:#eee;
\tborder:1px solid #aaa;
}
</style>
<script type="text/javascript" src="js/container.js"></script>
<script type="text/javascript">
function init() {
var el = document.getElementById('attachlist');
if(el != null){
\t var list = el.getElementsByTagName('a');
\t for( var i=0; i<list.length; i++ ) {
\t if( list[i].getAttribute("rel") == "attachhref" ){
\t\t\t\t\tvar el = 'tooltip'+i;
\t\t\t\t\tvar url = list[i].href;
\t\t\t\t\tvar title = '<img src="'+list[i].href+'">';
\t\t\t\t\tif ( list[i].title ) title += '<br>'+list[i].innerHTML;
\t\t\t\t\tvar tp = new YAHOO.widget.Tooltip( el, { context:list[i], text: title, autodismissdelay: 7500 } );
\t\t\t\t}
\t }
}
var el = document.getElementById('swfulist');
if(el != null){
\tvar list = el.getElementsByTagName('a');
\t for( var i=0; i<list.length; i++ ) {
\t if( list[i].getAttribute("rel") == "attachhref" ){
\t\t\t\t\tvar el = 'tooltip'+i;
\t\t\t\t\tvar url = list[i].getAttribute("url");
\t\t\t\t\tvar title = '<img src="'+url+'">';
\t\t\t\t\tif ( list[i].title ) title += '<br>'+list[i].innerHTML;
\t\t\t\t\tvar tp = new YAHOO.widget.Tooltip( el, { context:list[i], text: title, autodismissdelay: 7500 } );
\t\t\t\t}
\t }
\t\t}
}
YAHOO.util.Event.addListener(window, "load", init);
</script>
EOD;
$body .= '<br /><div id="attachlist" style="border: 2px dashed #666;padding:5px 10px;background-color:#eee">' . $attaches . '</div>';
}
$qm = get_qm();
$helpstr = $qm->m['html']['view_help_message'];
//list up swfu files
if (has_swfu()) {
require_once SWFU_TEXTSQL_PATH;
$db = new CTextDB(SWFU_IMAGEDB_PATH);
$imgtitle = $qm->m['html']['img_title'];
$imgtitle2 = $qm->m['html']['img_title2'];
$attcstr = $qm->m['html']['attach_message'];
//! swfuの画像データを取得して表示をする
$rs = $db->select('$page_name=="' . $page . '"', 'created desc');
if (count($rs) > 0) {
$body .= '<div id="swfulist" style="border:1px #aaa dashed;margin-top:10px;padding:10px;font-size:12px">';
$body .= '<b><a href="./swfu/index_child.php?page=FrontPage&KeepThis=true&TB_iframe=true&height=450&width=650" class="thickbox">' . $attcstr . '(SWFU)</a> : </b>';
foreach ($rs as $k => $v) {
$path = SWFU_IMAGE_DIR . $v['name'];
$prop = SWFU_DIR . 'view.php?id=' . $v['id'] . '&page=FrontPage&KeepThis=true&TB_iframe=true&height=450&width=650';
$body .= '<span style="padding:2px;margin-right:5px">';
$atitle1 = $qm->replace("html.insert_title", $v['name']);
$atitle2 = $qm->replace("html.ar_insert_title", $v['name']);
if (preg_match('/\\.(png|jpeg|jpg|gif)$/i', $v['name'])) {
$title = h($v['name']);
$body .= '<a href="' . $prop . '" url="' . $path . '" rel="attachhref" class="thickbox" title="' . $title . '"><img src="image/file.png" width="20" height="20" alt="file" style="border-width:0" />' . $v['name'] . '</a>';
$body .= <<<EOD
<a href="#" title="{$atitle1}" onclick="javascript:jQuery.clickpad.cpInsert('&show({$v['name']},,{$v['description']});'); return false;"><img src="image/ins-img.png" alt="{$imgtitle}"/></a><a href="#" title="{$atitle2}" onclick="javascript:jQuery.clickpad.cpInsert('\\n#show({$v['name']},aroundl,{$v['description']})\\n'); return false;"><img src="image/ins-img2.png" alt="{$imgtitle2}" /></a>
EOD;
} else {
$body .= '<a href="' . $path . '"><img src="image/file.png" width="20" height="20" alt="file" style="border-width:0" />' . $v['name'] . '</a>';
$body .= <<<EOD
<a href="#" title="{$v['name']}" onclick="javascript:insert('&dlbutton({$path});'); return false;"><img src="image/ins-btn.png" alt="{$imgtitle}"/></a>
EOD;
}
$body .= '</span>';
}
$body .= '</div>';
}
}
return $body;
}
/**
* 画像を添付するためのもの
*/
function plugin_show_action()
{
global $script, $vars, $username;
global $html_transitional;
$qm = get_qm();
//check auth
$editable = edit_auth($vars['refer'], FALSE, FALSE);
if (!$editable) {
return array('msg' => $qm->m['plg_attachref']['title_ntc_admin'], 'body' => '<p>' . $qm->m['plg_attachref']['ntc_admin'] . '</p>');
}
//戻り値を初期化
$retval['msg'] = $qm->m['plg_attachref']['title'];
$retval['body'] = '';
if (array_key_exists('attach_file', $_FILES) and array_key_exists('refer', $vars) and is_page($vars['refer'])) {
$file = $_FILES['attach_file'];
$attachname = $file['name'];
$filename = preg_replace('/\\..+$/', '', $attachname, 1);
//! swfuを持っていたら (管理者のみ)--------------------------------------------
if ($editable && has_swfu()) {
//アップロードするファイル名を決める（日本語ダメ、重複もダメ）
$upload_name = $file['name'];
if (preg_match('/^[-_.+a-zA-Z0-9]+$/', $upload_name)) {
while (!$overwrite && file_exists(SWFU_IMAGE_DIR . $upload_name)) {
$upload_name = 's_' . $upload_name;
}
$upload_file = SWFU_IMAGE_DIR . $upload_name;
$fname = $upload_name;
$disp = $qm->m['plg_attachref']['img_desc'];
} else {
$matches = array();
if (!preg_match('/[^.]+\\.(.*)$/', $upload_name, $matches)) {
echo 'invalid file name : ' . $upload_name;
exit(0);
}
$ext = $matches[1];
$tmp_name = tempnam(SWFU_IMAGE_DIR, 'auto_');
$upname = $tmp_name . '.' . $ext;
$disp = $upload_name;
rename($tmp_name, $upname);
$upload_file = SWFU_IMAGE_DIR . basename($upname);
$fname = basename($upname);
}
move_uploaded_file($file['tmp_name'], $upload_file);
chmod($upload_file, 0666);
//regist db
$stat = stat($upload_file);
$data = array('name' => $fname, 'description' => $disp, 'created' => $stat['mtime'], 'size' => $stat['size'], 'page_name' => $vars['refer']);
require_once SWFU_TEXTSQL_PATH;
$db = new CTextDB(SWFU_IMAGEDB_PATH);
$db->insert($data);
$retval = show_insert_ref(SWFU_IMAGE_DIR . $fname);
return $retval;
}
// open qhm用 attachフォルダにファイルを置く
//すでに存在した場合、 ファイル名に'_0','_1',...を付けて回避(姑息)
$count = '_0';
while (file_exists('./attach/' . encode($vars['refer']) . '_' . encode($attachname))) {
$attachname = preg_replace('/^[^\\.]+/', $filename . $count++, $file['name']);
}
$file['name'] = $attachname;
require_once PLUGIN_DIR . "attach.inc.php";
if (!exist_plugin('attach') or !function_exists('attach_upload')) {
return array('msg' => $qm->m['plg_attachref']['err_notfound']);
}
$pass = array_key_exists('pass', $vars) ? $vars['pass'] : NULL;
$retval = attach_upload($file, $vars['refer'], $pass);
if ($retval['result'] == TRUE) {
$retval = show_insert_ref($file['name']);
}
} else {
$retval = show_showform();
// XHTML 1.0 Transitional
$html_transitional = TRUE;
}
return $retval;
}
function del($table, $condition, $connect)
{
$db = new CTextDB();
return $db->delete($condition, $table);
}
