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

07/27/2009 00:07 n0mansland#1051
Quote:
Originally Posted by gawdin View Post
Ok i was taking a look through my iteminfo.cs and I noticed that it actually doesn't contain a quality modifier
Code:
public static byte[] ItemInfo(int UID, int itemid, int Plus, int Progress, int Minus, int Enchant, int soc1, int soc2, int currentdura, int maxdura, int Location, int Color)
so unless I am mistaken there actually aren't any links to it to change the quality
What do you mean? When you do the item command you automatically get Normal, Refined, Elite, Super

Code:
/item OwlVest [B]9[/B] 2 12 7 255 3
The 9 is Super go down to 8 it is elite 7 unique so on... I don't understand what you mean if there are those qualities? Do you mean stats of those qualities?
07/27/2009 01:54 gawdin#1052
ok thanks i will check that as soon as i get this problem fixed, could you help me figure out where it is snagging?

[Only registered and activated users can see links. Click Here To Register...]

This is line 419 of database.cs
Code:
Item.Progress = Convert.ToInt32(DR["Progress"]);
and this is line 124 of Packetprocessor.cs
Code:
Database.Database.SetPass(AccountName, Password);
07/27/2009 02:01 n0mansland#1053
The line 419 which is the not specified column is because you have to make a new column in the MySQL items table.. (Right Click + Design table, Add Field, Then name it progress in the guide it should show you how to make it) As for packetprocessor I'm not sure.. Clearing up the Column Error might clean that one too.
07/27/2009 02:31 gawdin#1054
Quote:
Originally Posted by n0mansland View Post
The line 419 which is the not specified column is because you have to make a new column in the MySQL items table.. (Right Click + Design table, Add Field, Then name it progress in the guide it should show you how to make it) As for packetprocessor I'm not sure.. Clearing up the Column Error might clean that one too.
Yeah that cleared it up, thanks for the help
07/28/2009 05:56 gawdin#1055
ok my gm commands are not working so i can't test, the tables say the account has gm and pm privs, i even tried making a new account, i don't see any errors in the console or ingame. anyone know what would cause this?

example command:
/item fencekatana 9 2 12 7 255 3
/scroll tc
07/28/2009 06:26 n0mansland#1056
Uhmm try taking the PM off so you are only GM doesn't make sense to do both because I don't think PM's have the rights to do commands. Though /scroll is a normal member command.. Maybe the character is bugged because you are both.
07/28/2009 11:20 gawdin#1057
Quote:
Originally Posted by n0mansland View Post
Uhmm try taking the PM off so you are only GM doesn't make sense to do both because I don't think PM's have the rights to do commands. Though /scroll is a normal member command.. Maybe the character is bugged because you are both.
Yeah that fixed the problem, however changing that number (and I went through 1-60), it would make them all as normal items, occasionally the number would produce the highest level of that item, and sometimes that highest level would also be refined or unique, however elite and super never showed up. I am going to reinstall the source and rebuild everything and hopefully that will fix things
07/28/2009 12:09 gawdin#1058
Ok so yeah, I reinstalled the server (see if maybe that would fix the problem), however this time I got a new error, may be a typo somewhere on my part if anyone could assist? (reinstalling game server again gives same problem)

Code:
System.InvalidOperationException: Connection must be valid and open.
   at MySql.Data.MySqlClient.MySqlCommand.CheckState
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader
   at CoEmu_v2_GameServer.Database.Database.LoadMonsters in c:\Documents and Settings\†Gawdin†\Desktop\COserv\CoEmu v2\CoEmu v2 GameServer\Database\Database.cs:line 516
   at CoEmu_v2_GameServer.Structs.Struct.LoadMonsters in c:\Documents and Settings\†Gawdin†\Desktop\COserv\CoEmu v2\CoEmu v2 GameServer\Structs\DataLoader.cs:line 143
   at CoEmu_v2_GameServer.Nano.StartServer in c:\Documents and Settings\†Gawdin†\Desktop\COserv\CoEmu v2\CoEmu v2 GameServer\Nano.cs:line 68
   at CoEmu_v2_GameServer.Program.Main in c:\Documents and Settings\†Gawdin†\Desktop\COserv\CoEmu v2\CoEmu v2 GameServer\Main.cs:line 33
(this is what pops up in debug)

This comes up in the console:
Code:
System.NullReferenceException: Object reference not set to an instance of an object.
     at MySql.Data.MySqlClient.MySqlPacket.ReadString()
     at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
     at MySql.Data.MySqlClient.NativeDriver.Open()
     at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
     at MySql.Data.MySqlClient.MySqlPool..ctor(MySqlConnectionStringBuilder settings)
     at MySql.Data.MySqlClient.MySqlPoolManager.GetPool(MySqlConnectionStringBuilder settings)
     at MySql.Data.MySqlClient.MySqlConnection.Open()
     at CoEmu_v2_GameServer.Database.DatabaseConnection.NewConnection() in c:\...\CoEmu v2 GameServer\Database\DatabaseConnection.cs
This occurs right after it
Code:
[GameServer] Did not load DMap: christmas02.DMap[1832]
07/28/2009 19:42 rblazed12601#1059
can any1 plz help me im gettin confused xD cause im gettin stuck wit the phpmyadmin idk how to do it with navicat does any1 have a better 1 that they worked with or maybe some1 can give a vid to show me how to set up the source mayb im doin sumtin wrong?
07/28/2009 19:47 n0mansland#1060
Just download Navicat seperate it's a lot easier.. + download MySQL instance config wizard so you can setup your database
07/28/2009 20:53 Belth#1061
The only thing I don't understand is how to intercept packets sent by the client so that I can properly code the server to process them (rather than just respond with "unknown packet").

I did a lot of searching and decided that it ultimately came down to a custom program that intercepts and decrypts the packets. I read about "packet sniffers" that do just that without the decrypting; which is fine except I don't understand what I'm reading or more specifically how to determine what connection/packets I should be looking at. If this is the right path can anyone guide me to an efficient packet sniffer and how I should interpret what I see? If not, where should I start looking?

Any help would be greatly appreciated.
07/28/2009 22:26 rblazed12601#1062
@n0mansland
i was following ur guide and i have a problem wit line 34 idk why it looks just like urs
07/29/2009 02:04 LegendsReborn#1063
i thnk i got everything right.. but then when i try to login..
my passwords are both the same for the DatabaseConnections.cs

it gives me this error:

DBpass Equals Error: Error
07/29/2009 02:20 n0mansland#1064
The MySQL database password isn't correct?

Username: root
Pass: pass <-- Wrong?
07/29/2009 02:43 LegendsReborn#1065
Quote:
Originally Posted by n0mansland View Post
The MySQL database password isn't correct?

Username: root
Pass: pass <-- Wrong?
nvm i seemed to have fixed it.. with the line 31 fix .. lol

anyways.. now i have a problem with login freezing for like 3 seconds then says "server maint"...

but i have like no errors on my console.. and it doesnt even say "user is logging in"