Shop Disabled ZnoteAAC (?)

[jo31]

As you can see my shop is Disabled and i cant seem to figure it out how to enable it?
ZnoteAAC, TFS 1.3, 10.98 client
Thanks for your help.

 

[Znote]

You can enable shop in config.php here:

ZnoteAAC/config.php at 0c64adb55e31c9617ec9f048620bedb343dfd7cf · Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC

github.com

$config['shop'] = array(
    'enabled' => false,
    'loginToView' => false, // Do user need to login to see the shop offers?
    'enableShopConfirmation' => true, // Verify that user wants to buy with popup
    'useDB' => false, // Fetch offers from database, or the below config array
    'showImage' => true,
    'imageServer' => 'items.znote.eu',
    'imageType' => 'gif',
);

By setting enabled to true.

For "Buy points" you need to enable some sort of purchase gateway like PayPal, pagseguro or PayGol:

ZnoteAAC/config.php at 0c64adb55e31c9617ec9f048620bedb343dfd7cf · Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC

github.com

 

[jo31]

You can enable shop in config.php here:

ZnoteAAC/config.php at 0c64adb55e31c9617ec9f048620bedb343dfd7cf · Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC

github.com

$config['shop'] = array(
    'enabled' => false,
    'loginToView' => false, // Do user need to login to see the shop offers?
    'enableShopConfirmation' => true, // Verify that user wants to buy with popup
    'useDB' => false, // Fetch offers from database, or the below config array
    'showImage' => true,
    'imageServer' => 'items.znote.eu',
    'imageType' => 'gif',
);

By setting enabled to true.

For "Buy points" you need to enable some sort of purchase gateway like PayPal, pagseguro or PayGol:

ZnoteAAC/config.php at 0c64adb55e31c9617ec9f048620bedb343dfd7cf · Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC

github.com

Yes but when i enable paypal system it says php cURL is not enabled. It is required to for paypal or captcha services. 1. Find your php.ini file. 2. Uncomment extension=php_curl Restart web server. If you don't want this then disable paypal & use_captcha in config.php.
but i dont have the php.ini i have searched everywere.

Post automatically merged: Mar 19, 2020

@Znote I also have encountered this problem
If someone could help me with my SQL problem i got in console when i shutdown my server it says the line below. But only when my character wear the custom items we have put in the server.

[Error - mysql_real_query] Query: INSERT INTO player_items (player_id, pid, sid, itemtype, count, attributes) VALUES (3,1,101,2457,1,''),(3,2,102,2173,1,'\0'),(3,3,103,1988,1,''),(3,4,104,2463,1,''),(3,5,105,2525,1,''),(3,6,106,7410,1,''),(3,7,107,2647,1,''),(3,8,108,11117,
Message: Out of range value for column 'itemtype' at row 9
[Error - mysql_real_query] Query: INSERT INTO player_items (player_id, pid, sid, itemtype, count, attributes) VALUES (3,1,101,2457,1,''),(3,2,102,2173,1,'\0'),(3,3,103,1988,1,''),(3,4,104,2463,1,''),(3,5,105,2525,1,''),(3,6,106,7410,1,''),(3,7,107,2647,1,''),(3,8,108,11117,
Message: Out of range value for column 'itemtype' at row 9
[Error - mysql_real_query] Query: INSERT INTO player_items (player_id, pid, sid, itemtype, count, attributes) VALUES (3,1,101,2457,1,''),(3,2,102,2173,1,'\0'),(3,3,103,1988,1,''),(3,4,104,2463,1,''),(3,5,105,2525,1,''),(3,6,106,7410,1,''),(3,7,107,2647,1,''),(3,8,108,11117,
Message: Out of range value for column 'itemtype' at row 9
Error while saving player: Lucifer

 

[Znote]

@jo31 In order to help you properly, I'm gonna need to know what software you are using.

1. Which operating system? (Windows 10, Ubuntu 18.04?)
2. Which OT server distribution? (TFS 0.2, TFS 0.3, TFS 0.4, TFS 1.2, 1.3, otserv-br, otx, nostalrius, nekiro, othire)
3. Which web server? (xampp, uniform server, something else?)
4. Which PHP version are you using? (especially if using Linux)

You might need to install curl for php manually.


Your in-game SQL issue is odd, firstly the query is broken (did you not copy the entire query)?
Secondly, itemtype should support itemids up to 32767, so which itemid is it trying to save?
It says "row 9", but of which file?

 

[willfry]

@Znote Hello. I have the same problem, follow my information.
1. ubuntu 16.04
2. Othire
3. apache2
4. php7.0
I appreciate the attention.

Yes but when i enable paypal system it says php cURL is not enabled. It is required to for paypal or captcha services. 1. Find your php.ini file. 2. Uncomment extension=php_curl Restart web server. If you don't want this then disable paypal & use_captcha in config.php.
but i dont have the php.ini i have searched everywere.

 

[Znote]

@Znote Hello. I have the same problem, follow my information.
1. ubuntu 16.04
2. Othire
3. apache2
4. php7.0
I appreciate the attention.

Yes but when i enable paypal system it says php cURL is not enabled. It is required to for paypal or captcha services. 1. Find your php.ini file. 2. Uncomment extension=php_curl Restart web server. If you don't want this then disable paypal & use_captcha in config.php.
but i dont have the php.ini i have searched everywere.

Have you tried sudo apt install php7.0-curl

You can also look for php.ini in these directories on Ubuntu:
/etc/php/7.0/cli/php.ini
/etc/php/7.0/fpm/php.ini
?

 

[willfry]

Have you tried sudo apt install php7.0-curl

You can also look for php.ini in these directories on Ubuntu:
/etc/php/7.0/cli/php.ini
/etc/php/7.0/fpm/php.ini
?

Thanks, I was able to install a phpcurl 7.40, but the recapctha doesn't appear on my account creation screen, but if you try to create it, the message "prove you're not a robot"