process(); $rec = $rs->next(); if(!isset($rec['newid'])) $rec['newid'] = 1; $_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'; } $_REQUEST['error'] = $error; $_REQUEST['notice'] = $notice; //Assign Smarty variables and load the admin template $smarty->display('room.tpl'); ?>