//----------------------------------------------------------------------------------------------------- #endregion //----------------------------------------------------------------------------------------------------- //----------------------------------------------------------------------------------------------------- public void Login() { sep.Send("[" + (int)ServerOpcode.login_profile + "]"); SQLResult result = Program._SQL.Select("SELECT * FROM users WHERE id=?", user_id); if (result.Count != 0) { user_id = result.Read <int>(0, "id"); Name = result.Read <string>(0, "Name"); rank = result.Read <int>(0, "rank"); user_fb = result.Read <string>(0, "fbid"); gold = result.Read <int>(0, "gold"); cash = result.Read <int>(0, "cash"); gp = result.Read <int>(0, "gp"); gender = result.Read <string>(0, "gender"); user_key = result.Read <string>(0, "Key"); if (!(result.Read <int>(0, "foto") == 0)) { foto = Int64.Parse(user_fb); } guild = result.Read <int>(0, "guild"); if (guild > 0) { SQLResult resultxx = Program._SQL.Select("SELECT a.nombre, o.rango FROM guild a JOIN guild_members o ON a.id = o.id_guild AND o.id_user=?", user_id); guild_name = resultxx.Read <string>(0, "nombre"); guild_job = resultxx.Read <int>(0, "rango"); } } sep.Send("[" + (int)ServerOpcode.login_avatars + "]"); SQLResult result2 = Program._SQL.Select("SELECT a.avatar,i.genero,i.parte FROM user_items a JOIN items i ON a.avatar=i.id AND a.puesto=1 AND a.id_user=?", user_id); if (result2.Count != 0) { for (int p = 0; p < result2.Count; p++) { int _avatar = result2.Read <int>(p, "avatar"); string _parte = result2.Read <string>(p, "parte"); switch (_parte) { case "h": { head = _avatar; break; } case "e": { eyes = _avatar; break; } case "b": { body = _avatar; break; } case "f": { flag = _avatar; break; } case "1": { background = _avatar; break; } case "2": { foreground = _avatar; break; } } } } PlayerInfo(); }
public static void SendList(Serverb _serv) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); using (JsonWriter writer = new JsonTextWriter(sw)) { writer.Formatting = Formatting.None; writer.WriteStartArray(); writer.WriteValue((int)ServerOpcode.rooms_list); writer.WriteStartArray(); foreach (Chanel _cha in Program.Chanels) { writer.WriteStartArray(); writer.WriteValue(_cha._chanel_id); writer.WriteValue(_cha._chanel_name); writer.WriteValue(_cha._chanel_useronli); writer.WriteValue(_cha._chanel_maxplayers); writer.WriteValue(_cha._chanel_status); writer.WriteValue(_cha._chanel_gamemode); writer.WriteValue(_cha._chanel_look); writer.WriteValue(_cha._chanel_map); writer.WriteValue(_cha._chanel_poweruse); writer.WriteEndArray(); } writer.WriteEndArray(); writer.WriteValue(0); writer.WriteValue(0); writer.WriteEndArray(); } _serv.Send(sb.ToString()); }