Chaning v4p point rewards to cashpoint

[Mang-Berto]

magandang araw po, papaano po ba palitan yung points na nakukuha sa v4p ni sir jaypee from points to cashpoints in game? maraming salamat po!

[Euro]

I haven't tested this code but here's it:

*Edit* Fixed Typo

prontera,x,y,n	 script	 V4P to Cash	 n,{
function updatePoints;
function getPoints;

set [email protected], getPoints(getcharid(3));
mes "You have"[email protected];
mes "Would you like to exchange them all?";
switch ( select ("Yes","No") ) {
case 1:
updatePoints(getcharid(3), [email protected]);
break;
case 2:
break;
}
close;

function updatePoints {
set [email protected]_id,getarg(0);
set [email protected],getarg(1);
query_sql("UPDATE `cp_v4p_voters` SET points=(points-"[email protected]+") WHERE account_id='"[email protected]_id+"'");
return;
}

function getPoints {
set [email protected]_id,getarg(0);
query_sql("SELECT `points` FROM `cp_v4p_voters` WHERE account_id="[email protected]_id+" LIMIT 1",[email protected]);
if(getarraysize([email protected])==0)
return 0;
return [email protected][0];
}
}

Edited August 22, 2012 by Euro

[Mang-Berto]

It's not working!

Edited August 23, 2012 by Mang-Berto