load("profilefields");
addacpnav($lang->nav_profile_fields, "profilefields.php");
switch($mybb->input['action'])
{
case "add":
addacpnav($lang->nav_add_field);
break;
case "delete":
addacpnav($lang->nav_delete_field);
break;
case "edit":
addacpnav($lang->nav_edit_field);
break;
}
checkadminpermissions("caneditpfields");
logadmin();
if($mybb->input['action'] == "do_add")
{
$type = $mybb->input['type'];
if($type != "text" && $type != "textarea")
{
$thing = "$type\n$options";
}
else
{
$thing = $type;
}
$sqlarray = array(
"name" => addslashes($mybb->input['name']),
"description" => addslashes($mybb->input['description']),
"disporder" => intval($mybb->input['disporder']),
"type" => addslashes($thing),
"length" => intval($mybb->input['length']),
"maxlength" => intval($mybb->input['maxlength']),
"required" => addslashes($mybb->input['required']),
"editable" => addslashes($mybb->input['editable']),
"hidden" => addslashes($mybb->input['hidden']),
);
$db->insert_query(TABLE_PREFIX."profilefields", $sqlarray);
$fid = $db->insert_id();
$fieldname = "fid$fid";
$db->query("ALTER TABLE ".TABLE_PREFIX."userfields ADD $fieldname TEXT;");
$db->query("OPTIMIZE TABLE ".TABLE_PREFIX."userfields");
cpredirect("profilefields.php", $lang->field_added);
}
if($mybb->input['action'] == "do_delete")
{
if($mybb->input['deletesubmit'])
{
$fid = intval($mybb->input['fid']);
$db->query("DELETE FROM ".TABLE_PREFIX."profilefields WHERE fid='$fid'");
$fieldname = "fid$fid";
$db->query("ALTER TABLE ".TABLE_PREFIX."userfields DROP $fieldname");
$db->query("OPTIMIZE TABLE ".TABLE_PREFIX."userfields");
cpredirect("profilefields.php", $lang->field_deleted);
}
else
{
$mybb->input['action'] = "modify";
}
}
if($mybb->input['action'] == "do_edit")
{
$type = $mybb->input['type'];
if($type != "text" && $type != "textarea")
{
$thing = "$type\n$options";
}
else
{
$thing = $type;
}
$sqlarray = array(
"name" => addslashes($mybb->input['name']),
"description" => addslashes($mybb->input['description']),
"disporder" => intval($mybb->input['disporder']),
"type" => addslashes($thing),
"length" => intval($mybb->input['length']),
"maxlength" => intval($mybb->input['maxlength']),
"required" => addslashes($mybb->input['required']),
"editable" => addslashes($mybb->input['editable']),
"hidden" => addslashes($mybb->input['hidden']),
);
$db->update_query(TABLE_PREFIX."profilefields", $sqlarray, "fid='".intval($mybb->input['fid'])."'");
cpredirect("profilefields.php", $lang->field_updated);
}
if($mybb->input['action'] == "add")
{
cpheader();
startform("profilefields.php", "" , "do_add");
starttable();
tableheader($lang->new_custom_field);
makeinputcode($lang->field_name, "name");
maketextareacode($lang->field_description, "description");
makeinputcode($lang->field_max_length, "maxlength");
makeinputcode($lang->field_length, "length", 20);
makeinputcode($lang->field_disporder, "disporder", "", 4);
makelabelcode($lang->field_type, "");
maketextareacode($lang->field_options, "options", "", 6, 50);
makeyesnocode($lang->field_required, "required", "no");
makeyesnocode($lang->field_editable, "editable", "yes");
makeyesnocode($lang->field_hidden, "hidden", "no");
endtable();
endform($lang->add_field, $lang->reset_button);
cpfooter();
}
if($mybb->input['action'] == "delete")
{
$fid = intval($mybb->input['fid']);
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE fid='$fid'");
$profilefield = $db->fetch_array($query);
cpheader();
startform("profilefields.php", "", "do_delete");
makehiddencode("fid", $fid);
starttable();
$lang->delete_field = sprintf($lang->delete_field, $profilefield['name']);
tableheader($lang->delete_field, "", 1);
$yes = makebuttoncode("deletesubmit", $lang->yes);
$no = makebuttoncode("no", $lang->no);
$lang->delete_confirm = sprintf($lang->delete_confirm, $profilefield['name']);
makelabelcode("$lang->delete_confirm
$yes$no", "");
endtable();
endform();
cpfooter();
}
if($mybb->input['action'] == "edit")
{
$fid = intval($mybb->input['fid']);
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."profilefields WHERE fid='$fid'");
$profilefield = $db->fetch_array($query);
$profilefield['name'] = stripslashes($profilefield['name']);
$profilefield['description'] = stripslashes($profilefield['description']);
$profilefield['type'] = stripslashes($profilefield['type']);
$type = explode("\n", $profilefield['type'], "2");
$typesel[$type[0]] = "selected";
$options = $type[1];
cpheader();
startform("profilefields.php", "" , "do_edit");
makehiddencode("fid", $profilefield['fid']);
starttable();
$lang->edit_custom_field = sprintf($lang->edit_custom_field, $profilefield['name']);
tableheader($lang->edit_custom_field);
makeinputcode($lang->field_name, "name", "$profilefield[name]");
maketextareacode($lang->field_description, "description", $profilefield['description']);
makeinputcode($lang->field_max_length, "maxlength", $profilefield['maxlength']);
makeinputcode($lang->field_length, "length", $profilefield['length']);
makeinputcode($lang->field_disporder, "disporder", $profilefield['disporder'], 4);
makelabelcode($lang->field_type, "");
maketextareacode($lang->field_options, "options", $options, 6, 50);
makeyesnocode($lang->field_required, "required", $profilefield['required']);
makeyesnocode($lang->field_editable, "editable", $profilefield['editable']);
makeyesnocode($lang->field_hidden, "hidden", $profilefield['hidden']);
endtable();
endform($lang->edit_field, $lang->reset_button);
cpfooter();
}
if($mybb->input['action'] == "modify" || $mybb->input['action'] == "")
{
if(!$noheader)
{
cpheader();
}
$hopto[] = "create_profilefield\" onclick=\"hopto('profilefields.php?action=add');\" class=\"hoptobutton\">";
makehoptolinks($hopto);
starttable();
tableheader($lang->profile_fields, "", "6");
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."profilefields ORDER BY disporder");
while($profilefield = $db->fetch_array($query))
{
$bgcolor = getaltbg();
startform("profilefields.php");
makehiddencode("fid", $profilefield['fid']);
$profilefield['required'] = ($profilefield['required'] == "yes") ? $lang->yes : $lang->no;
$profilefield['editable'] = ($profilefield['editable'] == "yes") ? $lang->yes : $lang->no;
$profilefield['hidden'] = ($profilefield['hidden'] == "yes") ? $lang->yes : $lang->no;
echo "\n";
echo "| $profilefield[name] | \n";
echo "$profilefield[fid] | \n";
echo "$profilefield[required] | \n";
echo "$profilefield[editable] | \n";
echo "$profilefield[hidden] | \n";
echo " go\"> | \n";
echo "
\n";
endform();
}
endtable();
cpfooter();
}
?>