private function commonInitiate()
{
$this->_config_channel = GameManager::getChannel($this->_data["uid"]);
$config_temp = new Zend_Config(array('database' => array('adapter' => $this->_config_channel->adapter, 'params' => $this->_config_channel->params)));
$db_channel = GameManager::getDbConnection($config_temp, $this->_config_channel->dbname);
$this->_db_channel = $db_channel;
$config_temp = new Zend_Config(array('database' => array('adapter' => 'pdo_mysql', 'params' => array('host' => $this->_config_channel->params->host, 'dbname' => "information_schema", 'username' => $this->_config_channel->params->username, 'password' => $this->_config_channel->params->password))));
$db_channel_schema = GameManager::getDbConnection($config_temp, $this->_config_channel->dbname . ".information_schema");
$this->_db_channel_schema = $db_channel_schema;
return $this;
}
public static function getUserByPlayerName($playername)
{
$config = Zend_Registry::get("config");
$sql = " select uid from player where playername = ? ";
$playerData = array();
//find user by name
for ($i = 1; $i <= $config->total_channel; $i++) {
$chkey = "channel{$i}";
$config_temp = new Zend_Config(array('database' => array('adapter' => 'pdo_mysql', 'params' => array('host' => $config->db->{$chkey}->params->host, 'dbname' => $config->db->{$chkey}->params->dbname, 'username' => $config->db->{$chkey}->params->username, 'password' => $config->db->{$chkey}->params->password))));
$db_channel = GameManager::getDbConnection($config_temp, $config->db->{$chkey}->params->dbname);
$playerData = $db_channel->fetchRow($sql, $playername);
if ($playerData) {
break;
}
}
if ($playerData) {
return self::getUserObject($playerData["uid"]);
} else {
return null;
}
}
