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_idmediumint(8NOT NULL auto_increment,
  `
class_namevarchar(60NOT NULL default '',
  `
class_short_namechar(3NOT NULL default '',
  `
module_idmediumint(8NOT NULL default '0',
  `
primary_field_namevarchar(60NOT NULL default '',
  `
is_for_admintinyint(1NOT NULL default '0',
  `
is_for_creatortinyint(1NOT NULL default '0',
  `
in_blocktinyint(1NOT NULL default '1',
  `
is_wrf_validtinyint(1NOT NULL default '0',
  `
uidmediumint(8unsigned NOT NULL default '0',
  `
date_creationdatetime NOT NULL default '0000-00-00 00:00:00',
  `
date_last_updatedatetime NOT NULL default '0000-00-00 00:00:00',
  
PRIMARY KEY  (`class_id`)
ENGINE=MyISAM ;

-- 
table `xg_module`

CREATE TABLE `xg_module` (
  `
module_idmediumint(8NOT NULL auto_increment,
  `
module_namevarchar(30NOT NULL default '0',
  `
short_namechar(2NOT NULL default '',
  `
versionvarchar(10NOT NULL default '',
  `
master_class_namevarchar(60NOT NULL default '0',
  `
date_creationdatetime NOT NULL default '0000-00-00 00:00:00',
  `
date_last_updatedatetime 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_idmediumint(8NOT NULL auto_increment,
  `
key_idmediumint(8NOT NULL default '0',
  `
class_idmediumint(8NOT NULL default '0',
  `
field_namevarchar(60NOT NULL default '',
  `
field_typevarchar(60NOT NULL default '',
  `
html_typevarchar(60NOT NULL default '',
  `
sizemediumint(8NOT NULL default '0',
  `
html_extravarchar(100NOT NULL default '',
  `
source_join_keyvarchar(60NOT NULL default '',
  `
foreign_classvarchar(60NOT NULL default '',
  `
weightsmallint(3NOT NULL default '0',
  `
trayvarchar(20NOT NULL default '',
  `
default_valuevarchar(80NOT NULL default '',
  `
is_neededtinyint(1NOT NULL default '0',
  `
is_in_create_formtinyint(1NOT NULL default '0',
  `
is_in_modif_formtinyint(1NOT NULL default '0',
  `
is_searchtinyint(1NOT NULL default '0',
  `
is_list_showtinyint(1NOT NULL default '0',
  `
is_partof_desctinyint(1NOT NULL default '0',
  `
is_partof_key_unicitytinyint(1NOT NULL default '0',
  `
with_helptinyint(1NOT NULL default '0',
  `
uidmediumint(8NOT NULL default '0',
  `
date_creationdatetime NOT NULL default '0000-00-00 00:00:00',
  `
date_last_updatedatetime NOT NULL default '0000-00-00 00:00:00',
  
PRIMARY KEY  (`field_id`)
ENGINE=MyISAM ;

-- 
table `xg_statut`

CREATE TABLE `xg_statut` (
  `
statut_idmediumint(8NOT NULL auto_increment,
  `
class_idmediumint(8NOT NULL default '0',
  `
statut_numbertinyint(2NOT NULL default '0',
  `
with_historiquetinyint(1NOT NULL default '0',
  `
template_visumediumint(8NOT NULL default '0',
  `
statut_namevarchar(30NOT NULL default '0',
  `
date_creationdatetime NOT NULL default '0000-00-00 00:00:00',
  `
date_last_updatedatetime 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_idmediumint(8NOT NULL auto_increment,
  `
statut_idmediumint(8NOT NULL default '0',
  `
php_variable_namevarchar(60NOT NULL default '',
  `
class_idmediumint(8NOT NULL default '0',
  `
field_namevarchar(60NOT NULL default '0',
  `
valuevarchar(30NOT NULL default '0',
  `
operatorvarchar(10NOT NULL default '0',
  `
transitionvarchar(20NOT NULL default '',
  `
uidmediumint(8NOT NULL default '0',
  `
date_creationdatetime NOT NULL default '0000-00-00 00:00:00',
  `
date_last_updatedatetime 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_idmediumint(8NOT NULL auto_increment,
  `
field_idmediumint(8NOT NULL default '0',
  `
statut_idmediumint(8NOT NULL default '0',
  `
rangsmallint(2NOT NULL default '0',
  `
date_creationdatetime NOT NULL default '0000-00-00 00:00:00',
  `
date_last_updatedatetime 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_idmediumint(8NOT NULL auto_increment,
  `
action_namevarchar(60NOT NULL default '',
  `
weightmediumint(3NOT NULL default '0',
  `
with_confirmtinyint(1NOT NULL default '0',
  `
statut_idmediumint(8NOT NULL default '0',
  `
class_idmediumint(8NOT NULL default '0',
  `
date_creationdatetime NOT NULL default '0000-00-00 00:00:00',
  `
date_last_updatedatetime 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
http://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 xoopsformtextdateselectCannot 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 xoopsformtextdateselectCannot 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 streamNo 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

Who's Online

138 user(s) are online (80 user(s) are browsing Support Forums)


Members: 0


Guests: 138


more...

Donat-O-Meter

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

Latest GitHub Commits