C&C Guild | The Definitive Resource for Command & Conquer Modding

2002	Connection refused
	SELECT *, UNIX_TIMESTAMP(LastActive) AS LastActiveU FROM Users WHERE Users.ID = 586159;

Regular User (10,240 points)
Last active: January 1, 1970 - 0:00
Last action:

Show this user's contributions
Show this user's Revora profile

2002

Connection refused

					SELECT
						Items.Title AS Title,
						Items.Type AS Type,
						Ratings.Item AS ID,
						Ratings.Rating AS Rating,
						UNIX_TIMESTAMP(Ratings.RateDate) AS RateDate
					FROM
						Ratings
						LEFT JOIN Items
							ON (Ratings.Item = Items.ID)
					WHERE
						Ratings.User = 586159 AND
						Items.Visible = TRUE AND
						Items.Trashed = FALSE
					ORDER BY
						Rating DESC,
						Ratings.RateDate DESC
					LIMIT 0,10;

Return to top

2002	Connection refused
	SELECT Name, Link, Button FROM Affiliates ORDER BY Position ASC;