Welcome to Ronald

and the wonderful world of PHP.


There seems to be a few quirks about running PHP scripts on Ronald.

PHP Manual
Connected to Host: ronald.cori.missouri.edu, Database: cori_test.
First 10 Records from cori_test.Doc_File
1 0000950137-03-000043.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR S-3 2004-04-03 2003-01-03 0 440937 1 0 F
2 0000950123-03-000047.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 13D/A 2004-04-03 2003-01-03 0 35365 2 0 F
3 0001021408-03-000045.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-03-22 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 382809 14 0 F
4 0000893220-03-000009.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 14D9/A 2004-04-03 2003-01-03 0 11944 2 0 F
5 0001014897-03-000001.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 5748 2 0 F
6 0000950133-03-000007.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 137998 1 0 F
7 0000902664-03-000013.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 13D/A 2004-04-03 2003-01-03 0 63369 1 0 F
8 0001020242-03-000012.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 64666 1 0 F
9 0001020242-03-000013.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 62195 1 0 F
10 0000807249-03-000007.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 13D/A 2004-04-03 2003-01-03 0 33386 2 0 F


Second 10 Records from cori_test.Doc_File
11 0001020242-03-000018.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 90796 1 0 F
12 0001020242-03-000019.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 74971 1 0 F
13 0000892251-03-000002.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 13D/A 2004-04-03 2003-01-03 0 12805 1 0 F
14 0001171520-03-000004.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 14970 3 0 F
15 0001047469-03-000104.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 13D/A 2004-04-03 2003-01-03 0 33890 1 0 F
16 0001200876-03-000002.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 13D/A 2004-04-03 2003-01-03 0 21969 1 0 F
17 0000950144-03-000084.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 13D/A 2004-04-03 2003-01-03 0 88990 1 0 F
18 0000950134-03-000132.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K/A 2004-04-03 2003-01-03 0 113530 6 0 F
19 0000950134-03-000140.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 5629 1 0 F
20 0001035675-03-000003.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 16594 1 0 F




Connected to Host: ronald.cori.missouri.edu, Database: cori_test.
First 30 Records from test.Tracking
1 1 2004-04-05 04:18:25 Login
328 26 2004-03-22 10:15:00 Archive 439
327 26 2004-03-22 10:14:58 View 439
326 26 2004-03-22 10:14:02 Archive 336
325 26 2004-03-22 10:13:59 View 336
324 26 2004-03-22 10:13:36 Archive 437
323 26 2004-03-22 10:13:32 View 437
322 26 2004-03-22 10:11:20 Archive 337
321 26 2004-03-22 10:10:26 View 337
320 26 2004-03-22 10:09:36 Archive 435
319 26 2004-03-22 10:09:30 View 435
318 26 2004-03-22 10:09:05 Archive 434
317 26 2004-03-22 10:09:00 View 434
316 26 2004-03-22 10:08:08 Archive 2371
315 26 2004-03-22 10:08:01 View 2371
314 26 2004-03-22 10:03:13 Archive 335
313 26 2004-03-22 10:03:10 View 335
312 26 2004-03-22 10:02:23 Archive 201
311 26 2004-03-22 10:00:43 View 201
310 26 2004-03-22 10:00:42 Submit 201 2446
309 26 2004-03-22 09:58:17 View 201
308 26 2004-03-22 09:58:15 Submit 201 2445
307 26 2004-03-22 09:57:39 View 201
306 26 2004-03-22 09:57:38 Submit 201 2444
305 26 2004-03-22 09:56:59 View 201
304 26 2004-03-22 09:56:57 Submit 201 2443
303 26 2004-03-22 09:56:05 View 201
302 26 2004-03-22 09:56:03 Submit 201 2442
301 26 2004-03-22 09:54:03 View 201
300 26 2004-03-22 09:54:01 Submit 201 2441


Third 10 Records from cori_test.Doc_File
21 0001047469-03-000277.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 79717 5 0 F
22 0000892626-03-000002.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 10405 2 0 F
23 0000950152-03-000056.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 4187 1 0 F
24 0000899243-03-000006.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 9959 2 0 F
25 0001035704-03-000009.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR SC 13D/A 2004-04-03 2003-01-03 0 41129 3 0 F
26 0000931763-03-000011.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 12503 1 0 F
27 0001116679-03-000004.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 46075 3 0 F
28 0000950137-03-000026.txt /usr2/cori/docs/raw/finished/ 2004-03-04 1900-01-01 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 6679 2 0 F
29 0001045829-03-000002.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 53989 4 0 F
30 0000950144-03-000045.txt /usr2/cori/docs/raw/finished/ 2004-03-04 2004-04-05 2005-10-27 Finished-2003-01 EDGAR 8-K 2004-04-03 2003-01-03 0 7236 1 0 F




