# # 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("Rule $number/$revision($vitality) : $title
$text
") . ($history eq "" ? "" : "$history
")'; $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("Rule $number/$revision : $title
$text
") . ($history eq "" ? "" : "$history
")'; $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("Proposal $number/$revision($vitality, $activity) : $title
$text
") . ($history eq "" ? "" : "$history
")'; $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("Proposal $number/$revision($vitality, $activity) : $title
$text
") . ($history eq "" ? "" : "$history
")'; $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("Motion $number/$revision($vitality, $activity) : $title
$text
") . ($history eq "" ? "" : "$history
")'; $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("Motion $number/$revision($vitality, $activity) : $title
$text
") . ($history eq "" ? "" : "$history
")'; $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("Judgment $number/$revision($vitality)

Statement:

$statement
Ruling: $ruling

Plainiff\'s Analysis:

$p_analysis
Judge\'s Analysis and Orders:
$j_analysis
") . ($history eq "" ? "" : "$history
")'; $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("Judgment $number/$revision($vitality)

Statement:

$statement
Ruling: $ruling

Plainiff\'s Analysis:

$p_analysis
Judge\'s Analysis and Orders:
$j_analysis
") . ($history eq "" ? "" : "$history
")'; $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
"'; # # 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
"'; # # 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
"'; # # 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