Changes the owner and date of selected posts and threads 1.9.0 query_first_slave("SELECT * FROM " . TABLE_PREFIX . "product WHERE productid = '" . $db->escape_string("changetpowner") . "'"); if ($check['version']) { delete_product("changetpowner"); } $check = $db->query_first_slave("SELECT * FROM " . TABLE_PREFIX . "product WHERE productid = '" . $db->escape_string("chgtpowner38") . "'"); if ($check['version']) { delete_product("chgtpowner38"); } ]]> fetch_modlogtypes fetch_modlogactions cache_templates forumdisplay_start render(); ]]> search_complete render(); $template_changethreadsowner_link = vB_Template::create('forumdisplay_changethreadsowner_link'); $template_hook[inlinemod_post_bottom] .= $template_link->render(); ]]> showthread_start render(); ]]> inlinemod_action_switch input->clean_array_gpc("p", array("do" => TYPE_STR ) ); $actions = array("changethreadsowner", "dochangethreadsowner", "changepostsowner", "dochangepostsowner"); if ( in_array($vbulletin->GPC['do'], $actions) ) { $handled_do=true; }]]> inlinemod_start input->clean_array_gpc("p", array("do" => TYPE_STR ) ); $actions = array("changethreadsowner", "dochangethreadsowner", "changepostsowner", "dochangepostsowner"); //print_r($vbulletin->GPC); if ( in_array($vbulletin->GPC['do'], $actions) ) { $has_permission = false; if ($vbulletin->options['changethreadsowner_gp']) { foreach(split(",", $vbulletin->options['changethreadsowner_gp']) AS $gp) { if (is_member_of($vbulletin->userinfo, $gp)) { $has_permission = true; break; } } } else { $has_permission = can_moderate($threadinfo['forumid']); } if (!$has_permission) { print_no_permission(); } if (count($vbulletin->GPC['tlist']) > $threadlimit) { eval(standard_error(fetch_error('you_are_limited_to_working_with_x_threads', $threadlimit))); } if (count($vbulletin->GPC['plist']) > $postlimit) { eval(standard_error(fetch_error('you_are_limited_to_working_with_x_posts', $postlimit))); } } // ################################## // ### Change Posts/Threads Owner ### // ################################## $actions = array('dochangepostsowner', 'dochangethreadsowner'); if ( in_array($vbulletin->GPC['do'], $actions) ) { $changedate = false; $arrnewdate = $vbulletin->input->clean_gpc('p', 'date', TYPE_ARRAY); $newdate = mktime($arrnewdate['hour'], $arrnewdate['minute'], $arrnewdate['second'], $arrnewdate['month'], $arrnewdate['day'], $arrnewdate['year']); if ($arrnewdate['change'] == 'on') { $changedate = true; } $newpostowner = $vbulletin->input->clean_gpc('p', 'newthreadowner', TYPE_NOHTML); $setunregistered = $vbulletin->input->clean_gpc('p', 'setunregistered', TYPE_NOHTML); $newpostowner = $db->escape_string($newpostowner); if ($setunregistered == 'on') { $changeuser = true; $userinfo['userid'] = 0; if (strlen($newpostowner) > 0) { $userinfo['username'] = $newpostowner; } else { $userinfo['username'] = $vbphrase['unregistered']; } $userinfo['ipaddress'] = ""; } else { $changeuser = false; if (is_numeric($newpostowner)) { $querywhat = "userid"; } else { $querywhat = "username"; } $getuseridq = $vbulletin->db->query_read("SELECT ipaddress, userid, username FROM " . TABLE_PREFIX . "user WHERE ".$querywhat."='".$newpostowner."'"); if ($db->num_rows($getuseridq) > 0) { $userinfo = $vbulletin->db->fetch_array($getuseridq); $changeuser = true; } } if (!$changeuser AND !$changedate) { eval(standard_error(fetch_error('invalidid', $vbphrase['user'], $vbulletin->options['contactuslink']))); } } // ######################### // ### Change Post-Owner ### // ######################### if ($vbulletin->GPC['do'] == "changepostsowner") { if (empty($vbulletin->GPC['plist'])) { eval(standard_error(fetch_error('no_applicable_posts_selected'))); } $postids = implode(',', $vbulletin->GPC['plist']); $navbits[''] = $vbphrase['changethreadsowner_title']; $page_templater = vB_Template::create('forumdisplay_changethreadsowner'); $page_templater->register('postids', $postids); $postq = $db->query_read("SELECT p.dateline FROM " . TABLE_PREFIX . "post AS p WHERE p.postid=" . $vbulletin->GPC['plist'][0]); if ($db->num_rows($postq) > 0) { $datepost = $db->fetch_array($postq); $page_templater->register('day', date("d", $datepost['dateline'])); $page_templater->register('month', date("m", $datepost['dateline'])); $page_templater->register('year', date("Y", $datepost['dateline'])); $page_templater->register('hour', date("H", $datepost['dateline'])); $page_templater->register('minute', date("i", $datepost['dateline'])); $page_templater->register('second', date("s", $datepost['dateline'])); } } if ($vbulletin->GPC['do'] == "dochangepostsowner") { $vbulletin->input->clean_array_gpc('p', array('postids' => TYPE_STR)); $postids = explode(',', $vbulletin->GPC['postids']); foreach ($postids AS $index => $postid) { $post['postid'] = $postid; $postq = $db->query_read("SELECT p.userid, p.username, p.threadid, t.forumid FROM " . TABLE_PREFIX . "post AS p INNER JOIN " . TABLE_PREFIX . "thread AS t ON (p.threadid=t.threadid) WHERE p.postid=" . $post['postid']); if ($db->num_rows($postq)>0) { $oldpost = $db->fetch_array($postq); } $postdm =& datamanager_init('Post', $vbulletin, ERRTYPE_STANDARD, 'threadpost'); $postdm->set_existing($post); if ($changeuser) { if ($vbulletin->options['changethreadsowner_ip']) { $postdm->set('ipaddress', $userinfo['ipaddress'], true, false); } $postdm->set('userid', $userinfo['userid'], true, false); $postdm->set('username', $userinfo['username'], true, false); } if ($changedate) { $postdm->set('dateline', $newdate, true, false); } $postdm->save(); unset($postdm); if ($changeuser) { // Update Attachments $updateattq = $db->query_write("UPDATE " . TABLE_PREFIX . "attachment SET userid=" . $userinfo['userid'] . " WHERE contentid=" . $post['postid']); } $threadlist["$oldpost[threadid]"] = true; $forumlist["$oldpost[forumid]"] = true; if ($changeuser) { $userdm =& datamanager_init('User', $vbulletin, ERRTYPE_STANDARD); $userdm->set_existing($oldpost); $userdm->set('posts', 'IF(posts > 1, posts - 1, 0)', false); $userdm->save(); unset($userdm); $userdm =& datamanager_init('User', $vbulletin, ERRTYPE_STANDARD); $userdm->set_existing($userinfo); $userdm->set('posts', 'posts + 1', false); $userdm->save(); unset($userdm); } $modlog[] = array( 'userid' =>& $vbulletin->userinfo['userid'], 'forumid' =>& $oldpost['forumid'], 'threadid' => $oldpost['threadid'], 'postid' => $post['postid'], ); log_moderator_action($modlog, 'changethreadsowner_modaction', array($oldpost['username'], $userinfo['username'])); } foreach (array_keys($threadlist) AS $threadid) { build_thread_counters($threadid); } foreach (array_keys($forumlist) AS $forumid) { build_forum_counters($forumid); } // empty cookie setcookie('vbulletin_inlinepost', '', TIMENOW - 3600, '/'); //Finished, go to last thread $vbulletin->url = 'showthread.php?' . $vbulletin->session->vars['sessionurl'] . $oldpost['threadid']; eval(print_standard_redirect('redirect_changethreadsowner_success', true)); } // ########################### // ### Change Thread-Owner ### // ########################### if ($vbulletin->GPC['do'] == "changethreadsowner") { if ( empty( $vbulletin->GPC['tlist'] ) && empty( $vbulletin->GPC['vbulletin_inlinethread']) ) { eval(standard_error(fetch_error('you_did_not_select_any_valid_threads'))); } if ( !empty( $vbulletin->GPC['tlist'] ) ) { $threadids = implode(',', $vbulletin->GPC['tlist']); } else { $threadids = str_replace('-', ',' , $vbulletin->GPC['vbulletin_inlinethread']); } $first_thread = explode(',', $threadids); $navbits[''] = $vbphrase['changethreadsowner_title']; $page_templater = vB_Template::create('forumdisplay_changethreadsowner'); $page_templater->register('threadids', $threadids); $postq = $db->query_read("SELECT t.dateline FROM " . TABLE_PREFIX . "thread AS t WHERE t.threadid=" . $first_thread[0]); if ($db->num_rows($postq) > 0) { $datepost = $db->fetch_array($postq); $page_templater->register('day', date("d", $datepost['dateline'])); $page_templater->register('month', date("m", $datepost['dateline'])); $page_templater->register('year', date("Y", $datepost['dateline'])); $page_templater->register('hour', date("H", $datepost['dateline'])); $page_templater->register('minute', date("i", $datepost['dateline'])); $page_templater->register('second', date("s", $datepost['dateline'])); } } if ($vbulletin->GPC['do'] == "dochangethreadsowner") { //Get Threads $vbulletin->input->clean_array_gpc('p', array('threadids' => TYPE_STR)); $threadids = explode(',', $vbulletin->GPC['threadids']); foreach ($threadids AS $index => $threadid) { //Get Thread $threaddm =& datamanager_init('Thread', $vbulletin, ERRTYPE_STANDARD, 'threadpost'); $threaddm->set_existing(fetch_threadinfo($threadid)); $firstpostid=$threaddm->fetch_field('firstpostid'); $olduser['userid']=$threaddm->fetch_field('postuserid'); $olduser['username']=$threaddm->fetch_field('postusername'); $forumid=$threaddm->fetch_field('forumid'); $forumlist["$forumid"] = true; //Update Thread if ($changeuser) { $threaddm->set('postuserid', $userinfo['userid'], true, false); $threaddm->set('postusername', $userinfo['username'], true, false); } if ($changedate) { $threaddm->set('dateline', $newdate, true, false); } $threaddm->save(); //Update post $postdm =& datamanager_init('Post', $vbulletin, ERRTYPE_STANDARD, 'threadpost'); $postdm->set_existing(fetch_postinfo($firstpostid)); if ($changeuser) { if ($vbulletin->options['changethreadsowner_ip']) { $postdm->set('ipaddress', $userinfo['ipaddress'], true, false); } $postdm->set('userid', $userinfo['userid'], true, false); $postdm->set('username', $userinfo['username'], true, false); } if ($changedate) { $postdm->set('dateline', $newdate, true, false); } $postdm->save(); if ($changeuser) { //Update user's postcount $userdm =& datamanager_init('User', $vbulletin, ERRTYPE_STANDARD); $userdm->set_existing($olduser); $userdm->set('posts', 'IF(posts > 1, posts - 1, 0)', false); $userdm->save(); unset($userdm); $userdm =& datamanager_init('User', $vbulletin, ERRTYPE_STANDARD); $userdm->set_existing($userinfo); $userdm->set('posts', 'posts + 1', false); $userdm->save(); unset($userdm); } if ($changeuser) { // Update Attachments $updateattq = $db->query_write("UPDATE " . TABLE_PREFIX . "attachment SET userid=" . $userinfo['userid'] . " WHERE contentid=" . $firstpostid); } unset($threaddm); unset($postdm); $modlog[] = array( 'userid' =>& $vbulletin->userinfo['userid'], 'forumid' =>& $forumid, 'threadid' => $threadid, ); build_thread_counters($threadid); log_moderator_action($modlog, 'changethreadsowner_modaction', array($olduser['username'], $userinfo['username'])); } foreach (array_keys($forumlist) AS $forumid) { build_forum_counters($forumid); } // empty cookie setcookie('vbulletin_inlinethread', '', TIMENOW - 3600, '/'); //Finished $vbulletin->url = 'forumdisplay.php?' . $vbulletin->session->vars['sessionurl'] . $forumid; eval(print_standard_redirect('redirect_changethreadsowner_success', true)); }]]> 6 boolean yesno 1 ipaddress