update() public method

public update ( $table, $id, $fields = [] )
Exemplo n.º 1
0
    foreach ($modules as $module) {
        // Require its initialisation file
        require 'core/modules/' . htmlspecialchars($module->name) . '/initialisation.php';
    }
    // Get site name from cache
    $c->setCache('sitenamecache');
    $sitename = htmlspecialchars($c->retrieve('sitename'));
    $smarty->assign('SITE_NAME', $sitename);
    // Perform tasks for signed in users
    if ($user->isLoggedIn()) {
        // Update a user's IP
        $ip = $user->getIP();
        if (filter_var($ip, FILTER_VALIDATE_IP)) {
            $user->update(array('lastip' => $ip));
        }
        // Update user last online
        $queries->update('users', $user->data()->id, array('last_online' => date('U')));
        // Perform moderator actions
        if ($user->canViewMCP($user->data()->id)) {
            // Are there any open reports for moderators?
            $reports = $queries->getWhere('reports', array('status', '<>', '1'));
            if (count($reports)) {
                $reports = true;
                // Open reports
            } else {
                $reports = false;
                // No open reports
            }
        }
    }
}
Exemplo n.º 2
0
 $c = new Cache();
 $c->setCache('themecache');
 $c->store('theme', 'Bootstrap');
 $c->store('inverse_navbar', '0');
 // Todo: update site name
 //$c->setCache('sitenamecache');
 //$c->store('sitename', htmlspecialchars(Input::get('sitename')));
 $c->setCache('templatecache');
 $c->store('template', 'Default');
 $c->setCache('languagecache');
 $c->store('language', 'EnglishUK');
 $c->setCache('page_load_cache');
 $c->store('page_load', 0);
 $plugin_key = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 32);
 // New settings
 $queries->update('settings', 13, array('value' => 'By registering on our website, you agree to the following:<p>This website uses "Nameless" website software. The "Nameless" software creators will not be held responsible for any content that may be experienced whilst browsing this site, nor are they responsible for any loss of data which may come about, for example a hacking attempt. The website is run independently from the software creators, and any content is the responsibility of the website administration.</p>'));
 $queries->create('settings', array('name' => 'mc_api_key', 'value' => $plugin_key));
 $queries->create('settings', array('name' => 'phpmailer', 'value' => '0'));
 $queries->create('settings', array('name' => 'phpmailer_type', 'value' => 'smtp'));
 $external_query = $queries->getWhere('settings', array('name', '=', 'external_query'));
 if (!count($external_query)) {
     $queries->create('settings', array('name' => 'external_query', 'value' => 'false'));
 }
 $queries->create('settings', array('name' => 'use_plugin', 'value' => '0'));
 $queries->create('settings', array('name' => 'uuid_linking', 'value' => '1'));
 $queries->create('settings', array('name' => 'inverse_navbar', 'value' => '0'));
 $queries->create('settings', array('name' => 'error_reporting', 'value' => '0'));
 $queries->create('settings', array('name' => 'ga_script', 'value' => 'null'));
 $queries->create('settings', array('name' => 'avatar_api', 'value' => 'cravatar'));
 // Languages
 $queries->create('settings', array('name' => 'language', 'value' => 'EnglishUK'));
Exemplo n.º 3
0
                                        ?>
</p>
	  </footer>
	</div> <!-- /container -->
	<!-- Bootstrap core JavaScript
	================================================== -->
	<!-- Placed at the end of the document so the pages load faster -->
	<script src="/assets/js/jquery.min.js"></script>
	<script src="/assets/js/bootstrap.min.js"></script>
  </body>
