Esempio n. 1
0
}
$q = new DBSelect('pages', array('*'), '', 'Failed to get page list');
$result = $q->commit();
if (isset($_POST['form_sent_b'])) {
    if (futurebb_hash($_POST['confirmpwd']) == $futurebb_user['password']) {
        foreach ($_POST as $key => $val) {
            if (ctype_digit((string) $key)) {
                //insert history entry
                $select = new DBSelect('pages', array('*'), 'id=' . intval($key), 'Failed to get old value');
                $result = $select->commit();
                $element = $db->fetch_assoc($result);
                $lines = array();
                foreach ($element as $db_key => $db_val) {
                    $lines[] = $db_key . '=>' . $db_val;
                }
                $insertquery = new DBInsert('interface_history', array('action' => 'edit', 'area' => 'pages', 'field' => intval($key), 'user' => $futurebb_user['id'], 'time' => time(), 'old_value' => base64_encode(implode("\n", $lines))), 'Failed to insert history entry');
                $insertquery->commit();
                foreach ($val as $field => $field_value) {
                    //update the field
                    $updatequery = new DBUpdate('pages', array($field => $field_value), 'id=' . intval($key), 'Failed to update page entry');
                    $updatequery->commit();
                }
            }
        }
        CacheEngine::CachePages();
        redirect($base_config['baseurl'] . '/admin/interface/pages');
    } else {
        echo '<p>Your password was incorrect. Hit the back button to try again.</p>';
        return;
    }
} else {
Esempio n. 2
0
 public function createNewOrder($storeName)
 {
     $insertor = new DBInsert('localhost', 'root', '', 'mydb');
     $orderID = $insertor->insertNewOrder($this->getUsername(), $storeName);
     return $orderID;
 }
Esempio n. 3
0
         $q = new DBInsert('forums', $fields, 'Failed to insert forum');
         $q->commit();
     }
     echo '<p>Forums completed!</p>';
     header('Refresh: 2; url=' . $base_config['baseurl'] . '/mass_import?import&part=categories');
     break;
 case 'categories':
     $q = new DBDelete('categories', '1=1', 'Failed to delete all existing categories');
     $q->commit();
     $cats_xml = $xml->categories;
     foreach ($cats_xml->category as $val) {
         $fields = array();
         foreach ($val as $field => $data) {
             $fields[(string) $field] = (string) $data;
         }
         $q = new DBInsert('categories', $fields, 'Failed to insert category');
         $q->commit();
     }
     echo '<p>Categories completed!</p>';
     header('Refresh: 2; url=' . $base_config['baseurl'] . '/mass_import?import&part=createforumurls');
     break;
 case 'createforumurls':
     $q = new DBSelect('forums', array('id', 'name'), '1=1', 'Failed to get forum list');
     $r1 = $q->commit();
     while (list($id, $fname) = $db->fetch_row($r1)) {
         $base_name = URLEngine::make_friendly($fname);
         $name = $base_name;
         $add_num = 0;
         //check for forums with the same URL
         $result = $db->query('SELECT url FROM `#^forums` WHERE url LIKE \'' . $db->escape($name) . '%\'') or error('Failed to check for similar URLs', __FILE__, __LINE__, $db->error());
         $urllist = array();
 public function addOrderItemToOrder(OrderItem $orderItem)
 {
     $insertor = new DBInsert('localhost', 'root', '', 'mydb');
     $insertor->insertNewOrderItem($this->orderID, $this->storeName, $orderItem->getItemName(), $orderItem->getQuantity(), $orderItem->getPrice());
 }
Esempio n. 5
0
            $changes = array();
            if ($newkey != $old_lang['langkey']) {
                $changes['langkey'] = $newkey;
            }
            if ($newval != $old_lang['value']) {
                $changes['value'] = $newval;
            }
            if ($newcategory != $old_lang['category']) {
                $changes['category'] = $newcategory;
            }
            if (!empty($changes)) {
                $oldval = array();
                foreach ($old_lang as $db_key => $db_val) {
                    $oldval[] = $db_key . '=>' . $db_val;
                }
                $q2 = new DBInsert('interface_history', array('action' => 'edit', 'area' => 'language', 'field' => $id, 'user' => $futurebb_user['id'], 'time' => time(), 'old_value' => implode("\n", $oldval)), 'Failed to insert history entry');
                $q2->commit();
                $q2 = new DBUpdate('language', $changes, 'id=' . $id, 'Failed to update language');
                $q2->commit();
            }
        }
        //clear the cache
        CacheEngine::CacheLanguage();
        redirect($base_config['baseurl'] . '/admin/interface/language');
        return;
    } else {
        echo '<p>Your password was incorrect. Hit the back button to try again.</p>';
        return;
    }
}
if (isset($_GET['delete'])) {
Esempio n. 6
0
 set_config('admin_pages', 'PT5pbmRleApiYW5zPT5iYW5zCnJlcG9ydHM9PnJlcG9ydHMKY2Vuc29yaW5nPT5jZW5zb3JpbmcKZm9ydW1zPT5mb3J1bXMKaXBfdHJhY2tlcj0+aXB0cmFja2VyCnVzZXJfZ3JvdXBzPT51c2VyZ3JvdXBzCnRyYXNoX2Jpbj0+dHJhc2hiaW4KbWFpbnRlbmFuY2U9Pm1haW50ZW5hbmNlCnN0eWxlPT5zdHlsZQpleHRlbnNpb25zPT5leHRlbnNpb25zCmludGVyZmFjZT0+aW50ZXJmYWNl');
 set_config('mod_pages', 'YmFucz0+YmFucwpyZXBvcnRzPT5yZXBvcnRzCnRyYXNoX2Jpbj0+dHJhc2hiaW4KaXBfdHJhY2tlcj0+aXB0cmFja2Vy');
 set_config('date_format', 'd M Y');
 set_config('time_format', 'H:i');
 //create guest user
 $insert = new DBInsert('users', array('username' => 'Guest', 'password' => 'Guest', 'email' => '', 'registered' => 0, 'registration_ip' => '', 'group_id' => 0, 'last_visit' => 0, 'last_page_load' => 0, 'signature' => ''), 'Failed to create admin user');
 $insert->commit();
 //create admin user
 $insert = new DBInsert('users', array('username' => get_cookie_data('adminusername'), 'password' => futurebb_hash(get_cookie_data('adminpass')), 'email' => get_cookie_data('adminemail'), 'registered' => time(), 'registration_ip' => $_SERVER['REMOTE_ADDR'], 'group_id' => 1, 'last_visit' => time(), 'last_page_load' => time(), 'rss_token' => md5(time())), 'Failed to create admin user');
 $insert->commit();
 //create user groups
 $insert = new DBInsert('user_groups', array('g_permanent' => 1, 'g_guest_group' => 0, 'g_name' => 'Administrators', 'g_title' => 'Administrator', 'g_admin_privs' => 1, 'g_mod_privs' => 1, 'g_edit_posts' => 1, 'g_delete_posts' => 1, 'g_signature' => 1, 'g_user_list' => 1, 'g_user_list_groups' => '', 'g_promote_group' => 0, 'g_promote_posts' => 0, 'g_promote_operator' => 0, 'g_promote_days' => 0, 'g_post_flood' => 0, 'g_posts_per_hour' => 0, 'g_post_links' => 1, 'g_post_images' => 1), 'Failed to create admin user group');
 $insert->commit();
 $insert = new DBInsert('user_groups', array('g_permanent' => 1, 'g_guest_group' => 1, 'g_name' => 'Guests', 'g_title' => 'Guest', 'g_admin_privs' => 0, 'g_mod_privs' => 0, 'g_edit_posts' => 0, 'g_delete_posts' => 0, 'g_signature' => 0, 'g_user_list' => 0, 'g_user_list_groups' => '', 'g_promote_group' => 0, 'g_promote_posts' => 0, 'g_promote_operator' => 0, 'g_promote_days' => 0, 'g_post_flood' => 0, 'g_posts_per_hour' => 0, 'g_post_links' => 0, 'g_post_images' => 0), 'Failed to create guest user group');
 $insert->commit();
 $insert = new DBInsert('user_groups', array('g_permanent' => 1, 'g_guest_group' => 0, 'g_name' => 'Members', 'g_title' => 'Member', 'g_admin_privs' => 0, 'g_mod_privs' => 0, 'g_edit_posts' => 1, 'g_delete_posts' => 1, 'g_signature' => 1, 'g_user_list' => 1, 'g_user_list_groups' => '', 'g_promote_group' => 0, 'g_promote_posts' => 0, 'g_promote_operator' => 0, 'g_promote_days' => 0, 'g_post_flood' => 60, 'g_posts_per_hour' => 0, 'g_post_links' => 1, 'g_post_images' => 1), 'Failed to create member user group');
 $insert->commit();
 //run through stock cache to insert pages and language keys
 include FORUM_ROOT . '/app_config/cache/pages.php';
 $q = 'INSERT INTO `#^pages`(url,file,template,nocontentbox,admin,moderator,subdirs) VALUES';
 $page_insert_data = array();
 foreach ($pages as $url => $info) {
     $page_insert_data[] = '(\'' . $db->escape($url) . '\',\'' . $db->escape($info['file']) . '\',' . ($info['template'] ? '1' : '0') . ',' . (isset($info['nocontentbox']) ? '1' : '0') . ',' . ($info['admin'] ? '1' : '0') . ',' . ($info['mod'] ? '1' : '0') . ',0)';
 }
 foreach ($pagessubdirs as $url => $info) {
     $page_insert_data[] = '(\'' . $db->escape($url) . '\',\'' . $db->escape($info['file']) . '\',' . ($info['template'] ? '1' : '0') . ',' . (isset($info['nocontentbox']) ? '1' : '0') . ',' . ($info['admin'] ? '1' : '0') . ',' . ($info['mod'] ? '1' : '0') . ',1)';
 }
 $q = new DBMassInsert('pages', array('url', 'file', 'template', 'nocontentbox', 'admin', 'moderator', 'subdirs'), $page_insert_data, 'Failed to insert pages');
 $q->commit();
 unset($page_insert_data);
 unset($pages);
Esempio n. 7
0
 static function add_language_key($key, $text, $language = 'English', $category = 'main')
 {
     $q = new DBInsert('language', array('language' => $language, 'langkey' => $key, 'value' => $text, 'category' => $category), 'Failed to insert language key');
     $q->commit();
     //clear the cache
     $maindir = FORUM_ROOT . '/app_config/cache/language/' . $language;
     if (file_exists($maindir) && is_dir($maindir)) {
         $handle = opendir($maindir);
         while ($file = readdir($handle)) {
             if ($file != '.' && $file != '..') {
                 unlink($maindir . '/' . $file);
             }
         }
     }
 }
Esempio n. 8
0
</head>
<body>
  <?php 
require_once './php/Common/DBConnect.php';
// DB接続用
require_once './php/Register/RegisterControl.php';
require_once './php/Register/RegisterModel.php';
echo '<br><br><br>';
// 変数定義
$InputName = new InputName();
// アルバム名設定クラス
$DBCon = new DBCon();
// DB接続クラス
$UpList = new UpList();
// POSTデータ格納クラス
$DBInsert = new DBInsert();
// DB格納クラス
$DBSelect = new DBSelect();
// DBデータ取得クラス
$Done = null;
// DB操作結果
// DB接続にエラーが発生している場合は、始めに知らせる。
if ($DBInsert->getError != null) {
    echo $DBInsert->getError();
    require_once './php/Common/ExitCode.html';
    exit;
}
// 新規または既存アルバム名を取得(Model→Control)
$InputName->setInputName(htmlspecialchars($_POST['CreateName']), $_POST['AlbumList']);
$UpList->setAlbumName($InputName->getInputName());
// 新規アルバム名の場合はディレクトリを作成