Znote paypal doesn't add points

[Jojjo]

Hello,

I know this has been asked before but I just can't figure it out, I followed every step from the video Znote made in this thread:
https://otland.net/threads/video-tu...ing-ot-server-website-and-shop-system.166818/

The problem is when someone buys points on my server with paypal, the money will transfer to my paypal account but the player doesn't receive points. Even when my site shows the payment was succesfull.
I use Znote AAC version 1.5 and theforgottenserver-v1.1 with windows 8.1.

This is my config.php setup:

    //////////////
    /// PAYPAL ///
    //////////////

    // Write your paypal address here, and what currency you want to recieve money in.
    $config['paypal'] = array(
        'enabled' => true,
        'email' => '[email protected]', // Example: [email protected]
        'currency' => 'EUR',
        'points_per_currency' => 10, // 1 currency = ? points? [ONLY used to calculate bonuses]
        'success' => "http://".$_SERVER['HTTP_HOST']."/success.php",
        'failed' => "http://".$_SERVER['HTTP_HOST']."/failed.php",
        'ipn' => "http://".$_SERVER['HTTP_HOST']."/ipn.php",
        'showBonus' => true,
    );

    // Configure the "buy now" buttons prices, first write price, then how many points you get.
    // Giving some bonus points for higher donations will tempt users to donate more.
    $config['paypal_prices'] = array(
    //    price => points,
        1 => 10, // 0% bonus
        10 => 105, // +5% bonus
        15 => 165, // +10% bonus
        20 => 240, // +20% bonus
        25 => 325, // +30% bonus
        30 => 420, // +40% bonus
    );

Also I enabled Znote's External Open Tibia Services Server in my config.php:

    // Use Znote's External Open Tibia Services Server
    // Currently in Alpha and is pretty useless, but will contain paypal blacklist etc in future.
    // You can use the official server: http://zeotss.znote.eu/
    // Or host your own private one, here is the code: https://github.com/Znote/ZEOTSS
    $config['zeotss'] = array(
        'enabled' => true,
        'visitors' => true,
        'debug' => false,
        'server' => "http://zeotss.znote.eu/"
    );

And created an IPN on paypal for my website:

Furthermore if i go to my database table "Znote_paypal" it returned an empty result:

If I add points manually with the admin page it works perfect.
If you need extra info I'll be pleased to post it too.

I hope someone takes the time to look into this problem.

Thanks in advance,

Jonas

 

[Xanteria OT]

One of the reasons i prefer gesior,

U dont need to edit ipn from paypal so its automatic,

 

[Jojjo]

Well, I tried gesior but I can't even get the items ingame when bought with points, I followed every step in this tutorial:
https://otland.net/threads/ver-0-1-0-gesior-item-pacc-shop-php-lua-for-tfs.5772/

But used updated shop.lua for tfs 1.0 from this thread:
https://otland.net/threads/shop-lua-for-tfs-1-0.201559/

When I buy an item in the shop and relog on my server nothing happens. In Trans. history on website it just says "Not realized yet.".
In my database "z_ots_comunication" I see the "purchase" with type: login and action: give_item.
In z_shop_history_item I see the "purchase" aswell with trans_state: wait.

When I search the forums I always end up at post from 2009-2012 and just nothing helps, I tried so many shopsystem.php scripts and shop.lua (globalevent) scripts but nothing seems to work.

Yours

Jonas