what i am getting in the settings table is the above quoted 'select'. the settings and setting group are all being inserted. however, when i go to change the settings for the plugin, the dropdown does not show, but the setting name/row is present. in the html source, there is zero code where the <option select> should be.
here is the plugin code so far. i still need to add in the 'refresh groups' feature which will basically rebuild the dropdown i am having trouble with.
this entire app is not complete. this plug-in file is almost done, but the IPN processing has not been started yet.
<?php
// Premium Mmebership Plugin
// By [email protected]
// Version 1.0
// This plugin (C) [email protected] 2006. You may not redistribute this plugin without the permission from [email protected].
function premium_member_info()
{
return array(
'name' => 'Premium Membership',
'description' => 'Add premium membership for users. For MyBB 1.2.x',
'website' => 'http://www.pavementsucks.com',
'author' => 'JasonB',
'authorsite' => 'http://www.pavementsucks.com',
'version' => '1.0',
);
}
function premium_member_activate()
{
global $db;
$info = premium_member_info();
$result = $db->query('SELECT * FROM '.TABLE_PREFIX.'usergroups ORDER BY gid');
$group_options = 'select';
while ($row = $db->fetch_array($result))
{
$group_options .= '\r\n'.$row['gid'].'='.str_replace(' /', '', $row['title']);
}
$setting_group_array = array(
'name' => str_replace(' ', '_', 'jasonb_'.strtolower($info['name'])),
'title' => $info[name].' (JasonB)',
'description' => 'Settings for the '.$info[name].' plugin',
'disporder' => 1,
'isdefault' => 'no',
);
$db->insert_query(TABLE_PREFIX.'settinggroups', $setting_group_array);
$gid = $db->insert_id();
$premium_member_setting_1 = array(
'sid' => NULL,
'name' => 'premium_member_switch',
'title' => 'Premium Member Switch',
'description' => 'This turns on or off this plugin for the whole board.',
'optionscode' => 'onoff',
'value' => 'on',
'disporder' => '1',
'gid' => intval($gid),
);
$premium_member_setting_2 = array(
'sid' => NULL,
'name' => 'premium_member_moveinto',
'title' => 'Premium Group',
'description' => 'Group to move Premium Members into (if you edit groups, you must run the Update Groups options).',
'optionscode' => $group_options,
'value' => '2',
'disporder' => '2',
'gid' => intval($gid),
);
$premium_member_setting_3 = array(
'sid' => NULL,
'name' => 'premium_member_term',
'title' => 'Premium Member Term',
'description' => 'Legnth is the Premium Membership term (how long until it expires).',
'optionscode' => 'select
86400=1 Day
604800=7 Days
2592000=1 Month
5184000=2 Months
15552000=6 Months
31536000=1 Year
63072000=2 Years
94608000=3 Years',
'value' => '31536000',
'disporder' => '3',
'gid' => intval($gid),
);
$db->insert_query(TABLE_PREFIX.'settings', $premium_member_setting_1);
$db->insert_query(TABLE_PREFIX.'settings', $premium_member_setting_2);
$db->insert_query(TABLE_PREFIX.'settings', $premium_member_setting_3);
$db->query('ALTER TABLE '.TABLE_PREFIX.'users ADD prem_expire INT( 10 ) NOT NULL');
rebuildsettings();
}
function premium_member_deactivate()
{
global $db;
$info = premium_member_info();
$result = $db->query('SELECT gid FROM '.TABLE_PREFIX.'settinggroups WHERE name = "'.str_replace(' ', '_', 'jasonb_'.strtolower($info['name'])).'" LIMIT 1');
$group = $db->fetch_array($result);
if(!empty($group['gid']))
{
$db->query('DELETE FROM '.TABLE_PREFIX.'settinggroups WHERE gid = '.$group[gid].' LIMIT 1');
$db->query('DELETE FROM '.TABLE_PREFIX.'settings WHERE gid = '.$group[gid]);
rebuildsettings();
$db->query('ALTER TABLE '.TABLE_PREFIX.'users DROP prem_expire');
}
}
$plugins->add_hook('global_end', 'premium_member_run');
function premium_member_run()
{
global $mybb;
$rand = mt_rand(0, 10);
if ($rand > 8 && $mybb->settings['premium_member_switch'] == 'on')
{
premium_member_expire();
}
}
function premium_member_expire()
{
global $mybb, $db, $cache;
//get setting params
$settings = $mybb->settings;
$premium_group = $settings['premium_member_moveinto'];
// Expire Users
$expire_time = time();
$query = $db->query('
SELECT u.uid, u.additionalgroups, u.displaygroup
FROM '.TABLE_PREFIX.'users u
LEFT JOIN '.TABLE_PREFIX.'usergroups ug ON (u.usergroup = ug.gid)
WHERE
u.prem_expire > 0
AND u.prem_expire < '.$expire_time.'
AND ug.cancp != "yes"
');
while ($row = $db->fetch_array($query))
{
$existing_addgroups = explode(',', $row['additionalgroups']);
$new_addgroups = premium_member_remove_premium_group($existing_addgroups, $premium_group);
$db->query('UPDATE '.TABLE_PREFIX.'users SET prem_expire=0, additionalgroups="'.implode(',', $new_addgroups).'", displaygroup="'.$new_addgroups[0].'" WHERE uid ='.$row['uid']);
}
}
function premium_member_remove_premium_group($group_array, $group_remove)
{
$thisarray = array ();
foreach($group_array as $value)
if($value != $group_remove)
$thisarray[] = $value;
return $thisarray;
}
?>
