PageRenderTime 60ms CodeModel.GetById 21ms RepoModel.GetById 1ms app.codeStats 0ms

/cruddy_mysql/cruddy_mysql.php

https://github.com/davidrenne/cruddy_mysql
PHP | 4400 lines | 4166 code | 141 blank | 93 comment | 408 complexity | 14e8a6c0cc2f839665545141e25f6d3d MD5 | raw file

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. 

  3. $pwd = dirname(__FILE__);
    4. 

  4. define("ABS_PATH_TO_CRUDDY_MYSQL_FOLDER",dirname($_SERVER['PHP_SELF']).'/cruddy_mysql/');
    5. 

  5. define("ABS_PATH_HASH",substr(md5(dirname($_SERVER['PHP_SELF']).'/cruddy_mysql/'),0,8));
    6. 

  6. ini_set("memory_limit","256M");
    7. 

  7. set_time_limit(0);
    8. 

  8. set_magic_quotes_runtime(false); // -- dude just dont use magic quotes...
    9. 

  9. function get_microtime_ms() {
    10. 

  10. 	list($usec, $sec) = explode(" ",microtime());
    11. 

  11. 	return ((float)$usec + (float)$sec);
    12. 

  12. }
    13. 

  13. /* constants */
    14. 

  14. 

  15. define("GET_COLUMNS_SQL", "show full columns from %s");
    16. 

  16. define("GET_TABLES_SQL", "show full tables");
    17. 

  17. define("GET_DATABASES_SQL", "show databases");
    18. 

  18. define("UPDATE_SQL","update %s set %s where %s");
    19. 

  19. define("INSERT_SQL","insert into %s(%s) values(%s)");
    20. 

  20. define("TABLE_CONFIG","tableDef");
    21. 

  21. define("CRUD_FIELD_CONFIG","crudConfig");
    22. 

  22. 

  23. // table level keys and configs
    24. 

  24. define("OBJECT_DESC","description"); //high level table description (Keep short)
    25. 

  25. define("OBJECT_ACTIONS","actions"); //array of possible CRUD actions used in switch of controller page
    26. 

  26. define("OBJECT_DEFAULT_ORDER","defaultorder"); //for a generic_read function to handle how the records should be initially sorted
    27. 

  27. define("OBJECT_READ_FILTER","filterrecords"); //initial filter that the main recordset loads as
    28. 

  28. define("OBJECT_HIDE_NEW_LINK","hidenewlink"); //a flag to say whether the table should have a "New" link associated with it
    29. 

  29. define("OBJECT_HIDE_VIEW_LINK","hideviewlink"); //a flag to say whether the table should have a "New" link associated with it
    30. 

  30. define("OBJECT_HIDE_SEARCH_LINK","hidesearchlink");
    31. 

  31. define("OBJECT_HIDE_DETAILS_LINK","hidedetailslink");
    32. 

  32. define("OBJECT_HIDE_EDIT_LINK","hideeditlink");
    33. 

  33. define("OBJECT_HIDE_DELETE_LINK","hidedeletelink");
    34. 

  34. define("OBJECT_DELETE_CHECK_CONSTRAINTS","objdeleteconstraints"); //by default the crud class will loop through all tables and fields and if it finds an identical fieldname in any table in the database and there are records in that table, it will tell the user they cannot delete the only way to bypass this constraint is by setting this to false
    35. 

  35. define("OBJECT_TABLE","table");//table name
    36. 

  36. define("OBJECT_IS_AGGREGATE","aggregateview");//table name
    37. 

  37. define("OBJECT_CONNECTION_STRING","connection");//dba connection string
    38. 

  38. define("OBJECT_PK","primarykey");//primary key hard coded
    39. 

  39. define("OBJECT_FILTER_DESC","filterrecordsdescription");//used when you want to describe what the data is filtered by inside your controller function
    40. 

  40. define("OBJECT_PAGING","pagingenabled");//by default paging is enabled unless you say false here. paging is defaulted to 10 records per page but just need to add new configuration here when needing new functionality
    41. 

  41. define("OBJECT_PAGING_NUM_ROWS_PER_PAGE","pagingrows");
    42. 

  42. define("OBJECT_PAGING_SCROLL","pagingscroll");
    43. 

  43. define("OTHER_OBJECTS", "otherobjects" );//otherobjects allows you to build supporting form objects that will be tacked on at the end of the form before the button to post/update
    44. 

  44. 

  45. define("REQUIRED_TEXT","requiredtext");
    46. 

  46. define("OTHER_LINKS", "otherlinks" );
    47. 

  47. define("EDIT_TEXT","edittext");
    48. 

  48. define("DELETE_TEXT","deletetext");
    49. 

  49. define("TABLE_TEXT","tabletext");
    50. 

  50. define("ADD_TEXT","addtext");
    51. 

  51. define("VIEW_TEXT","viewtext");
    52. 

  52. define("SEARCH_TEXT","searchtext");
    53. 

  53. define("EDIT_LINK", "editlink");
    54. 

  54. define("DELETE_LINK", "deletelink");
    55. 

  55. 

  56. // field level keys and configs
    57. 

  57. 

  58. define("CAPTION","caption"); // what the user sees as the field name
    59. 

  59. 

  60. //these array keys/configurations are for the foreign key lookups definied at the field level
    61. 

  61. define("ID","lookupid");
    62. 

  62. define("TEXT", "lookuptext");
    63. 

  63. define("TABLE", "lookuptable" );
    64. 

  64. define("WHERE", "lookupwhere" );
    65. 

  65. define("SELECT","select");
    66. 

  66. 

  67. define("SHOWCOLUMN","showcolumn");
    68. 

  68. define("COLUMNPOSTTEXT","posttextc");
    69. 

  69. define("SORTABLE","sortable");
    70. 

  70. define("PRETEXTREAD","pretext");
    71. 

  71. define("POSTTEXTREAD","posttext");
    72. 

  72. define("REQUIRED","required");
    73. 

  73. define("UPDATE_READ_ONLY","ronlyupdate");
    74. 

  74. define("HIDE","inserthide");
    75. 

  75. 

  76. define("ROW_ID","number_0x45dsa4654das654da64dsa654da");
    77. 

  77. define("INPUT_DOIT","submit_cruddy_mysql");
    78. 

  78. define("INPUT_SUBMIT","submit_button");
    79. 

  79. 

  80. (include ("$pwd/dbal/dbal.php")) or die("This class require <a href='http://cesars.users.phpclasses.org/dba'>DBA</a> class. Please download it and copy the folder 'dbal' in $pwd");
    81. 

  81. (include ("$pwd/forms.php")) or die("This class require <a href='http://cesars.users.phpclasses.org/formsgeneration'>Forms Generation Class</a> class. Please download it and copy the file 'forms.php' in $pwd");
    82. 

  82. 

  83. 

  84. class cruddyMysql {
    85. 

  85. 

  86. 	function cruddyMysql($str,$table,$info=array()) {
    87. 

  87. 		$pwd = dirname(__FILE__);
    88. 

  88. 		$this->table = $info[TABLE_CONFIG][OBJECT_TABLE];
    89. 

  89. 		$this->conn = $str;
    90. 

  90. 		$this->dba = new dbal($str);
    91. 

  91. 		$this->dba->setCacheDir( "${pwd}/cache/" );
    92. 

  92. 		$this->tableDefinition = $info;
    93. 

  93. 		$this->getTableInformation();
    94. 

  94. 	}
    95. 

  95. 

  96. 	function doQuery($filter) {
    97. 

  97. 		$methodStartTime = get_microtime_ms();
    98. 

  98. 		$res  =  &$this->result;
    99. 

  99. 		$dba  =  &$this->dba;
    100. 

  100. 		$info =  &$this->formParams;
    101. 

  101. 		$definitions = &$this->tableDefinition;
    102. 

  102. 

  103. 		if (!empty($filter)) {
    104. 

  104. 			if ( ( stristr($filter,'=') || stristr($filter,'IN (') ||  stristr($filter,'IN(') ) && !stristr($filter,'where') ) {
    105. 

  105. 				$f = $filter == '' ? '' : ' WHERE '.$filter;
    106. 

  106. 			} else {
    107. 

  107. 				$f = $filter;
    108. 

  108. 			}
    109. 

  109. 		} else {
    110. 

  110. 			$f = $filter;
    111. 

  111. 		}
    112. 

  112. 		$query = "select count(*) as count from ".$this->table." $f";
    113. 

  113. 		$result = @mysql_query($query,$dba->dbm->dbh);
    114. 

  114. 		if ($result) {
    115. 

  115. 			$row = mysql_fetch_array($result);
    116. 

  116. 			$total_records = $row['count'];
    117. 

  117. 		} else {
    118. 

  118. 			$total_records = 0;
    119. 

  119. 		}
    120. 

  120. 		$scroll_page = ($definitions[TABLE_CONFIG][OBJECT_PAGING_NUM_ROWS_PER_PAGE]) ? $definitions[TABLE_CONFIG][OBJECT_PAGING_SCROLL] : 5 ;
    121. 

  121. 		$per_page = ($definitions[TABLE_CONFIG][OBJECT_PAGING_NUM_ROWS_PER_PAGE]) ? $definitions[TABLE_CONFIG][OBJECT_PAGING_NUM_ROWS_PER_PAGE] : 10 ;
    122. 

  122. 		$current_page = $_GET[$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['page']];
    123. 

  123. 		$pager_url = $_SERVER['PHP_SELF']."?action=".strtolower($definitions[TABLE_CONFIG][OBJECT_ACTIONS]['read'].$this->object_key).'&'.$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_field'].'='.$_GET[$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_field']].'&'.$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_direction'].'='.$_GET[$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_direction']].'&'.$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['page'].'=';
    124. 

  124. 		$inactive_page_tag = 'id="current_page"';
    125. 

  125. 		$previous_page_text = '&lt; Previous';
    126. 

  126. 		$next_page_text = 'Next &gt;';
    127. 

  127. 		$first_page_text = '&lt;&lt; First';
    128. 

  128. 		$last_page_text = 'Last &gt;&gt;';
    129. 

  129. 		$crudPage = new cruddyMysqlPager();
    130. 

  130. 		$crudPage->pager_set($pager_url, $total_records, $scroll_page, $per_page, $current_page, $inactive_page_tag, $previous_page_text, $next_page_text, $first_page_text, $last_page_text,'');
    131. 

  131. 		$result = mysql_query(str_replace("count(*) as count","*",$query)." LIMIT ".$crudPage->start.", ".$crudPage->per_page."",$dba->dbm->dbh);
    132. 

  132. 		$definitions[TABLE_CONFIG][OBJECT_PAGING] =  $crudPage;
    133. 

  133. 

  134. 		if ($result) {
    135. 

  135. 			while ($row = mysql_fetch_assoc($result)) {
    136. 

  136. 				$res[] = $row;
    137. 

  137. 			}
    138. 

  138. 		} else {
    139. 

  139. 			//if ($this->cruddyAdministrator) {
    140. 

  140. 				echo ("ERROR: ".$dba->getLastError());
    141. 

  141. 			//}
    142. 

  142. 		}
    143. 

  143. 		$total = (get_microtime_ms() - $methodStartTime);
    144. 

  144. 		$this->performance['doQuery'][] = $total ." sql:".$query;
    145. 

  145. 	}
    146. 

  146. 

  147. 	/**
    148. 

  148. 	 *  Creates a new row.
    149. 

  149. 	 *
    150. 

  150. 	 *  Show the form for create a new row.
    151. 

  151. 	 */
    152. 

  152. 	function create() {
    153. 

  153. 		$this->getTableInformation(true);
    154. 

  154. 		return $this->buildGenericForm(array(),false,"");
    155. 

  155. 	}
    156. 

  156. 

  157. 	/**
    158. 

  158. 	 *  search
    159. 

  159. 	 */
    160. 

  160. 	function search() {
    161. 

  161. 		$this->getTableInformation("search");
    162. 

  162. 		return $this->buildGenericForm(array(),false,"",false,true);
    163. 

  163. 	}
    164. 

  164. 	/**
    165. 

  165. 	 * Generic Form
    166. 

  166. 	 *
    167. 

  167. 	 *  @access private
    168. 

  168. 	 */
    169. 

  169. 	function buildGenericForm($default=array(),$update=false,$update_condition="",$readOnly=false,$search=false) {
    170. 

  170. 		$methodStartTime = get_microtime_ms();
    171. 

  171. 		$form = new form_class;
    172. 

  172. 		$form->NAME= $this->table."_form";
    173. 

  173. 		$form->METHOD="POST";
    174. 

  174. 		$form->ACTION="";
    175. 

  175. 		$form->ENCTYPE="multipart/form-data";
    176. 

  176. 		$form->InvalidCLASS="invalid";
    177. 

  177. 		$form->ResubmitConfirmMessage="Are you sure you want to submit this form again?";
    178. 

  178. 		$form->OptionsSeparator="<br />\n";
    179. 

  179. 		$form->ErrorMessagePrefix="- ";
    180. 

  180. 		$form->ErrorMessageSuffix="";
    181. 

  181. 		foreach($this->formParams as $k => $input)   {
    182. 

  182. 			if ( is_array($default) && count($default) > 0) {
    183. 

  183. 				$input["VALUE"] = $default[$k];
    184. 

  184. 			}
    185. 

  185. 			if ($input["NAME"]) {
    186. 

  186. 				echo $form->AddInput( $input );
    187. 

  187. 			}
    188. 

  188. 		}
    189. 

  189. 		$form->LoadInputValues($form->WasSubmitted(INPUT_DOIT));
    190. 

  190. 

  191. 

  192. 		$verify=array();
    193. 

  193. 		$doit=false;
    194. 

  194. 		$error_message="";
    195. 

  195. 		if($form->WasSubmitted(INPUT_DOIT))  {
    196. 

  196. 			 if(($error_message=$form->Validate($verify))!="") {
    197. 

  197. 				$doit=false;
    198. 

  198. 			 }  else {
    199. 

  199. 				$doit=true;
    200. 

  200. 			 }
    201. 

  201. 		}
    202. 

  202. 

  203. 		if($doit) {
    204. 

  204. 			$dba  = &$this->dba;
    205. 

  205. 

  206. 			// -- get a list of fields that the table can take skip anything else in the post
    207. 

  207. 			$sql  = sprintf(GET_COLUMNS_SQL,$this->table);
    208. 

  208. 			$record = $dba->query($sql);
    209. 

  209. 			if ( !$record )
    210. 

  210. 				return false;
    211. 

  211. 			$Field     = & $record->bindColumn('Field');
    212. 

  212. 			while ( $foo=$record->getNext() ) {
    213. 

  213. 				$tableFields[$Field] = $Field;
    214. 

  214. 			}
    215. 

  215. 			$sql = "";
    216. 

  216. 			$columns=array();
    217. 

  217. 			foreach($this->formParams as $k=>$v) {
    218. 

  218. 				if ( $k == ROW_ID || $k == INPUT_DOIT || $k == INPUT_SUBMIT) continue;
    219. 

  219. 				if (!in_array($k,$tableFields)) {
    220. 

  220. 					// -- found another form element see if there is something to do with it
    221. 

  221. 					continue;
    222. 

  222. 				} else {
    223. 

  223. 					if (strtoupper($v['TYPE']) == 'FILE') {
    224. 

  224. 						$form->GetFileValues($k,$userfile_values);
    225. 

  225. 						if ($userfile_values["name"]) {
    226. 

  226. 							// -- for files, user should be mapping the MIME, MOVE_TO, and SIZE to other fields
    227. 

  227. 							$columns[$k] = $k;
    228. 

  228. 							$values[$k] = $k;
    229. 

  229. 							$_POST[$k] = $userfile_values["name"];
    230. 

  230. 

  231. 							// -- users can store the MIME and FILE_SIZE attributes into a custom field mapping
    232. 

  232. 							// -- FYI there is no edit facility for MIME/SIZE you must convert your config to an array and manually add them to the $field_name_"config" section of the array
    233. 

  233. 							// -- MIME is meant to update another field with the MIME type of the fileupload and expects a field name as the value of the key
    234. 

  234. 							if ($v['MIME']) {
    235. 

  235. 								$columns[$v['MIME']] = $v['MIME'];
    236. 

  236. 								$values[$v['MIME']] = $v['MIME'];
    237. 

  237. 								$_POST[$v['MIME']] = $userfile_values["type"];
    238. 

  238. 							}
    239. 

  239. 

  240. 							if ($v['FILE_SIZE']) {
    241. 

  241. 								$columns[$v['FILE_SIZE']] = $v['FILE_SIZE'];
    242. 

  242. 								$values[$v['FILE_SIZE']] = $v['FILE_SIZE'];
    243. 

  243. 								$_POST[$v['FILE_SIZE']] = $userfile_values["size"];
    244. 

  244. 							}
    245. 

  245. 

  246. 							if (isset($v['MOVE_TO'])) {
    247. 

  247. 								if (@is_uploaded_file($userfile_values["tmp_name"])) {
    248. 

  248. 									if (substr($v['MOVE_TO'],-1))
    249. 

  249. 									if (substr($v['MOVE_TO'],-1) != '/' && strtoupper(substr(PHP_OS,0,3)!='WIN')) {
    250. 

  250. 										$v['MOVE_TO'] .= "/";
    251. 

  251. 									} elseif (substr($v['MOVE_TO'],-1) != "\\" && strtoupper(substr(PHP_OS,0,3)=='WIN')) {
    252. 

  252. 										$v['MOVE_TO'] .= "\\";
    253. 

  253. 									}
    254. 

  254. 									if (!@move_uploaded_file($userfile_values["tmp_name"], $v['MOVE_TO'].$userfile_values["name"])) {
    255. 

  255. 										die("File Upload Failed.  Ensure that {$v['MOVE_TO']} is chmod 777 for new files to overwrite.");
    256. 

  256. 									}
    257. 

  257. 								}
    258. 

  258. 							} else {
    259. 

  259. 								die("Missing MOVE_TO value to move the file");
    260. 

  260. 							}
    261. 

  261. 

  262. 						} else {
    263. 

  263. 

  264. 						}
    265. 

  265. 					} elseif (strtoupper($v['CustomClass']) == 'FORM_DATE_CLASS') {
    266. 

  266. 						$dateValue = $_POST["p_".$k."_year"]."-".$_POST["p_".$k."_month"]."-".$_POST["p_".$k."_day"];
    267. 

  267. 						if (empty($_POST["p_".$k."_year"]) || empty($_POST["p_".$k."_month"])) {
    268. 

  268. 							$dateValue = "";
    269. 

  269. 						}
    270. 

  270. 						$_POST[$k] = $dateValue;
    271. 

  271. 						$values[$k] = $k;
    272. 

  272. 						$columns[$k] = $k;
    273. 

  273. 					} else {
    274. 

  274. 						if ($v["UsesAutoFormName"] ==! false) {
    275. 

  275. 							// -- custom flag for use when widget calls $forms->GenerateInputID()
    276. 

  276. 							$columns[$k] = $k;
    277. 

  277. 							$values[$k] = "p_".$k."_".$v["UsesAutoFormName"];
    278. 

  278. 						} else {
    279. 

  279. 							$columns[$k] = $k;
    280. 

  280. 							$values[$k] = $k;
    281. 

  281. 						}
    282. 

  282. 					}
    283. 

  283. 				}
    284. 

  284. 			}
    285. 

  285. 

  286. 			if ( $update ) {
    287. 

  287. 				$updatx  = array();
    288. 

  288. 				foreach($columns as $k=>$v) {
    289. 

  289. 					if (isset($_POST[$k])) {
    290. 

  290. 						$updatx[] = " $v = :$values[$k]";
    291. 

  291. 					}
    292. 

  292. 				}
    293. 

  293. 				$sql = sprintf(UPDATE_SQL, $this->table,implode(" , ",$updatx),$update_condition);
    294. 

  294. 

  295. 			} else {
    296. 

  296. 				foreach($columns as $k=>$v) {
    297. 

  297. 					if (intval(substr($k,0,1)) > 0) {
    298. 

  298. 						// -- column starts with a number - unsupported
    299. 

  299. 						unset($columns[$k],$values[$k]);
    300. 

  300. 					}
    301. 

  301. 					if (!isset($_POST[$k])) {
    302. 

  302. 						unset($columns[$k],$values[$k]);
    303. 

  303. 					}
    304. 

  304. 				}
    305. 

  305. 				$sql = sprintf(INSERT_SQL, $this->table,implode(", ",$columns),":".implode(", :",$values));
    306. 

  306. 			}
    307. 

  307. 

  308. 			$dba->compile($sql);
    309. 

  309. 

  310. 			// -- support multi-value inserts/updates
    311. 

  311. 			$multi=false;
    312. 

  312. 			foreach ($_POST as $postKey=>$postValue) {
    313. 

  313. 				if (is_array($postValue)) {
    314. 

  314. 					$cnt++;
    315. 

  315. 					$multi=true;
    316. 

  316. 					$multiArray = $postValue;
    317. 

  317. 					$multiArrayKey = $postKey;
    318. 

  318. 				}
    319. 

  319. 			}
    320. 

  320. 

  321. 			if ($cnt != 1 && $multi === true) {
    322. 

  322. 				$error_message="You can only have 1 multi select for each row.";
    323. 

  323. 				return false;
    324. 

  324. 			}
    325. 

  325. 

  326. 			if ($multi === false ) {
    327. 

  327. 				$f = $dba->execute($_POST);
    328. 

  328. 			} else {
    329. 

  329. 				foreach ($multiArray as $insertValue) {
    330. 

  330. 					$_POST[$multiArrayKey] = $insertValue;
    331. 

  331. 					$f = $dba->execute($_POST);
    332. 

  332. 				}
    333. 

  333. 			}
    334. 

  334. 

  335. 			if ( $f ) {
    336. 

  336. 				if ($update) {
    337. 

  337. 					return true;
    338. 

  338. 				} else {
    339. 

  339. 					$lastInsert = mysql_insert_id($this->dba->dbm->dbh);
    340. 

  340. 					$_POST[$this->tableDefinition[TABLE_CONFIG][OBJECT_PK]] = $lastInsert;
    341. 

  341. 					return $lastInsert;
    342. 

  342. 				}
    343. 

  343. 			} else {
    344. 

  344. 				 $str = $dba->getLastError();
    345. 

  345. 				 if ( substr(strtolower($str),0,9) == "duplicate") {
    346. 

  346. 					$error_message="Duplicated data";
    347. 

  347. 					$s = strpos($str,"'")+1;
    348. 

  348. 					$e = strpos($str,"'",$s);
    349. 

  349. 					$err = trim( substr($str,$s,$e-$s) );
    350. 

  350. 					foreach($columns as $k => $v) {
    351. 

  351. 						if ( $err == $_POST[$v])  {
    352. 

  352. 							$verify[$v] = $v;
    353. 

  353. 						}
    354. 

  354. 					}
    355. 

  355. 				 } else {
    356. 

  356. 					$error_message="There was a database error that occurred in saving this record.";
    357. 

  357. 					if ($this->cruddyAdministrator) {
    358. 

  358. 						$error_message = $str;
    359. 

  359. 						echo $dba->__sql;
    360. 

  360. 					}
    361. 

  361. 

  362. 				}
    363. 

  363. 

  364. 			}
    365. 

  365. 		}
    366. 

  366. 		$total = (get_microtime_ms() - $methodStartTime);
    367. 

  367. 		$this->performance['buildGenericForm'][] = $total;
    368. 

  368. 		$this->autoTemplate($form,$error_message,$verify,$update,$readOnly,$search);
    369. 

  369. 		return false;
    370. 

  370. 	}
    371. 

  371. 

  372. 	function update($arr) {
    373. 

  373. 		if ( !is_array($arr) ) return false;
    374. 

  374. 		$filter=Array();
    375. 

  375. 		foreach($arr as $k=>$v) {
    376. 

  376. 			$filter[] ="$k = \"".addslashes($v)."\"";
    377. 

  377. 		}
    378. 

  378. 		$this->doQuery(implode(" && ",$filter));
    379. 

  379. 		return$this->buildGenericForm($this->result[0], true, implode(" && ",$filter) );
    380. 

  380. 	}
    381. 

  381. 

  382. 	function view($arr) {
    383. 

  383. 		if ( !is_array($arr) ) return false;
    384. 

  384. 		$filter=Array();
    385. 

  385. 		foreach($arr as $k=>$v) {
    386. 

  386. 			$filter[] ="$k = \"".addslashes($v)."\"";
    387. 

  387. 		}
    388. 

  388. 		$this->doQuery(implode(" && ",$filter));
    389. 

  389. 		return$this->buildGenericForm($this->result[0], true, implode(" && ",$filter),true);
    390. 

  390. 	}
    391. 

  391. 

  392. 	function delete($arr) {
    393. 

  393. 		if ( !is_array($arr) ) return false;
    394. 

  394. 		$filter=Array();
    395. 

  395. 		foreach($arr as $k=>$v) {
    396. 

  396. 			$filter[] ="$k = \"".addslashes($v)."\"";
    397. 

  397. 		}
    398. 

  398. 		$filter = implode(" && ",$filter);
    399. 

  399. 		$dba  =  &$this->dba;
    400. 

  400. 		$definitions = &$this->tableDefinition;
    401. 

  401. 		$f = $filter == '' ? 'XXXXXXXXX Unsupported XXXXXXXXX' : ' where '.$filter;
    402. 

  402. 		$r = $dba->query(GET_TABLES_SQL);
    403. 

  403. 			if (empty($r)) {
    404. 

  404. 			$parts = explode("/",$this->conn);
    405. 

  405. 			$database = $parts[sizeof($parts)-1];
    406. 

  406. 				$r = $dba->query(GET_TABLES_SQL." from $database");
    407. 

  407. 				if (empty($r)) {
    408. 

  408. 					$r = $dba->query("SHOW TABLES FROM $database");
    409. 

  409. 					if (empty($r)) {
    410. 

  410. 						die("<div class=\"error\">Could not get table listing from $database</div>");
    411. 

  411. 					}
    412. 

  412. 			}
    413. 

  413. 			}
    414. 

  414. 		if ( $r ) {
    415. 

  415. 			$Table     = & $r->bindColumn('Tables_in_'.$dba->info['db']);
    416. 

  416. 			$Type      = & $r->bindColumn('Table_type');
    417. 

  417. 			$dependentRecords = false;
    418. 

  418. 			while ( $foo=$r->getNext() ) {
    419. 

  419. 				if (strtolower($Table) == strtolower($definitions[TABLE_CONFIG][OBJECT_TABLE])) {
    420. 

  420. 					// -- dont check current table
    421. 

  421. 					continue;
    422. 

  422. 				}
    423. 

  423. 				$record2 = $dba->query(sprintf(GET_COLUMNS_SQL,$Table));
    424. 

  424. 				if ( $record2 ) {
    425. 

  425. 					$Field2     = & $record2->bindColumn('Field');
    426. 

  426. 					while ( $foo2=$record2->getNext() ) {
    427. 

  427. 						if ($definitions[TABLE_CONFIG][OBJECT_PK] == $Field2) {
    428. 

  428. 							// -- rules are if you have a table with the same field name and you didnt specify to OBJECT__CHECK_CONSTRAINTS => false
    429. 

  429. 							if ($definitions[TABLE_CONFIG][OBJECT_DELETE_CHECK_CONSTRAINTS] == 1) {
    430. 

  430. 								if ($Type == 'BASE TABLE') {
    431. 

  431. 									foreach($arr as $k=>$v) {
    432. 

  432. 										if ($k == $Field2) {
    433. 

  433. 											$valueWhere = $v;
    434. 

  434. 											break;
    435. 

  435. 										}
    436. 

  436. 									}
    437. 

  437. 									$record3 = $dba->query("SELECT * FROM ".$Table." WHERE ".$Field2." = '".$valueWhere."'");
    438. 

  438. 									if ( $record3->_result != null ) {
    439. 

  439. 										if ($_GET['confirm']==1 && $_GET['table']==$Table) {
    440. 

  440. 											$dba->query("DELETE FROM ".$Table." WHERE ".$Field2." = '".$valueWhere."'");
    441. 

  441. 											header("Location: ".rawurldecode($_GET['redir']));
    442. 

  442. 										} else {
    443. 

  443. 											$dependentRecords = "There are dependent records in \"".$Table."\" and you cannot delete this ".$Field2.".  Would you like to delete these dependent records too?  <a href='".$_SERVER['REQUEST_URI']."&table=$Table&confirm=1&redir=".rawurlencode($_SERVER['REQUEST_URI'])."'>Yes</a>";
    444. 

  444. 										}
    445. 

  445. 									}
    446. 

  446. 								}
    447. 

  447. 							}
    448. 

  448. 						}
    449. 

  449. 					}
    450. 

  450. 				}
    451. 

  451. 			}
    452. 

  452. 			if ($dependentRecords==false) {
    453. 

  453. 				$r = $dba->execute("delete from ".$this->table." $f");
    454. 

  454. 			} else {
    455. 

  455. 				$r = false;
    456. 

  456. 				echo $dependentRecords;
    457. 

  457. 			}
    458. 

  458. 		}
    459. 

  459. 		return $r != false;
    460. 

  460. 	}
    461. 

  461. 

  462. 	function buildSearchWhere($currentTable='') {
    463. 

  463. 		$definitions = &$this->tableDefinition;
    464. 

  464. 		if ($currentTable!='') {
    465. 

  465. 			$definitions = $this->currentAdminDB[CRUD_FIELD_CONFIG][$currentTable];
    466. 

  466. 		}
    467. 

  467. 		foreach($_COOKIE as $k=>$v) {
    468. 

  468. 			if (stristr($k,$definitions[TABLE_CONFIG]['alias']."~")) {
    469. 

  469. 				$column = str_replace($definitions[TABLE_CONFIG]['alias']."~","",$k);
    470. 

  470. 				if (!empty($v) && $v != "null") {
    471. 

  471. 					if (isset($definitions[$column])) {
    472. 

  472. 						// -- valid column config with a search cookie value
    473. 

  473. 						$where .= " AND `$column` like '%".mysql_real_escape_string($v)."%' ";
    474. 

  474. //						if ($definitions[$column][TABLE]) {
    475. 

  475. //							$res = mysql_query("select ".$definitions[$column][TEXT]." from ".$definitions[$column][TABLE]." WHERE `$column` = '".mysql_real_escape_string($v)."'");
    476. 

  476. //							var_dump(mysql_fetch_assoc($res));
    477. 

  477. //						}
    478. 

  478. 						$desc .=  "<div style='-moz-border-radius:8px 8px 8px 8px;border: 3px ridge #485254; float: left;cursor:pointer;' onclick='if (window.confirm(\"Do you want to remove the `".$definitions[$column][CAPTION]."` filter?\")) { eraseCookie(\"$k\"); document.location = document.location; } '><span style='font-size: 19px;color:#7F7F7F;'>".$definitions[$column][CAPTION]."</span>&rarr;<span style='font-size: 19px;color:#7F7F7F;'>\"".$v."\"</span></div><div style='float:left;margin-top:7px;'> + </div>";
    479. 

  479. 					}
    480. 

  480. 					if (!isset($definitions[$column]) && $currentTable!='') {
    481. 

  481. 						$desc = '';
    482. 

  482. 						$where = '';
    483. 

  483. 					}
    484. 

  484. 				}
    485. 

  485. 			}
    486. 

  486. 		}
    487. 

  487. 		$desc = substr($desc,0,-49);
    488. 

  488. 		return array($where,$desc);
    489. 

  489. 	}
    490. 

  490. 	/**
    491. 

  491. 	 *  READ
    492. 

  492. 	 *  @param string $filter SQL filter.
    493. 

  493. 	 */
    494. 

  494. 	function read($filter='') {
    495. 

  495. 		$methodStartTime = get_microtime_ms();
    496. 

  496. 		$definitions = &$this->tableDefinition;
    497. 

  497. 		list($wh,$desc) = $this->buildSearchWhere();
    498. 

  498. 		if (!stristr($filter,"order")) {
    499. 

  499. 			$filter .= $wh;
    500. 

  500. 		} elseif ($wh) {
    501. 

  501. 			$filter = str_replace("1=1","1=1 $wh", $filter);
    502. 

  502. 		}
    503. 

  503. 		if (!empty($definitions[TABLE_CONFIG][OBJECT_DEFAULT_ORDER]) && !stristr($filter,"order")) {
    504. 

  504. 			$filter .= " ORDER BY `".$definitions[TABLE_CONFIG][OBJECT_DEFAULT_ORDER]."`";
    505. 

  505. 		}
    506. 

  506. 		
    507. 

  507. 		$this->doQuery($filter);
    508. 

  508. 		$res  = &$this->result;
    509. 

  509. 		$info = &$this->formParams;
    510. 

  510. 		echo "<table>\n";
    511. 

  511. 		if ( is_array($res) ) {
    512. 

  512. 			
    513. 

  513. 			echo "<thead>
    514. 

  514. 						<tr>";
    515. 

  515. 			
    516. 

  516. 			if ($definitions[TABLE_CONFIG][OBJECT_IS_AGGREGATE]) {
    517. 

  517. 				echo "<th>Database</th>";
    518. 

  518. 			}
    519. 

  519. 			foreach($definitions as $key => $value) {
    520. 

  520. 				if ( !is_array($value) || $value[SHOWCOLUMN] == 0 || !isset($value[SHOWCOLUMN])) continue;
    521. 

  521. 

  522. 				// -- if the field doesnt say to NOT sort
    523. 

  523. 				if ( ($definitions[TABLE_CONFIG][SORTABLE] == 1 || !isset($definitions[TABLE_CONFIG][SORTABLE])) && !$definitions[TABLE_CONFIG][OBJECT_IS_AGGREGATE]) {
    524. 

  524. 					if ($_GET[$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_direction']] == 'ASC') {
    525. 

  525. 						$direction = 'DESC';
    526. 

  526. 						$directionAscii = '&darr;';
    527. 

  527. 					} else {
    528. 

  528. 						$direction = 'ASC';
    529. 

  529. 						$directionAscii = '&uarr;';
    530. 

  530. 					}
    531. 

  531. 

  532. 					// -- only set direction arrow if on current field
    533. 

  533. 					if (strtoupper($_GET[$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_field']]) == strtoupper($key)) {
    534. 

  534. 						if ($_GET[$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_direction']] == 'ASC') {
    535. 

  535. 							$directionAscii = '&uarr;';
    536. 

  536. 						} else {
    537. 

  537. 							$directionAscii = '&darr;';
    538. 

  538. 						}
    539. 

  539. 					} else {
    540. 

  540. 						$directionAscii = '';
    541. 

  541. 					}
    542. 

  542. 

  543. 					if (!empty($_GET[$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['page']])) {
    544. 

  544. 						$direction .= '&'.$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['page'].'='.$_GET[$definitions[OBJECT_ACTIONS]['page']];
    545. 

  545. 					}
    546. 

  546. 

  547. 					$sortLinkStart = "<a href='?action=".strtolower($definitions[TABLE_CONFIG][OBJECT_ACTIONS]['read'].$this->object_key).'&'.$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_field'].'='.$key.'&'.$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['order_direction'].'='.$direction;
    548. 

  548. 					if ($this->isPageInclude) {
    549. 

  549. 						$sortLinkStart .= "&conf=$this->current_config";
    550. 

  550. 					}
    551. 

  551. 					$sortLinkStart .= "'>$directionAscii";
    552. 

  552. 					$sortLinkEnd = "</a>";
    553. 

  553. 				}
    554. 

  554. 				echo "      <th>".$sortLinkStart.$value[CAPTION].$sortLinkEnd."</th>\n";
    555. 

  555. 				$sortLinkStart = $sortLinkEnd = '';
    556. 

  556. 			}
    557. 

  557. 

  558. 			echo "</tr>
    559. 

  559. 						</thead>";
    560. 

    561. 

  561. 		
    562. 

  562. 			//
    563. 

  563. 			$databases = array();
    564. 

  564. 			if ($definitions[TABLE_CONFIG][OBJECT_IS_AGGREGATE]) {
    565. 

  565. 				foreach ($definitions[TABLE_CONFIG]['all_databases'] as $server=>$values) {
    566. 

  566. 					foreach ($values as $database) {
    567. 

  567. 						$databases[$database]['db_name'] = $database;
    568. 

  568. 						//$databases[$database]['db_port'] = $definitions[TABLE_CONFIG]['all_ports'][$server];
    569. 

  569. 						$databases[$database]['db_password'] = $definitions[TABLE_CONFIG]['all_passwords'][$server];
    570. 

  570. 						$databases[$database]['db_server'] = $definitions[TABLE_CONFIG]['all_servers'][$server];
    571. 

  571. 						$databases[$database]['db_user'] = $definitions[TABLE_CONFIG]['all_users'][$server];
    572. 

  572. 					}
    573. 

  573. 				}
    574. 

  574. 			} else {
    575. 

  575. 				$database = $this->dba->info['db'];
    576. 

  576. 				$databases[$database]['db_name'] = $database;
    577. 

  577. 				$databases[$database]['db_port'] = $this->dba->info['user'];
    578. 

  578. 				$databases[$database]['db_password'] = $this->dba->info['pass'];
    579. 

  579. 				$databases[$database]['db_server'] = $this->dba->info['host'];
    580. 

  580. 				$databases[$database]['db_user'] = $this->dba->info['user'];
    581. 

  581. 			}
    582. 

  582. 			
    583. 

  583. 			$aggregateTotals = array();
    584. 

  584. 			foreach ($databases as $dbId=>$dbAttribs) {
    585. 

  585. 				$this->dba->setHost($dbAttribs['db_server']);
    586. 

  586. 				$this->dba->setPass($dbAttribs['db_password']);
    587. 

  587. 				$this->dba->setUser($dbAttribs['db_user']);
    588. 

  588. 				$this->dba->connectToNewDB($dbAttribs['db_name']);
    589. 

  589. 				$res  = array();
    590. 

  590. 				$this->doQuery($filter);
    591. 

  591. 				$res  = &$this->result;
    592. 

  592. 				
    593. 

  593. 				foreach($res as $k => $r) {
    594. 

  594. 					$pagedResults = (array)$r;
    595. 

  595. 					echo "   <tr>\n";
    596. 

  596. 

  597. 					if ($definitions[TABLE_CONFIG][OBJECT_IS_AGGREGATE]) {
    598. 

  598. 						echo "<td>{$dbAttribs['db_name']}</td>";
    599. 

  599. 					}
    600. 

  600. 					$edit_url = $definitions[TABLE_CONFIG][EDIT_LINK];
    601. 

  601. 					$del_url  = $definitions[TABLE_CONFIG][DELETE_LINK];
    602. 

  602. 

  603. 					if ($definitions[TABLE_CONFIG][OBJECT_HIDE_EDIT_LINK] == 1) {
    604. 

  604. 						$edit_url = "";
    605. 

  605. 					}
    606. 

  606. 					if ($definitions[TABLE_CONFIG][OBJECT_HIDE_DELETE_LINK] == 1) {
    607. 

  607. 						$del_url = "";
    608. 

  608. 					}
    609. 

  609. 

  610. 					foreach($pagedResults as $k2 => $v2) {
    611. 

  611. 						$edit_url = str_replace('%'.$k2.'%', $v2,  $edit_url);
    612. 

  612. 						$del_url  = str_replace('%'.$k2.'%', $v2,  $del_url);
    613. 

  613. 					}
    614. 

  614. 					$count=0;
    615. 

  615. 					foreach($definitions as $k => $v) {
    616. 

  616. 						if (!is_array($v)) {continue;}
    617. 

  617. 						if ( ! isset($v[SHOWCOLUMN]) || $v[SHOWCOLUMN] == 0) continue;
    618. 

  618. 						$count++;
    619. 

  619. 						$text = "";
    620. 

  620. 						if (isset($v[PRETEXTREAD])) {
    621. 

  621. 							$processedText = $v[PRETEXTREAD];
    622. 

  622. 							foreach($pagedResults as $k2 => $v2) {
    623. 

  623. 								$processedText = str_replace('%'.$k2.'%', $v2, rawurldecode($processedText));
    624. 

  624. 							}
    625. 

  625. 							$text .= $processedText;
    626. 

  626. 						}
    627. 

  627. 						$dataElementValue = (isset($info[$k]["OPTIONS"][$r[$k]]) && !empty($r[$k])) ? $info[$k]["OPTIONS"][$r[$k]] : $r[$k];
    628. 

  628. 						if (is_numeric($dataElementValue)) {
    629. 

  629. 							$aggregateTotals[$k] += $dataElementValue;
    630. 

  630. 						} /*else {
    631. 

  631. 							$aggregateTotals[$k] = 'N/A';
    632. 

  632. 						}*/
    633. 

  633. 						$text .= htmlentities($dataElementValue);
    634. 

  634. 						if (isset($v[POSTTEXTREAD])) {
    635. 

  635. 							$processedText = $v[POSTTEXTREAD];
    636. 

  636. 							foreach($pagedResults as $k2 => $v2) {
    637. 

  637. 								$processedText = str_replace('%'.$k2.'%', $v2,  rawurldecode($processedText));
    638. 

  638. 							}
    639. 

  639. 							$text .= $processedText;
    640. 

  640. 						}
    641. 

  641. 						if (empty($text) && $text !=='0') {
    642. 

  642. 							 $text .= "<span style='color:#EBEBEB'>(No ".$v[CAPTION].")</span>";
    643. 

  643. 						}
    644. 

  644. 

  645. 						$linkStart = $linkEnd = "";
    646. 

  646. 						if ($definitions[TABLE_CONFIG][OBJECT_HIDE_DETAILS_LINK] == 0 && $count == 1) {
    647. 

  647. 							$linkStart  = "<a href='".str_replace("update_","view_",$edit_url);
    648. 

  648. 							if ($this->isPageInclude) {
    649. 

  649. 								$linkStart .= "&conf=$this->current_config";
    650. 

  650. 							}
    651. 

  651. 							$linkStart .= "'>";
    652. 

  652. 							$linkEnd = "</a>";
    653. 

  653. 						}
    654. 

  654. 

  655. 						if (strlen($text) > 30 && preg_match("|<[^>]+>(.*)</[^>]+>|U",$text)==0 && !stristr($text,"<img") && !stristr($text,"<input")) {
    656. 

  656. 							$text = substr($text,0,30)."...";
    657. 

  657. 						}
    658. 

  658. 						if ($info[$k]["TYPE"] == 'select') {
    659. 

  659. 							$parts = parse_url($definitions[TABLE_CONFIG]['connection']);
    660. 

  660. 							if (!$this->isPageInclude) {
    661. 

  661. 								$text .= " <strong style=\"color:black;\">(<a href=\"?action=view_".str_replace("/","",$parts['path'])."_".$v[TABLE]."&". $v[ID] . "=". $r[$k] ."\">{$r[$k]}</a>)</strong>";
    662. 

  662. 							}
    663. 

  663. 						}
    664. 

  664. 

  665. 						echo "<td>".$linkStart.stripslashes($text).$linkEnd."</td>\n";
    666. 

  666. 						// -- debug the row
    667. 

  667. 						//echo "<td>".var_export($r,true)."</td>";
    668. 

  668. 

  669. 					}
    670. 

  670. 

  671. 					if (!empty($edit_url)) {
    672. 

  672. 						$edTxt = ($definitions[TABLE_CONFIG][EDIT_TEXT]) ? $definitions[TABLE_CONFIG][EDIT_TEXT] : 'Edit';
    673. 

  673. 						$edit = '<a title="Edit this '.$definitions[TABLE_CONFIG][OBJECT_DESC].'" href="'.$edit_url;
    674. 

  674. 						if ($this->isPageInclude) {
    675. 

  675. 							$linkStart .= "&conf=$this->current_config";
    676. 

  676. 						}
    677. 

  677. 						$edit .= '">'.$edTxt.'</a> - ';
    678. 

  678. 					}
    679. 

  679. 					if (!empty($del_url)) {
    680. 

  680. 						$delTxt = ($definitions[TABLE_CONFIG][DELETE_TEXT]) ? $definitions[TABLE_CONFIG][DELETE_TEXT] : "Delete";
    681. 

  681. 						$delete = '<a title="Delete this '.$definitions[TABLE_CONFIG][OBJECT_DESC].'" href="javascript:if(window.confirm(\'Are you sure you wish to delete this '.$this->object_name.'?\')){document.location=\''.$del_url.'\';}">'.$delTxt.'</a>';
    682. 

  682. 					}
    683. 

  683. 					if (is_array($definitions[TABLE_CONFIG][OTHER_LINKS])) {
    684. 

  684. 						$other = '';
    685. 

  685. 						foreach ($definitions[TABLE_CONFIG][OTHER_LINKS] as $key=>$value) {
    686. 

  686. 							$other_url = $value;
    687. 

  687. 							foreach($r as $k2 => $v2) {
    688. 

  688. 								$other_url  = str_replace('%'.$k2.'%', $v2,  rawurldecode($other_url));
    689. 

  689. 							}
    690. 

  690. 							$other .= ' - <a href="'.$other_url.'">'.$key.'</a>';
    691. 

  691. 						}
    692. 

  692. 					}
    693. 

  693. 					echo '<td><nobr>'.$edit.$delete.$other.'</nobr></td>'."\n";
    694. 

  694. 					echo "</tr>\n";
    695. 

  695. 				}
    696. 

  696. 			}
    697. 

  697. 			
    698. 

  698. 			if ($definitions[TABLE_CONFIG][OBJECT_IS_AGGREGATE]) {
    699. 

  699. 				echo "<tr>";
    700. 

  700. 				echo "<td>Totals</td>";
    701. 

  701. 				foreach ($aggregateTotals as $kAgg=>$vAgg) {
    702. 

  702. 					echo "<td>$vAgg</td>";
    703. 

  703. 				}
    704. 

  704. 				echo "</tr>\n\n";
    705. 

  705. 			}
    706. 

  706. 			
    707. 

  707. 		} else {
    708. 

  708. 			echo "<tr> \n";
    709. 

  709. 			if ($_COOKIE['current_db']) {
    710. 

  710. 				list($void,$db) = explode('-',$_COOKIE['current_db']);
    711. 

  711. 				$db .= " ";
    712. 

  712. 			}
    713. 

  713. 			echo "<td><h2>No ".$db.$definitions[TABLE_CONFIG][OBJECT_DESC]."'s found.</h2></td>";
    714. 

  714. 			echo "</tr> \n";
    715. 

  715. 		}
    716. 

  716. 		echo '</table>';
    717. 

  717. 		echo '<p id="paging_links">';
    718. 

  718. 		if ($definitions[TABLE_CONFIG][OBJECT_PAGING] -> next_page != "" || !empty($_GET[$definitions[TABLE_CONFIG][OBJECT_ACTIONS]['page']])) {
    719. 

  719. 			echo $definitions[TABLE_CONFIG][OBJECT_PAGING] -> first_page;
    720. 

  720. 			echo $definitions[TABLE_CONFIG][OBJECT_PAGING] -> previous_page;
    721. 

  721. 			echo $definitions[TABLE_CONFIG][OBJECT_PAGING] -> page_links;
    722. 

  722. 			echo $definitions[TABLE_CONFIG][OBJECT_PAGING] -> next_page;
    723. 

  723. 			echo $definitions[TABLE_CONFIG][OBJECT_PAGING] -> last_page;
    724. 

  724. 		}
    725. 

  725. 		$this->performance['readGeneric'][] = (get_microtime_ms() - $methodStartTime);
    726. 

  726. 

  727. 		echo '</p>';
    728. 

  728. 

  729. 	}
    730. 

  730. 

  731. 	/**
    732. 

  732. 	 *  Generate a basic template for the form.
    733. 

  733. 	 *
    734. 

  734. 	 *  @param object $form Form object
    735. 

  735. 	 *  @access private
    736. 

  736. 	 */
    737. 

  737. 	function autoTemplate($form,$error_message,$verify,$update,$readOnly=false,$search=false) {
    738. 

  738. 		$methodStartTime = get_microtime_ms();
    739. 

  739. 		$def = &$this->tableDefinition;
    740. 

  740. 		$formParams = &$this->formParams;
    741. 

  741. 		$formParams[INPUT_SUBMIT] = $this->button;
    742. 

  742. 		$form->StartLayoutCapture();
    743. 

  743. 		if (!empty($error_message)) {
    744. 

  744. 			echo '<div class="error">'.$error_message.'</div>';
    745. 

  745. 		}
    746. 

  746. 		// -- logic to hide/show based on cookies (also show a post text to unset the search cookie)
    747. 

  747. 

  748. 		if ($search == true) {
    749. 

  749. 			$disp = "style=\"display:none;\" id=\"{$def[TABLE_CONFIG]['alias']}_search\"";
    750. 

  750. 		}
    751. 

  751. 

  752. 		echo '<table '.$disp.' summary="Input fields table">';
    753. 

  753. 

  754. 

  755. 		if ($search == true) {
    756. 

  756. 			$jsSearch = array();
    757. 

  757. 			foreach($this->formParams as $inpName => $i) {
    758. 

  758. 				$form->inputs[$inpName]['VALUE'] = '';
    759. 

  759. 				$p = '';
    760. 

  760. 				if (substr($inpName,2) == 'p_') {
    761. 

  761. 					$p = 'p_';
    762. 

  762. 				}
    763. 

  763. 				$newSearchId = $p.$inpName."_search";
    764. 

  764. 				$form->inputs[$inpName]['NAME'] = $newSearchId;
    765. 

  765. 				$form->inputs[$inpName]['ID'] = $newSearchId;
    766. 

  766. 				$form->inputs[$newSearchId] = $form->inputs[$inpName];
    767. 

  767. 				unset($form->inputs[$inpName]);
    768. 

  768. 				$possibleSearchKey = $def[TABLE_CONFIG]['alias']."~".$inpName;
    769. 

  769. 				$possibleSearchVal = $_COOKIE[$possibleSearchKey];
    770. 

  770. 				if ($possibleSearchVal) {
    771. 

  771. 					$form->inputs[$newSearchId]['VALUE'] = $possibleSearchVal;
    772. 

  772. 				}
    773. 

  773. 				$jsAll .= "if ($('$newSearchId')) { createCookie('$possibleSearchKey',$('$newSearchId').value,500);} ";
    774. 

  774. 				$jsSearch[$inpName.'_search'] = "$('$newSearchId').value='';eraseCookie('$possibleSearchKey');";
    775. 

  775. 			}
    776. 

  776. 		}
    777. 

  777. 		
    778. 

  778. 		foreach($this->formParams as $inpName => $i) {
    779. 

  779. 			$continue = true;
    780. 

  780. 			
    781. 

  781. 			if ($search == true) {
    782. 

  782. 				$originalInputName = $inpName;
    783. 

  783. 				$inpName = $inpName . "_search";
    784. 

  784. 			}
    785. 

  785. 

  786. 			if (is_array($def[TABLE_CONFIG][OTHER_OBJECTS])) {
    787. 

  787. 				foreach ($def[TABLE_CONFIG][OTHER_OBJECTS] as $key=>$value) {
    788. 

  788. 					if ($key == $inpName) {
    789. 

  789. 						$continue = false;
    790. 

  790. 					}
    791. 

  791. 				}
    792. 

  792. 			}
    793. 

  793. 			if ( $inpName == INPUT_DOIT || $inpName == INPUT_SUBMIT) {
    794. 

  794. 				$continue = false;
    795. 

  795. 			}
    796. 

  796. 

  797. 			if (!isset($i['NAME'])) {
    798. 

  798. 				$continue = false;
    799. 

  799. 			}
    800. 

  800. 

  801. 			if ($continue === true) {
    802. 

  802. 				if ( isset($def[$inpName][HIDE]) && $def[$inpName][HIDE] ) {
    803. 

  803. 					echo "<tr style=\"display:none;\">\n";
    804. 

  804. 				} else {
    805. 

  805. 					echo "<tr>\n";
    806. 

  806. 				}
    807. 

  807. 				echo "<th align=\"right\">";
    808. 

  808. 				if ($search) {
    809. 

  809. 					echo "<label for=\"$inpName\">".$def[$originalInputName][CAPTION]."</label>";
    810. 

  810. 					echo " (<a style=\"cursor:pointer;\" onclick=\"{$jsSearch[$inpName]}\">X</a>)";
    811. 

  811. 				} else {
    812. 

  812. 					echo $form->AddLabelPart(array("FOR"=>$inpName));
    813. 

  813. 				}
    814. 

  814. 				echo "</th>\n";
    815. 

  815. 				echo "<td>";
    816. 

  816. 				if ( isset($def[$inpName][UPDATE_READ_ONLY]) && $def[$inpName][UPDATE_READ_ONLY] || $readOnly === true) {
    817. 

  817. 					$form->AddInputReadOnlyPart( $inpName );
    818. 

  818. 				} else {
    819. 

  819. 					$form->AddInputPart($inpName);
    820. 

  820. 				}
    821. 

  821. 				if ($search) {
    822. 

  822. 					echo " <a style=\"cursor:pointer;\" onclick=\"$('{$def[TABLE_CONFIG]['alias']}_bttn').onclick();\">&rArr;</a>";
    823. 

  823. 				}
    824. 

  824. 				echo $def[$inpName][COLUMNPOSTTEXT]."</td>\n";
    825. 

  825. 				echo "<td>". (IsSet($verify[$inpName]) ? "[Verify]" : "")."</td>\n";
    826. 

  826. 				echo "</tr>\n";
    827. 

  827. 			}
    828. 

  828. 		}
    829. 

  829. 

  830. 		if ( isset($def[TABLE_CONFIG][OTHER_OBJECTS]) && is_array($def[TABLE_CONFIG][OTHER_OBJECTS])) {
    831. 

  831. 			// -- for now additional elements draw right before the input box
    832. 

  832. 			foreach ($def[TABLE_CONFIG][OTHER_OBJECTS] as $key=>$value) {
    833. 

  833. 				echo "<tr>";
    834. 

  834. 				if (strtoupper($value['TYPE']) != 'HIDDEN') {
    835. 

  835. 					echo '<th align="right">';
    836. 

  836. 					echo $this->formParams[$key]['LABEL'];
    837. 

  837. 					echo ':</th>';
    838. 

  838. 				}
    839. 

  839. 				echo "\n<td>";
    840. 

  840. 				$form->AddInputPart($key);
    841. 

  841. 				echo "</td>\n";
    842. 

  842. 				echo "<td></td>\n";
    843. 

  843. 				echo "</tr>\n";
    844. 

  844. 			}
    845. 

  845. 		}
    846. 

  846. 

  847. 		if ($readOnly === false && $search == false) {
    848. 

  848. 			echo '<tr><th align="right"></th>';
    849. 

  849. 			echo "\n";
    850. 

  850. 			echo '<td>';
    851. 

  851. 			echo '<input name="'.INPUT_DOIT.'" value="1" TYPE="hidden"/><input name="'.INPUT_SUBMIT.'" value="'.$this->formParams[INPUT_SUBMIT]["VALUE"].'" onclick="if(this.disabled || typeof(this.disabled)==\'boolean\') this.disabled=true ; form_submitted_test=form_submitted ; form_submitted=true ; form_submitted=(!form_submitted_test || confirm(\''.$form->ResubmitConfirmMessage.'\')) ; if(this.disabled || typeof(this.disabled)==\'boolean\') this.disabled=false ; sub_form=\'\' ; return true" id="'.INPUT_SUBMIT.'" type="submit">';
    852. 

  852. 			echo "</td>\n";
    853. 

  853. 			echo "<td></td>\n";
    854. 

  854. 			echo "</tr>\n";
    855. 

  855. 		} elseif ($search == true) {
    856. 

  856. 			foreach ($jsSearch as $k=>$v) {
    857. 

  857. 				$tmp .= $v;
    858. 

  858. 			}
    859. 

  859. 			echo '<tr><th><input value="Clear All" onclick="'.$tmp.'" type="button"></th>';
    860. 

  860. 			echo '<td>';
    861. 

  861. 			echo '<input value="Search" id="'.$def[TABLE_CONFIG]['alias'].'_bttn" onclick="'.$jsAll.'document.location = location.pathname + \'?action=show_'.$def[TABLE_CONFIG]['alias'].'\';" type="button">';
    862. 

  862. 			echo "</td>";
    863. 

  863. 			echo "<td></td>";
    864. 

  864. 			echo "</tr>";
    865. 

  865. 		}
    866. 

  866. 		
    867. 

  867. 		echo '</table>';
    868. 

  868. 		$form->EndLayoutCapture();
    869. 

  869. 		$form->DisplayOutput();
    870. 

  870. 		$total = (get_microtime_ms() - $methodStartTime);
    871. 

  871. 		$this->performance['autoTemplate'][] = $total;
    872. 

  872. 	}
    873. 

  873. 

  874. 	/**
    875. 

  875. 	 *  Get information about the table
    876. 

  876. 	 *
    877. 

  877. 	 *  @access private.
    878. 

  878. 	 */
    879. 

  879. 	function getTableInformation($insert=false) {
    880. 

  880. 		$methodStartTime = get_microtime_ms();
    881. 

  881. 		$dba  = &$this->dba;
    882. 

  882. 

  883. 		$info = &$this->tableDefinition;
    884. 

  884. 		unset($this->formParams);
    885. 

  885. 		$formParams = &$this->formParams;
    886. 

  886. 		$sql  = sprintf(GET_COLUMNS_SQL,$this->table);
    887. 

  887. 		$record = $dba->query($sql);
    888. 

  888. 

  889. 		if ( !$record )
    890. 

  890. 			return false;
    891. 

  891. 

  892. 		$Field     = & $record->bindColumn('Field');
    893. 

  893. 		$Type      = & $record->bindColumn('Type');
    894. 

  894. 		$Null      = & $record->bindColumn('Null');
    895. 

  895. 		$Key       = & $record->bindColumn('Key');
    896. 

  896. 		$Extra     = & $record->bindColumn('Extra');
    897. 

  897. 		$Default     = & $record->bindColumn('Default');
    898. 

  898. 		$Comment     = & $record->bindColumn('Comment');
    899. 

  899. 		while ( $foo=$record->getNext() ) {
    900. 

  900. 			$actInfo = & $info[$Field];
    901. 

  901. 			if (stristr($Comment,"lookup")) {
    902. 

  902. 				list($type,$table,$field,$value) = explode(",",$Comment);
    903. 

  903. 				$actInfo[TABLE] = trim($table);
    904. 

  904. 				$actInfo[ID] = trim($field);
    905. 

  905. 				$actInfo[TEXT] = trim($value);
    906. 

  906. 			}
    907. 

  907. 			$actInfoFormOverRides = & $info[$Field."_config"];
    908. 

  908. 

  909. 			/* reseting form information */
    910. 

  910. 			$form = array();
    911. 

  911. 

  912. 			if ($Extra == 'auto_increment') {
    913. 

  913. 				continue;
    914. 

  914. 			}
    915. 

  915. 			/**
    916. 

  916. 			 *  If the field is autoincrement, we
    917. 

  917. 			 *  do not need to show it on the form.
    918. 

  918. 			 */
    919. 

  919. 			$display = "";
    920. 

  920. 			if ( isset($actInfo[HIDE]) && $actInfo[HIDE] ) {
    921. 

  921. 				$form["READONLY"] = "true";
    922. 

  922. 			}
    923. 

  923. 			$this->comments[$Field] = $Comment;
    924. 

  924. 			$this->datatypes[$Field] = $Type;
    925. 

  925. 			$autoType = $this->parseColumnInfo($Type,$foo['Default'],$Field);
    926. 

  926. 			$form["NAME"] = trim($Field);
    927. 

  927. 			$form["ID"] = $form["NAME"];
    928. 

  928. 

  929. 			// -- if table is configured as not null then user has to enter something
    930. 

  930. 			/*if (strtoupper($Null) == 'NO') {
    931. 

  931. 				 $form["ValidateAsNotEmpty"] = 1;
    932. 

  932. 			}*/
    933. 

  933. 

  934. 			// -- if developer tells class that the field is non-required then set dont set as required
    935. 

  935. 			if($actInfo[REQUIRED] == 1 && isset($actInfo[REQUIRED])) {
    936. 

  936. 				$form["ValidateAsNotEmpty"] = 1;
    937. 

  937. 				$form["Optional"] = false;
    938. 

  938. 				$form["LABEL"] .="<span class='required'>".$info[TABLE_CONFIG][REQUIRED_TEXT]."</span>";
    939. 

  939. 			} else {
    940. 

  940. 				$form["Optional"] = true;
    941. 

  941. 				unset($form["ValidateAsNotEmpty"]);
    942. 

  942. 			}
    943. 

  943. 

  944. 			$form["LABEL"] = isset($actInfo[CAPTION]) ? $actInfo[CAPTION] : $Field;
    945. 

  945. 			if (isset($actInfo[TABLE]) && isset($actInfo[ID]) && isset($actInfo[TEXT])) {
    946. 

  946. 				$form["TYPE"] = "select";
    947. 

  947. 				$opt = & $form["OPTIONS"];
    948. 

  948. 				if (isset($actInfo[WHERE])) {
    949. 

  949. 					$where = " where ".$actInfo[WHERE]." order by `".$actInfo[TEXT]."` ASC";
    950. 

  950. 				}
    951. 

  951. 				if (substr($actInfo[ID],0,23) == '___distinct___lookup___' || substr($actInfo[TEXT],0,23) == '___distinct___lookup___') {
    952. 

  952. 					$distinct = "distinct";
    953. 

  953. 					$actInfo[ID] = substr($actInfo[ID],23);
    954. 

  954. 					$actInfo[TEXT] = substr($actInfo[TEXT],23);
    955. 

  955. 				}
    956. 

  956. 				$rec1 = $dba->query("select ".$distinct." ".$actInfo[ID].",".$actInfo[TEXT]." from ".$actInfo[TABLE].$where);
    957. 

  957. 				if ( !$rec1 ) {
    958. 

  958. 					continue;
    959. 

  959. 				}
    960. 

  960. 				//@ToDo - say couldnt join if admin
    961. 

  961. 				$opt[""] = "Select a : ".$form["LABEL"];
    962. 

  962. 

  963. 				while ( $f = $rec1->getNext() ) {
    964. 

  964. 					if ( !isset($form["VALUE"]) ) $form["VALUE"]= "";
    965. 

  965. 					if (strlen($f[ $actInfo[TEXT] ]) > 300 ) {
    966. 

  966. 						$val = substr($f[ $actInfo[TEXT] ],0,300)."...";
    967. 

  967. 					} else {
    968. 

  968. 						$val = $f[ $actInfo[TEXT] ];
    969. 

  969. 					}
    970. 

  970. 					$this->cachedLookup[$hash]["ID"] = $f[$actInfo[ID] ];
    971. 

  971. 					$this->cachedLookup[$hash]["VALUE"] = $val;
    972. 

  972. 					$opt[ $f[$actInfo[ID] ] ] = $val;
    973. 

  973. 				}
    974. 

  974. 				if ($actInfoFormOverRides['TYPE'] != 'select_multi') {
    975. 

  975. 					unset($actInfoFormOverRides['TYPE']);
    976. 

  976. 				}
    977. 

  977. 			} else if ( isset($actInfo[SELECT]) ){
    978. 

  978. 				$form["TYPE"] = "select";
    979. 

  979. 				$form["OPTIONS"] = array_merge(array(""=>"Select: ".$form["LABEL"]),$actInfo[SELECT]);
    980. 

  980. 				$form["VALUE"] = array_shift( array_keys($actInfo[SELECT]) );
    981. 

  981. 			} else {
    982. 

  982. 				$form["TYPE"] = $autoType["TYPE"];
    983. 

  983. 			}
    984. 

  984. 			$form["ValidationErrorMessage"] = "'".$form["LABEL"]."' is required.";
    985. 

  985. 

  986. 			if (is_array($autoType)) {
    987. 

  987. 				foreach ($autoType as $autoTypeKey=>$autoTypeVal) {
    988. 

  988. 					if (!isset($form[$autoTypeKey])) {
    989. 

  989. 						$form[$autoTypeKey] = $autoType[$autoTypeKey];
    990. 

  990. 					}
    991. 

  991. 				}
    992. 

  992. 			}
    993. 

  993. 			if ( $type["TYPE"]=="select" ) {
    994. 

  994. 				$form["VALUE"] = strlen($Default)>0? $Default : current($form["OPTIONS"]);
    995. 

  995. 			}
    996. 

  996. 			/**
    997. 

  997. 			 *  Override Field Configuration based on field_config array
    998. 

  998. 			 */
    999. 

  999. 			if (!empty($actInfoFormOverRides)) {
    1000. 

  1000. 				 foreach ($actInfoFormOverRides as $option=>$optionValue) {
    1001. 

  1001. 					$form[$option] = $optionValue;
    1002. 

  1002. 				 }
    1003. 

  1003. 			}
    1004. 

  1004. 

  1005. 			if (isset($form['ValidateAsURL'])) {
    1006. 

  1006. 				unset($form['ValidateAsURL']);
    1007. 

  1007. 				$form["ReplacePatterns"] =  array(
    1008. 

  1008. 											"^[ \t\r\n]+"=>"",
    1009. 

  1009. 

  1010. 											"[ \t\r\n]+\$"=>"",
    1011. 

  1011. 

  1012. 											"^([wW]{3}\\.)"=>"http://\\1",
    1013. 

  1013. 

  1014. 											"^([^:]+)\$"=>"http://\\1",
    1015. 

  1015. 

  1016. 											"^(http|https)://(([-!#\$%&'*+.0-9=?A-Z^_`a-z{|}~]+\.)+[A-Za-z]{2,6}(:[0-9]+)?)\$"=>"\\1://\\2/"
    1017. 

  1017. 											);
    1018. 

  1018. 

  1019. 				$form["ValidateRegularExpression"] = '^(http|https)\://(([-!#\$%&\'*+.0-9=?A-Z^_`a-z{|}~]+\.)+[A-Za-z]{2,6})(\:[0-9]+)?(/)?/';
    1020. 

  1020. 				$form["ValidationErrorMessage"]    = (!isset($form["ValidateAsURLErrorMessage"])) ? "This is not a valid URL" : $form["ValidateAsURLErrorMessage"];;
    1021. 

  1021. 			}
    1022. 

  1022. 

  1023. 			if ($actInfoFormOverRides['TYPE'] == 'select_multi') {
    1024. 

  1024. 				$form["TYPE"] = "select";
    1025. 

  1025. 				$form["SIZE"] = "8";
    1026. 

  1026. 				$form["NAME"] = $Field."[]";
    1027. 

  1027. 				$form["ValidateOnlyOnClientSide"] = true;
    1028. 

  1028. 				$form["ExtraAttributes"] = array("multiple"=>"multiple");
    1029. 

  1029. 			}
    1030. 

  1030. 

  1031. 			if ($form['TYPE'] == 'wysiwyg' || $actInfoFormOverRides['TYPE'] == 'wysiwyg') {
    1032. 

  1032. 				unset($form['TYPE']);
    1033. 

  1033. 				require_once("form_FCKEditor.php");
    1034. 

  1034. 				$form["TYPE"] = "custom";
    1035. 

  1035. 				$form["CustomClass"] = "form_FCKEditor";
    1036. 

  1036. 				$form["BasePath"] = ABS_PATH_TO_CRUDDY_MYSQL_FOLDER."fck/";
    1037. 

  1037. 				$form["HEIGHT"] = 400;
    1038. 

  1038. 				$form["WIDTH"] = 800;
    1039. 

  1039. 				$form["Skin"] = "silver";
    1040. 

  1040. 				$form["UsesAutoFormName"] = "instance";
    1041. 

  1041. 			}
    1042. 

  1042. 			if ($form['TYPE'] == 'date' || $form['TYPE'] == 'timestamp') {
    1043. 

  1043. 				$form["TYPE"] = "custom";
    1044. 

  1044. 				$form["CustomClass"] = "form_date_class";
    1045. 

  1045. 				if ($insert=='search') {
    1046. 

  1046. 					$form["VALUE"] = '';
    1047. 

  1047. 					$form["ChooseControl"] = 0;
    1048. 

  1048. 				} else {
    1049. 

  1049. 					$form["VALUE"] = 'now';
    1050. 

  1050. 					$form["ChooseControl"] = 1;
    1051. 

  1051. 				}
    1052. 

  1052. 				$form["Format"] = "{day}/{month}/{year}";
    1053. 

  1053. 				$form["Months"] = array(
    1054. 

  1054. 													""=>"Select A Month",
    1055. 

  1055. 													"01"=>"January",
    1056. 

  1056. 													"02"=>"February",
    1057. 

  1057. 													"03"=>"March",
    1058. 

  1058. 													"04"=>"April",
    1059. 

  1059. 													"05"=>"May",
    1060. 

  1060. 													"06"=>"June",
    1061. 

  1061. 													"07"=>"July",
    1062. 

  1062. 													"08"=>"August",
    1063. 

  1063. 													"09"=>"September",
    1064. 

  1064. 													"10"=>"October",
    1065. 

  1065. 													"11"=>"November",
    1066. 

  1066. 													"12"=>"December"
    1067. 

  1067. 												);
    1068. 

  1068. 			}
    1069. 

  1069. 

  1070. 			if (!isset($form["STYLE"]) && $form['TYPE'] == 'textarea') {
    1071. 

  1071. 				$form["STYLE"] = "WIDTH:500px;HEIGHT:250px;";
    1072. 

  1072. 			}
    1073. 

  1073. 

  1074. 			if ($form['TYPE'] == 'select' && $actInfoFormOverRides['TYPE'] != 'select_multi' && isset($form['SIZE'])) {
    1075. 

  1075. 				unset($form['SIZE']);
    1076. 

  1076. 			}
    1077. 

  1077. 

  1078. 			$formParams[$Field] = $form;
    1079. 

  1079. 		}
    1080. 

  1080. 		if ( isset($info[TABLE_CONFIG][OTHER_OBJECTS]) && is_array($info[TABLE_CONFIG][OTHER_OBJECTS]) ) {
    1081. 

  1081. 			// -- for now additional elements draw right before the input box
    1082. 

  1082. 			foreach ($info[TABLE_CONFIG][OTHER_OBJECTS] as $key=>$value) {
    1083. 

  1083. 				$formParams[$key] = $value;
    1084. 

  1084. 			}
    1085. 

  1085. 		}
    1086. 

  1086. 		$this->performance['getTableInfo'][] = (get_microtime_ms() - $methodStartTime);
    1087. 

  1087. 	}
    1088. 

  1088. 

  1089. 	/**
    1090. 

  1090. 	 *  Analyze the column type, parse it, and return
    1091. 

  1091. 	 *  to the class for prepare the form.
    1092. 

  1092. 	 *
    1093. 

  1093. 	 *  @access private
    1094. 

  1094. 	 *  @param string $type MySQL column description
    1095. 

  1095. 	 *  @return array Parsed information
    1096. 

  1096. 	 */
    1097. 

  1097. 	function parseColumnInfo($type,$Default,$Field) {
    1098. 

  1098. 		$type = trim($type);
    1099. 

  1099. 		$pos = strpos($type,'(');
    1100. 

  1100. 		if ( $pos !== false) {
    1101. 

  1101. 			$extra = substr($type,$pos+1);
    1102. 

  1102. 			$extra[strlen($extra)-1] = ' ';
    1103. 

  1103. 			$type = substr($type,0,$pos);
    1104. 

  1104. 		}
    1105. 

  1105. 

  1106. 		$return = array();
    1107. 

  1107. 		if (!empty($Default)) {
    1108. 

  1108. 			$return["VALUE"] = $Default;
    1109. 

  1109. 		}
    1110. 

  1110. 		switch( strtolower($type) ) {
    1111. 

  1111. 			case "int":
    1112. 

  1112. 				$return["TYPE"] = "text";
    1113. 

  1113. 				$return["MAXLENGTH"] = $extra;
    1114. 

  1114. 				$return["SIZE"] = (floor($extra/1.5) > 50) ? 50 : floor($extra/1.5);
    1115. 

  1115. 				if ($Field == $this->tableDefinition[TABLE_CONFIG][OBJECT_PK]) {
    1116. 

  1116. 					$return["ValidateAsInteger"] = 1;
    1117. 

  1117. 				}
    1118. 

  1118. 				break;
    1119. 

  1119. 			case "float":
    1120. 

  1120. 				$t=explode(",",$extra);
    1121. 

  1121. 				$return["TYPE"] = "text";
    1122. 

  1122. 				$return["MAXLENGTH"] = $t[0]+$t[1]+1;
    1123. 

  1123. 				$return["SIZE"] = (floor($t[0]+$t[1]+1/1.5) > 50) ? 50 : floor($t[0]+$t[1]+1/1.5);;
    1124. 

  1124. 				if ($Field == $this->tableDefinition[TABLE_CONFIG][OBJECT_PK]) {
    1125. 

  1125. 					$return["ValidateAsFloat"] = 1;
    1126. 

  1126. 				}
    1127. 

  1127. 				break;
    1128. 

  1128. 			case "varchar":
    1129. 

  1129. 				$return["TYPE"] = "text";
    1130. 

  1130. 				$return["MAXLENGTH"] = $extra;
    1131. 

  1131. 				$return["SIZE"] = (floor($extra/1.5) > 50) ? 50 : floor($extra/1.5);
    1132. 

  1132. 				if ($Field == $this->tableDefinition[TABLE_CONFIG][OBJECT_PK]) {
    1133. 

  1133. 					$return["ValidateAsNotEmpty"] = 1;
    1134. 

  1134. 				}
    1135. 

  1135. 				break;
    1136. 

  1136. 			case "mediumtext":
    1137. 

  1137. 			case "longtext":
    1138. 

  1138. 				$return["TYPE"] = "textarea";
    1139. 

  1139. 				$return["STYLE"] = "WIDTH:500px;HEIGHT:250px;";
    1140. 

  1140. 				$return["MAXLENGTH"] = ($type == 'mediumtext') ? 16777215 : 4294967296;
    1141. 

  1141. 				break;
    1142. 

  1142. 			case "date":
    1143. 

  1143. 				require_once("form_date.php");
    1144. 

  1144. 				$return["TYPE"] = "custom";
    1145. 

  1145. 				$return["CustomClass"] = "form_date_class";
    1146. 

  1146. 				$return["VALUE"] = 'now';
    1147. 

  1147. 				$return["ChooseControl"] = 1;
    1148. 

  1148. 				$return["Format"] = "{day}/{month}/{year}";
    1149. 

  1149. 				$return["Months"] = array(
    1150. 

  1150. 													""=>"Select A Month",
    1151. 

  1151. 													"01"=>"January",
    1152. 

  1152. 													"02"=>"February",
    1153. 

  1153. 													"03"=>"March",
    1154. 

  1154. 													"04"=>"April",
    1155. 

  1155. 													"05"=>"May",
    1156. 

  1156. 													"06"=>"June",
    1157. 

  1157. 													"07"=>"July",
    1158. 

  1158. 													"08"=>"August",
    1159. 

  1159. 													"09"=>"September",
    1160. 

  1160. 													"10"=>"October",
    1161. 

  1161. 													"11"=>"November",
    1162. 

  1162. 													"12"=>"December"
    1163. 

  1163. 												);
    1164. 

  1164. 				break;
    1165. 

  1165. 			case "timestamp":
    1166. 

  1166. 			case "datetime":
    1167. 

  1167. 				require_once("form_date.php");
    1168. 

  1168. 				$return["TYPE"] = "custom";
    1169. 

  1169. 				$return["CustomClass"] = "form_date_class";
    1170. 

  1170. 				$return["VALUE"] = 'now';
    1171. 

  1171. 				$return["ChooseControl"] = 1;
    1172. 

  1172. 				$return["Format"] = "{day}/{month}/{year}";
    1173. 

  1173. 				$return["Months"] = array(
    1174. 

  1174. 													""=>"Select A Month",
    1175. 

  1175. 													"01"=>"January",
    1176. 

  1176. 													"02"=>"February",
    1177. 

  1177. 													"03"=>"March",
    1178. 

  1178. 													"04"=>"April",
    1179. 

  1179. 													"05"=>"May",
    1180. 

  1180. 													"06"=>"June",
    1181. 

  1181. 													"07"=>"July",
    1182. 

  1182. 													"08"=>"August",
    1183. 

  1183. 													"09"=>"September",
    1184. 

  1184. 													"10"=>"October",
    1185. 

  1185. 													"11"=>"November",
    1186. 

  1186. 													"12"=>"December"
    1187. 

  1187. 												);
    1188. 

  1188. 				break;
    1189. 

  1189. 			case "enum":
    1190. 

  1190. 				$return["TYPE"] = "select";
    1191. 

  1191. 				$options = & $return["OPTIONS"];
    1192. 

  1192. 				$return["OPTIONS"][""] = "Select One";
    1193. 

  1193. 				$max = strlen($extra);
    1194. 

  1194. 				$buf = "";
    1195. 

  1195. 				for($i=0; $i < $max; $i++)
    1196. 

  1196. 					switch ( $extra[$i] ) {
    1197. 

  1197. 						case "'":
    1198. 

  1198. 						case '"':
    1199. 

  1199. 							$end = $extra[$i++];
    1200. 

  1200. 

  1201. 							for(;$i < $max && $extra[$i] != $end; $i++) {
    1202. 

  1202. 								if ( $extra[$i] == "\\") {
    1203. 

  1203. 									$buf .= $extra[$i+1];
    1204. 

  1204. 									$i++;
    1205. 

  1205. 									continue;
    1206. 

  1206. 								}
    1207. 

  1207. 								$buf .= $extra[$i];
    1208. 

  1208. 							}
    1209. 

  1209. 							break;
    1210. 

  1210. 						case ",":
    1211. 

  1211. 							$options[$buf] = $buf;
    1212. 

  1212. 							$buf = "";
    1213. 

  1213. 							break;
    1214. 

  1214. 					}
    1215. 

  1215. 					if ( $buf!='') {
    1216. 

  1216. 						$return["OPTIONS"][$buf] = $buf;
    1217. 

  1217. 					}
    1218. 

  1218. 				break;
    1219. 

  1219. 			default:
    1220. 

  1220. 				$return["TYPE"] = "text";
    1221. 

  1221. 				break;
    1222. 

  1222. 		}
    1223. 

  1223. 

  1224. 		return $return;
    1225. 

  1225. 	}
    1226. 

  1226. }
    1227. 

  1227. 

  1228. class cruddyMysqlAdmin extends cruddyMysql {
    1229. 

  1229. 

  1230. 	function cruddyMysqlAdmin() {
    1231. 

  1231. 		if (strtoupper(substr(PHP_OS,0,3)=='WIN')) {
    1232. 

  1232. 			$this->isWindows = true;
    1233. 

  1233. 			$this->systemDirectorySeparator = '\\';
    1234. 

  1234. 		} else {
    1235. 

  1235. 			$this->isWindows = false;
    1236. 

  1236. 			$this->systemDirectorySeparator = '/';
    1237. 

  1237. 		}
    1238. 

  1238. 

  1239. 		$this->paintedHead = false;
    1240. 

  1240. 		$this->adminFile = getcwd().$this->systemDirectorySeparator."configurations".$this->systemDirectorySeparator."crud_".$_SERVER['SERVER_NAME']."_".ABS_PATH_HASH.".config.php";
    1241. 

  1241. 		$this->functionsFile = getcwd().$this->systemDirectorySeparator."configurations".$this->systemDirectorySeparator."crud_".$_SERVER['SERVER_NAME']."_".ABS_PATH_HASH.".custom.functions.php";
    1242. 

  1242. 		$this->functionsDrawFile = getcwd().$this->systemDirectorySeparator."configurations".$this->systemDirectorySeparator."crud_".$_SERVER['SERVER_NAME']."_".ABS_PATH_HASH.".draw.functions.php";
    1243. 

  1243. 		$this->databaseConnectionFile = getcwd().$this->systemDirectorySeparator."configurations".$this->systemDirectorySeparator."crud_".$_SERVER['SERVER_NAME']."_".ABS_PATH_HASH.".connections.php";
    1244. 

  1244. 		if ($this->adminDBExists()) {
    1245. 

  1245. 			$this->currentAdminDB = $this->readAdminDB();
    1246. 

  1246. 		}
    1247. 

  1247. 

  1248. 		$this->steps[1] = 'initialize_server';
    1249. 

  1249. 		$this->steps[2] = 'select_database';
    1250. 

  1250. 		$this->steps[3] = 'select_tables';
    1251. 

  1251. 		$this->steps[4] = 'select_groups';
    1252. 

  1252. 		$this->steps[5] = 'select_roles';
    1253. 

  1253. 		$this->steps[6] = 'select_users';
    1254. 

  1254. 		$this->steps[7] = 'select_theme';
    1255. 

  1255. 

  1256. 		$this->cruddyAdministrator = (isset($_COOKIE['current_role'])) ? $this->currentAdminDB['crud']['roles'][$_COOKIE['current_role']]['admin_role'] : false;
    1257. 

  1257. 		$this->dateTime = date("Y-m-j H:i:s");
    1258. 

  1258. 

  1259. 		// -- update these to whayou want your get string to look like  with concatenated TABLE by the time the user clicks
    1260. 

  1260. 		$this->actionTypes = array();
    1261. 

  1261. 		$this->actionTypes['new'] = "new_"; // + {TABLENAME} will be concatenated to match the action
    1262. 

  1262. 		$this->actionTypes['delete'] = "delete_"; // + {TABLENAME}
    1263. 

  1263. 		$this->actionTypes['update'] = "update_"; // + {TABLENAME}
    1264. 

  1264. 		$this->actionTypes['read'] = "show_"; // + {TABLENAME}
    1265. 

  1265. 		$this->actionTypes['view'] = "view_"; // + {TABLENAME}
    1266. 

  1266. 		$this->actionTypes['order_field'] = "sort_by"; // no additional
    1267. 

  1267. 		$this->actionTypes['order_direction'] = "direction"; // no additional
    1268. 

  1268. 		$this->actionTypes['page'] = "page"; // no additional
    1269. 

  1269. 

  1270. 		$this->tableControlDefaults = array();
    1271. 

  1271. 		$this->tableControlDefaults[EDIT_TEXT] = "Edit";
    1272. 

  1272. 		$this->tableControlDefaults[DELETE_TEXT] = "Delete";
    1273. 

  1273. 		$this->tableControlDefaults[ADD_TEXT] = "Add New {table_desc}";
    1274. 

  1274. 		$this->tableControlDefaults[TABLE_TEXT] = "{table_desc} Administration";
    1275. 

  1275. 		$this->tableControlDefaults[VIEW_TEXT] = "View";
    1276. 

  1276. 		$this->tableControlDefaults[SEARCH_TEXT] = "Search";
    1277. 

  1277. 		$this->tableControlDefaults[OBJECT_DELETE_CHECK_CONSTRAINTS] = 0;
    1278. 

  1278. 		$this->tableControlDefaults[OBJECT_HIDE_DELETE_LINK] = 0;
    1279. 

  1279. 		$this->tableControlDefaults[OBJECT_HIDE_EDIT_LINK] = 0;
    1280. 

  1280. 		$this->tableControlDefaults[OBJECT_HIDE_NEW_LINK] = 0;
    1281. 

  1281. 		$this->tableControlDefaults[OBJECT_HIDE_VIEW_LINK] = 0;
    1282. 

  1282. 		$this->tableControlDefaults[OBJECT_HIDE_SEARCH_LINK] = 0;
    1283. 

  1283. 

  1284. 		$this->tableControlDefaults[OBJECT_HIDE_DETAILS_LINK] = 0;
    1285. 

  1285. 		$this->tableControlDefaults[OBJECT_DELETE_CHECK_CONSTRAINTS] = 0;
    1286. 

  1286. 		$this->tableControlDefaults[OBJECT_PAGING] = 1;
    1287. 

  1287. 		$this->tableControlDefaults[OBJECT_ACTIONS] = $this->actionTypes;
    1288. 

  1288. 		$this->tableControlDefaults[REQUIRED_TEXT] = "*";
    1289. 

  1289. 		$this->tableControlDefaults[OBJECT_PAGING_NUM_ROWS_PER_PAGE] = 10;
    1290. 

  1290. 		$this->tableControlDefaults[OBJECT_PAGING_SCROLL] = 5;
    1291. 

  1291. 

  1292. 		$this->tableControlType = array();
    1293. 

  1293. 		$this->tableControlType[0]['desc'] = "Table Name";
    1294. 

  1294. 		$this->tableControlType[0]['type'] = "";
    1295. 

  1295. 		$this->tableControlType[OBJECT_DESC]['desc'] = "Table Desc.";
    1296. 

  1296. 		$this->tableControlType[OBJECT_DESC]['type'] = "text";
    1297. 

  1297. 		$this->tableControlType[TABLE_TEXT]['desc'] = "Table Name Text";
    1298. 

  1298. 		$this->tableControlType[TABLE_TEXT]['type'] = "text";
    1299. 

  1299. 		$this->tableControlType[EDIT_TEXT]['desc'] = "Edit Link Text or Image Src";
    1300. 

  1300. 		$this->tableControlType[EDIT_TEXT]['type'] = "text";
    1301. 

  1301. 		$this->tableControlType[ADD_TEXT]['desc'] = "Add Link Text or Image Src";
    1302. 

  1302. 		$this->tableControlType[ADD_TEXT]['type'] = "text";
    1303. 

  1303. 		$this->tableControlType[VIEW_TEXT]['desc'] = "View Link Text or Image Src";
    1304. 

  1304. 		$this->tableControlType[VIEW_TEXT]['type'] = "text";
    1305. 

  1305. 		$this->tableControlType[SEARCH_TEXT]['desc'] = "Search Link Text or Image Src";
    1306. 

  1306. 		$this->tableControlType[SEARCH_TEXT]['type'] = "text";
    1307. 

  1307. 		$this->tableControlType[DELETE_TEXT]['desc'] = "Delete Link Text or Image Src";
    1308. 

  1308. 		$this->tableControlType[DELETE_TEXT]['type'] = "text";
    1309. 

  1309. 		$this->tableControlType[OBJECT_DELETE_CHECK_CONSTRAINTS]['desc'] = "Referential Integrity<br/>On Same Fields?";
    1310. 

  1310. 		$this->tableControlType[OBJECT_DELETE_CHECK_CONSTRAINTS]['type'] = "checkbox";
    1311. 

  1311. 		/*$this->tableControlType[OBJECT_PK]['desc'] = "Primary Key";
    1312. 

  1312. 		$this->tableControlType[OBJECT_PK]['type'] = "text";*/
    1313. 

  1313. 		$this->tableControlType[OBJECT_DEFAULT_ORDER]['desc'] = "Default Order<br/>{FIELDNAME} DESC/ASC";
    1314. 

  1314. 		$this->tableControlType[OBJECT_DEFAULT_ORDER]['type'] = "text";
    1315. 

  1315. 		$this->tableControlType[OBJECT_READ_FILTER]['desc'] = "WHERE Clause Filter On Read";
    1316. 

  1316. 		$this->tableControlType[OBJECT_READ_FILTER]['type'] = "text";
    1317. 

  1317. 		$this->tableControlType[OBJECT_FILTER_DESC]['desc'] = "Description of Filter";
    1318. 

  1318. 		$this->tableControlType[OBJECT_FILTER_DESC]['type'] = "text";
    1319. 

  1319. 		$this->tableControlType[OBJECT_HIDE_NEW_LINK]['desc'] = "Hide \"Create\" Link";
    1320. 

  1320. 		$this->tableControlType[OBJECT_HIDE_NEW_LINK]['type'] = "checkbox";
    1321. 

  1321. 		$this->tableControlType[OBJECT_HIDE_DELETE_LINK]['desc'] = "Hide \"Delete\" Link";
    1322. 

  1322. 		$this->tableControlType[OBJECT_HIDE_DELETE_LINK]['type'] = "checkbox";
    1323. 

  1323. 		$this->tableControlType[OBJECT_HIDE_EDIT_LINK]['desc'] = "Hide \"Edit\" Link";
    1324. 

  1324. 		$this->tableControlType[OBJECT_HIDE_EDIT_LINK]['type'] = "checkbox";
    1325. 

  1325. 		$this->tableControlType[OBJECT_HIDE_VIEW_LINK]['desc'] = "Hide \"View\" Link";
    1326. 

  1326. 		$this->tableControlType[OBJECT_HIDE_VIEW_LINK]['type'] = "checkbox";
    1327. 

  1327. 		$this->tableControlType[OBJECT_HIDE_SEARCH_LINK]['desc'] = "Hide \"Search\…
    1328.

Large files files are truncated, but you can click here to view the full file