2002No such file or directory
2002No such file or directory
2002No such file or directory
SELECT ID, Title, Summary FROM Items WHERE Type = 2 AND ID <> 0 AND ID <> 0 AND Trashed = FALSE AND Visible = TRUE ORDER BY RAND() LIMIT 0,1
2002No such file or directory
			SELECT ID, Title, Votes, Rating
			FROM Items WHERE Type = 1 AND Trashed = FALSE AND Visible = TRUE AND Votes > 0
			ORDER BY Rating DESC, Votes DESC, Views DESC LIMIT 0, 10
2002No such file or directory
			SELECT ID, Title, Votes, Rating
			FROM Items WHERE Type = 2 AND Trashed = FALSE AND Visible = TRUE AND Votes > 0
			ORDER BY Rating DESC, Votes DESC, Views DESC LIMIT 0, 10
2002No such file or directory
			SELECT ID, Title, Votes, Rating
			FROM Items WHERE Type = 3 AND Trashed = FALSE AND Visible = TRUE AND Votes > 0
			ORDER BY Rating DESC, Votes DESC, Views DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, Views FROM Items WHERE Type = 1 AND Trashed = FALSE AND Visible = TRUE ORDER BY Views DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, Views FROM Items WHERE Type = 2 AND Trashed = FALSE AND Visible = TRUE ORDER BY Views DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, Views FROM Items WHERE Type = 3 AND Trashed = FALSE AND Visible = TRUE ORDER BY Views DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(Created) AS CreatedU FROM Items WHERE Type = 1 AND Trashed = FALSE AND Visible = TRUE ORDER BY Created DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(Created) AS CreatedU FROM Items WHERE Type = 2 AND Trashed = FALSE AND Visible = TRUE ORDER BY Created DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(Created) AS CreatedU FROM Items WHERE Type = 3 AND Trashed = FALSE AND Visible = TRUE ORDER BY Created DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(Updated) AS UpdatedU FROM Items WHERE Type = 1 AND Trashed = FALSE AND Visible = TRUE ORDER BY Updated DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(Updated) AS UpdatedU FROM Items WHERE Type = 2 AND Trashed = FALSE AND Visible = TRUE ORDER BY Updated DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(Updated) AS UpdatedU FROM Items WHERE Type = 3 AND Trashed = FALSE AND Visible = TRUE ORDER BY Updated DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(LastComment) AS LastCommentU FROM Items WHERE Type = 1 AND LastComment > 0 AND Trashed = FALSE AND Visible = TRUE ORDER BY LastComment DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(LastComment) AS LastCommentU FROM Items WHERE Type = 2 AND LastComment > 0 AND Trashed = FALSE AND Visible = TRUE ORDER BY LastComment DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Title, UNIX_TIMESTAMP(LastComment) AS LastCommentU FROM Items WHERE Type = 3 AND LastComment > 0 AND Trashed = FALSE AND Visible = TRUE ORDER BY LastComment DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Name, Points FROM Users WHERE Points > 0 ORDER BY Points DESC LIMIT 0, 10
2002No such file or directory
SELECT ID, Name, UNIX_TIMESTAMP(LastActive) AS Active, LastAction FROM Users WHERE LastActive > DATE_SUB(NOW(), INTERVAL 10 MINUTE) ORDER BY LastActive DESC
The 3rd Age - BFME Multiplayer, Modding and Mapping
The 3rd Age

There are no mods
in the database

Button for The 3rd AgeButton for The Dwarf HoldsButton for The Elven AllianceButton for Helm's Deep Last HopeButton for GothmogtheOrcButton for BFME+Button for The Four AgesButton for HDR HeadquartersButton for Middle Earth CenterButton for Project Perfect Mod

Become an affiliate!

   

Quick Lists

Top Rated

Tutorials

Mods

Downloads

Popular New Updated Last Comments Users

Register and log in to move these advertisements down

2002No such file or directory
SELECT *, UNIX_TIMESTAMP(LastActive) AS LastActiveU FROM Users WHERE Users.ID = 29234;
No Avatar

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

2002No such file or directory
					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 = 29234 AND
						Items.Visible = TRUE AND
						Items.Trashed = FALSE
					ORDER BY
						Rating DESC,
						Ratings.RateDate DESC
					LIMIT 0,10;

Go to top

 

"One site to rule them all, one site to find them,
one site to host them all, and on the network bind them."

 
20:01:08