##
##
##        Mod title:  CountryFlagMod
##
##      Mod version:  1.0
##   Works on PunBB:  1.2.10
##     Release date:  2005-12-18
##           Author:  Elisa ([email protected])
##
##      Description:  This mod allows you to add countries and view county 
##                      flags for each user.
##
##   Affected files:  ./profile.php
##                       ./userlist.php
##                       ./viewtopic.php  
##                       ./lang/English/profile.php
## 
##    Files Added:     ./flags.zip
##                        ->  contains 230 country flags 
##                       ./mods/countries.php 
##                        ->  contains an array of country names 
##                            for the pull down menue
##                        ./mods/genlist.sh 
##                        ->  generates ./mods/countries.php from all *.png 
##                            files which are in ./img/flags 
##                            (in case you need to update countries someday :)
##                            ./genlist.sh > countries.php
##                       
##       Affects DB:  Yes - New column "country" in "users" table.
##
##
##       DISCLAIMER:  Please note that "mods" are not officially supported by
##                    PunBB. Installation of this modification is done at your
##                    own risk. Backup your forum database and any and all
##                    applicable files before proceeding.
##
##


#
#---------[ 1. ئەمانە بەرز بکەوە ]-------------------------------------------------------
#

* upload install_mod.php to wherever your PunBB forum is located
* extract the flag.zip package and upload the flags to ./img/flags
* upload the mod files countries.php and genlist.sh to ./mods/*

#
#---------[ 2. مۆدەکە دابمەزرێنە ]----------------------------------------------------------
#

    ./install_mod.php

#
#---------[ 3. دواتر مۆدەکە بسڕەوە ]-------------------------------------------------------
#

    ./install_mod.php

#
#---------[ 4. ئەم پەرگەیە بکەوە ]---------------------------------------------------------
#

    ./profile.php

#
#---------[ 5. بگەڕێ بەدواى ]---------------------------------------------
#

     $form = extract_elements(array('realname', 'url', 'location'));

#
#---------[ 6. بیگۆڕە بە ]-------------------------------------------------
#

    $form = extract_elements(array('realname', 'url', 'location', 'country'));

#
#---------[ 7. بگەڕێ بەدواى  ]---------------------------------------------
#

        $result = $db->query('SELECT u.username, u.email, u.title, u.realname, u.url, u.jabber, u.icq, u.msn, u.aim, u.yahoo, u.location, u.use_avatar, u.signature, u.disp_topics, u.disp_posts, u.email_setting, u.save_pass, u.notify_with_post, u.show_smilies, u.show_img, u.show_img_sig, u.show_avatars, u.show_sig, u.timezone, u.language, u.style, u.num_posts, u.last_post, u.registered, u.registration_ip, u.admin_note, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $db->error());

#
#---------[ 8.  بیگۆڕە بە ]-------------------------------------------------
#

        $result = $db->query('SELECT u.username, u.email, u.title, u.realname, u.url, u.jabber, u.icq, u.msn, u.aim, u.yahoo, u.location, u.use_avatar, u.signature, u.disp_topics, u.disp_posts, u.email_setting, u.save_pass, u.notify_with_post, u.show_smilies, u.show_img, u.show_img_sig, u.show_avatars, u.show_sig, u.timezone, u.language, u.style, u.num_posts, u.last_post, u.registered, u.registration_ip, u.admin_note, u.country, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $db->error()); 

#
#---------[ 9. بگەڕێ بەدواى  ]-----------------------------------------
#

       <dt><?php echo $lang_profile['Location'] ?>: </dt>
       <dd><?php echo ($user['location'] !='') ? pun_htmlspecialchars(($pun_config['o_censoring'] == '1') ? censor_words($user['location']) : $user['location']) : $lang_profile['Unknown']; ?></dd>


#
#---------[ 10. لەدواى ئەمە زیاد بکە  ]-------------------------------------------------
#

  <dt><?php echo $lang_profile['Country'] ?>: </dt>
  <dd><?php echo ($user['country'] !='') ? pun_htmlspecialchars($user['country']) . '<br><img src="./img/flags/'.$user['country'].'.png" alt="'.$user['country'].'">' : $lang_profile['Unknown']; ?></dd> 

#
#---------[ 11. بگەڕێ بەدواى  ]------------------------------------------
#

       <label><?php echo $lang_profile['Location'] ?><br /><input type="text" name="form[location]" value="<?php echo pun_htmlspecialchars($user['location']) ?>" size="30" maxlength="30" /><br /></label>

#
#---------[ 12. لەدواى ئەمە زیاد بکە ]-------------------------------------------------
#

   <label>
     <?php echo $lang_profile['Country'] ?><br>
     <select name="form[country]">
       <?php require PUN_ROOT.'mods/countries.php';
       echo '<option value=" "';
       if ($user['country'] == " ") {
         echo ' selected="selected"'; }
       echo '> none </option>';
       foreach ($countries as $value) {
          echo '<option value="' . $value. '"';
          if ($user['country'] == $value) {
            echo ' selected="selected"'; }
         echo '>' . $value . '</option>'; } ?>
     </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
     <?php if ($user['country'] != NULL) {
       echo '<img src="./img/flags/'.$user['country'].'.png" alt="'.$user['country'].'">'; } ?>
   </label> 

#
#---------[ 13. پاشەکەوتى بکە و بارى بکەوە شوێنى خۆى ]-------------------------------------------------
#

./profile.php

#
#---------[ 14. ئەم پەرگەیە بکەوە  ]--------------------------------------------------------
#

./userlist.php

#
#---------[ 15. بگەڕێ بەدواى]---------------------------------------------
#

    require PUN_ROOT.'lang/'.$pun_user['language'].'/search.php';

#
#---------[ 16. لەدواى ئەمە زیاد بکە  ]-------------------------------------------------
#

    require PUN_ROOT.'lang/'.$pun_user['language'].'/profile.php';

#
#---------[ 17. بگەڕێ بەدواى  ]--------------------------------------------
#

     <th class="tcr" scope="col"><?php echo $lang_common['Registered'] ?></th>

#
#---------[ 18. لەدواى ئەمە زیاد بکە ]-------------------------------------------------
#

     <th class="tcr" scope="col"><?php echo $lang_profile['Country'] ?></th>

#
#---------[ 19. بگەڕێ بەدواى ]--------------------------------------------
#

     $result = $db->query('SELECT u.id, u.username, u.title, u.num_posts, u.registered, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id>1'.(!empty($where_sql) ? ' AND '.implode(' AND ', $where_sql) : '').' ORDER BY '.$sort_by.' '.$sort_dir.' LIMIT '.$start_from.', 50') or error('Unable to fetch user list', __FILE__, __LINE__, $db->error());

#
#---------[ 20.  بیگۆڕە بە  ]------------------------------------------------
#

     $result = $db->query('SELECT u.id, u.username, u.title, u.num_posts, u.registered, u.country, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id>1'.(!empty($where_sql) ? ' AND '.implode(' AND ', $where_sql) : '').' ORDER BY '.$sort_by.' '.$sort_dir.' LIMIT '.$start_from.', 50') or error('Unable to fetch user list', __FILE__, __LINE__, $db->error()); 

#
#---------[ 21. بگەڕێ بەدواى ]--------------------------------------------
#

    $user_title_field = get_title($user_data);

#
#---------[ 22. لەدواى ئەمە زیاد بکە]-------------------------------------------------
#

    $user_country = $user_data['country'];

#
#---------[ 23. بگەڕێ بەدواى ]-------------------------------------------
#

    <td class="tcr"><?php echo format_time($user_data['registered'], true) ?></td>

#
#---------[ 24. لەدواى ئەمە زیاد بکە ]-------------------------------------------------
#

    <td class="tcr">
      <?php if ( $user_country != '' ) {
        echo '<img src="./img/flags/'.$user_country.'.png" alt="'.$user_country.'" title="'.$user_country.'">'; } ?>
    </td>

#
#---------[ 25. پاشەکەوتى بکە و بارى بکەوە شوێنى خۆى ]-------------------------------------------------
#

./userlist.php

#
#---------[ 26. ئەم پەرگەیە بکەوە ]-------------------------------------------------------
#

./viewtopic.php

#
#---------[ 27. بگەڕێ بەدواى ]-------------------------------------------
#

      $result = $db->query('SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id LEFT JOIN '.$db->prefix.'online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id='.$id.' ORDER BY p.id LIMIT '.$start_from.','.$pun_user['disp_posts'], true) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); 

#
#---------[ 28. بیگۆڕە بە ]-----------------------------------------------
#

    $result = $db->query('SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.country, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'users AS u ON u.id=p.poster_id INNER JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id LEFT JOIN '.$db->prefix.'online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id='.$id.' ORDER BY p.id LIMIT '.$start_from.','.$pun_user['disp_posts'], true) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); 

#
#---------[ 29. بگەڕێ بەدواى  ]-------------------------------------------
#

    $user_title = get_title($cur_post);

#
#---------[ 30. لەدواى ئەمە زیاد بکە ]-------------------------------------------------
#

    $user_country = $cur_post['country'];

#
#---------[ 31.  بگەڕێ بەدواى  ]--------------------------------------------
#

    <dd class="postavatar"><?php echo $user_avatar ?> </dd>

#
#---------[ 32. لەدواى ئەمە زیاد بکە ]-------------------------------------------------
#

    <?php if ( $user_country != '') {
                echo '<dd class="postavatar"><img src="./img/flags/'.$user_country.'.png" alt="'.$user_country.'" title="'.$user_country.'"></dd>'; } ?>

#
#---------[ 33. پاشەکەوتى بکە و بارى بکەوە شوێنى خۆى ]-------------------------------------------------
#

./viewtopic.php

#
#---------[ 34. ئەم پەرگەیە بکەوە]-------------------------------------------------------
#

./lang/English/profile.php


#
#---------[ 35. بگەڕێ بەدواى  ]---------------------------------------------
#

    'Location'          =>  'Location',

#
#---------[ 36. لەدواى ئەمە زیاد بکە  ]-------------------------------------------------
#

    'Country'         =>  'Country',

#
#---------[ 37. پاشەکەوتى بکە و بارى بکەوە شوێنى خۆى ]-------------------------------------------------
#

./lang/English/profile.php


And now see where your members are from :)