</html>
					<?php 
                                        try {
                                            foreach ($data as $setting) {
                                                $id = $setting["id"];
                                                $queries->update("settings", $id, array("name" => $setting["name"], "value" => $setting["value"]));
                                            }
                                        } catch (Exception $e) {
                                            die($e->getMessage());
                                        }
                                        die;
                                    }
                                    try {
                                        foreach ($data as $setting) {
                                            $id = $setting["id"];
                                            $queries->update("settings", $id, array("name" => $setting["name"], "value" => $setting["value"]));
                                        }
                                        echo '<script>window.location.replace("/install/?step=account");</script>';
                                        die;
                                    } catch (Exception $e) {
                                        die($e->getMessage());
Exemplo n.º 4
0
    $donor_groups = $queries->getWhere('groups', array("buycraft_id", "<>", "NULL"));
    foreach ($bc_payments["payload"] as $donor) {
        $donor_user = $queries->getWhere('users', array("uuid", "=", $donor["uuid"]));
        if (count($donor_user)) {
            // see if the user has registered
            // Are they a staff member?
            $user_group = $queries->getWhere('groups', array('id', '=', $donor_user[0]->group_id));
            if ($user_group[0]->staff == 1) {
                // Don't do anything as they're a staff member - we want them to keep their staff rank
            } else {
                if (count($donor["packages"]) === 1) {
                    $donor_group = $queries->getWhere("groups", array("buycraft_id", "=", $donor["packages"][0]));
                    $package_group_id = $donor_group[0]->id;
                    if ($donor_user[0]->group_id < $package_group_id) {
                        try {
                            $queries->update('users', $donor_user[0]->id, array('group_id' => $package_group_id));
                        } catch (Exception $e) {
                            die($e->getMessage());
                        }
                    }
                }
                /*
                 * TODO: Run check if user has purchased multiple packages
                 */
            }
        }
    }
} else {
    if ($webstore == 'mm') {
        // MinecraftMarket
        require 'integration/minecraftmarket.php';
Exemplo n.º 5
0
 *  Users
 */
/*
 *  Query the database
 */
$modernbb_users = $mysqli->query("SELECT * FROM {$prefix}users");
$modernbb_users->data_seek(0);
/*
 *  Loop through the users
 */
while ($row = $modernbb_users->fetch_assoc()) {
    if ($row["username"] === "Guest") {
        continue;
    }
    if ($row["username"] === $user->data()->username) {
        $queries->update("users", $user->data()->id, array("id" => $row["id"]));
        $queries->update("users_session", 1, array("user_id" => $row["id"]));
    } else {
        // Get the user's group info
        $group = $row["group_id"];
        $group = $mysqli->query("SELECT * FROM {$prefix}groups WHERE g_id = {$group}");
        $group->data_seek(0);
        $group = $group->fetch_assoc();
        if ($group["g_id"] == 1) {
            // admin
            $group_id = 2;
        } else {
            if ($group["g_id"] == 2) {
                // moderator
                $group_id = 3;
            } else {
Exemplo n.º 6
0
 *  Get the table prefix
 */
$prefix = 'xf_';
/*
 *  Users
 */
/*
 *  Query the database
 */
$xf_users = $mysqli->query("SELECT * FROM {$prefix}user");
/*
 *  Loop through the users
 */
while ($row = $xf_users->fetch_assoc()) {
    if ($row['username'] == $user->data()->username) {
        $queries->update('users', $user->data()->id, array("id" => $row["user_id"]));
        $queries->update('users_session', 1, array("user_id" => $row["user_id"]));
    } else {
        // Get the user's group info
        $group = $row["user_group_id"];
        if ($group == 1) {
            // unconfirmed, needs to be member
            $group_id = 1;
        } else {
            if ($group == 2) {
                // member
                $group_id = 1;
            } else {
                if ($group == 3) {
                    // admin
                    $group_id = 2;
Exemplo n.º 7
0
 require 'integration/buycraft.php';
 /*
  *  Categories and packages
  */
 $packages = array();
 $categories = array();
 if (count($bc_categories)) {
     foreach ($bc_categories['categories'] as $item) {
         // Does it already exist in the database?
         $category = $queries->getWhere('donation_categories', array('cid', '=', htmlspecialchars($item['id'])));
         if (!count($category)) {
             // Input it now
             $queries->create('donation_categories', array('name' => htmlspecialchars($item['name']), 'cid' => $item['id'], 'order' => $item['order']));
         } else {
             // Update category
             $queries->update('donation_categories', $category[0]->id, array('name' => htmlspecialchars($item['name']), 'cid' => $item['id'], '`order`' => $item['order']));
         }
         // Packages
         if (count($item['packages'])) {
             foreach ($item['packages'] as $package) {
                 // Does it already exist?
                 $package_exists = $queries->getWhere('donation_packages', array('package_id', '=', $package['id']));
                 if (!count($package_exists)) {
                     // Input it now
                     $queries->create('donation_packages', array('name' => htmlspecialchars($package['name']), 'description' => 'No description available', 'cost' => $package['price'], 'package_id' => $package['id'], 'active' => 1, 'package_order' => $package['order'], 'category' => $item['id'], 'url' => 'none'));
                 } else {
                     // Update package
                     // Only update description if no custom one is set
                     if ($package_exists[0]->custom_description == 0) {
                         $queries->update('donation_packages', $package_exists[0]->id, array('name' => htmlspecialchars($package['name']), 'description' => 'No description available', 'cost' => $package['price'], 'package_id' => $package['id'], 'active' => 1, 'package_order' => $package['order'], 'category' => $item['id'], 'url' => 'none'));
                     } else {