1: <?php
  2: /**
  3:  * Extended User Profile
  4:  *
  5:  * You may not change or alter any portion of this comment or credits
  6:  * of supporting developers from this source code or any supporting source code
  7:  * which is considered copyrighted (c) material of the original comment or credit authors.
  8:  * This program is distributed in the hope that it will be useful,
  9:  * but WITHOUT ANY WARRANTY; without even the implied warranty of
 10:  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 11:  *
 12:  * @copyright       (c) 2000-2016 XOOPS Project (www.xoops.org)
 13:  * @license             GNU GPL 2 (http://www.gnu.org/licenses/gpl-2.0.html)
 14:  * @package             profile
 15:  * @since               2.3.0
 16:  * @author              Jan Pedersen
 17:  * @author              Taiwen Jiang <phppp@users.sourceforge.net>
 18:  * @param $module
 19:  * @return bool
 20:  */
 21: 
 22: function xoops_module_install_profile(XoopsModule $module)
 23: {
 24:     global $module_id;
 25:     $module_id = $module->getVar('mid');
 26:     xoops_loadLanguage('user');
 27: 
 28:     // Create registration steps
 29:     profile_install_addStep(_PROFILE_MI_STEP_BASIC, '', 1, 0);
 30:     profile_install_addStep(_PROFILE_MI_STEP_COMPLEMENTARY, '', 2, 1);
 31: 
 32:     // Create categories
 33:     profile_install_addCategory(_PROFILE_MI_CATEGORY_PERSONAL, 1);
 34:     profile_install_addCategory(_PROFILE_MI_CATEGORY_MESSAGING, 2);
 35:     profile_install_addCategory(_PROFILE_MI_CATEGORY_SETTINGS, 3);
 36:     profile_install_addCategory(_PROFILE_MI_CATEGORY_COMMUNITY, 4);
 37: 
 38:     // Add user fields
 39:     xoops_loadLanguage('notification');
 40:     xoops_loadLanguage('main', $module->getVar('dirname', 'n'));
 41:     include_once $GLOBALS['xoops']->path('include/notification_constants.php');
 42:     $umode_options         = array(
 43:         'nest'   => _NESTED,
 44:         'flat'   => _FLAT,
 45:         'thread' => _THREADED);
 46:     $uorder_options        = array(
 47:         0 => _OLDESTFIRST,
 48:         1 => _NEWESTFIRST);
 49:     $notify_mode_options   = array(
 50:         XOOPS_NOTIFICATION_MODE_SENDALWAYS         => _NOT_MODE_SENDALWAYS,
 51:         XOOPS_NOTIFICATION_MODE_SENDONCETHENDELETE => _NOT_MODE_SENDONCE,
 52:         XOOPS_NOTIFICATION_MODE_SENDONCETHENWAIT   => _NOT_MODE_SENDONCEPERLOGIN);
 53:     $notify_method_options = array(
 54:         XOOPS_NOTIFICATION_METHOD_DISABLE => _NOT_METHOD_DISABLE,
 55:         XOOPS_NOTIFICATION_METHOD_PM      => _NOT_METHOD_PM,
 56:         XOOPS_NOTIFICATION_METHOD_EMAIL   => _NOT_METHOD_EMAIL);
 57: 
 58:     profile_install_addField('name', _US_REALNAME, '', 1, 'textbox', 1, 1, 1, array(), 2, 255);
 59:     profile_install_addField('user_from', _US_LOCATION, '', 1, 'textbox', 1, 2, 1, array(), 2, 255);
 60:     profile_install_addField('timezone_offset', _US_TIMEZONE, '', 1, 'timezone', 1, 3, 1, array(), 2, 0);
 61:     profile_install_addField('user_occ', _US_OCCUPATION, '', 1, 'textbox', 1, 4, 1, array(), 2, 255);
 62:     profile_install_addField('user_intrest', _US_INTEREST, '', 1, 'textbox', 1, 5, 1, array(), 2, 255);
 63:     profile_install_addField('bio', _US_EXTRAINFO, '', 1, 'textarea', 2, 6, 1, array(), 2, 0);
 64:     profile_install_addField('user_regdate', _US_MEMBERSINCE, '', 1, 'datetime', 3, 7, 0, array(), 0, 10);
 65: 
 66:     profile_install_addField('user_icq', _US_ICQ, '', 2, 'textbox', 1, 1, 1, array(), 0, 255, false);
 67:     profile_install_addField('user_aim', _US_AIM, '', 2, 'textbox', 1, 2, 1, array(), 0, 255, false);
 68:     profile_install_addField('user_yim', _US_YIM, '', 2, 'textbox', 1, 3, 1, array(), 0, 255, false);
 69:     profile_install_addField('user_msnm', _US_MSNM, '', 2, 'textbox', 1, 4, 1, array(), 0, 255, false);
 70: 
 71:     profile_install_addField('user_viewemail', _US_ALLOWVIEWEMAIL, '', 3, 'yesno', 3, 1, 1, array(), 2, 1, false);
 72:     profile_install_addField('attachsig', _US_SHOWSIG, '', 3, 'yesno', 3, 2, 1, array(), 0, 1, false);
 73:     profile_install_addField('user_mailok', _US_MAILOK, '', 3, 'yesno', 3, 3, 1, array(), 2, 1, false);
 74:     profile_install_addField('theme', _PROFILE_MA_THEME, '', 3, 'theme', 1, 4, 1, array(), 0, 0, false);
 75:     profile_install_addField('umode', _US_CDISPLAYMODE, '', 3, 'select', 1, 5, 1, $umode_options, 0, 0, false);
 76:     profile_install_addField('uorder', _US_CSORTORDER, '', 3, 'select', 3, 6, 1, $uorder_options, 0, 0, false);
 77:     profile_install_addField('notify_mode', _NOT_NOTIFYMODE, '', 3, 'select', 3, 7, 1, $notify_mode_options, 0, 0, false);
 78:     profile_install_addField('notify_method', _NOT_NOTIFYMETHOD, '', 3, 'select', 3, 8, 1, $notify_method_options, 0, 0, false);
 79: 
 80:     profile_install_addField('url', _PROFILE_MI_URL_TITLE, '', 4, 'textbox', 1, 1, 1, array(), 2, 255);
 81:     profile_install_addField('posts', _US_POSTS, '', 4, 'textbox', 3, 2, 0, array(), 0, 255);
 82:     profile_install_addField('rank', _US_RANK, '', 4, 'rank', 3, 3, 2, array(), 0, 0);
 83:     profile_install_addField('last_login', _US_LASTLOGIN, '', 4, 'datetime', 3, 4, 0, array(), 0, 10);
 84:     profile_install_addField('user_sig', _US_SIGNATURE, '', 4, 'dhtml', 1, 5, 1, array(), 0, 0);
 85: 
 86:     profile_install_initializeProfiles();
 87: 
 88:     return true;
 89: }
 90: 
 91: function profile_install_initializeProfiles()
 92: {
 93:     global $module_id;
 94: 
 95:     $GLOBALS['xoopsDB']->queryF('   INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('profile_profile') . ' (profile_id) ' . '   SELECT uid ' . '   FROM ' . $GLOBALS['xoopsDB']->prefix('users'));
 96: 
 97:     $sql = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('group_permission') . ' (gperm_groupid, gperm_itemid, gperm_modid, gperm_name) ' . ' VALUES ' . ' (' . XOOPS_GROUP_ADMIN . ', ' . XOOPS_GROUP_ADMIN . ", {$module_id}, 'profile_access'), " . ' (' . XOOPS_GROUP_ADMIN . ', ' . XOOPS_GROUP_USERS . ", {$module_id}, 'profile_access'), " . ' (' . XOOPS_GROUP_USERS . ', ' . XOOPS_GROUP_USERS . ", {$module_id}, 'profile_access'), " . ' (' . XOOPS_GROUP_ANONYMOUS . ', ' . XOOPS_GROUP_USERS . ", {$module_id}, 'profile_access') " . ' ';
 98:     $GLOBALS['xoopsDB']->queryF($sql);
 99: }
100: 
101: // canedit: 0 - no; 1 - admin; 2 - admin & owner
102: /**
103:  * @param      $name
104:  * @param      $title
105:  * @param      $description
106:  * @param      $category
107:  * @param      $type
108:  * @param      $valuetype
109:  * @param      $weight
110:  * @param      $canedit
111:  * @param      $options
112:  * @param      $step_id
113:  * @param      $length
114:  * @param bool $visible
115:  *
116:  * @return bool
117:  */
118: function profile_install_addField($name, $title, $description, $category, $type, $valuetype, $weight, $canedit, $options, $step_id, $length, $visible = true)
119: {
120:     global $module_id;
121: 
122:     $profilefield_handler = xoops_getModuleHandler('field', 'profile');
123:     $obj                  = $profilefield_handler->create();
124:     $obj->setVar('field_name', $name, true);
125:     $obj->setVar('field_moduleid', $module_id, true);
126:     $obj->setVar('field_show', 1);
127:     $obj->setVar('field_edit', $canedit ? 1 : 0);
128:     $obj->setVar('field_config', 0);
129:     $obj->setVar('field_title', strip_tags($title), true);
130:     $obj->setVar('field_description', strip_tags($description), true);
131:     $obj->setVar('field_type', $type, true);
132:     $obj->setVar('field_valuetype', $valuetype, true);
133:     $obj->setVar('field_options', $options, true);
134:     if ($canedit) {
135:         $obj->setVar('field_maxlength', $length, true);
136:     }
137: 
138:     $obj->setVar('field_weight', $weight, true);
139:     $obj->setVar('cat_id', $category, true);
140:     $obj->setVar('step_id', $step_id, true);
141:     $profilefield_handler->insert($obj);
142: 
143:     profile_install_setPermissions($obj->getVar('field_id'), $module_id, $canedit, $visible);
144: 
145:     return true;
146:     /*
147:     //$GLOBALS['xoopsDB']->query("INSERT INTO ".$GLOBALS['xoopsDB']->prefix("profile_field")." VALUES (0, {$category}, '{$type}', {$valuetype}, '{$name}', " . $GLOBALS['xoopsDB']->quote($title) . ", " . $GLOBALS['xoopsDB']->quote($description) . ", 0, {$length}, {$weight}, '', 1, {$canedit}, 1, 0, '" . serialize($options) . "', {$step_id})");
148:     $gperm_itemid = $obj->getVar('field_id');
149:     unset($obj);
150:     $gperm_modid = $module_id;
151:     $sql = "INSERT INTO " . $GLOBALS['xoopsDB']->prefix("group_permission") .
152:         " (gperm_groupid, gperm_itemid, gperm_modid, gperm_name) " .
153:         " VALUES " .
154:         ($canedit ?
155:             " (" . XOOPS_GROUP_ADMIN . ", {$gperm_itemid}, {$gperm_modid}, 'profile_edit'), "
156:         : "" ) .
157:         ($canedit == 1 ?
158:             " (" . XOOPS_GROUP_USERS . ", {$gperm_itemid}, {$gperm_modid}, 'profile_edit'), "
159:         : "" ) .
160:         " (" . XOOPS_GROUP_ADMIN . ", {$gperm_itemid}, {$gperm_modid}, 'profile_search'), " .
161:         " (" . XOOPS_GROUP_USERS . ", {$gperm_itemid}, {$gperm_modid}, 'profile_search') " .
162:         " ";
163:     $GLOBALS['xoopsDB']->query($sql);
164: 
165:     if ($visible) {
166:         $sql = "INSERT INTO " . $GLOBALS['xoopsDB']->prefix("profile_visibility") .
167:             " (field_id, user_group, profile_group) " .
168:             " VALUES " .
169:             " ({$gperm_itemid}, " . XOOPS_GROUP_ADMIN . ", " . XOOPS_GROUP_ADMIN . "), " .
170:             " ({$gperm_itemid}, " . XOOPS_GROUP_ADMIN . ", " . XOOPS_GROUP_USERS . "), " .
171:             " ({$gperm_itemid}, " . XOOPS_GROUP_USERS . ", " . XOOPS_GROUP_ADMIN . "), " .
172:             " ({$gperm_itemid}, " . XOOPS_GROUP_USERS . ", " . XOOPS_GROUP_USERS . "), " .
173:             " ({$gperm_itemid}, " . XOOPS_GROUP_ANONYMOUS . ", " . XOOPS_GROUP_ADMIN . "), " .
174:             " ({$gperm_itemid}, " . XOOPS_GROUP_ANONYMOUS . ", " . XOOPS_GROUP_USERS . ")" .
175:             " ";
176:         $GLOBALS['xoopsDB']->query($sql);
177:     }
178:     */
179: }
180: 
181: /**
182:  * @param $field_id
183:  * @param $module_id
184:  * @param $canedit
185:  * @param $visible
186:  */
187: function profile_install_setPermissions($field_id, $module_id, $canedit, $visible)
188: {
189:     $gperm_itemid = $field_id;
190:     $gperm_modid  = $module_id;
191:     $sql          = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('group_permission') . ' (gperm_groupid, gperm_itemid, gperm_modid, gperm_name) ' . ' VALUES ' . ($canedit ? ' (' . XOOPS_GROUP_ADMIN . ", {$gperm_itemid}, {$gperm_modid}, 'profile_edit'), " : '') . ($canedit == 1 ? ' (' . XOOPS_GROUP_USERS . ", {$gperm_itemid}, {$gperm_modid}, 'profile_edit'), " : '') . ' (' . XOOPS_GROUP_ADMIN . ", {$gperm_itemid}, {$gperm_modid}, 'profile_search'), " . ' (' . XOOPS_GROUP_USERS . ", {$gperm_itemid}, {$gperm_modid}, 'profile_search') " . ' ';
192:     $GLOBALS['xoopsDB']->queryF($sql);
193: 
194:     if ($visible) {
195:         $sql = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('profile_visibility') . ' (field_id, user_group, profile_group) ' . ' VALUES ' . " ({$gperm_itemid}, " . XOOPS_GROUP_ADMIN . ', ' . XOOPS_GROUP_ADMIN . '), ' . " ({$gperm_itemid}, " . XOOPS_GROUP_ADMIN . ', ' . XOOPS_GROUP_USERS . '), ' . " ({$gperm_itemid}, " . XOOPS_GROUP_USERS . ', ' . XOOPS_GROUP_ADMIN . '), ' . " ({$gperm_itemid}, " . XOOPS_GROUP_USERS . ', ' . XOOPS_GROUP_USERS . '), ' . " ({$gperm_itemid}, " . XOOPS_GROUP_ANONYMOUS . ', ' . XOOPS_GROUP_ADMIN . '), ' . " ({$gperm_itemid}, " . XOOPS_GROUP_ANONYMOUS . ', ' . XOOPS_GROUP_USERS . ')' . ' ';
196:         $GLOBALS['xoopsDB']->queryF($sql);
197:     }
198: }
199: 
200: /**
201:  * @param $name
202:  * @param $weight
203:  */
204: function profile_install_addCategory($name, $weight)
205: {
206:     $GLOBALS['xoopsDB']->query('INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('profile_category') . ' VALUES (0, ' . $GLOBALS['xoopsDB']->quote($name) . ", '', {$weight})");
207: }
208: 
209: /**
210:  * @param $name
211:  * @param $desc
212:  * @param $order
213:  * @param $save
214:  */
215: function profile_install_addStep($name, $desc, $order, $save)
216: {
217:     $GLOBALS['xoopsDB']->query('INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('profile_regstep') . ' VALUES (0, ' . $GLOBALS['xoopsDB']->quote($name) . ', ' . $GLOBALS['xoopsDB']->quote($desc) . ", {$order}, {$save})");
218: }
219: