Re: oryxgen V 0.6 [Xoops Development] - XOOPS Web Application System

1

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

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

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

le="color: #000000"><?php -- 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

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

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

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

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:

le="color: #000000"><?php Fatal error: Class xoopsformtextdateselect: Cannot inherit from undefined class xoopsformcalendar in c:appservwwwx223classxoopsformformtextdateselect.php on line 52

...

8

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

le="color: #000000"><?php include_once XOOPS_ROOT_PATH.'/class/xoopsform/formtextdateselect.php';

add this line

le="color: #000000"><?php include_once XOOPS_ROOT_PATH.'/class/xoopsform/xoopsformcalendar.php';

Best regards

9

Re: oryxgen V 0.6

2006/4/5 17:36
cerbero
Not too shy to talk
Posts: 191
Since: 2003/9/11

Results:

le="color: #000000"><?php 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

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

le="color: #000000"><?php function quoteString($str) { if (is_string($str)) { $str = "'".str_replace('\"', '"', addslashes($str))."'"; } return $str; }

In XOOPS 2.0.13, the code is

le="color: #000000"><?php 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

le="color: #000000"><?php 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.

Stats
Goal:	$15.00
Due Date:	Jul 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$15.00

oryxgen V 0.6

Re: oryxgen V 0.6

Re: oryxgen V 0.6

Re: oryxgen V 0.6

Re: oryxgen V 0.6

Re: oryxgen V 0.6

Re: oryxgen V 0.6

Re: oryxgen V 0.6

Re: oryxgen V 0.6

Re: oryxgen V 0.6

Login

Search

Recent Posts

Re: XOOPS Debugbar 1.3.0 released

XOOPS Debugbar 1.3.0 released

Re: XOOPS 2.7.1-RC1 Released for Testing

Re: XOOPS 2.7.1-RC1 Released for Testing

Coming soon: fully rewritten PEDIGREE

XOOPS Cocktails available for testing

Quotes module available for testing

mTools available for testing

XOOPS 2.7.1-RC1 Released for Testing

Re: New XOOPS 2.7.0 Documentation in development

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}