How to change #KAFRAPOINTS to other variable?

[Feistz]

I dunno where to post this so please move if it in the wrong section. As the title says, is it possible to change all #KAFRAPOINTS value in my server to other variable such as #EVENTPOINTS. if yes, how can i do it? using script or mysql queries? thanks!

[Emistry]

set #EVENTPOINTS,#EVENTPOINTS + #KAFRAPOINTS;
set #KAFRAPOINTS,0;

[Feistz]

BUMP! How can I do that Emistry? Can give me more explanation or example?

[Emistry]

just add that in a npc script...

[Feistz]

How can i make if player login, it will automatically convert the points?

[Emistry]

OnPCLoginEvent:
...................<script>...................

[Feistz]

Thanks! but i got this error:-

[sql]: DB error - Duplicate entry '0-#EVENTPOINTS-2000000' for key 'PRIMARY'
[Debug]: at d:\rathena\src\char\inter.c:620 - INSERT INTO `global_reg_value` (`t
ype`,`account_id`,`char_id`,`str`,`value`) VALUES ('2','2000000','0','#GC_CAPTUR
ES','5'),('2','2000000','0','#eventpoints','10'),('2','2000000','0','#EVENTPOINT
S','10000')

And here is my script

- script converter -1,{
OnPCLoginEvent:
set #EVENTPOINTS,#EVENTPOINTS + #KAFRAPOINTS;
set #KAFRAPOINTS,0;
}

How to fix this?

[Emistry]

lol ? what's this....my script shouldnt caused this ...

are you using SQL ? or TXT ..?

are you sure that's the whole script ?

where did this come from ?

#GC_Captures ?

[Feistz]

Weird, now the error is gone, hmm i will do some test later on. Im using SQL. Yes, that is my whole script