Joomla Gaming

The Gaming extensions for Joomla!

  • Increase font size
  • Default font size
  • Decrease font size
Home Forum
Welcome, Guest
Username Password: Remember me

OVER 1000000000000
(1 viewing) (1) Guest

TOPIC: OVER 1000000000000

OVER 1000000000000 2 years ago #1486

  • barret
  • OFFLINE
  • Senior Boarder
  • Posts: 71
  • Points: 4989
Bank transfers can not be more than one trillion.

Mysql data has been set bigint (20).


Use com_alphauserpoints_v1.5.4.


bank==>casino correct amount of casino


casino==>bank bank the amount of error
If transfer 2E+12 becomes 2 .
If transfer 1E+12 becomes 1 .


My membership goal is to break the upper limit of bigint(20).
Last Edit: 2 years ago by barret.

Re: OVER 1000000000000 2 years ago #1488

  • Vanama
  • OFFLINE
  • Administrator
  • Posts: 712
  • Points: 5063069
If I understand, If You transfer points from Casino to AUP, here is problem? This is not Casino bug. Mysql bigint is field for bigest numbers.

Maybe AUP don't know bigger numbers.
Like You My Extensions? Please donate.
Please vote my extensions here. Thanks!

Re: OVER 1000000000000 2 years ago #1490

  • barret
  • OFFLINE
  • Senior Boarder
  • Posts: 71
  • Points: 4989
Vanama wrote:
If I understand, If You transfer points from Casino to AUP, here is problem? This is not Casino bug. Mysql bigint is field for bigest numbers.

Maybe AUP don't know bigger numbers.






AUP sql data has been set bigint (20).

Re: OVER 1000000000000 2 years ago #1492

  • Vanama
  • OFFLINE
  • Administrator
  • Posts: 712
  • Points: 5063069
JG Casino sql data too.
Like You My Extensions? Please donate.
Please vote my extensions here. Thanks!

Re: OVER 1000000000000 2 years ago #1501

  • barret
  • OFFLINE
  • Senior Boarder
  • Posts: 71
  • Points: 4989
Vanama wrote:
JG Casino sql data too.



JG Casino sql data too.

$task == "deposit" =====>> No problem.


$task == "withdraw" : ===>> error !


$query = "UPDATE ".$dbtable." SET ".$field." = ".($credit->points + ($value * (int)$ratiovalue[0]))." WHERE ".$uid." = '$userid'";
$database->setQuery($query);
$database->query();


Why add more than 1 trillion will become one?

1E+12



Why add more than 2 trillion will become two?

2E+12


Control program is in the bank.php.

Not in the AUP.


If it is int the problem should also be 2147483647 instead of 1.

I have no idea.
Last Edit: 2 years ago by barret.

Re: OVER 1000000000000 2 years ago #1502

  • Vanama
  • OFFLINE
  • Administrator
  • Posts: 712
  • Points: 5063069
If You have AUP plugin installed and published, this query is not used and AUP script is used.

If You don't use AUP plugin, it's a bug otherwise not.
Like You My Extensions? Please donate.
Please vote my extensions here. Thanks!
Moderators: Tinker
Time to create page: 0.60 seconds