Username:
Password:
Remember me:
Register  Forgot Password?
  Quick Search:  
Menu
Home
Shop for Scenarios
Article List
Review Section
Advanced Search
Games Wanted (49)
ASL Events
Scenario Lists
Publications
My Page (login req)
Contact
VASL Analyser
About the Archive
Site Sponsors
Stats
   
Scenarios: 7057
Users: 2445
Secret Santas:
Play-list Scenarios: 3105
AARs: 114
Articles: 578
Other files: 16951
Ratings: 19368
Module Reviews: 24
Games Logged: 15264
Scenario Lists: 75
Links: 178
Errata: 858
Map Previews: 4432
Roar games logged: 80464
Total Pubs Owned: 89662
Avg Pubs Owned: 139
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']."
Wednesday 14 November 2018 12:11:03 PM  (c)dramsey 2018