Purchase History using Donation Points

01/06/2015 05:52 [GM]Precious#1
Hi All,

Anyone knows where to find this?

If it is not by default available, is there anyone who have created this before?

Thanks,
Precious
01/06/2015 12:44 wallerus#2
If you mean In-game Item Mall purchase log, you can find it here:

Code:
[PS_GameData].[dbo].[PointLog]
I just wrote this for you to use;

Code:
SELECT
		C.CharID,
		C.CharName,
		PtL.UsePoint AS PointCost,
		PtL.ProductCode,
		PtL.TargetName,
		PL.ProductName,
		PtL.UseDate

FROM		[PS_GameData].[dbo].[PointLog] as PtL
inner join	[PS_GameDefs].[dbo].[ProductList] as PL on PtL.ProductCode=PL.ProductCode
inner join	[PS_GameDefs].[dbo].[Items] AS I on PL.ItemID1=I.ItemID
inner join	[PS_GameData].[dbo].[Chars] AS C on C.CharID=PtL.CharID
Here's an example of what you'll see: [Only registered and activated users can see links. Click Here To Register...]
You can add more columns to see what's inside the package etc, hope it helps!
01/06/2015 21:37 [GM]Precious#3
Great! :)

I didn't see that "PointLog", maybe because I do not know what was that for.

Thanks a bunch! This will help me alot!

Regards,
Precious