[RELEASE] Shaiya Admin Panel

[SkuulCandy]

UP!

[SnickQ]

You still forgot Order by Bag,Slot

And you have error when select item with empty craftname ( like lapis )

Try this

SqlDataAdapter sda = new SqlDataAdapter("select RowID,CharID,ItemID,ItemUID,Type,TypeID,Bag,Slot,Quality,Gem1,Gem2,Gem3,Gem4,Gem5,Gem6,cast(CASE Craftname WHEN ''  then  '00000000000000000000' else Craftname end as varchar(20)) as CraftName, Count, Maketime, Maketype, Del from Charitems where CharID=(Select TOP 1 CharID from Chars where charname= '" + textBox52.Text + "' and del='0') Order by bag, Slot", con);
DataTable dt = new DataTable();
sda.Fill(dt);
dataGridView2.DataSource = dt;

[wallerus]

I'm also learning C#, except I haven't released my work because I don't really agree with releasing bad or unfinished work that isn't user ready. I gave some input to help you improve the program because I personally wouldn't be happy with it if it was mine.

You should definitely compare your program to others like it if it's only for learning purposes, just give credits - you'll learn a lot from recreating programs others have released, obviously expand and improve on their ideas if you're going to release it though.

It wasn't to insult you, just pointing out some bugs and errors. The English will be easy to fix though, here's some misspelled words:
PassWord -> Password.
Wharehouse -> Warehouse.
Item Managment -> Item Management.
Small things, but it does make it look more professional to have proper spelling imo.

Under the Character tab, you could also combine "Select CharName" and "CharName" text boxes into an editable combobox rather than repeating the character names twice.

[SkuulCandy]

Originally Posted by SnickQ

You still forgot Order by Bag,Slot

And you have error when select item with empty craftname ( like lapis )

Try this

SqlDataAdapter sda = new SqlDataAdapter("select RowID,CharID,ItemID,ItemUID,Type,TypeID,Bag,Slot,Quality,Gem1,Gem2,Gem3,Gem4,Gem5,Gem6,cast(CASE Craftname WHEN ''  then  '00000000000000000000' else Craftname end as varchar(20)) as CraftName, Count, Maketime, Maketype, Del from Charitems where CharID=(Select TOP 1 CharID from Chars where charname= '" + textBox52.Text + "' and del='0') Order by bag, Slot", con);
DataTable dt = new DataTable();
sda.Fill(dt);
dataGridView2.DataSource = dt;

Thanks i use now your query
@wallerus i'll check all text :3

[SkuulCandy]

Hi, UPPP
Since several weeks I work on a rebuild of my program. I added a lot of new things, simplifying connection, improving the sequence of automatic action. BUT ABOVE !! I set up query that'll go check a lot of things!! especially at item editor, if the item in question can be stater or linker (pets/costume, lapis, consumable that cannot be).
Actually i need to finish item editor part
Few screen :

[SkuulCandy]

Version 2.1 added !!!