i.a.p prob
- killa187
- Contributor
- Posts: 56
- Joined: Thu Apr 23, 2020 7:46 pm
everything runs fine im using my tester account the purchase comes up i get email from test purchase receipt from google but in game the coins never update in ui and my database does not change.does it not update for test purchases.i get the message that coins been added the part the other error now shows its notifications but game dont update ui or database.
- Lovatto
- Admin
- Posts: 1834
- Joined: Sun Dec 07, 2014 3:18 pm
- Contact:
- killa187
- Contributor
- Posts: 56
- Joined: Thu Apr 23, 2020 7:46 pm
iam using 1.7 version one thing did notice is it does save under purchase in database just not the whole thing user id and id show but receipt and product id in database blank along with the coins not showing in ui or database at all
- killa187
- Contributor
- Posts: 56
- Joined: Thu Apr 23, 2020 7:46 pm
- killa187
- Contributor
- Posts: 56
- Joined: Thu Apr 23, 2020 7:46 pm
should it update in editor test to database as well or only when like been trying on google play and using a test account i looked even over the php and cant see no errors either where type 7 is i know a few diff languages it should save
- killa187
- Contributor
- Posts: 56
- Joined: Thu Apr 23, 2020 7:46 pm
the total coins being echoed back are just the ones from the database its like the ones being added from json not being added or equals 0 somewhere so when there being added together its what ever you had plus 0;
- Lovatto
- Admin
- Posts: 1834
- Joined: Sun Dec 07, 2014 3:18 pm
- Contact:
Thanks for the info, I found the problem, you have to edit the bl_Database.php script in your server with the following:
After this line:
Add this:
Then after these lines:
add these:
Let me know if that work for you.
After this line:
Code: Select all
$flist = safe($_POST['flist']);
Code: Select all
$data = safe($_POST['data']);
Code: Select all
$coins = stripslashes($coins);
$coins = mysqli_real_escape_string($link, $coins);
Code: Select all
$data = stripslashes($data);
$data = mysqli_real_escape_string($link, $data);
- killa187
- Contributor
- Posts: 56
- Joined: Thu Apr 23, 2020 7:46 pm
should it save to database in editor or will i need to build a test for google again cause the totalcoins still echoed is the original still not adding data.coins in unity equals what should be before being posted i put a debug so data in unity rightLovatto wrote: ↑Sun May 17, 2020 9:51 am Thanks for the info, I found the problem, you have to edit the bl_Database.php script in your server with the following:
After this line:Add this:Code: Select all
$flist = safe($_POST['flist']);
Then after these lines:Code: Select all
$data = safe($_POST['data']);
add these:Code: Select all
$coins = stripslashes($coins); $coins = mysqli_real_escape_string($link, $coins);
Let me know if that work for you.Code: Select all
$data = stripslashes($data); $data = mysqli_real_escape_string($link, $data);
- killa187
- Contributor
- Posts: 56
- Joined: Thu Apr 23, 2020 7:46 pm
in editor test database coins dont change the purchase are gets new listing but the receipt etc are blankLovatto wrote: ↑Sun May 17, 2020 9:51 am Thanks for the info, I found the problem, you have to edit the bl_Database.php script in your server with the following:
After this line:Add this:Code: Select all
$flist = safe($_POST['flist']);
Then after these lines:Code: Select all
$data = safe($_POST['data']);
add these:Code: Select all
$coins = stripslashes($coins); $coins = mysqli_real_escape_string($link, $coins);
Let me know if that work for you.Code: Select all
$data = stripslashes($data); $data = mysqli_real_escape_string($link, $data);
- killa187
- Contributor
- Posts: 56
- Joined: Thu Apr 23, 2020 7:46 pm
even test on google play no change ui in game says added but purchase area shows blank receipt in database and coins dont updateLovatto wrote: ↑Sun May 17, 2020 9:51 am Thanks for the info, I found the problem, you have to edit the bl_Database.php script in your server with the following:
After this line:Add this:Code: Select all
$flist = safe($_POST['flist']);
Then after these lines:Code: Select all
$data = safe($_POST['data']);
add these:Code: Select all
$coins = stripslashes($coins); $coins = mysqli_real_escape_string($link, $coins);
Let me know if that work for you.Code: Select all
$data = stripslashes($data); $data = mysqli_real_escape_string($link, $data);