vb.org Archive - Add-On Releases

Dear Phalynx you say : Did you purchased the item?

me and user can't see any icon that click and purchased it .

me use test.gif for icon but i have problem in this hack.:(

please visit post at my forum .

car20

07-06-2008 11:19 AM

dear Phalynx
why you have in this page tree icon by the names ( Ranking and shop and Statistics ) but me have just ranking ?

Ideal Web Tech

07-06-2008 11:53 AM

PHP Code:


		
			
        //Albumpictures
        $albumfield="visible";
        if ($this->field_exists('album', 'picturecount')) $albumfield="picturecount";

        if ($DoDebug==1) echo "<br/>Albumpictures";
        if ($vbulletin->options['xperience_points_pc'] > 0) 
        {    
            $vmessagesq =$vbulletin->db->query_read("SELECT 
            COUNT($albumfield) AS cnt_pictures
            FROM " . TABLE_PREFIX . "album
            WHERE userid=".$user['userid']);
    
            if ($vbulletin->db->num_rows($vmessagesq) > 0)
            {
                $vmessages = $vbulletin->db->fetch_array($vmessagesq);
                $xperience['count_user_albumpictures'] = $vmessages['cnt_pictures']*$vbulletin->options['xperience_points_pc'];
            } 
        }

Correct me if im wrong but shouldnt that be a sum not a count as you just made it now give points for each album instead of each picture (I could be wrong I am calling this from my memory for what I changed last time to fix it originally and I havent slept in 2-3 days). But from what I do remember that should be a SUM if I am remembering the table structure properly.

Phalynx

07-06-2008 12:57 PM

Quote:

Originally Posted by car20 (Post 1568067)

Quote:

Originally Posted by car20 (Post 1568075)

dear Phalynx
why you have in this page tree icon by the names ( Ranking and shop and Statistics ) but me have just ranking ?

there are NO icons in postbit if you don't purchased something. It seems you didn't have updated all files from ZIP on server, you are using an outdated xperience.php.

Quote:

Originally Posted by Ideal Web Tech (Post 1568097)

It is just me or is the album pictures code wrong again? (im in the hospital right now on some strong pain meds and havent tested the code was just reading thro it but I believe that currently it only counts how many albums a user has and not how many pictures)

Correct me if im wrong but shouldnt that be a sum not a count as you just made it now give points for each album instead of each picture (I could be wrong I am calling this from my memory for what I changed last time to fix it originally and I havent slept in 2-3 days). But from what I do remember that should be a SUM if I am remembering the table structure properly.

Yes, it should be a sum. What a pity nobody see this in betatest :(
Will correct this in 3.7.16

Dr. Bantham

07-06-2008 01:35 PM

Quote:

Originally Posted by Phalynx (Post 1568033)

Your SQL Statement is wrong:

PHP Code:


		
			
        SUM(counter) as sum_quotes

        FROM " . TABLE_PREFIX . "quotes

        WHERE userid=".$user['userid']);

counter seems not a column of the quotes table.

Many thanks! I changed it to the following and it seems to be working flawlessly:

PHP Code:


		
			
        SUM(quotecount) as sum_quotes

        FROM " . TABLE_PREFIX . "user

        WHERE userid=".$user['userid']);

I also made some changes to the labeling where I had not changed the default expressions. I am attaching the final file in case anyone is interested.

Phalynx

07-06-2008 01:38 PM

Thanks for sharing. It would be great to see this as an addin for vBExperience like Ideal Web Tech's addons.

car20

07-06-2008 03:50 PM

Dear Phalynx
i uploaded again all files .
where appear shop picture ?
if user to want buy a something where they must to go ?

msvi007

07-06-2008 04:02 PM

I have it working on our site fabulously, thank you. www.uofmom.com

One question though, what determines the order the icons appear in the postbit. Our users buy them in a specific order, but they seem to appear in a different order. Any help would be greatly appreciated on how to make them appear in postbit in the order they were purchased or if you could let me know how to re-arrange them for specific users.

thanks

AWF	07-06-2008 04:13 PM

will this work with the vBExperience mod??

All times are GMT. The time now is 09:05 AM.

Page 135 of 265

135

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03071 seconds Memory Usage 1,763KB 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_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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
Messages: