Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

cs42na

Archived
  • Posts

    12
  • Joined

  • Last visited

Profile Information

  • Real Name
    Nikolas Antoniades

cs42na's Achievements

  1. Nop I haveno , auctions is the only contribution I have installed so far
  2. Both the final_price and the auction_product include the values you specified but i still in my shopping cart I get the default price:(
  3. 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 .
  4. I think the problem is that these lines of codes never executed when I run the program /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();
  5. The contribution works great when someone which doesn't have an account buys a product but when a registered customer tries to buy something he gets the following error message 1366 - Incorrect integer value: '' for column 'customers_dummy_account' at row 1 insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, customers_dummy_account, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, shipping_module, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('5', 'Antonis Jacovides', '', 'Millenium', '', 'Guildford', 'GU2 7JN', 'Alabama', 'United Kingdom', '07738016190', '[email protected]', '1', '', 'Antonis Jacovides', '', 'Millenium', '', 'Guildford', 'GU2 7JN', 'Alabama', 'United Kingdom', '1', 'Antonis Jacovides', '', 'Millenium', '', 'Guildford', 'GU2 7JN', 'Alabama', 'United Kingdom', '1', 'Cash on Delivery', 'flat_flat', '', '', '', '', now(), '1', 'USD', '1.00000000') [TEP STOP]
  6. 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
  7. 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
  8. 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
  9. Nop Still no Luck , I am getting the following error " Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in C:\wamp\www\Nano\catalog\includes\modules\auction_bids.php on line 420" Shouldn't the product be added on the Customers shopping cart though??
  10. 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
  11. I have some problems after I installed the latest version. When I login as an administrator I cannot find were i can set the permissions for the customers to add products and when I click as a customer edit my products I am getting the following error " Parse error: syntax error, unexpected $end in C:\wamp\www\Nano\catalog\account_manage.php on line 824" P.s After I gave permission to one user by executing an SQL query from phpmyadmin I click to add a new product and the result was that I was transferred to a page full of php code and at the bottom there was the following error "Fatal error: Class 'objectInfo' not found in C:\wamp\www\Nano\catalog\account_add.php on line 197"
  12. 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
×
×
  • Create New...