📄 room.php
字号:
<?php
include_once('init.php');
if(!inSession()) {
include('login.php');
exit;
}
$error = '';
$notice = '';
if(!isset($_REQUEST['ispublic'])) $_REQUEST['ispublic'] = null;
if(!isset($_REQUEST['ispermanent'])) $_REQUEST['ispermanent'] = null;
if(isset($_REQUEST['add'])) {
if(!$_REQUEST['name']) {
$error = 'name cannot be empty';
} else {
$stmt = new Statement("SELECT MAX(id)+1 AS newid FROM {$GLOBALS['fc_config']['db']['pref']}rooms");
$rs = $stmt->process();
$rec = $rs->next();
$_REQUEST['ispermanent'] = $rec['newid'];
$stmt = new Statement("INSERT INTO {$GLOBALS['fc_config']['db']['pref']}rooms (created, name, password, ispublic, ispermanent) VALUES (NOW(), ?, ?, ?, ?)");
$_REQUEST['id'] = $stmt->process($_REQUEST['name'], $_REQUEST['password'], $_REQUEST['ispublic'], $_REQUEST['ispermanent']);
$notice = 'room added';
}
} else if(isset($_REQUEST['set'])) {
if(!$_REQUEST['name']) {
$error = 'name cannot be empty';
} else if(!$_REQUEST['id']) {
$error = 'wrong room id';
} else {
$stmt = new Statement("UPDATE {$GLOBALS['fc_config']['db']['pref']}rooms SET name=?, password=?, ispublic=?, ispermanent=? WHERE id=?");
$stmt->process($_REQUEST['name'], $_REQUEST['password'], $_REQUEST['ispublic'], $_REQUEST['ispermanent'], $_REQUEST['id']);
$notice = 'room updated';
}
} else if(isset($_REQUEST['del'])) {
if(!$_REQUEST['id']) {
$error = 'wrong room id';
} else {
$stmt = new Statement("DELETE FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE id=?");
$stmt->process($_REQUEST['id']);
$notice = 'room removed';
$_REQUEST['id'] = null;
}
}
if(isset($_REQUEST['id'])) {
$stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE id=?");
$rs = $stmt->process($_REQUEST['id']);
$_REQUEST = $rs->next();
} else {
$_REQUEST['id'] = 0;
$_REQUEST['name'] = '';
$_REQUEST['password'] = '';
$_REQUEST['ispublic'] = 'y';
$_REQUEST['ispermanent'] = 'y';
}
//Assign Smarty variables and load the admin template
$smarty->display('room.tpl');
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -