[MyAAC][Plugin] PagSeguro (Brazilian payments gateway)

OP
slawkens

slawkens

Developer
Premium User
Joined
Aug 27, 2007
Messages
2,854
Reaction score
369
Location
Germany
When i use this steps /\, he cause bug at my google chrome, and dont set coins to account, at the same moment, this set "pagseguro_transactions" but not happen nothing.

screenshots:

Screenshot - pagseguro
Screenshot - pagseguro
Screenshot - mysql transaction
Screenshot - mysql acc
Have you changed in your config $config['pagSeguro']['donationType'] to 'coins'?
 
OP
slawkens

slawkens

Developer
Premium User
Joined
Aug 27, 2007
Messages
2,854
Reaction score
369
Location
Germany
Ok, I found the issue I quess:

Edit, payments/pagseguro.php

Change:
Code:
$stmt = $conn->prepare('UPDATE accounts SET ' . $field . ' = ' . $field . ' + :item_count WHERE ' . (USE_ACCOUNT_NAME ? 'id' : 'name') . ' = :account');
To:
Code:
$stmt = $conn->prepare('UPDATE accounts SET ' . $field . ' = ' . $field . ' + :item_count WHERE ' . (USE_ACCOUNT_NAME ? 'name' : 'id') . ' = :account');
I will release a fixed version soon.
 

Ice Mirow

New Member
Joined
Dec 15, 2015
Messages
27
Reaction score
0
Ok, I found the issue I quess:

Edit, payments/pagseguro.php

Change:
Code:
$stmt = $conn->prepare('UPDATE accounts SET ' . $field . ' = ' . $field . ' + :item_count WHERE ' . (USE_ACCOUNT_NAME ? 'id' : 'name') . ' = :account');
To:
Code:
$stmt = $conn->prepare('UPDATE accounts SET ' . $field . ' = ' . $field . ' + :item_count WHERE ' . (USE_ACCOUNT_NAME ? 'name' : 'id') . ' = :account');
I will release a fixed version soon.
now work!!!!!!!!! thank you very much!

but i have one bug:

Screenshot

when the page returns from the pagseguro, the photo error occurs, nothing appears on the page
 
Last edited by a moderator:

LeOnArd0

New Member
Joined
Jan 24, 2010
Messages
9
Reaction score
0
Sorry for double post.

Error.log

[Tue Jan 23 17:21:16.005381 2018] [mpm_event:notice] [pid 2686:tid 140293887616896] AH00489: Apache/2.4.7 (Ubuntu) configured -- re$
[Tue Jan 23 17:21:16.005450 2018] [core:notice] [pid 2686:tid 140293887616896] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 17:26:25.989115 2018] [mpm_event:notice] [pid 2686:tid 140293887616896] AH00491: caught SIGTERM, shutting down
[Tue Jan 23 17:26:27.042643 2018] [mpm_prefork:notice] [pid 6279] AH00163: Apache/2.4.7 (Ubuntu) configured -- resuming normal oper$
[Tue Jan 23 17:26:27.042728 2018] [core:notice] [pid 6279] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 17:26:28.313272 2018] [mpm_prefork:notice] [pid 6279] AH00169: caught SIGTERM, shutting down
[Tue Jan 23 17:26:29.390971 2018] [mpm_prefork:notice] [pid 6365] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured -$
[Tue Jan 23 17:26:29.391021 2018] [core:notice] [pid 6365] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 17:37:28.755336 2018] [:error] [pid 6370] [client 200.228.216.66:58462] script '/var/www/html/index.php' not found or u$
[Tue Jan 23 17:41:53.810753 2018] [mpm_prefork:notice] [pid 6365] AH00169: caught SIGTERM, shutting down
[Tue Jan 23 17:41:54.876762 2018] [mpm_prefork:notice] [pid 6541] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured -$
[Tue Jan 23 17:41:54.876808 2018] [core:notice] [pid 6541] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 18:21:54.624430 2018] [mpm_prefork:notice] [pid 6541] AH00171: Graceful restart requested, doing restart
[Tue Jan 23 18:21:54.674728 2018] [mpm_prefork:notice] [pid 6541] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured -$
[Tue Jan 23 18:21:54.674748 2018] [core:notice] [pid 6541] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 18:23:58.035511 2018] [mpm_prefork:notice] [pid 6541] AH00169: caught SIGTERM, shutting down
[Tue Jan 23 18:23:59.101212 2018] [mpm_prefork:notice] [pid 14808] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Tue Jan 23 18:23:59.101256 2018] [core:notice] [pid 14808] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 01:59:09.983913 2018] [:error] [pid 14812] [client 200.100.60.202:53280] PHP Fatal error: require_once(): Failed openi$
[Wed Jan 24 01:59:13.972884 2018] [:error] [pid 14813] [client 200.100.60.202:53282] PHP Fatal error: require_once(): Failed openi$
[Wed Jan 24 01:59:26.980833 2018] [:error] [pid 14815] [client 200.100.60.202:53288] PHP Fatal error: require_once(): Failed openi$
[Wed Jan 24 02:03:21.010452 2018] [mpm_prefork:notice] [pid 14808] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:03:22.079493 2018] [mpm_prefork:notice] [pid 21368] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:03:22.079537 2018] [core:notice] [pid 21368] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 02:42:03.213187 2018] [mpm_prefork:notice] [pid 21368] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:42:04.295687 2018] [mpm_prefork:notice] [pid 22948] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:42:04.295739 2018] [core:notice] [pid 22948] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 02:43:46.776205 2018] [mpm_prefork:notice] [pid 22948] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:43:47.846908 2018] [mpm_prefork:notice] [pid 23012] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:43:47.846966 2018] [core:notice] [pid 23012] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 02:51:14.210798 2018] [mpm_prefork:notice] [pid 23012] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:51:15.274523 2018] [mpm_prefork:notice] [pid 23804] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:51:15.274572 2018] [core:notice] [pid 23804] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 02:57:36.726486 2018] [mpm_prefork:notice] [pid 23804] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:57:37.795376 2018] [mpm_prefork:notice] [pid 23927] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:57:37.795426 2018] [core:notice] [pid 23927] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 05:18:43.266775 2018] [mpm_prefork:notice] [pid 23927] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 05:19:30.537986 2018] [mpm_prefork:notice] [pid 2107] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured -$
 
