Title: College Flag Selection v2.0

Author: John Briggs

Description:
This modification will provide an option to select a College Flag image in your member control panel.
This modification will display your selected College Flag image in your profile, control panel and threads.

Copyright:  2006 John Briggs. All rights reserved.

Compatability: XMB 1.9.8 SP3

Install Note: Before adding this modification to your forum you should back up all files related to this modification.

License Note: This modification is released under the GPL License. A copy is provided with this software.

Author Note:
You downloaded this hack from XMBGarage.com, the #1 source for XMB related downloads.
Please visit http://www.xmbgarage.com/ for support.

=======================================================================================================================================================
=======
Step 1:
=======

=============================
Go To Admin Panel -> Insert Raw SQL
=============================

Upload provided file named "SQL.txt" & click "Submit Changes" button.

=======================================================================================================================================
=======
Step 2:
=======

=================
Edit File: member.php
=================

==========
Find Code:
==========

loadtemplates(

================
Replace Code With:
================

loadtemplates(
'member_profile_college',

==========
Find Code:
==========

                $langfileselect = createLangFileSelect($SETTINGS['langfile']);

===============
Add Code Below:
===============

                // College Flag Selection Mod Begin
                $colfs = array();
                $colfs[] = '<option value="">'.$lang['collegenone'].'</option>';
                $dp = opendir(ROOT.'images/college');
                while ($file = readdir($dp)) {
                    if ($file != '.' AND $file != '..' AND $file != 'index.html') {
                        $collegename = $file;
                        $collegename = str_replace(array('.gif','.jpg','.png','_'), array('','','',' '), $collegename);
                        if ($memberinfo['college'] == $file) {
                            $colfs[] = '<option value="'.$file.'" selected="selected">'.$collegename.'</option>';
                        } else {
                            $colfs[] = '<option value="'.$file.'">'.$collegename.'</option>';
                        }
                    }
                }
                closedir($dp);
                natcasesort($colfs);
                $collegeselect = '<select name="college" onchange="document.getElementById(\'collegeimg\').src = (this.options[this.selectedIndex].value != \'\') ? \'images/college/\'+this.options[this.selectedIndex].value : \'./images/pixel.gif\';" />'.implode("\n", $colfs).'</select>';
                $collegeimg  = '<img src="'.ROOT.'images/pixel.gif" id="collegeimg" alt="" />';
                if ($memberinfo['college'] != '') {
                    $collegeimg = '<img src="'.ROOT.'images/college/'.$memberinfo['college'].'" alt="'.str_replace(array('.gif','.jpg','.png','_'), array('','','',' '), $memberinfo['college']).'" id="collegeimg" />';
                }
                // College Flag Selection Mod End

==========
Find Code:
==========

                $sig = postedVar('sig', 'javascript', ($SETTINGS['sightml']=='off'), TRUE, TRUE);

===============
Add Code Below:
===============

                // College Flag Selection Mod Begin
                $college = postedVar('college', 'javascript', TRUE, TRUE, TRUE);
                // College Flag Selection Mod End

===================
Find Code (2 instances):
===================

) VALUES ('$username',

=========================
Replace Code With (2 instances):
=========================

, college) VALUES ('$username',

=================================
Find Code At End Of Both Query Statements:
=================================

)");

===========================
Replace Code With (Both Instances):
===========================

, '$college')");

==========
Find Code:
==========

                if ($memberinfo['customstatus'] != '') {
                    $showtitle = $rank['title'];
                    $customstatus = '<br />'.censor($memberinfo['customstatus']);
                } else {
                    $showtitle = $rank['title'];
                    $customstatus = '';
                }

