vb.org Archive - Major Additions

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Major Additions - vBExperience 4 (https://vborg.vbsupport.ru/showthread.php?t=245023)

Hi all,

I've been searching this threads for the past hour and haven't found the answer so forgive me if this has been asked already :)

I'm trying to customize the "Insight" page. I want other "Awards" listed besides the default "Most Active User" for the week, "Best Group", "Most achieved Achievement" etc. I want other awards or achievements to appear here. Is there something I need to modify in the php file, or can this be done via the administration functions? I can't find it.

thanks in advance!

Quote:

Originally Posted by ozione (Post 2275823)

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.

still busting my head with this one.
HALP!
:confused:

Quote:

Originally Posted by OldSchoolDSL (Post 2274135)

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.

These are simply names of the awards and achivements, you can edit them via AdminCP.

Quote:

Originally Posted by K!nG (Post 2274486)

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.

http://img853.imageshack.us/img853/6196/awardsx.png

Please check the settings, specially "Display award showcase in postbit?". There are a few locations that maybe fit your needs.

Quote:

Originally Posted by ozione (Post 2275823)

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.

It seems you are using "Advanced_Forum_Points". Please install the attached product XML, replace existing.

Quote:

Originally Posted by bryanb (Post 2275846)

There is no way to customize Insight. You would need to modify the xperience.php and the template "xperience_insight"

im new to this i dont have a clue how to upload this, i have read install but i still have no clue where i am uploading the files to on my server

Quote:

Originally Posted by Phalynx (Post 2277044)

It seems you are using "Advanced_Forum_Points". Please install the attached product XML, replace existing.

hi, Phalynx and thanks for your feedback.
after overwriting the "advanced_forum_points" I get a (another) new error:

Code:

Database error in vBulletin 4.1.8:



Invalid SQL:

SELECT COUNT(highscorerid) as countchampionships 

                        FROM `vb4_v3arcade_games` 

                        WHERE highscorerid = '2' 

                        AND v3arcade_games.dateadded > 315532800;



MySQL Error   : Unknown column 'v3arcade_games.dateadded' in 'where clause'

Error Number  : 1054

Request Date  : Wednesday, December 14th 2011 @ 08:56:12 AM

Error Date    : Wednesday, December 14th 2011 @ 08:56:13 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_Database

MySQL Version : 5.1.54-log

i tried to overwrtie v3 arcade plugings again, but w/o success.
:(

Please download and install the attached plugin.

Quote:

Originally Posted by Phalynx (Post 2277633)

Please download and install the attached plugin.

flawless!
THANKS!

Quote:

Originally Posted by Phalynx (Post 2277044)

...There is no way to customize Insight. You would need to modify the xperience.php and the template "xperience_insight"

Thanks, I'll do that.

Also, when and how are tags being updated in the stats page. I'm running a contest on my site - the person who creates the most tags by x date wins a prize. The thing is the stats for the tags aren't updated in real time. I've tried troubleshooting it by updating the counters and running scheduled maintenance by hand.

So simply, how do I manually update the tag stats, or have them updated hourly. Please let me know. Thanks!

Never mind - figured it out. The only counter I didn't run was the "Update Experience Points" - naturally that was it. :p

In the admin control panel for Experience: Points - it states "Counts only referrals from users that have made at least x posts"

How do I make "x" a number - like 5?

If I understand it correctly, I can issue 25 points for each member referred, and if that member makes x amount of posts, the referring member can be awarded x points on top of the original 25 points they received for referring that person. Right?

Or is it either points for members referred or referred members that post? Not a combination of the two.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (8)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03444 seconds Memory Usage 1,765KB 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 (3)bbcode_code_printable (8)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: