private function get_elements_private_status_by_value($search_string, $element_name = "Title", $collection_id = 4)
{
$db = get_db();
$config = $db->getAdapter()->getConfig();
$db_hack = new Zend_Db_Adapter_Pdo_Mysql(array('host' => $config["host"], 'username' => $config["username"], 'password' => $config["password"], 'dbname' => $config["dbname"]));
if (!$db->getConnection()) {
_log("__CONNECTION ROTTEN IN get_elements_private_status_by_value");
return false;
}
$sql = self::illegal_sql_generator($search_string, false, $element_name, $collection_id);
$stmt = $db_hack->prepare($sql);
$stmt->execute();
$itemId = $stmt->fetch();
if ($itemId) {
if (array_key_exists("id", $itemId)) {
$sql2 = self::illegal_sql_generator(false, $itemId["id"], "Privacy Required", $collection_id);
$stmt = $db_hack->prepare($sql2);
$stmt->execute();
$item = $stmt->fetch();
if ($item) {
if (array_key_exists("text", $item)) {
if ($item["text"] == "ja") {
return true;
}
}
}
}
}
return false;
}
private function _getMysqlColumns($tsql, Zend_Db_Adapter_Pdo_Mysql $dbh)
{
$sth = $dbh->prepare($tsql);
$sth->execute();
$colcount = $sth->columnCount();
for ($i = 0; $i < $colcount; $i++) {
$coll = $sth->getColumnMeta($i);
$cols[] = $coll['name'];
}
//print_r($cols);
return $cols;
}
