· 6 years ago · Jun 10, 2019, 08:20 PM
1$$\ $$\ $$$$$$\
2$$$\ $$ | $$ __$$\
3$$$$\ $$ | $$$$$$\ $$\ $$\ $$\ $$ / \__| $$$$$$\ $$$$$$$\
4$$ $$\$$ |$$ __$$\ $$ | $$ | $$ |\$$$$$$\ $$ __$$\ $$ _____|
5$$ \$$$$ |$$$$$$$$ |$$ | $$ | $$ | \____$$\ $$$$$$$$ |$$ /
6$$ |\$$$ |$$ ____|$$ | $$ | $$ |$$\ $$ |$$ ____|$$ |
7$$ | \$$ |\$$$$$$$\ \$$$$$\$$$$ |\$$$$$$ |\$$$$$$$\ \$$$$$$$\
8\__| \__| \_______| \_____\____/ \______/ \_______| \_______|
9
10
11
12$$$$$$$\ $$$$$$\ $$\
13$$ __$$\ $$ __$$\ $$ |
14$$ | $$ | $$$$$$\ $$$$$$\$$$$\ $$$$$$\ $$$$$$$\ $$ / \__| $$$$$$\ $$$$$$$ |
15$$ | $$ |$$ __$$\ $$ _$$ _$$\ $$ __$$\ $$ __$$\ \$$$$$$\ \____$$\ $$ __$$ |
16$$ | $$ |$$$$$$$$ |$$ / $$ / $$ |$$ / $$ |$$ | $$ | \____$$\ $$$$$$$ |$$ / $$ |
17$$ | $$ |$$ ____|$$ | $$ | $$ |$$ | $$ |$$ | $$ |$$\ $$ |$$ __$$ |$$ | $$ |
18$$$$$$$ |\$$$$$$$\ $$ | $$ | $$ |\$$$$$$ |$$ | $$ |\$$$$$$ |\$$$$$$$ |\$$$$$$$ |
19\_______/ \_______|\__| \__| \__| \______/ \__| \__| \______/ \_______| \_______|
20
21
22
23
24----------------------------------------------------------------------------------------------------------------------------
25
26Target : http://uic.edu/ ( Universidade de Illinois )
27
28Database, Tables, Columns Dumpeds
29
30By : DemonSad | NewSec Group | We Are : DemonSad, Kami, NedLock, Silv3r
31
32"TE APRESENTO A TROPA QUE DERRUBA O SUPER MAN"
33
34----------------------------------------------------------------------------------------------------------------------------
35/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
36/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
37/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
38/*!40101 SET NAMES utf8 */;
39
40--
41-- Database: `openreg`
42--
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `openreg_affiliations`
48--
49
50DROP TABLE IF EXISTS `openreg_affiliations`;
51CREATE TABLE IF NOT EXISTS `openreg_affiliations` (
52 `type` char(8) NOT NULL,
53 `class` varchar(12) NOT NULL,
54 `description` varchar(16) NOT NULL,
55 PRIMARY KEY (`type`)
56) ENGINE=MyISAM DEFAULT CHARSET=utf8;
57
58--
59-- Dumping data for table `openreg_affiliations`
60--
61
62INSERT INTO `openreg_affiliations` (`type`, `class`, `description`) VALUES
63('AA', 'AA_ALANON', 'AA'),
64('ALANON', 'AA_ALANON', 'Al-Anon'),
65('ALATEEN', 'ALATEEN', 'Alateen'),
66('GUEST', 'AA_ALANON', 'Guest'),
67('UNDER8', 'CHILD', 'Guest (Under 8)');
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `openreg_configuration`
73--
74
75DROP TABLE IF EXISTS `openreg_configuration`;
76CREATE TABLE IF NOT EXISTS `openreg_configuration` (
77 `configParameter` char(16) NOT NULL,
78 `configValue` text NOT NULL,
79 `configType` varchar(16) NOT NULL,
80 `configDescription` text NOT NULL,
81 `configCatagory` varchar(16) NOT NULL,
82 PRIMARY KEY (`configParameter`)
83) ENGINE=MyISAM DEFAULT CHARSET=utf8;
84
85--
86-- Dumping data for table `openreg_configuration`
87--
88
89INSERT INTO `openreg_configuration` (`configParameter`, `configValue`, `configType`, `configDescription`, `configCatagory`) VALUES
90('apiPsswd', 'T43VGU6H7R4TV922', 'string', 'Your <em>real</em> API password at PayPal.', 'PayPal'),
91('apiPsswdSandbox', '3asMLEAXKCTi9abD', 'string', 'Your <em>sandbox</em> API password at PayPal.', 'PayPal'),
92('apiSig', 'vUq2nGGvXbD0btjkxzASHGFrRFshNHha9hLZ5vmn304Yg4yclU6CcZjJ', 'string', 'Your <em>real</em> API signature at PayPal.', 'PayPal'),
93('apiSigSandbox', 'Gx10IYEXimFFNUtVSoHCOVOMZoXQPvV0NUu1hVcO6howmr7NMouZCcqasCrhdnYm', 'string', 'Your <em>sandbox</em> api signature at PayPal.', 'PayPal'),
94('apiUser', 'zk09w_api1.lrmvbkjofs.com', 'string', 'Your <em>real</em> API user name at PayPal.', 'PayPal'),
95('apiUserSandbox', 'rxmwz_4525726954_biz_api1.cjqzewjwgu.com', 'string', 'Your <em>sandbox</em> API user name at PayPal.', 'PayPal'),
96('cnfURL', 'http://your.host.org/openreg/default.php?pge=cnf', 'URL', 'The fully-qualified URL of the confirmation page. Be sure to use http: or https: depending on if your site is secure.', 'PayPal'),
97('regURL', 'http://your.host.org/openreg/default.php?pge=reg', 'URL', 'The fully-qualified URL of the registration page. Be sure to use http: or https: depending on if your site is secure.', 'PayPal'),
98('rvwURL', 'http://your.host.org/openreg/default.php?pge=rvw', 'URL', 'The fully-qualified URL of the order review page. Be sure to use http: or https: depending on if your site is secure.', 'PayPal'),
99('sandboxFlag', '1', 'boolean', '<em>Important:</em> Leaving this selection empty (false) will result in your site going live.<br />\r\nNULL, 0, false = false<br />\r\n1, any other value = true<br />\r\n', 'PayPal'),
100('cookieExpires', '14', 'integer', 'Number of days the user''s registration stays active.', 'Registration'),
101('envLimit', '10', 'integer', 'Limit of registration forms that can be put in an envelope.', 'Registration'),
102('regClosed', '2010-10-22 00:00:00', 'datetime', 'Date and time registration closes. Any valid date and/or time format will work. For instance, "11/20" or "11/20/2009 9:00 am".', 'Registration'),
103('regClosedPage', '', 'URL', 'Custom "Closed" page. Leave blank to use OpenReg standard "Closed" page.', 'Registration'),
104('regOpen', '2010-06-14 09:00:00', 'datetime', 'Date and time registration opens. Any valid date and/or time format will work. For instance, "11/20" or "11/20/2009 9:00 am".', 'Registration'),
105('footer', '/includes/footer.htm', 'URL', 'Relative path off the document root of the site''s footer for inclusion on OpenReg pages.', 'Site'),
106('header', '/includes/header.htm', 'URL', 'Relative path off the document root of the site''s header for inclusion on OpenReg pages.', 'Site'),
107('language', 'en', 'string', 'The two character language definition of the site.', 'Site'),
108('menu', '/includes/menu.htm', 'URL', 'Relative path off the document root of the site''s menu for inclusion on OpenReg pages.', 'Site'),
109('siteName', 'Project OpenReg', 'string', 'Then name of the site, for inclusion in the title bar.', 'Site'),
110('siteStyle', '', 'URL', 'Relative path off the document root of the site''s style sheet for inclusion on OpenReg pages.', 'Site'),
111('stylesheet', 'openreg', 'string', 'Name of the current OpenReg style sheet.', 'Site'),
112('defaultPassword', '4cb9c8a8048fd02294477fcb1a41191a', 'string', 'The MD5 hash key of the default password for new users.<br>\r\n* For ''password'' use<br> 5f4dcc3b5aa765d61d8327deb882cf99<br>\r\n* For ''changeme'' use<br>\r\n4cb9c8a8048fd02294477fcb1a41191a<br>\r\n* For ''swingset'' use<br>\r\n5aeba6480e1d86b423fe3cb7456f41c7', 'Administration'),
113('forceHttps', '', 'boolean', 'Set to;<br />* (blank), 0, false = HTTP<br />\r\n* 1, any other value = force the<br /> site to HTTPS.<br />\r\nThis does NOT affect the /admin pages.\r\n', 'Site');
114
115-- --------------------------------------------------------
116
117--
118-- Table structure for table `openreg_envelope`
119--
120
121DROP TABLE IF EXISTS `openreg_envelope`;
122CREATE TABLE IF NOT EXISTS `openreg_envelope` (
123 `envelopeID` int(8) NOT NULL,
124 `noOfForms` int(2) NOT NULL,
125 `amount` decimal(5,2) NOT NULL,
126 `regInProgressID` char(32) NOT NULL,
127 `paypalTransactionID` char(32) NOT NULL,
128 `paypalOrderTime` datetime NOT NULL,
129 `paypalBillTo` tinytext NOT NULL,
130 `paypalEmail` tinytext NOT NULL,
131 `paypalStatus` tinytext NOT NULL,
132 `paypalPendReason` tinytext NOT NULL,
133 PRIMARY KEY (`envelopeID`),
134 KEY `regInProgressID` (`regInProgressID`),
135 KEY `paypalTransactionID` (`paypalTransactionID`)
136) ENGINE=MyISAM DEFAULT CHARSET=utf8;
137
138--
139-- Dumping data for table `openreg_envelope`
140--
141
142INSERT INTO `openreg_envelope` (`envelopeID`, `noOfForms`, `amount`, `regInProgressID`, `paypalTransactionID`, `paypalOrderTime`, `paypalBillTo`, `paypalEmail`, `paypalStatus`, `paypalPendReason`) VALUES
143(20100000, 0, '0.00', '', '2010 Seed Envelope', '0000-00-00 00:00:00', '', '', '', '');
144
145-- --------------------------------------------------------
146
147--
148-- Table structure for table `openreg_form`
149--
150
151DROP TABLE IF EXISTS `openreg_form`;
152CREATE TABLE IF NOT EXISTS `openreg_form` (
153 `envelopeID` int(8) NOT NULL,
154 `formNo` int(2) NOT NULL,
155 `postDate` date NOT NULL,
156 `firstName` varchar(15) NOT NULL,
157 `lastName` varchar(30) NOT NULL,
158 `address` varchar(45) NOT NULL,
159 `suite` varchar(30) DEFAULT NULL,
160 `city` varchar(30) NOT NULL,
161 `state` varchar(2) NOT NULL,
162 `postalCode` varchar(10) NOT NULL,
163 `phoneNumber` varchar(13) DEFAULT NULL,
164 `eMail` varchar(30) DEFAULT NULL,
165 `specialNeeds` varchar(255) DEFAULT NULL,
166 `other` varchar(255) NOT NULL,
167 `affiliation` varchar(10) NOT NULL,
168 `registrationType` varchar(2) NOT NULL,
169 `amount` decimal(5,2) NOT NULL DEFAULT '0.00',
170 PRIMARY KEY (`envelopeID`,`formNo`),
171 KEY `postalCode` (`postalCode`)
172) ENGINE=MyISAM DEFAULT CHARSET=utf8;
173
174--
175-- Dumping data for table `openreg_form`
176--
177
178
179-- --------------------------------------------------------
180
181--
182-- Table structure for table `openreg_language`
183--
184
185DROP TABLE IF EXISTS `openreg_language`;
186CREATE TABLE IF NOT EXISTS `openreg_language` (
187 `langParameter` varchar(16) NOT NULL,
188 `langValue` text NOT NULL,
189 `langDescription` text NOT NULL,
190 `langCatagory` varchar(16) NOT NULL,
191 PRIMARY KEY (`langParameter`)
192) ENGINE=MyISAM DEFAULT CHARSET=utf8;
193
194--
195-- Dumping data for table `openreg_language`
196--
197
198INSERT INTO `openreg_language` (`langParameter`, `langValue`, `langDescription`, `langCatagory`) VALUES
199('en-errEmail', 'E-mail address must be in the format your.name@yourdomain.com.<br />', 'Invalid E-Mail address format.', 'Error'),
200('en-errRegType', 'Please select an appropriate registration (ie; Alateen => Pizza Party).<br />', 'Invalid registration type.', 'Error'),
201('en-errNoRegType', 'Please select a registration type (Conference only, Conference and Banquet, etc).<br />', 'No registration type selected.', 'Error'),
202('en-errState', 'Please select a state.<br />', 'No state selected.', 'Error'),
203('en-errAffil', 'Please select an affiliation (AA, Al-Anon, Guest, etc).<br />', 'No affiliation selected.', 'Error'),
204('en-currency', '$', 'Symbol for the US dollar', 'General'),
205('en-clsInstruct', '<h3>Sorry, but registration is closed.</h3>\r\nWalk-in registration will be available at the event.', 'Instructions that appear on the registration closed page. HTML is permitted. You may want to create your instructions on a blank page and cut-and-paste them here.', 'Instructions'),
206('en-cnfGoodbye', '<h3><em>See you at the conference!</em></h3>', 'Text that appears at the bottom of the confirmation page after the user is registered. HTML is permitted. You may want to create your instructions on a blank page and cut-and-paste them here.', 'Instructions'),
207('en-cnfInstruct', '<h3>Thank you for registering!</h3>\r\n<p>Please <a href=\\"\\" onclick=\\"window.print();return false;\\">[print]</a> this page and bring it with you.</p>', 'Instructions that appear on the order confirmation page. HTML is permitted. You may want to create your instructions on a blank page and cut-and-paste them here.', 'Instructions'),
208('en-instructions', '<table border=\\"0\\">\r\n<tr>\r\n<td colspan=\\"2\\">\r\nThis is your on-line registration "envelope". If you prefer the US Postal Service, you may print out <a target=\\"_blank\\" href=\\"images/registration2010.pdf\\">registration forms (pdf)</a> and mail them with a check made out to "The Conference"\r\n<ul>\r\n<li>Add attendees by filling out the form and clicking [Add / Update].</li>\r\n<li>You may copy a form by [Edit]ing it and clicking the [Copy] button.</li>\r\n<li>You may remove a form by [Edit]ing it and clicking the [Remove] button.</li>\r\n<li>Attendees who are registered together will be seated together.</li>\r\n<li>Each table seats 10, so you may purchase up to 10 registrations at a time.</li>\r\n<li>When you are done filling your envelope, you may pay using PayPal.</li>\r\n<li>PayPal allows you to pay by various means including your credit card.</li>\r\n</ul>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td>\r\n<!-- PayPal Logo --><table border=\\"0\\" cellpadding=\\"10\\" cellspacing=\\"0\\" align=\\"center\\">\r\n<tr>\r\n<td align=\\"center\\"></td>\r\n</tr>\r\n<tr>\r\n<td align=\\"center\\">\r\n<a href=\\"#\\" onclick=\\"javascript:window.open(\\''https://www.paypal.com/us/cgi-bin/webscr?cmd=xpt/Marketing/popup/OLCWhatIsPayPal-outside\\'',\\''olcwhatispaypal\\'',\\''toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=yes, width=400, height=350\\'');\\">\r\n<img src=\\"https://www.paypal.com/en_US/i/logo/PayPal_mark_60x38.gif\\" border=\\"0\\" alt=\\"Acceptance Mark\\"></a> </td>\r\n</tr>\r\n</table>\r\n<!-- PayPal Logo --></td>\r\n<td align=\\"center\\">When you have completed adding conference participants, you may pay using <a target=\\"_blank\\" href=\\"https://www.paypal.com/\\">PayPal's secure services</a>. If you don\\''t have a PayPal account, you may go there first and sign up or you may sign up when you click the [Check out with PayPal] button.</td>\r\n</tr>\r\n</table>', 'Instructions that appear on registration page. HTML is permitted. You may want to create your instructions on a blank page and cut-and-paste them here.', 'Instructions'),
209('en-rvwInstruct', '<h3>Please review and confirm your order</h3>\r\n<p><em><strong>Important:</strong></em> Your order will not processed until you follow the "Confirm" link below. You may return to the first page and edit your order by clicking the "Reject" link.</p>\r\n<p>If the registration is to you liking, please click the "Confirm" link and we will process it.</p>', 'Instructions that appear on the order review page. HTML is permitted. You may want to create your instructions on a blank page and cut-and-paste them here.', 'Instructions'),
210('en-pyiInstruct', '<h3>Please enter payment information</h3><p><em><strong>Important:</strong></em> Enter and review the information. If it is correct, click the [Complete Order] link. If information looks incorrect, you may click the [Modify Order] link and correct it.</p>\r\n', 'Instructions that appear on the payment information page. HTML is permitted. You may want to create your instructions on a blank page and cut-and-paste them here.', 'Instructions'),
211('en-pend-echeck', 'The payment is pending because it was made by an eCheck that has not yet cleared. You will receive an e-mail from PayPal in 3 to 5 days when the transaction is complete.', 'PayPal ''eCheck'' pending reason.', 'PayPal'),
212('en-cnfTitle', 'Confirm Your Order', 'The title of the registration confirmation page.', 'Title'),
213('en-clsTitle', 'Registration Is Closed', 'The title of the registration closed page.', 'Title'),
214('en-regTitle', 'Registration', 'The title of the registration page.', 'Title'),
215('en-rvwTitle', 'Review Your Order', 'The title of the registration review page.', 'Title'),
216('en-pyiTitle', 'Enter Payment Information', 'The title of the payment information page.', 'Title');
217
218-- --------------------------------------------------------
219
220--
221-- Table structure for table `openreg_limits`
222--
223
224DROP TABLE IF EXISTS `openreg_limits`;
225CREATE TABLE IF NOT EXISTS `openreg_limits` (
226 `code` char(1) NOT NULL,
227 `description` tinytext NOT NULL,
228 `byOrder` int(1) NOT NULL,
229 `byRegType` int(1) NOT NULL,
230 `byConference` int(1) NOT NULL,
231 `limit` int(5) NOT NULL,
232 `limitText` varchar(255) NOT NULL,
233 PRIMARY KEY (`code`)
234) ENGINE=MyISAM DEFAULT CHARSET=utf8;
235
236--
237-- Dumping data for table `openreg_limits`
238--
239
240INSERT INTO `openreg_limits` (`code`, `description`, `byOrder`, `byRegType`, `byConference`, `limit`, `limitText`) VALUES
241('A', 'Table total', 1, 1, 0, 10, 'Sorry, but the you may only register dinner guests in groups of 10.'),
242('B', 'Diner total', 0, 1, 1, 1200, 'Sorry, but the dinner is sold out.'),
243('C', 'Conference total', 0, 0, 1, 2400, 'Sorry, but the conference is sold out.');
244
245-- --------------------------------------------------------
246
247--
248-- Table structure for table `openreg_other`
249--
250
251DROP TABLE IF EXISTS `openreg_other`;
252CREATE TABLE IF NOT EXISTS `openreg_other` (
253 `type` varchar(2) NOT NULL,
254 `description` tinytext NOT NULL,
255 PRIMARY KEY (`type`)
256) ENGINE=MyISAM DEFAULT CHARSET=utf8;
257
258--
259-- Dumping data for table `openreg_other`
260--
261
262INSERT INTO `openreg_other` (`type`, `description`) VALUES
263('Y1', 'First year?'),
264('AC', 'Address change?');
265
266-- --------------------------------------------------------
267
268--
269-- Table structure for table `openreg_reg_types`
270--
271
272DROP TABLE IF EXISTS `openreg_reg_types`;
273CREATE TABLE IF NOT EXISTS `openreg_reg_types` (
274 `type` varchar(2) NOT NULL,
275 `amount` decimal(5,2) NOT NULL,
276 `description` varchar(45) NOT NULL,
277 `class` varchar(10) NOT NULL,
278 `disable` int(1) NOT NULL,
279 PRIMARY KEY (`type`)
280) ENGINE=MyISAM DEFAULT CHARSET=utf8;
281
282--
283-- Dumping data for table `openreg_reg_types`
284--
285
286INSERT INTO `openreg_reg_types` (`type`, `amount`, `description`, `class`, `disable`) VALUES
287('AB', '50.00', 'Alateen Conference and Banquet', 'ALATEEN', 0),
288('AC', '20.00', 'Alateen Conference Only', 'ALATEEN', 0),
289('AP', '25.00', 'Alateen Pizza Party/Water Park w/Conference', 'ALATEEN', 0),
290('BC', '50.00', 'AA/Alanon/Guest Banquet and Conference', 'AA_ALANON', 0),
291('CO', '20.00', 'AA/Alanon/Guest Conference Only', 'AA_ALANON', 0),
292('U8', '0.00', 'Guest Under 8 Years Old', 'CHILD', 0);
293
294-- --------------------------------------------------------
295
296--
297-- Table structure for table `openreg_roles`
298--
299
300DROP TABLE IF EXISTS `openreg_roles`;
301CREATE TABLE IF NOT EXISTS `openreg_roles` (
302 `name` varchar(16) NOT NULL,
303 `description` varchar(255) NOT NULL,
304 `permissions` int(11) NOT NULL,
305 PRIMARY KEY (`name`)
306) ENGINE=MyISAM DEFAULT CHARSET=utf8;
307
308--
309-- Dumping data for table `openreg_roles`
310--
311
312INSERT INTO `openreg_roles` (`name`, `description`, `permissions`) VALUES
313('admin-full', 'Admin with PayPal and User rights', 15),
314('admin', 'Admin', 3),
315('admin-paypal', 'Admin with PayPal rights', 7),
316('manager', 'Manager - reporting rights', 1),
317('manager-paypal', 'Manager with PayPal rights', 5);
318
319-- --------------------------------------------------------
320
321--
322-- Table structure for table `openreg_special_needs`
323--
324
325DROP TABLE IF EXISTS `openreg_special_needs`;
326CREATE TABLE IF NOT EXISTS `openreg_special_needs` (
327 `type` varchar(2) NOT NULL,
328 `description` tinytext NOT NULL,
329 PRIMARY KEY (`type`)
330) ENGINE=MyISAM DEFAULT CHARSET=utf8;
331
332--
333-- Dumping data for table `openreg_special_needs`
334--
335
336INSERT INTO `openreg_special_needs` (`type`, `description`) VALUES
337('WC', 'Wheel Chair'),
338('VG', 'Vegetarian Meal'),
339('HR', 'Hearing Impaired'),
340('BL', 'Blind'),
341('GL', 'Gluten Free'),
342('DI', 'Diabetic');
343
344-- --------------------------------------------------------
345
346--
347-- Table structure for table `openreg_users`
348--
349
350DROP TABLE IF EXISTS `openreg_users`;
351CREATE TABLE IF NOT EXISTS `openreg_users` (
352 `name` char(32) NOT NULL,
353 `realName` varchar(45) NOT NULL,
354 `eMail` varchar(30) NOT NULL,
355 `password` char(32) NOT NULL,
356 `role` varchar(16) NOT NULL,
357 PRIMARY KEY (`name`)
358) ENGINE=MyISAM DEFAULT CHARSET=utf8;
359
360--
361-- Dumping data for table `openreg_users`
362--
363
364INSERT INTO `openreg_users` (`name`, `realName`, `eMail`, `password`, `role`) VALUES
365('superadmin', 'Add your own ID and delete this one', 'none@none.none', '4cb9c8a8048fd02294477fcb1a41191a', 'admin-full');
366
367-- --------------------------------------------------------
368
369--
370-- Table structure for table `openreg_us_states`
371--
372
373--