public static function loadFromID($id) { $obj = new self(); $record = ASDCLoader::instance()->query("SELECT * FROM `tbl_members_email_templates` WHERE `id` = {$id} LIMIT 1")->current(); $obj->id = $record->id; $obj->subject = $record->subject; $obj->body = $record->body; $obj->type = $record->type; $roles = ASDCLoader::instance()->query("SELECT et.role_id\r\n\t\t\t\tFROM `tbl_members_email_templates_role_mapping` AS `et`\r\n\t\t\t\tWHERE et.email_template_id = {$record->id}"); if ($roles->length() > 0) { foreach ($roles as $r) { $obj->addRole($r->role_id); } } return $obj; }