Jump to content

psylencer

Members
  • Content count

    106
  • Joined

  • Last visited

Posts posted by psylencer


  1. Dan my problem now ( i think it is the last one :P) is that whenever a bid ends the product is added in the cart but the selling price is not the one which the bid ends but is the default price of the product .

     

     

    Let me look into this, I've obviously missed something somewhere, It certainly works for me, my problem is I don't know how I got it to work. I spent HOURS on this. Fingers crossed I'll figure it out.

     

    Stay tuned


  2. K, The first problem you've got relates to the auto-refresh feature. Basically this needs to happen in the header of the file. There is a test to see if the page is an auction page or not. If so, the page should reload every 120 secs. This updates the PHP countdown. (Similar to ebay). Could you please post your product_info.php file for me to look at.

     

    secondly it sounds as if your setup.php file is either missing or in the wrong directory. Try copying it to the includes/modules directory and the /catalog directory and tell me what happens.

     

    My bad, it looks as if I've put it in the wrong folder. Sorry <:)

    Dan

     

    One more thing, read below :

     

    Sometimes programmers want to change some of the header values. For example, if the PHP if generating XML output, the Content-Type should be changed to reflect this. Another common example is in redirecting the user's browser to a different web page using the Location header element as described in this Tech-Recipe.

     

    The header must come first in the response from a web server and is separated from the body by one blank line. The reason this error occurs is that some part of the body of the web page has been sent to the user already when a request is made to set a header value. Because PHP simplifies many things for you, the problem may be hiding in plain site. Here are some guidelines for finding the problem:

     

    1) Find the header() statement that is causing the problem. The error must be at or before this line.

     

    2) Look for any statements that could send output to the user before this header statement. If you find one or more, find some way to move the header statement before them. Complex conditional statements may complicate the issue, but they may also help solve the problem. Consider a conditional expression at the top of the PHP script that determines the header value as early as possible and sets it there.

     

    3) Make sure there is no white space outside of the php start and end tags. While a blank line before the <?php start tag may look innocent, when processed by PHP, it will turn into an echo statement printing out a blank line. This is a common culprit.

     

    Dan - I didn't write that, got it off tech recipies


  3. I have a little problem here psy:

     

    I'm testing your contrib on my test amp by an item I previously added to my catalog, and this shows on the header products info page:

     

    "44

    Warning: Cannot modify header information - headers already sent by (output started at c:\shop\product_info.php:91) in c:\shop\product_info.php on line 109"

     

    and this on the Time Remaining box:

     

    "Warning: countdown(setup.php): failed to open stream: No such file or directory in c:\shop\includes\modules\auction_bids.php on line 112

     

    Fatal error: countdown(): Failed opening required 'setup.php' (include_path='.;C:\\php\pear\') in c:\shop\includes\modules\auction_bids.php on line 112"

     

    I'm using the newest auction_bids.php you posted recently, and this is my product_info.php:

     

    K, The first problem you've got relates to the auto-refresh feature. Basically this needs to happen in the header of the file. There is a test to see if the page is an auction page or not. If so, the page should reload every 120 secs. This updates the PHP countdown. (Similar to ebay). Could you please post your product_info.php file for me to look at.

     

    secondly it sounds as if your setup.php file is either missing or in the wrong directory. Try copying it to the includes/modules directory and the /catalog directory and tell me what happens.

     

    My bad, it looks as if I've put it in the wrong folder. Sorry <:)

     

     

    Dan


  4. The above code exists in my file. I run the whole project locally and I am not using any online Server. I am using wamp apache server and my PHP version is 5.2.5. I just can't find what the error is

     

    Can you please show me the error log which relates to loading of the page?


  5. yes i do have that button now what should i do

    but its the copy to button

     

    "Copy to" is fine, just follow the instructions above. - Create a new category called auctions, then disable it and copy any products you want to auction to that directory. Then go to categories - Auction Products and select the product you have copied to that directory and set up the auctions. _Note you may need to modify the name of the auction product so that you can tell it apart from the copied product.

     

    Dan


  6. how to copy the product when there all in one php code

     

     

    K its been a while since I had a virgin store, but go into you admin frontend and click on the catalog link on the left, now when you click on a product, do you have a copy option? If not, perhaps I've forgotten about a contribution I've added.

     

    Basically, "Copy" is a button which should appear next to the "edit" button in your admin console.

     

    Dan


  7. how should i add a product

     

    This from the install.txt file

     

     

    VERY IMPORTANT : HERE'S HOW THIS WORKS

     

    -------------IN THE ADMIN CONSOLE---------------

     

    • Create a new folder in your admin console for Auction Products.

    • Copy (not link) all products you wish to auction to that folder

    • In you admin console click configuration->auction listing and set "end of auction - options" to 0 <---this only needs to be done once.

    • Open the Auction admin section via Catalog ->Auction products

    • Select and set up the product of which you've just copied to the "Auction products" folder (or whatever you called it)

    • When the auction is finished, or someone places a higher bid than the last person an email will automatically be sent to the

    winner/lower bidder(s) <--this may be a bug.

    • You will need to make another copy of the product(s) EVERY time you wish to re-list the product(s).


  8. Yep I have tried and won an auction but nothing was added to the shopping cart of the winner:( . Can you tell in which file to look so that I can modify it

     

    OK, I'll give you a quick run down on how this contrib works.

     

    Auction bids are added to the auctions_bids table by the auctions_bids.php file when valid data is posted from this file, to start off with, an auction has the status of "1" or active. You can see this in the auctions table under the column "status"<--check to see if this column exists

     

    When an auction is won, one of many things will happen I'll outline them in detail below

    a) A user (winning or otherwise) will load the product_info.php file (which contains the auctions_bids.php) which will trigger the product to be added ONLY to the database table customers_basket.php (with the WINNING BIDDERS DETAILS) The highest bid for the product is added to a column under this table called "final_price" <--check to see if this column exists and the "Status" column under "auctions" table will revert to "0" - this will disable anyone else adding any further information to the "customers_basket" table.

    B ) The winner will go straight to their shopping cart - A test is performed on the status column to see if the user has A) won an auction - AND B)already had the product added to their shopping cart (auctions table - status column (see above) Obviously actions occur here depending on the outcome. Ie if no other user has triggered the information to be sent to the customer_basket" table, then this is done at this stage. SECONDLY, regardless of wether the information in the customers_basket table is UPDATED by THE WINNING BIDDER (who is looking at their own shopping cart) or by ANOTHER who was viewing a completed auction (see scenerio A) SESSIONS ARE NOW UPDATED - following this, the shopping cart loads as normal. and Whamo - you should see the product listed in the shopping cart. <--You should also see a note where the "remove tag" usually is stating "This is an auction product, it can not be removed", you should aso notice that you can not modify the ammount of units of the auction product you want to order.

    c) NO ONE checks their shopping cart or views a completed auction - in this case - the auctions still needs to end, however with no one viewing the page, what will trigger the auction to end? The aucron2.php file, which executed every 5 mins to update the customers_basket table.

     

    The class below is VERY important for all of this to work, likewise is the code which is to be inserted into the catalog/shopping_cart.php and auctions_bids.php <--although you should not need to modify this file.

     

     

    ******PLEASE NOTE: THE FOLLOWING IS CODE FROM MY OWN SITE - HENCE THE "CRAZYSTU" reference in the code.

     

    Classes/shopping_cart.php

     

    the following function should be in there.

     

    //DANS Auction Contrib - New function to add auction products to cart

    function add_cart_auction($products_id, $qty = '1', $attributes = '', $notify = true) {

    global $new_products_id_in_cart, $customer_id;

     

    $products_id = tep_get_uprid($products_id, $attributes);

    if ($notify == true) {

    $new_products_id_in_cart = $products_id;

    tep_session_register('new_products_id_in_cart');

    }

     

    if ($this->in_cart($products_id)) {

    $this->update_quantity($products_id, $qty, $attributes);

    } else {

    $this->contents[] = array($products_id);

    $this->contents[$products_id] = array('qty' => $qty);

    // insert into database

     

    if (is_array($attributes)) {

    reset($attributes);

    while (list($option, $value) = each($attributes)) {

    $this->contents[$products_id]['attributes'][$option] = $value;

    // insert into database

     

    }

    }

    }

    $this->cleanup();

     

    // assign a temporary unique ID to the order contents to prevent hack attempts during the checkout procedure

    $this->cartID = $this->generate_cart_id();

    }

    //EOF Dans AUCTION Contrib

     

    Also you'll need to check out /catalog/shopping_cart.php - this is one of the pages where the product is added to the database AND sessions. You'll also find similar code in the auctions_bids.php file, however in auctions_bids.php, only the database table customers_basket is modified - NOT the sessions.

     

    //BOF DANS AUCTION Contrib - SQL If (effectively) to test if customer has been notified via email, if not send email, update database and shopping cart. Please note, the "notifed" column in the table "auctions" Notified is actually sessions updated but I havent changed the wording because I can't be stuffed.

    global $ddd;

    $query="select MAX(ab.bid_price) as bid_price , ab.customers_id,ap.auctions_id, ap.products_id, pp.products_name, pr.products_model, cc.customers_firstname, cc.customers_lastname, cc.customers_email_address, ap.notified, ap.status from ".TABLE_AUCTIONS_BIDS." ab,".TABLE_AUCTIONS_PRODUCTS." ap, ".TABLE_CUSTOMERS." cc, ".TABLE_PRODUCTS_DESCRIPTION." pp, ".TABLE_PRODUCTS." pr where ab.auctions_id=ap.auctions_id and ab.customers_id = cc.customers_id and ap.products_id = pp.products_id and ap.notified = 1 and ap.expires_date <'". date("Y-m-d").' '.date("G:i:s")."' GROUP BY auctions_id";

    $result=mysql_query($query);

     

    //echo $query;

    $num=mysql_numrows($result);

    global $cart;

    global $custida;

    $i=0;

    while ($i < $num) {

    global $custida;

     

    //Get result Number to work with

    $Auction_id=mysql_result($result,$i,"auctions_id");

    $asfirstname=mysql_result($result,$i,"customers_firstname");

    $aslastname=mysql_result($result,$i,"customers_lastname");

    $asemail=mysql_result($result,$i,"customers_email_address");

    $asbidprice=mysql_result($result,$i,"bid_price");

    $asprodname=mysql_result($result,$i,"products_name");

    $asprodmod=mysql_result($result,$i,"products_model");

    $asprodid=mysql_result($result,$i,"products_id");

    $custida=mysql_result($result,$i,"customers_id");

    $anotified=mysql_result($result,$i,"notified");

    $astatus=mysql_result($result,$i,"status");

     

     

    //echo date("Y-m-d").' '.date("G:i:s").'<br>';

    //echo $custida . '<br>';

    //echo $asprodid . '<br>';

    //echo $asbidprice . '<br>';

    // send email

     

    //test to see if current customer is the winner of an auction which has not been processed.

     

    if ($custida == $customer_id){

    global $customer_id;

     

    if ($astatus == 1) {

    tep_mail($asfirstname.' '.$aslastname, $asemail, 'CrazyStu Auction Won :'.$asprodmod, 'Dear '.$asfirstname.' '.$aslastname.',<br><br><br>Congratulations. You are the winning bidder for a '.$asprodname.'!<br>

    This product has been added to your shopping cart at CrazyStu.com.au. <br>

    Please log-in to your account at <a href="https://crazystu.com.au/login.php">https://crazystu.com.au/login.php</a> and proceed directly to the checkout. Once there, you will be given payment and shipping options. Simply select the shipping method and destination you wish to use, then enter your payment details (Paypal, Direct Deposit or Credit Card). A receipt will be issued to you upon order completion.<br>

    Once payment is confirmed, your order will be dispatched straight away.<br>

    <strong>Please see below for final auction details:</strong><br>

    Your Auction ID is :'.$Auction_id.' (To be used as reference for direct deposit)<br>

    You have bid on '.$asprodmod.', '.$asprodname.'<br>

    <br>Your winning bid was :$'.$asbidprice.' +Shipping (Please proceed to our checkout for options and pricing)<br>

     

    Please contact us at <a href="mailto:admin@crazystu.com.au">admin@crazystu.com.au</a> if you have any further queries.<br>

    Thank you for your order.<br>

    <br>Regards,<br>

    <br>Dirk Renkema.<br>

    CrazyStu.com.au Administration.<br>

    <p>**Security notice : Crazystu.com.au will never ask you to reveal your login password. Protect yourself online and keep all login and personal details private and confidential.<br>

    A copy of our privacy notice is available online at <a href="http://crazystu.com.au/privacy.php">http://crazystu.com.au/privacy.php.</a><br />

    <br>

    <br>', 'CrazyStu.com.au', 'admin@CrazyStu.com.au');

    }

    //update database to processed status

    $query2 = "update ".TABLE_AUCTIONS_PRODUCTS." SET status = 0 where auctions_id = ".$Auction_id;

    $result2=mysql_query($query2);

    $query3 = "update ".TABLE_AUCTIONS_BIDS." SET bid_status = 'won' where bid_price = ".$asbidprice;

    $result3=mysql_query($query3);

    $query4 = "INSERT INTO ".TABLE_CUSTOMERS_BASKET." (auction_product, customers_id, products_id, customers_basket_quantity,final_price, customers_basket_date_added) VALUES ('1',".$custida.", ".$asprodid.",'1', ".$asbidprice.", ".date("Y-m-d").")";

    $result4=mysql_query($query4);

    $query5 = "update ".TABLE_AUCTIONS_PRODUCTS." SET notified = '0' where auctions_id = ".$Auction_id;

    $result5=mysql_query($query5);

    $cart-> add_cart_auction($asprodid, $qty = '1', $attributes = '', $notify = true);

    $cart->restore_contents();

    }

    $i++;

     

    }

    //EOF DANS AUCTION

     

     

    Hope this helps. Let me know if you've got any questions.

     

    Dan


  9. I fixed the problem. Because my php is probably configured differently from yours I typed above the query the following code "$products_id = $_REQUEST['products_id'];" and I have no error now.

     

    My problems now is how can I add the winning product to the shopping cart and also in the administrator console , the administrator cannot see who won the bid

     

     

    The product is automatically added to the winners shopping cart. (Have you tried winning an auction, then checking?) If this isn't working - it should -let me know. The admin will not see this until the product is paid for.

     

    The french guys are working on an admin side to this contrib, however Im yet to have a go installing it or to see if it's compatible with this contrib. If not, Im sure it won't be too difficult to whip something up.

     

    I'll be posting another update tonight as Ive finally got the Higher bidder notification working perfectly. Only the second highest bidder is notifed of a higher bid, the email sent also contains all details of the auction along with (hopefully) a URL to the auction of which I am working on right now.

     

    Dan


  10. Not sure right now, Ill look into it. FYI, Just managed to have some success on the emails thing. I'll post changes tomorrow.

     

    Dan

     

    Try this,

     

    $query="select * from '.TABLE_PRODUCTS.'";

    $result=mysql_query($query);

    $num=mysql_numrows($result);

     

    echo $num;

     

    Tell me if this works. - you should get a result greater than 0 (if you have any products that is).

     

    Also, check this thread, it might help, if not, I'll continue to look around.

     

    http://www.daniweb.com/forums/thread26425.html


  11. I run the project locally using wamp my PHP version is 5.2.5 and Mysql Version is 5.0.51a.

     

    So any idea how can I fix this so that the item will be added to the Customers shopping cart and I will not get the error I mentioned above??

     

    P.s I checked the database_tables.php and I have in my code " define('TABLE_AUCTIONS_PRODUCTS', 'auctions'); " so I do not know what the error is

    Not sure right now, Ill look into it. FYI, Just managed to have some success on the emails thing. I'll post changes tomorrow.

     

    Dan


  12. Is it some way to place auctions with start time and stop time.

     

    I want to plan comming auctions for exampel next week and want an auction to start 9 am and stop 12 pm.

     

    .... and thanx for the setup.php fix.

     

     

    :rolleyes: There sure is, and as soon as I've got this working, it'll be right up there on my list. How bout we get this working first, and then think about improvements.

     

    Also; There are a heap of bugs from the old code of which i'm still yet to resolve. The email code does not work correctly as of yet, this is what I'm working on right now. - So that only the second last bidder is notified of a higher bid, instead of ALL bidders.

     

    Dan


  13. Ok some bugs I fixed in this contribution

     

    1)In Producti Info I changed the query "$sql_auction = 'insert into '.TABLE_AUCTIONS_BIDS." (auctions_bids_id, auctions_id, customers_id, bid_price, bid_status, bid_date_added ) values('', '$auction_id', '$customers_id', '$bid_price', '', now()) ";"

     

    into this "$sql_auction = 'insert into '.TABLE_AUCTIONS_BIDS." (auctions_bids_id, auctions_id, customers_id, bid_price, bid_status, bid_date_added ) values(NULL, '$auction_id', '$customers_id', '$bid_price', '', now()) ";"

     

    I used a NULL value because auctions_bids_id is autoincremented.

     

    2)There was a problem when one customer was bidding more than once

     

    I changed the query " $sql_auction = 'update '.TABLE_AUCTIONS_BIDS." set auctions_id='$auction_id',bid_price= '$bid_price', bid_date_added= 'now()' where auctions_id='$auction_id' and customers_id='$customers_id'"; "

     

    into this "$sql_auction = 'update '.TABLE_AUCTIONS_BIDS." set auctions_id='$auction_id',bid_price= '$bid_price', bid_date_added= now() where auctions_id='$auction_id' and customers_id='$customers_id'"; "

     

    3) My problem is when an auction ends I am getting the following error "Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\Nano\catalog\includes\modules\auction_bids.php on line 412"

     

    I think is because at the sql query select MAX(ab.bid_price) as bid_price , ab.customers_id,ap.auctions_id, ap.products_id, pp.products_name, pr.products_model, cc.customers_firstname, cc.customers_lastname, cc.customers_email_address from ".TABLE_AUCTIONS_BIDS." ab,".TABLE_AUCTIONS_PRODUCTS." ap, ".TABLE_CUSTOMERS." cc, ".TABLE_PRODUCTS_DESCRIPTION." pp, ".TABLE_PRODUCTS." pr where ab.auctions_id=ap.auctions_id and ab.customers_id = cc.customers_id and ap.products_id = pp.products_id and ap.products_id = ".$products_id." and ap.status = 1 and pr.products_id = ".$products_id." and ap.expires_date <'". date("Y-m-d").' '.date("G:i:s")."' GROUP BY auctions_id";

     

    There is not a table TABLE_AUCTIONS_PRODUCTS. in our database. Any help how to fix this pls??

     

    Thank you very much for your time

    Firstly, thankyou so much for you help on this contrib. I'll try to keep things breif.

     

    1 & 2)<--Excellent work on this, I'll make the changes next contrib (Auction 2.0.4)

     

    3) Sounds like your version of MYSQL or PHP doesn't support numrows(). Mine does, my server versions are below, You are right in a way, there is no table called "TABE_AUCTIONS_PRODUCTS" Notice the "." before and after the reference though, the code reverts back from SQL to PHP, meaning this table is, or should be defined in your "databse_tables.php" file.

     

    In short, TABLE_AUCTIONS_PRODUCTS = auctions

     

    Ie. you should have a table called "Auctions" in your database, and this should appear in your database_tables.php file.

     define('TABLE_AUCTIONS_PRODUCTS', 'auctions');

     

    Here is my server versions

     

    :

     

    Server Host: (10.1.1.4) Database Host: yourserverhere.com (127.0.0.1)

    Server OS: Database: MySQL 5.0.41-community-nt

    Server Date: 04/03/2008 22:18:33 Datebase Date: 04/03/2008 23:18:33

    Server Up Time:

    HTTP Server: Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e mod_autoindex_color PHP/5.2.2

    PHP Version: 5.2.2 (Zend: 2.2.0)

    osCommerce 2.2-MS2

    PHP Logo

    PHP Version 5.2.2

     

     

    Thankyou SO much for the help.

     

    Dan


  14. i have installed the files in cluded and nothing chaneges in my admin please help anyone

    and tell me wat i can do to make it better

     

    rashawn13

    Please check the latest update, there was some missing files. Auctions 2.0.3 is current. there may still be some missing files/mods which I've left out, let me know if there's anything you pick up that's missing. If you want to test this contrib, check http://crazystu.com.au/512mb-sodimm-pc5300...ranty-p-97.html for a demo, note, I will not make you pay for any bids, just register and bid.

     

    Dan


  15. i m 100 % understanding, and certains taht it s a major rework of it,

    if you look in the contirbution and search for my name you ll see that it make 5 years i work on osc

    and from my experience, contribution taht have been spilt in several page ,get only people to be confused and

    them and you will be getting on nerves with people askeing you support for the old version and vice versa on the old topic.

     

    im sure all people who subscribe to the old topic and know the page of the old contrib would like me love to give feedback and help

    for this new revision 2 version, and everybody is aware that 2beta means beta , not full workin, 100 % tested.

     

    it s a pity, but we dont see how many persons are subscribed a topic, so when somebody post a message sometimes hundred persons recevie an email telling them there is an update.

    it not like when you make a new contribution page.

     

    so im not winning , just trying to get most of people interested to be aware of your new work and also try to get as much people involved on helping.

     

    also as i tol in private message , the french members workd in version 1.5 beta also , and i think we should and could join effort to release a version 2.10 with both our efforts :lol:

    http://www.oscommerce-fr.info/forum/index....amp;hl=encheres

     

    I'd be happy to help, but my understanding of french is limited to that of which babelfish can translate. If I'd known you guys were developing this, I'd have spoken to you first. None the less, it sounds like you guys have been working on an admin side to this which was to be the next thing I look at. Any chance I could get your code to see how the two contribs work together?

     

    Dan


  16. hell

    i don't understand why make a new contribution page, it s only making people confused and thinking it s two different contributions

    as long as you write beta , people would understand that it s not final , and would make their choice.

    since your work is coming from the version 1.4.4 then just post it after and proposal of new features on the topic opend forr the auctions contribution

     

    i hope you ll find my thinking usefull , tell me if you agree

     

    Azer, the old contrib page contains loads and loads of old or obsolete information, secondly, this is a major update to the contrib which was forgotten about long ago due to lack of support and those to finish the contribution off.

     

    I should point out and make very clear that even in V1's most recent version 1.4.4, while the core functionality was there, most of the important features which are required to make the thing work were not. As such, I don't believe I would be alone in assuming that most people who tried V1. went through all the effort to find out it was useless - eventually being abandoned by those who started the contrib.

     

    These changes relect most of the updates requested in the other forum to make the contrib truely functional. I've put the easy bugs on the backburner in favour of the more important bugs or features. Which is why the simple bugs are still present -further; anyone with limited Php knowledge should be able to figure them out, andif they don't I'll be doing so myself as soon as time allows.

     

    In short, I get lost in 11 pages of shit which has been negated 10 times only for myself to come along and do the same thing. My priority now is to make sure the countless hours of me pulling out my hair doesn't go to waste. I would like to see this contrib polished, which means getting as many of you guys to try the contrib and post feedback. - Hence the new forum topic - you're right though- it probably could have been posted under the existing contribs though.

     

    Dan


  17. This is a beta release. I have not tested this on a vanilla install. Any help or feedback from those installing on a vanilla OSC would be greatly appreciated.

     

    The purpose of this contribution is to allow one to run their own auctions.

     

    Current features include :

    Ability to run many auctions of one product at a time,

    "Won Auctions automatically added to shopping cart with "remove" and Qty changing disabled.

    Email automatically sent to winning bidder,

     

    etc etc. Please see the original "Auctions" contribution txts. for a full list of features.

     

    Auction 2.0 Beta

    ===============

    New features/Bug Fixes

    _____________

    - PHP Countdown with auto-refresh

    - "Won" auctions automatically added to shopping cart

    - Countdown to any time and date you wish (instead of 12:00)

    - Auction price now displays highest bid instead of starting price

    - You can no longer bid lower than starting price

    - You can no longer bid less than current bid +overbid ammount

    ____________________________________

    Known bugs

     

    -Possible multiple "higher bid" notification emails sent to everyone with lower bids when higher bid entered

    -"higher bid" notification emails are converted into SMTP Logs on some email servers <--This does not affect winning bid emails

    -Poor use of language definitions

    -Old obsolete code to be deleted

    -Terms and conditions link does not work

     

    This contribution in tested on a heavily modded OSC. I have documented this install for a New installation only (not upgrade), however changes made from Version 1.4.4 have been commented with "Dans Auction Contribution". Saying that 100% credit must go to the original Author Celdish and MarcusDesign. This is simply a few minor fixes and patches to make the contribution functional.

     

    Forgive me if I've left some files or Mods out. It is very difficult for me to keep track of all the changes made. No doubt, with some valuable help from the community, we'll be able to get a solid working version of this truly excellent contrib. -Saying that, this is working great on my own site. I hope it works for you guys too.

     

    Here's the link :

     

    http://addons.oscommerce.com/info/5843

     

    Dan


  18. This is a beta release. I have not tested this on a vanilla install. Any help or feedback from those installing on a vanilla OSC would be greatly appreciated.

     

    The purpose of this contribution is to allow one to run their own auctions.

     

    Current features include :

    Ability to run many auctions of one product at a time,

    "Won Auctions automatically added to shopping cart with "remove" and Qty changing disabled.

    Email automatically sent to winning bidder,

     

    etc etc. Please see the original "Auctions" contribution txts. for a full list of features.

     

    Auction 2.0 Beta

    ===============

    New features/Bug Fixes

    _____________

    - PHP Countdown with auto-refresh

    - "Won" auctions automatically added to shopping cart

    - Countdown to any time and date you wish (instead of 12:00)

    - Auction price now displays highest bid instead of starting price

    - You can no longer bid lower than starting price

    - You can no longer bid less than current bid +overbid ammount

    ____________________________________

    Known bugs

     

    -Possible multiple "higher bid" notification emails sent to everyone with lower bids when higher bid entered

    -"higher bid" notification emails are converted into SMTP Logs on some email servers <--This does not affect winning bid emails

    -Poor use of language definitions

    -Old obsolete code to be deleted

    -Terms and conditions link does not work

     

    This contribution in tested on a heavily modded OSC. I have documented this install for a New installation only (not upgrade), however changes made from Version 1.4.4 have been commented with "Dans Auction Contribution". Saying that 100% credit must go to the original Author Celdish and MarcusDesign. This is simply a few minor fixes and patches to make the contribution functional.

     

    Forgive me if I've left some files or Mods out. It is very difficult for me to keep track of all the changes made. No doubt, with some valuable help from the community, we'll be able to get a solid working version of this truly excellent contrib. -Saying that, this is working great on my own site. I hope it works for you guys too.

     

    I'll post the link in the following message....


  19. Ok homies,

     

    Trash the last idea, this is what i've got happening, if everyone's happy with it, Ill install it, document it and post it. ...

    Sessions are now automatically updated every time any winning bidder looks at their shopping cart, or - another client looks at an auction which is finished, or the cron file (executed every X mins) updates the shopping cart - which ever comes first. Only the winner can update their sessions containing won products. This is done in the shopping cart itself.

     

    At the admin side - An auctions "folder" must be created in which auction products are to be copied from the main products/categories list. Basically, if you want to list an auction, copy it to the auctions folder , then go to the auction products link in your admin -categories list and enter details of the product for auction, auction exp. date/time , starting price, overbid price etc. When the auction expires, the product does NOT become available again. In order to relist the item, admin must copy the product they wish to auction to the auctions "folder" and then select the product for auction from the admin-categories auction products section of your admin console.

     

    This seems to work for statistics gathering because a trail of all auctions will always exisit in the database. Someone else will have to impliment stats for this though.

     

    All I need now is a few people with "vanilla" installs to help me document the changes as my own site is heavily modded.

     

    For the moment, the catalog/auctions.php file has been dis-used as this is not necessary.

     

    Dan


  20. OK, I've set things now so that when the winner views a finished auction of which he/she has won, the auction status is updated, an email is sent to the winner, their sessions are updated (shopping cart) and subsequent views of the page from other users will result in a normal product page (with buy now). If the winner does NOT view the product page, the CRON job will still update the database every X mins, however the winner will not have the product added to their cart (sessions) untill they log off and log back on again.

     

    Basically, this will only affect users who are logged on and don't know/care if they've won an auction. Sounds a little crap to me, personally, I'd like the product added to the winners cart wether they've looked to see if they've won or not, however something has to trigger this event, and with my limited knowledge of the OSC system, I don't know how to have a users' sessions updated if THEY are not the ones updating them. Does anyone understand what im talking about?

     

    Suggestions would be really helpful. I'm thinking a script which would update ALL users sessions from data within the database would help, triggerd in the cron file- sort of a "refresh all sessions" script, however I've got ABSOLUTLY no idea how to do this. Help? Ideas?

     

    Secondly, A bug I've just noticed is that IF the admin re-lists an auction before it is added to the winners cart (through the database), the winner will never get the product they've won because when a product is re-listed, the status must change to "current" or boolean "1" in the databse. This means the CRON file or user viewing the page (and hence executing the script/databse updates themselves) will not know the auction is finished - assuming that its' status is "current" and continuing the already won auction untill the end of the newly re-listed auction. - A possible fix here is to have the admin section automatically create/copy the product and create a unique product_id for each auction. This would have the added bonus of enabling the admin to list multiples of the same product at once and will be greatly beneficial im sure for record keeping and statistics (something i don't want to think about too much right now, but am sure will come in handy when creating product auction history prices etc.), however will extend the time it takes me to release this contrib for at least another week at best. As a consequence, I'll have to remove the current "feature" of having products with finished auction status automatically revert to "Buy now" status once an auction is finished. Any thoughts?

     

    Dan

×