Jump to content


  • Content Count

  • Joined

  • Last visited

Posts posted by someone

  1. this is the answer i got from opencart community. "All line items on the order are stored in the "order_total" table. You can find the relevant lines using the "order_id" column, then loop through the rows you find, and pick the one with code "shipping". The cost of the shipping will be stored in the "value" column.

    How do i subtract this from the commission % ?

  2. this:	               
    			$sql = 'SELECT * FROM  `' . DB_PREFIX . 'order` WHERE order_id = ' . (int)$this->session->data['order_id'];
    			$jrox2 = mysqli_query($jrox, $sql);
    			$aff_data = mysqli_fetch_assoc($jrox2);	
    			$aff_integrate = file_get_contents('https://www.somewebsite.com/affiliates/sale/amount/' . $aff_data['total'] . '/trans_id/' . $this->session->data['order_id'] . '/tracking_code/' . $_COOKIE['jamcom']);
  3. thank you for your respond. Sorry got distracted with a different project and  did not respond back right away. That htaccess did not changed anything. 

    I wonder if it have anything to do with this part?

    the store  is located at domain.com/store/  has its own htaccess with rewrite rules

    # SEO URL Settings
    RewriteEngine On
    RewriteBase /store/
    RewriteRule ^sitemap.xml$ index.php?route=extension/feed/google_sitemap [L]
    RewriteRule ^googlebase.xml$ index.php?route=extension/feed/google_base [L]
    RewriteRule ^system/storage/(.*) index.php?route=error/not_found [L]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_URI} !.*\.(ico|gif|jpg|jpeg|png|js|css)
    RewriteRule ^([^?]*) index.php?_route_=$1 [L,QSA]



    and affiliate is located at domain.com/affiliates/  and has this part in htaccess   

    <ifModule mod_rewrite.c>
        RewriteEngine On
    	# Some accounts require the RewriteBase to be set
    	#RewriteBase /
        # Force URL to be on SSL page at all times
        #RewriteCond %{HTTPS} off
        #RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
    	RewriteCond %{REQUEST_URI} ^/system.*
        RewriteRule ^(.*)$ index.php?/$1 [L]
        RewriteCond %{REQUEST_FILENAME} !-f
        RewriteCond %{REQUEST_FILENAME} !-d
        RewriteRule ^(.+)$ index.php?/$1 [L]


    I think something is off between these two.


  4. Thank you for helping to resolve that issue. It got me further. Now i am testing the integration. As customer i click on the link and made a purchase. checkout/success page showed error on top of the page:

    Warning: file_get_contents (https://website.com/affiliates/sale/amount/56.8177/trans_id/19775/tracking_code/1-1-someone-KJA9FRZRB7S3IPL): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/someplace/public_html/store/system/storage/modification/catalog/controller/checkout/success.php on line 178

    And this is what i have on line 178 there:     

    $aff_integrate = file_get_contents('https://website.com/affiliates/sale/amount/' . $aff_data['total'] . '/trans_id/' . $this->session->data['order_id'] . '/tracking_code/' . $_COOKIE['jamcom']);

    (website.com is edited of course)


  5. Trying to test this software. Added a tex link for one user. Clicking on that link shoes error. What would this error mean?

    Error Number: 1055

    Expression #79 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'something_affiliate.jam_members_photos.photo_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

    SELECT `jam_members`.*, `jam_members`.`member_id` as `mid`, `jam_members_photos`.*, `jam_members_groups`.`group_id` FROM `jam_members` LEFT JOIN `jam_members_photos` ON `jam_members`.`member_id` = `jam_members_photos`.`member_id` LEFT JOIN `jam_members_groups` ON `jam_members`.`member_id` = `jam_members_groups`.`member_id` WHERE `jam_members`.`username` = 'someusername' AND `status` = '1' GROUP BY `jam_members`.`member_id`

    Filename: models/Affiliate_marketing_model.php

    Line Number: 373

  • Create New...