Last edited by a moderator:
OP
slawkens

slawkens

Developer
Premium User
Joined
Aug 27, 2007
Messages
2,854
Reaction score
369
Location
Germany
Sorry for double post.

Error.log

[Tue Jan 23 17:21:16.005381 2018] [mpm_event:notice] [pid 2686:tid 140293887616896] AH00489: Apache/2.4.7 (Ubuntu) configured -- re$
[Tue Jan 23 17:21:16.005450 2018] [core:notice] [pid 2686:tid 140293887616896] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 17:26:25.989115 2018] [mpm_event:notice] [pid 2686:tid 140293887616896] AH00491: caught SIGTERM, shutting down
[Tue Jan 23 17:26:27.042643 2018] [mpm_prefork:notice] [pid 6279] AH00163: Apache/2.4.7 (Ubuntu) configured -- resuming normal oper$
[Tue Jan 23 17:26:27.042728 2018] [core:notice] [pid 6279] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 17:26:28.313272 2018] [mpm_prefork:notice] [pid 6279] AH00169: caught SIGTERM, shutting down
[Tue Jan 23 17:26:29.390971 2018] [mpm_prefork:notice] [pid 6365] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured -$
[Tue Jan 23 17:26:29.391021 2018] [core:notice] [pid 6365] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 17:37:28.755336 2018] [:error] [pid 6370] [client 200.228.216.66:58462] script '/var/www/html/index.php' not found or u$
[Tue Jan 23 17:41:53.810753 2018] [mpm_prefork:notice] [pid 6365] AH00169: caught SIGTERM, shutting down
[Tue Jan 23 17:41:54.876762 2018] [mpm_prefork:notice] [pid 6541] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured -$
[Tue Jan 23 17:41:54.876808 2018] [core:notice] [pid 6541] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 18:21:54.624430 2018] [mpm_prefork:notice] [pid 6541] AH00171: Graceful restart requested, doing restart
[Tue Jan 23 18:21:54.674728 2018] [mpm_prefork:notice] [pid 6541] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured -$
[Tue Jan 23 18:21:54.674748 2018] [core:notice] [pid 6541] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 23 18:23:58.035511 2018] [mpm_prefork:notice] [pid 6541] AH00169: caught SIGTERM, shutting down
[Tue Jan 23 18:23:59.101212 2018] [mpm_prefork:notice] [pid 14808] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Tue Jan 23 18:23:59.101256 2018] [core:notice] [pid 14808] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 01:59:09.983913 2018] [:error] [pid 14812] [client 200.100.60.202:53280] PHP Fatal error: require_once(): Failed openi$
[Wed Jan 24 01:59:13.972884 2018] [:error] [pid 14813] [client 200.100.60.202:53282] PHP Fatal error: require_once(): Failed openi$
[Wed Jan 24 01:59:26.980833 2018] [:error] [pid 14815] [client 200.100.60.202:53288] PHP Fatal error: require_once(): Failed openi$
[Wed Jan 24 02:03:21.010452 2018] [mpm_prefork:notice] [pid 14808] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:03:22.079493 2018] [mpm_prefork:notice] [pid 21368] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:03:22.079537 2018] [core:notice] [pid 21368] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 02:42:03.213187 2018] [mpm_prefork:notice] [pid 21368] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:42:04.295687 2018] [mpm_prefork:notice] [pid 22948] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:42:04.295739 2018] [core:notice] [pid 22948] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 02:43:46.776205 2018] [mpm_prefork:notice] [pid 22948] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:43:47.846908 2018] [mpm_prefork:notice] [pid 23012] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:43:47.846966 2018] [core:notice] [pid 23012] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 02:51:14.210798 2018] [mpm_prefork:notice] [pid 23012] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:51:15.274523 2018] [mpm_prefork:notice] [pid 23804] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:51:15.274572 2018] [core:notice] [pid 23804] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 02:57:36.726486 2018] [mpm_prefork:notice] [pid 23804] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 02:57:37.795376 2018] [mpm_prefork:notice] [pid 23927] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured $
[Wed Jan 24 02:57:37.795426 2018] [core:notice] [pid 23927] AH00094: Command line: '/usr/sbin/apache2'
[Wed Jan 24 05:18:43.266775 2018] [mpm_prefork:notice] [pid 23927] AH00169: caught SIGTERM, shutting down
[Wed Jan 24 05:19:30.537986 2018] [mpm_prefork:notice] [pid 2107] AH00163: Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.22 configured -$
Can't find anything useful in this file. You need to copy whole content, without being trimmed, cause in this line for example:
Code:
[Wed Jan 24 01:59:26.980833 2018] [:error] [pid 14815] [client 200.100.60.202:53288] PHP Fatal error: require_once(): Failed openi$
There is more content after "Failed openi$" but it has been cutted off. You need to download that file to your computer, and then open it with Notepad++ or any other editor that makes automatic long line wraps.

