Modification Title: Internet Connection Selection v1.0

Mod Author: John Briggs & FunForum

Last Updated: 02/25/09

Mod Description:
This modification will provide an option on registration to select an Internet Connection.
This modification will provide an option in member control panel to select an Internet Connection.
This modification will provide an option in admin editprofile to select an Internet Connection.
This modification will display Internet Connection in the member's profile.
This modification will display Internet Connection in the member's posts.
This modification will display Internet Connection in the member's control panel.

Supported Version: XMB 1.9.8 SP3

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

License Note: This modification is released under the GPL License.

Author Note:
For security purposes, Please Check: http://www.xmbgarage.com for the latest version of this modification.
Downloading this modification from other sites could cause malicious code to enter into your XMB Forum software.
As such, XMBGarage.com will not offer support for modifications not offered at our site.

=======================================================================================================================
=======
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_inet',

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

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

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

                $inet = postedVar('inet', 'javascript', TRUE, TRUE, TRUE);

=================
Find Code (2 Times):
=================

                $db->query("INSERT INTO ".X_PREFIX."

===========================================
Find Code In-Line In Above Query Statements:
===========================================

) VALUES ('$username'

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

, inet) VALUES ('$username'

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

)");

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

, '$inet')");

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

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

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

                // Internet Connection Selection Mod Begin
                if (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet1']) {
                    $inettxt = $lang['inet1'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet2']) {
                    $inettxt = $lang['inet2'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet3']) {
                    $inettxt = $lang['inet3'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet4']) {
                    $inettxt = $lang['inet4'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet5']) {
                    $inettxt = $lang['inet5'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet6']) {
                    $inettxt = $lang['inet6'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet7']) {
                    $inettxt = $lang['inet7'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet8']) {
                    $inettxt = $lang['inet8'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet9']) {
                    $inettxt = $lang['inet9'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet10']) {
                    $inettxt = $lang['inet10'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } elseif (!empty($memberinfo['inet']) && $memberinfo['inet'] == $lang['inet11']) {
                    $inettxt = $lang['inet11'];
                    eval('$inetblock = "'.template('member_profile_inet').'";');
                } else {
                    $inettxt = '';
                    $inetblock = '';
                }
                // Internet Connection Selection Mod End

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

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

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

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

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

        // Internet Connection Selection Mod Begin
        $newinet = formVar('newinet');
        $inet = $newinet ? checkInput($newinet, 'no', 'yes', 'javascript', false) : '';
        // Internet Connection Selection Mod End

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

        $sig = addslashes($sig);

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

        // Internet Connection Selection Mod Begin
        $inet = addslashes($inet);
        // Internet Connection Selection Mod End

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

        eval('echo stripslashes("'.template('memcp_profile').'");');

===============
Add Code Above:
===============

        // Internet Connection Selection Mod Begin
        $inet1 = $inet2 = $inet3 = $inet4 = '';
        $inet5 = $inet6 = $inet7 = $inet8 = '';
        $inet9 = $inet10 = $inet11 = '';
        if (empty($member['inet'])) {
            $inetnone = $selHTML;
        } elseif ($member['inet'] == $lang['inet1']) {
            $inet1 = $selHTML;
        } elseif ($member['inet'] == $lang['inet2']) {
            $inet2 = $selHTML;
        } elseif ($member['inet'] == $lang['inet3']) {
            $inet3 = $selHTML;
        } elseif ($member['inet'] == $lang['inet4']) {
            $inet4 = $selHTML;
        } elseif ($member['inet'] == $lang['inet5']) {
            $inet5 = $selHTML;
        } elseif ($member['inet'] == $lang['inet6']) {
            $inet6 = $selHTML;
        } elseif ($member['inet'] == $lang['inet7']) {
            $inet7 = $selHTML;
        } elseif ($member['inet'] == $lang['inet8']) {
            $inet8 = $selHTML;
        } elseif ($member['inet'] == $lang['inet9']) {
            $inet9 = $selHTML;
        } elseif ($member['inet'] == $lang['inet10']) {
            $inet10 = $selHTML;
        } elseif ($member['inet'] == $lang['inet11']) {
            $inet11 = $selHTML;
        }
        // Internet Connection 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:
==================

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

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

    eval('echo stripslashes("'.template('memcp_home').'");');

===============
Add Code Above:
===============

    // Internet Connection Selection Mod Begin
    if (!empty($member['inet']) && $member['inet'] == $lang['inet1']) {
        $inettxt = $lang['inet1'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet2']) {
        $inettxt = $lang['inet2'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet3']) {
        $inettxt = $lang['inet3'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet4']) {
        $inettxt = $lang['inet4'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet5']) {
        $inettxt = $lang['inet5'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet6']) {
        $inettxt = $lang['inet6'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet7']) {
        $inettxt = $lang['inet7'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet8']) {
        $inettxt = $lang['inet8'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet9']) {
        $inettxt = $lang['inet9'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet10']) {
        $inettxt = $lang['inet10'];
    } elseif (!empty($member['inet']) && $member['inet'] == $lang['inet11']) {
        $inettxt = $lang['inet11'];
    } else {
        $inettxt = '';
    }
    // Internet Connection Selection Mod End

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

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

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

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

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

    // Internet Connection Selection Mod Begin
    $newinet = formVar('newinet');
    $inet = $newinet ? checkInput($newinet, 'no', 'yes', 'javascript', false) : '';
    // Internet Connection Selection Mod End

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

    $sig = addslashes($sig);

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

    // Internet Connection Selection Mod Begin
    $inet = addslashes($inet);
    // Internet Connection 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:
==================

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

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

    eval('echo stripslashes("'.template('admintool_editprofile').'");');

===============
Add Code Above:
===============

    // Internet Connection Selection Mod Begin
    $inet1 = $inet2 = $inet3 = $inet4 = '';
    $inet5 = $inet6 = $inet7 = $inet8 = '';
    $inet9 = $inet10 = $inet11 = '';
    if (empty($member['inet'])) {
        $inetnone = $selHTML;
    } elseif ($member['inet'] == $lang['inet1']) {
        $inet1 = $selHTML;
    } elseif ($member['inet'] == $lang['inet2']) {
        $inet2 = $selHTML;
    } elseif ($member['inet'] == $lang['inet3']) {
        $inet3 = $selHTML;
    } elseif ($member['inet'] == $lang['inet4']) {
        $inet4 = $selHTML;
    } elseif ($member['inet'] == $lang['inet5']) {
        $inet5 = $selHTML;
    } elseif ($member['inet'] == $lang['inet6']) {
        $inet6 = $selHTML;
    } elseif ($member['inet'] == $lang['inet7']) {
        $inet7 = $selHTML;
    } elseif ($member['inet'] == $lang['inet8']) {
        $inet8 = $selHTML;
    } elseif ($member['inet'] == $lang['inet9']) {
        $inet9 = $selHTML;
    } elseif ($member['inet'] == $lang['inet10']) {
        $inet10 = $selHTML;
    } elseif ($member['inet'] == $lang['inet11']) {
        $inet11 = $selHTML;
    }
    // Internet Connection Selection Mod End

=======================================================================================================================
=======
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:
===============

            // Internet Connection Selection Mod Begin
            if (!empty($post['inet']) && $post['inet'] == $lang['inet1']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet1'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet2']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet2'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet3']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet3'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet4']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet4'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet5']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet5'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet6']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet6'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet7']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet7'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet8']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet8'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet9']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet9'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet10']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet10'];
            } elseif (!empty($post['inet']) && $post['inet'] == $lang['inet11']) {
                $inettxt = '<br />'.$lang['inet'].' '.$lang['inet11'];
            } else {
                $inettxt = '';
            }
            // Internet Connection Selection Mod End

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

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

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

            // Internet Connection Selection Mod Begin
            $inettxt = '';
            // Internet Connection Selection Mod End

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

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

====================
Find Code At End Of File:
====================

?>

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

// Internet Connection Selection Mod Begin
$lang['inet'] = 'Internet Connection:';
$lang['inetnone'] = 'None';
$lang['inet1'] = '56K modem';
$lang['inet2'] = 'ISDN';
$lang['inet3'] = 'DSL Light';
$lang['inet4'] = 'DSL';
$lang['inet5'] = 'Cable, slow';
$lang['inet6'] = 'Cable, fast';
$lang['inet7'] = 'T1';
$lang['inet8'] = 'T2';
$lang['inet9'] = 'T3';
$lang['inet10'] = 'T4';
$lang['inet11'] = 'Other';
// Internet Connection Selection Mod End

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

=================================================
Go to admin panel -> templates -> viewthread_post
=================================================

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

$location

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

$inettxt

=======================================================================================================================
=======
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>
<td bgcolor="$THEME[altbg1]" class="tablerow" width="22%">$lang[inet]</td>
<td bgcolor="$THEME[altbg2]" class="tablerow">
<select name="inet">
<option value="&nbsp;" $inetnone>$lang[inetnone]</option>
<option value="$lang[inet1]">$lang[inet1]</option>
<option value="$lang[inet2]">$lang[inet2]</option>
<option value="$lang[inet3]">$lang[inet3]</option>
<option value="$lang[inet4]">$lang[inet4]</option>
<option value="$lang[inet5]">$lang[inet5]</option>
<option value="$lang[inet6]">$lang[inet6]</option>
<option value="$lang[inet7]">$lang[inet7]</option>
<option value="$lang[inet8]">$lang[inet8]</option>
<option value="$lang[inet9]">$lang[inet9]</option>
<option value="$lang[inet10]">$lang[inet10]</option>
<option value="$lang[inet11]">$lang[inet11]</option>
</select>
</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>
<td bgcolor="$THEME[altbg1]" class="tablerow" width="22%">$lang[inet]</td>
<td bgcolor="$THEME[altbg2]" class="tablerow">
<select name="newinet">
<option value="&nbsp;" $inetnone>$lang[inetnone]</option>
<option value="$lang[inet1]" $inet1>$lang[inet1]</option>
<option value="$lang[inet2]" $inet2>$lang[inet2]</option>
<option value="$lang[inet3]" $inet3>$lang[inet3]</option>
<option value="$lang[inet4]" $inet4>$lang[inet4]</option>
<option value="$lang[inet5]" $inet5>$lang[inet5]</option>
<option value="$lang[inet6]" $inet6>$lang[inet6]</option>
<option value="$lang[inet7]" $inet7>$lang[inet7]</option>
<option value="$lang[inet8]" $inet8>$lang[inet8]</option>
<option value="$lang[inet9]" $inet9>$lang[inet9]</option>
<option value="$lang[inet10]" $inet10>$lang[inet10]</option>
<option value="$lang[inet11]" $inet11>$lang[inet11]</option>
</select>
</td>
</tr>

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

=======================================================
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>
<td bgcolor="$THEME[altbg1]" class="tablerow" width="22%">$lang[inet]</td>
<td bgcolor="$THEME[altbg2]" class="tablerow">
<select name="newinet">
<option value="&nbsp;" $inetnone>$lang[inetnone]</option>
<option value="$lang[inet1]" $inet1>$lang[inet1]</option>
<option value="$lang[inet2]" $inet2>$lang[inet2]</option>
<option value="$lang[inet3]" $inet3>$lang[inet3]</option>
<option value="$lang[inet4]" $inet4>$lang[inet4]</option>
<option value="$lang[inet5]" $inet5>$lang[inet5]</option>
<option value="$lang[inet6]" $inet6>$lang[inet6]</option>
<option value="$lang[inet7]" $inet7>$lang[inet7]</option>
<option value="$lang[inet8]" $inet8>$lang[inet8]</option>
<option value="$lang[inet9]" $inet9>$lang[inet9]</option>
<option value="$lang[inet10]" $inet10>$lang[inet10]</option>
<option value="$lang[inet11]" $inet11>$lang[inet11]</option>
</select>
</td>
</tr>

=======================================================================================================================
========
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:
===============

$inetblock

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

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

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

<tr class="tablerow">
<td bgcolor="$THEME[altbg1]" width="22%">$lang[inet]</td>
<td bgcolor="$THEME[altbg2]">$inettxt</td>
</tr>

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

============================================
Go to admin panel -> templates -> memcp_home
============================================

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

<td bgcolor="$altbg1" valign="top">$lang[textcusstatus]</td>
<td bgcolor="$altbg2" valign="top">$member[customstatus]</td>
<td bgcolor="$altbg1" valign="top">&nbsp;</td>
<td bgcolor="$altbg2" valign="top">&nbsp;</td>

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

<td bgcolor="$altbg1" valign="top">$lang[textcusstatus]</td>
<td bgcolor="$altbg2" valign="top">$member[customstatus]</td>
<td bgcolor="$THEME[altbg1]" valign="top">$lang[inet]</td>
<td bgcolor="$THEME[altbg2]" valign="top">$inettxt</td>

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