// Check if there's a clan with the same name already!
$sql = "SELECT name FROM ". CLANS_TABLE ." WHERE name = '".$name."' ";
if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error retrieving data', '', __LINE__, __FILE__, $sql); }
while ( $row = $db->sql_fetchrow($result) )
{
if(!empty($row['name']))
{
// Clan already exists!!
$message = sprintf($lang['clans_couldnt_create'], ''.$name.'').'
'.$lang['clans_same_name'].'
'.sprintf($lang['clans_click_here'], '','');
message_die(GENERAL_MESSAGE, $message);
}
}