public void CreateChildrenNodes(List <Item.ItemType> _availableTypes, ItemsDatabase _itemsDatabase)
{
int randomTypeIndex = Random.Range(0, _availableTypes.Count);
Item.ItemType childrenItemType = _availableTypes[randomTypeIndex];
_availableTypes.RemoveAt(randomTypeIndex);
List <Item> items = _itemsDatabase.GetItems(childrenItemType);
int itemIndex = Random.Range(0, items.Count - 1);
int item0 = 0;
int item1 = 0;
int randomNodeIndex = Random.Range(0, 2);
if (randomNodeIndex == 0)
{
item0 = itemIndex;
item1 = itemIndex + 1;
}
else
{
item0 = itemIndex + 1;
item1 = itemIndex;
}
m_node1 = new Node(childrenItemType, items[item0], true, m_depth + 1, _availableTypes, _itemsDatabase);
m_node2 = new Node(childrenItemType, items[item1], false, m_depth + 1, _availableTypes, _itemsDatabase);
}
private static void InitDb(uint serverId)
{
var server = BasicTeraData.Instance.Servers.GetServer(serverId);
Region = server.Region;
var td = new TeraData(Region);
var lang = td.GetLanguage(Region);
//if (TimeManager.Instance.CurrentRegion != Region)
//{
TimeManager.Instance.SetServerTimeZone(lang);
SettingsManager.LastRegion = lang;
//}
TimeManager.Instance.SetGuildBamTime(false);
EntitiesManager.CurrentDatabase = new MonsterDatabase(lang);
ItemsDatabase.Reload(lang);
AbnormalityManager.CurrentDb = new AbnormalityDatabase(lang);
SocialDatabase.Load();
SystemMessages.Load();
GuildQuestDatabase.Load();
AccountBenefitDatabase.Load();
AchievementDatabase.Load();
AchievementGradeDatabase.Load();
MapDatabase.Load();
QuestDatabase.Load();
}
public static void CreateItemsDatabase()
{
ItemsDatabase newDatabase = ScriptableObject.CreateInstance <ItemsDatabase>();
AssetDatabase.CreateAsset(newDatabase, "Assets/ItemsDatabase.asset");
AssetDatabase.Refresh();
}
private void ClothEquip()
{
if (PlayerPrefs.GetString("Hat") != null)
{
Debug.Log("fdsf");
Hat[] hats = ItemsDatabase.Get().Hats().ToArray();
foreach (Hat hat in hats)
{
if (hat.GetName() == PlayerPrefs.GetString("Hat"))
{
GameObject spawnHat = Instantiate(hat.GetObject());
spawnHat.transform.parent = head.transform;
spawnHat.transform.localScale = hat.GetAttachedScale();
spawnHat.transform.localPosition = hat.GetAttachedPosition();
}
}
}
if (PlayerPrefs.GetString("Body") != null)
{
Body[] bodyes = ItemsDatabase.Get().Bodies().ToArray();
foreach (Body body in bodyes)
{
if (body.GetName() == PlayerPrefs.GetString("Body"))
{
GameObject spawnBody = Instantiate(body.GetObject());
spawnBody.transform.parent = bodyArmor.transform;
spawnBody.transform.localScale = body.GetAttachedScale();
spawnBody.transform.localPosition = body.GetAttachedPosition();
}
}
}
}
public void displayCells()
{
serialText.Text = lol.ItemID;
imeText.Text = lol.ItemName;
cenaText.Text = lol.Price.ToString();
List <string> row = new List <string>();
ItemsDatabase db = new ItemsDatabase();
if (lol.type == "Software")
{
SoftwareItem i = db.ReadSoftware(_code);
row.Add(i.LicenseKey);
row.Add(i.SizeInMB.ToString());
row.Add(i.version);
}
else if (lol.type == "Computer")
{
Computer c = db.ReadComputer(_code);
row.Add(c.NoOfCores.ToString());
row.Add(c.AmountOfRam.ToString());
row.Add(c.HDDSize.ToString());
row.Add(c.weight.ToString());
}
else if (lol.type == "Monitor")
{
Monitor m = db.ReadMonitor(_code);
row.Add(m.weight.ToString());
row.Add(m.Resolution);
row.Add(m.diag);
row.Add(m.MonitorType);
}
dataGridView1.Rows.Add(row.ToArray());
}
/// <summary>
/// Connects to the database and sets up the loaded items from the collection or vice versa.
/// </summary>
public void ConnectToDatabase()
{
ReadFromDatabase = false;
Client = GetMongoClient();
ItemsDatabase = Client.GetDatabase(DatabaseName);
IMongoCollection <T> itemsRead = ItemsDatabase.GetCollection <T>(CollectionName);
long totalCount = itemsRead.Count(Filter);
if (totalCount == 0 && LoadedItems.Count != 0)
{
AddLoadedItemsToBlankDatabase(itemsRead);
}
else if (LoadedItems.Count != 0 && LoadedItems.Count > totalCount)
{
AddNewItemsToExistingDatabase(itemsRead);
}
else if (totalCount != 0 && LoadedItems.Count <= totalCount)
{
LoadAllItemsFromDatabase(itemsRead);
ReadFromDatabase = true;
}
else if (totalCount != 0 && totalCount < LoadedItems.Count)
{
UpdateDatabaseItems(itemsRead);
ReadFromDatabase = true;
}
}
public void showIzdelki()
{
ItemsDatabase db = new ItemsDatabase();
List <Item> items = db.ReadItems();
izdelki_panel.Controls.Clear();
int i = 0;
foreach (Item izdelek in items)
{
SplitContainer splt = new SplitContainer();
splt.Size = new Size(772, 30);
Label lb = new Label();
lb.Text = izdelek.ItemName;
splt.Panel1.Controls.Add(lb);
splt.FixedPanel = System.Windows.Forms.FixedPanel.Panel1;
splt.FixedPanel = System.Windows.Forms.FixedPanel.Panel2;
Button btn = new Button();
btn.Text = "Uredi";
btn.Name = izdelek.ItemID;
btn.Click += editWindowOpen;
splt.Panel2.Controls.Add(btn);
splt.IsSplitterFixed = true;
splt.BackColor = i % 2 == 0 ? Color.White : Color.LightGray;
izdelki_panel.Controls.Add(splt);
i++;
}
}
public void RefreshTable()
{
ItemsDatabase db = new ItemsDatabase();
List <Item> items = db.ReadItems();
dataGridView1.Columns.Clear();
dataGridView1.Rows.Clear();
dataGridView1.Columns.Add("columnid", "ItemCode");
dataGridView1.Columns.Add("columnName", "ItemIme");
dataGridView1.Columns.Add("columnPrice", "Price");
dataGridView1.Columns.Add("columnType", "Tip");
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
btn.Name = "";
btn.HeaderText = "Edit";
btn.Text = "Uredi";
btn.UseColumnTextForButtonValue = true;
if (dataGridView1.Columns["edit"] == null)
{
dataGridView1.Columns.Add(btn);
}
foreach (Item i in items)
{
string[] row1 = { i.ItemID, i.ItemName, i.Price.ToString(), i.type, "s" };
dataGridView1.Rows.Add(row1);
}
}
private void button_izbrisi_Click(object sender, EventArgs e)
{
ItemsDatabase db = new ItemsDatabase();
db.RemoveItem(_code);
prejsn_form.RefreshTable();
this.Close();
}
public Node(List <Item.ItemType> _availableTypes, ItemsDatabase _itemsDatabase)
{
m_itemType = Item.ItemType.Top; // random, do not use it
m_item = null;
m_depth = 0;
CreateChildrenNodes(_availableTypes, _itemsDatabase);
}
public LibraryModule(IServiceProvider provider)
{
_log = provider.GetRequiredService <LoggingService>();
_items = provider.GetRequiredService <ItemsDatabase>();
_mobs = provider.GetRequiredService <MobsDatabase>();
_npcs = provider.GetRequiredService <NPCsDatabase>();
}
private void Button2_Click(object sender, EventArgs e)
{
//izbris
ItemsDatabase db = new ItemsDatabase();
db.DeleteItem(id_item);
prev_form.showIzdelki();
this.Dispose();
}
private void loadData()
{
ItemsDatabase db = new ItemsDatabase();
Item itm = db.ReadItem(id_item);
input_name.Text = itm.ItemName;
input_desc.Text = itm.ItemDesc;
input_price.Text = itm.Price.ToString();
}
/// <summary>
/// Adds a new item to the database.
/// </summary>
/// <param name="newItem">The item to add.</param>
public void AddNewItemToDatabase(T newItem)
{
Client = GetMongoClient();
ItemsDatabase = Client.GetDatabase(DatabaseName);
IMongoCollection <T> itemsRead = ItemsDatabase.GetCollection <T>(CollectionName);
itemsRead.InsertOne(newItem);
}
public static ItemsDatabase Load(string path)
{
var xml = File.ReadAllText(path);
XmlSerializer serializer = new XmlSerializer(typeof(ItemsDatabase));
StringReader reader = new StringReader(xml);
ItemsDatabase items = serializer.Deserialize(reader) as ItemsDatabase;
reader.Close();
return(items);
}
//Singleton
private void Awake()
{
if (instance != null)
{
Debug.LogWarning("Il n'y a plus d'une instance de ItemsDatabase dans la scène");
return;
}
instance = this;
}
private void Start()
{
itemDatabase = GetComponent <ItemsDatabase>();
hats.Add(new Hat("Creeper Hat", 53, hatsObj[0], new Vector2(0, 0.1f), new Vector2(1, 1)));
hats.Add(new Hat("Darth Vaider Hat", 35, hatsObj[1], new Vector2(0.1f, 0.1f), new Vector2(1, 1)));
hats.Add(new Hat("New Year Hat", 3, hatsObj[2], new Vector2(0, 0.35f), new Vector2(1, 1)));
bodies.Add(new Body("Metal Body", 105, bodiesObj[0], new Vector2(0, 0f), new Vector2(0.8f, 0.8f)));
bodies.Add(new Body("Cloth Body", 105, bodiesObj[1], new Vector2(0, -0.1f), new Vector2(0.7f, 0.7f)));
bodies.Add(new Body("Upgrade Cloth Body", 105, bodiesObj[2], new Vector2(0, 0f), new Vector2(0.7f, 0.7f)));
}
public static void StartItemCooldown(uint i)
{
if (!Game.DB !.ItemsDatabase.TryGetItemSkill(i, out var itemSkill))
{
return;
}
typeof(CooldownWindowViewModel)
.GetMethod("RouteSkill", BindingFlags.Instance | BindingFlags.NonPublic)?
.Invoke(WindowManager.ViewModels.CooldownsVM, new[] { new Cooldown(itemSkill, 60, CooldownType.Item) });
//WindowManager.ViewModels.CooldownsVM.RouteSkill(new Cooldown(itemSkill, 60, CooldownType.Item));
}
public void loadListView()
{
ItemsDatabase db = new ItemsDatabase();
List <Item> items = db.ReadItems();
listView1.Items.Clear();
foreach (Item i in items)
{
string[] rowList = { i.ItemID, i.ItemName, i.Price.ToString(), i.type };
listView1.Items.Add(new ListViewItem(rowList));
}
}
/// <summary>
/// Updates an existing item in the database.
/// </summary>
/// <param name="existingItem">The item to update.</param>
public void UpdateDatabaseItem(T existingItem)
{
Client = new MongoClient(DatabaseConnectionString);
ItemsDatabase = Client.GetDatabase(DatabaseName);
IMongoCollection <T> itemsRead = ItemsDatabase.GetCollection <T>(CollectionName);
var filterOnId = Builders <T> .Filter.Eq(s => s.Id, existingItem.Id);
long totalCount = itemsRead.Count(filterOnId);
var result = itemsRead.ReplaceOne(filterOnId, existingItem);
}
/// <summary>
/// Updates an existing item in the database.
/// </summary>
/// <param name="existingItem">The item to update.</param>
public void UpdateDatabaseItem(T existingItem)
{
Client = GetMongoClient();
ItemsDatabase = Client.GetDatabase(DatabaseName);
IMongoCollection <T> itemsRead = ItemsDatabase.GetCollection <T>(CollectionName);
FilterDefinition <T> filterOnId = Builders <T> .Filter.Eq(s => s.Id, existingItem.Id);
long totalCount = itemsRead.Count(filterOnId);
ReplaceOneResult result = itemsRead.ReplaceOne(filterOnId, existingItem);
}
void Start()
{
_itemsDatabase = GameObject.Find("ItemsDatabase").GetComponent <ItemsDatabase>();
_cam = Camera.main; // Asigning in the Start to reduce cost.
_items = _itemsDatabase.items[Random.Range(0, _itemsDatabase.items.Length)]; // Assigns random items from the ItemsDatabase
_spriteRenderer = GetComponent <SpriteRenderer>();
_spriteRenderer.sprite = _items.itemSprite;
_gameManager = GameObject.Find("Game Manager").GetComponent <GameManager>(); // This can certainly be substituted with Events and Delegates
_inventory = GameObject.Find("Inventory").GetComponent <Inventory>();
}
public static void TestAbnormDbLoad()
{
var db = new ItemsDatabase("EU-EN");
var samples = new List <long>();
var sw = new Stopwatch();
for (int i = 0; i < 1000; i++)
{
sw.Restart();
db.Load();
sw.Stop();
samples.Add(sw.ElapsedMilliseconds);
System.Diagnostics.Debug.WriteLine($"Average: {samples.Average():N2}ms Last:{sw.ElapsedMilliseconds:N2}ms n:{i+1}");
}
}
private void Button1_Click(object sender, EventArgs e)
{
//shrani
try
{
Item newItm = new Item(input_name.Text, input_desc.Text, Convert.ToDouble(input_price.Text));
ItemsDatabase db = new ItemsDatabase();
db.UpdateItem(id_item, newItm);
prev_form.showIzdelki();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public dodajForm(string code, Spreminjaj formck)
{
prejsn_form = formck;
InitializeComponent();
serialText.Enabled = false;
button_izbrisi.Visible = true;
button_spremeni.Visible = true;
dodaj_btn.Visible = false;
ItemsDatabase d = new ItemsDatabase();
lol = d.ReadItem(code);
showCells(lol.type);
_code = code;
comboBox1.Visible = false;
displayCells();
}
private void hardwareDataGrid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
ItemsDatabase db = new ItemsDatabase();
var row = softwareDataGrid.CurrentCell.RowIndex;
var column = softwareDataGrid.CurrentCell.ColumnIndex;
double weight = Convert.ToDouble(hardwareDataGrid.Rows[row].Cells[0].Value);
string itemID = hardwareDataGrid.Rows[row].Cells[1].Value.ToString();
string itemName = hardwareDataGrid.Rows[row].Cells[2].Value.ToString();
double price = Convert.ToDouble(hardwareDataGrid.Rows[row].Cells[3].Value);
HardwareItem hardwareItem = new HardwareItem(itemID, itemName, price, weight);
db.EditHardwareItem(hardwareItem);
}
public void ActiveToggle()
{
ItemIndex = ItemsDatabase.FecthItemByID(int.Parse(itemID.text)).ID;
if (selectQ1.isOn)
{
Quest.qItem1 = ItemsDatabase.database[ItemIndex].Title;
Quest.numberOfItems1 = int.Parse(nmbForItems.text);
Quest.q1Time = int.Parse(nmbForItems.text);
}
if (selectQ2.isOn)
{
Quest.qItem2 = ItemsDatabase.database[ItemIndex].Title;
Quest.numberOfItems2 = int.Parse(nmbForItems.text);
Quest.q2Time = int.Parse(nmbForItems.text);
}
}
private void deleteListButton_Click(object sender, EventArgs e)
{
try
{
splits = listBox1.SelectedItem.ToString().Split(' ');
serNum = Convert.ToInt32(splits[0]);
ItemsDatabase delete = new ItemsDatabase();
delete.deleteItem(serNum);
MessageBox.Show("Deleted");
lista();
}
catch
{
MessageBox.Show("Try again!");
}
}
private void deleteButton_Click(object sender, EventArgs e)
{
try
{
string itemID = DeleteTextBox.Text;
int id = Convert.ToInt32(itemID);
Item newItem = new Item(id);
ItemsDatabase db = new ItemsDatabase();
db.deleteItem(id);
MessageBox.Show("Deleted");
}
catch
{
MessageBox.Show("Try again");
}
}
public void Add(ItemEntity entity)
{
try
{
var itemData = OpenFileAndReadData(TravelInTimeConstants.ItemsDatabase).GetCollection();
for (var i = 0; i < itemData.Count; i++)
{
ItemsDatabase.Add(new ItemEntity((int)itemData[i]["id"], itemData[i]["title"].ToString(),
(int)itemData[i]["value"], (bool)itemData[i]["stackable"],
itemData[i]["slug"].ToString()));
}
}
catch (Exception e)
{
Debug.WriteLine("something went wrong with adding the item");
}
}
