Example #1
0
 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;
 }