create an account(smf) with mysql query

[samuelggt]

Hi, as I can register an account with a mysql query, the problem I found is in the part of the password, anyone can help me or guide on how to solve this, thanks.

So I have my query:

Code Select Expand

INSERT INTO `smf_members` (real_name, passwd, member_name, id_post_group, email_address) VALUES ('Samuel', sha1(Sam), 'Samuel', '4', '[email protected]')

[margarett]

I edited your block of code to remove your email address

It's not really recommended to directly interact with the database, as SMF has routines prepared to do it. The best way is to create a PHP file, require SSI.php and Sources/Subs-Members.php, then fill the $regOptions array and finally call registerMember($regOptions);

If you still want to go the manual way, you need to:
* insert the record in smf_members as you're doing. Password is sha1(strtolower($username) . $password)
* update smf_settings to increase the total of users
* update smf_settings to update "last member"

[samuelggt]

Password is sha1(strtolower($username) . $password)

To make it get error:

[margarett]

That's PHP syntax, not MySQL.

[samuelggt]

Is there a way to change the syntax of php to mysql query?

[Kindred]

Not really...

As has already been said, smf has some functions that already exist and are hooked and/or available to do exactly whatbyoubarebtrying to do.   Why are you trying to drop users directly in the database?   Because there are things that have to happen when a user is created, other then just the members table

[samuelggt]

It's for a game (SAMP) in which to sign up for the game, also do the SMF sending a mysql query.

[JBlaze]

Code Select Expand

<?php
require_once('/path/to/SSI.php');

global $sourcedir;

require_once($sourcedir . '/Subs-Members.php');

$regOptions = array(
    'real_name' => $username,
    'passwd' => sha1(strtolower($username) . $password),
    'member_name' => $username,
    'id_post_group' => $postgroup,
    'email_address' => $email
);

registerMember($regOptions);
?>

It's that easy. You can include SSI.php anywhere you need to use it outside of your forum, and you can do damn near anything with it. The $regOptions array keys are the same as the smf_members keys.

[Kindred]

In other words... do it, correctly, in php - with a call to the SMF register function... don't try to bypass or shortcut things by doing it directly in mySQL