[sweller]

Yeah, it seems to work fine by replacing the three lines of the username block with mt_rand. However be sure that there are letters somewhere in the value, such as the “mem” above. Buddypress will throw back an error without letters.

Also this probably wouldn’t work with large websites with thousands of people, as the chance of generating the same username goes up. You’d probably have to write a function that generates a long string of random letters and numbers.

[sweller]

I was looking for the same solution and appreciate all the work you guys have done. However the javascript solution seems like a long way to generate a random string. Is there a reason not to use the mt_rand function or something similar? So to add “mem” the username form would look like:

<input type="hidden" name="signup_username" id="signup_username" value="<?php echo("mem" . mt_rand()) ?>" />

[sweller]

I’d like to open this one back up. The project is for a local recycling program and I’m having trouble with a form for members to schedule pickups on the profile/index page. It calls XProfile address fields and tomorrow’s date for the default values, and should insert them into a custom table. The plugin creates a table and pulls the xprofile data fine, but nothing is reaching the database. I’ve tried every possible variation based on the bp-core and Travel-Junkie’s example above, but nothing is working.

Here’s the plugin:

<?php

/*

Plugin Name: Collection Records

Plugin URI: -

Description: Adds a table and page for listing and editing Recylable Collections.

Version: 1.0

*/



function collect_install_table() {

global $wpdb;

global $bp;



if ( !empty($wpdb->charset) )

$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";



$table_name = $wpdb->prefix . 'collections';

if($wpdb->get_var("show tables like '$table_name'") != $table_name) {



$sql = "CREATE TABLE " . $table_name . " (

id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,

sched_date datetime NOT NULL,

post_date datetime NOT NULL,

user_id bigint(20) UNSIGNED NOT NULL,

address_line_1 varchar(150) NOT NULL,

address_line_2 varchar(150) NOT NULL,

town varchar(150) NOT NULL,

state varchar(150) NOT NULL,

zip_code varchar(150) NOT NULL,

amount bigint(20) DEFAULT '0' NOT NULL,

verified tinyint(1) DEFAULT '1' NOT NULL,

paid tinyint(1) DEFAULT '1' NOT NULL,

KEY user_id (user_id)

) {$charset_collate};";



require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

dbDelta($sql);

}

}



/*Launch database*/

register_activation_hook(__FILE__,'collect_install_table');



function bp_collections() {

global $wpdb;

global $bp;



/* bp_is_home() Checks to make sure the current user being viewed equals the logged in user */



if ( !bp_is_home() && !is_site_admin() )

return false;



/* Check for new information*/

if( isset($_POST['go'] ))

{

/* Check the nonce */



check_admin_referer( 'schedule_collect' );



if( $_POST['sched_date'] && ! $_POST['address_line_1'] || ! $_POST['sched_date'] && $_POST['address_line_1'] )

{

bp_core_add_message( __( 'We need a time and a place!', 'buddypress' ), 'error' );

$error = true;

}



if( ! $error )

{

$user_id = $bp->loggedin_user->id;



if( isset( $_POST['address_line_2'] ) ) {

$address_line_2 = $_POST['address_line_2'];

}



$result = $wpdb->query( $wpdb->prepare("

INSERT INTO $wpdb->1_collections

( sched_date, post_date, user_id, address_line_1, address_line_2, town, state, zip_code )

VALUES ( %s, %s, %d, %s, %s, %s, %s, %s )",

$_POST['sched_date'], $_POST['post_date'], $user_id, $_POST['address_line_1'], $address_line_2, $_POST['town'], $_POST['state'], $_POST['zip_code'] ) );



/* Set the feedback messages */

if ( $errors )

bp_core_add_message( __( 'There was a problem calling your pickup, please try again.', 'buddypress' ), 'error' );

else

bp_core_add_message( __( 'Thanks for calling a recycling pickup.', 'buddypress' ) );



}



bp_core_load_template( apply_filters( 'xprofile_template_display_profile', 'profile/index' ) );

}

}

/* Function to call xprofile Address label */



function collections_xprofile( $field ) {

echo bp_collections_get_member_list_xprofile_data( $field );

}

function bp_collections_get_member_list_xprofile_data( $field ) {

global $bp, $site_members_template;

return xprofile_get_field_data( $field, $site_members_template->member->id );

}



?>

And the form:

<?php if ( bp_has_profile( 'profile_group_id=' . bp_get_current_profile_group_id() ) ) : while ( bp_profile_groups() ) : bp_the_profile_group(); ?>



<form action="" method="post" id="oncall" class="oncall">



<label for="address">At</label>

<input type="text" name="address_line_1" id="address_line_1" value="<?php echo bp_collections_get_member_list_xprofile_data('Address Line 1') ?>" />

<input type="text" name="address_line_2" id="address_line_2" value="<?php echo bp_collections_get_member_list_xprofile_data('Address Line 2') ?>" />

<input type="text" name="town" id="town" value="<?php echo bp_collections_get_member_list_xprofile_data('Town') ?>" />

<input type="hidden" name="state" id="state" value="MS" />

<input type="" name="zip_code" id="zip_code" value="<?php echo bp_collections_get_member_list_xprofile_data('Zip Code') ?>" />

<br />

<label for="date">On</label>

<input type="text" name="sched_date" id="sched_date" value="<?php $tomorrow = mktime(0,0,0,date("m"),date("d")+1,date("Y")); echo date("Y/m/d", $tomorrow); ?>" />



<input type="submit" name="go" id="go" value="go"/>

<input type="hidden" name="post_date" id="post_date" value="<?php $my_t=getdate(date("U")); print("$my_t[weekday], $my_t[month] $my_t[mday], $my_t[year]"); ?> " />



<?php wp_nonce_field( 'schedule_collect' ) ?>

</form>

<?php endwhile; endif; ?>

It has to be something simple but I’m lost. I’d really appreciate it if someone could take a minute and tell me what’s wrong with the code.