SELECT * FROM documents WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM cracktros WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM magazineissues WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM repositoryfiles WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC #category#
#author#
#date#/#month#/#year#
#description#
#indetail#", newRowCount)> #filename#
From #year#
#filename# Screenshot", newRowCount)> #magTitle# #magIssue#
#magheadline#", newRowCount)> SELECT idName,completeName FROM repositorygroupdetail WHERE idName = '#org#' #RS4A.completeName# #type#
(#fileName#)
#dateday#/#datemonth#/#dateyear#
#description#", newRowCount)> SELECT * FROM application.RSCombined ORDER BY dateAdded DESC #fileType#) #dateFormat(dateAdded,'dd-mmm')# #linkText# #dateFormat(dateAdded,'dd-mmm')# #linkText# #dateFormat(dateAdded,'dd-mmm')# #linkText# #dateFormat(dateAdded,'dd-mmm')# #linkText# (#bracketText#)
(#Clicks# dls) #dateFormat(dateAdded,'dd-mmm')#. #linkText# #linkText# cracktro #linkText# #linkText# file
SELECT * FROM repositorygroupdetail WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM magazinedetail WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM repositorygroupdetail WHERE dateRevised IS NOT NULL ORDER BY dateRevised DESC SELECT * FROM magazinedetail WHERE dateRevised IS NOT NULL ORDER BY dateRevised DESC SELECT * FROM documents WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM cracktros WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM magazineissues WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM repositoryfiles WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT * FROM scenewebsites WHERE DateAdded IS NOT NULL ORDER BY DateAdded DESC SELECT idName,completeName FROM repositorygroupdetail WHERE idName = '#org#' SELECT * FROM documents WHERE DateRevised IS NOT NULL ORDER BY DateRevised DESC SELECT * FROM cracktros WHERE DateRevised IS NOT NULL ORDER BY DateRevised DESC SELECT * FROM magazineissues WHERE DateRevised IS NOT NULL ORDER BY DateRevised DESC SELECT * FROM repositoryfiles WHERE DateRevised IS NOT NULL ORDER BY DateRevised DESC SELECT * FROM filepacks ORDER BY LastRevised DESC SELECT * FROM scenewebsites WHERE DateRevised IS NOT NULL ORDER BY DateRevised DESC SELECT idName,completeName FROM repositorygroupdetail WHERE idName = '#org#' SELECT * FROM RSCombined ORDER BY rscDate DESC
Current Server Time: #DateFormat(now(),'d-mmm')# #TimeFormat(now(),'HH:MM')#
Display
#NumberFormat((RSZ.recordcount-RSZ.currentrow)+1,'000000')# #DateFormat(rscDate,'dd-mmm yyyy')# #DateFormat(rscDate,'dd-mmm')# #TimeFormat(rscDate,'HH:mm')# updated #fileType#added #fileType#error #linkText# #linkText# #linkText# #linkText# #linkText# #linkText# #linkText# #linkText# (#bracketText#)

#RCnewsPosts# news posts since #dateFormat(DATEnewsPosts,"dd mmmm yyyy")#
#RCportalLinks# portal links covering 5 scene topics

#STATrepositoryGroups# different groups in the Scene Repository
#(STATdocuments+RCrepositoryDocs)# repository documents
#RCmagazineIssuesCode# magazines with #RCmagazinesCode# issues
#RCmagazineIssuesText# reports with #RCmagazinesText# issues
6,200 release information files viewable

#RCcracktros# cracktros plus #RCinstallers# installers
#RCcracktroGroups# groups have a cracktro or installer
Created by #RCcracktroAuthors# listed authors

Over #filesTotal# files on offer
Serving #filesServed# downloads since April 2006|

SELECT downloads,filesize,fulltitle,nolocal,filename FROM filepacks ORDER BY Downloads DESC SELECT clicks,magTitle,magIssue FROM magazineissues ORDER BY Clicks DESC SELECT clicks,description,uniqueID FROM documents ORDER BY Clicks DESC SELECT clicks,CreatedFor,filename FROM cracktros ORDER BY Clicks DESC Top #limit# Files (since April 2006)
#popDL["#i#"][1]#
#i#. #left(popDL["#i#"][2],34)#.. SELECT id,name,url,clicks FROM thesceneportal ORDER BY clicks desc Top #limit# Links (since April 2006)
#RS1.clicks#
#RS1.currentrow#. #left(RS1.name,34)#.. SELECT Count(Installer) AS sum FROM cracktros WHERE Installer = 0 AND InGameLoader = 0 SELECT Count(DISTINCT Author) AS sum FROM cracktrosauthors SELECT Count(DISTINCT CreatedFor) AS sum FROM cracktros SELECT SUM(Clicks) AS cracktotal FROM cracktros SELECT Count(Type) AS sum FROM documents WHERE Type = 'Text' OR Type = 'PDF' OR Type = 'Html' SELECT SUM(Clicks) AS doctotal FROM documents SELECT SUM(downloads) AS packstotal FROM filepacks SELECT SUM(Clicks) AS groupstotal FROM repositoryfiles SELECT Count(Installer) AS sum FROM cracktros WHERE Installer != 0 AND InGameLoader = 0 SELECT Count(magSize) AS sum FROM magazineissues WHERE magazineissues.magSize <> '0' AND magazineissues.magTitle = (SELECT magazinedetail.magPrimName FROM magazinedetail WHERE magazinedetail.magPrimText = 0 AND magazinedetail.magPrimName = magazineissues.magTitle) SELECT SUM(Clicks) AS magstotal FROM magazineissues SELECT Count(magPrimText) AS sum FROM magazinedetail WHERE magPrimText = 0 SELECT Count(magPrimText) AS sum FROM magazinedetail WHERE magPrimText != 0 SELECT Count(magSize) AS sum FROM magazineissues WHERE magazineissues.magSize <> '0' AND magazineissues.magTitle = (SELECT magazinedetail.magPrimName FROM magazinedetail WHERE magazinedetail.magPrimText != 0 AND magazinedetail.magPrimName = magazineissues.magTitle) SELECT id,Date FROM thescenenews SELECT id,clicks FROM statistics WHERE id='nfo' SELECT Count(disable) AS sum FROM thesceneportal WHERE disable = 0 SELECT Count(type) AS sum FROM repositoryfiles WHERE type <> 'Video' AND type <> 'Logo' AND type <> 'Image' SELECT Count(id) AS sum FROM repositoryfiles SELECT Count(idName) AS sum FROM repositorygroupdetail SELECT * FROM statisticsmaximumvisits WHERE id = 1 UPDATE statisticsmaximumvisits SET maxVisits=1, maxVisitsDate=#CreateODBCDateTime(now())# WHERE id=1 UPDATE statisticsmaximumvisits SET maxVisits=#IncrementValue(StructCount(application.usersCounting))#, maxVisitsDate=#CreateODBCDateTime(now())# WHERE id=1 Computers viewing the site : #tmp#just you
 Total visits today : #application.usersonline[tmp].people# people & #application.usersonline[tmp].robots# bots
Total visits yesterday : #application.usersonline[(tmp-1)].people# people & #application.usersonline[(tmp-1)].robots# bots