vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - vBExperience 3.8 (https://vborg.vbsupport.ru/showthread.php?t=199556)

Antiblank 12-30-2009 10:17 PM

So far the only issue I'm having using this with vb4 is on the profile page, the data appears twice. Once on the Experience tab and again on the Visitor Messages tab far far down the page at the bottom.

While I would love to see a new version I'm not so sure its going to happen given the author has logged into his own site he lists here since Nov. either.

arieltete 12-31-2009 02:02 PM

i cant remove it 0.0 its says:
"
for a complete kill use ZIP\extras\Remove vBExperience\upload_via_ftp\admincp\kill_xperience .php
"

where is it?
WTF?!

Antiblank 12-31-2009 02:13 PM

Quote:

Originally Posted by arieltete (Post 1943395)
i cant remove it 0.0 its says:
"
for a complete kill use ZIP\extras\Remove vBExperience\upload_via_ftp\admincp\kill_xperience .php
"

where is it?
WTF?!

Still in the Zip file you downloaded. Look in the extras directory and you'll see the rest of the directories. All you need to do is follow it, see how it says upload_via_ftp.

arieltete 12-31-2009 02:47 PM

i put it there now what 0.0
how i execute it ..

Trek 12-31-2009 06:07 PM

Quote:

Originally Posted by arieltete (Post 1943441)
i put it there now what 0.0
how i execute it ..

You GET it from the zip file and upload it to your admincp folder.

then you access by going to: www.yourdomain.com/admincp/kill_xperience.php

or whatever the proper path for your admincp folder is.

Nadeemjp 01-01-2010 09:44 PM

dear phalynx
i am having this error which i didnt have before:

Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT
u.userid,
points_user_activity+points_user_albumpictures+poi nts_misc_ibparcadechamps+points_user_law+points_po st_attachment+points_post_attachment_views+points_ post_avg+points_misc_events+points_misc_custom+poi nts_misc_dla+points_post_den+points_misc_ds_vbexp+ points_misc_dl2+points_xperience+points_user_profi le+points_user_friends+points_post_thanks_got_tota l+points_post_thanks_got_post+points_user_infracti ons+points_misc_ldm+points_misc_ppd+points_user_on line+points_misc+points_post+points_user+points_th read+points_posts+points_user_referrals+points_thr ead_replycount+points_user_reputation+points_threa ds_sg+points_posts_sg+points_user_socialgroup+poin ts_thread_stickies+points_thread_tags+points_threa ds+points_user_reputation_use+points_post_thanks_u se+points_post_thanks_used+points_thread_views+poi nts_user_visitormessages+points_thread_votes+point s_misc_cdp+points_misc_ppg+points_post_group_discu ssion+points_thread_group_discussion+points_misc_v bblog+points_post_thanks
AS get_count
FROM xperience_stats as s
INNER JOIN user as u ON u.userid = s.userid
WHERE 1 = 1 AND NOT (1=2 )
ORDER BY get_count DESC, points_xperience DESC
LIMIT 1,1;

MySQL Error : Unknown column 'points_misc_ds_vbexp' in 'field list'
Error Number : 1054
Request Date : Friday, January 1st 2010 @ 01:41:20 AM
Error Date : Friday, January 1st 2010 @ 01:41:21 AM
Script : http://www.familybunker.com/forums/c...and=1262331678
Referrer : http://www.familybunker.com/forums/
IP Address : 110.37.34.17
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
can you tell me please why is this happening and how can i get rid of it?

Nadeemjp 01-01-2010 11:46 PM

Also whenever i try to recount, when it processes the awards, it gives the following error:
Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT
u.userid,
points_post_avg+points_post_den+points_misc_dl2+po ints_xperience+points_post_thanks_got_total+points _post_thanks_got_post+points_misc+points_post+poin ts_user+points_thread+points_posts+points_thread_r eplycount+points_thread_stickies+points_thread_tag s+points_threads
AS get_count
FROM xperience_stats as s
INNER JOIN user as u ON u.userid = s.userid
WHERE 1 = 1 AND NOT (1=2 )
ORDER BY get_count DESC, points_xperience DESC
LIMIT 1,1;

MySQL Error : Unknown column 'points_post_den' in 'field list'
Error Number : 1054
Request Date : Friday, January 1st 2010 @ 07:45:10 PM
Error Date : Friday, January 1st 2010 @ 07:45:13 PM
Script : http://www.familybunker.com/forums/a...at=1601&pp=200
Referrer : http://www.familybunker.com/forums/a...at=1401&pp=200
IP Address : ******
Username :*****
Classname : vB_Database_MySQLi
MySQL Version : 5.1.30
please your support is required

Furthermore, I cant even delete the awards.
it gives the following error:
Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT
u.userid,
points_post_avg+points_post_den+points_misc_dl2+po ints_xperience+points_post_thanks_got_total+points _post_thanks_got_post+points_misc+points_post+poin ts_user+points_thread+points_posts+points_thread_r eplycount+points_thread_stickies+points_thread_tag s+points_threads
AS get_count
FROM xperience_stats as s
INNER JOIN user as u ON u.userid = s.userid
WHERE 1 = 1 AND NOT (1=2 )
ORDER BY get_count DESC, points_xperience DESC
LIMIT 1,1;

MySQL Error : Unknown column 'points_post_den' in 'field list'
Error Number : 1054
Request Date : Friday, January 1st 2010 @ 07:51:50 PM
Error Date : Friday, January 1st 2010 @ 07:51:51 PM
Script : http://www.familybunker.com/forums/a...=saveaawardcat
Referrer : http://www.familybunker.com/forums/a...tawardcat&id=4
IP Address : ******
Username : ****
Classname : vB_Database_MySQLi
MySQL Version : 5.1.30

sailnet 01-02-2010 01:48 PM

I wonder if anyone could help me create a custom data provider for this mod. I don't think it would be that difficult. I want to give points to users who have loaded images to a "specially named" Photo Album Using vb's Album Feature.

sailnet 01-02-2010 05:02 PM

Quote:

Originally Posted by shaqoneal (Post 1921046)
Phalynx - my PhotoPost is in a database different from vbulletin so the PhotoPost Pro add-on does not work. Can you please modify the plugin so that it can connect and pull data from the PhotoPost Pro database? It would be much appreciated.

mine is too - so I did a little digging and found that if you go to :
---> Plugin Manager and edit:
---> vBExperience PhotoPost Pro Integration xperience_calcdata

and change the code to the following (assuming you put in your photopost database name, username and password) it will work:


PHP Code:

if (($vbulletin->options['xperience_points_ppprogali'] > 0) OR ($vbulletin->options['xperience_points_ppprogalv'] > 0))
{
    if (
$DoDebug == 1) echo "<br/>PhotoPost Pro Images and Image Views";

    
$connection mysql_connect("localhost""root""password") or die ("Unable to connect!");
    
mysql_select_db("photopost_database_name") or die ("Unable to select database!");            
    
$queryq "select COUNT(id) as cnt_images, sum(views) as sum_views from photos where  WHERE userid=".$user['userid']." GROUP BY userid";        
    if (
mysql_num_rows($queryq) > 0)
    {
        
$query mysql_fetch_array($queryq);
                
        if (
$vbulletin->options['xperience_points_ppprogali'] > 0)
        {
            
$xperience['count_misc_ppprogali'] = $query['cnt_images'] * $vbulletin->options['xperience_points_ppprogali'];
            
$xperience['count_misc'] += $xperience['count_misc_ppprogali'];
            
$additionalsql .= "points_misc_ppprogali=".$xperience['count_misc_ppprogali'].",";
        }
        
        if (
$vbulletin->options['xperience_points_ppprogalv'] > 0)
        {
            
$xperience['count_misc_ppprogalv'] = $query['sum_views'] * $vbulletin->options['xperience_points_ppprogalv'];
            
$xperience['count_misc'] += $xperience['count_misc_ppprogalv'];
            
$additionalsql .= "points_misc_ppprogalv=".$xperience['count_misc_ppprogalv'].",";
        }
        
    }
    
mysql_close($connection);



sailnet 01-03-2010 12:34 PM

what I don't see which is very important on my forum is points for uploading attachment.

am I missing that?


All times are GMT. The time now is 01:09 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.03229 seconds
  • Memory Usage 1,777KB
  • 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_php_printable
  • (6)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