Addon for Album...

The time now is Thu 11 Dec, 2025 14:56 • All times are UTC + 1 Hour

Addon for Album...

Page 1 of 1

Xusqui

Joined: August 2006
Posts: 211
Location:

C?rdoba

Addon for Album...

Hile, Neighbours and friends...

After long time Out in "todash" I'm here again...

Today I made 2 modifications to the album for:

1.- View how many votes an image has
2.- View who rated the photo.

To do so:

Open album_showpage.php

Find

Code: [Download] [Hide]

$sql = "SELECT p.*, ac.*, u.user_id, u.username, u.user_rank, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT( DISTINCT c.comment_id) AS comments_count 

InLine After add

Code: [Download] [Hide]

, COUNT( DISTINCT r.rate_user_id) AS rate_count

Find

Code: [Download] [Hide]

$total_comments = $thispic['comments_count'];

After add

Code: [Download] [Hide]

$total_ratings = $thispic['rate_count'];

Find

Code: [Download] [Hide]

if( empty($thispic) )
 
{
 
    message_die(GENERAL_ERROR, $lang['Pic_not_exist'] . $lang['Nav_Separator'] . $pic_id);
 
}

After add

Code: [Download] [Hide]

// ------------------------------------
 
// Check users that voted
 
// ------------------------------------
 
$sql = "SELECT r.rate_user_id, u.user_id, u.username
 
        FROM " . ALBUM_RATE_TABLE . " AS r
 
            LEFT JOIN ". USERS_TABLE ." AS u on r.rate_user_id = u.user_id
 
        WHERE rate_pic_id = '$pic_id' 
 
        ORDER BY rate_user_id" ;
 
if($result = $db->sql_query($sql))
 
{
 
    if (!empty($result))
 
    {
 
        while ($users_rated = $db->sql_fetchrow($result))
 
        {
 
            $style_color = color_group_colorize_name($users_rated['user_id']);
 
            $users_that_rated .= ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $users_rated['user_id']) . '" class="gensmall">' . $style_color . '</a>, ';
 
        }
 
    }
 
    $db->sql_freeresult($result);
 
}
 
if (!$users_that_rated)
 
{
 
    $users_that_rated = '<i>' . $lang['no_one_rated'] . '</i>';
 
}
 
// ------------------------------------
 
// End Check users that voted
 
// ------------------------------------

Find:

Code: [Download] [Hide]

'PIC_COMMENTS' => $total_comments,

After add:

Code: [Download] [Hide]

        'PIC_RATINGS_COUNT' => $total_ratings,
 
        'TOTAL_USERS_VOTED' => $users_that_rated,

Find:

Code: [Download] [Hide]

'L_RATING' => $lang['Rating'],

After add:

Code: [Download] [Hide]

        'L_TOTAL_RATINGS' => $lang['total_ratings'],
 
        'L_USERS_VOTED' => $lang['users_voted'],

Open templates/*/album_showpage_body.tpl
Find:

Code: [Download] [Hide]

Before add:

Code: [Download] [Hide]

                <tr>
 
                    <td valign="top" align="right"><span class="genmed">{L_TOTAL_RATINGS}:</td>
 
                    <td valign="top" align="left"><b><span class="genmed">{PIC_RATINGS_COUNT}</b></td>
 
                </tr>
 
                <tr>
 
                    <td valign="top" align="right"><span class="genmed">{L_USERS_VOTED}:</td>
 
                    <td valign="top" align="left"><b><span class="genmed">{TOTAL_USERS_VOTED}</b></td>
 
                </tr>

Open language/*/lang_album_main.php
Find

Code: [Download] [Hide]

$lang['Album_rate_successfully'] = 'Your pic has been rated successfully';

After add

Code: [Download] [Hide]

$lang['total_ratings']='Total Rates';
 
$lang['no_one_rated'] = 'Nobody still rated';
 
$lang['users_voted'] = 'Users that already rated'; 

Save / Close All Files

I feel sorry for a new DB query... I'm sure that it could have been done without it, but I've been unable.

You can see an example here: http://www.ka-tet-corp.com/portal2.....php?pic_id=803

I've tested it on a live phpBB XS 2

____________
Icy Phoenix Latest 2.0 (working pending)
Style: Aphrodite and MG_Themes
Site: Spanish Stephen King fan forum
Mods: Medal System Mod. BBAntispam 1.2. Several own BBcodes.

Edited by Xusqui, Sun 18 Mar, 2007 08:51: Remove extra lines

#1 Sun 18 Mar, 2007 00:14

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

KugeLSichA Joined: August 2006 Posts: 803 Location: Dresden	Re: Addon for Album... great work thanks for sharing it here =) ____________ Play Games at GamesCampus!
#2 Sun 18 Mar, 2007 11:05

Xusqui

Joined: August 2006
Posts: 211
Location:

C?rdoba

Re: Addon for Album...

Little bug:

in album_showpage.php

FIND:

Code: [Download] [Hide]

, COUNT(r.rate_point) AS rate_count

Replace with:

Code: [Download] [Hide]

, COUNT( DISTINCT r.rate_user_id) AS rate_count

1st post updated!

____________
Icy Phoenix Latest 2.0 (working pending)
Style: Aphrodite and MG_Themes
Site: Spanish Stephen King fan forum
Mods: Medal System Mod. BBAntispam 1.2. Several own BBcodes.

#3 Wed 21 Mar, 2007 08:02

Mighty Gorgon Luca Libralato Joined: August 2006 Posts: 7192 Location: Borgo San Michele	Re: Addon for Album... Hi Xusqui, I'm glad to see you back again. Thanks for your modification... there is still a small bug in it... anyway I think I'll review it and add to Icy Phoenix so you don't need to fix the bug... just give me the time to test everything is needed to. ____________ Luca SEARCH is the quickest way to get support. Icy Phoenix ColorizeIt - CustomIcy - HON
#4 Thu 22 Mar, 2007 02:30

Zuker Joined: August 2006 Posts: 2134 Location: BA	Re: Addon for Album... This modification is only for php XS and maybe is not working with IcyPhoenix. If you are the author or are able to make them icy compatible, please feel free to post it. Thanks for your time and the good work so far. ____________ ? Zuker - EDDB - LPM - Sharefields
#5 Sat 07 Apr, 2007 20:50

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Thu 11 Dec, 2025 14:56 • All times are UTC + 1 Hour

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events