This is an old revision of the document!

---

LinuxMCE SQL query

Values taken from iOrbiter

Build Menu/Home Screen

Current room

SELECT PK_Room FROM Room ORDER BY PK_ROOM Limit 1;

Current user

SELECT PK_Users FROM Users ORDER BY PK_Users Limit 1;

Entertain area

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