===============
Add Code Below:
===============

                // College Flag Selection Mod Begin
                $collegeblock = '';
                if ($memberinfo['college'] != '') {
                    $collegename = $memberinfo['college'];
                    $collegename = str_replace('.gif', '', $collegename);
                    $collegename = str_replace('_', ' ', $collegename);
                    if (file_exists(ROOT.'images/college/'.$memberinfo['college'])) {
                        $collegeimg = '<img src="./images/college/'.$memberinfo['college'].'" alt="'.$collegename.'" title="'.$collegename.'" border="0" /><br />'.$collegename;
                        $memberinfo['college'] = $collegeimg;
                        eval('$collegeblock = "'.template('member_profile_college').'";');
                    }
                }
                // College Flag Selection Mod End

=======================================================================================================================================
=======
Step 3:
=======

=================
Edit File: memcp.php
=================

==========
Find Code:
==========

        $langfileselect = createLangFileSelect($member['langfile']);

===============
Add Code Below:
===============

        // College Flag Selection Mod Begin
        $colfs = array();
        $colfs[] = '<option value="">'.$lang['collegenone'].'</option>';
        $dp = opendir(ROOT.'images/college');
        while ($file = readdir($dp)) {
            if ($file != '.' AND $file != '..' AND $file != 'index.html') {
                $collegename = $file;
                $collegename = str_replace(array('.gif','.jpg','.png','_'), array('','','',' '), $collegename);
                if ($member['college'] == $file) {
                    $colfs[] = '<option value="'.$file.'" selected="selected">'.$collegename.'</option>';
                } else {
                    $colfs[] = '<option value="'.$file.'">'.$collegename.'</option>';
                }
            }
        }
        closedir($dp);
        natcasesort($colfs);
        $collegeselect = '<select name="newcollege" onchange="document.getElementById(\'collegeimg\').src = (this.options[this.selectedIndex].value != \'\') ? \'images/college/\'+this.options[this.selectedIndex].value : \'./images/pixel.gif\';" />'.implode("\n", $colfs).'</select>';
        $collegeimg  = '<img src="'.ROOT.'images/pixel.gif" id="collegeimg" alt="" />';
        if ($member['college'] != '') {
            $collegeimg = '<img src="'.ROOT.'images/college/'.$member['college'].'" alt="'.str_replace(array('.gif','.jpg','.png','_'), array('','','',' '), $member['college']).'" id="collegeimg" />';
        }
        // College Flag Selection Mod End

==========
Find Code:
==========

        $sig = isset($_POST['newsig']) ? checkInput($_POST['newsig'], '', $SETTINGS['sightml'], '', false) : '';

===============
Add Code Below:
===============

        // College Flag Selection Mod Begin
        $newcollege = formVar('newcollege');
        $college = $newcollege ? checkInput($newcollege, 'no', 'yes', 'javascript', false) : '';
        // College Flag Selection Mod End

==========
Find Code:
==========

        $sig = addslashes($sig);

===============
Add Code Below:
===============

        // College Flag Selection Mod Begin
        $college = addslashes($college);
        // College Flag Selection Mod End

==========
Find Code:
==========

$db->query("UPDATE ".X_PREFIX."members SET $pwtxt

=======================================
Find Code In-Line At End Of Above Query Statement:
=======================================

 WHERE username='$xmbuser'");

================
Replace Code With:
================

, college='$college' WHERE username='$xmbuser'");

==========
Find Code:
==========

    if ($member['mood'] != '') {
        $member['mood'] = censor($member['mood']);
        $member['mood'] = postify($member['mood'], 'no', 'no', 'yes', 'no', 'yes', 'no', true, 'yes');
    } else {
        $member['mood'] = '';
    }

===============
Add Code Below:
===============

    // College Flag Selection Mod Begin
    if ($member['college'] != '') {
        $collegename = $member['college'];
        $collegename = str_replace('.gif', '', $collegename);
        $collegename = str_replace('_', ' ', $collegename);
        if (file_exists(ROOT.'images/college/'.$member['college'])) {
            $collegeimg = '<img src="'.ROOT.'images/college/'.$member['college'].'" alt="'.$collegename.'" title="'.$collegename.'" border="0" /><br />'.$collegename;
            $member['college'] = $collegeimg;
        }
    }
    // College Flag Selection Mod End

=======================================================================================================================================
=======
Step 4:
=======

==========================
Edit File: editprofile.php
==========================

==========
Find Code:
==========

    $langfileselect = createLangFileSelect($member['langfile']);

===============
Add Code Below:
===============

    // College Flag Selection Mod Begin
    $colfs = array();
    $colfs[] = '<option value="">'.$lang['collegenone'].'</option>';
    $dp = opendir(ROOT.'images/college');
    while ($file = readdir($dp)) {
        if ($file != '.' AND $file != '..' AND $file != 'index.html') {
            $collegename = $file;
            $collegename = str_replace(array('.gif','.jpg','.png','_'), array('','','',' '), $collegename);
            if ($member['college'] == $file) {
                $colfs[] = '<option value="'.$file.'" selected="selected">'.$collegename.'</option>';
            } else {
                    $colfs[] = '<option value="'.$file.'">'.$collegename.'</option>';
            }
        }
    }
    closedir($dp);
    natcasesort($colfs);
    $collegeselect = '<select name="newcollege" onchange="document.getElementById(\'collegeimg\').src = (this.options[this.selectedIndex].value != \'\') ? \'images/college/\'+this.options[this.selectedIndex].value : \'./images/pixel.gif\';" />'.implode("\n", $colfs).'</select>';
    $collegeimg  = '<img src="'.ROOT.'images/pixel.gif" id="collegeimg" alt="" />';
    if ($member['college'] != '') {
        $collegeimg = '<img src="'.ROOT.'images/college/'.$member['college'].'" alt="'.str_replace(array('.gif','.jpg','.png','_'), array('','','',' '), $member['college']).'" id="collegeimg" />';
    }
    // College Flag Selection Mod End

==========
Find Code:
==========

    $sig = isset($_POST['newsig']) ? checkInput($_POST['newsig'], '', $SETTINGS['sightml'], '', false) : '';

===============
Add Code Below:
===============

    // College Flag Selection Mod Begin
    $newcollege = formVar('newcollege');
    $college = $newcollege ? checkInput($newcollege, 'no', 'yes', 'javascript', false) : '';
    // College Flag Selection Mod End

==========
Find Code:
==========

    $sig = addslashes($sig);

===============
Add Code Below:
===============

    // College Flag Selection Mod Begin
    $college = addslashes($college);
    // College Flag Selection Mod End

==========
Find Code:
==========

$db->query("UPDATE ".X_PREFIX."members SET email='$email',

==================================================
Find Code In-Line At End Of Above Query Statement:
==================================================

 WHERE username='$user'");

==================
Replace Code With:
==================

, college='$college' WHERE username='$user'");

=======================================================================================================================================
=======
Step 5:
=======

=========================
Edit File: viewthread.php
=========================

==========
Find Code:
==========

            if ($post['location'] != '') {
                $post['location'] = censor($post['location']);
                $location = '<br />'.$lang['textlocation'].' '.$post['location'];
            } else {
                $location = '';
            }

===============
Add Code Below:
===============

            // College Flag Selection Mod Begin
            if ($post['college'] != '') {
                $collegename = $post['college'];
                $collegename = str_replace(array('.gif','.jpg','.png','_'), array('','','',' '), $collegename);
                if (file_exists(ROOT.'images/college/'.$post['college'].'')) {
                    $collegeimg = '<img src="'.ROOT.'images/college/'.$post['college'].'" alt="'.$collegename.'" title="'.$collegename.'" border="0" /><br />'.$collegename.'<br />';
                    $post['college'] = '<br />'.$lang['college'].' '.$collegeimg;
                }
            }
            // College Flag Selection Mod End

==========
Find Code:
==========

            $location = '';
            $mood = '';

===============
Add Code Below:
===============

            // College Flag Selection Mod Begin
            $post['college'] = '';
            // College Flag Selection Mod End

=======================================================================================================================================
=======
Step 6:
=======

=======================
Edit File: lang/English.lang.php
=======================

====================
Add Code To End Of File:
====================

// College Flag Selection Mod Begin
$lang['college'] = "College Flag:";
$lang['collegenone'] = "--Select College Flag--";
// College Flag Selection Mod End

=======================================================================================================================================
=======
Step 7:
=======

=======================================================
Go To Admin Panel -> Templates -> admintool_editprofile
=======================================================

==========
Find Code:
==========

<tr class="tablerow">
<td bgcolor="$altbg1" width="22%">$lang[textlocation]</td>
<td bgcolor="$altbg2"><input type="text" name="newlocation" size="25" value="$member[location]" /></td>
</tr>

===============
Add Code Below:
===============

<tr class="tablerow">
<td bgcolor="$THEME[altbg1]" width="22%">$lang[college]</td>
<td bgcolor="$THEME[altbg2]">$collegeselect&nbsp;<img id="collegeimg" src="./images/college/$member[college]" alt="$collegename" title="$collegename" border="0" /></td>
</tr>

=======================================================================================================================================
=======
Step 8:
=======

==========================================
Go To Admin Panel -> Templates -> member_reg_optional
==========================================

==========
Find Code:
==========

<tr class="tablerow">
<td bgcolor="$altbg1" width="22%">$lang[textlocation]</td>
<td bgcolor="$altbg2"><input type="text" name="location" size="25" value="" /></td>
</tr>

===============
Add Code Below:
===============

<tr class="tablerow">
<td bgcolor="$THEME[altbg1]" width="22%">$lang[college]</td>
<td bgcolor="$THEME[altbg2]">$collegeselect&nbsp;<img id="collegeimg" src="./images/pixel.gif" alt="$collegename" title="$collegename" border="0" /></td>
</tr>

=======================================================================================================================================
=======
Step 9:
=======

===============================================
Go To Admin Panel -> Templates -> memcp_profile
===============================================

==========
Find Code:
==========

<tr class="tablerow">
<td bgcolor="$altbg1" width="22%">$lang[textlocation]</td>
<td bgcolor="$altbg2"><input type="text" name="newlocation" size="25" value="$member[location]" /></td>
</tr>

===============
Add Code Below:
===============

<tr class="tablerow">
<td bgcolor="$THEME[altbg1]" width="22%">$lang[college]</td>
<td bgcolor="$THEME[altbg2]">$collegeselect&nbsp;$collegeimg</td>
</tr>

=======================================================================================================================================
========
Step 10:
========

=================================================
Go To Admin Panel -> Templates -> viewthread_post
=================================================

==========
Find Code:
==========

$location

===============
Add Code Below:
===============

$post[college]

=======================================================================================================================================
========
Step 11:
========

======================================
Go To Admin Panel -> Templates -> member_profile
======================================

==========
Find Code:
==========

<tr class="tablerow">
<td bgcolor="$altbg1">$lang[textlocation]</td>
<td bgcolor="$altbg2">$memberinfo[location]</td>
</tr>

===============
Add Code Below:
===============

$collegeblock

=======================================================================================================================================
========
Step 12:
========

===========================================================
Go to admin panel -> templates -> create template name -> member_profile_college
===========================================================

================================
Add Code & Click Submit Changes:
================================

<tr class="tablerow">
<td bgcolor="$THEME[altbg1]" width="22%" valign="top">$lang[college]</td>
<td bgcolor="$THEME[altbg2]">$memberinfo[college]</td>
</tr>

=======================================================================================================================================
========
Step 13:
========

=====================================
Go To Admin Panel -> Templates -> memcp_home
=====================================

==========
Find Code:
==========

<td bgcolor="$altbg1" valign="top">&nbsp;</td>
<td bgcolor="$altbg2" valign="top">&nbsp;</td>

================
Replace Code With:
================

<td bgcolor="$THEME[altbg1]" valign="top">$lang[college]</td>
<td bgcolor="$THEME[altbg2]" valign="top" align="center">$member[college]</td>

=======================================================================================================================================
========
Step 14:
========

Now upload provided folder named "/college/" to your forum "/images/" directory.

=======================================================================================================================================