♠♠ [Release] Royal Accounts & Characters Manager (BETA) ♠♠

[Strange2010]

Hi e-pvpers
Today , I would like to introduce my first tool , Royal Accounts & Characters
Manager

What can it do ?

1- Create an account . (you don't say ? )

2- Search for a specific account .

3- Show full information of a character .

4- Shoaw a character's inventory .

5- View an account's warehouse .


I'm sorry if it doesn't have anything special , but as I said before it's my first program .

Screenshots :











Download Link :



Or download from attachment , and don't forget to press thanks


PS : It's a beta release so expect some minor bugs that will be fixed once I know about them .

[Modamer9]

nice tools.

[hackfever]

i wonder if possible to make 1 able to delete items from a players inventory and warehouse and or edit the number of a certain item

[Modamer9]

Originally Posted by hackfever

i wonder if possible to make 1 able to delete items from a players inventory and warehouse and or edit the number of a certain item

this is not impossible.I guess it easy to program such this idea ,but you must be admin to allow delete from player.not such gm

[Strange2010]

thx modamer and hackfever
and thx people for the 123 views and 3 comments -_-

[H1tcher]

Why all is on arabic ?

[Strange2010]

Originally Posted by H1tcher

Why all is on arabic ?

well if you can really see it's the job , titles and items names which are in arabic

and that's because i have an arabic string resource

[H1tcher]

and how change arabic string resources to english ?

[TheOnlyOneRaskim]

May i gave you an tip for performance and optic updates?

In my Opinion a listview is much more comfortable for much infos, than 1k textboxes.

But nice to see some Guys getting their ass up and doing on their own.

 Spoiler

heres a little snippet from my upcoming telnet gm tool


DataTable invviewer = new DataTable();

using (SqlConnection con = sqlcontele())
            {
                try
                {
                    invviewer = null;
                    invviewer = new DataTable();
                    con.Open();
                    SqlDataReader sqlReader = new SqlCommand("SELECT idx, C.owner_name, sR.name, p.Code, p.amount, p.level, p.enhance,p.flag, p.wear_info,p.socket_0, p.socket_1, p.socket_2, p.socket_3, p.remain_time, p.update_time,C.account FROM (SELECT owner_id,idx, code, cnt as amount, level, enhance,flag, wear_info,socket_0, socket_1, socket_2, socket_3,remain_time, update_time FROM " + Properties.Settings.Default.telecaster + ".dbo.Item WHERE owner_id > 0) AS P INNER JOIN  (SELECT sid, account, name as owner_name FROM " + Properties.Settings.Default.telecaster + ".dbo.Character) AS C ON C.sid = P.owner_id INNER JOIN  (SELECT id, name_id, tooltip_id, icon_file_name FROM " + Properties.Settings.Default.arcadia + ".dbo.ItemResource) AS iR ON iR.id = P.Code INNER JOIN  (SELECT code, value as name  FROM " + Properties.Settings.Default.arcadia + ".dbo.StringResource) AS sR ON sR.code = iR.name_id WHERE C.owner_name = N'" + textBox2.Text + "'ORDER BY idx ASC", con).ExecuteReader();
                    invviewer.Load(sqlReader);
                    foreach (DataRow row in invviewer.Rows)
                    {
                        ListViewItem item = new ListViewItem(row[0].ToString());
                        for (int i = 1; i < invviewer.Columns.Count; i++)
                        {
                            item.SubItems.Add(row[i].ToString());
                        }
                        listView1.Items.Add(item);
                    }

                }
                catch
                {
                }
                finally
                {
                    if (con.State == ConnectionState.Open)
                    {
                        con.Close();
                        try
                        {

                        }
                        catch
                        { }
                    }


                }
            }

Result :

 Spoiler

[Strange2010]

Originally Posted by TheOnlyOneRaskim

May i gave you an tip for performance and optic updates?

In my Opinion a listview is much more comfortable for much infos, than 1k textboxes.

But nice to see some Guys getting their ass up and doing on their own.

 Spoiler

heres a little snippet from my upcoming telnet gm tool


DataTable invviewer = new DataTable();

using (SqlConnection con = sqlcontele())
            {
                try
                {
                    invviewer = null;
                    invviewer = new DataTable();
                    con.Open();
                    SqlDataReader sqlReader = new SqlCommand("SELECT idx, C.owner_name, sR.name, p.Code, p.amount, p.level, p.enhance,p.flag, p.wear_info,p.socket_0, p.socket_1, p.socket_2, p.socket_3, p.remain_time, p.update_time,C.account FROM (SELECT owner_id,idx, code, cnt as amount, level, enhance,flag, wear_info,socket_0, socket_1, socket_2, socket_3,remain_time, update_time FROM " + Properties.Settings.Default.telecaster + ".dbo.Item WHERE owner_id > 0) AS P INNER JOIN  (SELECT sid, account, name as owner_name FROM " + Properties.Settings.Default.telecaster + ".dbo.Character) AS C ON C.sid = P.owner_id INNER JOIN  (SELECT id, name_id, tooltip_id, icon_file_name FROM " + Properties.Settings.Default.arcadia + ".dbo.ItemResource) AS iR ON iR.id = P.Code INNER JOIN  (SELECT code, value as name  FROM " + Properties.Settings.Default.arcadia + ".dbo.StringResource) AS sR ON sR.code = iR.name_id WHERE C.owner_name = N'" + textBox2.Text + "'ORDER BY idx ASC", con).ExecuteReader();
                    invviewer.Load(sqlReader);
                    foreach (DataRow row in invviewer.Rows)
                    {
                        ListViewItem item = new ListViewItem(row[0].ToString());
                        for (int i = 1; i < invviewer.Columns.Count; i++)
                        {
                            item.SubItems.Add(row[i].ToString());
                        }
                        listView1.Items.Add(item);
                    }

                }
                catch
                {
                }
                finally
                {
                    if (con.State == ConnectionState.Open)
                    {
                        con.Close();
                        try
                        {

                        }
                        catch
                        { }
                    }


                }
            }

Result :

 Spoiler

Thx raskim , I appreciate your suggestion .
What I first thought is to use a list view as you mentioned but when I tried the textboxes I saw them nice too , in my opinion

[Strange2010]

Originally Posted by sunnyxie49

very thank

i thought there was a button called "Thanks"

[Thelxinoe]

WARNING: Your keyboard needs to be set in English to make this work

[HeavenOnlyWishes]

Originally Posted by H1tcher

and how change arabic string resources to english ?

[lxhy]

ths for your tool

[rRINDVIEH]

I have a short problem with that tool.

I cannot type any numbers or letters in that field "Username" it tells me always that i have to type "only english characters" o.O

this is the screen of that error =