[C#] Get information from database, turn into TextColor [BcStorm Emulator]

adapter.setQuery("SELECT * FROM users WHERE id = @userId");

Just select the field you need, don't select everything..

I've no idea how bcstorm works, but try this:

string value = adapter.setQuery("SELECT fieldname FROM users WHERE id = @userId");
 
Upvote 0
oh. I already got it ;).
@userId has no value.
I did it now like this and it works O.O!
adapter.setQuery("SELECT * FROM users WHERE username = '" + GetClient().GetHabbo().Username + "'");

yeah.. it works.. but after a while it unloads you from the room.. fixing it now.
 
Upvote 0
Back