npc checks your credits (flux cp table)

[Alexandria]

Hello there,

Is there a way to show in a npc how many donation credits do you have without going to the website? (flux cp)

Thank you

 

[Tranquility]

Think it could be something like:

set .redeemTable$,"cp_credits";query_sql("SELECT `balance` FROM `" + escape_sql(.redeemTable$) + "` WHERE `account_id` = " + getcharid(3) + " LIMIT 0,30", .@credits);mes "You have "+ .@credits + " donation credits";

 

[Alexandria]

Thank you, I will test it