/**
  * Creates and executes a prepared statement.
  *
  * The purpose of prepared statements is to execute a single query multiple times quickly using different variables.
  * However, we are using them here for security purposes, aware of the fact that preparing and executing single statements
  * one at a time goes against the intention of prepared statements. See "Escaping and SQL Injection" at
  * http://php.net/manual/en/mysqli.quickstart.prepared-statements.php
  *
  * For insert and update queries, passing an associative array of column names and values along with the first few
  * words of the query, up to and including the table name, is sufficient.
  *
  * Example:
  *	$my_table_values = array(
  *		'Person' => 'Bob Jones',
  *		'Company => 'BJ Manufacturing'
  *	);
  *	$query_fragment	= "INSERT INTO `my_table`";
  *	database->query( $query_fragment, $my_table_values );
  *
  * @param string [$query] Either a valid SQL query or the start of one accompanied by an associative array
  * @param array [$params] Optional. Either a list of values that will be bound to the prepared statement or an associative
  * array whose keys match the table's column names.
  * @return mixed [$result or $success] The result of a SQL SELECT, else boolean.
  */
 public function query($query, $params = null)
 {
     if (mysqli_connect_error()) {
         throw new Exception('Failed to connect(' . mysqli_connect_errno() . '): ' . mysqli_connect_error());
     }
     //var_dump( 'before: ', $query, $params );
     if (empty($params)) {
         $statement = $this->prepare($query);
         return $this->execute($statement);
     } else {
         if (!is_array($params)) {
             $params = array($params);
             // convert to array because $this->bind_params requires it
         } else {
             if (is_assoc($params)) {
                 // @todo finish reduce_params( $table_name, $params );
                 // stick $params keys into $query
                 $query = $this->build_query_from_associative_array($query, array_keys($params));
                 // Because we've just filled in the keys (column names), we only need to pass the values
                 $params = array_values($params);
             }
         }
         //var_dump( 'after: ', $query, $params );
         $statement = $this->prepare($query);
         return $this->execute($statement, $params);
     }
 }

	public function init()
	{	
		parent::init();

		$this->current_index = 0;
		
		// make sure $field was specified
		if (!$this->field)
			throw new Exception("field must be specified in resultfilter control");
		$this->filter_definition = $this->controller->appmeta->filter->{$this->field};
		
		if (!$this->datasource) /* Default to the datasource definition in the config file */
			$this->datasource = $this->filter_definition->datasource;
		$filter_type = $this->filter_definition->type;

		// Set container and item templates from config file if not passed into tag
		if (!$this->item_template)
			$this->item_template = $this->controller->appmeta->renderer_map->{$filter_type}->item;
			
		if (!$this->container_template)
			$this->container_template = $this->controller->appmeta->renderer_map->{$filter_type}->container;
				
		// dig specific facet counts out of facets
		if (is_assoc($this->datasource))
		{
			$facet = $this->datasource[$this->filter_definition->facet->field];
			$this->datasource = array();
			foreach($facet as $value => $count)
				$this->datasource[] = array('value' => $value, 'count' => $count); 
		}
	}

 public function testIsAssoc()
 {
     $arr = ['a' => 0, 'b' => 1];
     $this->assertTrue(is_assoc($arr));
     $arr = ['a', 'b', 'c'];
     $this->assertFalse(is_assoc($arr));
 }

 function recursive($array, $level = 1)
 {
     $cur = 1;
     foreach ($array as $key => $value) {
         //If $value is an array.
         if (is_array($value)) {
             if (!is_numeric($key)) {
                 echo '"' . $key . '": ';
             }
             if (is_assoc($value)) {
                 echo '{ ';
             } else {
                 echo '[ ';
             }
             //We need to loop through it.
             recursive($value, $level + 1);
             if (is_assoc($value)) {
                 echo ' }';
             } else {
                 echo ' ]';
             }
         } else {
             //It is not an array, so print it out.
             echo '"' . $key . '": "' . $value, '"';
         }
         if ($cur != count($array)) {
             echo ', ';
         }
         $cur++;
     }
 }

 /**
  * __construct method
  * @param array $array
  * @array array $args
  * */
 public function __construct($array, $args)
 {
     $this->array = $array;
     $this->args = $args;
     is_assoc($this->array) ? $this->assocArray() : $this->sequentArray();
     $this->setRouting(implode('/', $this->array) . '/' . $this->args);
 }

