function custom_badges_rebuild()
{
$awarded = 0;
$posts = qa_db_query_sub('SELECT userid, postid, netvotes FROM ^posts WHERE type=$ AND netvotes>0', 'C');
while (($post = qa_db_read_one_assoc($posts, true)) !== null) {
$badges = array('nice_comment', 'good_comment', 'excellent_comment');
$awarded += count(qa_badge_award_check($badges, (int) $post['netvotes'], $post['userid'], $post['postid'], 2));
}
return $awarded;
}
function custom_badges_rebuild()
{
$awarded = 0;
$userq = qa_db_query_sub('SELECT user_id, meta_value FROM ^usermeta WHERE meta_key=$', 'max_bookmarks');
while (($user = qa_db_read_one_assoc($userq, true)) !== null) {
$badges = array('bookmarker', 'bookkeeper', 'bookworm');
$awarded += count(qa_badge_award_check($badges, (int) $user['meta_value'], $user['user_id'], null, 2));
}
return $awarded;
}
function qa_check_all_users_badges()
{
$awarded = 0;
$users;
$temp = qa_db_query_sub('SELECT * FROM ^posts');
while (($post = qa_db_read_one_assoc($temp, true)) !== null) {
if (!$post['userid']) {
continue;
}
$user = '******' . $post['userid'];
$pid = $post['postid'];
$pt = $post['type'];
// get post count
if (isset($users[$user]) && isset($users[$user][$pt])) {
$users[$user][$pt]++;
} else {
$users[$user][$pt] = 1;
}
// get post votes
if ($post['netvotes'] != 0) {
$users[$user][$pt . 'votes'][] = array('id' => $pid, 'votes' => (int) $post['netvotes'], 'parentid' => $post['parentid'], 'created' => $post['created']);
}
// get post views
if ($post['views']) {
$users[$user]['views'][] = array('id' => $pid, 'views' => $post['views']);
}
}
//votes received and given out
$voter = qa_db_read_all_assoc(qa_db_query_sub('SELECT userid,qupvotes,qdownvotes,aupvotes,adownvotes,upvoteds FROM ^userpoints'));
foreach ($voter as $idx => $votes) {
$user = '******' . $votes['userid'];
// votes
$users[$user]['votes'] = (int) $votes['qupvotes'] + (int) $votes['qdownvotes'] + (int) $votes['aupvotes'] + (int) $votes['adownvotes'];
// voteds
$users[$user]['voted'] = (int) $votes['upvoteds'];
unset($voter[$idx]);
}
// flags
$flag_result = qa_db_read_all_values(qa_db_query_sub('SELECT userid FROM ^uservotes WHERE flag > 0'));
foreach ($flag_result as $idx => $flag) {
$user = '******' . $flag;
// get flag count
if (isset($users[$user]) && isset($users[$user]['flags'])) {
$users[$user]['flags']++;
} else {
$users[$user]['flags'] = 1;
}
unset($flag_result[$idx]);
}
// per user loop
foreach ($users as $user => $data) {
$uid = (int) substr($user, 4);
// bulk posts
$badges = array('Q' => array('asker', 'questioner', 'inquisitor'), 'A' => array('answerer', 'lecturer', 'preacher'), 'C' => array('commenter', 'commentator', 'annotator'));
foreach ($badges as $pt => $slugs) {
if (!isset($data[$pt])) {
continue;
}
$awarded += count(qa_badge_award_check($slugs, $data[$pt], $uid, null, 0));
}
// nice Q&A
$badges = array('nice_question', 'good_question', 'great_question', 'nice_answer', 'good_answer', 'great_answer');
if ($this->badge_activated($badges)) {
$badges = array('Q' => array('nice_question', 'good_question', 'great_question'), 'A' => array('nice_answer', 'good_answer', 'great_answer'));
foreach ($badges as $pt => $slugs) {
foreach ($slugs as $badge_slug) {
if (!isset($data[$pt . 'votes'])) {
continue;
}
foreach ($data[$pt . 'votes'] as $idv) {
// poll plugin integration
if ($pt == 'A' && qa_opt('poll_enable')) {
$poll = qa_db_read_one_value(qa_db_query_sub('SELECT meta_value FROM ^postmeta WHERE post_id=# AND meta_key=$', $idv['id'], 'is_poll'), true);
if ($poll) {
continue;
}
}
if ((int) $idv['votes'] >= (int) qa_opt('badge_' . $badge_slug . '_var') && qa_opt('badge_' . $badge_slug . '_enabled') !== '0') {
$result = qa_db_read_one_value(qa_db_query_sub('SELECT badge_slug FROM ^userbadges WHERE user_id=# AND object_id=# AND badge_slug=$', $uid, $idv['id'], $badge_slug), true);
if ($result == null) {
// not already awarded this badge
$this->award_badge($idv['id'], $uid, $badge_slug, false, true);
$awarded++;
}
// old question answer vote checks
if ($pt == 'A') {
$qid = $idv['parentid'];
$create = strtotime($idv['created']);
$parent = $this->get_post_data($qid);
$pcreate = strtotime($parent['created']);
$diff = round(abs($pcreate - $create) / 60 / 60 / 24);
$badge_slug2 = $badge_slug . '_old';
if ($diff >= (int) qa_opt('badge_' . $badge_slug2 . '_var') && qa_opt('badge_' . $badge_slug2 . '_enabled') !== '0') {
$result = qa_db_read_one_value(qa_db_query_sub('SELECT badge_slug FROM ^userbadges WHERE user_id=# AND object_id=# AND badge_slug=$', $uid, $idv['id'], $badge_slug2), true);
if ($result == null) {
// not already awarded for this answer
$this->award_badge($idv['id'], $uid, $badge_slug2);
$awarded++;
}
}
}
}
}
}
}
}
// votes per user badges
if (isset($data['votes'])) {
$votes = $data['votes'];
$badges = array('voter', 'avid_voter', 'devoted_voter');
$awarded += count(qa_badge_award_check($badges, $votes, $uid, null, 0));
}
// voted per user badges
if (isset($data['voted'])) {
$votes = $data['voted'];
$badges = array('liked', 'loved', 'revered');
$awarded += count(qa_badge_award_check($badges, $votes, $uid, null, 0));
}
// views per post badges
if (isset($data['views'])) {
$badges = array('notable_question', 'popular_question', 'famous_question');
foreach ($data['views'] as $idv) {
$awarded += count(qa_badge_award_check($badges, $idv['views'], $uid, $idv['id'], 0));
}
}
// flags per user
if (isset($data['flags'])) {
$flags = $data['flags'];
$badges = array('watchdog', 'bloodhound', 'pitbull');
$awarded += count(qa_badge_award_check($badges, $flags, $uid, null, 0));
}
unset($users[$user]);
}
// selects, selecteds
$badges = array('gifted', 'wise', 'enlightened', 'grateful', 'respectful', 'reverential');
if ($this->badge_activated($badges)) {
$selects = qa_db_read_all_assoc(qa_db_query_sub('SELECT aselects, aselecteds, userid FROM ^userpoints'));
foreach ($selects as $idx => $s) {
$uid = $s['userid'];
if (isset($s['aselecteds'])) {
$count = $s['aselecteds'];
$badges = array('gifted', 'wise', 'enlightened');
$awarded += count(qa_badge_award_check($badges, $count, $uid, null, 0));
}
if (isset($s['aselects'])) {
$count = $s['aselects'];
$badges = array('grateful', 'respectful', 'reverential');
$awarded += count(qa_badge_award_check($badges, $count, $uid, null, 0));
}
unset($selects[$idx]);
}
}
// achievements
$badges = array('dedicated', 'devoted', 'zealous', 'visitor', 'trouper', 'veteran', 'regular', 'old_timer', 'ancestor', 'reader', 'avid_reader', 'devoted_reader');
if ($this->badge_activated($badges)) {
$userq = qa_db_query_sub('SELECT user_id AS uid,questions_read AS qr,oldest_consec_visit AS ocv,longest_consec_visit AS lcv,total_days_visited AS tdv,last_visit AS lv,first_visit AS fv,posts_edited AS pe FROM ^achievements');
while (($user = qa_db_read_one_assoc($userq, true)) !== null) {
$uid = $user['uid'];
// edits
$count = $user['pe'];
$badges = array('editor', 'copy_editor', 'senior_editor');
$awarded += count(qa_badge_award_check($badges, $count, $uid, null, 0));
// on-sign-in badges
// check lapse in days since last visit
// using julian days
$todayj = GregorianToJD(date('n'), date('j'), date('Y'));
$last_visit = strtotime($user['lv']);
$lastj = GregorianToJD(date('n', $last_visit), date('j', $last_visit), date('Y', $last_visit));
$last_diff = $todayj - $lastj;
$first_visit = strtotime($user['fv']);
$first_visitj = GregorianToJD(date('n', $first_visit), date('j', $first_visit), date('Y', $first_visit));
$first_visit_diff = $todayj - $first_visitj;
$badges = array('dedicated', 'devoted', 'zealous');
$awarded += count(qa_badge_award_check($badges, $user['lcv'], $uid, null, 0));
$badges = array('visitor', 'trouper', 'veteran');
$awarded += count(qa_badge_award_check($badges, $user['tdv'], $uid, null, 0));
$badges = array('regular', 'old_timer', 'ancestor');
$awarded += count(qa_badge_award_check($badges, $first_visit_diff, $uid, null, 0));
// views
$badges = array('reader', 'avid_reader', 'devoted_reader');
$awarded += count(qa_badge_award_check($badges, $user['qr'], $uid, null, 0));
}
}
// points
$badges = array('100_club', '1000_club', '10000_club');
if ($this->badge_activated($badges)) {
$userq = qa_db_query_sub('SELECT userid, points FROM ^userpoints');
while (($user = qa_db_read_one_assoc($userq, true)) !== null) {
$awarded += count(qa_badge_award_check($badges, $user['points'], $user['userid'], null, 0));
}
}
if (!QA_FINAL_EXTERNAL_USERS) {
// verified
$badges = array('verified');
if ($this->badge_activated($badges)) {
$userq = qa_db_query_sub('SELECT userid, flags FROM ^users WHERE flags&#', QA_USER_FLAGS_EMAIL_CONFIRMED);
while (($user = qa_db_read_one_assoc($userq, true)) !== null) {
$awarded += count(qa_badge_award_check($badges, false, $user['userid'], null, 0));
}
}
// profile stuff
$badges = array('avatar', 'profiler');
if ($this->badge_activated($badges)) {
$userq = qa_db_query_sub('SELECT userid FROM ^users');
while (($userid = qa_db_read_one_value($userq, true)) !== null) {
list($useraccount, $userprofile, $userfields) = qa_db_select_with_pending(qa_db_user_account_selectspec($userid, true), qa_db_user_profile_selectspec($userid, true), qa_db_userfields_selectspec());
// avatar badge
if (qa_opt('avatar_allow_upload') && isset($useraccount['avatarblobid'])) {
$badges = array('avatar');
$awarded += count(qa_badge_award_check($badges, false, $userid, null, 0));
}
// profile completion
$missing = false;
foreach ($userfields as $userfield) {
if (!isset($userprofile[$userfield['title']]) || @$userprofile[$userfield['title']] === '') {
$missing = true;
break;
}
}
if (!$missing) {
$badges = array('profiler');
$awarded += count(qa_badge_award_check($badges, false, $userid, null, 0));
}
}
}
}
// rebuild badges from other plugins - experimental! - $module->custom_badges_rebuild() returns number of badges awarded.
$moduletypes = qa_list_module_types();
foreach ($moduletypes as $moduletype) {
$modulenames = qa_list_modules($moduletype);
foreach ($modulenames as $modulename) {
$module = qa_load_module($moduletype, $modulename);
if (method_exists($module, 'custom_badges_rebuild')) {
$awarded += $module->custom_badges_rebuild();
}
}
}
// badges
$badges = array('medalist', 'champion', 'olympian');
if ($this->badge_activated($badges)) {
$badgelist = qa_db_read_all_values(qa_db_query_sub('SELECT user_id FROM ^userbadges'));
$users = array();
foreach ($badgelist as $idx => $medal) {
$user = '******' . $medal;
// get badge count
if (isset($users[$user]) && isset($users[$user]['medals'])) {
$users[$user]['medals']++;
} else {
$users[$user]['medals'] = 1;
}
unset($badgelist[$idx]);
}
foreach ($users as $user => $data) {
$uid = (int) substr($user, 4);
// check badges
if (isset($data['medals'])) {
$uid = (int) substr($user, 4);
$count = $data['medals'];
$awarded += count(qa_badge_award_check($badges, $count, $uid, null, 0));
}
unset($users[$user]);
}
}
// return ok text
return $awarded . ' badge' . ($awarded != 1 ? 's' : '') . ' awarded.';
}
function q_view_main($q_view)
{
qa_html_theme_base::q_view_main($q_view);
// badge check on view update
if (qa_opt('badge_active') && isset($this->content['inc_views_postid'])) {
$uid = $q_view['raw']['userid'];
if (!$uid) {
return;
}
// anonymous
$oid = $this->content['inc_views_postid'];
// total views check
$views = $q_view['raw']['views'];
$views++;
// because we haven't incremented the views yet
$badges = array('notable_question', 'popular_question', 'famous_question');
qa_badge_award_check($badges, $views, $uid, $oid, 2);
// personal view count increase and badge check
$uid = qa_get_logged_in_userid();
qa_db_query_sub('UPDATE ^achievements SET questions_read=questions_read+1 WHERE user_id=# ', $uid);
$views = qa_db_read_one_value(qa_db_query_sub('SELECT questions_read FROM ^achievements WHERE user_id=# ', $uid), true);
$badges = array('reader', 'avid_reader', 'devoted_reader');
qa_badge_award_check($badges, $views, $uid, null, 2);
}
}
function check_user_fields($userid, $params)
{
list($useraccount, $userprofile, $userfields) = qa_db_select_with_pending(qa_db_user_account_selectspec($userid, true), qa_db_user_profile_selectspec($userid, true), qa_db_userfields_selectspec());
// avatar badge
if (qa_opt('avatar_allow_upload') && isset($useraccount['avatarblobid'])) {
$badges = array('avatar');
qa_badge_award_check($badges, false, $userid);
}
// profile completion
$missing = false;
foreach ($userfields as $userfield) {
if (!isset($userprofile[$userfield['title']]) || @$userprofile[$userfield['title']] === '') {
$missing = true;
break;
}
}
if (!$missing) {
$badges = array('profiler');
qa_badge_award_check($badges, false, $userid);
}
}
function ajaxBookmark($qid, $uid, $bmd)
{
eval('$bmd = ' . $bmd . ';');
$bookmarks = $this->get_bookmarks_for_user($uid);
if ($bookmarks) {
if (!$bmd) {
$bookmarks = $bookmarks . ',' . $qid;
qa_db_query_sub('UPDATE ^usermeta SET meta_value=$ WHERE user_id=# AND meta_key=$', $bookmarks, $uid, 'bookmarks');
} else {
$bookmarks = substr(str_replace(',' . $qid . ',', ',', ',' . $bookmarks . ','), 1, -1);
qa_db_query_sub('UPDATE ^usermeta SET meta_value=$ WHERE user_id=# AND meta_key=$', $bookmarks, $uid, 'bookmarks');
}
} else {
if (!$bmd) {
qa_db_query_sub('INSERT INTO ^usermeta (user_id,meta_key,meta_value) VALUES (#,$,$) ON DUPLICATE KEY UPDATE meta_value=$', $uid, 'bookmarks', $qid, $qid);
} else {
$bookmarks = substr(str_replace(',' . $qid . ',', ',', $bookmarks), 1, -1);
qa_db_query_sub('DELETE FROM ^usermeta WHERE user_id=# AND meta_key=$', $uid, 'bookmarks');
}
}
// badges
if (!$bmd) {
$var = count(explode(',', $bookmarks));
if (function_exists('qa_badge_award_check') && qa_opt('badge_active') && qa_opt('badge_custom_badges')) {
$awarded = count(qa_badge_award_check(array('bookmarker', 'bookworm', 'bookkeeper'), $var, $uid, NULL, 2));
}
$max = qa_db_read_one_value(qa_db_query_sub('SELECT meta_value FROM ^usermeta WHERE user_id=# AND meta_key=$', $uid, 'max_bookmarks'), true);
if (!$max || (int) $max < $var) {
qa_db_query_sub('INSERT INTO ^usermeta (user_id,meta_key,meta_value) VALUES (#,$,$) ON DUPLICATE KEY UPDATE meta_value=$', $uid, 'max_bookmarks', $var, $var);
}
}
$this->bookmark($qid, $uid, $bmd == false);
}