Also, don't post the whole log, just the part at the time when you refresh your page and get that error. Check exact date & time.
 

LeOnArd0

New Member
Joined
Jan 24, 2010
Messages
9
Reaction score
0
Can't find anything useful in this file. You need to copy whole content, without being trimmed, cause in this line for example:
Code:
[Wed Jan 24 01:59:26.980833 2018] [:error] [pid 14815] [client 200.100.60.202:53288] PHP Fatal error: require_once(): Failed openi$
There is more content after "Failed openi$" but it has been cutted off. You need to download that file to your computer, and then open it with Notepad++ or any other editor that makes automatic long line wraps.

Also, don't post the whole log, just the part at the time when you refresh your page and get that error. Check exact date & time.
@slawkens.

Here

[Thu Jan 25 20:06:05.242565 2018] [core:error] [pid 15139] (13)Permission denied: [client 173.245.54.44:9259] AH00035: access to /images/guilds/default.gif denied (filesystem path '/var/www/html/images/guilds/default.gif') because search permissions are missing on a component of the path, referer: Guilds - Clash Baiak
[Thu Jan 25 20:06:07.418096 2018] [core:error] [pid 15158] (13)Permission denied: [client 162.158.79.36:14993] AH00035: access to /images/guilds/default.gif denied (filesystem path '/var/www/html/images/guilds/default.gif') because search permissions are missing on a component of the path, referer: Guilds - Clash Baiak
[Thu Jan 25 21:23:38.485190 2018] [:error] [pid 15176] [client 172.68.25.107:20723] PHP Fatal error: Uncaught exception 'Exception' with message 'PagSeguroLibrary: cURL library is required.' in /var/www/html/system/libs/PagSeguroLibrary/utils/PagSeguroHttpConnection.class.php:33\nStack trace:\n#0 /var/www/html/system/libs/PagSeguroLibrary/service/PagSeguroPaymentService.class.php(73): PagSeguroHttpConnection->__construct()\n#1 /var/www/html/system/libs/PagSeguroLibrary/domain/PagSeguroPaymentRequest.class.php(627): PagSeguroPaymentService::createCheckoutRequest(Object(PagSeguroAccountCredentials), Object(PagSeguroPaymentRequest), false)\n#2 /var/www/html/system/pages/pagseguro.php(35): PagSeguroPaymentRequest->register(Object(PagSeguroAccountCredentials))\n#3 /var/www/html/index.php(386): require('/var/www/html/s...')\n#4 {main}\n thrown in /var/www/html/system/libs/PagSeguroLibrary/utils/PagSeguroHttpConnection.class.php on line 33, referer: Points - Clash Baiak
 
OP
slawkens

slawkens

Developer
Premium User
Joined
Aug 27, 2007
Messages
2,854
Reaction score
369
Location
Germany
@slawkens.

Here

