add query_sql

[Zikoziz]

Hi,

I need help implementing query_sql to write the security keys. So you can have a backup if at some point they forget the pass

 

Hola,

Necesito ayuda para implementar una query que me guarde las claves de seguridad, por si algun momento algun user se le olvida tener la tabla con su clave =D

-	script	SecuritySystem	-1,{
	end;

OnSettings:
	while( 1 )
	{
		mes "[^FFA500Security System^000000]";
		mes "Estado Actual";

		mes "- Clave de Seguridad:";
		if( #SECURITYCODE )
		{
			mes "^FFFFFF__________^2E8B57Activada^000000.";

			mes "- Salidas de Items:";
			if( getsecurity() )
			{
				mes "^FFFFFF__________^2E8B57Bloqueadas^000000.";
				set .@Menu2$, "Permitir Salidas";
			}
			else
			{
				mes "^FFFFFF__________^FF0000Permitidas^000000.";
				set .@Menu2$, "Bloquear Salidas";
			}

			next;
			set .@Option, select("Cambiar Clave",.@Menu2$,"Quitar Clave","Salir");
		}
		else
		{
			mes "^FFFFFF__________^FF0000Inactiva^000000.";
			next;
			set .@Option, select("Establecer Clave","Salir") + 4;
		}
		
		switch( .@Option )
		{
			case 1: // Cambiar Clave
				mes "[^FFA500Security System^000000]";
				mes "La clave debe ser un número de 4 digitos entre 1000 y 9999";
				mes "Ingrese su Clave Actual...";
				next;

				input .@Pass;
				if( .@Pass != #SECURITYCODE )
				{
					mes "[^FFA500Security System^000000]";
					mes "Clave actual incorrecta!!.";
					close;
				}
			
			case 5:
				mes "[^FFA500Security System^000000]";
				mes "Ingrese la nueva Clave (Número entre 1000 y 9999)";
				next;
				
				input .@Pass;
				if( .@Pass < 1000 || .@Pass > 9999 )
				{
					mes "[^FFA500Security System^000000]";
					mes "Valor incorrecto de Pin!!.";
					close;
				}
				
				mes "[^FFA500Security System^000000]";
				mes "Repita la nueva clave para confirmar.";
				next;

				input .@CPass;
				if( .@CPass != .@Pass )
				{
					mes "[^FFA500Security System^000000]";
					mes "Las Claves no Concuerdan.";
					close;
				}
				
				set #SECURITYCODE, .@Pass;
				break;
			case 2: // Permitir Salidas - Bloquear Salidas
				if( getsecurity() )
				{
					mes "[^FFA500Security System^000000]";
					mes "Ingrese su número de Pin o Clave para permitir la salida de items.";
					next;
					
					input .@Pass;
					if( #SECURITYCODE != .@Pass )
					{
						mes "[^FFA500Security System^000000]";
						mes "Clave incorrecta!!.";
						close;
					}
					
					setsecurity 0;
				}
				else if( #SECURITYCODE > 0 )
					setsecurity 1;
				else
					setsecurity 0;
				break;
			case 3: // Quitar Clave
				mes "[^FFA500Security System^000000]";
				mes "Ingrese su número de Pin o Clave para continuar.";
				next;
				
				input .@Pass;
				if( #SECURITYCODE != .@Pass )
				{
					mes "[^FFA500Security System^000000]";
					mes "Clave incorrecta!!.";
					close;
				}
				
				set #SECURITYCODE, 0;
				setsecurity 0;
				break;
			case 4:
			case 6:
				mes "[^FFA500Security System^000000]";
				mes "Puedes regresar al sistema de Seguridad con @security.";
				mes "Buen día...";
				close;
		}
	}
	
	end;
}

 

Edited December 8, 2016 by Zikoziz

[Emistry]

query_sql( "SELECT `value` FROM `acc_reg_num` WHERE `account_id` = "+getcharid(3)+" AND `key` LIKE '#SECURITYCODE'",.@value );
mes "Your security code = "+.@value;

or you can just use this

mes "Your security code = "+#SECURITYCODE;

 

[Zikoziz]

I dont like xD

can you tell me where to add the query_sql line?
and how would my table =D

 

14 hours ago, Emistry said:

query_sql( "SELECT `value` FROM `acc_reg_num` WHERE `account_id` = "+getcharid(3)+" AND `key` LIKE '#SECURITYCODE'",.@value );
mes "Your security code = "+.@value;

or you can just use this

mes "Your security code = "+#SECURITYCODE;

 

I dont like xD

can you tell me where to add the query_sql line?
and how would my table =D

[Emistry]

the variable value are already stored in the acc_reg_num table, I dont see there is a need to create a new table for it.