[xoops-svn] SF.net SVN: xoops-svn:[11573] XoopsModules/smallworld/trunk/smallworld

[<dj...@us...>]

Revision: 11573
          http://sourceforge.net/p/xoops/svn/11573
Author:   djculex
Date:     2013-05-22 13:01:51 +0000 (Wed, 22 May 2013)
Log Message:
-----------
Change: Sql messages from varchar to text
Bugfix: Fixing appearance of admin

Modified Paths:
--------------
    XoopsModules/smallworld/trunk/smallworld/admin/about.php
    XoopsModules/smallworld/trunk/smallworld/sql/mysql.sql

Modified: XoopsModules/smallworld/trunk/smallworld/admin/about.php
===================================================================
--- XoopsModules/smallworld/trunk/smallworld/admin/about.php	2013-05-22 07:38:03 UTC (rev 11572)
+++ XoopsModules/smallworld/trunk/smallworld/admin/about.php	2013-05-22 13:01:51 UTC (rev 11573)
@@ -23,16 +23,17 @@
 
 xoops_cp_header();
 global $xoTheme;        
+
+
+$aboutAdmin = new ModuleAdmin();
+
+echo $aboutAdmin->addNavigation('about.php');
+echo $aboutAdmin->renderAbout('', false);
+
 $xoTheme->addStylesheet(
     XOOPS_URL . '/modules/smallworld/css/SmallworldAdmin.css'
 );     
 $xoTheme->addScript(
     XOOPS_URL . '/modules/smallworld/js/adminsmallworld.js'
 );  
-
-$aboutAdmin = new ModuleAdmin();
-
-echo $aboutAdmin->addNavigation('about.php');
-echo $aboutAdmin->renderAbout('', false);
-
 include 'admin_footer.php';
\ No newline at end of file

Modified: XoopsModules/smallworld/trunk/smallworld/sql/mysql.sql
===================================================================
--- XoopsModules/smallworld/trunk/smallworld/sql/mysql.sql	2013-05-22 07:38:03 UTC (rev 11572)
+++ XoopsModules/smallworld/trunk/smallworld/sql/mysql.sql	2013-05-22 13:01:51 UTC (rev 11573)
@@ -24,7 +24,7 @@
   PRIMARY KEY (`com_id`),
   KEY `msg_id_fk` (`msg_id_fk`),
   KEY `uid_fk` (`uid_fk`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 CREATE TABLE `smallworld_followers` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
@@ -55,14 +55,14 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 CREATE TABLE `smallworld_messages` (
-  `msg_id` int(11) NOT NULL auto_increment,
-  `message` varchar(200) default NULL,
-  `uid_fk` int(11) default NULL,
-  `priv` int(1) NOT NULL default '1',
-  `created` int(11) default '1269249260',
-  PRIMARY KEY  (`msg_id`),
+  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
+  `message` text,
+  `uid_fk` int(11) DEFAULT NULL,
+  `priv` int(1) NOT NULL DEFAULT '1',
+  `created` int(11) DEFAULT '1269249260',
+  PRIMARY KEY (`msg_id`),
   KEY `uid_fk` (`uid_fk`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=225 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 CREATE TABLE `smallworld_user` (
   `id` int(5) unsigned NOT NULL auto_increment,
@@ -152,4 +152,4 @@
   `userid` int(11) NOT NULL,
   `value` text NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;