Pro Forms 2000 v1.2 issue

Worker Joined: Feb 09, 2011 Posts: 188 Location: US

I downloaded pro-forms 1.2 from Clanthemes and I followed the instructions and installed it. However, after I drudged through the forums and turned on error reporting, this is what I get:

Quote:

Warning: main(/homepages/**/d*********/htdocs/h3llclan/html/modules/PRO_Forms/includes/extensions/PHPNUKE.php) [function.main]: failed to open stream: No such file or directory in /homepages/**/d*********/htdocs/h3llclan/html/modules/PRO_Forms/includes/system.php on line 0

Warning: main() [function.include]: Failed opening '/homepages/**/d*********/htdocs/h3llclan/html/modules/PRO_Forms/includes/extensions/PHPNUKE.php' for inclusion (include_path='.:/usr/lib/php5') in /homepages/**/d*********/htdocs/h3llclan/html/modules/PRO_Forms/includes/system.php on line 0

Fatal error: Call to undefined function extPF_header() in /homepages/**/d*********/htdocs/h3llclan/html/modules/PRO_Forms/prepf.php on line 12

I didn't move any files or delete any, I put ioncube in the proforms folder, and installed it, and the ioncube-loader-helper.php script said "successful". So, it has to be something with the program itself, or something I did wrong.

Posted: Sun Oct 09, 2011 10:38 am

Okay, I realized I didn't install something in the right place, so I did that, but now I get this when I go to the Pro_Forms page:

Quote:

Notice: Constant _NAME already defined in /homepages/16/d********/htdocs/h3llclan/html/modules/Shout_Box/lang-block/lang-english.php on line 16

Notice: Constant _OR already defined in /homepages/16/d*********/htdocs/h3llclan/html/modules/Shout_Box/lang-block/lang-english.php on line 33

Notice: Undefined variable: BannedShouter in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 109

Notice: Undefined variable: BannedShouter in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 116

Notice: Undefined variable: ShoutError in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 433

Notice: Undefined variable: preURL in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 543

Notice: Undefined variable: preURL in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 544

Notice: Undefined offset: 1 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined offset: 2 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined offset: 3 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined offset: 4 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined offset: 5 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined offset: 6 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined offset: 7 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined offset: 8 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined offset: 9 in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 604

Notice: Undefined variable: PreviousComment in /homepages/16/d*********/htdocs/h3llclan/html/blocks/block-CT_Shout_Box.php on line 650
the above was in the shoutbox area.

the below was in the pro-forms area:
Notice: Use of undefined constant License - assumed 'License' in /homepages/16/d*********/htdocs/h3llclan/html/modules/PRO_Forms/index.php on line 0

Notice: Use of undefined constant value - assumed 'value' in /homepages/16/d*********/htdocs/h3llclan/html/modules/PRO_Forms/index.php on line 0

Notice: Undefined offset: 0 in /homepages/16/d*********/htdocs/h3llclan/html/modules/PRO_Forms/index.php on line 0

Notice: Use of undefined constant FILE_EXPIRY - assumed 'FILE_EXPIRY' in /homepages/16/d*********/htdocs/h3llclan/html/modules/PRO_Forms/index.php on line 0
(mysql): SELECT * FROM `nuke_pf_config` ORDER BY formno
NO FORMS HAVE BEEN CONFIGURED YET
(mysql): SELECT user_password FROM `nuke_users` WHERE user_id = 2

(mysql): SELECT * FROM `nuke_pf_questions` WHERE inuse <> 0 AND isdel < 1 AND fldnum > 0 AND formno = -2 and parent = 0 ORDER BY fldord ASC

registered · Posted: Sun Oct 09, 2011 10:46 am

Those are just notices. You should be able to turn error reporting off in config.php and they will not appear any more. Many older modules and blocks will throw off notices....

Posted: Sun Oct 09, 2011 11:24 am

Oh, sweet Thanks allot.

Posted: Sun Oct 09, 2011 12:33 pm

I can clean those up for you if you can mail me the language file and the block file to
webmaster {AT} code-authors {dot} com
Please include a link to this thread so I remember what I'm doing Smile

I get tons of mail.

Posted: Sun Oct 09, 2011 9:18 pm

