vb.org Archive - Major Additions

i'm having the same problem , how can i fix this myself ?

i think its stored in xperience_level

now it looks like 24200 68

so the experience level 24200 should have people at lvl 68 right? but when i do a recount people get level 22 while they should have 68 i think

i deleted it again, did a reset imported lvl 3 (or 4) then i did a recount and its like :

22 Bushmaster 56,161 99.8% 13 3,754 1,073 2,313 49,020
22 Istvan 24,299 100.0% 15 3,811 8,501 11,886 100
22 Thalin 22,255 77.0% -5 3,738 4,540 13,976 0
22 Illieth 17,138 99.9% 10 3,762 2,415 8,344 2,616
22 Atee 14,071 38.0% 10 3,755 3,487 6,827 0
22 Grovis 11,587 38.0% 10 3,756 1,928 5,902 0
22 Hyfk 7,950 42.0% 20 3,159 1,232 3,533 25
22 Roos 7,855 47.0% 0 3,133 688 4,034 0
22 P?nelop? 7,827 42.0% 20 3,790 940 3,097 0
22 Leeona 6,989 51.0% 10 3,787 1,768 1,434 0
22 Barkas 6,790 38.0% 10 3,751 991 2,047 0
22 Fjotte 6,647 38.0% 10 3,751 973 1,922 0
22 Armengar 6,633 38.0% 10 2,558 958 3,116 0
22 Layla 6,552 51.0% 10 3,753 672 2,126 0

i used the kill_xperience.php to delete the mod completly but when i reinstall everyone is stuk on lvl 22 again while he xperience_level reads

20800 20
22400 21
24000 22
25500 23
27200 24
28900 25
30500 26

so even tho the levels seem to have been imported into the database people cant level up past lvl 22

akibui

11-24-2011 02:37 PM

I removed vBExperience following the readme_install_uninstall_upgrade.txt then i get error when i try to remove all file from FTP. Please help.

Quote:

arning: require_once([path]/xperience/hooks/memberaction_dropdown.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions.php(3410) : eval()'d code on line 4

Fatal error: require_once() [function.require]: Failed opening required '/home/xxxx/public_html/xperience/hooks/memberaction_dropdown.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxxx/public_html/includes/functions.php(3410) : eval()'d code on line 4

problem solved.

goxy63

11-30-2011 03:35 PM

So to exclude some inactive members just to create one usergroup and to move those users there as it looks weird that some user who is not with us 2-3 years get some rewards today :D
And after this to recount ?

Or there is option "Only active users?" within admin CP, but where to set in VB after how many days someone is active or not...so many options I just lost myself there :)
After this says please do not recount!

After any of these changes we again need to wait some time that everything get sorted out with data?

snowlion

12-01-2011 12:46 AM

Quote:

Originally Posted by goxy63 (Post 2273376)

Use this mod :D
Move Inactive and Lurker Users To New Usergroup

https://vborg.vbsupport.ru/showthread.php?t=231874

tylerjmorrison

12-01-2011 01:41 AM

Got It!

Vowgaming

12-01-2011 04:46 AM

Hi Im trying to use vsa donate add on and have changed vBExperience VSa PayPal Donate to

PHP Code:


		
			
if ($DoDebug==1) echo "<br/>VSa PayPal Donate - Attachments";

if ($user['usergoupid'] != "55" or $user['usergoupid'] != "56" )
{
    $attq = $vbulletin->db->query_read("SELECT
        SUM(amount) as myamount
        FROM " . TABLE_PREFIX . "vsa_ppdonate
        WHERE confirmed=1 AND userid=".$user['userid']."
        GROUP BY userid
    ");

    if ($vbulletin->db->num_rows($attq) > 0 )
    {
        $att = $vbulletin->db->fetch_array($attq);
        $xperience['count_user_vppd'] = $att['myamount'] * $vbulletin->options['xperience_points_vppd'];
        $xperience['count_user'] += $xperience['count_user_vppd'];
    }
}

I'm trying to exclude a user group or two from getting points for donations. but this does not seem to work can anyone give me a few more pointers please.

Vowgaming

12-01-2011 09:17 AM

Looks like I worked it out

the ' ' marks in if ($user['usergoupid'] != "55" or $user['usergoupid'] != "56" ) should not be there it should read

if ($user[usergoupid] != "55" or $user[usergoupid] != "56" )

the code I'm using on my site that works is

PHP Code:


		
			
if ($DoDebug==1) echo "<br/>VSa PayPal Donate - Attachments";



if ($user[usergroupid] > "55")

{

    $attq = $vbulletin->db->query_read("SELECT

        SUM(amount) as myamount

        FROM " . TABLE_PREFIX . "vsa_ppdonate

        WHERE confirmed=1 AND userid=".$user['userid']."

        GROUP BY userid

    ");



    if ($vbulletin->db->num_rows($attq) > 0 )

    {

        $att = $vbulletin->db->fetch_array($attq);

        $xperience['count_user_vppd'] = $att['myamount'] * $vbulletin->options['xperience_points_vppd'];

        $xperience['count_user'] += $xperience['count_user_vppd'];

    }

}

OldSchoolDSL

12-02-2011 09:54 PM

Installed and working

4.1.8 :D

Although I did notice a few typing errors. Not the spelling per say, but rather a few words running into one another

Example.... On the Award tab, the description for The Community Award reads

Points for posting Visitormessages ....

Should be: Points for posting Visitor messages ....

A few other places here and there.

K!nG	12-04-2011 04:26 AM

Hi guys,

Well i know i have done it before or have seen it before and now i searched around but i can't seem to find out .... i need a lil bit of help. Right now my awards are currently showing under user name and i wants to bring them down with users activity and all that but i can't seem to find where to do the template edit for this and what will be the exact code that i have to move.. I want am attaching an image to make it more clear. Thanks.

https://vborg.vbsupport.ru/

ozione

12-08-2011 08:33 AM

hello!

i just upgraded to 4.1.0 RC and I get the following error when trying to recount experience points:

Code:

SELECT

                                        COUNT(*) AS count_threads,

                                        SUM(votetotal/votenum) AS count_votes,

                                        SUM(replycount) AS count_replycount,

                                        SUM(views) AS count_views,

                                        SUM(sticky) AS count_stickies

                                        FROM vb4_thread 

                                        WHERE visible=1 AND forumid = 54

                                        AND postuserid=2

                                        AND thread.dateline > 315532800;



MySQL Error   : Unknown column 'thread.dateline' in 'where clause'

Error Number  : 1054

Request Date  : Thursday, December 8th 2011 @ 10:27:48 AM

Error Date    : Thursday, December 8th 2011 @ 10:27:49 AM

Script        : http://www.xxx.xxx/vb4/admincp/xperience_admin.php?do=xperience_admin_recount_xp

Referrer      : http://www.xxx.xxx/vb4/admincp/xperience_admin.php?do=recount

IP Address    : xxx.xxx.xxx.xxx

Username      : xxx

Classname     : vB_xxx

MySQL Version : 5.1.54-log

any help would be appriciated.

All times are GMT. The time now is 07:37 PM.

Page 221 of 270

221

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02749 seconds Memory Usage 1,774KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: