Admin add new member using database or cpanel

Dear all

I have disabled the membership registration, and want to register the new members by myself. How to configure the dolphin system?

Regards

AMIR

You can try next SQL:

INSERT INTO `profiles` (`ID`, `NickName`, `Email`, `Password`, `Salt`, `Status`, `Role`, `Couple`, `Sex`, `LookingFor`, `Headline`, `DescriptionMe`, `Country`, `City`, `DateOfBirth`, `Featured`, `DateReg`, `DateLastEdit`, `DateLastLogin`, `DateLastNav`, `aff_num`, `Tags`, `zip`, `EmailNotify`, `LangID`, `UpdateMatch`, `Views`, `Rate`, `RateCount`, `CommentsCount`, `PrivacyDefaultGroup`, `allow_view_to`, `UserStatus`, `UserStatusMessage`, `UserStatusMessageWhen`, `Avatar`, `Height`, `Weight`, `Income`, `Occupation`, `Religion`, `Education`, `RelationshipStatus`, `Hobbies`, `Interests`, `Ethnicity`, `FavoriteSites`, `FavoriteMusic`, `FavoriteFilms`, `FavoriteBooks`, `FirstName`, `LastName`) VALUES (NULL, 'Nickname', 'Email', '', '', 'Active', 1, 0, 'male', '', 'Headline', '<p>description</p>', 'US', 'City', '1981-01-01', 0, '2012-01-01 00:00:00', '0000-00-00 00:00:00', '2012-01-01 00:00:00', '2012-01-01 00:00:00', 0, '', 'Zipcode', 1, 0, 0, 0, 0, 0, 0, 3, 3, 'online', '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

I have marked the most important values which you have to change.

After you execute the SQL, you will need to clean dolphin caches, and then use 'restore password' option to regenerate password

Hi AndrewP

Thanks for the info.

At first, I used your method. And due to my zero knowledge of coding in the database, I feared to go for it. Then I look around in the database and find a table named profile. Then, I enter the information directly from there.

Now, my problem was resolved.

Regards,

AMIR

AndrewP,

Where do I find the 'restore password' option to regenerate the password?

In Dolphin or Mysql?

Thanks in advance

Blaine.