phpbb-auction.com Forum Index phpbb-auction.com
Download, Support, Documentation
 
Donate to phpbb-auction.com to support the project


phpbb-Auction
  Home
   - News
   - Bug report/Patches
   - Future Features
  Demo
  Downloads
   - Version 1.3m  (Core /Lang /Mods)
   - Version 1.2m  (Core /Lang /Mods)
   - Version 1.0m  (Core /Lang /Mods)
   - All
  Services
  Documentation
   - Features
   - Documents
   - How-Tos
   - About
  Support
   - English
   - German
  Development
   - Changlog
   - Requests
   - Team
   - CVS
  Community
   - Website of the Month
   - Websites
   - Community Forum
   - Member

Navigation
FAQFAQ
SearchSearch
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesLog in to check your private messages
Log inLog in

Forum
Changing start time auctions
Sun Feb 07, 2010 4:33 am FR
Easy: what code to use to update sql table?
Fri Oct 16, 2009 8:39 am guyb
Unlimited products(downloads)
Wed Oct 14, 2009 7:09 pm hoimyr
Seller chooses currency
Sun Oct 11, 2009 8:00 pm hoimyr
Cant select end date without getting error
Sun Oct 11, 2009 6:43 pm hoimyr

About
Author: FR
Credits:
Brookfresh, Brad Lawryk, Crogon, DaMysterious, EklipzeDesigns, ML, musashi, phpBB Group, phpBB-Auction-Team, php-styles, sanman, Tel, Vampy, wGEric

Supported Sites





Statistics
User: 17479
Posts: 18401
Latest User: hilary8083

Bidfind megalist

 
Post new topic   Reply to topic    phpbb-auction.com Forum Index -> Development
View previous topic :: View next topic  

Add a 'megalist' option to phpbb auction?
Yes, this would increase traffic to our sites!
100%
 100%  [ 2 ]
No, I don't want any more traffic! I don't want to sell anything.
0%
 0%  [ 0 ]
Total Votes : 2

Author Message
treebeard
Large-Cap Auctioneer
Large-Cap Auctioneer


Joined: 14 Sep 2004
Posts: 140
Location: Central Command

PostPosted: Sat Oct 16, 2004 6:52 pm    Post subject: Bidfind megalist Reply with quote

Please add the compatability with bidfind.com megalist so that our auctions can be indexed in their search function.

As a bonus you can have this auction software listed in the 'vender' section on bidfinds site.

http://www.bidfind.com/af/af-prog.html

Here is what the megalist needs to do.

http://www.bidfind.com/af/af-mega.html

Thanks!!
________
colorado dispensaries


Last edited by treebeard on Fri Feb 04, 2011 6:50 am; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
FR
Site Admin
Site Admin


Joined: 26 Jan 2004
Posts: 1764
Location: root directory

PostPosted: Sun Oct 17, 2004 9:48 am    Post subject: Re: Bidfind megalist Reply with quote

treebeard wrote:
Please add the compatability with bidfind.com megalist so that our auctions can be indexed in their search function.

As a bonus you can have this auction software listed in the 'vender' section on bidfinds site.

http://www.bidfind.com/af/af-prog.html

Here is what the megalist needs to do.

http://www.bidfind.com/af/af-mega.html

Thanks!!


should be easy.
is that bidfind really as big as they call themselves ?
_________________
Want to say thank you. Use my Amazon Wishlist
Meet the world on movie-on.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
treebeard
Large-Cap Auctioneer
Large-Cap Auctioneer


Joined: 14 Sep 2004
Posts: 140
Location: Central Command

PostPosted: Sun Oct 17, 2004 5:50 pm    Post subject: Reply with quote

They have been around for a long time. Worst case senario you get some additional traffic to this site which will bring on some additional help in the programming and development areas and we as users of the phpbb-auction system will have a way to bring in additional traffic to our sites.....

Seems like a win win situation to me Very Happy

I figured the programming to make the 'megalist' would be simple, I just didn't know where to start on it myself. Embarassed

I look forward to seeing it implemented. Wink
________
Honda RC212V specifications


Last edited by treebeard on Fri Feb 04, 2011 6:51 am; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
FR
Site Admin
Site Admin


Joined: 26 Jan 2004
Posts: 1764
Location: root directory

PostPosted: Sun Oct 17, 2004 8:34 pm    Post subject: Reply with quote

Wanna try some code ?

Code:
<HTML>
<HEAD>
<TITLE>BidFind Export for phpbb-auction</TITLE>
</HEAD>
<BODY>
<VERSION>V.1.6<BR>


