internal static Pet CreatePet(uint UserId, string Name, int Type, string Race, string Color)
{
Pet pet = new Pet(404, UserId, 0, Name, (uint)Type, Race, Color, 0, 100, 100, 0, ButterflyEnvironment.GetUnixTimestamp(), 0, 0, 0.0);
pet.DBState = DatabaseUpdateState.NeedsUpdate;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
if (dbClient.dbType == Database_Manager.Database.DatabaseType.MSSQL)
dbClient.setQuery("INSERT INTO user_pets (user_id,name,type,race,color,expirience,energy,createstamp,nutrition,respect,x,y,z) OUTPUT INSERTED.* VALUES (" + pet.OwnerId + ",@" + pet.PetId + "name," + pet.Type + ",@" + pet.PetId + "race,@" + pet.PetId + "color,0,100,'" + pet.CreationStamp + "',0,0,0,0,0)");
else
dbClient.setQuery("INSERT INTO user_pets (user_id,name,type,race,color,expirience,energy,createstamp) VALUES (" + pet.OwnerId + ",@" + pet.PetId + "name," + pet.Type + ",@" + pet.PetId + "race,@" + pet.PetId + "color,0,100,'" + pet.CreationStamp + "')");
dbClient.addParameter(pet.PetId + "name", pet.Name);
dbClient.addParameter(pet.PetId + "race", pet.Race);
dbClient.addParameter(pet.PetId + "color", pet.Color);
pet.PetId = (uint)dbClient.insertQuery();
}
return pet;
}
internal void AddPet(Pet Pet)
{
isUpdated = false;
if (Pet == null || InventoryPets.ContainsKey(Pet.PetId))
return;
Pet.PlacedInRoom = false;
Pet.RoomId = 0;
InventoryPets.Add(Pet.PetId, Pet);
//using (DatabaseClient dbClient = ButterflyEnvironment.GetDatabase().GetClient())
//{
// dbClient.addParameter("botid", Pet.PetId);
// dbClient.runFastQuery("UPDATE user_pets SET room_id = 0, x = 0, y = 0, z = 0 WHERE id = @botid LIMIT 1");
//}
ServerMessage AddMessage = new ServerMessage(603);
Pet.SerializeInventory(AddMessage);
GetClient().SendMessage(AddMessage);
//UpdatePets(false);
}
internal void AddPet(Pet Pet)
{
isUpdated = false;
if (Pet == null || InventoryPets.ContainsKey(Pet.petID))
return;
Pet.isPlaced = false;
Pet.roomID = 0;
InventoryPets.Add(Pet.petID, Pet);
ServerMessage AddMessage = PacketHandelingManager.GetRecycledItem(OutputCode.AddPettoInventoryMessageComposer);
Pet.SerializeInventory(AddMessage);
AddMessage.AddInt32(5); // error status
AddMessage.AddInt32(1); // pick
GetClient().SendMessage(AddMessage);
}
internal RoomUser DeployBot(RoomBot Bot, Pet PetData)
{
RoomUser BotUser = new RoomUser(0, room.RoomId, primaryPrivateUserID++, room, false);
int PersonalID = secondaryPrivateUserID++;
BotUser.InternalRoomID = PersonalID;
//this.UserList[PersonalID] = BotUser;
userlist.Add(PersonalID, BotUser);
DynamicRoomModel Model = room.GetGameMap().Model;
if ((Bot.X > 0 && Bot.Y > 0) && Bot.X < Model.MapSizeX && Bot.Y < Model.MapSizeY)
{
BotUser.SetPos(Bot.X, Bot.Y, Bot.Z);
BotUser.SetRot(Bot.Rot, false);
}
else
{
Bot.X = Model.DoorX;
Bot.Y = Model.DoorY;
BotUser.SetPos(Model.DoorX, Model.DoorY, Model.DoorZ);
BotUser.SetRot(Model.DoorOrientation, false);
}
BotUser.BotData = Bot;
BotUser.BotAI = Bot.GenerateBotAI(BotUser.VirtualId);
if (BotUser.IsPet)
{
BotUser.BotAI.Init((int)Bot.BotId, BotUser.VirtualId, room.RoomId, BotUser, room);
BotUser.PetData = PetData;
BotUser.PetData.VirtualId = BotUser.VirtualId;
}
else
{
BotUser.BotAI.Init(-1, BotUser.VirtualId, room.RoomId, BotUser, room);
}
UpdateUserStatus(BotUser, false);
BotUser.UpdateNeeded = true;
ServerMessage EnterMessage = new ServerMessage(28);
EnterMessage.AppendInt32(1);
BotUser.Serialize(EnterMessage, room.GetGameMap().gotPublicPool);
room.SendMessage(EnterMessage);
BotUser.BotAI.OnSelfEnterRoom();
if (BotUser.BotData.AiType == AIType.Guide)
room.guideBotIsCalled = true;
if (BotUser.IsPet)
{
if (pets.ContainsKey(BotUser.PetData.PetId)) //Pet allready placed
pets[BotUser.PetData.PetId] = BotUser;
else
pets.Add(BotUser.PetData.PetId, BotUser);
petCount++;
}
return BotUser;
}
internal RoomUser DeployBot(RoomBot Bot, Pet PetData)
{
DynamicRoomModel Model = room.GetGameMap().Model;
RoomUser BotUser = new RoomUser(0, string.Empty, room.RoomId, primaryPrivateUserID++, room, false);
BotUser.InternalRoomID = ++secondaryPrivateUserID;
//this.UserList[PersonalID] = BotUser;
userlist.Add(BotUser.InternalRoomID, BotUser);
if ((Bot.X > 0 && Bot.Y > 0) && Bot.X < Model.MapSizeX && Bot.Y < Model.MapSizeY)
{
BotUser.SetPos(Bot.X, Bot.Y, Bot.Z);
BotUser.SetRot(Bot.Rot, false);
}
else
{
Bot.X = Model.DoorX;
Bot.Y = Model.DoorY;
BotUser.SetPos(Model.DoorX, Model.DoorY, Model.DoorZ);
BotUser.SetRot(Model.DoorOrientation, false);
}
BotUser.BotData = Bot;
BotUser.BotAI = Bot.GenerateBotAI(BotUser.VirtualId);
if (BotUser.IsPet)
{
BotUser.BotAI.Init((int)Bot.BotId, BotUser.VirtualId, room.RoomId, BotUser, room);
BotUser.PetData = PetData;
BotUser.PetData.virtualID = BotUser.VirtualId;
}
else
{
BotUser.BotAI.Init(Bot.ownerID > 0 ? (int)Bot.BotId : -1, BotUser.VirtualId, room.RoomId, BotUser, room);
}
UpdateUserStatus(BotUser, false);
BotUser.UpdateNeeded = true;
ServerMessage EnterMessage = PacketHandelingManager.GetRecycledItem(OutputCode.UsersMessageEvent);
EnterMessage.AddInt32(1);
BotUser.Serialize(EnterMessage);
room.SendMessage(EnterMessage);
BotUser.BotAI.OnSelfEnterRoom();
if (BotUser.IsPet)
{
if (pets.ContainsKey(BotUser.PetData.petID)) //Pet allready placed
pets[BotUser.PetData.petID] = BotUser;
else
pets.Add(BotUser.PetData.petID, BotUser);
petCount++;
}
return BotUser;
}
internal static Pet CreatePet(uint UserId, string Name, int Type, string Race, string Color)
{
Pet pet = new Pet(404, UserId, 0, Name, (uint)Type, Race, Color, 0, 100, 100, 0, ButterflyEnvironment.GetUnixTimestamp(), 0, 0, 0.0, 0, 0);
pet.databaseState = DatabaseUpdateState.PendingUpdate;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("INSERT INTO user_pets (user_id,name,type,race,color,expirience,energy,createstamp) VALUES (" + pet.ownerID + ",@" + pet.petID + "name," + pet.petType + ",@" + pet.petID + "race,@" + pet.petID + "color,0,100,'" + pet.creationStamp + "')");
dbClient.addParameter(pet.petID + "name", pet.name);
dbClient.addParameter(pet.petID + "race", pet.race);
dbClient.addParameter(pet.petID + "color", pet.color);
pet.petID = (uint)dbClient.insertQuery();
}
return pet;
}
