Having Issue with a script

[Radian]

Hey guys, while I was checking a script i noticed that I cant exchange my points it keeps saying this part mes "You don't have enough points to exchange.";

This is the part of the script, I got 15 points from my mysql.

		if(select("Exchange my points into coins:Cancel")==2) close;
		if(!query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id` = "+getcharid(0)+"",@WA_POINTS))
			@WA_POINTS = 0;
		mes "[ ^04B4AEAvery^000000 ]";
		if(@WA_POINTS < $@WA_WP)
			mes "You don't have enough points to exchange.";
		else {
			mes "You currently have ^0000aa"+@WA_POINTS+"^000000 points. How much would you exchange?";
			input .@cb,$@WA_WP,@WA_POINTS;
			if(.@cb > @WA_POINTS) {
				mes "You want to exchange too much points.";
			} else {
				.@div = .@cb / $@WA_WP;
				getitem 32609,.@div;
				.@reste = .@cb - (.@cb % $@WA_WP);
				if((@WA_POINTS - .@reste) <= 0) {
					query_sql("DELETE FROM `wicked_ladder` WHERE `char_id` = '"+getcharid(0)+"'");
				} else {
					query_sql("UPDATE `wicked_ladder` SET `points` = '"+(@WA_POINTS - .@reste)+"' WHERE `char_id` = "+getcharid(0)+"");
				}
				mes "^00af00You got "+.@div+" Wicked Coin(s).^000000";
			}
		}

No map error at all.

[Radian]

Nevermind, I forgot that I need 500 WP to exchange. my bad please closed this. thanks!

[Skorm]

58 minutes ago, Radian said:

Hey guys, while I was checking a script i noticed that I cant exchange my points it keeps saying this part mes "You don't have enough points to exchange.";

This is the part of the script, I got 15 points from my mysql.

No map error at all.

At some point query_sql was changed to return -1 instead of zero when failing.

if(!query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id` = "+getcharid(0)+"",@WA_POINTS))

Should be

if(query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id` = "+getcharid(0)+"",@WA_POINTS) <= 0)

I can't say that will fix your problem for sure though. Make sure your database is correct.

[Radian]

10 minutes ago, Skorm said:

At some point query_sql was changed to return -1 instead of zero when failing.

if(!query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id` = "+getcharid(0)+"",@WA_POINTS))

Should be

if(query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id` = "+getcharid(0)+"",@WA_POINTS) <= 0)

I can't say that will fix your problem for sure though. Make sure your database is correct.

I'll run a test on your suggestion..

 

Edit -- 

I still got the same result, And as you mention i checked the database and it is correct. for the other npc it is working

at this part

	case 1:
		if(@WA_POINTS < 1 || !query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id`="+getcharid(0)+"",@WA_POINTS)) {
			mes "[ ^04B4AEArena Helper^000000 ]";
			mes "I required ^0000ff1WP^000000 for this service. Im sorry.";
		} else {			
			if((@WA_POINTS - 1) <= 0) {
				query_sql("DELETE FROM `wicked_ladder` WHERE `char_id` = '"+getcharid(0)+"'");
			} else {
				query_sql("UPDATE `wicked_ladder` SET `points` = '"+(@WA_POINTS - 1)+"' WHERE `char_id` = "+getcharid(0)+"");
			}
			skilleffect 28,2000;
			percentheal 100,100;
		}

 

Edited March 5, 2018 by Radian