Форумы / Cotonti / Development / How to safe data from custom field in a user profile to the DB?

I am trying to create a new plugin which adds additional fields to a user profile.

I have gotten it so far that when I edit the user profile the fields are there and actually contain the data I insert to the DB upon plugin install. But I can for the life of me not figure out how to set the plugin up so that if the field value is changed it actually saves this new data when the user presses "submit".

I have created a php for the hooks to "do" when the user updates the profile:
Part=users.edit
File=subscriber.user.edit.update.done
Hooks=users.edit.update.done

I have been trying to get this to work since friday evening and I am about to throw myself out of the window.
Is there someone who can tell me what I need to do so that edited field values get saved to the DB?

Thanks in advance!


PS: yes I can use extra fields of course, but it would be nice if I can just make this a plugin so no additonal user input is needed when installing the plugin.

Added 4 hours later:

So here is the edit part of the plugin: 

if (!defined('SED_CODE')) { die('Wrong URL.'); }


$userid = sed_import('id','G','INT');

$sub_sql = sed_sql_query("SELECT user_subscr_end_date, user_subscr_date_stamp, user_subscriber_status FROM $db_users WHERE user_id='$userid'");
	if (sed_sql_numrows($sub_sql) > 0) {
		$sub = sed_sql_fetcharray($sub_sql);

		$sub_end = $sub['user_subscr_end_date'];
		$sub_stamp = $sub['user_subscr_date_stamp'];
		$sub_status = $sub['user_subscriber_status'];
		$sub_stamp = strtotime($sub_end);

	}

$t->assign(array(
	"USERS_EDIT_SUBSCRIPDATE" => "<input type=\"text\" class=\"text\" name=\"subscr_end_date\" value=\"".htmlspecialchars($sub['user_subscr_end_date'])."\" size=\"8\" maxlength=\"10\" />",
	"USERS_EDIT_SUBSCRIPSTATUS" => "<input type=\"text\" class=\"text\" name=\"subscriber_status\" value=\"".htmlspecialchars($sub['user_subscriber_status'])."\" size=\"1\" maxlength=\"1\" />"
));

And here is the update.done part of the plugin: 

defined('SED_CODE') or die('Wrong URL'); 

$userid = sed_import('id','G','INT');

$sub_sql_u2 = sed_sql_query("UPDATE $db_users SET user_subscr_end_date='".sed_sql_prep($sub_end)."', user_subscr_date_stamp='".sed_sql_prep($sub_stamp)."', user_subscriber_status='".sed_sql_prep($sub_status)."', user_auth='' WHERE user_id=$userid");

Now, I have tried about a few million different sql queries trying to perform the update and everything fails. My DB values are never updated when I change them in the user edit page.
If I change the update.done part of the plugin and (lets say) hardcode the DB values they get updated properly. So, the plugin works....I just can not figure out how to make the plugin update with the correct field values.

Added 8 hours later:

I tried a few dozen other different values for ".sed_sql_prep($sub_end)." to see if that would properly update the DB but all fial.

Wow, thank you very much Macik. That is really some very helpfull info :)
I can pretty much understand where I went wrong and I am going to apply some changes.

I should indeed just have gone for the extra fields, I was just trying to re-invent the wheel I guess :)


Yes, this is still a genoa website, still not gotten to the time to upgrade and figure out what some erros during the upgrade cause (I have tried but failed each time).
Once I have implemented some changes I will post here the results.
I actually plan to share this plugin as it might be usefull to others as well. With this plugin I add a subscription date I add to a users profile which adds the user to a specific group and when the date has passed he is automatically removed from the group. With this you can do all kind of fun stuff....at least I am working on some ;)

Added 1 hour later:

Sigh, I still cant get it to work.

I have created the fields through the extra fields for users. The fields are in my DB, if I change their value (manually directly in the DB) in my profile I can see the changed values.
I have added a file into my plugin for the "users.edit.update.first" hook. In it I added the $-post as you described yet still my DB is not updated when I update my profile with the new info.

I have enabled dbug mode, the "FOOTER_DEVMODE" tags were already present in my footer but I do not see any messages in my footer upon profile update. Does it only display errors if there are any or does it always display something (something in the sense of "dev info")?
So, I would like to share any erros with you, but there are none.

I must be overlooking something really simple, but I simply cant figure it out. :(

Added 2 hours later:

Got it!
Now that I use the user extra fields like you suggested I do not need this hook any more to insert the new field value as that is already done by just the user edit form itself. I was hookibg something which did not need that at all..
I am now only using the hook to get the new date stamp and insert that into the DB upon profile edit submit.

I am sure I will have some more questions but at least now that I can store dates I can work on the plugin funtionality itself :)