1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Can't create new auction

Discussion in 'Optigold ISP' started by googlecrawl, Aug 11, 2010.

0
  1. #1
    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:
     
    googlecrawl, Aug 11, 2010 IP
  2. googlecrawl

    googlecrawl Banned

    Messages:
    1,739
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    is there any body can help me please.
     
    googlecrawl, Aug 11, 2010 IP
  3. wgcom

    wgcom Peon

    Messages:
    157
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    wgcom, Aug 14, 2010 IP