For and Query_SQL

[Dynasty]

hi

 

this is what i were doing for 2 days... i want to make a achievement system using sql and this is a command that the user might use for see the progress that they do

-	script	atcmd_example	-1,{
OnInit: bindatcmd "logro","Verlogro::OnCommand"; end;
}
 
prontera,111,222,3	script	Verlogro	123,{
OnCommand:
	setarray .@logros$[0],"","","","","","","","";
for( set .@i, 0; .@i < getarraysize(.@logros$); set .@i, .@i + 1 ){
set .@logrot$,"(query_sql "SELECT `"+ .@logros$[.@i]"` FROM logros WHERE `account_id` = "+ getcharid(3), .@logrot$[.@i];)";
	while (.@i <= getarraysize(.@logros$)) {
				dispbottom "----------------------------------------------------------------------";
				dispbottom "	 =============================================================";
				dispbottom "	 =							  Logros						=";
				dispbottom "	 =			 ("+.@logros$[.@i])+" : "+.@logrot$[.@i]+")     =";
				dispbottom "	 =============================================================";
				dispbottom "----------------------------------------------------------------------";
				set .@i,.@i+1;
			}
		}
	}
}

i want to make a multiple query to the sql and at the same time add to a array... it is right???

 

here is the sql that i make... for that...

CREATE TABLE IF NOT EXISTS `logros` (
  `Cuenta_ID` int(11) unsigned NOT NULL default '0',
  `Nombre_cuenta` varchar(255) NOT NULL default 'NULL',
  `Logros` varchar(255) NOT NULL default 'NULL',
  `Poring1` varchar(255) NOT NULL default 'NULL',
  `Poring2` varchar(255) NOT NULL default 'NULL',
  `Poring3` varchar(255) NOT NULL default 'NULL',
  `Poring4` varchar(255) NOT NULL default 'NULL',
  `Poring5` varchar(255) NOT NULL default 'NULL',
  `Poring6` varchar(255) NOT NULL default 'NULL',
  `Poring7` varchar(255) NOT NULL default 'NULL',
  `Poring8` varchar(255) NOT NULL default 'NULL',
  `Poring9` varchar(255) NOT NULL default 'NULL',
  `Poring10` varchar(255) NOT NULL default 'NULL',
  `Poring11` varchar(255) NOT NULL default 'NULL',
  `Poring12` varchar(255) NOT NULL default 'NULL',
  `Poring13` varchar(255) NOT NULL default 'NULL',
  `Poring14` varchar(255) NOT NULL default 'NULL',
  `Poring15` varchar(255) NOT NULL default 'NULL',
  `Poring16` varchar(255) NOT NULL default 'NULL',
  `Poring17` varchar(255) NOT NULL default 'NULL',
  `Poring18` varchar(255) NOT NULL default 'NULL',
  `Poring19` varchar(255) NOT NULL default 'NULL',
  `Poring20` varchar(255) NOT NULL default 'NULL',
  `Poring21` varchar(255) NOT NULL default 'NULL',
  `Poring22` varchar(255) NOT NULL default 'NULL',
  `Poring23` varchar(255) NOT NULL default 'NULL',
  `Poring24` varchar(255) NOT NULL default 'NULL',
  `Poring25` varchar(255) NOT NULL default 'NULL',
  PRIMARY KEY  (`Cuenta_ID`)
) ENGINE=MyISAM;

BUMB?

Edited November 11, 2013 by Dynasty