Appnitro Software Forums » MachForm

Problem with validate_username function

(12 posts)
  • Started 2 years ago by idckamikaze
  • Latest reply from yuniar

  1. idckamikaze
    Member

    I installed the Exec-PHP plugin for Wordpress to be able to execute PHP on a certain page (where a MachForm would be displayed). When I try to embed the form using the code generated in my admin panel, it gives me an error in the validate_username() function.
    Cannot redeclare validate_username() (previously declared in /homepages/32/d239429970/htdocs/mdpc/wp-includes/registration.php:49) in /homepages/32/d239429970/htdocs/machform/includes/common-validator.php on line 242

    I think this relates to my previous post about unique identifiers in XHTML. Wordpress has a registration.php file that uses the validate_username() function. MachForm also uses this function, however, I don't have enough coding knowledge to know how it relates to the ability to embed the form. I used the iframe code and I achieved what I set out to do, but I think this is an important point for future revisions of MachForm.

    Posted 2 years ago #

  2. yuniar
    MachForm Founder

    Go to line 243 of "includes/common-validator.php" file. You'll find this line:

    function validate_username($value){

    change it to become:

    function validate_user_name($value){

    or any other similar function name. Thanks for the suggestion on this.

    Posted 2 years ago #

  3. idckamikaze
    Member

    That worked and then I got a similar error on helper_functions.php, line 201, function show_message. I changed that to show_machform_message (also used in manage_form, not sure where else), but that only fixed the function conflicts.

    Now it seems like I'm getting SQL errors. This displays:
    select form_name, form_description, form_redirect, form_success_message, form_password, form_unique_ip, form_frame_height, form_has_css, form_active, form_captcha, form_review from ap_forms where form_id='2' Query failed: Table 'db273972956.ap_forms' doesn't exist

    The only thing I can figure is the query is trying to run on my WP database and not the MachForm database. It isn't critical that I use the PHP embedding feature, but I thought it would be nice to have Wordpress integration. Any thoughts would be appreciated.

    Posted 2 years ago #

  4. yuniar
    MachForm Founder

    Apparently, WordPress and MachForm are using the same constant name for the database. That's why it won't able to select machform database.

    To fix it, edit your "includes/db-core.php" file. Around line 12 you will find this:

    mysql_select_db(DB_NAME) or die('Could not select database');

    change the DB_NAME above with your machform database name, example:

    mysql_select_db('my_machform') or die('Could not select database');

    make sure to put quotes as above.

    also, adjust your php embed code, add the code to re-select your wordpress db. like this:

    <?php
	require("/appnitro/machform/machform.php");
	$mf_param['form_id'] = 519;
	$mf_param['base_path'] = 'http://example.com/machform/';
	display_machform($mf_param);
	mysql_select_db('your_wordpress_db_here'); //<-- this line
?>
    Posted 2 years ago #

  5. idckamikaze
    Member

    I forgot to mention that the MachForm db and the Wordpress db are on separate servers (I'm on a virtual host). Would I need to define the parameters for the MachForm database in the db-core.php file, or could I import the config.php file into the db-core file?

    Posted 2 years ago #

  6. yuniar
    MachForm Founder

    Ah.. I see. If that is the case, you need to edit another line of db-core.php file.

    Search for this line:

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Could not connect: ' . mysql_error());

    change the DB_HOST, DB_USER and DB_PASSWORD above with a quoted string, exactly like DB_NAME

    Posted 2 years ago #

  7. bfkouba
    Member

    This was helpful... this is the information you need (including that last step) if you're having trouble integrating with wordpress. Worked for me.

    Posted 2 years ago #

  8. jolynnbraley
    Member

    Hi, in your comment above where you wrote, "also, adjust your php embed code, add the code to re-select your wordpress db. like this:", which is followed by the block of code underneath.....what is the exact name of the file that code is to be placed in?

    Thanks!

    Posted 1 year ago #

  9. yuniar
    MachForm Founder

    That code should be placed into your WordPress post/page, which you can do it from WordPress admin panel.

    Posted 1 year ago #

  10. jolynnbraley
    Member

    Thanks Yuniar. My db's run on the same server but I also had to add in those other changes to the $link line of code after making the change in my php code in my WP page, and now the form is displaying in my WP page.

    It has a couple other issues and I'll work on those now, and then I want to connect it to Aweber. At least it's connecting to the db now though - progress is being made! :)

    JoLynn

    Posted 1 year ago #

  11. jvarn1
    Member

    It's a pain to have to remember to add:

    mysql_select_db('your_wordpress_db_here'); //<-- this line

    Every time in the embed code.

    Instead I just did a search and replace on DB_NAME, DB_PASSWORD, DB_USER, and DB_HOST across all the MachForm files using Coda and replaced all occurrences with MF_DB_NAME, MF_DB_PASSWORD etc.

    This way I can still use the copy-and-pasteable embed code from within MachForms without having to add the additional line above.

    Posted 1 year ago #

  12. yuniar
    MachForm Founder

    jvarn -- yep, that works best indeed. As a matter of fact, I think we'll doing it that way for the next update.

    Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.