### Eclipse Workspace Patch 1.0 #P leow_drupal6 Index: web/sites/all/modules/quota_by_role/quota_by_role.module =================================================================== --- web/sites/all/modules/quota_by_role/quota_by_role.module (revision 126) +++ web/sites/all/modules/quota_by_role/quota_by_role.module (working copy) @@ -498,7 +498,7 @@ //We check the quota of the user // We are going to cycle through all of the quota's, and see if there is a matching role in the user's role table - $sql_result_object = db_query("SELECT q.*, l.*, r.name FROM {quota_by_role_rules} q, {quota_by_role_limit_submissions} l, {role} r WHERE q.rid = r.rid AND q.qid = l.qid GROUP BY q.qid ORDER by q.weight ASC"); + $sql_result_object = db_query("SELECT q.*, l.*, r.name, nt.name as nice_content_type FROM {quota_by_role_rules} q, {quota_by_role_limit_submissions} l, {node_type} nt, {role} r WHERE q.rid = r.rid AND q.qid = l.qid AND nt.type = l.content_type GROUP BY q.qid ORDER by q.weight ASC"); while(($r = db_fetch_object($sql_result_object))) { // is this user even in the role given? @@ -535,9 +535,9 @@ } if ($per == t('forever')) - $output .= '