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 .@points, getPoints(getcharid(3));
mes "You have"+.@points;
mes "Would you like to exchange them all?";
switch ( select ("Yes","No") ) {
case 1:
updatePoints(getcharid(3), .@points);
break;
case 2:
break;
}
close;
function updatePoints {
set .@account_id,getarg(0);
set .@usedPoints,getarg(1);
query_sql("UPDATE `cp_v4p_voters` SET points=(points-"+.@usedPoints+") WHERE account_id='"+.@account_id+"'");
return;
}
function getPoints {
set .@account_id,getarg(0);
query_sql("SELECT `points` FROM `cp_v4p_voters` WHERE account_id="+.@account_id+" LIMIT 1",.@points);
if(getarraysize(.@points)==0)
return 0;
return .@points[0];
}
}