public bool PutItemIntoMarche(uint itemID, string itemName, string SteamID, string VendeurName, int Number, int prix, EItemType type, EItemRarity rarity)
{
try
{
MySqlConnection connection = CreateConnection();
MySqlCommand cmd = new MySqlCommand("INSERT INTO binaryshop.marchecomu (`ItemID`, `ItemName`, `SteamID`, `VendeurName`, `Number`, `Prix`, `Type`, `Rarity`) VALUES (@ItemID, @ItemName,@SteamID,@VendeurName,@Number,@Prix,@Type,@Rarity)", connection);
connection.Open();
if (connection.State == ConnectionState.Open)
{
cmd.Parameters.AddWithValue("@ItemID", itemID);
cmd.Parameters.AddWithValue("@ItemName", itemName);
cmd.Parameters.AddWithValue("@SteamID", SteamID);
cmd.Parameters.AddWithValue("@VendeurName", VendeurName);
cmd.Parameters.AddWithValue("@Number", Number);
cmd.Parameters.AddWithValue("@Prix", prix);
cmd.Parameters.AddWithValue("@Type", type.ToString());
cmd.Parameters.AddWithValue("@Rarity", rarity.ToString());
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Logger.Log(ex);
return(false);
}
}
public CItem CreateItem(EItemType itemType)
{
if (Enum.IsDefined(typeof(EItemType), itemType))
{
string itemClass = "Managers.CItem" + itemType.ToString();
CItem item = (CItem)System.Reflection.Assembly.GetAssembly(typeof(CItem)).CreateInstance(itemClass);
return(item);
}
return(null);
}
public override bool Submit(SEConnection connection)
{
MT.pHLab.SE.V1.SEParamRequest request = new MT.pHLab.SE.V1.SEParamRequest(GetRequestId());
var record = new MT.pHLab.SE.V1.Request_setupExportRecord();
record.m_itemGroup = m_eItemType.ToString();
record.m_itemName = "";
connection.Write(request.CreateTelegram(record));
return(true);
}
//---------------------------------------------------------------------------
public static Pickup Create(EItemType itemType, Vector3 location, Vector3 force)
{
Pickup pickup = Create(itemType.ToString(), location, force);
Sprite sprite = ItemManager.Get().Find(itemType).Sprite;
pickup.AddComponent <SpriteComponent>().Init(sprite, Vector2.Zero, Vector2.One * 2);
pickup.AddComponent <ShadowComponent>().Init(sprite, Vector2.One * 2, new Vector2(0, 3));
pickup.AddComponent <LightingComponent>().Init(sprite, Vector2.Zero, Vector2.One * 2, Color.White, 0.5f);
ParticleSpawnerComponent particleSpawner = pickup.AddComponent <ParticleSpawnerComponent>();
Color color = ItemManager.Get().GetColorByType(itemType);
ParticleDesc desc = ParticleDesc.Stars;
desc.ParticleColor = (time) => color;
desc.LightColor = (time) => color;
particleSpawner.Emitter = new CircleParticleEmitter(0, 30, desc)
{
Sprite = CollisionManager.Get().PointTexture,
Light = CollisionManager.Get().PointTexture,
SpawnRate = (time) => 20
};
pickup.AddComponent <LightingComponent>().Init(AssetManager.Get().Find <Texture2D>(ELightAssets.CircleLight), Vector2.Zero, Vector2.One * 0.5f, Color.White, 0.8f);
ItemPickupComponent pickupComponent = pickup.AddComponent <ItemPickupComponent>();
if (pickupComponent != null)
{
pickupComponent.Type = itemType;
pickup.GetComponent <CircleColliderComponent>().Enter += (source, target) =>
{
pickupComponent.OnPickup(target);
};
}
return(pickup);
}
public virtual void ShowThanks(EItemType targetType, bool haveBudget, bool haveItem)
{
NPCWrap dialKey = ResourcesManager.Instance.NPCs.objects.Find(e => e.ID == IDname);
if (dialKey != null)
{
ThanksText txts = DialoguesDatabase[dialKey.NPCText].thanks.Find(t => t.itemType == targetType.ToString());
if (txts != null)
{
if (haveBudget && haveItem)
{
PointingBubble.instance.PNJThanks(this, txts.fullThanks);
}
else if (haveBudget)
{
PointingBubble.instance.PNJThanks(this, txts.haveBudgetText);
}
else if (haveItem)
{
PointingBubble.instance.PNJThanks(this, txts.haveItemText);
}
}
}
}