# This resembles the real scripts.conf in all respects, save the real db password is not given herein.

#
# Paths 
#
$BASE = "/home/g1";
$BAK = "$BASE/bak";
$BIN = "$BASE/bin";
$DATA = "$BASE/data";
$TPL= "$BASE/tpl";
$TMP = "$BASE/tmp";
$WWW = "$BASE/www";

#
# Settings for connecting to MySQL
#
$database = 'g1';
$host = 'localhost';
$user = 'g1';
$password = 'password';
$dsn = "DBI:mysql:database=$database;host=$host;port=3306";

#
# Targets for htmlizer.pl
#
@ALL = (
'Rules_Historical',
'Rules_Numerical',
#'Rules_Logical',
#'Rules_Index',
'Proposals_Archive',
'Proposals_Live',
#'Proposals_Index',
#'Motions_Archive', 
#'Motions_Live',
'Judgments_Archive',
'Judgments_Live',
#'Judgments_Index', 
'Roster',
'EventLog',
'Standings'
);      

#
# Historical Ruleset
#
$Rules_Historical = 'numerical';
$Rules_Historical_title = 'Historical Rules';
$Rules_Historical_perpage = 100;
$Rules_Historical_lock = 'rule, rule0history, event';
$Rules_Historical_page_query = 'select number from rule order by number';
$Rules_Historical_body_query = 'select * from rule where number between $first and $last order by number, revision';
$Rules_Historical_hist_query = 'select rule0history.revision, event.event, date_format(event.date, \'%%d %%b %%Y %%T\') from rule0history, event where rule0history.number = $number and rule0history.id = event.id order by event.date';
$Rules_Historical_record_fmt = 'sprintf("<a name = \"$number.$revision\"><b>Rule $number/$revision($vitality)&nbsp;:&nbsp;$title</b></a><blockquote>$text</blockquote>") . ($history eq "" ? "" : "<font size = -1>$history</font><hr>")';
$Rules_Historical_table = 'rule';
$Rules_Historical_links = 1;

#
# Numerical Ruleset
#
$Rules_Numerical = 'numerical';
$Rules_Numerical_title = 'Numerical Rules';
$Rules_Numerical_perpage = 100;
$Rules_Numerical_lock = 'rule, rule0history, event';
$Rules_Numerical_page_query = 'select number from rule where vitality = \'l\' order by number';
$Rules_Numerical_body_query = 'select * from rule where number between $first and $last and vitality = \'l\' order by number, revision';
$Rules_Numerical_hist_query = 'select rule0history.revision, event.event, date_format(event.date, \'%%d %%b %%Y %%T\') from rule0history, event where rule0history.number = $number and rule0history.id = event.id order by event.date';
$Rules_Numerical_record_fmt = 'sprintf("<a name = \"$number.$revision\"><b>Rule $number/$revision&nbsp;:&nbsp;$title</b></a><blockquote>$text</blockquote>") . ($history eq "" ? "" : "<font size = -1>$history</font><hr>")';
$Rules_Numerical_table = 'rule';
$Rules_Numerical_links = 1;

#
# Proposals Archive
#
$Proposals_Archive = 'numerical';
$Proposals_Archive_title = 'Proposals Archive';
$Proposals_Archive_perpage = 25;
$Proposals_Archive_lock = 'proposal, proposal0history, event';
$Proposals_Archive_page_query = 'select number from proposal order by number';
$Proposals_Archive_body_query = 'select * from proposal where number between $first and $last order by number, revision';
$Proposals_Archive_hist_query = 'select proposal0history.revision, event.event, date_format(event.date, \'%%d %%b %%Y %%T\') from proposal0history, event where proposal0history.number = $number and proposal0history.id = event.id order by event.date';
$Proposals_Archive_record_fmt = 'sprintf("<a name = \"$number.$revision\"><b>Proposal $number/$revision($vitality, $activity)&nbsp;:&nbsp;$title</b></a><blockquote>$text</blockquote>") . ($history eq "" ? "" : "<font size = -1>$history</font><hr>")';
$Proposals_Archive_table = 'proposal';
$Proposals_Archive_links = 1;

#
# Proposals_Live
#
$Proposals_Live = 'single';
$Proposals_Live_title = 'Live Proposals';
$Proposals_Live_lock = 'proposal, proposal0history, event';
$Proposals_Live_body_query = 'select * from proposal where vitality = \'l\' order by number, revision';
$Proposals_Live_hist_query = 'select proposal0history.revision, event.event, date_format(event.date, \'%%d %%b %%Y %%T\') from proposal0history, event where proposal0history.number = $number and proposal0history.id = event.id order by event.date';
$Proposals_Live_record_fmt = 'sprintf("<a name = \"$number.$revision\"><b>Proposal $number/$revision($vitality, $activity)&nbsp;:&nbsp;$title</b></a><blockquote>$text</blockquote>") . ($history eq "" ? "" : "<font size = -1>$history</font><hr>")';
$Proposals_Live_table = 'proposal';

#
# Judgments Archive
#
$Judgments_Archive = 'numerical';
$Judgments_Archive_title = 'Judgments Archive';
$Judgments_Archive_perpage = 25;
$Judgments_Archive_lock = 'judgment, judgment0history, event';
$Judgments_Archive_page_query = 'select number from judgment order by number';
$Judgments_Archive_body_query = 'select * from judgment where number between $first and $last order by number, revision';
$Judgments_Archive_hist_query = 'select judgment0history.revision, event.event, date_format(event.date, \'%%d %%b %%Y %%T\') from judgment0history, event where judgment0history.number = $number and judgment0history.id = event.id order by event.date';
$Judgments_Archive_record_fmt = 'sprintf("<a name = \"$number.$revision\"><b>Judgment $number/$revision($vitality)</b></a><p>Statement:<blockquote>$statement</blockquote>Ruling: $ruling<p>Plainiff\'s Analysis:<blockquote>$p_analysis</blockquote>Judge\'s Analysis and Orders:<blockquote>$j_analysis</blockquote>") . ($history eq "" ? "" : "<font size = -1>$history</font><hr>")';
$Judgments_Archive_table = 'judgment';
$Judgments_Archive_links = 1;

#
# Judgments_Live
#
$Judgments_Live = 'single';
$Judgments_Live_title = 'Live Judgments';
$Judgments_Live_lock = 'judgment, judgment0history, event';
$Judgments_Live_body_query = 'select * from judgment where vitality = \'l\' order by number, revision';
$Judgments_Live_hist_query = 'select judgment0history.revision, event.event, date_format(event.date, \'%%d %%b %%Y %%T\') from judgment0history, event where judgment0history.number = $number and judgment0history.id = event.id order by event.date';
$Judgments_Live_record_fmt = 'sprintf("<a name = \"$number.$revision\"><b>Judgment $number/$revision($vitality)</b></a><p>Statement:<blockquote>$statement</blockquote>Ruling: $ruling<p>Plainiff\'s Analysis:<blockquote>$p_analysis</blockquote>Judge\'s Analysis and Orders:<blockquote>$j_analysis</blockquote>") . ($history eq "" ? "" : "<font size = -1>$history</font><hr>")';
$Judgments_Live_table = 'judgment';

#
# Roster
#
$Roster = 'single';
$Roster_title = 'Roster';
$Roster_lock = 'entity, name, mail';
$Roster_body_query = 'select name.name, mail.address, entity.activity from entity, name, mail where entity.id = name.id and name.id = mail.id and name.activity = \'a\' and mail.activity = \'a\' and entity.vitality = \'l\' order by name.name';
$Roster_hist_query = '';
$Roster_record_fmt = '"$name, $address<br>"';

#
# EventLog
#
$EventLog = 'single';
$EventLog_title = 'Event Log';
$EventLog_lock = 'event';
$EventLog_body_query = 'select * from event order by date desc, id desc';
$EventLog_hist_query = '';
$EventLog_record_fmt = '"$date, $event<br>"';

#
# Standings
#
$Standings = 'single';
$Standings_title = 'Standings';
$Standings_lock = 'entity, name';
$Standings_body_query = 'select name.name, entity.score from entity, name where name.id = entity.id order by entity.score desc';
$Standings_hist_query = '';
$Standings_record_fmt = '"$name, $score<br>"';

#
# VotingResults
#

1