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?

NickyNet 07-21-2010 10:47 AM

Quote:

Originally Posted by Phalynx (Post 2072383)

thank you... worked like a charm! :up:

Phalynx 07-21-2010 11:06 AM

Quote:

Originally Posted by KURTZ (Post 2072385)
i need to do it Marius?

No, as you are not using DB Prefix.

Quote:

Originally Posted by NickyNet (Post 2072392)
thank you... worked like a charm! :up:

Nice :)

AA_ 07-21-2010 12:14 PM

@phalynx

the query should you change:

Code:

SELECT userid,
        (_wr * " . (int) $vbulletin->options['vbsoccer_points']['wr'] . ") +
        ((_count - _wr - _rr - _rd) * " . (int) $vbulletin->options['vbsoccer_points']['rw'] . ") +
        (_rd * " . (int) $vbulletin->options['vbsoccer_points']['rd'] . ") +
        (_rr * " . (int) $vbulletin->options['vbsoccer_points']['rr'] . ") 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 " . TABLE_PREFIX . "soccer_user_bet AS b
        INNER JOIN " . TABLE_PREFIX . "soccer_match AS m ON(m.id=b.match_id)
        WHERE userid=" . $user['userid'] . " AND score_key>0 AND match_is_finished=1
        GROUP BY userid) AS userpoints

(der join auf die usertabelle ist nicht notwendig und das sortieren ebensowenig. ausserdem werden nur abgeschlossene spiele ber?cksichtigt. beachte, dass "u.userid" zu "userid" wird. am besten du kopierst das komplette query.)

Phalynx 07-21-2010 12:24 PM

Quote:

Originally Posted by AA_ (Post 2072414)
the query should you change:

Thanks for your optimization hints, I appreciate it.

@KURTZ
Now you should update :)

Download:
https://vborg.vbsupport.ru/showthrea...37#post2071937

NickyNet 07-21-2010 12:35 PM

Quote:

Originally Posted by AA_ (Post 2072414)
@phalynx

the query should you change:

(der join auf die usertabelle ist nicht notwendig und das sortieren ebensowenig. ausserdem werden nur abgeschlossene spiele ber?cksichtigt. beachte, dass "u.userid" zu "userid" wird. am besten du kopierst das komplette query.)

wie ?blich :up:

have 782 points at vbsoccer... got 7820 points into vBExperience
thank you 2 both of you!

AA_ 07-21-2010 12:36 PM

Quote:

Originally Posted by Phalynx (Post 2072417)
Thanks for your optimization hints, I appreciate it.

@KURTZ
Now you should update :)

Download:
https://vborg.vbsupport.ru/showthrea...37#post2071937

noch eine kleine speicheroptimierung (das ganze mit query_first() also limit 1 und automatischem free(). beachte die verwendung der variablen $att statt $attq; userid habe ich gleich mit entfernt, wird nicht ben?tigt):

Code:

if (($att = $vbulletin->db->query_first("
                SELECT (_wr * " . (int) $vbulletin->options['vbsoccer_points']['wr'] . ") +
                ((_count - _wr - _rr - _rd) * " . (int) $vbulletin->options['vbsoccer_points']['rw'] . ") +
                (_rd * " . (int) $vbulletin->options['vbsoccer_points']['rd'] . ") +
                (_rr * " . (int) $vbulletin->options['vbsoccer_points']['rr'] . ") 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 " . TABLE_PREFIX . "soccer_user_bet AS b
                INNER JOIN " . TABLE_PREFIX . "soccer_match AS m ON(m.id=b.match_id)
                WHERE userid=" . $user['userid'] . " AND score_key>0 AND match_is_finished=1
                GROUP BY userid) AS userpoints
        ")))
{
        $xperience['count_user_vbs'] = $att['points'] * $vbulletin->options['xperience_points_vbs'];
        $xperience['count_user'] += $xperience['count_user_vbs'];
}


Phalynx 07-21-2010 01:06 PM

@All
The file has been updated!

@AA_
Habs eingebaut, danke.

KURTZ 07-21-2010 06:05 PM

Quote:

Originally Posted by Phalynx (Post 2072417)
Thanks for your optimization hints, I appreciate it.

@KURTZ
Now you should update :)

Download:
https://vborg.vbsupport.ru/showthrea...37#post2071937

done :)

NickyNet 07-21-2010 06:33 PM

just 4 info:

table: xperience_achievements_issues want be emptied if you delete all your stats in admincp after you "played" with the point settings...

Aramist 07-22-2010 03:54 AM

Hi , ty for this great mod.

I have installed this mod today on my board, and all member's activity is 99%+

Is it correct?

Ty in advance

NickyNet 07-22-2010 06:18 AM

1 Attachment(s)
here another 2 plugins
points for vBGallery (v. > 3) and 8WR Media Library (v. 4.1.1)

Phalynx 07-22-2010 06:51 AM

Quote:

Originally Posted by Aramist (Post 2072731)
Hi , ty for this great mod.

I have installed this mod today on my board, and all member's activity is 99%+

Is it correct?

Ty in advance

Give the activity system a few days to collect the data it requires.

Quote:

Originally Posted by NickyNet (Post 2072777)
here another 2 plugins
points for vBGallery (v. > 3) and 8WR Media Library (v. 4.1.1)

