Purchase History using Donation Points

[[GM]Precious]

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

[wallerus]

If you mean In-game Item Mall purchase log, you can find it here:

[PS_GameData].[dbo].[PointLog]

I just wrote this for you to use;

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:
You can add more columns to see what's inside the package etc, hope it helps!

[[GM]Precious]

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