} if ($_REQUEST['do'] == 'doadd') { $vbulletin->input->clean_array_gpc('p', array('suggestid' => TYPE_UINT, 'photoplog_category' => TYPE_ARRAY)); $photoplog_suggestid = $vbulletin->GPC['suggestid']; $photoplog_category = $vbulletin->GPC['photoplog_category']; $photoplog_category_title = trim(strval($photoplog_category['title'])); $photoplog_category_description = trim(strval($photoplog_category['description'])); $photoplog_category_displayorder = intval(trim(strval($photoplog_category['displayorder']))); $photoplog_category_parentid = intval(trim(strval($photoplog_category['parentid']))); $photoplog_category_options = $photoplog_category['options']; foreach ($photoplog_category_options as $photoplog_key => $photoplog_val) { $photoplog_category_options["{$photoplog_key}"] = intval(trim(strval($photoplog_val))); } require_once DIR . '/includes/functions_misc.php'; $photoplog_category_bitopts = convert_array_to_bits($photoplog_category_options, $photoplog_categoryoptions, 1); if (photoplog_insert_category($photoplog_category_title, $photoplog_category_description, $photoplog_category_displayorder, $photoplog_category_parentid, $photoplog_category_bitopts, $photoplog_ds_catopts, $photoplog_suggestid)) { if ($photoplog_suggestid) { if ($vbulletin->options['photoplog_user_email']) { $photoplog_moderate_cat = $db->query_first("SELECT userid, title\r\n\t\t\t\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_suggestedcats\r\n\t\t\t\t\tWHERE suggestid = " . intval($photoplog_suggestid) . "\r\n\t\t\t\t"); if ($photoplog_moderate_cat) { $photoplog_fetch_userinfo = $db->query_first("SELECT username,email\r\n\t\t\t\t\t\tFROM " . TABLE_PREFIX . "user\r\n\t\t\t\t\t\tWHERE userid = " . intval($photoplog_moderate_cat['userid']) . "\r\n\t\t\t\t\t\tAND (options & " . intval($vbulletin->bf_misc_useroptions['adminemail']) . ")\r\n\t\t\t\t\t"); if ($photoplog_fetch_userinfo) { $photoplog_category = strval($photoplog_moderate_cat['title']); $photoplog_username = unhtmlspecialchars($photoplog_fetch_userinfo['username']); $photoplog_subject = $photoplog_message = ''; eval(fetch_email_phrases('photoplog_approved_category', -1, '', 'photoplog_')); vbmail($photoplog_fetch_userinfo['email'], $photoplog_subject, $photoplog_message, true); } $db->free_result($photoplog_fetch_userinfo); } }
function photoplog_massmove_make_subcats_as_necessary(&$fileids, &$destination_list_categories, &$parent_list_categories, &$source_list_categories, &$ds_catopts) { global $vbulletin; $source_key_of_parent_list = photoplog_make_source_key_of_parent_list($source_list_categories, $parent_list_categories); $clone_category_list = array(); $clone_category_list[] = false; foreach ($source_list_categories as $source_key => $source_cat) { if ($source_key != 0 && $fileids[$source_key] != '') { $clone_category_list[$source_key] = true; $parent_key = $source_key_of_parent_list[$source_key]; while ($parent_key != 0) { $clone_category_list[$parent_key] = true; $parent_key = $source_key_of_parent_list[$parent_key]; } } else { $clone_category_list[$source_key] = false; } } foreach ($clone_category_list as $clone_key => $clone_cat) { if ($clone_key != 0) { if ($clone_cat) { $clone_parent_key = $source_key_of_parent_list[$clone_key]; $clone_parent_cat = $destination_list_categories[$clone_parent_key]; $orig_child_cat = $source_list_categories[$clone_key]; $child_info_query = ''; $child_title = ''; $child_description = ''; $child_displayorder = 0; $child_options = ''; $child_info_query = $vbulletin->db->query_first("SELECT title,\r\n\t\t\t\t\t\tdescription, displayorder, options\r\n\t\t\t\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_categories\r\n\t\t\t\t\tWHERE catid = " . intval($orig_child_cat)); if ($child_info_query) { $child_title = $child_info_query['title']; $child_description = $child_info_query['description']; $child_displayorder = $child_info_query['displayorder']; $child_options = $child_info_query['options']; } $child_search_query = $vbulletin->db->query_first("SELECT catid\r\n\t\t\t\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_categories\r\n\t\t\t\t\tWHERE parentid = " . intval($clone_parent_cat) . "\r\n\t\t\t\t\tAND title = '" . $vbulletin->db->escape_string($child_title) . "'\r\n\t\t\t\t"); if ($child_search_query) { // child already exists $destination_list_categories[$clone_key] = $child_search_query['catid']; } else { // child does not exist, create clone // attempt to grab options from parent category $parent_query = $vbulletin->db->query_first("SELECT options\r\n\t\t\t\t\t\tFROM " . PHOTOPLOG_PREFIX . "photoplog_categories\r\n\t\t\t\t\t\tWHERE catid = " . intval($clone_parent_cat) . "\r\n\t\t\t\t\t"); if ($parent_query) { $child_options = $parent_query['options']; } $destination_list_categories[$clone_key] = photoplog_insert_category($child_title, $child_description, $child_displayorder, $clone_parent_cat, $child_options, $ds_catopts); } } else { // really should be no files to move, but in case something just came in, don't move it. $destination_list_categories[$clone_key] = $source_list_categories[$clone_key]; } } } }