Jump to content

psylencer

Members
  • Content count

    106
  • Joined

  • Last visited

Posts posted by psylencer


  1. Hi All,

     

    Just wanted to offer a sneak peak to those interested of the new Auctions V3 Contribution. I've spent the last 6 months almost completely re-coding this contribution. There were a million problems with the last v2.1 contrib - all are fixed. I've been testing this live over the past few weeks and have fixed all reported problems.

     

    New features include:

     

    Proxy Bids!!!!

    Customer Feedback Console

    Live feedback displayed on auction page including thumbs up, down etc.

    User bidding History,

    Finished Auction History

     

    Revamped "My account" page with users bidding info;

    Bid Que

    Up-Bid Table (Automatic Up-Bid increase)

    Automatic Out-bid notification

    Revamped Bid List

    + Many More.

     

    check it out @ crazystu.com.au

     

    New release will not be available for some time as I've got to separate the program logic from my page design. Any help with this would be appreciated. Private msg me if interested.

     

    Dan


  2. Dear all:

     

    My server information is below:

    Database: MySQL 4.1.22-standard-log

    HTTP Server: Apache 3 - nowhere

    PHP Version: 5.2.4 (Zend: 2.2.0)

     

    I can't run Batch Print Center.

     

    Program Message:Invalid date, Please enter a valid date in Year-Month-Day (0000-00-00) format.

    Would you please help to advise asap?

     

    Best Regards,

     

    This contrib requires register globals to be "on". Change it and the problem should be fixed. The problem is that with register globals off, the variables are not passed through to the following window correctly, hence the message.

     

    Regards

    Dan


  3. UPDATE: After some tinkering, I just deleted all the standard HTML coding above the initial PHP (and the body and html close tags at the bottom), and it all works fine.

     

    Other issues I was having - the body of the automatic email sent is actually in TWO places (aucron2.php and shopping_cart.php). This could be streamlined in the next update to this package.

     

    The final_price variable isn't carried properly to the shopping cart. The shopping cart seems to ignore the final_price variable. I'm trying to figure out a proper work-around.

     

    Matt, heres the solution : in shopping_cart.php you need to do a cart reset. Check the code. If not message me and Ill help you out.

     

    mine certainly updates without a problem.


  4. HI Guys,

     

    Im going to begin to re-develop Auction for OSC V3, .

     

    Please list new feature requests here.

     

    So far on my list is some sort of customer review module Ala Ebay. One problem I've found with this is that customers just don't trust you. I think if we can introduce a seller feedback option, thjis may solve the problem.

     

    Dan


  5. I could not get the paypal fee to from the "Paypal Fee" module to pass through to Paypal, and I COULD get the paypal IPN with fee module to pass the fee, however this would not display the fee in order totals, so I combined the two with great results.

     

    Simply combine the Paypal_IPN Module with Fee (osCommerce-PayPal_IPN_with_fee) and The "Paypal Fee" modules

    Install them both, then set the "Fee" under "Payment modules -> Paypal IPN with fee" to 1.0 and the "Fee" under Order_total modules to what ever you like (2.5%) or whatever.

     

    Make sure you set the sort order for the Order total paypal fee module to a value just before the "Total" module Ie if Total is set to 5, then set Paypal Fee to 4.

     

    Now the fee is displayed correctly in your checkout confirmation page AND it's passed through to paypal.

     

    Cheers to those who made the contribs, while none worked well for me, they both work together nicely.

     

    Dan


  6. This problem, apparently occurs because I have not done a mysql_numrows before the offending lines. Basically, the error occurs when there are no results to display. If I could get a dump of the SQL tables related to this, I may be able to diagnose and repair.

     

    Cheers everyone for the effort, I'll try and keep a closer eye out for any more questions.

     

    I also have the same problems. I commented out the lines that has the errors just for a cosmetic fix (so the problem's still exist)...

     

    Hopefully someone with a understanding of the auction plugin will be able to give us some help.


  7. There is a problem using Order Editor and the Individual Shipping contributions. I posted this thread seeking help:

     

    http://forums.oscommerce.com/index.php?sho...0&p=1201199

     

    I never found a solution. It appears to be rather complicated and beyond my php expertise. If anyone finds a solution, please share it with me.

     

     

    This will fix the problem!

     

     

    In Indvship1.php

     

    Find :

    $shiptotal1 = $cart->get_shiptotal1();

     

    Replace :

    $currpage =$_SERVER["PHP_SELF"];

    if ($currpage <> "/admin/edit_orders.php"){

    $shiptotal1 = $cart->get_shiptotal1();

    }

     

    More of a patch rather than fix, none the less works.

     

    Happy days.

    Dan


  8. Just a note to everyone.

     

    Our auction site just got pulled because we don't have an auctioneers licence. We'll be looking into this ASAP.

     

    Im in Australia by the way.

     

    Dan

     

     

    I've done my research. Apparently there are no laws which prevent the sale of new items via auction in Australia. UNLESS you are selling motor vehicles or Real Estate, or prescribed items (mobile phones and second hand goods)

     

    Dan


  9. Firstly thank you Dan for a great contribution.

     

    Let's hope we can get this forum back to the original topic - support for Auction v2.1.

     

    I just uploaded a out of the box package of OS Commerce and installed Auction v2.1. It works great, however for a few little bugs.

     

    The first being:

     

    Page -

    http://domain.com.au/auctions.php

     

    The error display twice, under the Starting Price and Highest Bid

    Warning: Missing argument 2 for display_price() in /var/www/vhosts/domain.com.au/httpdocs/includes/classes/currencies.php on line 72

     

    I know there is no modifications for the currencies file.

     

    Line 72 is

    	function display_price($products_price, $products_tax, $quantity = 1) {
      return $this->format($this->calculate_price($products_price, $products_tax, $quantity));
    }

     

    The second error is in:

    http://domain.com.au/product_info.php?products_id=8

     

    Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/domain.com.au/httpdocs/product_info.php:142) in /var/www/vhosts/domain.com.au/httpdocs/product_info.php on line 160

     

    Line 142 in product_info.php is

    <html <?php echo HTML_PARAMS; ?>>

     

    And line 160 is:

    159 if ($casprodid==(int)$HTTP_GET_VARS['products_id']) {
    160 header('Refresh: 90');} else {
    161 echo '';}

     

    I haven't had a chance to go over the code fully to see what could be causing the errors.

    Like I said before, I am using the out of the box installation. The sql file was installed.

    The admin works without any problems.

     

    Thanks in advance!

    Lau

     

     

    Thanks for the feedback.

     

    I'll go through them one by one.

     

    Currencies? Yes you are correct here. I will make this mod in the next version 2.2

     

     

    Line 72 is

    	function display_price($products_price, $products_tax, $quantity = 1) {
      return $this->format($this->calculate_price($products_price, $products_tax, $quantity));
    }

     

    The missing argument for display price is for TAX. as I did not want tax to be applied or come into play when people are bidding on items, I left out the argumet. This error can be ignored, short of that, I'll have to re-do the function.

     

    Line 142 in product_info.php is

    <html <?php echo HTML_PARAMS; ?>>

     

    And line 160 is:

    159 if ($casprodid==(int)$HTTP_GET_VARS['products_id']) {
    160 header('Refresh: 90');} else {
    161 echo '';}

     

    I could not reproduce this error on Version 2.2 RC2a. This section of code however is to automatically refresh the page every 90secs. The error displayed is definitely being caused by header tags being sent twice to the page. Any chance you could PM me your product_info.php so I can try to reproduce the error?

     

     

    Regards

    Dan


  10. and i would for sure not speak about my stupid comments , never talked about credits but rather a logic,

    take a contrib like fckeditor, lookin contributions see they are at least 5 , so because i helped in one i ot at least 10 message a week asking me wich one to download, wich one is the best, wich one is the last, and i thin it s a waste of enrgy and time.

     

    it think this is not stupid when i see auctions then auction beta, then auction 2.10 and not auction 2 for instance

    to say and expect that then after there will be a page 3.10 etc.

     

    so before it was too late i wanted to give an advice and opinion.

     

    by the way if i didnt test your version it s because i m already testing the beta version that also is a bunch of work we did with french members.

     

    and i think when your beta is finished and ours , then we coulnd defintily make an even better version with both work.

     

    imagine if we did alos a page calleld auction french beta , then for sure again ... blablab bla bla bla

     

    so dont misunderstand me i dont judge your work as i know we also had to rework almost from the scratch and it s hard to work at several on a complete rework of any code ...

     

    i for sur would give you feedback when i would test your new version on a virgin ms2

     

    so stupid and french, but not dumb and deaf

    that would be my last post about this subject :-"

     

     

    The Beta IS finished . 2.1 is a polished version, sure there is plenty of work to do, however this version is fully functional. I've already got a list of improvements in terms of functionality, Language definition files, streamlining code and very minor bug fixes.


  11. well then that would be great to call it something diferent from the beginnig like :

     

    Better auctions or anything , but not auction 2.xx that for sure would evolve to auction 3.xx sometimes

    so not use any version in the name

    And for me as it s an evolution of auction i dont see the meaning to post it in another page even if it s a tremendous evolution, it s just to not confuse osc members and to get as much help as you need bu people interested in this contributions.

     

    Making different threads, different contrib page, different names would only split people and make them being confused.

    This contrib is so far removed from the original that it is not practical to have the two together. Separating the two has been a request from those ACTIVELY involved in this contrib for this reason. I have already requested the BETA contrib be removed, I certainly don't need, advise on the subject. Ill not be doing the same for Version 2.1 which is polished *enough* to release as THE ONLY fully functional version.

     

    Dan

     

    I would have, however, much of the work was done by previous contributors, and, like I said, Credit. Given the fact that I've requested the BETA version be removed as is no longer necessary. Given the fact, that nobody seems to look at the previous version or respond to any posts and the fact I've posted a notice in the previous version, stating I will not support it, I do not think this will be a problem. If it is, people should learn to read. If they can't, I don't want to support them. Fair enough?


  12. I have to agree with Azer on this...

     

    There was no need to open up a new contribution everytime a modification is made - the last two instances of you adding a new independent contribution to the downloads are was not necessary..... you should have used a little tact because this will end up being confusing for some people who are looking a for a particular type of auction contribution to download.

     

    I suggest asking a moderator to delete this contributions you have added:

    Auctions V2 Beta http://addons.oscommerce.com/info/5843

     

    It is prefereable to continue adding contribution modifications at the original area:

    http://addons.oscommerce.com/info/4651 and preferable to use the original support thread: http://forums.oscommerce.com/index.php?showtopic=235920

     

    But as it seems you are trying to break away from the style of the original author with modifications and have set up your own download with a new support thread, I request you continue to post all updates in just one area which is here: http://addons.oscommerce.com/info/5890

     

    Thanks

     

    Before you go and hop on Azers band wagon, have a look at my code, have a look how much SH*T has been removed and added in its place. Doing so was a request from those actively involved in the contrib. This is not simply a 5 second bunch of mods, rather the culmination of ALL previous issues, requested functions etc from the previous contrib. ALL features no one else here could be F**KED completing. Separating the two was not a decision based on removing credit from original authors, rather to limit confusion from those seeking advice or reading now completely obsolete posts on fixes from previous versions. Note to mention the 11 odd pages of advice of which 95% of has been rectified in this contrib.

     

    I invite you to go back, have a look at the outstanding issues from the previous thread, issues which you'll find from page 1-11. Now I invite you to go back and find one that hasn't been rectified in this contrib.

     

    As for Azers completely STUPID comment about opening a new thread for version 2.2,3 etc. Azer WAKE UP. Having NO ONE to test this contrib bar myself, i did not want an in opperable version to be muddled in amoungst finished versions. HENCE THE WORD B-E-T-A! Meaning (in IT terms) "Testing for BUGS". Shall we just add all the obsolete feedback to the original thread as well?

     

    I should point out that separating this contribution was done under advice from people ACTIVELY contributing and submitting feedback on the BETA version, something none of you guys would do.

     

    Its taken years for someone to be bothered getting off their ass to develop this contrib into something truely useful.

    A simple thankyou for all the hard work would suffice.

     

     

    Dan


  13. Auctions Contrib has been completely re-developed. Please see here :http://addons.oscommerce.com/info/5890

     

    Auctions 2.1 By Dan Herlihy for OSCommerce Version 2.2rc2a (Should work on previous versions)

     

    Credit goes to Celdish, Marcus Design, Azer and The French Autions team. Who have all put a lot of work into this contrib.

    I'd also like to thank those who tested and reported bugs for the BETA Version of this contribution. Without your help, this

    would not have been possible.

     

    Regards

    Dan

     

    TESTED with PHP V5

     

    Basic Features :

    Run your own ebay Like auctions from your own website.

    Admin console to monitor the status of auctions (Auction finished, added to cart, complete).

    Auto emails sent upon higher bid and finished auction.

    Finished Auctions automatically added to users shopping cart.

    Auctions page provides overview of current auctions including number of bidders, starting bid, highest bid, time remaining,

     

    etc.

    Current auctions of which a user has bid on appear in "My Account" (account.php)

    PHP countdown with autorefresh to update times

    PHP file for CRON job to automatically process completed auctions, sends notification emails, adds to cart etc.

     

    ***Please note, completed auctions are processed in the following ways:

    • CRON JOB (you must set this up yourself - Google VisualCron (for windows) for more information. This cron job is best run

     

    from the server in which your site resides. Ask your system Admin about setting up a "CronJob" to automatically load the

     

    aucron2.php file every 3 or so mins.

    • Customer views their own shopping cart

    • Anyone views the completed auction page (This page will auto refresh which will also process a completed auction)

     

     

     

    Installation Notes:

     

    This installation requires a basic level of PHP and SQL understanding provided you are installing this on a fresh copy of

     

    OSC version 2.2rc2a

    You can modify the "results per page" for the auctions.php and account.php by changing the value of the $rowsPerPage

     

    variable in each page.

    Please ensure the following files are modified to suit your store. You will need to replace "Yoursitename.com" and "Your

     

    Name" with your own details. This (Best done once installation is complete)

    catalog/includes/modules/auctions_bids.php

    catalog/shopping_cart.php

    catalog/product_info.php

    You must set a cron job to execute aucron2.php file every 3 mins. This file will automatically detect finished auctions and

     

    send emails to the winners.


  14. Something like this will do:

     

    select max(ab.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 auctions_bids ab,

    auctions ap,

    customers cc,

    products_description pp,

    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 = pr.products_id

    and ap.status = 1

    and pr.products_id = ap.products_id

    and ap.expires_date < 'now()'

    group by ab.bid_price

    order by ab.bid_date_added asc

    limit 1

     

    I will have account ready today and pm you with all info.

     

    One step ahead of you. THis is what I used (I prefer your way though - a lot simpler. I wish I'd remembers the ORDER BY and LIMIT functions before! :

     

    select max(ar.bid_price) as bid_price, ar.customers_lastname, ar.customers_firstname,ar.customers_email_address

    FROM (SELECT ab.customers_id, ab.bid_price, c.customers_lastname, c.customers_firstname,c.customers_email_address

    FROM auctions_bids ab, customers c

    WHERE ab.customers_id =c.customers_id and ab.auctions_id =***22*** <-for instance! ) ar

    Group by bid_price DESC

    LIMIT 1,1

     

    Auctions 2.0.5 BETA is now released. Y'all may want to hold off though as we now have a Vanilla Site to install, test and document this on (Thanks marcinmf). This means we MAY be very close to a polished release. Fingers crossed I'll have some good news for everyone tomorrow. (It's going to be a late night)

     

    Here's the detail on fixes for 2.0.5

     

    • Updated auctions.sql file - please check for changes and perform them!

    • product_info.php A few changes to the code for sending emails and a few queries, please perform step 1 again. - Fixed higher bid notification bug

    • New auctions_bids.php file - Fixed Winning email bug -sent to wrong person

    • New admin/auctions.php file - Plenty of new features here - This is the NEW ADMIN CONSOLE!!!! -Please make sure you've updated your database from the auctions.sql file. Please note this file is for new installs only, If you're upgrading, be sure to check what has changed and manually do so. Changes are documented in the file

    • New account.php file (STEP 0)- Lets users know whats happening with auctions they've bid on! I've included MY OWN file here. I've changed the file name from account.php to dansaccount.php so you don't copy over your existing file. My Site is heavily modded- I think I've got the changes document here (STEP 0), but just in case - my file is there for your reference - Works for me.

    • NEW auctionslister.php file. This displays all current auctions. to be copied to your /catalog/ directory. This file is formated for my own site. Mine is heavily modified, if you try to open this on your own site, you may need to modify the file for it work correctly.Still yet to create a link for and document this. It's a similar file to the privacy.php file (Not an include, but full file).

    • NEW auctions_info.php language file

    • NEW auctions_bids.php language file

    • NEW auction.php language file

    • NEW auctions.php language file

    • Changes to /catalog/filenames.php (Step 2)

    •Changes to /admin/filenames.php (Step 8)

    • auction_terms.php <---Probably doesnt work - Still can't be stuffed doing this- Will probably be last on the list.

    • auction_info.php <--Not sure if this file is necessary, none the less it was in my catalog directory, so I included it.

     

    Dan


  15. I took the latest version of the contrib and the same problem came, here is the case. Try to recreate that

    there are 3 customers, John, Mike and Tom.

    John bid 10

    Mike bid 20

    Tom bid 30

    Again John bid 40

    After auction finish Tom got email that he won auction with price of 40. not john, i was studying the select MAX query. I will consult that with friend of my and we will come with some solution.

     

     

    Hmmm Let me look into it - I understand the problem a bit better now. I'll figure it out - There is another way to do the query which may work better. I'll get back to you tomorrow.

     

    Also stay tuned as I've just completed the admin side to this contrib- Give all auction details and payment status similar to ebay. I was going to post this last week, but like I said, I've been busy on other things.

     

    D


  16. Well i am customizing this contribution to fit my already customized store maybe thats the problem.

    I can provide server for testing with fresh os cstore, let me know if you would like to work on it so i will provide you some access, or pm me.

     

    FANTASTIC- Finally, someone is intersted enough to give me something fresh to install this on - we may get out of the Beta versions yet!

     

    PM the the details including DB IP, L/P, Site URL, L/P and FTP L/P and I'll get started right away. Sorry I was a bit quiet last week, I was busy working on my Calendar Deals contrib (crazystu.com.au) - This will not be publicly relseased as I don't want every man and his dog doing the same thing.

     

    I'll consider private requests. -The best thing? There's next to no PHP modification, simply copy the files, include the calendar and you're done.

     

    Dan


  17. I found one bug.

    I have created 3 users, and was placing bids randomly. After auction ended email with winning info was send to the bidder who had highest number in auctions_bids_id in table auctions bids.

    Problem is if customer will place bid again he still will have the same auctions_bids_id and if he won email will be send to someone else.

    Problem is in aucton2.php

    $query="select MAX

    I will look on it tomorrow and give correct query.

     

    Not quite sure I understand the problem. To be honest, I have not been able to reproduce the error you describe, however Im not sure I understand exactly what you are saying. As far as I know, "select MAX(ab.bid_price) as bid_price" selects the highest bid only which should have nothing to do with customers_id. None the less, I'd be very interested to see a more solid way to do this.

     

    By the way, thanks for the constructive feedback

    Dan


  18. Nop I haveno , auctions is the only contribution I have installed so far

     

    If this is a virgin site, I know it's a big ask, but is there any chance I could install this for you? The whole reason this is a BETA version is because it has not been tested properly on a virgin install. I can't even doucment this correctly because I don't have virgin site to do so on.

     

    Not that it means much, but you have my word I will not steal your site or any information within. PM me if interested.

     

    By the way, we now have an admin console!

     

    Featuring : Checkout status : NA/Added to cart/Complete

    A paged list of all auctions with highest bidder, highest bid, ammount of bids, starting price, auction status, description, image, auction end date etc. Basically all the information one needs to be able to see the status of their auctions at a glance.

     

    I've also polished the "My Account" section with a paged list of all auctions bid on,

     

    Recreated an catalog/auctions.php page with most of the information from the admin console.

     

    Dan

     

    Dan


  19. it dosent give me an auction folder in my admin

    If that is the case, then you have not installed the admin console correctly. There should be an option "Auction Products" under the catalog section of your admin, if not, read the install instructions carefully. The answer lies within.

     

    No offence, but these are pretty simple problems you've got and as this is a BETA contrib, I think the level of expertise required to install this is a little over your head.

     

    Good luck

    Dan


  20. 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

     

     

    OK Lets just work through this step by step so I know where the problem lies,

     

    If the product is added to the shopping_cart,

     

    can you find the product in the customers_basket table?

    does the customers_basket table contain a column called "auction_product" and "Final_price"?

    If so, does the "auction_product" field contain the number 1?

    also does the "final_price" field contain the final auction price?

    If none of this is true, add some dummy information to these fields - "1" in auction_product and say "99" in final price. Then log in as the winning bidder and have another look at your cart, then tell me what happens.


  21. Thank you so much for your reply,

     

    I moved the setup.php to modules and it worked like charm, for the header problem:

     

    product_info.php

    <?php 
    //DANS AUCTION SCRIPT -REFRESH
    $cquery="select products_id from ".TABLE_AUCTIONS_PRODUCTS." where products_id =".(int)$HTTP_GET_VARS['products_id'];
    $cresult=mysql_query($cquery);
    
    $cnum=mysql_numrows($cresult);
    
    $z=0;
    while ($z < $cnum) {
    
    $casprodid=mysql_result($cresult,$z,"products_id");
    
    echo $casprodid;
    $z++;
    }
    if ($casprodid==(int)$HTTP_GET_VARS['products_id']) {
    header('Refresh: 120');} else {									 -= I think this line's causing problem =-
    echo '';}
    //END DANS AUCTION SCRIPT
    ?>

     

    But I'm not sure about the arrangement of the code, startings and endings are in the right place and there's a blank line before the starting, I tried to remove it but no result.

     

    Here's my code, do a compare and see if you pick up anything. Please note: This is from a heavily modded site. Some of this may not work for you, best to simply the whole lot down first to see exactly where there error occurs.

     

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html <?php echo HTML_PARAMS; ?>>
    
    <?php 
    //DANS AUCTION SCRIPT -REFRESH
    $cquery="select products_id from ".TABLE_AUCTIONS_PRODUCTS." where products_id =".(int)$HTTP_GET_VARS['products_id'];
    $cresult=mysql_query($cquery);
    
    $cnum=mysql_numrows($cresult);
    
    $z=0;
    while ($z < $cnum) {
    
    $casprodid=mysql_result($cresult,$z,"products_id");
    
    //echo $product_info_queryA;
    $z++;
    }
    if ($casprodid==(int)$HTTP_GET_VARS['products_id']) {
    header('Refresh: 90');} else {
    echo '';}
    //END DANS AUCTION SCRIPT
    echo $aaprodname;
    ?>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
    <title><?php echo $header_tags[title_tag]; ?></title>
    <meta name="description" content="<?php echo $header_tags[desc_tag]; ?>">
    <meta name="keywords" content="<?php echo $header_tags[keywords_tag]; ?>">
    <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
    <link rel="stylesheet" type="text/css" href="style.css">
    <script language="javascript"><!--
    function popupWindow(url) {
     window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
    izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le
    ft=150')
    }
    //--></script>
    </head>
    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
    <!-- header //-->
    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>

×