$lastInsertedObject = $dbOut->getLastInsertedId();
$resultUsername = $dbOut->buildQuery("SELECT Username FROM sellers WHERE Username=%s", $userSeller['username']);
$usernameExist = $dbOut->getHasRows($resultUsername);
if (!$usernameExist) {
$dbOut->insert("sellers", $userSeller);
}
$newFormatCatObj = array("object_id" => $lastInsertedObject, "category_id" => $categoryIds[$objectArr['Categorie']]);
$dbOut->insert("object_in_category", $newFormatCatObj);
$result = $dbIn->buildQuery("SELECT * FROM Illustraties WHERE ItemID = %s", $objectArr['ID']);
$getFiles = $dbIn->fetchAssoc($result);
$newFormatPic = array("filename" => substr($getFiles['IllustratieFile'], 0, 37), "objectid" => $lastInsertedObject);
if (!empty($newFormatPic['filename'])) {
$dbOut->insert("files", $newFormatPic);
}
}
$objectVar = getObjects();
echo "Inserting objects\r\n";
foreach ($objectVar as $object) {
setObjects($object);
}
$objectsInsertTime = date('U') - ($beginTime + $categoryInsertTime + $secQuestionsInsertTime + $usersInsertTime);
echo "Done inserting objects. (took " . $objectsInsertTime . " seconds)\r\n\r\n";
echo "Fetching minimal bids.\r\n";
function getMinimalBids()
{
//Create array with minimal bids
$minimalBids = array(array("upper_limit" => 50, "raise" => 0.5), array("upper_limit" => 500, "raise" => 1), array("upper_limit" => 1000, "raise" => 5), array("upper_limit" => 5000, "raise" => 10), array("upper_limit" => 1000000, "raise" => 50));
return $minimalBids;
}
$minBidVar = getMinimalBids();
echo "Done fetching minimal bids.\r\n";
<?php
session_start();
include_once "connect.php";
function getObjects()
{
$sql = mysql_query("SELECT id, name, parent_id FROM objects");
$res = array();
while ($row = mysql_fetch_array($sql)) {
$res[$row["parent_id"]][] = $row;
}
return $res;
}
//В переменную $objects_arr записываем все объекты
$objects_arr = getObjects();
function OutTree($parent_id, $lvl)
{
global $objects_arr;
//Делаем переменную $objects_arr видимой в функции
$exp = "expand";
$aj_func = "javascript:show_descr(this);";
//$edit = "<a class='edit'>
if (isset($_SESSION['uid'])) {
$show = "";
$exp = "collapse";
$aj_func = "javascript:edit_object(this);";
} elseif ($parent_id == 0) {
$show = "";
} else {
$show = " class=\"collapsed\"";
}
public function getColumns()
{
$sql = <<<SQL
SELECT
f.attname AS name,
f.attnotnull AS notnull,
pg_catalog.format_type(f.atttypid,f.atttypmod) AS type,
CASE
WHEN p.contype = 'p' THEN 't'
ELSE 'f'
END AS primarykey,
CASE
WHEN p.contype = 'u' THEN 't'
ELSE 'f'
END AS uniquekey,
CASE
WHEN p.contype = 'f' THEN g.relname
END AS foreignkey,
CASE
WHEN p.contype = 'f' THEN p.confkey
END AS foreignkey_fieldnum,
CASE
WHEN p.contype = 'f' THEN g.relname
END AS foreignkey,
CASE
WHEN p.contype = 'f' THEN p.conkey
END AS foreignkey_connnum,
CASE
WHEN f.atthasdef = 't' THEN d.adsrc
END AS default
FROM pg_attribute f
JOIN pg_class c ON c.oid = f.attrelid
JOIN pg_type t ON t.oid = f.atttypid
LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
LEFT JOIN pg_class AS g ON p.confrelid = g.oid
WHERE c.relkind = 'r'::char
AND n.nspname = 'public'
AND c.relname = ? -- Replace with Schema name
AND f.attnum > 0 ORDER BY f.attnum;
SQL;
return getObjects($sql, $this->name);
}
function get_posts($token = null, $username = null, $olderThan = null)
{
global $error_message;
$db = new Database(df_db());
$user = get_user();
if (!$user) {
$error_message = "You are not logged in";
return false;
}
if (!$username) {
$username = $user;
}
if (!$olderThan) {
$olderThan = time();
}
$out = getObjects("select post_id, username, date_posted, comment, photo from posts where username=:username and date_posted <= :older_than", array('username' => $username, 'older_than' => $olderThan));
foreach ($out as $r) {
if ($o->photo) {
$o->photo = get_post_photo_url($o);
}
}
return $out;
}