SELECT Attachment_Type, Attachment_Name, Contract_Score, Has_Contract, Exhibit_ID FROM Attachment LEFT JOIN Exhibit_Type et ON TRIM(et.Description) = IF( INSTR(Attachment_Type, '.')>0, LEFT(Attachment_Type, INSTR(Attachment_Type, '.')-1), TRIM(Attachment_Type) ) LIMIT 0,30
EX-2.3 FIRST AMENDMENT TO SETTLEMENT AGREEMENT##d02286a2exv2w3.txt Y 30
EX-2.4 AMENDED AND RESTATED PROMISSORY NOTE##d02286a2exv2w4.txt Y 30
EX-2.5 SECURED PROMISSORY NOTE##d02286a2exv2w5.txt Y 30
EX-2.6 SECURITY AGREEMENT##d02286a2exv2w6.txt Y 30
EX-99.B STOCK PURCHASE AGREEMENT##d02314exv99wb.txt Y 32
EX-4.3 INDENTURE##y65390a1exv4w3.txt Y 31
EX-4.6 FORM OF SPECIMEN GLOBAL NOTE##y65390a1exv4w6.txt Y 31
EX-4.7 REGISTRATION RIGHTS AGREEMENT##y65390a1exv4w7.txt Y 31
EX-10.8 CREDIT AGREEMENT##y65390a1exv10w8.txt Y 25
EX-10.9 CREDIT AGREEMENT##y65390a1exv10w9.txt Y 25
EX-10.14 PURCHASE AGREEMENT##y65390a1exv10w14.txt Y 25
EX-10.15 AMENDMENT TO KCS MANAGEMENT SERVICES AGREEMENT##y65390a1exv10w15.txt Y 25
EX-10.16 AGREEMENT RELATING TO TFM''S PURCHASE OF EQUITY##y65390a1exv10w16.txt Y 25
EX-99.4 FORM OF EXCHANGE AGENT AGREEMENT##y65390a1exv99w4.txt Y 32
EX-2.1 ARTICLES OF AMENDMENT##g80088exv2w1.txt Y 30
EX-4.1 SUBSCRIPTION AGREEMENT##g80088exv4w1.txt Y 31
EX-4.1 EXHIBIT 4.1##a2100012zex-4_1.txt Y 31
EX-10.0 EXHIBIT 10.0##a2100012zex-10_0.txt Y 25
EX-10.1 EXHIBIT 10.1##a2100012zex-10_1.txt Y 25
EX-10.14 EXHIBIT 10.14 REINSURANCE AGREEMENT##l96558cexv10w14.txt Y 25
EX-2 COMMON STOCK PURCHASE AGREEMENT##w70832exv2.txt Y 30
EX-3 PUT AND RIGHT OF FIRST REFUSAL AGREEMENT##w70832exv3.txt Y 28
EX-2.4 AMENDED PURCHASE AGREEMENT##b44556a2exv2w4.txt Y 30
EX-10.7 DISTRIBUTION AGREEMENT##b44556a2exv10w7.txt Y 25
EX-10.26 VESTING AGREEMENT##b44556a2exv10w26.txt Y 25
EX-10.27 LETTER DATED JULY 7, 2007##b44556a2exv10w27.txt Y 25
EX-10.29 LETTER OF INTENT##b44556a2exv10w29.txt Y 25
EX-99 EXHIBIT 99.1##exh99_1.txt Y 32
EX-99 EXHIBIT 99.2##exh99_2.txt Y 32
EX-2 STOCK OPTION AGREEMENT DATED MARCH 16, 2001##dex2.txt Y 30

Associative Array Testing
$query = SELECT * FROM Track WHERE 1 LIMIT 0,10
Track_ID User_ID When_Done Action Doc_File_ID CORI_Contract_ID
1 1 2004-04-05 04:18:25 Login
328 26 2004-03-22 10:15:00 Archive 439
327 26 2004-03-22 10:14:58 View 439
326 26 2004-03-22 10:14:02 Archive 336
325 26 2004-03-22 10:13:59 View 336
324 26 2004-03-22 10:13:36 Archive 437
323 26 2004-03-22 10:13:32 View 437
322 26 2004-03-22 10:11:20 Archive 337
321 26 2004-03-22 10:10:26 View 337
320 26 2004-03-22 10:09:36 Archive 435