phpLinkBid v1 Bug Fix

Hey,

A few people have reported receiving the following error message by email after a bid has been placed:

SELECT FAILED ON: SELECT link_id, link_url, link_title FROM tbl_links WHERE link_url = ""

See this thread: http://www.phplinkbid.com/forums/viewtopic.php?f=7&t=16

I had the same problem and figured out what it was so thought I would post the fix here... I have also emailed phpLinkBid to inform them.

If you open the file bid.tpl and edit the following line:

<input type="hidden" name="item_name" value="Bid for {link_url} on {site_name}">

Code (markup):

Then the problem will occur, basically the IPN script uses the {link_url} from this hidden field to update the bid. So you can either leave that line as it is and everything will work fine, or do the following:

Add this line of code below the above line:

<input type="hidden" name="custom" value="{link_url}">

Code (markup):

Then open the ipn.php file and edit line 101 from:

$sql = 'SELECT link_id, link_url, link_title FROM ' . TBL_LINKS . ' WHERE link_url = "' . $ret_url . '"';

Code (markup):

To:

$sql = 'SELECT link_id, link_url, link_title FROM ' . TBL_LINKS . ' WHERE link_url = "'.trim($_POST['custom']).'"';

Code (markup):

HTH

 

Hey silky you know if that dude has released a newer version yet or not ?

And thanks for the fix.

 

I bought my copy yesterday and it was still v1 so I guess not.

 

Darn. Well how much you paid ? Is the price same or increased?

 

I picked up mine for 24.95, they have a discount at the moment down from $39.95

 

Right i remember picking it for 21$ only, i think current customers get to pay only 19$ for extra . Plus the dude was nice to let me remove the footer link at no cost thus giving my page more strength i guess.

 

Thanks for your help SilkySmooth, I hope phplinkbid updates their files and releases a fix so that it can be downloaded.

 

you should post it in the official forum at http://www.phplinkbid.com/forums/

 

ok silky what you break now

heheh nice fix good lookin out...