hi dp expert coder I need your help..here my site: listwebsite.net if you register and create new auction you can't do it..is there someone who can help me.. Here the auction php code <?php global $main; $theviews = 1; mysql_query("UPDATE `auctions` SET `auction_views` = `auction_views` + $theviews WHERE `auction_id` = '{$main->page_data['auction_id']}'"); include ('php/inc.bbcode.php'); function alexaRank($domain){ $remote_url = 'http://data.alexa.com/data?cli=10&dat=snbamz&url='.trim($domain); $search_for = '<POPULARITY URL'; if ($handle = @fopen($remote_url, "r")) { while (!feof($handle)) { $part .= fread($handle, 100); $pos = strpos($part, $search_for); if ($pos === false) continue; else break; } $part .= fread($handle, 100); fclose($handle); } $str = explode($search_for, $part); $str = array_shift(explode('"/>', $str[1])); $str = explode('TEXT="', $str); return number_format($str[1]); } function get_google_backlinks_count($url) { $url = "http://ajax.googleapis.com/ajax/services/search/web?v=1.0&q=site:$url"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_REFERER, 'http://www.flipmarketplace.com/'); $response = curl_exec($ch); curl_close($ch); $json = json_decode($response); return $json -> responseData -> cursor -> estimatedResultCount; } function get_yahoo_backlinks_count($url) { $appid = 'Ky7Gl0bV34Gnp7csVyAexZS7JZ70DKtxt43ATx.fxM_OKBjnORygFv7PO208cBPD'; $url = "http://search.yahooapis.com/WebSearchService/V1/webSearch?appid=$appid&query=site:$url&results=1"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_REFERER, 'http://www.flipmarketplace.com/'); $response = curl_exec($ch); curl_close($ch); $xml = simplexml_load_string($response); return $xml -> attributes() -> totalResultsAvailable; } ?> <div class="main_grey"> <div id="auction_container"> <div id="auction_left"> <div class="abox"> <h2><?php echo $main->page_data['auction_title']; ?></h2> <h3><?php echo $main->page_data['auction_subtitle']; ?> - <? $q = mysql_query("SELECT * from `categories` WHERE `category_id` = '{$main->page_data['auction_category_id']}' LIMIT 1"); $r = mysql_fetch_assoc($q); echo $r['category_name']; ?></h3> <div id="summary"> <div id="leftt"> <div id="thumbnail"> <a href="/view/<?php echo $main->page_data['auction_id']; ?>"><img src="http://designussion.websnapr.com/?url=<?php echo $main->page_data['auction_url']; ?>&size=s&nocache=39"></a> </div> <?php $q = mysql_query("SELECT * FROM `attachments` WHERE `attachment_auction_id` = '{$main->page_data['auction_id']}' ORDER by RAND() LIMIT 2"); if (@mysql_num_rows($q)): echo '<ul id="thumbnails">'; while ($r = mysql_fetch_assoc($q)): ?> <li> <a href="/img/attachment/<?php echo $r['attachment_id']; ?>/" rel="heavybox[fullscreen]" target="_blank"> <img src="/img/thumbnail/<?php echo $r['attachment_id']; ?>/" alt="" title=" (Click to view attachment)" /> </a> </li> <?php endwhile; echo '</ul>'; echo '<a href="#thumbers" id="seeall">see all thumbnails</a>'; endif; ?> </div> <div id="rightt"> <h4> <?php if(($main->page_data['auction_time_end'] - time()) < 0){ echo "Auction has ended and is closed for bidding"; } else { switch ($main->page_data['auction_status']) { default: case '1': echo "Auction open for bidding. "; if ($main->page_data['auction_reserve'] > 0): if ($r['bid_amount'] >= $main->page_data['auction_reserve']): echo "Reserve has been met"; else: echo "Reserve not met."; endif; endif; break; case '2': echo "The auction is closed for bidding"; break; case '3': echo "The auction has been won"; break; case '4': echo "The auction has recieved a BIN offer, pending sale"; break; } } ?></h4> <div id="bidding"> <dl> <?php if(($main->page_data['auction_time_end'] - time()) > 0){ switch ($main->page_data['auction_status']) { default: case '1': $q = mysql_query("SELECT `bid_amount` FROM `bids` WHERE `bid_auction_id` = '{$main->page_data['auction_id']}' && `bid_approved` = '1' ORDER BY `bid_time` DESC LIMIT 1"); if (@mysql_num_rows($q)): $r = mysql_fetch_assoc($q); $current_bid = $r['bid_amount']; ?> <dt>Current Bid: </dt> <dd>$<?php echo number_format($r['bid_amount']); ?></dd> <?php else: ?> <dt>Current Bid: </dt> <dd>No Bids</dd> <dt>Minimum Bid: </dt> <dd>$<?php echo number_format($main->page_data['auction_starting_bid']); ?></dd> <?php endif; ?> <?php if ($main->auth['user_id'] !== $main->page_data['auction_user_id']): ?> <dt>Your Bid:</dt> <dd> <form method="post" action="<? if($main->auth['logged_in']){ ?>/place-bid/<?php echo $main->page_data['auction_id']; ?><? } else {?>/login/<? } ?>"> <fieldset> <div class="arroww"> <input type="text" name="amount" id="putinbid" class="text"> <input type="image" src="/imgs/summary_placebid.gif" name="placebid" id="putinbinbutton"> </div> <div class="arroww2"> <i>(Enter $<?php echo number_format($main->page_data['auction_starting_bid']) ?> or more)</i> </div> </fieldset> </form> </dd> <?if ($main->page_data['auction_bin'] > 0): ?> <dt>Buy It Now:</dt> <dd> <form method="post" action="<? if($main->auth['logged_in']){ ?>/place-bin/<?php echo $main->page_data['auction_id']; ?><? } else {?>/login/<? } ?>"> <fieldset > <label>$<?php echo number_format($main->page_data['auction_bin']); ?></label> <input type="image" src="/imgs/summary_placebin.gif" name="buyitnow" id="putinbinbutton"> </fieldset> </form> </dd> <?php endif; ?> <?php endif; ?> <?php break; case '2': break; case '3': break; case '4': break; } } ?> <dt>Bid History:</dt> <dd><? $q = mysql_query("SELECT `bid_amount` FROM `bids` WHERE `bid_auction_id` = '{$main->page_data['auction_id']}'"); echo @mysql_num_rows($q)." bids"; ?></dd> <dt>Ending:</dt> <dd><?php if(($main->page_data['auction_time_end'] - time()) < 0){ echo "Auction Ended"; } else { echo time_left($main->page_data['auction_time_end'] - time()); } ?></dd> <dt>Listed:</dt> <dd><?php echo date("D M j G:i:s T Y", $main->page_data['auction_time_listed']); ?></dd> </dl> </div> </div> </div> <h5 style="padding-top: 30px;">Payment Methods</h5> <? if($main->page_data['auction_payment_eft'] == 1){ echo '<p><strong>Accepts payment via Escrow.com: Yes </strong>(<a href="/help/escrow">what?</a>)</p>'; } else { echo '<p ><strong>Accepts payment via Escrow.com: No </strong>(<a href="/help/escrow">what?</a>)</p>'; } if($main->page_data['auction_payment_cc'] == 1 || $main->page_data['auction_payment_paypal'] == 1 || $main->page_data['auction_payment_wu'] == 1){ echo "<p>Seller also accepts: "; $i = 0; if($main->page_data['auction_payment_paypal'] == 1){ echo 'Paypal'; $i++; } if($main->page_data['auction_payment_cc'] == 1){ if($i > 0){ echo ", "; } echo 'Visa Credit Card'; } if($main->page_data['auction_payment_wu'] == 1){ if($i > 0){ echo ", "; } echo 'Western Union'; } echo "</p>"; } ?> <h5 style="margin-top: 30px;">Auction Description</h5> <p><?php echo BBCode($main->page_data['auction_description']);?></p> </div> <div class="abox" id="thumbers"> <h5>Auction Thumbnails<?php if ($main->auth['user_id'] == $main->page_data['auction_user_id']): ?> <em class="nb"><a href="/upload-attachment/<?php echo $main->page_data['auction_id']; ?>/" rel="heavybox[400,300]">Upload Attachments</a></em><?php endif; ?></h5> <ul id="thethumbs"> <?php $q = mysql_query("SELECT * FROM `attachments` WHERE `attachment_auction_id` = '{$main->page_data['auction_id']}'"); if (@mysql_num_rows($q)): while ($r = mysql_fetch_assoc($q)): ?> <li> <a href="/img/attachment/<?php echo $r['attachment_id']; ?>/" rel="heavybox[fullscreen]" target="_blank"> <img src="/img/thumbnail/<?php echo $r['attachment_id']; ?>/" alt="" title=" (Click to view attachment)" /> </a> </li> <?php endwhile; else: ?> No attachments have been uploaded for this listing. <?php endif; ?> </div> <?php $sql = "SELECT * FROM `comments` LEFT JOIN `users` ON `user_id` = `comment_user_id` WHERE `comment_auction_id` = '{$main->page_data['auction_id']}' ORDER BY `comment_id` ASC"; $q = mysql_query($sql); $comments_numba = mysql_num_rows($q); ?> <div class="abox"> <h5><? echo $comments_numba;?> Comments</h5> <a name="comments"></a> <div id="comment-list"> <ol id="auction-questions" class="auction-questions"> <?php while ($r = mysql_fetch_assoc($q)): ?> <li id="<?php echo $r['comment_id']; ?>"> <div class="acomment<? if($main->page_data['user_name'] == $r['user_name']){ echo " owner"; } ?>"> <h6><a href="/user/<?php echo $r['user_id']; ?>/"><?php echo $r['user_name']; ?></a><?= howlongago($r['comment_time']);?></h6> <p><?php echo nl2br(bb_parse(htmlspecialchars($r['comment_body']))); ?></p> </div> </li> <?php endwhile; if (!mysql_num_rows($q)): ?> There are no comments for this auction. <?php endif; ?> </ol> </div> <form method="post" id="postcomments" action="/" enctype="multipart/form-data" class="form" onsubmit="return add_comment(<?php echo $main->page_data['auction_id']; ?>);"> <h5>Add a Comment</h5> <?php if ($main->auth['logged_in']): ?> <input type="hidden" name="action" value="comment" /> <textarea name="body" id="body"></textarea> <input type="image" src="/imgs/submit_comment.gif"/> <?php else: ?> <p>If you were <a href="/login/">logged in</a> you could post a question.</p> <?php endif; ?> </form> </div> </div> <div id="auction_right"> <div class="abox"> <h5>Auction Statistics</h5> <?php echo BBCode($main->page_data['auction_views']);?> views </div> <? if ($main->auth['user_id'] == $main->page_data['auction_user_id']): ?> <div class="abox"> <h5>Administrator Functions</h4> <ul> <li><a href="/promote/<?php echo $main->page_data['auction_id']; ?>/" title="Promote Your Auction">Promote Auction</a></li> <li><a href="/auction-status/<?php echo $main->page_data['auction_id']; ?>/" rel="heavybox[400,350]" title="Change Auction Status">Change Auction Status</a></li> <li><a href="/edit-auction/<?php echo $main->page_data['auction_id']; ?>/">Edit Auction Details</a></li> <li><a href="/upgrade-auction/<?php echo $main->page_data['auction_id']; ?>/">Upgrade This Auction</a></li> </ul> </div> <?php elseif ($main->auth['user_admin'] == 1): ?> <div class="abox"> <h5>Administrator Functions</h4> <ul> <li><<a href="/delete-auction/<?php echo $main->page_data['auction_id']; ?>/">Delete Auction</a></li> <li><a href="/edit-auction/<?php echo $main->page_data['auction_id']; ?>/">Edit Auction Details</a></li> <li><a href="/upgrade-auction/<?php echo $main->page_data['auction_id']; ?>/">Upgrade This Auction</a></li> </ul> </div> <?php endif; ?> <? if ($main->auth['user_id'] == $main->page_data['auction_user_id']){ $q = mysql_query("SELECT `bids`.*, `users`.* FROM `bids` LEFT JOIN `users` ON `user_id` = `bid_user_id` WHERE `bid_auction_id` = '{$main->page_data['auction_id']}' && `bid_approved` = '1' ORDER BY `bid_id` DESC"); if (@mysql_num_rows($q)){ echo '<div class="abox">'; echo '<h5>Approved Offers</h5>'; echo '<ul class="manageoffers">'; while ($r = mysql_fetch_assoc($q)){ echo '<li>'; echo '<h4><a href="/user/'.$r['bid_user_id'].'">'.$r['user_name'].'</a></h4>'; echo '<p>$'.number_format($r['bid_amount']).' on '.date('M j g:iA', $r['bid_time']).'</p>'; echo '<h6><a href="/disapprove-bid/'.$r['bid_id'].'">disapprove</a> | <a href="/delete-bid/'.$r['bid_id'].'">delete</a> | <a href="/whispers/?compose=1&user='.$r['user_id'].'" class="msg">Message User</a></h6>'; echo '</li>'; } echo '</ul>'; echo '</div>'; } $q = mysql_query("SELECT `bids`.*, `users`.* FROM `bids` LEFT JOIN `users` ON `user_id` = `bid_user_id` WHERE `bid_auction_id` = '{$main->page_data['auction_id']}' && `bid_approved` = '0' ORDER BY `bid_id` DESC"); if (@mysql_num_rows($q)){ echo '<div class="abox">'; echo '<h5>Not Approved Offers</h5>'; echo '<ul class="manageoffers">'; while ($r = mysql_fetch_assoc($q)){ echo '<li>'; echo '<h4><a href="/user/'.$r['bid_user_id'].'">'.$r['user_name'].'</a></h4>'; echo '<p>$'.number_format($r['bid_amount']).' on '.date('M j g:iA', $r['bid_time']).'</p>'; echo '<h6><a href="/approve-bid/'.$r['bid_id'].'">approve</a> | <a href="/delete-bid/'.$r['bid_id'].'">delete</a> | <a href="/whispers/?compose=1&user='.$r['user_id'].'" class="msg">Message User</a></h6>'; echo '</li>'; } echo '</ul>'; echo '</div>'; } } ?> <? $str = md5($main->page_data['user_id']).'_'.md5(split_url($main->page_data['auction_url'],'host')); $siteverified = 1; if ($main->auth['logged_in'] && $main->auth['user_id'] == $main->page_data['auction_user_id']){ if(!verify_site(split_url($main->page_data['auction_url'], 'host'),$str)){ echo '<div class="abox"><h5><span style="color: red;">Please verify your ownership</span></h5><script type="text/javascript"> function highlight(field) { field.focus(); field.select(); } </script> Create a text file called "<b>site_verify.txt</b>" with the following content in, and upload to your main directory to verify'; echo '<input type="text" value="'.$str.'" onClick="highlight(this)" id="verifybox">'; echo '</div>'; $siteverified = 2; } } else { if(!verify_site(split_url($main->page_data['auction_url'], 'host'),$str)){ $siteverified = 3; } } if($siteverified == 1){ echo '<div class="abox"><h5>Site Verification</h5>Site Access has been verified!</div>'; } elseif($siteverified == 3){ echo '<div class="abox"><h5>Site Verification</h5>Site Access has <b><u>not</u></b> been verified</div>'; } ?> <div class="abox"> <h5>Site Details <span>(claimed by seller)</span></h5> <ul> <li><span>Domain URL:</span> <a href="/view/<?php echo $main->page_data['auction_id']; ?>" target="_blank"><?php echo split_url($main->page_data['auction_url'], 'host'); ?></a></li> <li><span>Listed:</span> <?php echo date('F jS, Y', $main->page_data['auction_time_listed']); ?></li> <? if(!$main->page_data['auction_established']){ } else {?> <li><span>Established:</span> <?php echo date('F jS, Y', $main->page_data['auction_established']); ?></li> <? } ?> <li><span>Monthly Traffic:</span> <?php echo number_format($main->page_data['auction_traffic']); ?></li> <li><span>Monthly Revenue:</span> $<?php echo number_format($main->page_data['auction_revenue']); ?></li> </ul> </div> <? if ($main->auth['logged_in']){ ?> <div class="abox"> <h5>Your Watch List</h5> <ul> <li><? $q = mysql_query("SELECT * FROM `watching` WHERE `watching_auction_id` = '{$main->page_data['auction_id']}' && `watching_user_id` = '{$main->auth[user_id]}' LIMIT 1"); if (mysql_num_rows($q) == 1){ ?> <a href="/watch/remove/<?php echo $main->page_data['auction_id']; ?>">Remove this from your watch list</a> <? } else { ?> <a href="/watch/add/<?php echo $main->page_data['auction_id']; ?>">Add this to your watch list</a> <? } ?></li> </ul> </div> <? } ?> <div class="abox"> <h5>Domain Statistics</h5> <ul> <li><span>Domain Registrar:</span> <?php echo $main->page_data['auction_domain_registrar'] ?></li> <li><span>Domain Created:</span> <?php echo $main->page_data['auction_domain_created'] ?></li> <li><span>Full Whois Data:</span> <a href="http://whois.sc/<?php echo split_url($main->page_data['auction_url'], 'host'); ?>" target="_blank">Click here to view</a></li> <li><span>Alexa Rank:</span> <?php echo alexaRank($main->page_data['auction_url']);?></li> <li><span>Google Backlinks:</span> <?php echo get_google_backlinks_count($main->page_data['auction_url']);?></li> <li><span>Yahoo Backlinks:</span> <?php echo get_yahoo_backlinks_count($main->page_data['auction_url']);?></li> </ul> </div> <div class="abox"> <h5>Seller Statistics</h5> <ul> <?php $sql = "SELECT SUM(`feedback_points`) as `total` FROM `feedback` WHERE `feedback_seller_id` = '{$main->page_data['auction_user_id']}'"; $q1 = mysql_query($sql); $r1 = mysql_fetch_assoc($q1); $total_points = $r1['total']; if(empty($total_points)){ $total_points = 0;} $sql3 = mysql_query("SELECT * FROM `feedback` WHERE `feedback_seller_id` = '{$main->page_data['auction_user_id']}'"); $total_positives = 0; $total_feedback = mysql_num_rows($sql3); while ($r3 = mysql_fetch_assoc($sql3)){ if($r3['feedback_points'] == "0"){ $total_feedback = $total_feedback-1; } elseif($r3['feedback_points'] == "1"){ $total_positives = $total_positives+1; } } if($total_positives == "0" || $total_feedback == "0"){ $total_percentage = 0; } else { $total_percentage = $total_positives/$total_feedback; $total_percentage = ceil($total_percentage*60); } if($main->page_data['phone_verified'] == 1){ $total_percentage = $total_percentage+40; } $q = mysql_query("SELECT * from `users` WHERE `user_id` = '{$main->page_data['auction_user_id']}' LIMIT 1"); $r = mysql_fetch_assoc($q); ?> <li><span>User:</span> <a href="/user/<?=$main->page_data['auction_user_id'];?>"><?= $r['user_name'];?></a></li> <li><span>Feedback:</span> <a href="/user/<?=$main->page_data['auction_user_id'];?>"><?=$total_points;?> Points</a></li> <li><span>Feedback Percentage:</span> <a href="/user/<?=$main->page_data['auction_user_id'];?>"><?=$total_percentage;?>%</a></li> <li><span>Verified by Phone:</span> <? if($main->page_data['phone_verified'] == 1){ echo "Yes"; } else { echo "No"; } ?></li> <li><span>Whisper Seller</span> <a href="/whispers/?compose=1&user=<?= $main->page_data['auction_user_id'];?>">Click Here</a></li> </div> </div></div> </div> </div> <?php function verify_site($url,$string){ if($content = get_url($url.'/site_verify.txt')){ if($content == $string || substr($content, 0, -1) == $string) return true; } return false; } function get_url($url){ $c = curl_init($url); curl_setopt($c,CURLOPT_RETURNTRANSFER,true); curl_setopt($c,CURLOPT_FOLLOWLOCATION,true); curl_setopt($c,CURLOPT_TIMEOUT,2); $content = curl_exec($c); $info = curl_getinfo($c); curl_close($c); if($info['http_code'] == 200) return $content; return false; } class Alexa { const CURL_TIMEOUT = 2; const ALEXA_SITE_INFO_URL = 'http://www.alexa.com/siteinfo/'; private $domain = NULL; public function __construct($domain = NULL) { if (!is_null($domain)) { $this->domain = $domain; } else { throw new Exception('You must pass domain name to constructor!'); } } public function setDomain($domain) { $this->domain = $domain; } public function getAlexaRank() { $response = $this->get(self::ALEXA_SITE_INFO_URL . $this->domain); $regexp = '#<div class="data .+?"><img src="\/images\/icons\/globe-sm.+?"/>(.*?)</div>#si'; preg_match($regexp, $response, $matches); if(!isset($matches[1])) return false; preg_match('#[\d,]+#s', $matches[1], $m); if(!isset($m[0])) return false; return $m[0]; } protected function get($url) { $hCurl = curl_init($url); curl_setopt($hCurl, CURLOPT_TIMEOUT, self::CURL_TIMEOUT); curl_setopt($hCurl, CURLOPT_RETURNTRANSFER, TRUE); return curl_exec($hCurl); } } ?> PHP:
you are posting in the wrong forum, this forum dedicated to Optigold ISP software you should post your question in this forum: http://forums.digitalpoint.com/forumdisplay.php?f=37