sql query that counts/checks how many key are already inserted

[iZeal]

Hello Guys, I'm trying to modify a script for max level reward

but I'm stuck on sql query.

regarding checking if how many key entry are already inside acc_reg_num_db

like for example it will check if there is already 50 entry of #99reward

 

 

 

Thanks in advance.

[Euphy]

SQL has a 'COUNT()' function: http://www.w3schools.com/sql/sql_func_count.asp

Though I suggest you just keep a global variable instead (and sync it with SQL if necessary once when the server starts), since there's no point running the query repeatedly--that'd be much slower than checking a global.

[iZeal]

I'm doing this for my race to lvl 99 reward because it's only for 1 claim per account., and it's only meant for 100 players else if 100 players already claimed the npc will hide. that's why I'm using #99reward because I restrict for account.

[Euphy]

So use a global variable ($var) to keep track of how many players have gotten the reward, i.e. increment it every time you give one. Much simpler than counting database entries.

[iZeal]

if i use that maybe it will not be 1 per account.?

[Cydh]

if i use that maybe it will not be 1 per account.?

 

$ <- global var

# <- account var

[Capuche]

sth like this

	if ( #reward_account ) {
		mes "already claimed";
		close;
	}
	getitem ...
	$total_claimed++;
	if ( $total_claimed > 100 ) disablenpc