<?php
     define('IN_PHPBB', true);
     $phpbb_root_path = './';
     include_once($phpbb_root_path . 'auction/auction_common.php');

     // START Grab all the offer-data
     $sql = "SELECT t.*, u.username, u.user_id, u2.username as maxbidder_user_name, u2.user_id as maxbidder_user_id
                      FROM (" . AUCTION_OFFER_TABLE . " t
                      LEFT JOIN " . USERS_TABLE . " u ON u.user_id = t.FK_auction_offer_user_id
                      LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = t.FK_auction_offer_last_bid_user_id)
                      WHERE auction_offer_time_stop>" . time() . "
                           AND auction_offer_time_start<" . time() . "
                           AND auction_offer_paid = 1
                           AND auction_offer_state = " . AUCTION_OFFER_UNLOCKED . "
                      ORDER BY t.auction_offer_time_stop;";

     if ( !($result = $db->sql_query($sql)) )
     {
        message_die(GENERAL_ERROR, '1 Could not obtain topic information', '', __LINE__, __FILE__, $sql);
     }

     $total_offers = 0;
     while( $row = $db->sql_fetchrow($result) )
     {
         $auction_offer_rowset[] = $row;
         $total_offers++;
     }
     $db->sql_freeresult($result);
     $total_offers += $total_announcements;


// Dump out the page
if( $total_offers )
{
    for($i = 0; $i < $total_offers; $i++)
    {
        echo "<ITEM>auction";
        $auction_offer_id = $auction_offer_rowset[$i]['PK_auction_offer_id'];
        $auction_offer_title = ( count($orig_word) ) ? preg_replace($orig_word, $replacement_word, $auction_offer_rowset[$i]['auction_offer_title']) : $auction_offer_rowset[$i]['auction_offer_title'];
        $view_auction_offer_url = append_sid("auction_offer_view.$phpEx?" . POST_AUCTION_OFFER_URL . "=$auction_offer_id");
        echo "<ITEMURL>" . $view_auction_offer_url;
        echo "<ITEMTITLE>" . $auction_offer_title . "<br>";
    }
}
?>

</BODY>
</HTML>

_________________
Want to say thank you. Use my Amazon Wishlist
Meet the world on movie-on.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
treebeard
Large-Cap Auctioneer
Large-Cap Auctioneer


Joined: 14 Sep 2004
Posts: 140
Location: Central Command

PostPosted: Mon Oct 18, 2004 12:49 am    Post subject: Reply with quote

FR,

The code gives a display as follows:

Code:
V.1.6
auctionauction_offer_view.php?ao=73Motorola V60 Cell phone -used-
auctionauction_offer_view.php?ao=81Jack Daniels 'old number 7' Shot glass NOS!
auctionauction_offer_view.php?ao=59John Kerry gourd head 'Wow his head is so huge!'
auctionauction_offer_view.php?ao=68Garmin GPS iQue 3600 bundle $417.84 after rebate!


I added my site address as follows:

Code:
echo "<ITEM>auction";
        $auction_offer_id = $auction_offer_rowset[$i]['PK_auction_offer_id'];
        $auction_offer_title = ( count($orig_word) ) ? preg_replace($orig_word, $replacement_word, $auction_offer_rowset[$i]['auction_offer_title']) : $auction_offer_rowset[$i]['auction_offer_title'];
        $view_auction_offer_url = append_sid("auction_offer_view.$phpEx?" . POST_AUCTION_OFFER_URL . "=$auction_offer_id");
        echo "<ITEMURL>www.smartsauctions.com/" . $view_auction_offer_url;
        echo "<ITEMTITLE>" . $auction_offer_title . "<br>";


So now the output is:

Code:
auctionwww.smartsauctions.com/auction_offer_view.php?ao=73Motorola V60 Cell phone -used-
auctionwww.smartsauctions.com/auction_offer_view.php?ao=81Jack Daniels 'old number 7' Shot glass NOS!
auctionwww.smartsauctions.com/auction_offer_view.php?ao=59John Kerry gourd head 'Wow his head is so huge!'
auctionwww.smartsauctions.com/auction_offer_view.php?ao=68Garmin GPS iQue 3600 bundle $417.84 after rebate!


The code seems to work perfectly! Thanks!! Very Happy

P.S. Ignore the way the link is created in the above code snip. It does not do that on the live page which you can view here:

http://www.smartsauctions.com/megalist.php

I also added to the <head> the copyright disclosures required by bidfind so that they can access the information on the page for inclusion in their search system...
________
ecig forum
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    phpbb-auction.com Forum Index -> Development All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


phpbb-auction.com - Developed by www.digital-media-lab.com
Sponsored by: www.globibo.com - www.learn2go.de - www.talentone.org - www.language-school.in - www.ping-ke.cn