<?php class NP_AssignItemAuthor extends NucleusPlugin { function getName() { return 'AssignItemAuthor'; } function getAuthor() { return 'Leah'; } function getURL() { return 'http://www.web-threads.com/'; } function getVersion() { return '0.1'; } function getDescription() { return 'Allows blog admins to assign another blog team author to an item.'; } function getMinNucleusVersion() { return 300; } function supportsFeature($what) { switch($what) { case 'SqlTablePrefix': return 1; case 'HelpPage': return 0; break; default: return 0; break; } } function getEventList() { return array('EditItemFormExtras','PreAddItem','AddItemFormExtras','PreUpdateItem'); } function event_EditItemFormExtras($data) { //Check that the member is a blog admin for displaying list options global $member; $bid = getBlogIDFromItemID($data['itemid']); if ($member->isBlogAdmin($bid)){ echo '<h3>Assign Another Author</h3><p /> <select name="author_set"> <option value="">No change</option>'; // get list of blog team members $query= sql_query('SELECT tmember, mname, mnumber FROM '.sql_table('team').', '.sql_table('member').' WHERE (tmember= mnumber AND tblog = '.$bid.') ORDER BY mname'); while ($result = mysql_fetch_array($query)) { echo '<option value="'.$result['tmember'].'">'.$result['mname'].'</option>'; } echo '</select>'; } } function event_AddItemFormExtras($data) { // Check member is blog admin for displaying list options global $member,$blogid; if ($member->isBlogAdmin($blogid)){ echo '<h3>Assign Another Author</h3><p /> <select name="author_set"> <option value="">No change</option>'; // get list of blog team members $query= sql_query('SELECT tmember, mname, mnumber FROM '.sql_table('team').', '.sql_table('member').' WHERE (tmember= mnumber AND tblog = '.$blogid.') ORDER BY mname'); while ($result = mysql_fetch_array($query)) { echo '<option value="'.$result['tmember'].'">'.$result['mname'].'</option>'; } echo '</select>'; } } function event_PreAddItem($data) { $assigned = requestVar('author_set'); if ($assigned) { $data['authorid'] = $assigned; } } function event_PreUpdateItem($data) { $assigned = requestVar('author_set'); if ($assigned) { $data['authorid'] = $assigned; $query = 'UPDATE '.sql_table('item').' SET iauthor ='.$assigned.' WHERE inumber = '.$data['itemid']; sql_query($query); } } } ?>