All pastes #126278 Raw Edit

naderman

public php v1 · immutable
·published 2006-08-11 09:26 UTC
rendered paste body
<?php		$sql_not_in = array();		foreach ($cp_data as $key => $null)		{			if (strncmp($key, '_', 1) === 0)			{				$sql_not_in[] = "'" . $db->sql_escape(substr($key, 1)) . "'";			}			else			{				$sql_not_in[] = "'" . $db->sql_escape($key) . "'";			}		}		$sql = 'SELECT f.field_type, f.field_ident, f.field_default_value, l.lang_default_value			FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f 			WHERE l.lang_id = ' . $user->get_iso_lang_id() . ' 				' . ((sizeof($sql_not_in)) ? ' AND f.field_ident NOT IN (' . implode(', ', $sql_not_in) . ')' : '') . '				AND l.field_id = f.field_id';		$result = $db->sql_query($sql);?><?php		$sql_not_in = array();		foreach ($cp_data as $key => $null)		{			if (strncmp($key, '_', 1) === 0)			{				$sql_not_in[] = substr($key, 1);			}			else			{				$sql_not_in[] = $key;			}		}		$sql = 'SELECT f.field_type, f.field_ident, f.field_default_value, l.lang_default_value			FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f 			WHERE l.lang_id = ' . $user->get_iso_lang_id() . ' 				' . ((sizeof($sql_not_in)) ? ' AND ' . $db->sql_in_set('f.field_ident', $sql_not_in, true) : '') . '				AND l.field_id = f.field_id';		$result = $db->sql_query($sql);?>