Menu
▾
▴
[xoops-svn] SF.net SVN: xoops-svn:[11356] XoopsModules/userlog/trunk/userlog
|
From: <ir...@us...> - 2013-04-07 08:54:48
|
Revision: 11356
http://sourceforge.net/p/xoops/svn/11356
Author: irmtfan
Date: 2013-04-07 08:54:45 +0000 (Sun, 07 Apr 2013)
Log Message:
-----------
- change version to 1.01 RC 1 (2013/04/07)
- add update functionality - e.g.: update is possible from v1 beta1 to v1.01 rc1(2013/04/07)
- fix: change module_name field in mod_userlog_log table size from VARCHAR(25) to VARCHAR(50) (2013/04/07)
Modified Paths:
--------------
XoopsModules/userlog/trunk/userlog/class/log.php
XoopsModules/userlog/trunk/userlog/docs/changelog.txt
XoopsModules/userlog/trunk/userlog/include/module.php
XoopsModules/userlog/trunk/userlog/sql/mysql.sql
XoopsModules/userlog/trunk/userlog/xoops_version.php
Modified: XoopsModules/userlog/trunk/userlog/class/log.php
===================================================================
--- XoopsModules/userlog/trunk/userlog/class/log.php 2013-04-07 03:14:28 UTC (rev 11355)
+++ XoopsModules/userlog/trunk/userlog/class/log.php 2013-04-07 08:54:45 UTC (rev 11356)
@@ -54,7 +54,7 @@
$this->initVar("pagetitle", XOBJ_DTYPE_TXTBOX, null, false, 255);
$this->initVar("pageadmin", XOBJ_DTYPE_INT, null, false);
$this->initVar("module", XOBJ_DTYPE_TXTBOX, null, true, 25);
- $this->initVar("module_name", XOBJ_DTYPE_TXTBOX, null, true, 25);
+ $this->initVar("module_name", XOBJ_DTYPE_TXTBOX, null, true, 50);
$this->initVar("item_name", XOBJ_DTYPE_TXTBOX, null, false, 10);
$this->initVar("item_id", XOBJ_DTYPE_INT, null, false);
$this->initVar("request_method", XOBJ_DTYPE_TXTBOX, null, false, 20);
@@ -801,7 +801,31 @@
}
return $this->getCount($criteria, $notNullFields);
}
-
+ public function changeField($field = null, $structure = null)
+ {
+ $sql = "ALTER TABLE {$this->table} CHANGE {$field} {$field} {$structure}";
+ if (!$result = $this->db->queryF($sql)) {
+ xoops_error($this->db->error().'<br />'.$sql);
+ return false;
+ }
+ return true;
+ }
+ public function showFields($field = null)
+ {
+ $sql = "SHOW FIELDS FROM {$this->table}";
+ if (isset($field)) {
+ $sql .= " LIKE '{$field}'";
+ }
+ if (!$result = $this->db->queryF($sql)) {
+ xoops_error($this->db->error().'<br />'.$sql);
+ return false;
+ }
+ $ret = array();
+ while ($myrow = $this->db->fetchArray($result)) {
+ $ret[$myrow["Field"]] = $myrow;
+ }
+ return $ret;
+ }
public function &get($id)
{
static $logs;
Modified: XoopsModules/userlog/trunk/userlog/docs/changelog.txt
===================================================================
--- XoopsModules/userlog/trunk/userlog/docs/changelog.txt 2013-04-07 03:14:28 UTC (rev 11355)
+++ XoopsModules/userlog/trunk/userlog/docs/changelog.txt 2013-04-07 08:54:45 UTC (rev 11356)
@@ -1,5 +1,12 @@
Userlog
Changelog:
+
+VERSION 1.01:
+- change version to 1.01 RC 1 (2013/04/07)
+- add update functionality - e.g.: update is possible from v1 beta1 to v1.01 rc1(2013/04/07)
+- fix: change module_name field in mod_userlog_log table size from VARCHAR(25) to VARCHAR(50) (2013/04/07)
+
+VERSION 1:
- fix and improve: parse all files in all paths before any action in class/log.php and admin/file.php(2013/04/06)
- fix: return false when no file is selected in class/log.php(2013/04/06)
- fix: hide filename element when delete is selected in admin/file.php(2013/04/06)
Modified: XoopsModules/userlog/trunk/userlog/include/module.php
===================================================================
--- XoopsModules/userlog/trunk/userlog/include/module.php 2013-04-07 03:14:28 UTC (rev 11355)
+++ XoopsModules/userlog/trunk/userlog/include/module.php 2013-04-07 08:54:45 UTC (rev 11356)
@@ -25,4 +25,37 @@
{
$logsetObj = UserlogSetting::getInstance();
return $logsetObj->cleanCache(); // delete all settings caches
+}
+function xoops_module_update_userlog(&$module, $prev_version = null)
+{
+ if ($prev_version == round( $module->getInfo("version") * 100, 2 )) {
+ $module->setErrors("You have the latest " . $module->getInfo("name") . " module (". $module->getInfo("dirname") . " version " . $module->getInfo("version") . ") and update is not necessary");
+ print_r($module->getErrors());
+ return true;
+ }
+ $ret = false;
+ // first db update
+ if ($prev_version == 100) {
+ $ret = update_userlog_v100($module);
+ }
+ print_r($module->getErrors());
+ return $ret;
+}
+
+// update database from v1 to 1.01 (Beta1 to RC1)
+// module_name VARCHAR(25) change to VARCHAR(50)
+function update_userlog_v100(&$module)
+{
+ $field = "module_name";
+ $Userlog = Userlog::getInstance();
+ $ret = $Userlog->getHandler('log')->showFields($field);
+ preg_match_all('!\d+!', $ret[$field]["Type"], $nums);
+ // only change if module_name Type was VARCHAR(25)
+ if($nums[0][0] == 25) {
+ $ret2 = $Userlog->getHandler('log')->changeField($field, "VARCHAR(50)");
+ } else {
+ $ret2 = true;
+ $module->setErrors("Your table field ({$field}) with size {$ret[$field]['Type']} dont need change.");
+ }
+ return $ret2;
}
\ No newline at end of file
Modified: XoopsModules/userlog/trunk/userlog/sql/mysql.sql
===================================================================
--- XoopsModules/userlog/trunk/userlog/sql/mysql.sql 2013-04-07 03:14:28 UTC (rev 11355)
+++ XoopsModules/userlog/trunk/userlog/sql/mysql.sql 2013-04-07 08:54:45 UTC (rev 11356)
@@ -18,7 +18,7 @@
pagetitle varchar(255) NOT NULL default '',
pageadmin smallint(1) unsigned NOT NULL default 0,
module varchar(25) NOT NULL default '',
- module_name varchar(25) NOT NULL default '',
+ module_name varchar(50) NOT NULL default '',
item_name varchar(10) NOT NULL default '',
item_id int(11) unsigned NOT NULL default 0,
request_method varchar(20) NOT NULL default '',
Modified: XoopsModules/userlog/trunk/userlog/xoops_version.php
===================================================================
--- XoopsModules/userlog/trunk/userlog/xoops_version.php 2013-04-07 03:14:28 UTC (rev 11355)
+++ XoopsModules/userlog/trunk/userlog/xoops_version.php 2013-04-07 08:54:45 UTC (rev 11356)
@@ -25,7 +25,7 @@
$modversion['dirname'] = 'userlog';
xoops_loadLanguage('admin', $modversion['dirname']);
$modversion['description'] = _MI_USERLOG_DSC;
-$modversion['version'] = '1';
+$modversion['version'] = '1.01';
$modversion['author'] = 'xoops.org (irmtfan)';
$modversion['nickname'] = 'irmtfan';
$modversion['credits'] = 'The XOOPS Project Team, trabis, irmtfan, mamba, tatane, Cesag, zyspec';
@@ -34,13 +34,14 @@
$modversion['official'] = 0;
$modversion['help'] = 'page=help';
$modversion['image'] = 'images/userlog_logo.png';
+$modversion['onUpdate'] = 'include/module.php';
$modversion['onUninstall'] = 'include/module.php';
//about
-$modversion['release_date'] = '2013/04/01';
+$modversion['release_date'] = '2013/04/07';
$modversion['module_website_url'] = 'http://www.xoops.org/';
$modversion['module_website_name'] = 'XOOPS';
-$modversion['module_status'] = 'BETA 1';
+$modversion['module_status'] = 'RC 1';
$modversion['min_php'] = '5.3';
$modversion['min_xoops'] = '2.5.5';
$modversion['min_db'] = array('mysql' => '5.0.7', 'mysqli' => '5.0.7');
|
