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)

MySaltyreef 01-05-2012 05:19 AM

Quote:

Originally Posted by gamersplatoon (Post 2283671)
i have tried all this but nothing is gonna work

only way it so read how to kill it(uninstall readme) you will find it in the plugin folders
cause it resets the mysql tables which has the points

and install it again. "reconfigure"

thanks, gonna give it a bash now

pantasd 01-08-2012 11:31 AM

can someone help me with thoso 2 questions ?
http://www.vbaddict.net/showthread.p...-with-referals

MySaltyreef 01-09-2012 10:48 AM

Quote:

Originally Posted by gamersplatoon (Post 2283671)
i have tried all this but nothing is gonna work

only way it so read how to kill it(uninstall readme) you will find it in the plugin folders
cause it resets the mysql tables which has the points

and install it again. "reconfigure"

didn't work for me :(

Successfulsteps 01-10-2012 03:01 AM

Quote:

Originally Posted by GPOClan (Post 2279366)
Hey,

great mod, I'm using it almost a year now, but after updating it, I get a database error:

Datenbankfehler in vBulletin 4.0.8:

Invalid SQL:
SELECT
COUNT(fid) AS iresult
FROM formresults
WHERE userid=1
AND formresults.dateline > 315532800;

MySQL-Fehler : Unknown column 'formresults.dateline' in 'where clause'
Fehler-Nr. : 1054
Fehler-Zeit : Tuesday, 20.12.2011 @ 14:08:19
Datum : Tuesday, 20.12.2011 @ 14:08:19
Skript : http://gpo-clan.com/admincp/xperienc...min_recount_xp
Referrer : http://gpo-clan.com/admincp/xperienc...php?do=recount
IP-Adresse : ?.?.?.?
Benutzername : ?
Klassenname : vB_Database
MySQL-Version : 5.1.49-3~bpo50+1-log


IP-Adress and Username censored...
Could you help me? What's the problem here?

Thanks!

I am getting that same error on vbookie integration and when I disable the vbookie, the next mod in line seems to give an error. Also my experience page is coming up with a "page not found" error.

I had upgraded to 4.1.9 and vbSEO. It was working so perfectly before! My members are not happy their points are not updating. I completely reinstalled with new upgrade here, uploaded all files again, and all the integrated plug-ins.

Any help is greatly appreciated! I do not want to do away with this mod, it is far too loved by my members and myself! So, please help me find out what is wrong.

Thank you!

Edit: the db errors are occuring on the recount of points, first option: Admincp>Experience>Recount>Update Experience Points which is required after you update to a new level as well as upgrade in this mod. So I am just presently stuck!

MySaltyreef 01-10-2012 03:47 PM

Quote:

Originally Posted by MySaltyreef (Post 2285499)
didn't work for me :(

okay its working, my bad on why i thought it wasn't, after you set the date to start it wont start your members at zero points, it takes into account of profile info, friends and alot more but if i set the date back to default you can see the huge difference in points on the members

kudo's to team, the vbekill does do the trick !

nathl123 01-11-2012 02:27 AM

i have installed vbexperience, now everytime i go to admincp/experience i get this 404 (Page Not Found) Error

Successfulsteps 01-11-2012 03:53 AM

Hi, I need help!

I am getting far too many db errors, and this mod has been through a bit. I used to have a partner on my forum who could never get it working. Well at the time I had no vbulletin knowledge. Now I have a little, and no partner. I got it working, but recently with the upgrade to 4.1.9 and vbSEO, there are far too many db errors. The strangest thing though is that if I do the recount after user 50 it works, before then while testing it on user 1 - 50, it stopped many times with db errors and all the same thing:

first the date on vbookie, then this Unknown column 'points_user_tso' in 'field list'

So I'd like to try and uninstall it completely and then do a fresh install but I do not completely understand the uninstall instructions. I do understand I must upload the kill file to the forum directory, but then it says to "run" it. How do I run it? I haven't attempted this as I want to insure I do it correctly.

Please someone give me these awesome kill instructions I am hearing about, so I can clear the db and reinstall this from scratch and hopefully fix all the problems I am having.

Thank you in advance for any assistance on instructions!

~Deb

MySaltyreef 01-11-2012 12:59 PM

i found it a bit difficult to but the instructions are actually quite easy, biggest pain in manually removing files via ftp but hey lifes not fun without any hicups ;) only thingthey not clear on was where to put the kill_xperience.php, added a note for you in red !

Quote:

/***** Uninstall *****\
- If you want to retain custom points or the shop and try a clean install you can just uninstall the product.
- To remove vBExperience completly, you will have to copy "ZIP\extras\Remove vBExperience\upload\admincp\kill_xperience.php" to AdminCP (put this in your admincp folder via ftp)and execute it. After a confirmation dialog all vBExperience tables will be completely removed. Afterwards you will have to remove the product and all files via FTP.
you'll execute the file the same way you run a upgrade to the board by typing this into your browser


http://www.1stdegreefreebies.com/for..._xperience.php ( delete this file when you done !)

follow the instructions then unistall the product via the product manager and manually remove files via ftp( not needed IMO if you gonna put it back) just make sure you upload the latest version

Successfulsteps 01-11-2012 07:49 PM

Quote:

Originally Posted by MySaltyreef (Post 2286510)
i found it a bit difficult to but the instructions are actually quite easy, biggest pain in manually removing files via ftp but hey lifes not fun without any hicups ;) only thingthey not clear on was where to put the kill_xperience.php, added a note for you in red !



you'll execute the file the same way you run a upgrade to the board by typing this into your browser


http://www.1stdegreefreebies.com/for..._xperience.php ( delete this file when you done !)

follow the instructions then unistall the product via the product manager and manually remove files via ftp( not needed IMO if you gonna put it back) just make sure you upload the latest version

Thanks so much! I was able to run that kill file. That's the part I was not understanding about putting that in my web browser. I hope not deleting the files will make a difference as I am just going to turn around and reinstall it. I'll know soon enough!

Again, thank you for you help, I really did appreciate it! It's always trying when you have several mods and they can interfere with each or conflict. But when your database somehow gets corrupted, it's often better to do a fresh install if its possible. I'll let you know if this worked to get my vbexperience running smoothly. I love the mod!


Edited: I reinstalled it. It still gives me db errors on vbookie, so I disabled that integration, and the rest ... NO DB ERRORS! I can live without the integration to vbookie, so I am happy! I hate db errors, and this way we stay error free! Thanks again!

GPOClan 01-12-2012 12:59 PM

OK, I killed and reinstalled the mod, the recount works now, but the activity is still at 0 %. Experience > Recount Activity shows no effect...

Could anyone help? :)

Successfulsteps 01-12-2012 08:42 PM

Quote:

Originally Posted by nathl123 (Post 2286334)
i have installed vbexperience, now everytime i go to admincp/experience i get this 404 (Page Not Found) Error

I am good2go, except for this same problem. My page for experience, the activity and award notifications are all bad links. Anyone know of a fix for this?

Thanks in advance for your time!

jobbe 01-13-2012 07:29 AM

I'm still having hundreds errors per day
Code:

Database error in vBulletin 4.1.9:

Invalid SQL:
SHOW COLUMNS FROM vb_xperience_stats WHERE Field='points_threads';

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Field='points_threads'' at line 1
Error Number  : 1064

Any chance to solve it?
Thanks a lot in advance.

Successfulsteps 01-13-2012 01:12 PM

Quote:

Originally Posted by jobbe (Post 2287195)
I'm still having hundreds errors per day
Code:

Database error in vBulletin 4.1.9:

Invalid SQL:
SHOW COLUMNS FROM vb_xperience_stats WHERE Field='points_threads';

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Field='points_threads'' at line 1
Error Number  : 1064

Any chance to solve it?
Thanks a lot in advance.

That's the error I was getting. I had to uninstall by using the vekill and it deletes those bad tables. I then reinstalled and only integration with vbookie was giving me those db errors. But that it is the way I fixed the others. As it sure did throw a lot of db errors on me too.

Right now I am still trying to find out how to get the experience page to show back up.

MySaltyreef 01-13-2012 03:36 PM

Quote:

Originally Posted by Successfulsteps (Post 2286669)
Thanks so much! I was able to run that kill file. That's the part I was not understanding about putting that in my web browser. I hope not deleting the files will make a difference as I am just going to turn around and reinstall it. I'll know soon enough!

Again, thank you for you help, I really did appreciate it! It's always trying when you have several mods and they can interfere with each or conflict. But when your database somehow gets corrupted, it's often better to do a fresh install if its possible. I'll let you know if this worked to get my vbexperience running smoothly. I love the mod!


Edited: I reinstalled it. It still gives me db errors on vbookie, so I disabled that integration, and the rest ... NO DB ERRORS! I can live without the integration to vbookie, so I am happy! I hate db errors, and this way we stay error free! Thanks again!

glad you came right sorry, i cant help with errors on the integrations

Successfulsteps 01-13-2012 04:48 PM

Quote:

Originally Posted by MySaltyreef (Post 2287314)
glad you came right sorry, i cant help with errors on the integrations

OH that's fine! I can live w/out 1 integration, it's not as important as the others. I just can't figure out why the experience page is coming up as not found. I am wondering if that is something in vbseo. The problem with having too many mods is it's hard to figure which one is causing somethings. I may have to get someone to take a look at my forum to fix that one.

I do appreciate your help though. I don't like seeing ANY db errors. I'd rather turn it off than have those fill up my inbox. I heard some forums don't send them to themselves, but I want to know about everyone of them, and get them fixed so my forum is optimized.

Phalynx 01-14-2012 10:32 AM

If the xperience.php is not beeing found and is 100% uploaded, than you should check your vBSEO configuration related to this.

@all
As to the SQL Errors: Did you imported the corrected and fixed Plugins from the GOLD ZIP?

gsmlover4u 01-18-2012 08:23 AM

after uninstall facing this error

Warning: require_once([path]/xperience/hooks/memberaction_dropdown.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions.php(3412) : eval()'d code on line 4

Fatal error: require_once() [function.require]: Failed opening required '/mounted-storage/home127/sub015/sc75274-IGMU/********.com/forum/xperience/hooks/memberaction_dropdown.php' (include_path='.:/usr/share/php5/') in /mounted-storage/home127/sub015/sc75274-IGMU/********.com/forum/includes/functions.php(3412) : eval()'d code on line 4

maria bartolome 01-19-2012 08:43 AM

I do with folder xperiencie??
how ?

bryanb 01-20-2012 04:27 PM

I am having an odd problem. Some members' "Achievements" are not showing up in the postbits below their rank. It has nothing to do with their user group since many other members of the same user group display achievements there. These members have achievements which are displayed in their user profile.

Does anyone have an idea how to fix this?

snowlion 01-21-2012 06:20 AM

Quote:

Originally Posted by bryanb (Post 2290239)
I am having an odd problem. Some members' "Achievements" are not showing up in the postbits below their rank. It has nothing to do with their user group since many other members of the same user group display achievements there. These members have achievements which are displayed in their user profile.

Does anyone have an idea how to fix this?

+1, mine too.

pokusek 01-21-2012 06:38 PM

I did not find an option to count points for uploaded attachments, Could you add this feature, please? Thanks.

insidegames 01-23-2012 09:29 PM

I think this doesn't works with 4.1.10

owning_y0u 01-24-2012 07:00 AM

Installed on 4.1.10 and working
Currently working on a dutch translation of it

Phoenixgal 01-25-2012 05:15 PM

I get this when trying to install

PHP Code:

Bitfield Collisionallowvideos credits_cantearn 


owning_y0u 01-28-2012 08:03 PM

small question: is it possible that i can allow 1 certain member to add awards and such.
Without adding that user to the administrator group?

khininger 01-28-2012 08:22 PM

hi

great thing, loving it, but cant figure out what am i doing wrong with advanced forum points. i installed it, see it in my products and plugins, but don't see any place to set points per forums. really wanted it, was my main reason for installing the whole experience...

also, assuming you'll help me figure out what am i doing wrong - would i be able to give achievements/awards for posting in specific forums? user A has a postcount of 100 including 1 post in forum Z, user B has a postcount of 20 including 10 posts in forum Z, so i want user B to have award "top Z-poster"?

thank you so very much, desperately waiting for a response lol

slinky 01-28-2012 10:03 PM

I was wondering if there is any way to cut down on this incredible plugin being the resource hog that it is. It's practically 1/3 the size of the entire vBulletin database. That itself is of concern. I don't really need all the daily feeds, etc. who did what, etc. They just need a few toplists and that's all. Those can and should be cached and can be updated daily and would be fine (e.g. "List as of xx/yy/zzzz).

But here's a larger issue. I started to log slow queries and this is what I saw - not even what I expected. The first two queries have been shown several times in the list. Perhaps we can put together a practices list for minimizing resources using this plugin? If it was already done, would someone be able to point me to it? Many thanks - here's my data:

# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 664253
use mysite_mysitedb;
SELECT
COUNT(*) AS cnt_ach,
i.achievementid,
a.title,
a.description,
a.imagebig
FROM xperience_achievements_issues AS i
INNER JOIN xperience_achievements AS a ON a.achievementid=i.achievementid
GROUP BY achievementid
ORDER BY COUNT(*) DESC
LIMIT 1;
# Time: 120128 14:34:46
# User@Host: mysite_myaccount[mysite_myaccount] @ [123.123.123.123]
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 664253
SELECT
COUNT(*) AS cnt_ach,
i.achievementid,
a.title,
a.description,
a.imagebig
FROM xperience_achievements_issues AS i
INNER JOIN xperience_achievements AS a ON a.achievementid=i.achievementid
GROUP BY achievementid
ORDER BY COUNT(*) ASC
LIMIT 1;
# Time: 120128 15:05:40
# User@Host: mysite_myaccount[mysite_myaccount] @ [123.123.123.123]
# Query_time: 5 Lock_time: 0 Rows_sent: 17 Rows_examined: 17
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmark sitecache','options','bitfield s','attachmentcache','forumcache','usergroupcache' ,'stylecache','languagecache', 'products','pluginlist','cron','profilefield','loa dcache','noticecache');

pantasd 01-28-2012 11:50 PM

@khininger

can you plz link me advanced forum points, i simple cant find it :(

stilly 01-29-2012 09:41 PM

Question,

I am trying to expand the bars to better fit my postbit width.

I can expand the bars by increasing the below width of 102.

Code:

div title="{vb:raw xperience.gfx_level}" style="width:102px;
Looks better, but the color within does not change to match the proportion. Where can I change the color inside the bars to match the new width of the bars ie: If a users activity is at 99% when I change the width, the color does not expand accordingly.

bryanb 01-30-2012 02:41 PM

Quote:

Originally Posted by bryanb (Post 2290239)
I am having an odd problem. Some members' "Achievements" are not showing up in the postbits below their rank. It has nothing to do with their user group since many other members of the same user group display achievements there. These members have achievements which are displayed in their user profile.

Does anyone have an idea how to fix this?

Please help with this, someone. Any assistance would be truly appreciated. Thanks!

onealien 01-31-2012 07:02 PM

how do i grant permissions for additional admins to be able to adjust settings and such?

can find where that is at...thanx

owning_y0u 02-03-2012 07:12 PM

Quote:

Originally Posted by onealien (Post 2294709)
how do i grant permissions for additional admins to be able to adjust settings and such?

can find where that is at...thanx

They need "can administer users permissions in ACP"

mjfan227 02-03-2012 09:25 PM

Very awesome mod. I love it!

shuuk 02-05-2012 12:44 PM

1 Attachment(s)
i got a problem with the glow option look at the picture i doesnt work :/
where is the problem?

can anyone help me please

JonUrban 02-05-2012 07:57 PM

I just installed this modification. It all seemed to be working, but now I am getting tons of errors, all like this:

Quote:

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT
COUNT(*) AS users
FROM xperience_stats AS x
INNER JOIN user AS u
ON u.userid=x.userid
WHERE 1=1 AND u.userid NOT IN(1, 5,);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 6
Error Number : 1064
Request Date : Sunday, February 5th 2012 @ 02:55:33 PM
Error Date : Sunday, February 5th 2012 @ 02:55:33 PM
Script : ....../forums/xperience.php?go=ranking&page=200sortfield=xl&sort order=desc&ausername=
Referrer :
IP Address : 12.12.12.12
Username : username
Classname : vB_Database
MySQL Version : 5.1.56
Can anyone help? :eek:

Can I modify the xperience.php to stop this error? I'm not sure which is exactly line 6.

JonUrban 02-06-2012 12:14 AM

Quote:

Originally Posted by JonUrban (Post 2296565)
I just installed this modification. It all seemed to be working, but now I am getting tons of errors, all like this:

Can anyone help? :eek:

Can I modify the xperience.php to stop this error? I'm not sure which is exactly line 6.

i did some testing, and the errors started when I excluded users 1, 3, and 5 from the system in the EXPERIENCE control panel applet. Once I deleted these entries, the error messages stopped.

So, it appears that the errors come from this area. No big deal. I just didn't want to hog some of the awards, because I am the top poster.

jromz03 02-07-2012 07:27 PM

Quote:

Originally Posted by bryanb (Post 2290239)
I am having an odd problem. Some members' "Achievements" are not showing up in the postbits below their rank. It has nothing to do with their user group since many other members of the same user group display achievements there. These members have achievements which are displayed in their user profile.

Does anyone have an idea how to fix this?

I'm having this problem too. 4.1.10.

it was working before but suddenly disappeared.

Phalynx 02-08-2012 11:08 AM

Quote:

Originally Posted by JonUrban (Post 2296565)
I just installed this modification. It all seemed to be working, but now I am getting tons of errors, all like this:



Can anyone help? :eek:

Can I modify the xperience.php to stop this error? I'm not sure which is exactly line 6.

Remove the last comma , from the list of ignored users.

jromz03 02-08-2012 11:25 AM

Quote:

Originally Posted by jromz03 (Post 2297247)
I'm having this problem too. 4.1.10.

it was working before but suddenly disappeared.


fixed it by clearing and resetting achievements. now its working.

stilly 02-13-2012 10:49 PM

Is this patched?

Quote:

vBExperience Module for vBulletin contains a flaw that allows a remote cross-site scripting (XSS) attack. This flaw exists because the application does not validate the 'sort' and 'sortorder' parameter upon submission to the 'xperience.php' script. This may allow a user to create a specially crafted URL that would execute arbitrary script code in a user's browser within the trust relationship between their browser and the server.
I believe this product is still vulnerable to SQL. I had to remove from my forum due to a Select Order at xperience.php. Latest version of this mod was installed.


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.04648 seconds
  • Memory Usage 1,865KB
  • 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
  • (1)bbcode_php_printable
  • (19)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