[HELP] V4P issue.

[ted.lodestone 0]

I can't see the vote I made from the site.. Thus some of the scripts also changed since im using the old script that i had in 3cream.

 

Please help thank you!

 

 

 helloworld,0,0,4    script    Vote For Vote    570,{    setarray @vote_item[0],		   30135, 30136, 30137, 30138, 30139, 30140, 30141;  // Item ID    setarray @vote_item_count[0],    1, 1, 1, 1, 1, 1, 1; // Item Count wich will be given    setarray @vote_cost[0],		    780, 780, 780, 780, 780, 780, 780; // Cost in Vote Points    set @min_vote, 0; // minimum count on Vote Points to see the Item List    set @npcname$,"[^ff0000Vote For Legendary Set^000000]";    query_sql ("SELECT `points` FROM `voting_points` WHERE `account_id` = ('"+getcharid(3)+"')", @vote);    mes @npcname$;    mes "You have ^ff0000"+@vote+"^000000 Vote Points!";    if( @vote < @min_vote ) {	    mes "^ff0000You will need "+@min_vote+" or more Vote Points to trade them with me!^000000";	    close;    }    if (select("Trade my Points!","Cancel~") == 2)	    close;    next;    mes "[^ff0000List^000000]";    mes "^0000ffItem^000000 = ^00aa00Cost^000000";    for( set .@i, 0; .@i < getarraysize(@vote_item); set .@i, .@i + 1 ) {	    mes "^0000ff"+@vote_item_count[.@i]+"x "+getitemname(@vote_item[.@i])+"^000000 = ^00aa00"+@vote_cost[.@i]+"^000000";	    if( .@i < 1 )		    set .@menu$, getitemname(@vote_item[.@i]);	    else		    set .@menu$, .@menu$+":"+getitemname(@vote_item[.@i]);    }    next;    select(.@menu$);    set @choice, @menu - 1;    mes @npcname$;    if( @vote_cost[@choice] > @vote ) {	    mes "^ff0000You dont have enought Vote Point for "+@vote_item_count[@choice]+"x '"+getitemname(@vote_item[@choice])+"' :/^000000";	    close;    }    mes "Are u realy sure to trade "+@vote_item_count[@choice]+"x '^ff0000"+getitemname(@vote_item[@choice])+"^000000' for ^00aa00"+@vote_cost[@choice]+"^000000 Vote Points?";    if(select("No! Cancel!:Yes, Trade me!") == 1 ) {	    mes "^ff0000Trade was canceled~^000000";	    close;    }    set .@new, @vote - @vote_cost[@choice];    if( .@new < 0 ) // safty first..	    set .@new, 0;    query_sql("UPDATE `voting_points` SET `points` = '"+.@new+"' WHERE `account_id` = ('"+getcharid(3)+"')");    getitem @vote_item[@choice], @vote_item_count[@choice];    mes "^00aa00Trade was Successfull  Hope to see u again =)!^000000";    close;} 

 

[GodLesZ 1]

This is like running to your service station saying "my car wont start".

• Any mysql error in your map-server console?
• How are the new vote points saved? Each vote a new table record or just a single record per account_id?
• May you attach the voting PHP script too?
  

Edited September 5, 2013 by GodLesZ