adding condition

[Leic]

		case 1:
			warp "turbo_room",100,100;
			break;

is there a query that if the character account's pin code is not set then he cannot warp on that room?

[Sehrentos]

Look for pincode in the login table.

query_sql("SELECT pincode FROM login WHERE account_id="+ getcharid(3) +";", .@pin);

if ( getarraysize( .@pin ) ) { /* Has pincode .@pin[0] */ }

 

Edited March 24, 2018 by Sehrentos

[Leic]

thanks. how about a script that will delete the current pin code if you entered the warp?

[Sehrentos]

18 hours ago, Leic said:

thanks. how about a script that will delete the current pin code if you entered the warp?

"UPDATE login SET pincode = '' WHERE account_id="+getcharid(3);