[Uber] User-Furniture [SQL]

[Saia]

I noticed that a few people needed a way to keep track of duped furniture, staff giving away furniture, etc. I have devised a unique query specifically for Uber to aid in tracking all of this down.

Search a Username:

Replace the red with the username.

SELECT DISTINCT u.id AS 'User ID', u.username AS 'Username', u.rank AS 'Rank', ui.base_item AS 'Furniture ID', (SELECT f.public_name FROM furniture f WHERE f.id = ui.base_item LIMIT 0,1) AS 'Furniture Name', (SELECT COUNT(uiq2.base_item) FROM user_items uiq2 WHERE uiq2.base_item = ui.base_item) AS 'Count'
FROM user_items ui
INNER JOIN users u
ON ui.user_id = u.id
WHERE ui.user_id = (SELECT uq2.id FROM users uq2 WHERE uq2.username = 'USERNAME' LIMIT 0,1)
ORDER BY u.id ASC

Display All:

SELECT DISTINCT u.id AS 'User ID', u.username AS 'Username', u.rank AS 'Rank', ui.base_item AS 'Furniture ID', (SELECT f.public_name FROM furniture f WHERE f.id = ui.base_item LIMIT 0,1) AS 'Furniture Name', (SELECT COUNT(uiq2.base_item) FROM user_items uiq2 WHERE uiq2.base_item = ui.base_item) AS 'Count'
FROM user_items ui
INNER JOIN users u
ON ui.user_id = u.id
ORDER BY u.id ASC

Credits:

Saia (saia.zurchmora@gmail.com).

[MentaL]

[wichard]

wtf means this?

[PEjump2]

@wichard A simple query to check for all user items or 1 item etc, Thanks for releasing this, but it ain't rly needed :P

[Richardjuhh]

Oh, i thinks this is the first girl who can make a retro :D

[Joopie]

Oh, i thinks this is the first girl who can make a retro :D

Maby is that so, But see knows how to do

[vista4life]

I noticed that a few people needed a way to keep track of duped furniture, staff giving away furniture, etc. I have devised a unique query specifically for Uber to aid in tracking all of this down.

Search a Username:

Replace the red with the username.

SELECT  ui.user_id AS 'User ID', (SELECT u.username FROM users u WHERE u.id = ui.user_id LIMIT 0,1) AS 'Username', (SELECT uq2.rank FROM users uq2 WHERE uq2.id = ui.user_id LIMIT 0,1) AS 'Rank', f.id AS 'Furniture ID', f.public_name AS 'Furniture Name', (SELECT COUNT(uiq2.base_item) FROM user_items uiq2 WHERE uiq2.base_item = ui.base_item) AS 'Count'
FROM user_items ui
INNER JOIN furniture f
ON f.id = ui.base_item
WHERE ui.user_id = (SELECT uq2.id FROM users uq2 WHERE uq2.username = 'USERNAME' LIMIT 0,1)
ORDER BY f.public_name ASC

Display All:

SELECT  ui.user_id AS 'User ID', (SELECT u.username FROM users u WHERE u.id = ui.user_id LIMIT 0,1) AS 'Username', (SELECT uq2.rank FROM users uq2 WHERE uq2.id = ui.user_id LIMIT 0,1) AS 'Rank', f.id AS 'Furniture ID', f.public_name AS 'Furniture Name', (SELECT COUNT(uiq2.base_item) FROM user_items uiq2 WHERE uiq2.base_item = ui.base_item) AS 'Count'
FROM user_items ui
INNER JOIN furniture f
ON f.id = ui.base_item
ORDER BY ui.user_id ASC

Credits:

Saia (saia.zurchmora@gmail.com).

looks okey but let me guess you made this with navicat :D?

anyway Thanks.

[Saia]

looks okey but let me guess you made this with navicat :D?

anyway Thanks.

Just because you do not know SQL nor understand a remote amount of how SQL works, does not mean that someone else (such as myself) doesn't understand how SQL works, and how to code it properly.

Just a quick FYI, this was coded 20 minutes prior to me coming to high school this morning. I took a quick glimpse at the Uber database structures and developed that.

[vista4life]

Just because you do not know SQL nor understand a remote amount of how SQL works, does not mean that someone else (such as myself) doesn't understand how SQL works, and how to code it properly.

Just a quick FYI, this was coded 20 minutes prior to me coming to high school this morning. I took a quick glimpse at the Uber database structures and developed that.

WHAHAHAHAHAHAHA your so funny i like it , but you know nothing about me ;)

[wichard]

Or, just make a Cached idgenerator like Matty13 did =)

[Saia]

Or, just make a Cached idgenerator like Matty13 did =)

I don't think you understand the point of this release. This is to track furniture duplication, staff giving away furniture, hacked furniture... not generating furniture ID's.

[salah-salah]

Thanks for this release:)

[Saia]

WHAHAHAHAHAHAHA your so funny i like it , but you know nothing about me ;)

You are right, I do not know anything about you. Should I?

[vista4life]

You are right, I do not know anything about you. Should I?

yes , so you automatically draw conclusions xD

[Saia]

yes , so you automatically draw conclusions xD

As you did regarding me.

[Quackster]

It's just querys? :O