Jump to content

henri

Team
  • Content count

    334
  • Joined

  • Last visited

Everything posted by henri

  1. henri

    OSC-Affiliate

    Ok, the first Release. Differences to Steve Alpha: -Optimised a lot of SQL Querys -Bugfixes -new Database Strukture -removed not yet working things -Introduced a billing system in the Admin Get it here contributions Test it and find the bugs (hope i didn't produced some news with the last changes i did today) what do i want to do until 1.0: - registration: more fields - perhaps a change of the bannermanger - some codeoptimation (getting it to OSC-Standards) - check for unused defines and other old stuff which is in the code I will try to fix upcoming bugs very fast, new features have to wait due lack of time. Whats would be usefull: - someone makes the missing / changes the worse Buttons - Translation to german/espanol Have Fun Henri
  2. Webbased fully configurable Supportticketsystem (easy to install) Demo: http://62.146.28.232/ (may be broken) Used OSC Version: MS1 (but should work with all Versions who have the affiliate running ;) ) Download: http://www.oscommerce.com/community/contributions,1230 For updates also check: http://www.in-solution.org Have Fun Cu Henri
  3. henri

    OSC-Affiliate

    But the main function for this stuff should be present ;)
  4. henri

    OSC-Affiliate

    affiliate_id affiliate_lft affiliate_rgt affiliate_root 1 1 2 1 Ok lets insert No2 as child of 1: affiliate_id affiliate_lft affiliate_rgt affiliate_root 1 1 4 1 2 2 3 1 Ok lets insert No3 as child of 1: affiliate_id affiliate_lft affiliate_rgt affiliate_root 1 1 6 1 2 2 3 1 3 4 5 1 No4 is child of 3 affiliate_id affiliate_lft affiliate_rgt affiliate_root 1 1 8 1 2 2 3 1 3 4 7 1 4 5 6 1 clear? test it here: http://www.klempert.de/nested_sets/demo/in...e=r2&node=0
  5. henri

    OSC-Affiliate

    If the tier system is the same as in my very old release, then the tier information are stored in the affiliate_affiliate table. The system to store it is called "Nested Sets" (original developed by Joe Celko, i think). You need the fields lft and rgt (root) to determine alle subs and level of an affiliate. Should only be one query to get all the information. The other possible model is the parent_id model, (like used in the categories), but this has huge performance problems if you have a lot of tiers. (some may have experienced this with the categories ;) ) Sad to here this. I stopped developing it and wanted to release a new version with the so called upcoming MS3... Perhaps wirh the next osC release in some years ;) i start again...
  6. Sure it possible, the problem is, when the number gets guessable, everyone can try to read tickets, if you allow non registered customers to write tickets.
  7. henri

    OSC-Affiliate

    Just set billingtime to -1 than you can test at once, at least at my old release it worked. From the old Faq:
  8. henri

    OSC-Affiliate

    affiliate_affiliate via: affiliate_lft, affiliate_rgt, affiliate_root
  9. henri

    OSC-Affiliate

    The realtion of the tier system stands in the DB. It's saved via "nested sets".
  10. Should be explained in this thread. If not just copy the tep_mail functions in the catalog, and add the Store Owner Emailaddress (similar to checkout_process). Customers should get an email. The content is not added, cause a, we want the customer to get back to the shop, b, if he gets content he replies to the email which would ignore the ticket system Depends on what you need. There are bigger and complexer) systems out there ;) But if you need emails to remind you to look after a possible ticket, it should be working for you
  11. henri

    OSC-Affiliate

    Solutions: - don't use Get-vars only Post as methods for submitting the ref-id (means that your affiliate have to use forms to link to you page) I think google than does not follow the links. - you can send all get links to a extra page which then redirects via moved permanently to your unique product page (don't know how google reacts to this)
  12. henri

    OSC-Affiliate

    add this: then you should see where it is ;)
  13. henri

    OSC-Affiliate

    Hi, if you want to reduce the $affiliate_total you should run through the $order_total (the code is seen in checkout_process) and check if a giftvoucher is used. If so you can reduce the $affiliate_total.
  14. henri

    OSC-Affiliate

    Which contribution did you download? (exact file please) If this is the original file, it's a security breach. If your admin has a session based login, every one has access to it!
  15. henri

    OSC-Affiliate

    Should work with the banner_id. The script doesn't checks if the banner exists. So if you made a list: banner_id - keyword 100001 keyword1 100002 keyword2 and then give google links with ref and affiliate_banner_id it should fill the database. For a complete online solution you have to code some more scripts.
  16. henri

    OSC-Affiliate

    To alle questions yes, except: Nice idea, not done yet. ref= should work, ALL links with ref= are counted. If you want other textlinks just build them. I haven't implemented this yet. Would increase the difficulty of the setup of the contri. And as a lot of people have problems with the simple setup, just forget it for now. How to do it: add a affiliate commision field to the products, get this field into the products array in the classes shopping_cart and orders. -> then you can use it in affiliate_checkout_process to use you calculation. Shouldn't be a problem to add a tep_mail function to the signup page ;)
  17. henri

    OSC-Affiliate

    read the thread...
  18. In the admin und the box Support Tickets
  19. henri

    3DSecure

    i.e. the basic Ipayment (Germany) module is 3dsecure compatible for a customer i implemented an enhanced ipayment module, but this needed certification by visa.
  20. henri

    OSC-Affiliate

    For wwaht do you think payment treshold stands?
  21. henri

    OSC-Affiliate

    Cause no new problems occur ;) So as always: check if the sale is registered in Admin (if not check installation). and provision > treshold and order status = delivered and order is older than days before billing
  22. henri

    OSC-Affiliate

    Not possible with the Addon But lock at affiliate_checkout_process.php ?for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { ? ?$affiliate_total += $order->products[$i]['final_price'] * $order->products[$i]['qty']; ?} to: ?for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { ? ?if($order->products[$i]['skip_affiliate'] == '1') continue; ? ?$affiliate_total += $order->products[$i]['final_price'] * $order->products[$i]['qty']; ?} You must adjust the rest of the shop that you have $order->products[$i]['skip_affiliate'] add skip_affiliate to products and get it it into the orderclass...
  23. henri

    OSC-Affiliate

    Cause everything stands here and in the readme / faq...
  24. henri

    OSC-Affiliate

    It's possible. Store the affiliate_id in the customer table, when the customer logs in back into the affiliate session
  25. henri

    OSC-Affiliate

    Search google for nested sets Tutorials. Yes is possible, must only be implemented....
×