sql is select r.*, i.name, i.description, i.imageurl, t.description as "hardware_type", c.id as "company_id", c.name as "hardware_company_name" from hardware_reviews r, hardware_items i, hardware_companies c, hardware_types t where r.hardware_item_id = i.id and i.hardware_company_id = c.id and i.hardware_type_id = t.id and r.id = '53'
Surprisingly, Microsoft hasn’t enabled video messages – which I thought would be there at day one. Another big problem is that not too many games support Xbox Live currently outside of UNO. I have played UNO to death the past week messing around with gamers that are curious to know why I have a camera and where they can buy one. The set-up for UNO is simple; the camera acts as a web cam as you play with three other users. I must warn parents that the cameras could end up being used for illicit images that children may not want to see, such as people ‘mooning’ other players.
The last feature I want to speak about is the option to change your gamertag picture to whatever you feel like. No longer will you have to use a dull and boring picture of Amped 3, but you are able to snap a picture of anything your heart desires. Whether it is a picture of yourself or your dog, customized gamertag pics will turn out to be incredibly popular. 