Reg By The Numbers
As of January 2024
MySQL Database
68 tables 834 columns
265 strings for configurations
the record counts of a few selected tables:
user 324
people 86,775 - first one entered 12/22/1982
grid 23,006
event 1,522
program 2,444 - first one started on 11/03/1989
rental 1,516 - first one started on 3/5/1996
registration 102,619
rental_payment 1,713 total $11,403,669
reg_payment 131,992 total $26,219,269
mmi_payment 23,157 total $3,699,632
xaccount_payment 8,664 total $1,476,367
total payments $42,798,937
proposal 331 from 4/2009 to 11/2018
inquiry 548 since June 2022
Perl
cgi-bin scripts on akash - moved from mmc.org - began June 2022
plus authorize.net => Stripe
39 scripts total 7,542 lines
controller .pm
43 files total 31,596 lines
model .pm
68 files total 7,108 lines
lib .pm
19 files total 5,717 lines
catalyst script dir
33 files total 2,870 lines
TOTAL 202 files 54,833 lines
src bin/sh scripts
25 files total 153 lines
templates .tt2
in root/src
336 files total 19,194 lines
in cgi-bin/
42 files total 3,572 lines
in letter/
38 files total 3,283 lines
TOTAL 416 files 26,049 lines
style sheets .css
10 files total 1,328 lines
help files .html
55 files total 9,000 lines
timelogs
35 invoices 2007-2020
3,178 hours at $50 per hour = $158,895
RG’s “terms and conditions”
6,599 words