Requesting for V4points Dynamic NPC Shop

[agentbogz]

Hello Guys, Do you have any scripts there? Vote for points dynamic npc shop,

so i can view,test preview the item.

i'm using Sir Jaypee's V4points Script.

Thanks to you all =)

[Euphy]

- <tab> script <tab> VotePointConvert <tab> -1,{
OnPCLoginEvent:
   query_sql("SELECT `points` FROM `cp_v4p_voters` WHERE account_id="+getcharid(3)+" LIMIT 1",.@points);
   if (!.@points) end;
   query_sql("UPDATE `cp_v4p_voters` SET points=(points-"+.@points+") WHERE account_id='"+getcharid(3)+"'");
   set #VOTEPOINTS, #VOTEPOINTS+.@points;
   dispbottom "Vote Points updated! Total: "+#VOTEPOINTS;
   end;
}

Then use my quest shop with the following configuration:

setarray .Points$[0],"#VOTEPOINTS","Vote Points";

[agentbogz]

Oops.. Thanks a Lot Sir Euphy all scripts are now working.. BIG THANKS =)

Edited July 5, 2012 by agentbogz

[dave23]

sir can you give me the full script of this?

[Emistry]

check Euphy topic in Script Release section if you are looking for his script

[mrlongshen]

- <tab> script <tab> VotePointConvert <tab> -1,{
OnPCLoginEvent:
    query_sql("SELECT `points` FROM `cp_v4p_voters` WHERE account_id="+getcharid(3)+" LIMIT 1",.@points);
    if (!.@points) end;
    query_sql("UPDATE `cp_v4p_voters` SET points=(points-"+.@points+") WHERE account_id='"+getcharid(3)+"'");
    set #VOTEPOINTS, #VOTEPOINTS+.@points;
    dispbottom "Vote Points updated! Total: "+#VOTEPOINTS;
    end;
}

Then use my quest shop with the following configuration:

setarray .Points$[0],"#VOTEPOINTS","Vote Points";

 

sir i make new txt file for the VotePointConvert. what is the function ?  i dont see any my vote for point there.

[darking123]

thank you for this

[pr3p]

- <tab> script <tab> VotePointConvert <tab> -1,{
OnPCLoginEvent:
    query_sql("SELECT `points` FROM `cp_v4p_voters` WHERE account_id="+getcharid(3)+" LIMIT 1",.@points);
    if (!.@points) end;
    query_sql("UPDATE `cp_v4p_voters` SET points=(points-"+.@points+") WHERE account_id='"+getcharid(3)+"'");
    set #VOTEPOINTS, #VOTEPOINTS+.@points;
    dispbottom "Vote Points updated! Total: "+#VOTEPOINTS;
    end;
}

Then use my quest shop with the following configuration:

setarray .Points$[0],"#VOTEPOINTS","Vote Points";

The votepointconverter is a separate npc?

[agentbogz]

Yup!

[Sensei334]

any have the npc? edited? with euphy sql fix?