//-----------------------------------------------------------------------------------------------------
#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());
}
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());
}
