get_lang('hostlist'); $tablename = Database::get_main_table('vchamilo'); $sql = " SELECT sitename, root_web FROM $tablename WHERE visible = 1 "; if ($VCHAMILO == '%'){ $result = Database::query($sql); $_template['hosts'] = array(); if ($result){ while($vchamilo = Database::fetch_assoc($result)){ $_template['hosts'][] = $vchamilo; } } } else { }