function array_str($arr, $var_export_all = false)
{
    $is_assoc = is_assoc($arr);
    $result = '[';
    foreach ($arr as $key => $value) {
        if ($is_assoc) {
            $result .= $key . '=';
        }
        if (is_array($value)) {
            $result .= array_str($value);
        } else {
            if ($var_export_all) {
                $result .= var_export($value, true);
            } else {
                if (is_bool($value)) {
                    $result .= bool_str($value);
                } else {
                    if (is_string($value)) {
                        $result .= '"' . $value . '"';
                    } else {
                        if (is_string_convertable($value)) {
                            $result .= $value;
                        } else {
                            $result .= var_export($value, true);
                        }
                    }
                }
            }
        }
        $result .= ', ';
    }
    return remove_last($result, ', ') . ']';
}

 /**
  * Constructor
  *
  * @param array  $array     multidimensional associative array
  * @param string $separator [optional] default '.'
  *
  * @throws NonAssocException
  */
 public function __construct(array $array, $separator = '.')
 {
     if (!is_assoc($array)) {
         throw new NonAssocException();
     }
     $this->storage = $array;
     $this->separator = $separator;
 }

 /**
  * @return $this
  */
 public function _refresh()
 {
     if (!is_assoc($this->_result)) {
         return $this;
     }
     DB::_getInstance()->query("UPDATE `Token` SET `Created` = NULL WHERE `ID` = {$this->_result['ID']};");
     return $this;
 }

 /**
  * Copy nodes
  *
  * @param array $keys associative array
  *
  * @throws NonAssocException
  *
  * @return $this
  */
 public function copyKeys(array $keys)
 {
     if (!is_assoc($keys)) {
         throw new NonAssocException();
     }
     foreach ($keys as $existingKey => $newKey) {
         $this->array->offsetSet($newKey, $this->array->offsetGet($existingKey));
     }
     return $this;
 }

function parseMatch($match, $MAJOR_ITEMS)
{
    //Strip fields from participants
    // $support_1;
    // $support_2;
    $counter = 0;
    foreach ($match['participants'] as $participant) {
        // if ($participant['timeline']['role'] == 'DUO_SUPPORT' && $participant['teamId'] == 100)
        // 	$support_1 = $participant['participantId'];
        // if ($participant['timeline']['role'] == 'DUO_SUPPORT' && $participant['teamId'] == 200)
        // 	$support_2 = $participant['participantId'];
        unset($match['participants'][$counter]['masteries']);
        unset($match['participants'][$counter]['runes']);
        foreach ($participant['stats'] as $key => $value) {
            if ($key != 'deaths' && $key != 'kills' && $key != 'assists' && $key != 'winner') {
                unset($match['participants'][$counter]['stats'][$key]);
            }
        }
        $counter++;
    }
    unset($match['participantIdentities']);
    unset($match['teams']);
    //Strip events
    $frame_counter = 0;
    if (is_assoc($match['timeline']['frames'])) {
        return $match;
        //don't change doc at all
    }
    foreach ($match['timeline']['frames'] as $frame) {
        unset($match['timeline']['frames'][$frame_counter]['participantFrames']);
        if (isset($frame['events'])) {
            $counter = 0;
            foreach ($frame['events'] as $event) {
                if ($event['eventType'] != 'ITEM_PURCHASED') {
                    unset($match['timeline']['frames'][$frame_counter]['events'][$counter]);
                } else {
                    // if ($event['participantId'] != $support_1 && $event['participantId'] != $support_2 && !in_array($event['itemId'], $MAJOR_ITEMS['items']))
                    if (!in_array($event['itemId'], $MAJOR_ITEMS['items'])) {
                        unset($match['timeline']['frames'][$frame_counter]['events'][$counter]);
                    }
                    //remove event if not a major purchase by non-support
                }
                $counter++;
            }
            if (count($match['timeline']['frames'][$frame_counter]['events']) == 0) {
                unset($match['timeline']['frames'][$frame_counter]);
            }
        }
        $frame_counter++;
    }
    return $match;
}

 public static function replace($subject, $variables)
 {
     if (is_array($variables) && is_assoc($variables)) {
         foreach ($variables as $key => $value) {
             $key = str_replace("[", "\\[", $key);
             $key = str_replace("]", "\\]", $key);
             $subject = preg_replace("/\\{\\{{$key}\\}\\}/", $value, $subject);
         }
         /* Remove any variables remaining */
         $subject = preg_replace("/\\{\\{[^}]*\\}\\}/", "", $subject);
     }
     return $subject;
 }

 public function setProperties($properties)
 {
     if (!is_array($properties)) {
         $properties = func_get_args();
     } elseif (is_assoc($properties)) {
         foreach ($properties as $key => $value) {
             $this->settable_properties[$key] = $value;
         }
         return;
     }
     foreach ($properties as $property) {
         $this->settable_properties[$property] = "";
     }
 }

