Username:
Password:
Remember me:
Register  Forgot Password?
  Quick Search:  
Menu
Home
Shop for Scenarios
Article List
Review Section
Advanced Search
Games Wanted (20)
ASL Events
Scenario Lists
Publications
My Page (login req)
Contact
VASL Analyser
About the Archive
Site Sponsors
Stats
   
Scenarios: 6740
Users: 2120
Secret Santas:
Play-list Scenarios: 2768
AARs: 97
Articles: 573
Other files: 14000
Ratings: 16271
Module Reviews: 24
Games Logged: 12842
Scenario Lists: 69
Links: 178
Errata: 732
Map Previews: 3558
Roar games logged: 80464
Total Pubs Owned: 84564
Avg Pubs Owned: 141
Most Played Scenarios:
'); echo("
Most Played Scenarios
"); $count=0; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $count++; $col='#c5f049'; if (($count%2)==1) $col='#f5f069'; echo(""); } echo("
ScenarioPlayings
".$row['title']."".$row['a']."
"); $q = "Select distinct scenario.id id,publisher_name, scenario.title,total_playings a from roardata,scenario,pubs,publishers where archive_sc_id=scenario.id and pubs.id=scenario.pub_id and pubs.publish_id=publishers.publisher_id group by scenario.title order by a desc limit 50"; $result=mysql_query($q,$conn) or die("Failed Query"); /* echo(''); echo("
ROAR\'s Most Played Scenarios
"); $count=0; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $count++; $col='#c5f049'; if (($count%2)==1) $col='#f5f069'; echo(""); }*/ ?>
ScenarioPlayings
".$row['title']."".$row['a']."
Monday 29 May 2017 09:25:07 PM  (c)dramsey 2017