Endless Paradigm

function db_insert_rows($table, $rows, $check_all = false)
{
	global $db;
	// if checking all, see if less than threshold value
	if($check_all && count($rows) < 4)
	{
		// just use normal insert
		foreach($rows as $row)
			$db->insert_query(MY_TABLE_PREFIX.$table, $row);
		return;
	}
	
	if($check_all)
	{
		foreach($rows as $row)
		{
			foreach($row as $fdname => $data)
				if(!isset($fields[$fdname]))
					$fields[$fdname] = $fdname;
		}
	}
	else
	{
		$fields = array_keys(reset($rows));
	}
	
	$insertsql = '';
	foreach($rows as $row)
	{
		if($check_all)
		{
			$insertsql .= '(';
			foreach($fields as $field)
			{
				if(isset($row[$field]))
					$insertsql .= '\''.$row[$field].'\',';
				else
					$insertsql .= '\'\',';
			}
			$insertsql = substr($insertsql, 0, strlen($insertsql)-1).'),';
		}
		else
			$insertsql .= '(\''.implode('\',\'', $row).'\'),';
	}
	// remove trailing comma
	db_write_query('INSERT INTO '.TABLE_PREFIX.$table.'('.implode(',', $fields).')
		VALUES '.substr($insertsql, 0, strlen($insertsql)-1));
}

db_insert_rows(TABLE_PREFIX."plaza_uformat_styles", array(
		array(
			'style' => 'color',
			'friendlyname' => $lang->userformat_color,
			'filter' => $db->escape_string("#([a-zA-Z]*|\#?[0-9a-fA-F]{6})#")
		),
		array(
			'style' => 'font-family',
			'friendlyname' => $lang->userformat_font,
			'filter' => $db->escape_string("#([a-zA-Z0-9 ,\-]+?)#")
		)
	));