function add($productId, $qty = 1)
{
if (is_array($productId)) {
foreach ($productId as $pid => $qty) {
add($pid, $qty);
}
return getList();
}
$user = \cf\User::getLoggedIn();
if ($user) {
$cartId = create();
$oldQty = \cf\query2var('SELECT amount FROM cf_products_in_cart WHERE cart_id=:cid AND product_id=:pid AND status=0', array('cid' => $cartId, 'pid' => $productId));
if ($oldQty) {
\cf\execQuery('UPDATE cf_products_in_cart SET amount=:amt WHERE cart_id=:cid AND product_id=:pid', array('cid' => $cartId, 'pid' => $productId, 'amt' => $qty + $oldQty));
} else {
\cf\execQuery('INSERT INTO cf_products_in_cart (cart_id,product_id,amount) VALUES(:cid,:pid,:amt)', array('cid' => $cartId, 'pid' => $productId, 'amt' => $qty));
}
} else {
$c = create();
$products = $c->getParam('ready');
if (array_key_exists($productId, $products)) {
$products[$productId] += (int) $qty;
} else {
$products[$productId] = (int) $qty;
}
$c->setParam('ready', $products);
$c->set();
}
return getList();
}
function getRandomImage($albumId = false, $numOfImages = 1)
{
if ($albumId) {
if (!is_array($albumId)) {
$albumId = array($albumId);
}
$albumId = \cf\Page::getID($albumId);
}
return \cf\query2var($albumId === false ? 'SELECT id FROM cf_gallery_images ORDER BY RAND() LIMIT ' . (int) $numOfImages : 'SELECT image_id FROM cf_gallery_image_in_album WHERE album_id ' . ($albumId === null ? 'IS NULL' : 'IN (' . implode($albumId, ',') . ')') . ' ORDER BY RAND() LIMIT ' . (int) $numOfImages);
}
function getAlbumID($code)
{
if (!$code) {
//root album
return null;
}
if (is_numeric($code)) {
return (int) $code;
}
return \cf\query2var("SELECT id FROM cf_gallery_albums WHERE code=:code", array('code' => substr($code, strrpos($code, '/') !== false ? strrpos($code, '/') + 1 : 0)));
}
function save($id, $target)
{
if (!is_array($id)) {
$id = array($id);
}
$q = \cf\createQuery('SELECT f FROM cf_tmp_files WHERE id=:id');
$qDel = \cf\createQuery('DELETE FROM cf_tmp_files WHERE id=:id');
foreach ($id as $i) {
$f = pathinfo(\cf\query2var($q, array('id' => $i)));
if ($f['basename']) {
@rename($_SERVER['DOCUMENT_ROOT'] . '/' . $f['dirname'] . '/' . $f['basename'], $_SERVER['DOCUMENT_ROOT'] . "/{$target}/" . $f['basename']);
}
$qDel->setParam('id', $i)->execute();
}
}
function getID($code)
{
$code = trim($code);
return is_numeric($code) ? (int) $code : \cf\query2var("SELECT id FROM cf_form WHERE code=:code", array('code' => $code));
}
/**
@param $bulkParams array( array('paramName1'=>paramVal1,...) )
*/
function doActionBulk($id, $bulkParams, $params = array())
{
$user = \cf\User::getLoggedIn();
$sql = \cf\query2var('SELECT query FROM cf_admin_action WHERE id=:id', array('id' => $id));
eval('$sql="' . $sql . '";');
foreach ($params as $nm => $v) {
$params[$nm] = $v ? $v : null;
}
$q = \cf\createQuery($sql, $params);
foreach ($bulkParams as $p) {
$q->setParams($p)->execute();
}
}
<?php
require_once 'core.php';
$nm = cf\query2var('SELECT name FROM cf_admin_categories WHERE id=:id', array('id' => cf\param::get('id')));
show('category', $nm, array(array('', $nm)));
function importRSS($channelID)
{
global $abort;
$parser = xml_parser_create('UTF-8');
xml_set_element_handler($parser, 'onStartTag', 'onEndTag');
xml_set_character_data_handler($parser, 'onText');
$f = fopen(cf\query2var("SELECT channel_url FROM cf_rss_channel WHERE id=:id", array('id' => $channelID)), 'r');
if ($f === false) {
throw new Exception("Could't open file:" + $settings['url']);
}
while (($data = fread($f, 1024)) && !$abort) {
if (!xml_parse($parser, $data, feof($f))) {
throw new Exception(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($parser)), xml_get_current_line_number($parser)));
}
}
xml_parser_free($parser);
fclose($f);
}
public static function getID($id)
{
if (is_null($id) || $id === 0) {
//root page
return null;
}
if (is_int($id) || preg_match('/^[1-9]{1}[0-9]*$/', $id)) {
return (int) $id;
}
return \cf\query2var("SELECT id FROM cf_page WHERE code=:code", array('code' => $id));
}
function doActionOnMultiple($id, $paramName, $paramValues)
{
$sql = \cf\query2var('SELECT query FROM cf_admin_action WHERE id=:id', array('id' => $id));
$q = \cf\createQuery($sql);
foreach ($paramValues as $v) {
$q->setParam($paramName, $v);
$q->execute();
}
}
<?php
require_once 'core.php';
$id = cf\param::get('id');
$nm = cf\query2var('SELECT name FROM cf_admin_categories WHERE id=:id', array('id' => $id));
$smarty->assign('childmenu', MainMenu::children($id));
show('category', $nm);
function getText($id)
{
return \cf\query2var("SELECT txt FROM cf_page WHERE id=:id", array('id' => \cf\Page::getID($id)));
}
function getID($code)
{
if (is_null($code)) {
//root page
return null;
}
$code = rtrim($code, ' /');
$code = substr($code, strrpos($code, '/') !== false ? strrpos($code, '/') + 1 : 0);
return is_numeric($code) ? (int) $code : \cf\query2var("SELECT id FROM cf_page WHERE code=:code", array('code' => $code));
}
