public static function setConstant($key, $value = null) { if (!empty($key)) { GameConstantUtil::setCacheConstant($key, $value); $setting = GameConstants::findByExample(DBUtils::getConnection(), GameConstants::create()->setKey_($key)); if (!empty($setting)) { if (sizeof($setting) > 0) { $setting = $setting[0]; $k = $setting->getKey_(); if (empty($k)) { $setting = null; } } else { $setting = null; } } if (!empty($setting)) { $setting->setValue_($value); } else { $setting = GameConstants::create(); $setting->setKey_($key); $setting->setValue_($value); } $setting->updateInsertToDatabase(DBUtils::getConnection()); } return false; }
public static function getDailyBonusConstants() { try { $SQL = "SELECT * FROM " . TBL_GAME_CONSTANTS . " WHERE key_='" . BonusUtils::$CONSTANT_DAILYBONUS . "1' OR key_='" . BonusUtils::$CONSTANT_DAILYBONUS . "2' OR" . " key_='" . BonusUtils::$CONSTANT_DAILYBONUS . "3' OR key_='" . BonusUtils::$CONSTANT_DAILYBONUS . "4' OR key_='" . BonusUtils::$CONSTANT_DAILYBONUS . "5' OR" . " key_='" . BonusUtils::$CONSTANT_DAILYBONUS . "6' OR key_='" . BonusUtils::$CONSTANT_DAILYBONUS . "7' ORDER BY key_ ASC"; $dailyBonuses = GameConstants::findBySql(DBUtils::getConnection(), $SQL); $result = array(); for ($i = 1; $i < 8; $i++) { $dailybonus = new stdClass(); $dailybonus->order = $i; if (!empty($dailyBonuses) && sizeof($dailyBonuses) >= $i) { $tmp = $dailyBonuses[$i - 1]; if ($tmp != null) { $dailybonus->coin = $tmp->getValue_(); } } if (empty($dailybonus->coin)) { $dailybonus->coin = $i * 100; } array_push($result, $dailybonus); } return $result; } catch (Exception $exc) { var_dump($exc); error_log($exc->getTraceAsString()); } $result = array(); for ($i = 1; $i < 8; $i++) { $dailybonus = new stdClass(); $dailybonus->order = $i; $dailybonus->coin = $i * 100; array_push($result, $dailybonus); } return $result; }
/** * get single GameConstants instance from a DOMElement * * @param DOMElement $node * @return GameConstants */ public static function fromDOMElement(DOMElement $node) { $o = new GameConstants(); $o->assignByHash(self::domNodeToHash($node, self::$FIELD_NAMES, self::$DEFAULT_VALUES, self::$FIELD_TYPES)); $o->notifyPristine(); return $o; }