[NickyNet]

Originally Posted by Phalynx

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

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