[(Awesome)RELEASE] CoEmuv2.Nano(5095) Source Code

05/28/2009 02:17 andyd123#346
Quote:
Originally Posted by scottdavey View Post
It was because i was using a low grade mysql version, its fixed.

PS. Message for andy, has this ever froze for you with several players?
No.
Had ~100 people on, would be greatly more than that, but like I said, a few days is nothing.
05/28/2009 02:20 danielachraf#347
Quote:
Originally Posted by andyd123 View Post
No.
Had ~100 people on, would be greatly more than that, but like I said, a few days is nothing.
I got all works ... but i can't open ports on SpeedTouch router ..
05/28/2009 02:42 scottdavey#348
I noticed it doesn't save cps, here's cps saving for noobs or people that want to save time.

Code:
		public static void SaveCharacter(Character Client)
		{
            MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `Level` = " + Client.Level + ", `WHMoney` = " + Client.WHMoney + ", `PkPoints` = " + Client.PkPoints + ", `xCord` = " + Client.X + ", `yCord` = " + Client.Y + ", `Map` = " + (int)Client.Map + ", `HairStyle` = " + Client.Hair + ", `Class` = " + (int)Client.Class + ", `Exp` = " + Client.Exp + ", `Money` = " + Client.Money + ", `CPoints` = " + Client.CPs + ", `Str` = " + Client.Strength + ",`Vit` = " + Client.Vitality + ", `Spi` = " + Client.Spirit + ", `Dex` = " + Client.Dexterity + ", `StatPoints` = " + Client.StatPoints + ", `FirstLog` = " + 1 + ", `Reborn` = " + Client.Reborn + ", `HP` = " + Client.CurrentHP + ", `MP` = " + Client.CurrentMP + " WHERE `CharID` = " + Client.ID, DatabaseConnection.NewConnection());
			Cmd.ExecuteNonQuery();
			Cmd.Connection.Close();
			Cmd.Connection.Dispose();
			Cmd.Dispose();
		}
Great source btw.

[ code] is making indentation look terrible lol.
05/28/2009 05:11 painkiller199202#349
How to fix the freeze problem?
05/28/2009 05:41 HooliGan73#350
Quote:
Originally Posted by scottdavey View Post
I noticed it doesn't save cps, here's cps saving for noobs or people that want to save time.

Code:
		public static void SaveCharacter(Character Client)
		{
            MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `Level` = " + Client.Level + ", `WHMoney` = " + Client.WHMoney + ", `PkPoints` = " + Client.PkPoints + ", `xCord` = " + Client.X + ", `yCord` = " + Client.Y + ", `Map` = " + (int)Client.Map + ", `HairStyle` = " + Client.Hair + ", `Class` = " + (int)Client.Class + ", `Exp` = " + Client.Exp + ", `Money` = " + Client.Money + ", `CPoints` = " + Client.CPs + ", `Str` = " + Client.Strength + ",`Vit` = " + Client.Vitality + ", `Spi` = " + Client.Spirit + ", `Dex` = " + Client.Dexterity + ", `StatPoints` = " + Client.StatPoints + ", `FirstLog` = " + 1 + ", `Reborn` = " + Client.Reborn + ", `HP` = " + Client.CurrentHP + ", `MP` = " + Client.CurrentMP + " WHERE `CharID` = " + Client.ID, DatabaseConnection.NewConnection());
			Cmd.ExecuteNonQuery();
			Cmd.Connection.Close();
			Cmd.Connection.Dispose();
			Cmd.Dispose();
		}
Great source btw.

[ code] is making indentation look terrible lol.
sorry,dude
i gonna flame you cause i still learning coding, where i should be put this?!!
05/28/2009 06:06 teroareboss1#351
thx all
but how make register page?help pls
05/28/2009 06:15 BrokeN^WinG#352
Quote:
Originally Posted by HooliGan73 View Post
sorry,dude
i gonna flame you cause i still learning coding, where i should be put this?!!
Database
Database.cs
05/28/2009 06:18 laurytalvi#353
anyone can help me somehow.? how can i put hamachi ip to server.dat? thanks in advance
05/28/2009 06:43 BrokeN^WinG#354
For Who Ask About Hair Style

Example: /hair 440
05/28/2009 15:24 geloux#355
in game server i got this error
line 34
MySqlConnection C = null;
try{
C = new MySqlConnection("Server=" + SERVER + ";Database='" + DATA_BASE + "';Username='" + USER_NAME + "';Password='" + PASSWORD + "'; Min Pool Size = 300; Max Pool Size = 900");
C.Open();
}
catch(Exception e)
},<---- this is the line 34
Console.WriteLine(e.ToString());
return null;
}
return C;
}
}
at login server i got this error
MySql.Data.MySqlClient.MySqlException:acess denied for user 'coemuorg'@'localhost
line 30
MySqlConnection C = null;
try{
C = new MySqlConnection("Server=" + SERVER + ";Database='" + DATA_BASE + "';Username='" + USER_NAME + "';Password='" + PASSWORD + "'");
C.Open(); <---- line 30
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
return null;
}
return C;
}
}
05/28/2009 15:30 Kiyono#356
Quote:
Originally Posted by scottdavey View Post
I noticed it doesn't save cps, here's cps saving for noobs or people that want to save time.

Code:
		public static void SaveCharacter(Character Client)
		{
            MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `Level` = " + Client.Level + ", `WHMoney` = " + Client.WHMoney + ", `PkPoints` = " + Client.PkPoints + ", `xCord` = " + Client.X + ", `yCord` = " + Client.Y + ", `Map` = " + (int)Client.Map + ", `HairStyle` = " + Client.Hair + ", `Class` = " + (int)Client.Class + ", `Exp` = " + Client.Exp + ", `Money` = " + Client.Money + ", `CPoints` = " + Client.CPs + ", `Str` = " + Client.Strength + ",`Vit` = " + Client.Vitality + ", `Spi` = " + Client.Spirit + ", `Dex` = " + Client.Dexterity + ", `StatPoints` = " + Client.StatPoints + ", `FirstLog` = " + 1 + ", `Reborn` = " + Client.Reborn + ", `HP` = " + Client.CurrentHP + ", `MP` = " + Client.CurrentMP + " WHERE `CharID` = " + Client.ID, DatabaseConnection.NewConnection());
			Cmd.ExecuteNonQuery();
			Cmd.Connection.Close();
			Cmd.Connection.Dispose();
			Cmd.Dispose();
		}
Great source btw.

[ code] is making indentation look terrible lol.
Already posted some pages back.
05/28/2009 17:11 Zimbolt#357
I guess I could be kind enough to add my crappy register page to this thread.
(Yes I know its horrible, but I guess if your retarded, you could use it)
Only registers an accountname, nothing fancy.
Obviously set up create.php
and edit the servername in 5095.html
05/28/2009 18:07 danielachraf#358
Quote:
Originally Posted by Zimbolt View Post
I guess I could be kind enough to add my crappy register page to this thread.
(Yes I know its horrible, but I guess if your retarded, you could use it)
Only registers an accountname, nothing fancy.
Obviously set up create.php
and edit the servername in 5095.html
nice .. but i will make one better when i connect to the game ...
05/28/2009 18:39 araXis#359
Hey everyone ,

How i can delete GuardRevivers in twinCity,CoEmuGuard To normal guard name,How to work ToxicFog Skill , i want Per kill for 25 Cps in your inventory.

How i can make my wish project.
05/28/2009 19:00 myjonas13#360
well i got probs here.. can contact me at [Only registered and activated users can see links. Click Here To Register...] to ask you ma'am?