npc checks your credits (flux cp table)

[Alexandria 53]

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 12]

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 53]

Thank you, I will test it