$subitems = array();
if ($prop['Type'] > 5) {
$qq = mysql_query("select n.* from StorePropMulti n inner join StorePropValues v on v.Value=n.ID where v.PropID=" . intval($prop['ID']) . " and v.itemID=" . $book['ID']);
while ($subprop = mysql_fetch_assoc($qq)) {
$subitems[] = $subprop['Name'];
}
} elseif ($prop['Type'] == 5) {
$qq = mysql_query("select n.* from StorePropMulti n inner join StorePropValues v on v.Value=n.ID where v.PropID=" . intval($prop['ID']) . " and v.itemID=" . $book['ID']);
while ($subprop = mysql_fetch_assoc($qq)) {
$subitems = $subprop['Name'];
}
} elseif ($prop['Type'] == 4) {
$qq = mysql_fetch_assoc(mysql_query("select * from StorePropValues where PropID=" . intval($prop['ID']) . " and itemID=" . $book['ID']));
$subitems = $qq['Value'];
$oVotingView->_fRate = $subitems;
$subitems = $oVotingView->getSmallVoting(0, '');
} else {
$qq = mysql_fetch_assoc(mysql_query("select * from StorePropValues where PropID=" . intval($prop['ID']) . " and itemID=" . $book['ID']));
$subitems = $qq['Value'];
}
$prop['value'] = $subitems;
$props[] = $prop;
}
$book['props'] = $props;
$smarty->assign("book", $book);
$smarty->assign("categ", mysql_fetch_assoc(mysql_query("select * from StoreCategories where ID=" . $book['categoryID'])));
$smarty->assign("ap_seller", $seller);
if (!empty($photos)) {
$smarty->assign("photos", $photos);
}
$contact_type = 2;
* Whether you are running classifieds for autos, motorcycles, bicycles, rv's, guns,
* horses, or general merchandise, our product is the right package for you.
* It has template system and no limit to usage with free for any changes.
*
* Copyright (c) 2009-2013
*/
include "./include_php/init.php";
include "./include_php/TemplVotingView.php";
$type = intval($_GET['type']);
$id = intval($_GET['id']);
$book = mysql_fetch_assoc(mysql_query("select * from Store where type=" . ($type - 1) . " and ID=" . $id));
$categ = mysql_fetch_assoc(mysql_query("select * from StoreCategories where ID=" . $book['categoryID']));
$user = mysql_fetch_assoc(mysql_query("select * from Profiles where ID=" . intval($book['userID'])));
$oVotingView = new TemplVotingView('gvoting', 0);
$oVotingView->_fRate = $book['rating'];
$vote1 = $oVotingView->getSmallVoting(0, '');
$book['title_short'] = strlen($book['Title']) > 30 ? substr(htmlspecialchars($book['Title']), 0, 30) . '...' : htmlspecialchars($book['Title']);
$book['price'] = number_format($book['price'], 2, ".", "");
if ($type == 1) {
$book['url'] = 'product';
$book['prefix'] = '';
} else {
$book['url'] = 'wproduct';
$book['prefix'] = '_b';
}
$img = '';
$photos = array();
$q = mysql_query("select v.* from StorePropValues v inner join StoreProp p on p.ID=v.PropID where v.itemID=" . $id . " and p.Type=3 limit 1");
while ($arr = mysql_fetch_assoc($q)) {
if (is_file("./media/store/small_" . $arr['Value'])) {
$book['Photo1'] = $arr['Value'];
if ($profileID != $_SESSION['memberID']) {
$user = mysql_fetch_assoc(mysql_query("select * from Profiles where ID=" . $profileID));
} else {
$user = $_SESSION['memberINFO'];
}
$seller = $user;
$prof_photo = 'media/images/profile/' . $user['ID'] . '/thumb_' . $user['PrimPhoto'];
if (is_file($prof_photo)) {
$fileinfo = getimagesize($prof_photo);
$prof_photo = array("src" => $prof_photo, "width" => $fileinfo[0]);
$smarty->assign("prof_photo", $prof_photo);
}
$oVotingView = new TemplVotingView('gvoting', 0);
$votecount = intval($user['rating_count']);
$oVotingView->_fRate = $user['rating'];
$vote1 = $oVotingView->getSmallVoting(0, intval($votecount) . ' votes');
$rating = mysql_fetch_assoc(mysql_query("select * from ProfilesRating where userID=" . intval($_SESSION['memberID']) . " and voteID={$profileID}"));
$oVotingView->_fRate = intval($rating['rating']) > 0 ? intval($rating['rating']) : '1';
$voter = '<input type="hidden" name="review_rating" id="gvotingbig" value="' . (intval($rating['rating']) > 0 ? intval($rating['rating']) : '1') . '">' . $oVotingView->getBigVoting(intval($rating['rating']) > 0 ? '0' : '1', '');
$user['LastLoggedIn'] = $user['LastLoggedIn'] ? date("d-m-Y H:i", strtotime($user['LastLoggedIn'])) : "Never";
$user['city'] = mysql_fetch_assoc(mysql_query("select * from City where ID=" . intval($user['city'])));
$user['city'] = $user['city']['Title'];
$smarty->assign("user", $user);
$smarty->assign("ap_seller", $seller);
$smarty->assign("vote1", $vote1);
$smarty->assign("voter", $voter);
$order = isset($_REQUEST['border']) ? $_REQUEST['border'] : 'title';
$desc = isset($_REQUEST['bdesc']) ? true : false;
$books = array('order' => $order, 'desc' => $desc, 'cur_url' => '/profile.php?ID=' . $profileID, 'prefix' => 'b', 'list' => array());
if ($order == 'date') {
$order = 's.date';
