/**
* Step #3
*
*/
function step_3()
{
$this->add_index(sprintf($this->phrase['core']['altering_x_table'], 'user', 1, 1), 'user', 'referrerid', array('referrerid'));
require_once DIR . '/includes/adminfunctions_bookmarksite.php';
build_bookmarksite_datastore();
}
$sort = 'ASC';
break;
default:
$comp = false;
$sort = false;
}
if ($comp and $sort and $bookmarksite_swap = $db->query_first("SELECT bookmarksiteid, displayorder FROM " . TABLE_PREFIX . "bookmarksite WHERE displayorder {$comp} {$bookmarksite_orig['displayorder']} ORDER BY displayorder {$sort}, title ASC LIMIT 1")) {
$db->query_write("\n\t\t\t\t\tUPDATE " . TABLE_PREFIX . "bookmarksite\n\t\t\t\t\tSET displayorder = CASE bookmarksiteid\n\t\t\t\t\t\tWHEN {$bookmarksite_orig['bookmarksiteid']} THEN {$bookmarksite_swap['displayorder']}\n\t\t\t\t\t\tWHEN {$bookmarksite_swap['bookmarksiteid']} THEN {$bookmarksite_orig['displayorder']}\n\t\t\t\t\t\tELSE displayorder END\n\t\t\t\t\tWHERE bookmarksiteid IN({$bookmarksite_orig['bookmarksiteid']}, {$bookmarksite_swap['bookmarksiteid']})\n\t\t\t\t");
// tell the datastore to update
$changes = true;
}
}
}
//update the datastore bookmarksite cache
if ($changes) {
build_bookmarksite_datastore();
}
$_REQUEST['do'] = 'modify';
}
// ########################################################################
// we want to display the bookmark list - this is the default action
if ($_REQUEST['do'] == 'modify') {
if (!$vbulletin->options['socialbookmarks']) {
print_table_start();
print_description_row(fetch_error('social_bookmarks_disabled'));
print_table_footer(2, '', '', false);
}
// display the form and table header
print_form_header('bookmarksite', 'quickupdate');
print_table_header($vbphrase['social_bookmarking_manager'], 3);
$bookmarksites_result = $db->query_read("\n\t\tSELECT * FROM " . TABLE_PREFIX . "bookmarksite AS bookmarksite\n\t\tORDER BY displayorder, title\n\t");
/**
* Step #97
*
* @param array contains id to startat processing at
*
* @return mixed
*/
function step_97($data = null)
{
$startat = intval($data['startat']);
$this->show_message(sprintf($this->phrase['vbphrase']['update_table'], TABLE_PREFIX . 'userlist'));
$perpage = 100;
$users = $this->db->query_read("\n\t\t\tSELECT *\n\t\t\tFROM " . TABLE_PREFIX . "user AS user\n\t\t\tLEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (usertextfield.userid = user.userid)\n\t\t\tWHERE user.userid > {$startat} AND (usertextfield.ignorelist <> '' OR usertextfield.buddylist <> '')\n\t\t\tORDER BY user.userid ASC\n\t\t\t" . ($this->limitqueries ? "LIMIT 0, {$perpage}" : "") . "\n\t\t");
// check to see if we have some results...
if ($this->db->num_rows($users)) {
$lastid = 0;
while ($user = $this->db->fetch_array($users)) {
$this->show_message(sprintf($this->phrase['version']['370b2']['build_userlist'], $user['userid']));
$buddylist = preg_split('/( )+/', trim($user['buddylist']), -1, PREG_SPLIT_NO_EMPTY);
$ignorelist = preg_split('/( )+/', trim($user['ignorelist']), -1, PREG_SPLIT_NO_EMPTY);
if (!empty($buddylist)) {
$buddylist = array_map('intval', $buddylist);
foreach ($buddylist as $buddyid) {
$this->db->query_write("INSERT IGNORE INTO " . TABLE_PREFIX . "userlist (userid, relationid, type, friend) VALUES (" . $user['userid'] . ", " . $buddyid . ", 'buddy', 'no')");
}
}
if (!empty($ignorelist)) {
$ignorelist = array_map('intval', $ignorelist);
foreach ($ignorelist as $ignoreid) {
$this->db->query_write("INSERT IGNORE INTO " . TABLE_PREFIX . "userlist (userid, relationid, type, friend) VALUES (" . $user['userid'] . ", " . $ignoreid . ", 'ignore', 'no')");
}
}
$lastid = $user['userid'];
}
return array('startat' => $lastid);
} else {
$this->show_message($this->phrase['version']['370b2']['build_userlist_complete']);
}
require_once DIR . '/includes/adminfunctions_bookmarksite.php';
build_bookmarksite_datastore();
}