function is_red($ob)
{
    if (!is_array($ob)) {
        return false;
    }
    if (!is_assoc($ob)) {
        return false;
    }
    foreach ($ob as $val) {
        if ($val === 'red') {
            return true;
        }
    }
    return false;
}

function recursive_add($obj)
{
    $total = 0;
    foreach ($obj as $k => $v) {
        if (is_scalar($v)) {
            $total += $v;
            if ($v === "red" && is_assoc($obj)) {
                // part 2
                return 0;
            }
        } else {
            $total += recursive_add($obj[$k]);
        }
    }
    return $total;
}

 public function parse()
 {
     if (!$this->map) {
         throw new CSVParserException('$map must be defined.');
     }
     if (!is_assoc($this->map)) {
         throw new CSVParserException('$map must be associative.');
     }
     if (!$this->delimiter) {
         throw new CSVParserException('$delimiter must be defined.');
     }
     if (!$this->path) {
         throw new CSVParserException('$path must be defined.');
     }
     $csv = $this->remote ? $this->_getRemoteCSV() : $this->_getLocalCSV();
     return $csv;
 }

function print_select($name, $options = array(), $selected = NULL)
{
    echo "<select name=\"{$name}\">";
    if (!is_assoc($options)) {
        $new_options = array();
        foreach ($options as $option) {
            $new_options[$option] = $option;
        }
    }
    foreach ($options as $option => $text) {
        $setxt = "";
        if (!is_null($selected) && $selected == $option) {
            $setxt = " selected";
        }
        echo "<option value=\"{$option}\"{$setxt}>{$text}</option>";
    }
    echo "</select>";
}

function icon_switch($case, $icons)
{
    $icon = '';
    if (is_numeric($case) && !is_assoc($icons)) {
        $case %= count($icons);
    }
    if (isset($icons[$case])) {
        if (is_array($icons[$case])) {
            $icon = $icons[$case]['icon'];
            $url = isset($icons[$case]['url']) ? $icons[$case]['url'] : FALSE;
            $attr = isset($icons[$case]['attr']) ? $icons[$case]['attr'] : array();
            $icon = icon($icon, $url, $attr);
        } else {
            $icon = icon($icons[$case]);
        }
    }
    return $icon;
}

function convert($currency_value, $your_currencies)
{
    global $exchangeRates, $currencies;
    if (isset($your_currencies)) {
        $list_currencies = $your_currencies;
    } elseif (isset($currencies)) {
        $list_currencies = $currencies;
    } else {
        $list_currencies = (array) $exchangeRates->rates;
    }
    foreach ($list_currencies as $key => $value) {
        if (is_assoc($list_currencies)) {
            $return_list[$key] = convert_to($currency_value, $key);
        } else {
            $return_list[$value] = convert_to($currency_value, $value);
        }
    }
    return $return_list;
}

 public function package_maintainers()
 {
     $this->package = Package::find_by_name($_GET['name']);
     $data = unserialize(Version::find('first', array('conditions' => array('package_id' => $this->package->id)))->meta);
     $this->maintainers = array();
     foreach (array('lead', 'developer', 'contributor', 'helper') as $role) {
         if (isset($data[$role]) && !empty($data[$role])) {
             if (!is_assoc($data[$role])) {
                 foreach ($data[$role] as $node) {
                     $node['role'] = $role;
                     $this->maintainers[] = $node;
                 }
             } else {
                 $data[$role]['role'] = $role;
                 $this->maintainers[] = $data[$role];
             }
         }
     }
 }

 public function __construct($o = array())
 {
     if (!$o) {
         throw new \Exception('Constructor arguments required.');
     }
     if (!\is_assoc($o)) {
         throw new \Exception('Contsructor argument needs to be associative.');
     }
     $o = (object) $o;
     $this->codebase_paths = $o->codebase_paths;
     $this->db = $o->db;
     if ($o->page_path_default) {
         $this->page_path_default = $o->page_path_default;
     }
     if ($o->page_path_404) {
         $this->page_path_404 = $o->page_path_404;
     }
     $this->uri = $o->uri;
 }