Insert into tables.

[kevincon]

What is the best way to directly insert a user into the tables.

I already have users and I created a "activate user on forum" page, which inserts them into phpbb, However Inserting them directly into the users table and the user_group table didn't work, my script worked fine it all went in well but from the administration control system It says "user not found" they do show up on the member list though.

My question is what tables do I have to insert information on that player into in order for it to work 100%?

[Erik Frèrejean]

You should always use the phpBB framework for any database mutation. For adding users, use the user_add (mixed $user_row, [string $cp_data = false]) function.

[kevincon]

How could I use that with my code?
Like how could I link my page to PhpBB?
Also can I use that to put the users password on there, Because the users already have passwords.

[kevincon]

I need to insert the following.

Code: Select all

	$user_sess = $_SESSION['username'];

	$user_4_forum = mysql_query("SELECT * FROM users WHERE username='".$user_sess."'") or die ("Error in query".mysql_error());
		if (mysql_num_rows($user_4_forum) > 0) 
			{
				while($row = mysql_fetch_array($user_4_forum)) 
					{
						$steamid = $row["steamid"];
						$rank = $row["rank"];		
						$password = $row["password"];
						$username = $row["username"];
					}
			}

I have a series of codes that if a user rank is a certain number they get inserted into a certain phpbb group, how can I do this as well with your method?

[Erik Frèrejean]

Moving to MOD writers discussion.

[kevincon]

Thanks