#
# 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_Historical_Index',
'Rules_Numerical',
'Rules_Numerical_Index',
#'Rules_Logical',
'Proposals_Archive',
'Proposals_Archive_Index',
'Proposals_Live',
'Proposals_Voting',
'Motions_Archive', 
'Motions_Archive_Index',
'Motions_Live',
'Motions_Voting',
'Judgments_Archive',
'Judgments_Live',
#'Judgments_Index', 
'Officers_Historical',
'Elections_Voting',
'Roster',
'EventLog',
'Standings'
);      

#
# Historical Ruleset
#
$Rules_Historical = 'numerical';
$Rules_Historical_header_file = "$TPL/paged.header";
$Rules_Historical_hlinks_file = "$TPL/paged.hlinks";
$Rules_Historical_footer_file = "$TPL/date.footer";
$Rules_Historical_replace_file = "$TPL/generic.replace";
$Rules_Historical_title = 'Historical Ruleset';
$Rules_Historical_perpage = 100;
$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;

#
# Historical Ruleset Index
#
$Rules_Historical_Index = 'index';
$Rules_Historical_Index_header_file = "$TPL/single.header";
$Rules_Historical_Index_footer_file = "$TPL/date.footer";
$Rules_Historical_Index_replace_file = "$TPL/generic.replace";
$Rules_Historical_Index_title = 'Historical Ruleset Index';
$Rules_Historical_Index_table = 'rule';
$Rules_Historical_Index_body_query = 'select number, revision, title from rule order by number, revision';

#
# Numerical Ruleset
#
$Rules_Numerical = 'numerical';
$Rules_Numerical_header_file = "$TPL/paged.header";
$Rules_Numerical_hlinks_file = "$TPL/paged.hlinks";
$Rules_Numerical_footer_file = "$TPL/date.footer";
$Rules_Numerical_replace_file = "$TPL/generic.replace";
$Rules_Numerical_title = 'Numerical Ruleset';
$Rules_Numerical_perpage = 100;
$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;

#
# Numerical Ruleset Index
#
$Rules_Numerical_Index = 'index';
$Rules_Numerical_Index_header_file = "$TPL/single.header";
$Rules_Numerical_Index_footer_file = "$TPL/date.footer";
$Rules_Numerical_Index_replace_file = "$TPL/generic.replace";
$Rules_Numerical_Index_title = 'Numerical Ruleset Index';
$Rules_Numerical_Index_table = 'rule';
$Rules_Numerical_Index_body_query = 'select number, revision, title from rule where vitality = \'l\' order by number';

#
# Proposals Archive
#
$Proposals_Archive = 'numerical';
$Proposals_Archive_header_file = "$TPL/paged.header";
$Proposals_Archive_hlinks_file = "$TPL/paged.hlinks";
$Proposals_Archive_footer_file = "$TPL/date.footer";
$Proposals_Archive_replace_file = "$TPL/generic.replace";
$Proposals_Archive_title = 'Proposals Archive';
$Proposals_Archive_perpage = 25;
$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 Archive Index
#
$Proposals_Archive_Index = 'index';
$Proposals_Archive_Index_header_file = "$TPL/single.header";
$Proposals_Archive_Index_footer_file = "$TPL/date.footer";
$Proposals_Archive_Index_replace_file = "$TPL/generic.replace";
$Proposals_Archive_Index_title = 'Proposals Archive Index';
$Proposals_Archive_Index_table = 'proposal';
$Proposals_Archive_Index_body_query = 'select number, revision, title from proposal order by number, revision';

#
# Proposals_Live
#
$Proposals_Live = 'single';
$Proposals_Live_header_file = "$TPL/single.header";
$Proposals_Live_footer_file = "$TPL/date.footer";
$Proposals_Live_replace_file = "$TPL/generic.replace";
$Proposals_Live_title = 'Live Proposals';
$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';

#
# Motions Archive
#
$Motions_Archive = 'numerical';
$Motions_Archive_header_file = "$TPL/paged.header";
$Motions_Archive_hlinks_file = "$TPL/paged.hlinks";
$Motions_Archive_footer_file = "$TPL/date.footer";
$Motions_Archive_replace_file = "$TPL/generic.replace";
$Motions_Archive_title = 'Motions Archive';
$Motions_Archive_perpage = 25;
$Motions_Archive_page_query = 'select number from motion order by number';
$Motions_Archive_body_query = 'select * from motion where number between $first and $last order by number, revision';
$Motions_Archive_hist_query = 'select motion0history.revision, event.event, date_format(event.date, \'%%d %%b %%Y %%T\') from motion0history, event where motion0history.number = $number and motion0history.id = event.id order by event.date';
$Motions_Archive_record_fmt = 'sprintf("<a name = \"$number.$revision\"><b>Motion $number/$revision($vitality, $activity)&nbsp;:&nbsp;$title</b></a><blockquote>$text</blockquote>") . ($history eq "" ? "" : "<font size = -1>$history</font><hr>")';
$Motions_Archive_table = 'motion';
$Motions_Archive_links = 1;

