LinuxMCE SQL query

Values taken from iOrbiter

Build Menu/Home Screen

Current room

SELECT PK_Room FROM Room ORDER BY PK_ROOM Limit 1;

Description

SELECT Description FROM Room WHERE PK_Room = $currentRoom

Current user

SELECT PK_Users FROM Users ORDER BY PK_Users Limit 1;

Description

SELECT UserName FROM Users WHERE PK_Users = $currentUser

Entertain area

$currentRoom = SELECT PK_Room FROM Room ORDER BY PK_ROOM Limit 1;
SELECT PK_EntertainArea FROM EntertainArea WHERE FK_Room = $currentRoom