Fail when picking up pets

[bilbodog1203]

Hello.

I have been working on some bugs on my hotel client, but now there is one more I can't explain or find any information about. I'm not the best person to articulate in english, so maybe it's just bad search words.

The problem is, when I buy pets and then place them in my room and pick it up again, it wont show it in the Pets table. I'm using R63B with PlusEMU from *****.com

I hope someone have the same problem, know how to solve this and would like to help me with it!

Best Regards,
Bilbodog & Seeker

 

[Zaka]

Hello.

I have been working on some bugs on my hotel client, but now there is one more I can't explain or find any information about. I'm not the best person to articulate in english, so maybe it's just bad search words.

The problem is, when I buy pets and then place them in my room and pick it up again, it wont show it in the Pets table. I'm using R63B with PlusEMU from *****.com

I hope someone have the same problem, know how to solve this and would like to help me with it!

Best Regards,
Bilbodog & Seeker

This could simply be that there is no database query for that function, you could just add one. Or the inventory is not reloading when you do. I think that PlusEMU saves some information locally until you actually logout, and then post that information to the database. I'm unsure tho.

 

[Velaski]

Emulator\Communication\Packets\Incoming\Rooms\AI\Pets
PickUpPetEvent.cs

using System;
using System.Linq;
using System.Text;
using System.Collections.Generic;

using Plus.HabboHotel.Rooms.AI;
using Plus.HabboHotel.Rooms;
using Plus.Communication.Packets.Outgoing.Inventory.Pets;

using System.Drawing;
using Plus.HabboHotel.GameClients;
using Plus.Communication.Packets.Outgoing.Rooms.Engine;
using Plus.Database.Interfaces;