Great, thanks! Included in official ZIP.

Phalynx 07-22-2010 06:51 AM

The vBExperience 4 GOLD Release has been refreshed! The ZIP includes now more Plugins to collect points with:

- Photopost Pro Gallery 7. Keep in mind that this only works if the vBulletin Database is beeing used.
- PhotoPost vBGallery 3, thanks to NickyNet
- 8WR Media Library, thanks to NickyNet
- vBSoccer, thanks to AA_
- vBookie

You can find all 19 plugins in ZIP\extras\Addons. Install the plugins as you would install vBulletin Addons.

There is no need to reinstall/overwrite.

KURTZ 07-22-2010 08:45 AM

thanks Marius, just a Q: the who's download plug-in was made for this product? https://vborg.vbsupport.ru/showthread.php?t=237489

Rene Kriest 07-22-2010 08:51 AM

Great! I love to see vbsoccer included. Thx!

tekram 07-22-2010 09:13 AM

Great Add-On. Many thy for this :)

DS MrSinister 07-22-2010 01:19 PM

Phalynx,

So we don't need another point system. What do you need to make this fully integrated with vbookie?

Phalynx 07-22-2010 02:40 PM

Quote:

Originally Posted by DS MrSinister (Post 2072903)
Phalynx,

So we don't need another point system. What do you need to make this fully integrated with vbookie?

There is already a plugin for vBookie.

DS MrSinister 07-22-2010 03:19 PM

Sorry Mate its not working for me. i can't use my vBExperience points. only way it works if i select vcash in Cash/Points System option in the vbookie setting.

Phalynx 07-22-2010 05:28 PM

Ok, that way it doesn't work. I thought you mean collecting points via bets. Let's see how this can be accomplished.

Arae 07-23-2010 02:52 AM

http://i30.tinypic.com/6iqh6f.jpg

^ How can I remove the three colored bars in the postbit? I'm exploring the template codes but I'm unsure.
It looks pretty but my userinfo-postbit has a lot of things in it like big badges, so I like to remove the three colorfulbars (blue, orange and green)
I just want to remove it in postbit, but I like it to stay in my profile. :)

Thanks :)

newmomsforum 07-23-2010 04:12 AM

Thanks for a great mod ;)

BrightStar 07-23-2010 08:23 PM

If a gift is sent to a user, it shows a Default Category box in postbit, how to change the name of Default Category to something like Gifts?

Also how do I utilise the extra icons which have been provided? Do I just upload them in the images folder of vbexperience and they will appear by default or have to create new items one by one?

stwan 07-24-2010 08:55 AM

in xperience.php?go=groups bug?

https://vborg.vbsupport.ru/

stwan 07-24-2010 09:14 AM

In template xperience_groups_ranking superfluous </div>:

HTML Code:

<th><a style="text-align:right;" class="blocksubhead" href="{vb:raw sorturl}{vb:if !$show['sorturlnoargs'], '&amp;'}order={vb:raw oppositesort}&amp;sort=members&amp;pp={vb:raw perpage}">{vb:rawphrase members} {vb:raw sortarrow.xperience_activity}</a>[B]</div>[/B]</th>

stwan 07-24-2010 09:17 AM

In template for xhtml 1.0 valid:

HTML Code:

<img align="left" style="margin-right:5px;" width="{vb:raw myawards.awardxy}" height="{vb:raw myawards.awardxy}" border="0" src="{vb:raw vboptions.bburl}/xperience/icons/{vb:raw myawards.awardurl}" title="{vb:raw myawards.awardtitle}" />
replace on:
HTML Code:

<img align="left" style="margin-right:5px;" width="{vb:raw myawards.awardxy}" height="{vb:raw myawards.awardxy}" border="0" src="{vb:raw vboptions.bburl}/xperience/icons/{vb:raw myawards.awardurl}" title="{vb:raw myawards.awardtitle}" alt="" />

NickyNet 07-24-2010 11:30 AM

1 Attachment(s)
here another 2 plugins
points for vBGallery Comments (v. > 3) and 8WR Media Library Comments (v. 4.1.1)
standard points set to "5"

KProjects 07-24-2010 12:29 PM

Is it possible to use points you earn with this and bet them with vbookie or do you just earn points for betting?

NickyNet 07-24-2010 12:43 PM

1 Attachment(s)
here another one for vBSoccer :)

Quote:

INFORMATION:
vBSoccer.xml plugin fetch only Points from vBSoccer for specific user which they reach there.
With this plugin there is a possibility to give users points in vBExperience for everyone bet they done in vBSoccer.
Standard Point for every bet is set to 1.
Thank you to AA_ and Phalynx for both great Add-ons!

Hall of Famer 07-24-2010 05:20 PM

I got this after uninstalling VBexperience 3.8 while importing the xml files for VBexperience 4.0:

Quote:

Fatal error: Cannot redeclare dodropcolumns() (previously declared in /home7/pkmnhofc/public_html/forum/includes/functions_xperience.php:529) in /home7/pkmnhofc/public_html/forum/includes/install_xperience.php on line 32
Whats that supposed to mean? Please help...


All times are GMT. The time now is 10:54 AM.

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.02606 seconds
  • Memory Usage 1,860KB
  • 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
  • (3)bbcode_html_printable
  • (23)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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