<?php
	global $rewrite, $session;
	
	$table_name = addslashes(@$rewrite[0]);
	
	if (sizeof($_POST) > 0) {
		$colz = array();
		$valz = array();
		
		$sql = "SHOW COLUMNS FROM " . $table_name;
		
		$cols = get_select($sql, __LINE__, __FILE__);
		
		foreach ($cols as $k => $v) {
			if ($v['Field'] != table_prefix($table_name) . 'id') {
				if (isset($_POST[$v['Field']])) {
					$colz[] = $v['Field'];
					$valz[] = "'" . addslashes(stripslashes($_POST[$v['Field']])) . "'";
				}
				if (isset($_FILES[$v['Field']])) {
					$colz[] = $v['Field'];
					$valz[] = "'" . addslashes(file_get_contents($_FILES[$v['Field']]['tmp_name'])) . "'";
				}
			}
		}
		
		if (sizeof($colz) > 0) {
			$colz = implode(",\n", $colz);
			$valz = implode(",\n", $valz);
			
			$sql = "INSERT INTO $table_name (
						$colz
					) VALUES (
						$valz
					)";
	
			if (executesql($sql, __LINE__, __FILE__, false)) {
				flash('Entry has been created');
				if (isset($sesssion['last_post'])) unset($sesssion['last_post']);
				redirect(rewrite($rewrite[0]));
			} else {
				flash('Could not create new entry');
				$session['last_post'] = $_POST;
				redirect(rewrite($rewrite[0] . '/create'));
			}
		}
	}
	
	$sql = "SELECT * FROM __admin_tables
			WHERE at_name = '$table_name'
			LIMIT 1";
	$smarty->assign('selected_table', get_select_1($sql, __LINE__, __FILE__));
	
	$sql = "SELECT * FROM __admin_columns
			WHERE ac_at_name = '$table_name'
			ORDER BY ac_order";
	$columnz = get_select($sql, __LINE__, __FILE__);
	
	//search for enums
	$cols = get_select("SHOW COLUMNS FROM $table_name", __LINE__, __FILE__);
	foreach ($cols as $k => $v) {
		if (substr($v['Type'], 0, 4) == 'enum') {
			foreach ($columnz as $k2 => $v2) {
				if ($v2['ac_name'] == $v['Field']) {
					preg_match('/enum\\((.*)\\)/i', $v['Type'], $out);
					$enums = preg_split('/[\',]/i', $out[1], -1, PREG_SPLIT_NO_EMPTY);
					$columnz[$k2]['enums'] = $v2['enums'] = $enums;
				}
			}
		}
	}
	
	$smarty->assign('all_columns', $columnz);

?>