$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';