vb.org Archive

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)

Phalynx 07-20-2010 11:01 AM

Quote:

Originally Posted by KURTZ (Post 2071945)
http://www.fniv.it/board/experience/stats/

just installed, now i got the paypal donations ... (never done a donation onto my board) ... also i can't create a specific award for this plug-in (i haven't the field in the ACP)

Christian, that is just the phrase, a copy&paste error. As for the points, please PM me a temporary account with execute SQL permissions. Thanks for offer.

Quote:

Originally Posted by capt gary (Post 2071947)
Is there a way to issue different point values based on which forum the thread is created or responded in?

In other words I'd like to offer different point values for creating or answering a thread in a forum that deals with information and still other points value for creating or responding in a general chatty forum thread.

Thanks,
Capt Gary

Yes. You need to install the plugin Advanced Forum Points, which is included in ZIP\extras\Addons\advanced_forum_points.xml

KURTZ 07-20-2010 11:10 AM

Quote:

Originally Posted by Phalynx (Post 2071956)
Christian, that is just the phrase, a copy&paste error. As for the points, please PM me a temporary account with execute SQL permissions. Thanks for offer.

check your box :)

edit: ps. it would be great if we can give a specific award to our users for a specific league (not only for the overall) ... do you think that's possible?

Phalynx 07-20-2010 12:00 PM

Quote:

Originally Posted by KURTZ (Post 2071958)
check your box :)

Thanks. Tracked down and fixed! I've already installed the working version on your board.

Quote:

Originally Posted by KURTZ (Post 2071958)
it would be great if we can give a specific award to our users for a specific league (not only for the overall) ... do you think that's possible?

Uhm, sounds a bit difficult, as the leagues are variable.
I suggest to create an award for each finished league and assign that award manually to the winner. That way you override the automatic assign.

RollaJedi 07-20-2010 12:43 PM

Quote:

Originally Posted by RollaJedi (Post 2071699)
I apologize if this has been answered, but i have installed this now and its wonderful! The only problem i see though is my forum has been open for at least 5 years now so there are many members that have lots of posts and they registered way back when. Even people that havent got nearly as much or are kinda newer than that ALL are almost to reach level 100 or have done so already. Thats no fun. Is there a way for me to increase how many points it takes to go up to the next level? Thank you

Quote:

Originally Posted by Phalynx (Post 2071703)
Maybe you missed the part about installing, espacially the part "3. Import a level product "vbexperience_level_1_?.xml" (see readme "Levels")."

There are instructions in the readme_levels.txt which level file should be imported. There are different level definitions as there are incomparable forums out there.

actually i did do that. My top users are all at level 100, even my not quite tops are averaging 95-97. I have the smallest level xml you have available. My site is around 300 people. What would you suggest? Thanks

Phalynx 07-20-2010 01:02 PM

Take level 3 and recount.

miyuki 07-20-2010 01:03 PM

Quote:

Originally Posted by Phalynx (Post 2071615)
Does Katsue have already an award and max. awards for this user have been reached? Is Katsue in a group being ignored, like Administrators?

OK, my bad, Katsue is in the administrator group... thanks for the hints to solve my problem

KURTZ 07-20-2010 06:44 PM

Quote:

Originally Posted by Phalynx (Post 2071978)
Thanks. Tracked down and fixed! I've already installed the working version on your board.


Uhm, sounds a bit difficult, as the leagues are variable.
I suggest to create an award for each finished league and assign that award manually to the winner. That way you override the automatic assign.

Thanks Marius, as always you rock mate! ;)

about the league awards, if you can give me something like i need i can send you a "gift" ... just tell me ...

NickyNet 07-21-2010 09:57 AM

Quote:

Originally Posted by Phalynx (Post 2071937)
I've attached two plugins for vBExperience 4.

- vBSoccer aka Fussball Tippspiele
- vBookie

The plugins are untested, as I don't have the live data for them.

Please install the attached XML Products and run a recount. Awaiting feedback.


hi Phalynx..

thank you for the plugin vBSoccer... :up:

when i would like to recount "Update Experience points"
will receive this mysql error only when vBSoccer is active

Code:

Database error in vBulletin 4.0.5:

Invalid SQL:

        SELECT u.userid,
            (_wr * 0) +
            ((_count - _wr - _rr - _rd) * 1) +
            (_rd * 2) +
            (_rr * 3) AS points
        FROM (
            SELECT userid, COUNT(*) AS _count,
                SUM(score_key != bet_score_key) AS _wr,
                SUM(bet_home=points_home AND bet_away=points_away) AS _rr,
                SUM(CAST(bet_home - bet_away AS SIGNED)=(points_home - points_away)
                    AND NOT (bet_home = points_home AND bet_away = points_away)) AS _rd
            FROM vb_soccer_user_bet AS b
            INNER JOIN vb_soccer_match AS m ON(m.id=b.match_id)
            WHERE userid=1 AND score_key>0
            GROUP BY userid) AS userpoints
        INNER JOIN user AS u USING(userid)
        ORDER BY points DESC, username;

MySQL Error  : Table 'xxxx_db.user' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, July 21st 2010 @ 12:52:53 PM
Error Date    : Wednesday, July 21st 2010 @ 12:52:54 PM
Script        : http://xxxxxxx/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : http://xxxxxx/admincp/xperience_admin.php?do=recount
IP Address    : xxxxxxxxxxxxxxx
Username      : Nicky
Classname    : vB_Database
MySQL Version : 5.0.32-Debian_7etch6-log


Phalynx 07-21-2010 10:05 AM

Fixed, please redownload here:
https://vborg.vbsupport.ru/showthrea...37#post2071937

KURTZ 07-21-2010 10:18 AM

Quote:

Originally Posted by Phalynx (Post 2072383)

i need to do it Marius?


All times are GMT. The time now is 09:22 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03438 seconds
  • Memory Usage 1,756KB
  • 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
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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