SEO-MAN

Chukcha:
а какая версия mysql на сервере?

<?php

class OkiDb {
private $link;
private $prefix;

public function connect($host, $user, $pass, $dbname, $prefix = '', $names = null)
{
$this->link = mysql_connect($host, $user, $pass);
if (!$this->link) {
$this->dieError('Cannot connect to DB ' . mysql_error());
}
if (!mysql_select_db($dbname, $this->link)) $this->dieError('Cannot select DB');
if ($names != null) {
mysql_query('SET NAMES ' . $names, $this->link);
}
$this->prefix = $prefix;
}

private function dieError($msg = 'MySql Error')
{
die($msg . ': ' . mysql_error());
}

public function query($sql)
{
return mysql_query($sql, $this->link);
}

public function escape($str)
{
return mysql_real_escape_string($str, $this->link);
}

public function buildQuery($query, $args)
{
$i = 0;
if (!is_array($args)) $args = array($args);
while ($i < count($args) && ($pos = strpos($query, '?')) !== false) {
$repl = "'" . $this->escape($args[$i++]) . "'";
$query = substr_replace($query, $repl, $pos, 1);
}
return $query;
}

public function select($table, $cols = '*', $where = null, $order = null, $joins = null, $limit = null)
{
$sql = "SELECT $cols FROM {$this->prefix}$table";
if (is_array($where)) {
$sql .= ' WHERE ' . $this->buildQuery($where[0], $where[1]);
} else if ($where != null) {
$sql .= " WHERE $where";
}
if ($order != null) $sql .= " ORDER BY $order";
if ($limit != null) $sql .= " LIMIT $limit";
return $this->query($sql);
}

/**
* fetch all into associative array
* @return array
*/
public function fetchAll($table, $cols = '*', $where = null, $order = null, $joins = null, $limit = null)
{
$result = $this->select($table, $cols, $where, $order, $joins, $limit);
if ($result === false) $this->dieError('DB SELECT query failed');
$ret = array();
while (($row = mysql_fetch_assoc($result)) !== false) {
$ret[] = $row;
}
return $ret;
}

public function fetchRow($table, $cols = '*', $where = null, $order = null, $joins = null)
{
$result = $this->select($table, $cols, $where, $order, $joins, 1);
if ($result === false)
$this->dieError('DB SELECT query failed');
$ret = mysql_fetch_assoc($result);
return $ret;
}

public function fetchOne($table, $column = '*', $where = null, $order = null)
{
$row = $this->fetchRow($table, $column, $where, $order);
return $row !== false ? $row[$column] : false;
}

public function insert($table, array $data)
{
if (count($data) == 0) return false;

$fields = '(';
$values = 'VALUES (';
foreach ($data as $key => $value) {
$fields .= '`'.$key.'`,';
$values .= "'" . $this->escape($value, $this->link)."',";
}
$fields = substr($fields, 0, -1) . ')';
$values = substr($values, 0, -1) . ')';
$sql = "INSERT INTO {$this->prefix}$table $fields $values";
if ($this->query($sql) === false) return false;
return $this->insertId();
}

public function update($table, array $data, $where = null)
{
if (count($data) == 0) return false;

$set = '';
foreach ($data as $key => $value) {
$set .= "`$key`='" . $this->escape($value) . "',";
}
$set = substr($set, 0, -1); // remove last period (,)

$sql = "UPDATE {$this->prefix}$table SET $set";

if (is_array($where)) {
$sql .= ' WHERE ' . $this->buildQuery($where[0], $where[1]);
} else if ($where != null) {
$sql .= " WHERE $where";
}

return $this->query($sql);
}

public function insertId()
{
return mysql_insert_id($this->link);
}
}

SeoMotion:

QPL - функционал хороший, натянуть шаблон не проблема, возможность конструирования полей из админки, в т.ч. настройка полей для конкретных категорий.