[Thu Jan 25 20:06:05.242565 2018] [core:error] [pid 15139] (13)Permission denied: [client 173.245.54.44:9259] AH00035: access to /images/guilds/default.gif denied (filesystem path '/var/www/html/images/guilds/default.gif') because search permissions are missing on a component of the path, referer: Guilds - Clash Baiak
[Thu Jan 25 20:06:07.418096 2018] [core:error] [pid 15158] (13)Permission denied: [client 162.158.79.36:14993] AH00035: access to /images/guilds/default.gif denied (filesystem path '/var/www/html/images/guilds/default.gif') because search permissions are missing on a component of the path, referer: Guilds - Clash Baiak
[Thu Jan 25 21:23:38.485190 2018] [:error] [pid 15176] [client 172.68.25.107:20723] PHP Fatal error: Uncaught exception 'Exception' with message 'PagSeguroLibrary: cURL library is required.' in /var/www/html/system/libs/PagSeguroLibrary/utils/PagSeguroHttpConnection.class.php:33\nStack trace:\n#0 /var/www/html/system/libs/PagSeguroLibrary/service/PagSeguroPaymentService.class.php(73): PagSeguroHttpConnection->__construct()\n#1 /var/www/html/system/libs/PagSeguroLibrary/domain/PagSeguroPaymentRequest.class.php(627): PagSeguroPaymentService::createCheckoutRequest(Object(PagSeguroAccountCredentials), Object(PagSeguroPaymentRequest), false)\n#2 /var/www/html/system/pages/pagseguro.php(35): PagSeguroPaymentRequest->register(Object(PagSeguroAccountCredentials))\n#3 /var/www/html/index.php(386): require('/var/www/html/s...')\n#4 {main}\n thrown in /var/www/html/system/libs/PagSeguroLibrary/utils/PagSeguroHttpConnection.class.php on line 33, referer: Points - Clash Baiak
Oh, right. You don't have cURL php extension installed.

You can install it with this command, when using linux:
Code:
sudo apt-get install php5-curl
Then restart apache:
Code:
sudo service apache2 restart
 

LeOnArd0

New Member
Joined
Jan 24, 2010
Messages
9
Reaction score
0
Oh, right. You don't have cURL php extension installed.

You can install it with this command, when using linux:
Code:
sudo apt-get install php5-curl
Then restart apache:
Code:
sudo service apache2 restart
Haha, you're the best! God.

Everything working! Thank you.

An question, how do I add vip days in the shop in db?
 
OP
slawkens

slawkens

Developer
Premium User
Joined
Aug 27, 2007
Messages
2,854
Reaction score
369
Location
Germany
Haha, you're the best! God.

Everything working! Thank you.

An question, how do I add vip days in the shop in db?
Its currently impossible. You can only add items that will add vip days with lua script.
 

mattos123

Well-Known Member
Joined
Sep 28, 2011
Messages
14
Reaction score
1
hello im getting,
[HTTP 401] - UNAUTHORIZED

upon search found this is realted to host not being able to send user of pagseguro and token, or something related to curl
halp pls
jajaja
 

d0gw4r

Member
Joined
Jun 6, 2019
Messages
30
Reaction score
1
Location
Brazil
Oh, hi...


  • I'm getting the following error when I try to buy coins.

36803


  • Here is my pagseguro.php configuration:
Path: /usr/share/nginx/html/plugins/pagseguro


36804


  • This is my MyAAC folder (I'm using nginx with MySQL Server):

36805


  • This is my installed plugins:

36806


  • This is how I configured My Applications in my PagSeguro Account (I don't know if it's right).

36807


I installed the geisor shop system plugin before the pagseguro plugin, and I think it's everything right configured, including my token code. What I'm doing wrong? :(

Thank you!
 
Last edited:

d0gw4r

Member
Joined
Jun 6, 2019
Messages
30
Reaction score
1
Location
Brazil
I'm also having this problem:

When I try to put any item in shop offer I get stuck on this screen....

36808


36809

How can I solve this?

Thanks!
 
OP
slawkens

slawkens

Developer
Premium User
Joined
Aug 27, 2007
Messages
2,854
Reaction score
369
Location
Germany
Oh, hi...


  • I'm getting the following error when I try to buy coins.

View attachment 36803


  • Here is my pagseguro.php configuration:
Path: /usr/share/nginx/html/plugins/pagseguro


View attachment 36804


  • This is my MyAAC folder (I'm using nginx with MySQL Server):

View attachment 36805


  • This is my installed plugins:

View attachment 36806


  • This is how I configured My Applications in my PagSeguro Account (I don't know if it's right).

View attachment 36807


I installed the geisor shop system plugin before the pagseguro plugin, and I think it's everything right configured, including my token code. What I'm doing wrong? :(

Thank you!
To buy points you need to visit: yourhost.com/?points, not ?pagseguro
 
Top