[Uber] User-Information [SQL]

[Saia]

I noticed that sometimes there may be an overwhelming amount of unorganized information in the Uber database regarding the users. I have developed a query to simplify a few things, to display only some of the important user information.

Display All:

SELECT u.id AS 'User ID', u.ip_last AS 'User IP Address', u.username AS 'Username', u.gender AS 'Sex', r.name AS 'Rank', u.credits AS 'Credits', u.activity_points AS 'Pixels', u.online AS 'Online Status'
FROM users u
INNER JOIN ranks r
ON u.rank = r.id
ORDER BY u.id ASC

Notes:

The reason I did not do "SELECT DISTINCT" is because the id column in the users table is set to be automatically incrementing. If I put DISTINCT it would be kind of redundant seeing as each id is unique.

Credits:

Saia (saia.zurchmora@gmail.com).

[MentaL]

[Emerica]

Sounds and looks good, thanks

[HabMoon]

I needed this, thank you very much :]

[Saia]

I needed this, thank you very much :]

I am glad you found it useful. You can add my MSN if you would like, if you need anything else or have questions.

[HabMoon]

I am glad you found it useful. You can add my MSN if you would like, if you need anything else or have questions.

Oh thanks, uhm could you PM me your msn?

[Saia]

Oh thanks, uhm could you PM me your msn?

I left it on your profile.

For anyone who is looking through either this thread, or my other thread that I created earlier this morning. If you have any suggestions for queries or stuff that you need, let me know. I am new to the Habbo private server world and stuff, although I am ready to get started on a long stay.

[Zak©]

Habmoon just to let you know thats not a girl

ontopic: WTF!

[Saia]

Habmoon just to let you know thats not a girl

ontopic: WTF!

So basically you are saying that if a girl can develop better than you that it must be a guy? I understand now why you are spending all your time inside on your computer, because you can't get a girl friend in real life.

It must be hard having pimples all over your face. You are a very sad person.

[AWA]

Finally somebody with SQL knowledge has come to this section!

[ntl200]

this is looking intresting in many ways welcome nice release

[Saia]

Finally somebody with SQL knowledge has come to this section!

Thanks for the support. These were done briefly, I am sure I'll soon be releasing some more queries (among other things) as time passes.

[Zak©]

So basically you are saying that if a girl can develop better than you that it must be a guy? I understand now why you are spending all your time inside on your computer, because you can't get a girl friend in real life.

It must be hard having pimples all over your face. You are a very sad person.

No Because in the Habbo section Girls are known as boys so i wouldnt be suprised your a guy. and Yes you are better then me at SQL but i dont do SQL do i? ^^ im a C# guy and lol i dont even have Pimples and im not sad im actually living the life lol. so dont take it wrong this section has a bad history of its girls

and make sure you know the person it be embrassing for you if i was a sql expert. i can do querys but what ever lol.

[Jonteh]

UPDATE ragezone_history SET fake_girls = fake_girls + 1
INSERT INTO ragezone_history (name, gender, fake_female) VALUES ('Saia', 'M', '1') 

I know sql too l0l0l

[Saia]

UPDATE ragezone_history SET fake_girls = fake_girls + 1
INSERT INTO ragezone_history (name, gender, fake_female) VALUES ('Saia', 'M', '1') 

I know sql too l0l0l

Aren't you hilarious. If you knew SQL, you would of realized that those two queries would not work the way that you wrote them. It would be something more like...

INSERT INTO small_dicks (name, gender, penis_size) VALUES ('Jontycat', 'Male', '3cm');

[Jonteh]

Aren't you hilarious. If you knew SQL, you would of realized that those two queries would not work the way that you wrote them. It would be something more like...

INSERT INTO small_dicks (name, gender, penis_size) VALUES ('Jontycat', 'Male', '3cm');

Now this is an intellegent battle!

Oh, sorry, I forgot the semi-colon which doesn't really matter when I use navicat. I don't really give a fuck about SQL, only use it when I have to.

However you're incorrect in saying my penis is 3cm, sorry :(