Mod Title: Internet Connection Selection v1.0

Mod Author: John Briggs & FunForum

Last Updated: 04/10/06

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

Supported Version: XMB 1.9.5 Nexus Final

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

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

Author Note:
For security purposes, Please Check: http://www.xmbxtreme.com for the latest version of this mod.
Downloading this mod from other sites could cause malicious code to enter into your XMB Forum software.
As such, XMBXtreme.com will not offer support for mods not offered in our mod forum.

=======================================================================================================================
=======
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           = checkInput($_POST['sig']);

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

        $inet           = isset($inet) ? checkInput($inet, '', '', 'javascript', false) : '';

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

        $locationnew   = addslashes($locationnew);

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

        $inet	= addslashes($inet);

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

        $db->query("INSERT INTO $table_members (uid,

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

) VALUES ('', '$username'

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

, inet) VALUES ('', '$username'

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

)");

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

, '$inet')");

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

            if ($memberinfo['customstatus'] != '') {
                $showtitle = $rank['title'];
                $customstatus = '<br />'.$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($newsig) ? checkInput($newsig, '', $SETTINGS['sightml'], '', false) : '';

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

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

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

        $memlocation    = addslashes($memlocation);

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

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

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

        eval("\$profile = \"".template("memcp_profile")."\";");
        $profile = stripslashes($profile);
        echo $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 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet1']) {
            $inet1 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet2']) {
            $inet2 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet3']) {
            $inet3 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet4']) {
            $inet4 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet5']) {
            $inet5 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet6']) {
            $inet6 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet7']) {
            $inet7 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet8']) {
            $inet8 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet9']) {
            $inet9 = $selHTML;
        } elseif ($member['inet'] == $lang['inet10']) {
            $inet10 = 'selected="selected"';
        } elseif ($member['inet'] == $lang['inet11']) {
            $inet11 = 'selected="selected"';
        }
        // Internet Connection Selection Mod End

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

        $db->query("UPDATE $table_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($newsig) ? checkInput($newsig, '', $SETTINGS['sightml'], '', false) : '';

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

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

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

    $memlocation    = addslashes($newmemlocation);

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

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

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

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

    $db->query("UPDATE $table_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'");

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

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

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

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

$dayselect
<input type="text" name="year" size="4" /></td>
</tr>

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

<tr>
<td bgcolor="$altbg1" class="tablerow" width="22%">$lang[inet]</td>
<td bgcolor="$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:
==========

$dayselect
<input type="text" name="year" size="4" value="$year" /></td>
</tr>

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

<tr>
<td bgcolor="$altbg1" class="tablerow" width="22%">$lang[inet]</td>
<td bgcolor="$altbg2" class="tablerow">
<select name="inet">
<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:
==========

$dayselect
<input type="text" name="year" size="4" value="$year" />
</td>
</tr>

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

<tr>
<td bgcolor="$altbg1" class="tablerow" width="22%">$lang[inet]</td>
<td bgcolor="$altbg2" class="tablerow">
<select name="inet">
<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:
==========

$emailblock

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

$inetblock

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

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

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

<tr>
<td bgcolor="$altbg1" class="tablerow" width="22%">$lang[inet]</td>
<td bgcolor="$altbg2" class="tablerow">$inettxt</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="$altbg1" valign="top">$lang[inet]</td>
<td bgcolor="$altbg2" valign="top">$inettxt</td>

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