Transaction History

xdfelgen · 2021-08-13T23:12:47.855Z

Okay. So i have tried everything under the sun about this but i just don’t know what to do.

Alright well so i got a banking script and i’ve added transaction history to it, so you can see what you have spent but also what you have received in transfers from other players.

Anyways so basically whenever i do the query to get all the transactions I do it like so:

SELECT id, sender, target, label, amount, iden, type, date FROM account_recent WHERE identifier = @identifier

But this will only select results if you have sent a payment, not received one.

So now i ask how/and what would be the best way to counter this?

Thanks for reading. Regards.

xdfelgen · 2021-08-14T21:05:09.448Z

Guess no one is good at SQL.

XenoS.exe · 2021-08-14T21:38:12.734Z

if you are using a table similar to billing then identifier is who received the invoice and sender is who sent it

xdfelgen · 2021-08-15T00:20:38.443Z

I fixed it. I made it so when a transfer is made it creates 2 rows. 1 with sent identifier so the one who sent can see, and that one is negative for him. And another row for the receiver that has POS and their identifier !