[Uber] User-Information [SQL]

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:

Code:

---


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).

Sounds and looks good, thanks

I needed this, thank you very much :]

Quote:

---

Originally Posted by habmoon

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.

Quote:

---

Originally Posted by Saia

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?

Quote:

---

Originally Posted by habmoon

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.

Habmoon just to let you know thats not a girl

ontopic: WTF!

Quote:

---

Originally Posted by Žak™

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. :ehh:

Finally somebody with SQL knowledge has come to this section!

this is looking intresting in many ways welcome nice release

Quote:

---

Originally Posted by AWA

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.

Quote:

---

Originally Posted by Saia

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. :ehh:

---

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:tongue:

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.

PHP Code:

---

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

Quote:

---

Originally Posted by Jontycat

PHP Code:

---

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...

Code:

---


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

---

Quote:

---

Originally Posted by Saia

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...

Code:

---


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 :(