[MOD] Advanced Group Management v. 1.5.3 ...:: UPDATE ::...

[killer-kurt Tim]

This is going to sound extremely n00bish lol but what does it mean by execute db_install.php? lol i mean what exactly do i have to do?

[BuByX]

This is going to sound extremely n00bish lol but what does it mean by execute db_install.php? lol i mean what exactly do i have to do?

Yea man it is...

You have to point your browser to the db_install.php file to update your tables in database!

Example:
Let say that you forum link is http://www.example.com
Than you need to write in address bar http://www.example.com/db_install.php and hit enter!

And the script will do what it is need to be done with your database, after that you just follow aslan's guidelines in mod directory (purge the cache, permissions etc.)!

Cheers!

[petesat]

I feel just as bad as the newbe before me, only I have gone just 1 step further..

I have done the install, and now get this message..

Code: Select all

Database successfully updated. Please install this mod into into the ACP/USERS AND GROUPS/ACP_ADVANCED_GROUPS
Now set permission and purge cache.

I cannot see how to install into the ACP, can someone please advise me.

Regards to all.

Pete

[petesat]

Disregard my last post..

Figured it out..

Thankyou for this mod..

Regards,

Pete

[Aslan]

Hii nice mod.

Ich have install to my live board.
Funtionality %100

Thanks for your for.

NOTE : (Are you türkish)
YOUR NAME ASLAN = LÖWE = KING

hehe... no im from slovakia and thaks for kompliment

what exactly is course of life about?

with course of life you can manage a carier on you board... when you will promote or demote any user, just go to his profile and wind one click you can promote to VIP (or other... -> setings in acp)

-----------

if you have a idea how to upgrade this mod (new features or upgrade this features) just write to this topic i read this

[Obsidian]

Is this compatible with 3.0.1?

[Aslan]

yes

[Obsidian]

Okay, I think I'll pop it onto my test board then and see if it is what I'm looking for. Looks pretty nice, too, by the way.

[AngelArvil]

Weeeeee This is what I am looking for THANKS!!!!!!!

GOOD JOB!

[..::Frans::..]

Hi there aslan,

I've found a quite annoying bug in this very nice mod. You're mod is working perfectly as long als all order_id's are next to each other.... (e.g. 1-2-3-4-5-6-7-8-9 etc.)


BUT when this order is off, because of deleting and creating groups than you have a problem.... (e.g. 12-16-23-29 etc.)

I created a solution, that works for me:

Open acp_advanced_groups.php

FIND

Code: Select all

            case 'move_up':
            case 'move_down':
                $group_id = request_var('g', '');

                $sql = 'SELECT group_order as current_order
                    FROM ' . GROUPS_TABLE . '
                    WHERE group_id = '.$group_id;
                $result = $db->sql_query($sql);
                $current_order = (int) $db->sql_fetchfield('current_order');
                $db->sql_freeresult($result);

                $switch_order_id = ($action == 'move_down') ? $current_order + 1 : $current_order - 1;

                $sql = "UPDATE " . GROUPS_TABLE . "
                    SET group_order = $current_order
                    WHERE group_order = $switch_order_id
                        AND group_id <> $group_id";
                $db->sql_query($sql);

                if ($db->sql_affectedrows())
                {
                    $sql = "UPDATE " . GROUPS_TABLE . "
                        SET group_order = $switch_order_id
                        WHERE group_order = $current_order
                            AND group_id = $group_id";
                    $db->sql_query($sql);
                }
            break;
 

REPLACE WITH

Code: Select all

            case 'move_up':
            case 'move_down':
                //What group id ?
                $group_id = request_var('g', '');

                //no group, exit
                if((int) $group_id == 0)
                {
                    exit;
                }

                $groups_ary = array();
                $assoc_index = 0;

                $sql = 'SELECT group_id, group_order
                    FROM ' . GROUPS_TABLE . '
                    ORDER BY group_order';
                $result = $db->sql_query($sql);
                $groups_ary = $db->sql_fetchrowset($result);

                $db->sql_freeresult($result);
                foreach($groups_ary as $key => $grouprow)
                {
                    if((int)$group_id == (int)$grouprow['group_id'])
                    {
                        $assoc_index = $key;
                    }
                }

                $swap_id1 = ($action == 'move_up') ? $assoc_index - 1 :  $assoc_index + 1;
                $swap_order1 = $groups_ary[$assoc_index]['group_order'];
                $swap_id2 = $groups_ary[$swap_id1]['group_id'];
                $swap_order2 = $groups_ary[$swap_id1]['group_order'];

                $sql = "UPDATE " . GROUPS_TABLE . "
                    SET group_order = $swap_id1
                    WHERE group_id = $group_id";
                //echo $sql . '<br />';
                $db->sql_query($sql);

                $sql = "UPDATE " . GROUPS_TABLE . "
                    SET group_order = $swap_order1
                    WHERE group_id = $swap_id2";
                //echo $sql . '<br />';
                $db->sql_query($sql);
            break;
 

Hope this helps...