XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. Xoops Development 
  4.  / oryxgen V 0.6
Register
1
oryxvet
oryxgen V 0.6

  • 2006/3/16 18:37

  • oryxvet

  • Just popping in

  • Posts: 24

  • Since: 2005/4/22


Here is the new oryxgen version (xoops module generator) witch include

--> a Generation of SQL file
--> New css menu avalable for IE (not perfect but ... )
--> Add a permission system
--> Add automatic managment of cols called : "uid_update", "uid_create", "user_id" ou "uid"
....
have a good time


http://www.oryxvet.com/dev/upload/oryxgen_0.6.rar
2
domecc
Re: oryxgen V 0.6

  • 2006/3/16 19:06

  • domecc

  • Just popping in

  • Posts: 71

  • Since: 2005/10/30


It's wonderful!
Thanks very much!
XoopsChina Webmaster
3
aixos
Re: oryxgen V 0.6

  • 2006/4/2 11:37

  • aixos

  • Just popping in

  • Posts: 79

  • Since: 2004/12/31


If you have a error in istalation
Quote:
"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 15"



see:
solution

you can edit the .sql files to remove the expression DEFAULT CHARSET-latin1

the good code is this :
code .sql
-- table `xg_class`

CREATE TABLE `xg_class` (
  `class_id` mediumint(8) NOT NULL auto_increment,
  `class_name` varchar(60) NOT NULL default '',
  `class_short_name` char(3) NOT NULL default '',
  `module_id` mediumint(8) NOT NULL default '0',
  `primary_field_name` varchar(60) NOT NULL default '',
  `is_for_admin` tinyint(1) NOT NULL default '0',
  `is_for_creator` tinyint(1) NOT NULL default '0',
  `in_block` tinyint(1) NOT NULL default '1',
  `is_wrf_valid` tinyint(1) NOT NULL default '0',
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`class_id`)
) ENGINE=MyISAM ;

-- table `xg_module`

CREATE TABLE `xg_module` (
  `module_id` mediumint(8) NOT NULL auto_increment,
  `module_name` varchar(30) NOT NULL default '0',
  `short_name` char(2) NOT NULL default '',
  `version` varchar(10) NOT NULL default '',
  `master_class_name` varchar(60) NOT NULL default '0',
  `date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`module_id`)
) ENGINE=MyISAM ;

-- table `xg_field_def`

CREATE TABLE `xg_field_def` (
  `field_id` mediumint(8) NOT NULL auto_increment,
  `key_id` mediumint(8) NOT NULL default '0',
  `class_id` mediumint(8) NOT NULL default '0',
  `field_name` varchar(60) NOT NULL default '',
  `field_type` varchar(60) NOT NULL default '',
  `html_type` varchar(60) NOT NULL default '',
  `size` mediumint(8) NOT NULL default '0',
  `html_extra` varchar(100) NOT NULL default '',
  `source_join_key` varchar(60) NOT NULL default '',
  `foreign_class` varchar(60) NOT NULL default '',
  `weight` smallint(3) NOT NULL default '0',
  `tray` varchar(20) NOT NULL default '',
  `default_value` varchar(80) NOT NULL default '',
  `is_needed` tinyint(1) NOT NULL default '0',
  `is_in_create_form` tinyint(1) NOT NULL default '0',
  `is_in_modif_form` tinyint(1) NOT NULL default '0',
  `is_search` tinyint(1) NOT NULL default '0',
  `is_list_show` tinyint(1) NOT NULL default '0',
  `is_partof_desc` tinyint(1) NOT NULL default '0',
  `is_partof_key_unicity` tinyint(1) NOT NULL default '0',
  `with_help` tinyint(1) NOT NULL default '0',
  `uid` mediumint(8) NOT NULL default '0',
  `date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`field_id`)
) ENGINE=MyISAM ;

-- table `xg_statut`

CREATE TABLE `xg_statut` (
  `statut_id` mediumint(8) NOT NULL auto_increment,
  `class_id` mediumint(8) NOT NULL default '0',
  `statut_number` tinyint(2) NOT NULL default '0',
  `with_historique` tinyint(1) NOT NULL default '0',
  `template_visu` mediumint(8) NOT NULL default '0',
  `statut_name` varchar(30) NOT NULL default '0',
  `date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`statut_id`)
) ENGINE=MyISAM ;

-- table `xg_statut_criteria`

CREATE TABLE `xg_statut_criteria` (
  `criteria_id` mediumint(8) NOT NULL auto_increment,
  `statut_id` mediumint(8) NOT NULL default '0',
  `php_variable_name` varchar(60) NOT NULL default '',
  `class_id` mediumint(8) NOT NULL default '0',
  `field_name` varchar(60) NOT NULL default '0',
  `value` varchar(30) NOT NULL default '0',
  `operator` varchar(10) NOT NULL default '0',
  `transition` varchar(20) NOT NULL default '',
  `uid` mediumint(8) NOT NULL default '0',
  `date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`criteria_id`)
) ENGINE=MyISAM ;

-- table `xg_statut_field`

CREATE TABLE `xg_statut_field` (
  `statut_field_id` mediumint(8) NOT NULL auto_increment,
  `field_id` mediumint(8) NOT NULL default '0',
  `statut_id` mediumint(8) NOT NULL default '0',
  `rang` smallint(2) NOT NULL default '0',
  `date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`statut_field_id`),
  UNIQUE KEY `statut_field_id` (`statut_field_id`)
) ENGINE=MyISAM ;

-- table `xg_action`

CREATE TABLE `xg_action` (
  `action_id` mediumint(8) NOT NULL auto_increment,
  `action_name` varchar(60) NOT NULL default '',
  `weight` mediumint(3) NOT NULL default '0',
  `with_confirm` tinyint(1) NOT NULL default '0',
  `statut_id` mediumint(8) NOT NULL default '0',
  `class_id` mediumint(8) NOT NULL default '0',
  `date_creation` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`action_id`)
) ENGINE=MyISAM ;


The instalacion is a correct in this moment
best regarts
aixos
4
menochi
Re: oryxgen V 0.6

  • 2006/4/2 19:03

  • menochi

  • Friend of XOOPS

  • Posts: 259

  • Since: 2003/12/28


Hi oryxve

thank you for sharing this module with us. Hope I can play with it in the next days .
in valid code we trust
5
avoulvou
Re: oryxgen V 0.6

  • 2006/4/3 15:04

  • avoulvou

  • Just popping in

  • Posts: 41

  • Since: 2006/2/23


Hi oryxve

thank you for sharing this module with us. I will play with it in the next days
hhttp://xoops.gr - XOOPS.gr Greek Support
6
oryxvet
Re: oryxgen V 0.6

  • 2006/4/3 16:02

  • oryxvet

  • Just popping in

  • Posts: 24

  • Since: 2005/4/22


I have correct this small bug in this package :

http://www.oryxvet.com/dev/upload/oryxgen_0.6.rar

Is there someone who generate something usable with oryxgen ?
Just curious.
7
cerbero
Re: oryxgen V 0.6

  • 2006/4/5 16:22

  • cerbero

  • Not too shy to talk

  • Posts: 191

  • Since: 2003/9/11


testing in localhost i've only obtained this error trying to access the module:

Fatal error: Class xoopsformtextdateselect: Cannot inherit from undefined class xoopsformcalendar in c:appservwwwx223classxoopsformformtextdateselect.php on line 52
...
8
oryxvet
Re: oryxgen V 0.6

  • 2006/4/5 16:42

  • oryxvet

  • Just popping in

  • Posts: 24

  • Since: 2005/4/22


Haihaihai !

oryxgen is useful with XOOPS 2.0.13. I suppose you use XOOPS 223. I never test it in such version.

To correct this bug (i'm not sure that it was the last), add in the file c:\appserv\www\x223\class\oryxgen\form\formloader.php

before this line
include_once XOOPS_ROOT_PATH.'/class/xoopsform/formtextdateselect.php';

add this line
include_once XOOPS_ROOT_PATH.'/class/xoopsform/xoopsformcalendar.php';


Best regards
9
cerbero
Re: oryxgen V 0.6

  • 2006/4/5 17:36

  • cerbero

  • Not too shy to talk

  • Posts: 191

  • Since: 2003/9/11


Results:

Fatal error: Class xoopsformtextdateselect: Cannot inherit from undefined class xoopsformcalendar in c:appservwwwx223classxoopsformformtextdateselect.php on line 52
Warning [PHP]: main(c:/appserv/www/x223/class/xoopsform/xoopsformcalendar.php): failed to open stream: No such file or directory in file c:appservwwwx223classoryxgenformformloader.php line 44
Warning [PHP]: main(): Failed opening 'c:/appserv/www/x223/class/xoopsform/xoopsformcalendar.php' for inclusion (include_path='.;c:php4pear') in file c:appservwwwx223classoryxgenformformloader.php line 44


thanks anyway for your quick response
...
10
oryxvet
Re: oryxgen V 0.6

  • 2006/4/6 10:10

  • oryxvet

  • Just popping in

  • Posts: 24

  • Since: 2005/4/22


Sorry,

I can't spend time to correct oryxgen for XOOPS 2.2 or 2.3. I keep development on 2.0 for the moment.
I'm waiting for the early stable version of 2.2.4 or 2.3 to adapt oryxgen to this new versions.

The 2.2.3 is not really stable. you'll get better results by using the latest 2.0.x release.

For example in the 2.2.3 in the XoopsMySQLDatabase class the quoteString function is

function quoteString($str)
{
 if (is_string($str)) {
  $str = "'".str_replace('\"', '"', addslashes($str))."'";
 }
 return $str;
}


In XOOPS 2.0.13, the code is
function quoteString($str)
{
  $str = "'".str_replace('\"', '"', addslashes($str))."'";
  return $str;
}


I use this function to format field in the SQL requests. In 2.2.3 if my string is "" the quoteString return blank (becaus e "" isn't a string) witch provide a sql error...
Should i correct this in the oryxgen module or not ?

For me the quoteString will become
function quoteString($str)
{
  if (is_string($str)) {
      $str = "'".str_replace('\"', '"', addslashes($str))."'";
  } else if (!$str) {
     $str ="''";
  }
  return $str;
}


But i don't know if it is a bug or something of desired.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

491 user(s) are online (396 user(s) are browsing Support Forums)

Members: 0

Guests: 491

more...

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits