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)

HM666 02-24-2014 09:32 AM

Hello, I'm getting this DB error on this mod. For now I have disabled the Farcasters Events, but I really do need to have this working on my forum if at all possible.

Code:


Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT
                COUNT(response) AS countevents
                FROM vb4_eventattendance
                INNER JOIN vb4_event ON event.eventid = eventattendance.eventid
                WHERE response='Yes' AND userid=1
                AND event.dateline > 315532800;

MySQL Error  : Column 'userid' in where clause is ambiguous
Error Number  : 1052
Request Date  : Sunday, February 23rd 2014 @ 10:13:35 AM
Error Date    : Sunday, February 23rd 2014 @ 10:13:36 AM
Script        : /xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : /xperience_admin.php?do=recount
IP Address    : xxxxxxxxxxx
Username      : HerzeleidMeister
Classname    : vB_Database
MySQL Version : 5.5.35-cll


XiTCLUB 02-26-2014 04:47 AM

Hello, points arenot updating for me. when i am trying to "Recount" manually from admin cp its giving DB error
Code:

SELECT
                        COUNT(attachmentid) as sum_views
                        FROM _vbattachmentviewslog
                        WHERE userid=1
                        AND dateline > 315532800;

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

AND i tried skipping User ID 1 than it gives error

Code:

Invalid SQL:
SELECT
                        COUNT(attachmentid) as sum_views
                        FROM _vbattachmentviewslog
                        WHERE userid=235
                        AND dateline > 315532800;

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


M.C. 03-02-2014 09:53 PM

dam! Any chance to limit Give Away Points amount per usergroup/day? I have users with LARGE amount of points giving it away to newbies for fun and I have promotion system based on experience so all messing up.. :(

maxwolfie13 03-20-2014 07:42 AM

Does anyone know which phrases need to be changed in order to change all references of "Points" to "Experience" (as in experience/XP in games)... there seems to be a lot of phrases that have the word "Points" in them and I don't want to change anything that's not vBExperience specific.

undertable99 03-20-2014 05:52 PM

Hi right after installation, I have recieved this error :

Quote:

Deprecated: Assigning the return value of new by reference is deprecated in /home/undertable99/undertable99forum.com/admincp/xperience_admin.php on line 160

Deprecated: Assigning the return value of new by reference is deprecated in /home/undertable99/undertable99forum.com/admincp/xperience_admin.php on line 240

Deprecated: Assigning the return value of new by reference is deprecated in /home/undertable99/undertable99forum.com/admincp/xperience_admin.php on line 342

Deprecated: Assigning the return value of new by reference is deprecated in /home/undertable99/undertable99forum.com/admincp/xperience_admin.php on line 385

Deprecated: Assigning the return value of new by reference is deprecated in /home/undertable99/undertable99forum.com/admincp/xperience_admin.php on line 538

Deprecated: Assigning the return value of new by reference is deprecated in /home/undertable99/undertable99forum.com/admincp/xperience_admin.php on line 641

Deprecated: Assigning the return value of new by reference is deprecated in /home/undertable99/undertable99forum.com/admincp/xperience_admin.php on line 1682

Deprecated: Assigning the return value of new by reference is deprecated in /home/undertable99/undertable99forum.com/admincp/xperience_admin.php on line 1848
I wonder have i done anything wrong?

And the postbit bars are not align and its on the left than being in center. Would anyone care to shed some lights?

Deeply appreciate the help from you gurus=)

undertable99

HM666 03-21-2014 12:41 AM

Quote:

Originally Posted by maxwolfie13 (Post 2488530)
Does anyone know which phrases need to be changed in order to change all references of "Points" to "Experience" (as in experience/XP in games)... there seems to be a lot of phrases that have the word "Points" in them and I don't want to change anything that's not vBExperience specific.

An easy way to find what phrases deal with just the vBExperience mod is when you go into "Search for Phrases" put in the following:

Search For Text: Points
Product: vBExperience
Search in...: tick Phrase Text and Phrase Variable Name

Click "Find"

this should render only the word points related to the mod.

krimznheidiz 03-21-2014 12:44 AM

I think the developer need to do some modification to suit 4.2.2 :)

Tibiaspy 04-02-2014 05:40 PM

Quote:

Originally Posted by MySaltyreef (Post 2479618)
use the standard vb promotions dude
cpanel>usergroups>promotions

and work with your user groups or you can use user ranks or user titles

As I said in my post - is there any OTHER way to do it besides the one I mentioned which is the one you also posted. Please read carefully. I don't want to be playing around with dozens of groups.

Drache 04-03-2014 01:50 AM

Hi this is very nice mod. however I'd like to do a clean install so I wanted to remove xperience.php first.

I've followed the uninstall instruction and also ran the kill script kill_xperience.php

However after I click on do it kill_xperience.php?do=kill

Then it just showing the word Remove vBExperience but nothing else is showing. and I checked the database all the databases are still there.

Did I do something wrong?

ccmoon 04-03-2014 03:04 AM

have anyone successfully installed this mod with vb4.2.2?


All times are GMT. The time now is 09:53 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.03744 seconds
  • Memory Usage 1,747KB
  • 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_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
  • (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