public static void AddClan(virtualUser User, string Name, string Description)
{
string[] GetCheck = DB.runReadRow("SELECT * FROM clans WHERE clanname='" + Name + "'");
if (GetCheck.Length == 0)
{
//if (User.Rank < 1)
//{
// User.send(new PACKET_CHAT("SYSTEM", PACKET_CHAT.ChatType.Whisper, "SYSTEM >> Cannot create the clan " + Name + " because is available only for donators!", User.SessionID, User.Nickname));
// return;
//}
if (User.ClanID == -1) // If user hasn't a clan
{
string ActualTime = DateTime.Now.ToString("yyyy.MM.dd");
if (Description != "")
{
DB.runQuery("INSERT INTO clans (clanjoindate, clanname, maxusers, win, lose, description, announcment, iconid) VALUES('" + ActualTime + "', '" + Name + "', '20', '0', '0', '" + Description + "', 'Insert here The Announcement!', '1001001')");
}
if (Description == "")
{
DB.runQuery("INSERT INTO clans (clanjoindate, clanname, maxusers, win, lose, description, announcment, iconid) VALUES('" + ActualTime + "', '" + Name + "', '20', '0', '0', 'Insert Here The Introduction!', 'Insert here The Announcement!', '1001001')");
}
int ClanID = getClanIDByName(Name);
virtualClan Clan = new virtualClan(ClanID, Name, 1001001, 20, 0, 0, 0); // Add the new clan for live update
Clans.Add(Clan); // Add it in the arraylist
User.ClanID = ClanID; // Set clan id to the master
User.ClanName = Name; // Set clan name to the maste
User.ClanRank = 2; // Set clan rank as master
User.ClanIconID = 1001001;
User.Clan = getClan(ClanID);
User.Dinar -= 10000;
/* Execute query for the database */
DB.runQuery("UPDATE users SET dinar='" + User.Dinar + "', clanid='" + ClanID + "', clanrank='2', clanjoindate='" + ActualTime + "' WHERE id='" + User.UserID + "'");
// Finaly result
User.send(new PACKET_CHAT("SYSTEM", PACKET_CHAT.ChatType.Whisper, "SYSTEM >> Successfully created the clan (" + Name + ")!", User.SessionID, User.Nickname));
User.send(new PACKET_CLAN(Name, ClanID));
}
else // else if user has already a clan
{
string Rank = (User.ClanRank == 2 ? "own" : "are in"); // Calculate if is a master or an normal clan member
User.send(new PACKET_CHAT("SYSTEM", PACKET_CHAT.ChatType.Whisper, "SYSTEM >> Cannot create the clan because you " + Rank + " a clan!", User.SessionID, User.Nickname));
}
}
else
{
User.send(new PACKET_CHAT("SYSTEM", PACKET_CHAT.ChatType.Whisper, "SYSTEM >> Cannot create the clan because this clan name is already in use!", User.SessionID, User.Nickname));
}
}
public static virtualClan getClan(int ID)
{
// Get clan by the ID
virtualClan TargetClan = null;
foreach (virtualClan Clan in Clans)
{
if (Clan.clanID == ID)
{
return(TargetClan = Clan); // If the clan exists return it
}
}
return(null); // If no clan is found return null
}
public static void Load() // Load all clans
{
Clans.Clear(); // Clear previous table
int[] clanID = DB.runReadColumn("SELECT id FROM clans", 0, null);
for (int I = 0; I < clanID.Length; I++)
{
// For each clan in the table add's it in the arraylist
string[] clanData = DB.runReadRow("SELECT clanname, maxusers, win, lose, exp, iconid FROM clans WHERE id=" + clanID[I].ToString());
virtualClan Clan = new virtualClan(clanID[I], clanData[0], long.Parse(clanData[5]), Convert.ToInt32(clanData[1]), Convert.ToInt32(clanData[2]), Convert.ToInt32(clanData[3]), Convert.ToInt32(clanData[4]));
Clans.Add(Clan);
int[] Users = DB.runReadColumn("SELECT * FROM users WHERE clanid='" + clanID[I].ToString() + "'", 0, null);
if (Users.Length <= 0)
{
DB.runQuery("DELETE FROM clans WHERE id='" + clanID[I].ToString() + "'");
DB.runQuery("UPDATE users SET clanid='-1', clanrank='1' WHERE clanid='" + clanID[I].ToString() + "'");
Clans.Remove(Clan);
}
}
// Finaly if we doesn't get error clans are loaded
//Log.AppendText("Loaded " + Clans.Count + " clans!");
}
public void addRoomInfo(virtualRoom Room)
{
//|4 1 1 0 Let's pl 0 16 1 12 3 2 0 0 4 1 0 1 0 0 0 1 0 66 0 -1
//18 1 1 0 ClanWar 0 16 1 12 3 2 0 0 4 1 0 1 1 0 0 1 0 54 0 99999999 20514 1001001 Montana -1 -1 ?
addBlock(Room.ID);
addBlock(Room.RoomStatus);
addBlock(Room.RoomStatus);
addBlock(Room.RoomMasterSlot);
addBlock(Room.Name);
addBlock(Room.EnablePassword);
addBlock(Room.MaxPlayers);
addBlock(Room.PlayerCount);
addBlock(Room.MapID);
if (Room.Channel == 3)
{
addBlock(Room.ZombieDifficulty);
}
else
{
addBlock(Room.Rounds);
}
addBlock(Room.Rounds);
addBlock(Room.TimeLimit);
addBlock(Room.Mode);
addBlock(4);
addBlock(Room.isJoinAble() ? 1 : 0); // 0 = unjoinable(grey room) // Once We are almost over
addBlock(0);
addBlock(Room.NewMode);
addBlock(Room.SubNewMode);
addBlock(Room.SuperMaster ? 1 : 0); // 1 = Room has Supermaster
addBlock(Room.RoomType);
addBlock(Room.LevelLimit);
addBlock(Room.PremiumOnly);
addBlock(Room.VoteKick);
addBlock(Room.AutoStart ? 1 : 0); // AutoStart
addBlock(0);
addBlock(Room.Ping);
if (Room.RoomType == 1)
{
virtualClan Clan1 = ClanManager.getClan(Room.getClanID(0));
virtualClan Clan2 = ClanManager.getClan(Room.getClanID(1));
addBlock(1);
if (Clan1 == null)
{
addBlock(-1);
addBlock(-1);
addBlock("?");
}
else
{
addBlock(Clan1.clanID);
addBlock(Clan1.clanIconID);
addBlock(Clan1.clanName);
}
if (Clan2 == null)
{
addBlock(-1);
addBlock(-1);
addBlock("?");
}
else
{
addBlock(Clan2.clanID);
addBlock(Clan2.clanIconID);
addBlock(Clan2.clanName);
}
}
else
{
addBlock(-1);
}
}
