function ryzom_user_get_info($cid, $webprivs = false, $player_stats = false) { // User information global $_RYZOM_API_CONFIG; if (isset($_SESSION['dev_shard']) && $_SESSION['dev_shard']) { $db = new ServerDatabase(RYAPI_NELDB_HOST, RYAPI_NELDB_LOGIN, RYAPI_NELDB_PASS, RYAPI_NELDB_RING_DEV); } else { $db = new ServerDatabase(RYAPI_NELDB_HOST, RYAPI_NELDB_LOGIN, RYAPI_NELDB_PASS, RYAPI_NELDB_RING); } $sql = "SELECT char_name, race, civilisation, cult, guild_id, creation_date, last_played_date FROM characters WHERE char_id = {$cid}"; $result = $db->query($sql) or die('Could not query on ryzom_user_get_info'); $found = $db->num_rows($result) >= 1; if (!$found) { return array('char_name' => _t('guest'), 'cid' => $cid, 'ERROR' => 'unknown_user', 'groups' => array('GUEST')); } $row = $db->fetch_assoc($result); $db->free_result($result); if ($row) { $row['race'] = substr($row['race'], 2); $row['cult'] = substr($row['cult'], 2); $row['civ'] = substr($row['civilisation'], 2); if ($row['guild_id'] != '0') { $xml = @simplexml_load_file(ryzom_guild($row['guild_id'], false)); // $xml = false; if ($xml !== false) { $row['guild_icon'] = (string) $xml->icon; $row['guild_name'] = (string) $xml->name; $result = $xml->xpath("/guild/members/member[cid={$cid}]"); while (list(, $item) = each($result)) { $row['grade'] = (string) $item->grade; } } else { $row['guild_name'] = 'UNKNOWN_GUILD_' . $row['guild_id']; // Unknow name (normal in yubo shard) } } } $uid = intval($cid / 16); $db = new ServerDatabase(RYAPI_NELDB_HOST, RYAPI_NELDB_LOGIN, RYAPI_NELDB_PASS, RYAPI_NELDB_NEL); $sql = "SELECT Privilege FROM user WHERE UId = {$uid}"; $result = $db->query($sql) or die("Could not query."); $priv_row = $db->fetch_row($result, MYSQLI_NUM); $priv = $priv_row[0]; $db->free_result($result); $groups = array(); $row['uid'] = $uid; $row['cid'] = $cid; $row['slot'] = $cid % 16; if (strpos($priv, ':DEV:') !== false) { $groups[] = 'DEV'; $groups[] = 'SGM'; $groups[] = 'GM'; $groups[] = 'EM'; $groups[] = 'EG'; $groups[] = 'VG'; $groups[] = 'G'; } if (strpos($priv, ':SGM:') !== false) { $groups[] = 'SGM'; $groups[] = 'GM'; $groups[] = 'VG'; $groups[] = 'G'; } if (strpos($priv, ':GM:') !== false) { $groups[] = 'GM'; $groups[] = 'VG'; $groups[] = 'G'; } if (strpos($priv, ':VG:') !== false) { $groups[] = 'VG'; $groups[] = 'G'; } if (strpos($priv, ':G:') !== false) { $groups[] = 'G'; } if (strpos($priv, ':SEM:') !== false) { $groups[] = 'SEM'; $groups[] = 'EM'; $groups[] = 'EG'; } if (strpos($priv, ':EM:') !== false) { $groups[] = 'EM'; $groups[] = 'EG'; } if (strpos($priv, ':EG:') !== false) { $groups[] = 'EG'; } $groups[] = 'PLAYER'; if (isset($_SESSION['dev_shard']) && $_SESSION['dev_shard']) { $groups[] = 'DEV_SHARD'; } if ($webprivs) { $db = new ServerDatabase(RYAPI_WEBDB_HOST, RYAPI_WEBDB_LOGIN, RYAPI_WEBDB_PASS, 'webig'); $sql = 'SELECT web_privs FROM accounts WHERE uid = ' . intval($cid / 16); $result = $db->query($sql) or die("Could not query." . $db->get_error()); if ($result->num_rows == 0) { $db->query('INSERT INTO accounts (`uid`, `web_privs`) VALUES (' . intval($cid / 16) . ', \'\')') or die("Could not query." . $db->get_error()); } $priv_row = $db->fetch_row($result, MYSQLI_NUM); $privs = $priv_row[0]; $db->free_result($result); $groups = array_merge($groups, explode(':', $privs)); } if ($player_stats) { include_once RYAPI_PATH . 'server/player_stats.php'; $row['fames'] = ryzom_player_fames_array($cid); } $row['groups'] = $groups; return $row; }
static function updateDatabaseStruct($defs) { if (file_exists(RYAPP_PATH . 'database.versions')) { $versions = unserialize(file_get_contents(RYAPP_PATH . 'database.versions')); } else { $versions = array(); } $c = "Updating DB Structure...\n"; foreach ($defs as $dbname => $tables) { $db = new ServerDatabase(RYAPI_WEBDB_HOST, RYAPI_WEBDB_LOGIN, RYAPI_WEBDB_PASS, $dbname); $db->query("SET NAMES utf8"); $c .= "\n\tSelected DB '{$dbname}'\n"; foreach ($tables as $table => $sql) { $version = count($sql); if (array_key_exists($table, $versions)) { $diff = $version - $versions[$table]; } else { $versions[$table] = 0; $diff = $version; } $c .= "\t\tTable '{$table}' need v{$version} (current v" . strval($versions[$table] . ') => '); if ($diff > 0) { $sql_to_run = array_slice($sql, $versions[$table], $diff); foreach ($sql_to_run as $sql_run) { if ($sql_run) { $c .= "Run sql... "; $result = $db->query($sql_run); } else { $c .= "KO!!!"; } } if ($result) { $c .= "OK"; $versions[$table] = $version; } } else { $c .= "OK"; } $c .= "\n"; } $c .= "\n"; $db->close(); } file_put_contents(RYAPP_PATH . 'database.versions', serialize($versions)); return '<pre>' . $c . '<pre>'; }