#
# Motions Archive Index
#
$Motions_Archive_Index = 'index';
$Motions_Archive_Index_header_file = "$TPL/single.header";
$Motions_Archive_Index_footer_file = "$TPL/date.footer";
$Motions_Archive_Index_replace_file = "$TPL/generic.replace";
$Motions_Archive_Index_title = 'Motions Archive Index';
$Motions_Archive_Index_table = 'motion';
$Motions_Archive_Index_body_query = 'select number, revision, title from motion order by number, revision';

#
# Motions_Live
#
$Motions_Live = 'single';
$Motions_Live_header_file = "$TPL/single.header";
$Motions_Live_footer_file = "$TPL/date.footer";
$Motions_Live_replace_file = "$TPL/generic.replace";
$Motions_Live_title = 'Live Motions';
$Motions_Live_body_query = 'select * from motion where vitality = \'l\' order by number, revision';
$Motions_Live_hist_query = 'select motion0history.revision, event.event, date_format(event.date, \'%%d %%b %%Y %%T\') from motion0history, event where motion0history.number = $number and motion0history.id = event.id order by event.date';
$Motions_Live_record_fmt = 'sprintf("<a name = \"$number.$revision\"><b>Motion $number/$revision($vitality, $activity)&nbsp;:&nbsp;$title</b></a><blockquote>$text</blockquote>") . ($history eq "" ? "" : "<font size = -1>$history</font><hr>")';
$Motions_Live_table = 'motion';

#
# Judgments Archive
#
$Judgments_Archive = 'numerical';
$Judgments_Archive_header_file = "$TPL/paged.header";
$Judgments_Archive_hlinks_file = "$TPL/paged.hlinks";
$Judgments_Archive_footer_file = "$TPL/date.footer";
$Judgments_Archive_replace_file = "$TPL/generic.replace";
$Judgments_Archive_title = 'Judgments Archive';
$Judgments_Archive_perpage = 25;
$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_header_file = "$TPL/single.header";
$Judgments_Live_footer_file = "$TPL/date.footer";
$Judgments_Live_replace_file = "$TPL/generic.replace";
$Judgments_Live_title = 'Live Judgments';
$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_header_file = "$TPL/single.header";
$Roster_footer_file = "$TPL/date.footer";
$Roster_replace_file = "$TPL/Roster.replace";
$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 isnull(name.end) and isnull(mail.end) and entity.vitality = \'l\' order by name.name';
$Roster_hist_query = '';
$Roster_record_fmt = '"$name, $address<br>"';

#
# EventLog
#
$EventLog = 'single';
$EventLog_header_file = "$TPL/single.header";
$EventLog_footer_file = "$TPL/date.footer";
$EventLog_replace_file = "$TPL/generic.replace";
$EventLog_title = 'Event Log';
$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_header_file = "$TPL/single.header";
$Standings_footer_file = "$TPL/date.footer";
$Standings_replace_file = "$TPL/generic.replace";
$Standings_title = 'Standings';
$Standings_body_query = 'select name.name, entity.score from entity, name where name.id = entity.id and isnull(name.end) order by entity.score desc';
$Standings_hist_query = '';
$Standings_record_fmt = '"$name, $score<br>"';

#
# Officers_Historical
#
$Officers_Historical = 'officers';
$Officers_Historical_header_file = "$TPL/single.header";
$Officers_Historical_footer_file = "$TPL/date.footer";
$Officers_Historical_title = 'Officers Past';

#
# Elections_Voting
#
$Elections_Voting = 'voting';
$Elections_Voting_header_file = "$TPL/single.header";
$Elections_Voting_footer_file = "$TPL/date.footer";
$Elections_Voting_title = 'Elections Voting';
$Elections_Voting_table = 'election0voting';

#
# Proposals_Voting
#
$Proposals_Voting = 'voting';
$Proposals_Voting_header_file = "$TPL/single.header";
$Proposals_Voting_footer_file = "$TPL/date.footer";
$Proposals_Voting_title = 'Proposals Voting';
$Proposals_Voting_table = 'proposal0voting';

#
# Motions_Voting
#
$Motions_Voting = 'voting';
$Motions_Voting_header_file = "$TPL/single.header";
$Motions_Voting_footer_file = "$TPL/date.footer";
$Motions_Voting_title = 'Motions Voting';
$Motions_Voting_table = 'motion0voting';

1