File modules\profile\include\update.php

$sql = 'SELECT * FROM `' . $GLOBALS['xoopsDB']->prefix('user_profile_field') . "` WHERE `field_name` NOT IN ('" . implode("', '", $skip_fields) . "')";

61:

$result = $GLOBALS['xoopsDB']->query($sql);

62:

if (!$GLOBALS['xoopsDB']->isResultSet($result)) {

63:

throw new \RuntimeException(

64:

\sprintf(_DB_QUERY_ERROR, $sql) . $GLOBALS['xoopsDB']->error(), E_USER_ERROR

);

}

$fields = array();

while (false !== ($myrow = $GLOBALS['xoopsDB']->fetchArray($result))) {

69:

$fields[] = $myrow['field_name'];

70:

$object = $field_handler->create();

71:

$object->setVars($myrow, true);

72:

$object->setVar('cat_id', 1);

73:

if (!empty($myrow['field_register'])) {

74:

$object->setVar('step_id', 2);

75:

}

76:

if (!empty($myrow['field_options'])) {

77:

$object->setVar('field_options', unserialize($myrow['field_options']));

78:

}

79:

$field_handler->insert($object, true);

80:

81:

$gperm_itemid = $object->getVar('field_id');

82:

$sql = 'UPDATE ' . $GLOBALS['xoopsDB']->prefix('group_permission') . ' SET gperm_itemid = ' . $gperm_itemid . ' WHERE gperm_itemid = ' . $myrow['fieldid'] . ' AND gperm_modid = ' . $module->getVar('mid') . " AND gperm_name IN ('profile_edit', 'profile_search')";

83:

$GLOBALS['xoopsDB']->queryF($sql);

84:

85:

$groups_visible = $goupperm_handler->getGroupIds('profile_visible', $myrow['fieldid'], $module->getVar('mid'));

86:

$groups_show = $goupperm_handler->getGroupIds('profile_show', $myrow['fieldid'], $module->getVar('mid'));

87:

foreach ($groups_visible as $ugid) {

88:

foreach ($groups_show as $pgid) {

89:

$sql = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('profile_visibility') . ' (field_id, user_group, profile_group) ' . ' VALUES ' . " ({$gperm_itemid}, {$ugid}, {$pgid})";

90:

$GLOBALS['xoopsDB']->queryF($sql);

}

}

//profile_install_setPermissions($object->getVar('field_id'), $module->getVar('mid'), $canedit, $visible);

unset($object);

}

// Copy data from profile table

99:

foreach ($fields as $field) {

100:

$GLOBALS['xoopsDB']->queryF('UPDATE `' . $GLOBALS['xoopsDB']->prefix('profile_profile') . '` u, `' . $GLOBALS['xoopsDB']->prefix('user_profile') . "` p SET u.{$field} = p.{$field} WHERE u.profile_id=p.profileid");

101:

}

102:

103:

// Drop old profile table

104:

$sql = 'DROP TABLE ' . $GLOBALS['xoopsDB']->prefix('user_profile');

105:

$GLOBALS['xoopsDB']->queryF($sql);

106:

107:

// Drop old field module

108:

$sql = 'DROP TABLE ' . $GLOBALS['xoopsDB']->prefix('user_profile_field');

109:

$GLOBALS['xoopsDB']->queryF($sql);

110:

111:

// Remove not used items

112:

$sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('group_permission') . ' WHERE `gperm_modid` = ' . $module->getVar('mid') . " AND `gperm_name` IN ('profile_show', 'profile_visible')";

113:

$GLOBALS['xoopsDB']->queryF($sql);

114:

}

115:

116:

if ($oldversion < '1.6.2') {

117:

$GLOBALS['xoopsDB']->queryF('UPDATE `' . $GLOBALS['xoopsDB']->prefix('profile_field') . "` SET `field_valuetype`=1 WHERE `field_name`='umode'");

118:

}

119:

120:

if ($oldversion < '1.8.6') {

121:

// delete old html template files

122:

$templateDirectory = XOOPS_ROOT_PATH . '/modules/' . $module->getVar('dirname', 'n') . '/templates/';

123:

$template_list = array_diff(scandir($templateDirectory), array('..', '.'));

124:

foreach ($template_list as $k => $v) {

125:

$fileinfo = new SplFileInfo($templateDirectory . $v);

126:

if ($fileinfo->getExtension() === 'html' && $fileinfo->getFilename() !== 'index.html') {

127:

@unlink($templateDirectory . $v);

}

}

xoops_load('xoopsfile');

132:

//delete /images directory

133:

$imagesDirectory = XOOPS_ROOT_PATH . '/modules/' . $module->getVar('dirname', 'n') . '/images/';

134:

$folderHandler = XoopsFile::getHandler('folder', $imagesDirectory);

135:

$folderHandler->delete($imagesDirectory);

136:

//delete /templates/style.css file

137:

$cssFile = XOOPS_ROOT_PATH . '/modules/' . $module->getVar('dirname', 'n') . '/templates/style.css';

138:

$folderHandler = XoopsFile::getHandler('file', $cssFile);

139:

$folderHandler->delete($cssFile);

140:

//delete .html entries from the tpl table

141:

$sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('tplfile') . " WHERE `tpl_module` = '" . $module->getVar('dirname', 'n') . "' AND `tpl_file` LIKE '%.html%'";

142:

$GLOBALS['xoopsDB']->queryF($sql);

143:

}

144:

145:

if ($oldversion < '1.8.8') {

146:

// update user_sig field to use dhtml editor

147:

$tables = new Xmf\Database\Tables();

148: