Lines Matching refs:sql
388 …$sql = "select a.entity_id entity, a.value hash from customer_entity_varchar a where a.attribute_i…
390 foreach( $dbh->query( $sql ) as $row ) {
442 $sql = "select user_id entity,password hash from admin_user where user_id = {$entity};";
444 foreach( $dbh->query( $sql ) as $row ) {
508 …$sql = "select a.entity_id entity,a.value first,b.value last from customer_entity_varchar a,custom…
509 foreach( $dbh->query( $sql ) as $row ) {
538 …$sql = "select a.entity_id entity,a.email mail from customer_entity a where a.entity_id = {$entity…
539 foreach( $dbh->query( $sql ) as $row ) {
570 …$sql = "select a.entity_id entity,b.customer_group_code groups from customer_entity a, customer_gr…
571 foreach( $dbh->query( $sql ) as $row ) {
603 …$sql = "select user_id entity,firstname first,lastname last, username user,email mail from admin_u…
604 foreach( $dbh->query( $sql ) as $row ) {
640 …$sql = "select role_id id,role_type type,parent_id parent,tree_level level from admin_role where u…
641 foreach( $dbh->query( $sql ) as $row ) {
658 …$sql = "select role_id id,role_type type,parent_id parent,tree_level level from admin_role where r…
659 foreach( $dbh->query( $sql ) as $row ) {
691 … $sql = "select role_id id,role_name name from admin_role where role_type = 'G' order by role_id;";
692 foreach( $dbh->query( $sql ) as $row ) {