I have found one more issue, so far, and that is when I click on the form setup icon under pro-forms, it takes me to a blank page ( http://h3llclan.com/admin.php?op=PFsetup&formno=0 ). You know what would cause this?

The Application list, question list, and just about every button on there doesn't work either.

I turned on error reporting and this is what I getting.
On the main pro-form page:

Quote:

(mysql): SELECT * FROM `nuke_pf_config` ORDER BY formno ASC (mysql): SELECT * FROM `nuke_pf_config` WHERE formno = 0 (mysql): SELECT * FROM `nuke_pf_questions` WHERE isdel < 1 AND formno = 0 ORDER BY fldord (mysql): SELECT * FROM `nuke_pf_config`

This when I click on the form setup, application list, and question list icons:

Quote:

Warning: filesize() [function.filesize]: stat failed for abuse/abuse_default.tpl in /homepages/**/d********/htdocs/h3llclan/html/includes/nukesentinel.php on line 1056

Warning: fread(): supplied argument is not a valid stream resource in /homepages/**/d*********/htdocs/h3llclan/html/includes/nukesentinel.php on line 1056

I get this when I click on the view form in the admin panel:

Quote:

Notice: Use of undefined constant License - assumed 'License' in /homepages/**/d*********/htdocs/h3llclan/html/modules/PRO_Forms/index.php on line 0

Notice: Use of undefined constant value - assumed 'value' in /homepages/**/d*********/htdocs/h3llclan/html/modules/PRO_Forms/index.php on line 0

Notice: Undefined offset: 0 in /homepages/**/d*********/htdocs/h3llclan/html/modules/PRO_Forms/index.php on line 0

Notice: Use of undefined constant FILE_EXPIRY - assumed 'FILE_EXPIRY' in /homepages/**/d********/htdocs/h3llclan/html/modules/PRO_Forms/index.php on line 0
(mysql): SELECT * FROM `nuke_pf_config` ORDER BY formno (mysql): SELECT user_password FROM `nuke_users` WHERE user_id = 2

Challeng Form
(mysql): SELECT * FROM `nuke_pf_config` ORDER BY formno
(mysql): SELECT * FROM `nuke_pf_questions` WHERE inuse <> 0 AND isdel < 1 AND fldnum > 0 AND formno = 0 and parent = 0 ORDER BY fldord ASC

Posted: Sun Oct 09, 2011 11:05 pm

Apart from making sure those database tables exist, there is not much you can do with that module. There is no chance of fixing it because it's encrypted and you cannot therefore alter the code.
The only chance you have is to contact the original author.
I would assume the errors relating to filesize and read are due to the script using the fread() function which looks as though it is not allowed on your server.

Posted: Mon Oct 10, 2011 9:58 am

Okay, how do I allow "fread() in nuke sentinel, or would that be a bad thing? Also, the nuke_pf_config order, how do I fix that?
Would it just be smart to go into my database and just delete all that pro-forms imputed (which is going to be interesting because the main files is encoded).

Posted: Mon Oct 10, 2011 10:21 am

I was going to go out on a limb and guess your shared hosting provider does not allow you to use fread/fopen/ but that doesn't fully make sense. Some shared hosts disable functions with similar abilities but that is usually as a security measure to stop scripts opening remote files (not files on the same server).

Make sure you have the file on your server;
abuse/abuse_default.tpl
as that is the file being accessed on line 1056 of nukesentinel.php

I don't know what to recommend regarding Pro Forms - the files are encrypted so there is no way to fix any errors. Other than making sure the tables actually exist in your database, there is not much else you can do apart from turning error reporting off and hope for the best (not ideal).

Posted: Mon Oct 10, 2011 10:26 am

Here is the script for the SQL if anyone wants it:

Quote:

(mysql): SELECT * FROM `nuke_bbtopics` (mysql): SELECT * FROM `nuke_bbtopics` (mysql): SELECT * FROM `nuke_bbtopics` (mysql): SELECT * FROM `nuke_bbposts` (mysql): SELECT * FROM `nuke_bbvote_desc` (mysql): CREATE TABLE `nuke_pf_config` (`keyfld` int(11) NOT NULL auto_increment,`apptxt` longtext NOT NULL,`admaddr` text NOT NULL,`emdetail` tinyint(1) NOT NULL default '0',`fpdetail` tinyint(1) NOT NULL default '0',`group_id` mediumint( Cool

NOT NULL default '0',`forum_id` smallint(5) NOT NULL default '0',`tytxt` longtext NOT NULL,`noapptxt` longtext NOT NULL,`termsloc` tinyint(1) NOT NULL,`termspagetxt` longtext NOT NULL,`appson` tinyint(1) NOT NULL default '1',`current` tinyint(1) NOT NULL default '0',`formtitle` varchar(64) NOT NULL default '',`appslimit` tinyint(1) NOT NULL default '0',`appslimitno` int(11) NOT NULL default '0',`appsfull` tinyint(1) NOT NULL default '0',`group_add` mediumint( Cool

NOT NULL default '0',`block_multi_apps` tinyint(1) NOT NULL default '1',`email_admin` tinyint(1) NOT NULL default '1',`mailgroup` tinyint(1) NOT NULL default '0',`topicwatch` tinyint(1) NOT NULL default '0',`emuser` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`annon` tinyint(1) NOT NULL default '0',`VertAlign` tinyint(1) NOT NULL default '0',`auto_group` tinyint(1) NOT NULL default '0',`approvtxt` longtext NOT NULL,`denytxt` longtext NOT NULL,`formlist` tinyint(1) NOT NULL default '0',`compat` BOOL NOT NULL default '0',`emhtml` BOOL NOT NULL default '0',`restrict_group` BOOL NOT NULL default '0',`group_restrict` mediumint( Cool

NOT NULL default '0',`listapp` BOOL NOT NULL default '0',`showuser` BOOL NOT NULL default '0',`blockscroll` BOOL NOT NULL default '0',`rccolor` varchar(15) NOT NULL default '0',`dccolor` varchar(15) NOT NULL default '0',`accolor` varchar(15) NOT NULL default '0',`appslnsperpg` smallint(6) NOT NULL default '0',`setmanager` BOOL NOT NULL default '0',`group_manager` int(11) NOT NULL default '0',`approvedword` varchar(25) NOT NULL default '',`deniedword` varchar(25) NOT NULL default '',`recievedword` varchar(25) NOT NULL default '',`useauc` tinyint(1) NOT NULL,`addpoll` tinyint(1) NOT NULL,`poll_text` longtext NOT NULL,`poll_length` int(11) NOT NULL default '0',`poll_view_switch` tinyint(1) NOT NULL,`poll_options` longtext NOT NULL,`yani` text NOT NULL,`SubmitButton` varchar(24) NOT NULL default '',UNIQUE KEY `keyfld` (`keyfld`)) AUTO_INCREMENT=0 1050: Table 'nuke_pf_config' already exists

ADOConnection._Execute() % line 0, file: adodb.inc.php
ADOConnection.Execute() % line 0, file: functions_sql.php
PFsql_db.sql_query() % line 0, file: PForms_Install_200.php
install_1_0_1() % line 0, file: PForms_Install_200.php

Table 'nuke_pf_config' already existsCREATE TABLE `nuke_pf_config` (`keyfld` int(11) NOT NULL auto_increment,`apptxt` longtext NOT NULL,`admaddr` text NOT NULL,`emdetail` tinyint(1) NOT NULL default '0',`fpdetail` tinyint(1) NOT NULL default '0',`group_id` mediumint( Cool

NOT NULL default '0',`forum_id` smallint(5) NOT NULL default '0',`tytxt` longtext NOT NULL,`noapptxt` longtext NOT NULL,`termsloc` tinyint(1) NOT NULL,`termspagetxt` longtext NOT NULL,`appson` tinyint(1) NOT NULL default '1',`current` tinyint(1) NOT NULL default '0',`formtitle` varchar(64) NOT NULL default '',`appslimit` tinyint(1) NOT NULL default '0',`appslimitno` int(11) NOT NULL default '0',`appsfull` tinyint(1) NOT NULL default '0',`group_add` mediumint( Cool

NOT NULL default '0',`block_multi_apps` tinyint(1) NOT NULL default '1',`email_admin` tinyint(1) NOT NULL default '1',`mailgroup` tinyint(1) NOT NULL default '0',`topicwatch` tinyint(1) NOT NULL default '0',`emuser` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`annon` tinyint(1) NOT NULL default '0',`VertAlign` tinyint(1) NOT NULL default '0',`auto_group` tinyint(1) NOT NULL default '0',`approvtxt` longtext NOT NULL,`denytxt` longtext NOT NULL,`formlist` tinyint(1) NOT NULL default '0',`compat` BOOL NOT NULL default '0',`emhtml` BOOL NOT NULL default '0',`restrict_group` BOOL NOT NULL default '0',`group_restrict` mediumint( Cool

NOT NULL default '0',`listapp` BOOL NOT NULL default '0',`showuser` BOOL NOT NULL default '0',`blockscroll` BOOL NOT NULL default '0',`rccolor` varchar(15) NOT NULL default '0',`dccolor` varchar(15) NOT NULL default '0',`accolor` varchar(15) NOT NULL default '0',`appslnsperpg` smallint(6) NOT NULL default '0',`setmanager` BOOL NOT NULL default '0',`group_manager` int(11) NOT NULL default '0',`approvedword` varchar(25) NOT NULL default '',`deniedword` varchar(25) NOT NULL default '',`recievedword` varchar(25) NOT NULL default '',`useauc` tinyint(1) NOT NULL,`addpoll` tinyint(1) NOT NULL,`poll_text` longtext NOT NULL,`poll_length` int(11) NOT NULL default '0',`poll_view_switch` tinyint(1) NOT NULL,`poll_options` longtext NOT NULL,`yani` text NOT NULL,`SubmitButton` varchar(24) NOT NULL default '',UNIQUE KEY `keyfld` (`keyfld`)) AUTO_INCREMENT=0
Table 'nuke_pf_config' already existserror Message: Table 'nuke_pf_config' already exists SQL Error
(mysql): CREATE TABLE `nuke_pf_questions` (`fldnum` int(10) unsigned NOT NULL auto_increment,`fldord` int(11) NOT NULL default '0',`fldname` text NOT NULL,`requrd` char(1) NOT NULL default '',`inuse` char(1) NOT NULL default '',`format` char(1) NOT NULL default '',`parent` smallint(6) NOT NULL default '0',`isdel` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`rgextxt` text,`tarows` smallint(6) NOT NULL default '0',`tacols` smallint(6) NOT NULL default '0',`tatxt` longtext NOT NULL,`talign` varchar(6) NOT NULL,`rpos` varchar(20) NOT NULL,`ralign` varchar(6) NOT NULL,`qfnr` tinyint(1) NOT NULL,`qufl` tinyint(1) NOT NULL,`qframe` tinyint(1) NOT NULL, UNIQUE KEY `fldnum` (`fldnum`)) AUTO_INCREMENT=0 1050: Table 'nuke_pf_questions' already exists

ADOConnection._Execute() % line 0, file: adodb.inc.php
ADOConnection.Execute() % line 0, file: functions_sql.php
PFsql_db.sql_query() % line 0, file: PForms_Install_200.php
install_1_0_1() % line 0, file: PForms_Install_200.php

Table 'nuke_pf_questions' already existsCREATE TABLE `nuke_pf_config` (`keyfld` int(11) NOT NULL auto_increment,`apptxt` longtext NOT NULL,`admaddr` text NOT NULL,`emdetail` tinyint(1) NOT NULL default '0',`fpdetail` tinyint(1) NOT NULL default '0',`group_id` mediumint( Cool

NOT NULL default '0',`forum_id` smallint(5) NOT NULL default '0',`tytxt` longtext NOT NULL,`noapptxt` longtext NOT NULL,`termsloc` tinyint(1) NOT NULL,`termspagetxt` longtext NOT NULL,`appson` tinyint(1) NOT NULL default '1',`current` tinyint(1) NOT NULL default '0',`formtitle` varchar(64) NOT NULL default '',`appslimit` tinyint(1) NOT NULL default '0',`appslimitno` int(11) NOT NULL default '0',`appsfull` tinyint(1) NOT NULL default '0',`group_add` mediumint( Cool

NOT NULL default '0',`block_multi_apps` tinyint(1) NOT NULL default '1',`email_admin` tinyint(1) NOT NULL default '1',`mailgroup` tinyint(1) NOT NULL default '0',`topicwatch` tinyint(1) NOT NULL default '0',`emuser` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`annon` tinyint(1) NOT NULL default '0',`VertAlign` tinyint(1) NOT NULL default '0',`auto_group` tinyint(1) NOT NULL default '0',`approvtxt` longtext NOT NULL,`denytxt` longtext NOT NULL,`formlist` tinyint(1) NOT NULL default '0',`compat` BOOL NOT NULL default '0',`emhtml` BOOL NOT NULL default '0',`restrict_group` BOOL NOT NULL default '0',`group_restrict` mediumint( Cool

NOT NULL default '0',`listapp` BOOL NOT NULL default '0',`showuser` BOOL NOT NULL default '0',`blockscroll` BOOL NOT NULL default '0',`rccolor` varchar(15) NOT NULL default '0',`dccolor` varchar(15) NOT NULL default '0',`accolor` varchar(15) NOT NULL default '0',`appslnsperpg` smallint(6) NOT NULL default '0',`setmanager` BOOL NOT NULL default '0',`group_manager` int(11) NOT NULL default '0',`approvedword` varchar(25) NOT NULL default '',`deniedword` varchar(25) NOT NULL default '',`recievedword` varchar(25) NOT NULL default '',`useauc` tinyint(1) NOT NULL,`addpoll` tinyint(1) NOT NULL,`poll_text` longtext NOT NULL,`poll_length` int(11) NOT NULL default '0',`poll_view_switch` tinyint(1) NOT NULL,`poll_options` longtext NOT NULL,`yani` text NOT NULL,`SubmitButton` varchar(24) NOT NULL default '',UNIQUE KEY `keyfld` (`keyfld`)) AUTO_INCREMENT=0
CREATE TABLE `nuke_pf_questions` (`fldnum` int(10) unsigned NOT NULL auto_increment,`fldord` int(11) NOT NULL default '0',`fldname` text NOT NULL,`requrd` char(1) NOT NULL default '',`inuse` char(1) NOT NULL default '',`format` char(1) NOT NULL default '',`parent` smallint(6) NOT NULL default '0',`isdel` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`rgextxt` text,`tarows` smallint(6) NOT NULL default '0',`tacols` smallint(6) NOT NULL default '0',`tatxt` longtext NOT NULL,`talign` varchar(6) NOT NULL,`rpos` varchar(20) NOT NULL,`ralign` varchar(6) NOT NULL,`qfnr` tinyint(1) NOT NULL,`qufl` tinyint(1) NOT NULL,`qframe` tinyint(1) NOT NULL, UNIQUE KEY `fldnum` (`fldnum`)) AUTO_INCREMENT=0
Table 'nuke_pf_questions' already existserror Message: Table 'nuke_pf_questions' already exists SQL Error
(mysql): CREATE TABLE `nuke_pf_data` (`appno` int(11) NOT NULL auto_increment,`userno` int(11) NOT NULL default '0',`adate` text NOT NULL,`formno` int(11) NOT NULL default '0',`appstatus` tinyint(4) NOT NULL default '0',`qanda` longtext NOT NULL,`terms_on` tinyint(1) NOT NULL default '0',`terms_agree` tinyint(1) NOT NULL default '0',`user_ip` varchar(20) NOT NULL default '',`postid` int(11) NOT NULL default '0',`topid` int(11) NOT NULL default '0',`specialresponse` text NOT NULL,PRIMARY KEY (`appno`)) TYPE=MyISAM AUTO_INCREMENT=0 ; 1050: Table 'nuke_pf_data' already exists

ADOConnection._Execute() % line 0, file: adodb.inc.php
ADOConnection.Execute() % line 0, file: functions_sql.php
PFsql_db.sql_query() % line 0, file: PForms_Install_200.php
install_1_0_1() % line 0, file: PForms_Install_200.php

Table 'nuke_pf_data' already existsCREATE TABLE `nuke_pf_config` (`keyfld` int(11) NOT NULL auto_increment,`apptxt` longtext NOT NULL,`admaddr` text NOT NULL,`emdetail` tinyint(1) NOT NULL default '0',`fpdetail` tinyint(1) NOT NULL default '0',`group_id` mediumint( Cool

NOT NULL default '0',`forum_id` smallint(5) NOT NULL default '0',`tytxt` longtext NOT NULL,`noapptxt` longtext NOT NULL,`termsloc` tinyint(1) NOT NULL,`termspagetxt` longtext NOT NULL,`appson` tinyint(1) NOT NULL default '1',`current` tinyint(1) NOT NULL default '0',`formtitle` varchar(64) NOT NULL default '',`appslimit` tinyint(1) NOT NULL default '0',`appslimitno` int(11) NOT NULL default '0',`appsfull` tinyint(1) NOT NULL default '0',`group_add` mediumint( Cool

NOT NULL default '0',`block_multi_apps` tinyint(1) NOT NULL default '1',`email_admin` tinyint(1) NOT NULL default '1',`mailgroup` tinyint(1) NOT NULL default '0',`topicwatch` tinyint(1) NOT NULL default '0',`emuser` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`annon` tinyint(1) NOT NULL default '0',`VertAlign` tinyint(1) NOT NULL default '0',`auto_group` tinyint(1) NOT NULL default '0',`approvtxt` longtext NOT NULL,`denytxt` longtext NOT NULL,`formlist` tinyint(1) NOT NULL default '0',`compat` BOOL NOT NULL default '0',`emhtml` BOOL NOT NULL default '0',`restrict_group` BOOL NOT NULL default '0',`group_restrict` mediumint( Cool

NOT NULL default '0',`listapp` BOOL NOT NULL default '0',`showuser` BOOL NOT NULL default '0',`blockscroll` BOOL NOT NULL default '0',`rccolor` varchar(15) NOT NULL default '0',`dccolor` varchar(15) NOT NULL default '0',`accolor` varchar(15) NOT NULL default '0',`appslnsperpg` smallint(6) NOT NULL default '0',`setmanager` BOOL NOT NULL default '0',`group_manager` int(11) NOT NULL default '0',`approvedword` varchar(25) NOT NULL default '',`deniedword` varchar(25) NOT NULL default '',`recievedword` varchar(25) NOT NULL default '',`useauc` tinyint(1) NOT NULL,`addpoll` tinyint(1) NOT NULL,`poll_text` longtext NOT NULL,`poll_length` int(11) NOT NULL default '0',`poll_view_switch` tinyint(1) NOT NULL,`poll_options` longtext NOT NULL,`yani` text NOT NULL,`SubmitButton` varchar(24) NOT NULL default '',UNIQUE KEY `keyfld` (`keyfld`)) AUTO_INCREMENT=0
CREATE TABLE `nuke_pf_questions` (`fldnum` int(10) unsigned NOT NULL auto_increment,`fldord` int(11) NOT NULL default '0',`fldname` text NOT NULL,`requrd` char(1) NOT NULL default '',`inuse` char(1) NOT NULL default '',`format` char(1) NOT NULL default '',`parent` smallint(6) NOT NULL default '0',`isdel` tinyint(1) NOT NULL default '0',`formno` int(11) NOT NULL default '0',`rgextxt` text,`tarows` smallint(6) NOT NULL default '0',`tacols` smallint(6) NOT NULL default '0',`tatxt` longtext NOT NULL,`talign` varchar(6) NOT NULL,`rpos` varchar(20) NOT NULL,`ralign` varchar(6) NOT NULL,`qfnr` tinyint(1) NOT NULL,`qufl` tinyint(1) NOT NULL,`qframe` tinyint(1) NOT NULL, UNIQUE KEY `fldnum` (`fldnum`)) AUTO_INCREMENT=0
CREATE TABLE `nuke_pf_data` (`appno` int(11) NOT NULL auto_increment,`userno` int(11) NOT NULL default '0',`adate` text NOT NULL,`formno` int(11) NOT NULL default '0',`appstatus` tinyint(4) NOT NULL default '0',`qanda` longtext NOT NULL,`terms_on` tinyint(1) NOT NULL default '0',`terms_agree` tinyint(1) NOT NULL default '0',`user_ip` varchar(20) NOT NULL default '',`postid` int(11) NOT NULL default '0',`topid` int(11) NOT NULL default '0',`specialresponse` text NOT NULL,PRIMARY KEY (`appno`)) TYPE=MyISAM AUTO_INCREMENT=0 ;
Table 'nuke_pf_data' already existserror Message: Table 'nuke_pf_data' already exists SQL Error

ERROR(1050) Table 'nuke_pf_data' already exists
ERROR 28 - Unable to create response table!
CREATE TABLE `nuke_pf_data` (`appno` int(11) NOT NULL auto_increment,`userno` int(11) NOT NULL default '0',`adate` text NOT NULL,`formno` int(11) NOT NULL default '0',`appstatus` tinyint(4) NOT NULL default '0',`qanda` longtext NOT NULL,`terms_on` tinyint(1) NOT NULL default '0',`terms_agree` tinyint(1) NOT NULL default '0',`user_ip` varchar(20) NOT NULL default '',`postid` int(11) NOT NULL default '0',`topid` int(11) NOT NULL default '0',`specialresponse` text NOT NULL,PRIMARY KEY (`appno`)) TYPE=MyISAM AUTO_INCREMENT=0 ;.
Error: (1050) Table 'nuke_pf_data' already exists

Posted: Mon Oct 10, 2011 10:57 am

Thanks for your help. I was reading in another forum, either here or one Clanthemes and unless I missunderstood, the guy who made it/ designed it died. There was a guy trying to get it from the widow, but I didn't read all of it, so I don't know how it went.

One other thing, I got it to work right (so far) as a stand alone. It is with it integrated that seems to be causing the errors. I wonder if it is in the PHPNUKE integration section?

here is the code for it:

Quote:

<?php

/***************************************************************************
*
* This is an example of how to integrate Pro Forms with PHP-Nuke based CMS's.
*
***************************************************************************/

function extPF_header()
{
require_once("mainfile.php");
include_once("header.php");
}

function extPF_OpenTable()
{
OpenTable();
}

function extPF_CloseTable()
{
CloseTable();
}

function extPF_footer()
{
require("footer.php");
}
function extPF_AdmLinkDir()
{
global $admin_file, $nukeurl;
$tmprpath = $nukeurl;
$pfadmlinkdir = $tmprpath."/".$admin_file.'.php';
return $pfadmlinkdir;
}
function extPF_LinkDir()
{
global $nukeurl;
$tmprpath = $nukeurl;
$pfadmlinkdir = $tmprpath.'/modules.php?name=PRO_Forms';
return $pfadmlinkdir;
}
$extpathmodifier = "/modules/PRO_Forms"
?>

Posted: Mon Oct 10, 2011 11:18 am

I cannot see anything wrong with that code. The paths being built would be correct provided no one accidentally added a trailing slash to the nukeurl in the site preferences. In any event, if that was the case, it would trip a PHP error and you would see a double slash in the path reported.

Posted: Mon Oct 10, 2011 11:36 am

I set it up as a stand alone and it works just fine. No problems as of yet. I don't know what it could be. Maybe something else is messed up in my site and is causing this. I have no clue.

Posted: Mon Oct 10, 2011 1:38 pm

Yes... when I first came to RN that was the first thing I tried to get working. He had passed and I only had that one conversation with his widow as I'm not the type to push someone in that type of situation.

Also, his code was locked down with some code locker and his widow didn't really know anything about the source files.

Pretty much... that modules is done where it is.

Posted: Mon Oct 10, 2011 1:53 pm

To me it seems like it can't find the files under my webserver, or they are misnamed.

Posted: Mon Oct 10, 2011 2:39 pm

Do you know of another one? Or have the paid for one?

Posted: Mon Oct 10, 2011 2:41 pm

There was no "paid for one"... he passed before he finished it as far as I can tell. I ended up coding my own form from scratch.

Posted: Mon Oct 10, 2011 2:50 pm

You have one like his I can use? I would love to have a better integration then what his had. I have had nothing but issues with it. I am trying to integrate it with the Tournament Champion module that I got from Clanthemes, and it said to download the pro-form 2.1 lite, however I only got the tournament champion to work. My goals is to have it where anyone can come to our website and challenge our clan without actually having to create an account. However, that may not be possible, but it is what I am shooting for.

Posted: Mon Oct 10, 2011 2:53 pm

killing-hours wrote:

I ended up coding my own form from scratch.

Posted: Mon Oct 10, 2011 2:55 pm

Thank you for your time. I understand. It sucks when you can't get support for something like that. Sad

Posted: Mon Oct 10, 2011 3:01 pm

Here's something to think about... IF you leave any type of form open to the public... it's bound to be abused somehow. However you decide to go with it... make sure you have server side validation on it and make sure to have some sort of captcha on it to ensure it's not abused by bots.

Sorry I couldn't help you further.

Posted: Mon Oct 10, 2011 3:03 pm

You have been a great help. Thank you for taking the time.

Posted: Tue Oct 11, 2011 11:45 am

One other thing I found, I got it installed as a stand alone, but when a challenge form is filled out and submitted, it won't notify all users, only the admin. Anything I can do to fix it?

Posted: Tue Oct 11, 2011 12:49 pm

It depends what it's coded to do and since we can't access the code........

Posted: Tue Oct 11, 2011 6:41 pm

I feel I am wasting my time with this pro-form. I thought it might just be a setting...I will keep trying to see what I can find.