namespace Plus.Communication.Packets.Incoming.Rooms.AI.Pets
{
    class PickUpPetEvent : IPacketEvent
    {
        public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
        {
            if (!Session.GetHabbo().InRoom)
                return;

            if (Session == null || Session.GetHabbo() == null || Session.GetHabbo().GetInventoryComponent() == null)
                return;

            Room Room;

            if (!PlusEnvironment.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
                return;

            int PetId = Packet.PopInt();

            RoomUser Pet = null;
            if (!Room.GetRoomUserManager().TryGetPet(PetId, out Pet))
            {
                //Check kick rights, just because it seems most appropriate.
                if ((!Room.CheckRights(Session) && Room.WhoCanKick != 2 && Room.Group == null) || (Room.Group != null && !Room.CheckRights(Session, false, true)))
                    return;

                //Okay so, we've established we have no pets in this room by this virtual Id, let us check out users, maybe they're creeping as a pet?!
                RoomUser TargetUser = Session.GetHabbo().CurrentRoom.GetRoomUserManager().GetRoomUserByHabbo(PetId);
                if (TargetUser == null)
                    return;

                //Check some values first, please!
                if (TargetUser.GetClient() == null || TargetUser.GetClient().GetHabbo() == null)
                    return;

                //Update the targets PetId.
                TargetUser.GetClient().GetHabbo().PetId = 0;

                //Quickly remove the old user instance.
                Room.SendMessage(new UserRemoveComposer(TargetUser.VirtualId));

                //Add the new one, they won't even notice a thing!!11 8-)
                Room.SendMessage(new UsersComposer(TargetUser));
                return;
            }

            if (Session.GetHabbo().Id != Pet.PetData.OwnerId && !Room.CheckRights(Session, true, false))
            {
                Session.SendWhisper("You can only pickup your own pets, to kick a pet you must have room rights.");
                return;
            }

            //Only if user is riding horse duuuh
            if (Pet.RidingHorse)
            {
                RoomUser UserRiding = Room.GetRoomUserManager().GetRoomUserByVirtualId(Pet.HorseID);
                if (UserRiding != null)
                {
                    //Set user is not longer riding a horse
                    UserRiding.RidingHorse = false;
                    //Set user effect to normal
                    UserRiding.ApplyEffect(-1);
                    UserRiding.MoveTo(new Point(UserRiding.X + 1, UserRiding.Y + 1));
                }
                else
                    Pet.RidingHorse = false;
            }

            Pet.PetData.RoomId = 0;
            Pet.PetData.PlacedInRoom = false;

            Pet pet = Pet.PetData;
            if (pet != null)
            {
                using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
                {
                    dbClient.RunQuery("UPDATE `bots` SET `room_id` = '0', `x` = '0', `Y` = '0', `Z` = '0' WHERE `id` = '" + pet.PetId + "' LIMIT 1");
                    dbClient.RunQuery("UPDATE `bots_petdata` SET `experience` = '" + pet.experience + "', `energy` = '" + pet.Energy + "', `nutrition` = '" + pet.Nutrition + "', `respect` = '" + pet.Respect + "' WHERE `id` = '" + pet.PetId + "' LIMIT 1");
                }

                Session.GetHabbo().GetInventoryComponent().TryAddPet(Pet.PetData);
                Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
            }

            if (pet.OwnerId != Session.GetHabbo().Id)
            {
                GameClient Target = PlusEnvironment.GetGame().GetClientManager().GetClientByUserID(pet.OwnerId);
                if (Target != null)
                {
                    Target.GetHabbo().GetInventoryComponent().TryAddPet(Pet.PetData);
                    Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
                    Room.GetRoomUserManager().RemoveBot(Pet.VirtualId, false);

                    Target.SendMessage(new PetInventoryComposer(Target.GetHabbo().GetInventoryComponent().GetPets()));
                    return;
                }
            }

            Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
            Room.GetRoomUserManager().RemoveBot(Pet.VirtualId, false);
        }
    }
}

 

[Zaka]

Emulator\Communication\Packets\Incoming\Rooms\AI\Pets
PickUpPetEvent.cs

using System;
using System.Linq;
using System.Text;
using System.Collections.Generic;

using Plus.HabboHotel.Rooms.AI;
using Plus.HabboHotel.Rooms;
using Plus.Communication.Packets.Outgoing.Inventory.Pets;

using System.Drawing;
using Plus.HabboHotel.GameClients;
using Plus.Communication.Packets.Outgoing.Rooms.Engine;
using Plus.Database.Interfaces;

namespace Plus.Communication.Packets.Incoming.Rooms.AI.Pets
{
    class PickUpPetEvent : IPacketEvent
    {
        public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
        {
            if (!Session.GetHabbo().InRoom)
                return;

            if (Session == null || Session.GetHabbo() == null || Session.GetHabbo().GetInventoryComponent() == null)
                return;

            Room Room;

            if (!PlusEnvironment.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
                return;

            int PetId = Packet.PopInt();

            RoomUser Pet = null;
            if (!Room.GetRoomUserManager().TryGetPet(PetId, out Pet))
            {
                //Check kick rights, just because it seems most appropriate.
                if ((!Room.CheckRights(Session) && Room.WhoCanKick != 2 && Room.Group == null) || (Room.Group != null && !Room.CheckRights(Session, false, true)))
                    return;

                //Okay so, we've established we have no pets in this room by this virtual Id, let us check out users, maybe they're creeping as a pet?!
                RoomUser TargetUser = Session.GetHabbo().CurrentRoom.GetRoomUserManager().GetRoomUserByHabbo(PetId);
                if (TargetUser == null)
                    return;

                //Check some values first, please!
                if (TargetUser.GetClient() == null || TargetUser.GetClient().GetHabbo() == null)
                    return;

                //Update the targets PetId.
                TargetUser.GetClient().GetHabbo().PetId = 0;

                //Quickly remove the old user instance.
                Room.SendMessage(new UserRemoveComposer(TargetUser.VirtualId));

                //Add the new one, they won't even notice a thing!!11 8-)
                Room.SendMessage(new UsersComposer(TargetUser));
                return;
            }

            if (Session.GetHabbo().Id != Pet.PetData.OwnerId && !Room.CheckRights(Session, true, false))
            {
                Session.SendWhisper("You can only pickup your own pets, to kick a pet you must have room rights.");
                return;
            }

            //Only if user is riding horse duuuh
            if (Pet.RidingHorse)
            {
                RoomUser UserRiding = Room.GetRoomUserManager().GetRoomUserByVirtualId(Pet.HorseID);
                if (UserRiding != null)
                {
                    //Set user is not longer riding a horse
                    UserRiding.RidingHorse = false;
                    //Set user effect to normal
                    UserRiding.ApplyEffect(-1);
                    UserRiding.MoveTo(new Point(UserRiding.X + 1, UserRiding.Y + 1));
                }
                else
                    Pet.RidingHorse = false;
            }

            Pet.PetData.RoomId = 0;
            Pet.PetData.PlacedInRoom = false;

            Pet pet = Pet.PetData;
            if (pet != null)
            {
                using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
                {
                    dbClient.RunQuery("UPDATE `bots` SET `room_id` = '0', `x` = '0', `Y` = '0', `Z` = '0' WHERE `id` = '" + pet.PetId + "' LIMIT 1");
                    dbClient.RunQuery("UPDATE `bots_petdata` SET `experience` = '" + pet.experience + "', `energy` = '" + pet.Energy + "', `nutrition` = '" + pet.Nutrition + "', `respect` = '" + pet.Respect + "' WHERE `id` = '" + pet.PetId + "' LIMIT 1");
                }

                Session.GetHabbo().GetInventoryComponent().TryAddPet(Pet.PetData);
                Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
            }

            if (pet.OwnerId != Session.GetHabbo().Id)
            {
                GameClient Target = PlusEnvironment.GetGame().GetClientManager().GetClientByUserID(pet.OwnerId);
                if (Target != null)
                {
                    Target.GetHabbo().GetInventoryComponent().TryAddPet(Pet.PetData);
                    Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
                    Room.GetRoomUserManager().RemoveBot(Pet.VirtualId, false);

                    Target.SendMessage(new PetInventoryComposer(Target.GetHabbo().GetInventoryComponent().GetPets()));
                    return;
                }
            }

            Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
            Room.GetRoomUserManager().RemoveBot(Pet.VirtualId, false);
        }
    }
}

Can't see a query for actually storing the pet data into the database, I don't know if they count bots_petdata as the pets?

 

[DaveMustaine]

Can you check the mysql error log and look for a query error with 'bots' or 'bots_petdata' there? I remember fix something similar some time ago

 

[bilbodog1203]

Emulator\Communication\Packets\Incoming\Rooms\AI\Pets
PickUpPetEvent.cs

using System;
using System.Linq;
using System.Text;
using System.Collections.Generic;

using Plus.HabboHotel.Rooms.AI;
using Plus.HabboHotel.Rooms;
using Plus.Communication.Packets.Outgoing.Inventory.Pets;

using System.Drawing;
using Plus.HabboHotel.GameClients;
using Plus.Communication.Packets.Outgoing.Rooms.Engine;
using Plus.Database.Interfaces;

namespace Plus.Communication.Packets.Incoming.Rooms.AI.Pets
{
    class PickUpPetEvent : IPacketEvent
    {
        public void Parse(HabboHotel.GameClients.GameClient Session, ClientPacket Packet)
        {
            if (!Session.GetHabbo().InRoom)
                return;

            if (Session == null || Session.GetHabbo() == null || Session.GetHabbo().GetInventoryComponent() == null)
                return;

            Room Room;

            if (!PlusEnvironment.GetGame().GetRoomManager().TryGetRoom(Session.GetHabbo().CurrentRoomId, out Room))
                return;

            int PetId = Packet.PopInt();

            RoomUser Pet = null;
            if (!Room.GetRoomUserManager().TryGetPet(PetId, out Pet))
            {
                //Check kick rights, just because it seems most appropriate.
                if ((!Room.CheckRights(Session) && Room.WhoCanKick != 2 && Room.Group == null) || (Room.Group != null && !Room.CheckRights(Session, false, true)))
                    return;

                //Okay so, we've established we have no pets in this room by this virtual Id, let us check out users, maybe they're creeping as a pet?!
                RoomUser TargetUser = Session.GetHabbo().CurrentRoom.GetRoomUserManager().GetRoomUserByHabbo(PetId);
                if (TargetUser == null)
                    return;

                //Check some values first, please!
                if (TargetUser.GetClient() == null || TargetUser.GetClient().GetHabbo() == null)
                    return;

                //Update the targets PetId.
                TargetUser.GetClient().GetHabbo().PetId = 0;

                //Quickly remove the old user instance.
                Room.SendMessage(new UserRemoveComposer(TargetUser.VirtualId));

                //Add the new one, they won't even notice a thing!!11 8-)
                Room.SendMessage(new UsersComposer(TargetUser));
                return;
            }

            if (Session.GetHabbo().Id != Pet.PetData.OwnerId && !Room.CheckRights(Session, true, false))
            {
                Session.SendWhisper("You can only pickup your own pets, to kick a pet you must have room rights.");
                return;
            }

            //Only if user is riding horse duuuh
            if (Pet.RidingHorse)
            {
                RoomUser UserRiding = Room.GetRoomUserManager().GetRoomUserByVirtualId(Pet.HorseID);
                if (UserRiding != null)
                {
                    //Set user is not longer riding a horse
                    UserRiding.RidingHorse = false;
                    //Set user effect to normal
                    UserRiding.ApplyEffect(-1);
                    UserRiding.MoveTo(new Point(UserRiding.X + 1, UserRiding.Y + 1));
                }
                else
                    Pet.RidingHorse = false;
            }

            Pet.PetData.RoomId = 0;
            Pet.PetData.PlacedInRoom = false;

            Pet pet = Pet.PetData;
            if (pet != null)
            {
                using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
                {
                    dbClient.RunQuery("UPDATE `bots` SET `room_id` = '0', `x` = '0', `Y` = '0', `Z` = '0' WHERE `id` = '" + pet.PetId + "' LIMIT 1");
                    dbClient.RunQuery("UPDATE `bots_petdata` SET `experience` = '" + pet.experience + "', `energy` = '" + pet.Energy + "', `nutrition` = '" + pet.Nutrition + "', `respect` = '" + pet.Respect + "' WHERE `id` = '" + pet.PetId + "' LIMIT 1");
                }

                Session.GetHabbo().GetInventoryComponent().TryAddPet(Pet.PetData);
                Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
            }

            if (pet.OwnerId != Session.GetHabbo().Id)
            {
                GameClient Target = PlusEnvironment.GetGame().GetClientManager().GetClientByUserID(pet.OwnerId);
                if (Target != null)
                {
                    Target.GetHabbo().GetInventoryComponent().TryAddPet(Pet.PetData);
                    Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
                    Room.GetRoomUserManager().RemoveBot(Pet.VirtualId, false);

                    Target.SendMessage(new PetInventoryComposer(Target.GetHabbo().GetInventoryComponent().GetPets()));
                    return;
                }
            }

            Session.SendMessage(new PetInventoryComposer(Session.GetHabbo().GetInventoryComponent().GetPets()));
            Room.GetRoomUserManager().RemoveBot(Pet.VirtualId, false);
        }
    }
}

This ain't working.. Still the same problem. :

 

Can you check the mysql error log and look for a query error with 'bots' or 'bots_petdata' there? I remember fix something similar some time ago

There is nothing about the bot, bots_petdata or similar in the MySQL Error Log
 

Error in query:
SELECT * FROM `catalog_pet_races`
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'habbodbtest.catalog_pet_races' doesn't exist
ved MySql.Data.MySqlClient.MySqlStream.ReadPacket()
ved MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
ved MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
ved MySql.Data.MySqlClient.MySqlDataReader.NextResult()
ved MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
ved System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
ved System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
ved System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
ved Plus.Database.Adapter.QueryAdapter.getTable() i C:\Users\Sledmore\Desktop\PRODUCTION-201601012205-226667486\Database\Adapter\QueryAdapter.cs:linje 121

I found this?..

 

[angleiito]

Spoiler: catalog_pet_races

DROP TABLE IF EXISTS `catalog_pet_races`;

CREATE TABLE `catalog_pet_races` (
`raceid` int(255) DEFAULT NULL,
`color1` int(255) DEFAULT NULL,
`color2` int(255) DEFAULT NULL,
`has1color` enum('1','0') DEFAULT NULL,
`has2color` enum('1','0') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `catalog_pet_races` */

insert into `catalog_pet_races`(`raceid`,`color1`,`color2`,`has1color`,`has2color`) values (12,0,0,'1','0'),(12,1,1,'1','0'),(12,2,2,'1','0'),(12,3,3,'1','0'),(12,4,4,'1','0'),(12,5,5,'1','0'),(17,0,0,'1','0'),(18,0,0,'1','0'),(19,0,0,'1','0'),(20,0,0,'1','0'),(21,0,0,'1','0'),(22,0,0,'1','0'),(0,0,0,'1','0'),(0,1,1,'1','0'),(0,2,2,'1','0'),(0,3,3,'1','0'),(0,4,4,'1','0'),(0,5,5,'1','0'),(0,6,6,'1','0'),(0,7,7,'1','0'),(0,8,8,'1','0'),(0,9,9,'1','0'),(0,10,10,'1','0'),(0,11,11,'1','0'),(0,12,12,'1','0'),(0,13,13,'1','0'),(0,14,14,'1','0'),(0,15,15,'1','0'),(0,16,16,'1','0'),(0,17,17,'1','0'),(0,18,18,'1','0'),(0,19,19,'1','0'),(0,20,20,'1','0'),(0,21,21,'1','0'),(0,22,22,'1','0'),(0,23,23,'1','0'),(0,24,24,'1','0'),(1,0,0,'1','0'),(1,1,1,'1','0'),(1,2,2,'1','0'),(1,3,3,'1','0'),(1,4,4,'1','0'),(1,5,5,'1','0'),(1,6,6,'1','0'),(1,7,7,'1','0'),(1,8,8,'1','0'),(1,9,9,'1','0'),(1,10,10,'1','0'),(1,11,11,'1','0'),(1,12,12,'1','0'),(1,13,13,'1','0'),(1,14,14,'1','0'),(1,15,15,'1','0'),(1,16,16,'1','0'),(1,17,17,'1','0'),(1,18,18,'1','0'),(1,19,19,'1','0'),(1,20,20,'1','0'),(1,21,21,'1','0'),(1,22,22,'1','0'),(1,23,23,'1','0'),(1,24,24,'1','0'),(10,0,0,'1','0'),(9,0,0,'1','0'),(9,1,1,'1','0'),(9,2,2,'1','0'),(9,3,3,'1','0'),(9,4,4,'1','0'),(9,5,5,'1','0'),(9,6,6,'1','0'),(9,7,7,'1','0'),(9,8,8,'1','0'),(11,1,1,'1','0'),(11,2,2,'1','0'),(11,3,3,'1','0'),(11,4,4,'1','0'),(11,5,5,'1','0'),(11,6,6,'1','0'),(11,8,8,'0','0'),(11,9,9,'1','0'),(11,10,10,'1','0'),(11,11,11,'1','0'),(11,12,12,'1','0'),(11,13,13,'1','0'),(11,15,15,'1','0'),(11,18,18,'1','0'),(8,0,0,'1','0'),(8,1,1,'1','0'),(8,2,2,'1','0'),(8,3,3,'1','0'),(8,4,4,'1','0'),(8,5,5,'1','0'),(8,6,6,'1','0'),(8,7,7,'1','0'),(8,8,8,'1','0'),(8,9,9,'1','0'),(8,10,10,'1','0'),(8,11,11,'1','0'),(8,14,14,'1','0'),(7,0,0,'1','0'),(7,1,1,'1','0'),(7,2,2,'1','0'),(7,3,3,'0','1'),(7,4,4,'1','0'),(7,5,5,'1','0'),(7,6,6,'1','0'),(7,7,7,'1','0'),(7,0,0,'1','0'),(7,1,1,'1','0'),(7,2,2,'1','0'),(7,3,3,'0','1'),(7,4,4,'1','0'),(7,5,5,'1','0'),(7,6,6,'1','0'),(7,7,7,'1','0'),(5,0,0,'1','0'),(5,1,1,'1','0'),(5,2,2,'1','0'),(5,3,3,'1','0'),(5,5,5,'1','0'),(5,7,7,'1','0'),(5,8,8,'1','0'),(3,0,0,'1','0'),(3,1,1,'1','0'),(3,2,2,'1','0'),(3,3,3,'1','0'),(3,4,4,'1','0'),(3,5,5,'1','0'),(3,6,6,'1','0'),(4,0,0,'1','0'),(4,1,1,'1','0'),(4,2,2,'1','0'),(4,3,3,'1','0'),(2,0,0,'1','0'),(2,1,1,'1','0'),(2,2,2,'1','0'),(2,3,3,'1','0'),(2,4,4,'1','0'),(2,5,5,'1','0'),(2,6,6,'1','0'),(2,7,7,'1','0'),(2,8,8,'1','0'),(2,9,9,'1','0'),(2,10,10,'1','0'),(2,11,11,'1','0'),(6,0,0,'1','0'),(6,1,1,'1','0'),(6,2,2,'1','0'),(6,3,3,'1','0'),(6,4,4,'1','0'),(6,5,5,'1','0'),(6,6,6,'0','1'),(6,7,7,'0','1'),(6,8,8,'0','1'),(6,9,9,'0','1'),(6,10,10,'0','1'),(6,11,11,'1','0'),(6,12,12,'0','1'),(15,1,2,'1','0'),(15,2,3,'1','0'),(15,3,4,'1','0'),(15,4,5,'1','0'),(15,1,6,'1','1'),(15,2,7,'1','1'),(15,3,8,'1','1'),(15,4,9,'1','1'),(15,1,10,'1','1'),(15,2,11,'1','1'),(15,3,12,'1','1'),(15,4,13,'1','1'),(15,1,14,'1','1'),(15,2,15,'1','1'),(15,3,16,'1','1'),(15,4,17,'1','1'),(15,1,18,'0','1'),(15,2,19,'0','1'),(15,3,20,'0','1'),(15,4,21,'0','1'),(15,1,22,'0','1'),(15,2,23,'0','1'),(15,3,24,'0','1'),(15,4,25,'0','1'),(15,1,26,'0','1'),(15,2,27,'0','1'),(15,3,28,'0','1'),(15,4,29,'0','1'),(15,1,30,'0','1'),(15,2,31,'0','1'),(15,3,32,'0','1'),(15,4,33,'0','1'),(15,1,34,'0','1'),(15,2,35,'0','1'),(15,3,36,'0','1'),(15,4,37,'0','1'),(15,1,38,'0','1'),(15,2,39,'0','1'),(15,3,40,'0','1'),(15,4,41,'0','1'),(15,1,46,'0','1'),(15,2,43,'0','1'),(15,3,44,'0','1'),(15,4,45,'0','1'),(15,1,42,'0','1'),(15,2,78,'1','0'),(15,3,48,'0','1'),(15,4,49,'0','1'),(15,1,77,'1','0'),(15,2,47,'0','1'),(15,3,79,'1','0'),(15,4,80,'1','0'),(14,0,0,'1','0'),(14,1,1,'1','1'),(14,2,2,'1','0'),(14,3,3,'1','0'),(14,4,4,'1','0'),(14,5,5,'1','0'),(14,6,6,'1','0'),(14,7,7,'1','0'),(14,8,8,'1','0'),(14,9,9,'1','0'),(14,9,9,'1','0'),(14,10,10,'1','0'),(14,11,11,'1','0'),(14,12,12,'1','0'),(14,13,13,'1','0'),(29,1,1,'1','0'),(29,2,2,'1','0'),(29,3,3,'1','0'),(29,4,4,'1','0'),(29,5,5,'1','0'),(29,6,6,'1','0'),(29,7,7,'1','0'),(29,8,8,'1','0'),(29,9,9,'1','0'),(29,10,10,'1','0'),(28,1,1,'1','0'),(28,2,2,'1','0'),(28,3,3,'1','0'),(28,4,4,'1','0'),(28,5,5,'1','0'),(28,6,6,'1','0'),(28,7,7,'1','0'),(28,8,8,'1','0'),(28,9,9,'1','0'),(28,10,10,'1','0'),(30,1,1,'1','0'),(30,2,2,'1','0'),(30,3,3,'1','0'),(30,4,4,'1','0'),(30,5,5,'1','0'),(30,6,6,'1','0'),(30,7,7,'1','0'),(30,8,8,'1','0'),(30,9,9,'1','0'),(30,10,10,'1','0');