/** * Creates a new game account. * * @param int user id * @param string user name * @param string email */ public static function create($userID, $username, $email) { $sql = "INSERT INTO ugml_users\n\t\t\t\t(id, username, email,\n\t\t\t\t email_2, register_time, lastLoginTime,\n\t\t\t\t dilizium, diliziumFeatures)\n\t\t\t\tVALUES\n\t\t\t\t(" . $userID . ", '" . escapeString($username) . "', '" . escapeString($email) . "',\n\t\t\t\t '" . $email . "', " . time() . ", " . time() . ",\n\t\t\t\t 500, 'a:0:{}')"; WCF::getDB()->sendQuery($sql); $sql = "UPDATE ugml_config\n\t\t\t\tSET config_value = (SELECT COUNT(*)\n\t\t\t\t\t\t\t\t\tFROM ugml_users)\n\t\t\t\tWHERE config_name = 'users_amount'"; WCF::getDB()->sendQuery($sql); $accountEditor = new AccountEditor($userID); // TODO: event listener require_once LW_DIR . 'lib/data/news/News.class.php'; require_once LW_DIR . 'lib/data/user/UserSettings.class.php'; WCF::getCache()->addResource('news-' . PACKAGE_ID, WCF_DIR . 'cache/cache.news-' . PACKAGE_ID . '.php', LW_DIR . 'lib/system/cache/CacheBuilderNews.class.php'); $news = WCF::getCache()->get('news-' . PACKAGE_ID); foreach ($news as $key => $newsItem) { if ($key != "hash") { UserSettings::setSetting($userID, $newsItem->getIdentifier(), TIME_NOW); } } return $accountEditor; }
<?php include_once "config.php"; $setting = new UserSettings(); $setting->setSetting("philinfo2", "value2"); ?>
/** * Sets the 'checked'-flag for the messages of a given user. * * @param int userID * @param int checked * @param array folderIDs */ public function checkAll($userID, $checked = 1, $folderIDs = null) { $sql = "UPDATE ugml_message\n\t\t\t\tSET checked = " . $checked . "\n\t\t\t\tWHERE recipentID = " . $userID; if ($folderIDs !== null && count($folderIDs)) { $sql .= " AND folderID IN (" . implode(',', $folderIDs) . ")"; } WCF::getDB()->sendQuery($sql); $sql = "SELECT COUNT(*) AS count\n\t\t\t\tFROM ugml_message\n\t\t\t\tWHERE checked = 1\n\t\t\t\t\tAND recipentID = " . $userID; $row = WCF::getDB()->getFirstRow($sql); UserSettings::setSetting($userID, 'checkedMessages', intval($row['count'])); }