Who is online

[Jaynno]

Hi,

If you have a server and you dont want your GA or GM or whatever to know your database password and username, but you want them to know who is online on what map and what nation, simply download this visual studio 10 solution and change a string.

This is what you need to change :



this is the result :


a bug that ive found is if the name is too long.. and i cant make it work good :(



feel free to do any modification you want. Im new to c# so i know it is a very basic program.

This is the download link :

[MentaL]

[Yamachi]

This is a VERY bad idea. Storing the username and password in a string like that is a huge security risk. All someone has to do is open the application in something like .Net Reflector and they have your details. I would not recommend anyone use this... If you're going to use this, at least switch the username and password to read from application settings.

[Millenial]

Why god use VB for that.

Just use PHP and make it a webpage. Works far better.

[Amaymon]

Myabe he is good in programming not in php,who knows.

[Jaynno]

i have a php one but like i said, im NOOB at c# and it was my first program... i didint know anything about the connection string. thanks yamachi for this constructive comment.

delete the thread then if its dangerous to use. sorry about that.

Message to Millenial... if all you can say is that, next time dont say anything or do a constructive comment.


Thats my php one :

[Yamachi]

Why god use VB for that.

Just use PHP and make it a webpage. Works far better.

It's C#, not VB.net...

[Millenial]

It's C#, not VB.net...

Does not make pretty much difference.
Also, there are many PHP online player systems out there.
You do not need to do one.

[Yamachi]

Does not make pretty much difference.
Also, there are many PHP online player systems out there.
You do not need to do one.

Unless you've got something constructive to say, I suggest you stay out of this thread.

[Jaynno]

Thanks yamachi,

seriously you can delete the thread since its dangerous.

[Yamachi]

Well, as I said, all you need to do is store the username and password in the application settings. That would fix the security issue.

[KeelzYou]

All Yamachi said was that storing the username and password in a string like that is a huge security risk, he didn't mean the program it self was dangerous. So, if you're going to try this do what he said and switch the username and password to read from application settings.

Edit: Dang, Yama posted before me lol.

[Jaynno]

so if i understand i put the username and password in variable like this :

$user = "theuserhere"
$pass = "thepasswordhere"

then in the connection string i put the variable ???

and those variable are declared in the main class ?

[error0024]

Releasing a php code will be better,as a person which are outside still can monitor the online players.Since its easier to use too

[Yamachi]

so if i understand i put the username and password in variable like this :

$user = "theuserhere"
$pass = "thepasswordhere"

then in the connection string i put the variable ???

and those variable are declared in the main class ?

No, you don't declare the variables in the main class... That would cause the exact same security issues. The variables should be stored in the application settings, like I said.

Project -> Properties -> Settings

Then use it like this:

connectionString = String.Format("Data Source=localhost;Initial Catalog=Gamedb;User ID={0};Password={1}", Properties.Settings.user, Properties.Settings.pass);

NOTE: There's no need to declare the types of your variables and their values seperately. Instead of

string blah = null; blah = "asd";

just do

var blah = "asd"

[Jaynno]

ive needed to put default in the string :

string connectionString = String.Format("Data Source=localhost;Initial Catalog=Gamedb;User ID={0};Password={1}", Properties.Settings.Default.User, Properties.Settings.Default.Password);

but this way its working.

Gonna re-edit the first post tommorow.

[SheenBR]

@Jaynno

Search for a program named DotFuscator. :)

[Alin1337]

very bad idea to give to players your sql informations.
You will get hacked ;D

it's easy to decompile :D