It is currently Sat Jul 04, 2020 5:00 am

All times are UTC + 5:30 hours




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: Tue Mar 10, 2015 8:36 pm 

Joined :
Thu Feb 12, 2015 3:52 am

Posts : 5
When registering a user, the information in the joomla users table doesn't get stored properly. The username gets saved as the name and the email address gets saved as the username. The first and last name never gets saved in the users table.


Report this post
Top
 Profile  
 
PostPosted: Thu Apr 23, 2015 10:21 am 

Joined :
Mon Mar 09, 2015 10:18 am

Posts : 0
Hi,

In social pinboard, on user registration username and email will be saving in '#__users' table and first name and last name will be saving in '#__pin_user_settings' table.


Report this post
Top
 Profile  
 
PostPosted: Thu Apr 23, 2015 6:38 pm 

Joined :
Thu Feb 12, 2015 3:52 am

Posts : 5
All information is saved correctly in the #__pin_user_settings table but not in the #__users table - the username gets saved as the name and the email address gets saved as the username. The first and last name never get saved in #__users. This becomes a problem when customization is done like uddeIM is added. The users email address is shown instead of the username. A Private message component should not display the users email address.


Report this post
Top
 Profile  
 
PostPosted: Wed Apr 29, 2015 10:52 am 

Joined :
Mon Mar 09, 2015 10:18 am

Posts : 0
Hi,

In social pinboard, by default in '#__users', there are fields for only name, username, email and password. So for first name and last name we have used the table '#__pin_user_settings'.

If you face any difficulty , kindly contact us at assist@apptha.com.


Report this post
Top
 Profile  
 
PostPosted: Wed Apr 29, 2015 6:23 pm 

Joined :
Thu Feb 12, 2015 3:52 am

Posts : 5
That is correct. And again, for the name field you save what should be the username instead of the users actual name. And for the username field, you save the email address. I have given you an example below.

Here is an example: User is John Doe username is jdoe123, email is johndoe@johndoe.com.
Here is what you save in #__users table
Name: jdoe123
username: johndoe@johndoe.com
email: johndoe@johndoe.com

Here is what you should save:
Name: "John Doe"
username: jdoe123
email: johndoe@johndoe.com

I am only telling you bugs so you can fix them and make your component better. The money I spent for this component is not worth it considering all the bugs I have come across, poor communication, and extra time I have devoted to fixing things that should be working. Other users should be made aware so they can decide if its worth it to them.


Report this post
Top
 Profile  
 
PostPosted: Tue May 05, 2015 10:25 am 

Joined :
Mon Mar 09, 2015 10:18 am

Posts : 0
Hi,

To save name, username , email correctly in "#__users" table, kindly do as follows

Go to ../components/com_socialpinboard/models/register.php

Find the following code

if ($version != '1.5') {
$query = "INSERT INTO #__users(name,username,email,password,block,sendEmail,registerDate,lastvisitDate) VALUES
('" . $username . "', '" . $new_email . "' , '" . $new_email . "', '" . $password . "',1,1,now(),now())";
$db->setQuery($query);
$db->query();
$userId = $db->insertid();
$query = "INSERT INTO #__user_usergroup_map(user_id,group_id)
VALUES('" . $userId . "', '2')";
$db->setQuery($query);
$db->query();
} else {
$query = "INSERT INTO #__users(name,username,email,password,block,sendEmail,registerDate,lastvisitDate)
VALUES ('" . $username . "', '" . $new_email . "' , '" . $new_email . "', '" . $password . "',1,1,now(),now())";
$db->setQuery($query);
$db->query();
$userId = $db->insertid();

and replace it with the following code

if ($version != '1.5') {
$query = "INSERT INTO #__users(name,username,email,password,block,sendEmail,registerDate,lastvisitDate) VALUES
('" . $first_name . "', '" . $username . "' , '" . $new_email . "', '" . $password . "',1,1,now(),now())";
$db->setQuery($query);
$db->query();
$userId = $db->insertid();
$query = "INSERT INTO #__user_usergroup_map(user_id,group_id)
VALUES('" . $userId . "', '2')";
$db->setQuery($query);
$db->query();
} else {
$query = "INSERT INTO #__users(name,username,email,password,block,sendEmail,registerDate,lastvisitDate)
VALUES ('" . $first_name . "', '" . $username . "' , '" . $new_email . "', '" . $password . "',1,1,now(),now())";
$db->setQuery($query);
$db->query();
$userId = $db->insertid();


Report this post
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 5:30 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron