Auto Donation System

[ReSp]

Hello all.

Help me please with automatic donation system.

My website is on FluxCP, rAthena server.

Players must donation for example on paypal, and then get cash points at account in game.

[Balfear]

14 hours ago, ReSp said:

Hello all.

Help me please with automatic donation system.

My website is on FluxCP, rAthena server.

Players must donation for example on paypal, and then get cash points at account in game.

Hi, you can use this simple script:
 

//===== rAthena Script =======================================
//= Donate converter
//===== By: ==================================================
//= Balfear
//===== Last Updated: ========================================
//= 20171207
//===== Description: ========================================= 
//= Automatic convert player balance("cp_credits") to cashpoint in game when player login.
//============================================================
-	script	balance2cashpoint	-1,{
OnPCLoginEvent:
	query_sql("select balance from `cp_credits` WHERE account_id = " + getcharid(3) + "", .@balance);
	if (.@balance != 0) {
		query_sql ("UPDATE `cp_credits` SET balance = 0 WHERE account_id = " + getcharid(3) + "");
		set #CASHPOINTS,(#CASHPOINTS + .@balance);
		announce "Gain cash point: "+.@balance+"",bc_self, 0xADFFC5, FW_BOLD;
	}
	end;
}

 

[Foob]

On 12/7/2017 at 1:32 PM, ReSp said:

Hello all.

Help me please with automatic donation system.

My website is on FluxCP, rAthena server.

Players must donation for example on paypal, and then get cash points at account in game.

Flux CP has built in NPC that can let you get proof of donation. And create a script for it so that you can exchange PODs to CASH or what #2 post says.

[CyberDevil]

On 12/7/2017 at 9:33 PM, Balfear said:

Hi, you can use this simple script:
 

//===== rAthena Script =======================================
//= Donate converter
//===== By: ==================================================
//= Balfear
//===== Last Updated: ========================================
//= 20171207
//===== Description: ========================================= 
//= Automatic convert player balance("cp_credits") to cashpoint in game when player login.
//============================================================
-	script	balance2cashpoint	-1,{
OnPCLoginEvent:
	query_sql("select balance from `cp_credits` WHERE account_id = " + getcharid(3) + "", .@balance);
	if (.@balance != 0) {
		query_sql ("UPDATE `cp_credits` SET balance = 0 WHERE account_id = " + getcharid(3) + "");
		set #CASHPOINTS,(#CASHPOINTS + .@balance);
		announce "Gain cash point: "+.@balance+"",bc_self, 0xADFFC5, FW_BOLD;
	}
	end;
}

  

I have this error (sorry I'm not a coder ^^):

Quote

[Error]: npc_parsesrcfile: Unknown syntax in file 'npc/custom/auto_donation_converter.txt', line '19'. Stopping...
 * w1=
 * w2=
 * w3=
 * w4=
 

EDIT: I have found the problem... after the last "}" there is an invisible ascii character! XD... Mistery of "copy & paste"!!!!

Edited June 27, 2018 by CyberDevil
corrected