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)); }