public static Pet CreatePet(int UserId, string Name, int Type, string Race, string Color)
{
Pet Pet = new Pet(0, UserId, 0, Name, Type, Race, Color, 0, 100, 100, 0, ProjectHub.GetUnixTimestamp(), 0, 0, 0.0, 0, 0, 0, -1, "-1");
using (IQueryAdapter DbClient = ProjectHub.GetDatabaseManager().GetQueryReactor())
{
DbClient.SetQuery("INSERT INTO " + ProjectHub.DbPrefix + "bots (user_id,name, ai_type) VALUES (" + Pet.OwnerId + ",@" + Pet.PetId + "name, 'pet')");
DbClient.AddParameter(Pet.PetId + "name", Pet.Name);
Pet.PetId = Convert.ToInt32(DbClient.InsertQuery());
DbClient.SetQuery("INSERT INTO " + ProjectHub.DbPrefix + "bots_petdata (id,type,race,color,experience,energy,createstamp) VALUES (" + Pet.PetId + ", " + Pet.Type + ",@" + Pet.PetId + "race,@" + Pet.PetId + "color,0,100,UNIX_TIMESTAMP())");
DbClient.AddParameter(Pet.PetId + "race", Pet.Race);
DbClient.AddParameter(Pet.PetId + "color", Pet.Color);
DbClient.RunQuery();
}
return(Pet);
}
public double FormatTimestamp()
{
return(ProjectHub.GetUnixTimestamp() - 172800.0);
}
