Printable View
GM Manager Version 1.1
Function
1.Send gift
2.Add Item Option (Item Attr)
3.User Setting
4.Player Rank Update , Farm Rank Update , Guild Rank Update
5.Add TR to other members , Add EXP to other members
6.Piero Setting can select colour
7.Advance ItemAttr Setting
.Net Framework 3.5
Update Version 1.1
http://imageshack.us/scaled/landing/27/tic4.png
Download Version 1.0 : Attachment 136129
Download Version 1.1 : Download
The program just freezing and "Not responding" when I click Login ><
Quote:
Originally Posted by Symbo
Well you need to configure the connection to the server
Code:[Config]
IP=Tcp:255.255.255.255,99999<---- Server IP
US=sa <---- Sql User
PW=talesrunner <--- Sql Pw
DB=TalesRunner <---- TalesRunner Db
ID=kevinteran99 <---- ID to edit
Version=1.0
[Web]
FB=https://www.facebook.com/pages/Tales-Runner-Latino/442958582425379 <--- Facebook Page
Nice!!Quote:
Originally Posted by Silver Bullet
Works Very Well Help In some things
I did it, Its just freeze when I click "Login" and then its just "Not responding"..Quote:
Originally Posted by Kevin Teran
Same, this happened with the last TR GMC he released.Quote:
Originally Posted by Symbo
Thanks Thanks Thanks Thanks
Do someone knows why its freezing ["Not responding"] for me? ><
Fixed.Quote:
Originally Posted by Kevin Teran
Working, Thanks!Quote:
Originally Posted by Megaponder
Name Skype?
great release
thx =)
This is to localQuote:
Originally Posted by Megaponder
I use VPS as I have to put Ip and port
Quote:
Originally Posted by eTalesrunner
Maybe u can Upload the Option to change Pw??
Yay v1.1 ><
Edit:
Is there any way to make other people access to my db? [from other pc]
MSSQL you can add logins or make a teamviewer.Quote:
Originally Posted by Symbo
Also it worked now that I used tylers way of entering it (localhost\TR)
It works with anything as long as the database is on your computer.Quote:
Originally Posted by Kevin Teran
I works perfectly in DB OnlineQuote:
Originally Posted by Megaponder
guys , if you use the GM tool from another pc , you must enable "TCP" Option.
which lets you connect over IP (ipaddr,1433) [1433 = default port for mssql]
and from same pc , you need to use your addr (which probably is your computername/sqlexpress)
btw , this code could be improved by selecting with "AS" instead of select * (which may cause errors) .
like select namefd AS "NAME",cashfd AS "CASH" so it will look better and explains more..
also i've seen that you dont have any exception handler ...Code:
private void Button2_Click(object sender, EventArgs e)
{
SqlConnection selectConnection = new SqlConnection();
SqlCommand sqlCommand1 = new SqlCommand();
SqlCommand sqlCommand2 = new SqlCommand();
DataTable dataTable = new DataTable();
DataSet dataSet = new DataSet();
INIControl.SelectINI(".\\Config.ini");
string str = "Server='" + INIControl.ReadINI("Config", "IP", "", 1024) + "';UID='" + INIControl.ReadINI("Config", "US", "", 1024) + "';PASSWORD='" + INIControl.ReadINI("Config", "PW", "", 1024) + "';Database='" + INIControl.ReadINI("Config", "DB", "", 1024) + "';Max Pool Size=400;Connect Timeout=600;";
selectConnection.ConnectionString = str;
selectConnection.Open();
SqlConnection sqlConnection = selectConnection;
if (sqlConnection.State == ConnectionState.Open)
sqlConnection.Close();
sqlConnection.ConnectionString = str;
sqlConnection.Open();
new SqlDataAdapter("SELECT * From tblAvatarUserAttr WHERE fdUserNum = " + this.TextBox2.Text + "", selectConnection).Fill(dataSet, "tblAvatarUserAttr");
if (dataSet.Tables["tblAvatarUserAttr"].Rows.Count == 0)
return;
DataGridView dataGridView1 = this.DataGridView1;
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = (object) dataSet.Tables["tblAvatarUserAttr"];
}
which might cause shit load of problems.
anyway , nice share .
btw , i really think this one :
can be improved by a stored procedure which returns -3 (which will cause the user to update in real time)Code:
private void Button1_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection();
SqlCommand sqlCommand1 = new SqlCommand();
SqlCommand sqlCommand2 = new SqlCommand();
INIControl.SelectINI(".\\config.ini");
MyProject.Computer.FileSystem.FileExists(INIControl.SelectedINI);
string str = "Server='" + INIControl.ReadINI("Config", "IP", "", 1024) + "';UID='" + INIControl.ReadINI("Config", "US", "", 1024) + "';PASSWORD='" + INIControl.ReadINI("Config", "PW", "", 1024) + "';Database='" + INIControl.ReadINI("Config", "DB", "", 1024) + "';Max Pool Size=400;Connect Timeout=600;";
connection.ConnectionString = str;
connection.Open();
if (Conversions.ToInteger(new SqlCommand("INSERT INTO tblGift (fdSendUserNum,fdSendNickname,fdReceiveUserNum,fdGiftItemDescNum,fdNotified,fdMemo) values ('" + this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + this.TextBox1.Text + "','" + this.TextBox4.Text + "',0,'" + this.TextBox5.Text + "')", connection).ExecuteScalar()) == 0)
{
int num1 = (int) MessageBox.Show("Send Gift Ok.");
}
else
{
int num2 = (int) MessageBox.Show("Wrong!");
}
connection.Close();
}
Nooooooooooooooooooooooooo...it doesn't work with SQL Express 2012
Kevin uses SQL 2012 perfectly fineQuote:
Originally Posted by Nathan Adhitya
thanks
Good Release , Thanks Bro :thumbup:
i cant login into the gm manger what is the id? sa?
Your id and pw are the ones you use for your sql authQuote:
Originally Posted by gaskor
so the userid is sa?????
what i need to write in gmc the userid?helep me plz~
i cant connect into the gm manger can u helep me teamviewr???????plz
Something like this: http://puu.sh/70ZT0.pngQuote:
Originally Posted by gaskor
ok i will try
can u helep me how i can fix shop plz helep
- - - Updated - - -
any one can helep me how i can fix shop plz helep me
helepQuote:
Originally Posted by gaskor
is
not
a
fucking
word
soo what i can do?