fork(1) download
  1. <? #//v.3.2.1
  2. #///////////////////////////////////////////////////////
  3. if (!file_exists("includes/passwd.inc.php")) {
  4. echo "<script>document.location.href='install.php'</script>";
  5. } else {
  6. #///////////////////////////////////////////////////////
  7.  
  8. require_once ('./includes/config.inc.php');
  9.  
  10. #// Run cron according to SETTINGS
  11. if($SETTINGS['cron'] == 2)
  12. {
  13. include_once "cron.php";
  14. }
  15. require_once ("./header.php");
  16.  
  17. function get_next_bid($auction_id) {
  18.  
  19. if (intval($auction_id)>0) {
  20. $result = mysql_query("SELECT * FROM BPPENNYAUTOBID_auctions WHERE id=" . intval($auction_id));
  21. $result_bids = mysql_query("select max(bid) AS maxbid, bidder FROM BPPENNYAUTOBID_bids WHERE auction=" . intval($auction_id) . " GROUP BY auction, bidder ORDER BY maxbid DESC");
  22.  
  23. $customincrement = mysql_result($result, 0, "increment");
  24. $max_bid = mysql_result($result_bids, 0, "maxbid");
  25. $minimum_bid = mysql_result($result, 0, "minimum_bid");
  26. if($max_bid == 0) {
  27. $MAX_BID = $minimum_bid;
  28. //// Added by Yosi 22 Jul 2009 - consider if auction starts with some value
  29. $max_bid = $minimum_bid;
  30. }else
  31. {
  32. $MAX_BID = $max_bid;
  33. }
  34. /* Get bid increment for current bid and calculate minimum bid */
  35.  
  36. $query = "SELECT increment FROM BPPENNYAUTOBID_increments WHERE " . "((low <= $MAX_BID AND high >= $MAX_BID) OR " . "(low < $MAX_BID AND high < $MAX_BID)) ORDER BY increment DESC";
  37.  
  38. //echo "<div style='display:none;'>sql:<br>";
  39. //echo "$query</div>";
  40.  
  41. $result_incr = mysql_query($query);
  42. if(mysql_num_rows($result_incr) != 0)
  43. {
  44. $increment = mysql_result($result_incr, 0, "increment");
  45. }
  46. if($customincrement > 0)
  47. {
  48. $increment = $customincrement;
  49. }
  50.  
  51. if($max_bid == 0 || $atype == 2)
  52. {
  53. $next_bid = $minimum_bid;
  54. }else
  55. {
  56. $next_bid = $max_bid + $increment;
  57. }
  58. return $next_bid;
  59. } else {
  60. return 0;
  61. }
  62. }
  63. function get_winner_name($auction_id) {
  64. $sql = "SELECT b.bid, b.bidder, COUNT(bid) AS bid_count,u.nick
  65. FROM BPPENNYAUTOBID_bids b
  66. INNER JOIN BPPENNYAUTOBID_users u ON b.bidder=u.id
  67. WHERE b.auction=".$auction_id." GROUP BY b.bid ORDER BY b.bid DESC ";
  68. $result = mysql_query($sql);
  69. if ($row1=mysql_fetch_array($result)) {
  70. return $row1['nick'];
  71. } else {
  72. return "";
  73. }
  74. }
  75.  
  76. $TIME = mktime(date("H") + $SETTINGS['timecorrection'], date("i"), date("s"), date("m"), date("d"), date("Y"));
  77. //echo "<br />";
  78. $NOW = date("YmdHis", $TIME);
  79. /*
  80. prepare data for templates/template
  81. */
  82. /* prepare categories list for templates/template */
  83. # Prepare categories sorting
  84. if($SETTINGS['catsorting'] == 'alpha')
  85. {
  86. $catsorting = " ORDER BY t.cat_name ASC";
  87. }else
  88. {
  89. $catsorting = " ORDER BY sub_counter DESC";
  90. }
  91. $TPL_categories_value = "";
  92. $query = "select distinct * from BPPENNYAUTOBID_categories c, BPPENNYAUTOBID_cats_translated t
  93. WHERE c.parent_id=0
  94. AND t.cat_id=c.cat_id
  95. AND t.lang='" . $USERLANG . "'
  96. $catsorting";
  97. $result = mysql_query($query);
  98. if(!$result)
  99. {
  100. MySQLError($query);
  101. exit();
  102. }else
  103. {
  104. $num_cat = mysql_num_rows($result);
  105. $i = 0;
  106. $TPL_categories_value = "<ul>\n";
  107. while($i < $num_cat && $i < $SETTINGS['catstoshow'])
  108. {
  109. $catlink = "";
  110. $cat_id = mysql_result($result, $i, "cat_id");
  111. $cat_name = mysql_result($result, $i, "cat_name");
  112. $sub_count = intval(mysql_result($result, $i, "sub_counter"));
  113. $cat_colour = mysql_result($result, $i, "cat_colour");
  114. $cat_image = mysql_result($result, $i, "cat_image");
  115. $cat_counter = (int)mysql_result($result, $i, "counter");
  116. if($sub_count != 0)
  117. $cat_counter = "(" . $sub_count . ")";
  118. else
  119. {
  120. $cat_counter = "";
  121. }
  122. $cat_url = "./browse.php?id=$cat_id";
  123. if($cat_image != "")
  124. {
  125. $catlink = "<A HREF=\"$cat_url\"><IMG SRC=\"$cat_image\" BORDER=0></a>";
  126. }
  127. #// Select the translated category name
  128. $cat_name = @mysql_result(mysql_query("SELECT cat_name FROM BPPENNYAUTOBID_cats_translated WHERE cat_id=$cat_id AND lang='" . $USERLANG . "'"), 0, "cat_name");
  129. $catlink .= "<A HREF=\"$cat_url\">$cat_name</A>" . " $cat_counter";
  130. if($cat_colour != "")
  131. {
  132. $catlink = setsspan($catlink, "background-color:$cat_colour");
  133. }
  134. $TPL_categories_value .= "<li>" . $catlink . "</li>\n";
  135. $i++;
  136. }
  137. $TPL_categories_value .= "</ul>\n";
  138. $TPL_categories_value .= "<A HREF=\"browse.php?id=0\">$MSG_277</A>";
  139. }
  140.  
  141.  
  142.  
  143. /********************************************************************************************/
  144. //------------------------------------------------------------------------------
  145. // prepare classic auctions values (get last created auctions)
  146.  
  147. $query = "SELECT id,title,starts, ends, pict_url, auction_type, item_value, minimum_bid, bid_value FROM BPPENNYAUTOBID_auctions WHERE closed='0' AND suspended=0 AND auction_type = 1 AND is_main_auction = 0 AND ";
  148. if($SETTINGS['adultonly'] == 'y' && !isset($_SESSION["BPPENNYAUTOBID_LOGGED_IN"]))
  149. {
  150. $query .= "adultonly='n' AND ";
  151. }
  152. if($category_id != ""){
  153. if (subCategoriesList($category_id) !="") {
  154. $query .= "(category = ".$category_id." OR category IN (".subCategoriesList($category_id).")) AND ";
  155. } else {
  156. $query .= "category = ".$category_id." AND ";
  157. }
  158. }
  159. $query .= "starts <= " . $NOW . " ORDER BY ends ASC LIMIT " . $SETTINGS['lastitemsnumber'];
  160.  
  161. $result = mysql_query($query);
  162.  
  163.  
  164. if($result)
  165. $num_auction = mysql_num_rows($result);
  166. else
  167. $num_auction = 0;
  168. $i = 0;
  169. $TPL_auctions_classic = array();
  170.  
  171. while($i < $num_auction)
  172. {
  173.  
  174.  
  175. $title = mysql_result($result, $i, "title");
  176. $id = mysql_result($result, $i, "id");
  177. $date = mysql_result($result, $i, "ends");
  178. $pict_url = mysql_result($result, $i, "pict_url");
  179. if($pict_url == "")
  180. {
  181. $pict_url = 'no_image.png';
  182. }
  183. $auction_type = mysql_result($result, $i, "auction_type");
  184. $item_value = mysql_result($result, $i, "item_value");
  185. $bid_value = mysql_result($result, $i, "bid_value");
  186. $year = substr($date, 0, 4);
  187. $month = substr($date, 4, 2);
  188. $day = substr($date, 6, 2);
  189. $hours = substr($date, 8, 2);
  190. $minutes = substr($date, 10, 2);
  191. $seconds = substr($date, 12, 2);
  192. $minimum_a_bid = mysql_result($result, $i, "minimum_bid");
  193. $sql="SELECT MAX(bid) AS max_bid FROM BPPENNYAUTOBID_bids WHERE auction=".$id;
  194. $result_bid = mysql_query($sql);
  195.  
  196. #// Check bold and highlighted options
  197. $ISBOLD = FALSE;
  198. $ISHIGHLIGHTED = FALSE;
  199. $TPL_auctions_classic[$i] = array();
  200. $TPL_auctions_classic[$i]["date_created"] = $month . "/" . $day . "/" . $year . " " . $hours . ":" . $minutes . ":" . $seconds;
  201. $TPL_auctions_classic[$i]["remained_seconds"]=strtotime($TPL_auctions_classic[$i]["date_created"])-time();
  202. //ArrangeDateNoCorrection($day,$month,$year,$hours,$minutes);
  203. $TPL_auctions_classic[$i]["name"] = stripslashes($title);
  204. $TPL_auctions_classic[$i]["link_href"] = "./item.php?id=".$id."&history=view#history";
  205. $TPL_auctions_classic[$i]["pict_url"] = $pict_url;
  206. $TPL_auctions_classic[$i]["item_value"] = stripslashes($item_value);
  207. $TPL_auctions_classic[$i]["bid_value"] = stripslashes($bid_value);
  208. $TPL_auctions_classic[$i]["next_bid"]=get_next_bid($id);
  209. $TPL_auctions_classic[$i]["winner"]=get_winner_name($id);
  210. $TPL_auctions_classic[$i]["current_bid"]=mysql_result($result_bid, 0, "max_bid");
  211. if ($TPL_auctions_classic[$i]["current_bid"]=="") {
  212. $TPL_auctions_classic[$i]["current_bid"]=$minimum_a_bid;
  213. }
  214. $TPL_auctions_classic[$i]["auction_id"] = $id;
  215. $i++;
  216. }
  217.  
  218.  
  219.  
  220.  
  221. /********************************************************************************************/
  222. //------------------------------------------------------------------------------
  223. // prepare "more live auctions"
  224. $query = "SELECT id,title,starts, ends, pict_url, auction_type, item_value, minimum_bid, bid_value FROM BPPENNYAUTOBID_auctions WHERE closed='0' AND suspended=0 AND auction_type = 1 AND is_main_auction = 0 AND ";
  225. if($SETTINGS['adultonly'] == 'y' && !isset($_SESSION["BPPENNYAUTOBID_LOGGED_IN"]))
  226. {
  227. $query .= "adultonly='n' AND ";
  228. }
  229. if($category_id != ""){
  230. if (subCategoriesList($category_id) !="") {
  231. $query .= "(category = ".$category_id." OR category IN (".subCategoriesList($category_id).")) AND ";
  232. } else {
  233. $query .= "category = ".$category_id." AND ";
  234. }
  235. }
  236.  
  237. $query .= "starts <= " . $NOW . " ORDER BY ends ASC LIMIT " . ($SETTINGS['lastitemsnumber']).",30";
  238.  
  239. $result = mysql_query($query);
  240.  
  241.  
  242. if($result)
  243. $num_auction1 = mysql_num_rows($result);
  244. else
  245. $num_auction1 = 0;
  246. $i = 0;
  247. $TPL_more_auctions = array();
  248. while($i < $num_auction1)
  249. {
  250.  
  251.  
  252. $title = mysql_result($result, $i, "title");
  253. $id = mysql_result($result, $i, "id");
  254. $date = mysql_result($result, $i, "ends");
  255. $pict_url = mysql_result($result, $i, "pict_url");
  256. if($pict_url == "")
  257. {
  258. $pict_url = 'no_image.png';
  259. }
  260. $auction_type = mysql_result($result, $i, "auction_type");
  261. $item_value = mysql_result($result, $i, "item_value");
  262. $bid_value = mysql_result($result, $i, "bid_value");
  263. $year = substr($date, 0, 4);
  264. $month = substr($date, 4, 2);
  265. $day = substr($date, 6, 2);
  266. $hours = substr($date, 8, 2);
  267. $minutes = substr($date, 10, 2);
  268. $seconds = substr($date, 12, 2);
  269. $minimum_a_bid = mysql_result($result, $i, "minimum_bid");
  270. $sql="SELECT MAX(bid) AS max_bid FROM BPPENNYAUTOBID_bids WHERE auction=".$id;
  271. $result_bid = mysql_query($sql);
  272.  
  273. #// Check bold and highlighted options
  274. $ISBOLD = FALSE;
  275. $ISHIGHLIGHTED = FALSE;
  276. $TPL_more_auctions[$i] = array();
  277. $TPL_more_auctions[$i]["date_created"] = $month . "/" . $day . "/" . $year . " " . $hours . ":" . $minutes . ":" . $seconds;
  278. $TPL_more_auctions[$i]["remained_seconds"]=strtotime($TPL_more_auctions[$i]["date_created"])-time();
  279. //ArrangeDateNoCorrection($day,$month,$year,$hours,$minutes);
  280. $TPL_more_auctions[$i]["name"] = stripslashes($title);
  281. $TPL_more_auctions[$i]["link_href"] = "./item.php?id=".$id."&history=view#history";
  282. $TPL_more_auctions[$i]["pict_url"] = $pict_url;
  283. $TPL_more_auctions[$i]["item_value"] = stripslashes($item_value);
  284. $TPL_more_auctions[$i]["bid_value"] = stripslashes($bid_value);
  285. $TPL_more_auctions[$i]["next_bid"]=get_next_bid($id);
  286. $TPL_more_auctions[$i]["winner"]=get_winner_name($id);
  287. $TPL_more_auctions[$i]["current_bid"]=mysql_result($result_bid, 0, "max_bid");
  288. $TPL_more_auctions[$i]["auction_id"] = $id;
  289. if ($TPL_more_auctions[$i]["current_bid"]=="") {
  290. $TPL_more_auctions[$i]["current_bid"]=$minimum_a_bid;
  291. }
  292. $i++;
  293. }
  294.  
  295. $open_auction_num=$num_auction+$num_auction1;
  296.  
  297. /****************************************************************************************/
  298. /**
  299.  * NOTE: get higher bids
  300.  */
  301. $TPL_maximum_bids = "";
  302. $query = "select auction,max(bid) AS max_bid
  303. FROM BPPENNYAUTOBID_bids b, BPPENNYAUTOBID_auctions a WHERE a.suspended=0 AND a.closed=0 AND a.id=b.auction GROUP BY b.bid,b.auction ORDER BY max_bid desc";
  304. $result = mysql_query($query);
  305. if($result)
  306. $num_auction = mysql_num_rows($result);
  307. else
  308. $num_auction = 0;
  309. $i = 0;
  310. $j = 0;
  311. $bgcolor = "#FFFFFF";
  312. $AU = array();
  313. while($i < $num_auction && $j < $SETTINGS['higherbidsnumber'])
  314. {
  315. $max_bid = mysql_result($result, $i, "max_bid");
  316. $auction = mysql_result($result, $i, "auction");
  317. //-- Get auction data
  318. $query = "SELECT title,closed,id from BPPENNYAUTOBID_auctions
  319. WHERE id=\"$auction\" AND";
  320. $query .= "'" . $NOW . "'>=starts";
  321. //print $query;
  322. $result_bid = mysql_query($query);
  323. if(mysql_num_rows($result_bid) > 0)
  324. {
  325. $title = mysql_result($result_bid, 0, "title");
  326. $closed = mysql_result($result_bid, 0, "closed");
  327. $auc_id = mysql_result($result_bid, 0, "id");
  328. }
  329. if($closed == "0" && !in_array($auction, $AU))
  330. {
  331. #// Check bold and highlighted options
  332. $ISBOLD = FALSE;
  333. $ISHIGHLIGHTED = FALSE;
  334. $TPL_maximum_bids .= "
  335. <p style=\"background-color:$bgcolor;display:block\"><A HREF=javascript:window_open('converter.php?AMOUNT=$max_bid','incre',650,200,30,30)>" . print_money($max_bid) . "&nbsp;<A HREF=\"./item.php?id=$auc_id\">";
  336. if($ISHIGHLIGHTED)
  337. {
  338. $TPL_maximum_bids .= "<SPAN CLASS=hg>";
  339. }
  340. if($ISBOLD)
  341. {
  342. $TPL_maximum_bids .= "<B>";
  343. }
  344. $TPL_maximum_bids .= stripslashes($title);
  345. if($ISBOLD)
  346. {
  347. $TPL_maximum_bids .= "</B>";
  348. }
  349. if($ISHIGHLIGHTED)
  350. {
  351. $TPL_maximum_bids .= "</SPAN>";
  352. }
  353. $TPL_maximum_bids .= "</A></p>";
  354. if($bgcolor == "#FFFFFF")
  355. {
  356. $bgcolor = $FONTCOLOR[$SETTINGS['headercolor']];
  357. }else
  358. {
  359. $bgcolor = "#FFFFFF";
  360. }
  361. $AU[] = $auction;
  362. $j++;
  363. }
  364. $i++;
  365. }
  366.  
  367. //-- Build news list
  368. if(($SETTINGS['newsbox'] == 1) && !isset($_SESSION["BPPENNYAUTOBID_LOGGED_IN"]))
  369. {
  370. $query = "SELECT title,id,new_date from BPPENNYAUTOBID_news where suspended=0 order by new_date DESC limit " . $SETTINGS['newstoshow'];
  371. $res = mysql_query($query);
  372. if(!$res)
  373. {
  374. MySQLError($query);
  375. exit();
  376. }
  377.  
  378. $TPL_news_list = "";
  379. while($new = mysql_fetch_array($res))
  380. {
  381. $TPL_news_list .= "<div class='newsfont'>";
  382. $TR = @mysql_fetch_array(@mysql_query("SELECT title,content FROM BPPENNYAUTOBID_news_translated WHERE id=".intval($new['id'])." AND lang='".addslashes($language)."'"));
  383. $new['title']=$TR['title'];
  384. $new['content']=$TR['content'];
  385. $new_date = $new['new_date'];
  386. $F_date = FormatDate($new_date);
  387. $TPL_news_list .= "<div class='newstital'>
  388. <div class='icone'><img src='".$SETTINGS['siteurl']."themes/mytheme/img/icone.png' width='11' height='12' align='absmiddle' /></div>
  389. <div class='image'><a href='viewnew.php?id=".$new['id']."' class='newstitle'>".$new['title']."</a></div>
  390. </div>";
  391. $TPL_news_list .= $F_date." - ".substr($new['content'], 0, 90)."... <a href='viewnew.php?id=".$new['id']."' class='linkmore'>More</a>";
  392. $TPL_news_list .= "</div>";
  393. $TPL_news_list .= "<div class='image'><img src='".$SETTINGS['siteurl']."themes/mytheme/img/line.png' /></div>";
  394. }
  395.  
  396. }else
  397. {
  398. $TPL_news_list = "&nbsp;";
  399. }
  400. $TPL_news_list .= "&nbsp;&nbsp;<a href='viewallnews.php'>" . $MSG_31_0046 . "</a>";
  401. //-- Build closed auctions list
  402. $query = "SELECT DISTINCT
  403. a.title, a.id, a.pict_url,
  404. w.bid, w.winner, a.ends AS closingdate,
  405. w.bid,
  406. u.nick
  407. FROM BPPENNYAUTOBID_auctions a
  408. LEFT OUTER JOIN BPPENNYAUTOBID_winners w ON a.id = w.auction
  409. LEFT OUTER JOIN BPPENNYAUTOBID_users u ON w.winner = u.id
  410. WHERE
  411. auction_type = '1' AND closed = '1'
  412. ORDER BY ends DESC limit 0, 7";
  413. $res = mysql_query($query);
  414. if(!$res)
  415. {
  416. //MySQLError($query);
  417. //exit;
  418. }
  419. $TPL_closed_auctions_list = "";
  420. while($row = mysql_fetch_array($res))
  421. {
  422. $title = ((strlen($row['title']) > 12) ? substr($row['title'], 0, 12) . "..." : $row['title']);
  423. $closed_date = $row['closingdate'];
  424. $pict_url = $row['pict_url'];
  425. if($pict_url == "")
  426. {
  427. $pict_url = 'no_image.png';
  428. }
  429. $winner = ($row['winner'] != "") ? " Winner: " . $row['nick'] : "";
  430. $bid = ($row['bid'] != "") ? " Won bid: " . $row['bid'] : "";
  431. $F_date = FormatDate($closed_date);
  432. $TPL_closed_auctions_list .= "<div class='newsfont'>";
  433. $TPL_closed_auctions_list .= "<table><tr>";
  434. $TPL_closed_auctions_list .= "<td><a href=\"item.php?id=" . $row['id'] . "\">" . $title . "</a></td>";
  435. $TPL_closed_auctions_list .= "<td>" . $F_date . "</td>";
  436. $TPL_closed_auctions_list .= "</tr>";
  437. $TPL_closed_auctions_list .= "<tr>";
  438. if($row['pict_url']!="") {
  439. $TPL_closed_auctions_list .= "<td><a href=\"item.php?id=" . $row['id'] . "\" title='" . $row['title'] . "' ><img alt='" . $row['title'] . "' border='0' width='60px' height='60px' src='" . $SETTINGS['siteurl'] . "uploaded/" . $row["pict_url"] . "' style='filter:alpha(opacity=100);-moz-opacity:1.0; cursor:pointer; border:1px solid #cdcdcd;' onmouseover='makevisible(this,1)' onmouseout='makevisible(this,0)' /></a></td>";
  440. } else {
  441. $TPL_closed_auctions_list .= "<td><a href=\"item.php?id=" . $row['id'] . "\" title='" . $row['title'] . "' ><img alt='" . $row['title'] . "' border='0' width='60px' height='60px' src='" . $SETTINGS['siteurl'] . "images/no-image.jpg' style='filter:alpha(opacity=100);-moz-opacity:1.0; cursor:pointer; border:1px solid #cdcdcd;' onmouseover='makevisible(this,1)' onmouseout='makevisible(this,0)' /></a></td>";
  442. }
  443. $TPL_closed_auctions_list .= "<td>";
  444. $TPL_closed_auctions_list .= $MSG_40_020." <font style='color:#FF9900'><br /><b> " . print_money($row['bid'], 2, '.', ' ') . "</b></font><br>";
  445. $TPL_closed_auctions_list .= $MSG_40_021." <font style='color:#777777'><br /><b>" . $row['nick'] . "</b></font><br>";
  446. $TPL_closed_auctions_list .= "<td>";
  447. $TPL_closed_auctions_list .= "</tr></table>";
  448. $TPL_closed_auctions_list .= "</div>";
  449. }
  450.  
  451. $TPL_closed_auctions_list .= "<div class='image'><img src='".$SETTINGS['siteurl']."themes/mytheme/img/line.png' /></div>";
  452. $TPL_closed_auctions_list .= "&nbsp;&nbsp;<a href='viewallclosedauctions.php'>" . $MSG_31_0046 . "</a>";
  453.  
  454. require_once (phpa_include("template_index_php.html"));
  455. require_once ('./footer.php');
  456. }
  457. ?>
Success #stdin #stdout 0.02s 13112KB
stdin
Standard input is empty
stdout
<script>document.location.href='install.php'</script>