Updated benchmark db populating script for current codebase. Removed some functionality (creation of cats/forums)...

git-svn-id: file:///svn/phpbb/trunk@1130 89ea8834-ac86-4346-8a33-228a782c2dd0
author: natec <natec@users.sourceforge.net> 2001-10-05 19:41:20 +0000
committer: natec <natec@users.sourceforge.net> 2001-10-05 19:41:20 +0000
commit: e6f668724c0522ead22a11f666ba19f94ab9b7f6 (patch)
tree: 9d93c5d4a0122ab60394df9957a0549e3118c2dd /phpBB/develop
parent: 53cde745a3ffb07584bdda89e0908a9826dc9cc7 (diff)
download: forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.tar
forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.tar.gz
forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.tar.bz2
forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.tar.xz
forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.zip
1 files changed, 369 insertions, 213 deletions
diff --git a/phpBB/develop/benchmark.php b/phpBB/develop/benchmark.php
index bbfb74052f..bcfbbdb63e 100644
--- a/phpBB/develop/benchmark.php
+++ b/phpBB/develop/benchmark.php
@@ -1,12 +1,41 @@
 <?php
-include('../extension.inc');
-include('../config.'.$phpEx);
-include('../includes/constants.'.$phpEx);
-include('../functions/functions.'.$phpEx);
-include('../includes/db.'.$phpEx);
+$phpbb_root_path = "../";
+include($phpbb_root_path . 'extension.inc');
+include($phpbb_root_path . 'common.'.$phpEx);
+include($phpbb_root_path . 'includes/post.'.$phpEx);
+include($phpbb_root_path . 'includes/bbcode.'.$phpEx);
 
 srand ((double) microtime() * 1000000);
-set_time_limit(20*60);
+set_time_limit(240*60);
+
+// Here's the text we stick in posts..
+$bigass_text = ' 
+phpBB BBCode test suite v0.0.2
+auto-linkification:
+http://something.com
+www.something.com
+nate@phpbb.com
+http://something.com/foo.php?this=that&theother=some%20encoded%20string is a link.
+[code]
+Simple code block with some <html> <tags>.
+[/code]
+[b]bolded[/b], [i]italic[/i]
+[email]james@totalgeek.org[/email]
+[url=http://www.totalgeek.org]totalgeek.org[/url]
+[url]www.totalgeek.org[/url] 
+[list] 
+[*] This is the first bulleted item.
+[*] This is the second bulleted item.
+[/list] 
+[list=A] 
+[*] This is the first bulleted item.
+[*] This is the second bulleted item.
+[/list] 
+[quote]
+And a quote!
+[/quote]
+';
+
 
 // The script expects the ID's in the tables to sequential (1,2,3,4,5), 
 // so no holes please (1,4,5,8)...
@@ -14,35 +43,39 @@ $nr_of_users  = nrof(USERS_TABLE);
 $nr_of_cats   = nrof(CATEGORIES_TABLE);
 $nr_of_forums = nrof(FORUMS_TABLE);
 $nr_of_posts  = nrof(POSTS_TABLE);
-$nr_of_topics = nrof(TOPICS_TABLE);  // create_topic() will keep this up to date
 
 $u = $users;
 
 $starttime = microtime();
 
-while($users > 0){
+while($users > 0)
+{
 
-  $name = "testuser_" . ($nr_of_users+10);
-  createuser($name);
-  $users--;
-}
-if ($forums > 0){
-    create_forums($forums);
+	$name = "testuser_" . substr(md5(uniqid(rand())), 0, 10);
+	if (make_user($name))
+	{
+		echo "Created user: $name <br>\n";
+		flush();
+	}
+	$users--;
 }
-if ($posts > 0){
-    filldb($posts);
+
+if ($posts > 0)
+{
+	filldb($posts);
 }
 
 $endtime = microtime();
 
-if ($submit="" || !isset($submit)){
+if ($submit="" || !isset($submit))
+{
     ?>
 Hello, welcome to this little phpBB Benchmarking script :)<p>
 
 At the moment there are:<br>
+
 <table>
 <tr><td align="right"><?php echo $nr_of_users?></td><td>Users</td></tr>
-<tr><td align="right"><?php echo $nr_of_topics?></td><td>Topics</td></tr>
 <tr><td align="right"><?php echo $nr_of_forums?></td><td>Forums</td></tr>
 <tr><td align="right"><?php echo $nr_of_posts?></td><td>Posts</td></tr>
 </table>
@@ -51,250 +84,373 @@ What do you want to create?<p>
 
 <form method="get" action="<?php echo $PHP_SELF?>">
 <input type="text" name="users" size="3"> Users<br>
-<input type="text" name="forums" size="3"> Forums/categories<br>
 <input type="text" name="posts" size="3"> Posts/topics (optional: post size in <input type="text" name="size" size="3"> bytes)<br>
 <input type="submit" name="submit">
 </form>
 
     <?php
-} else {
+} 
+else 
+{
 
-  
 	list ($starttime_msec,$starttime_sec) = explode(" ",$starttime);
 	list ($endtime_msec,$endtime_sec) = explode(" ",$endtime);
 	$timetaken_sec = ($endtime_sec+$endtime_msec) - ($starttime_sec+$starttime_msec);
 	print "<B>TIME TAKEN : ".$timetaken_sec."s</B><BR>\n"; 
 
-	$starttime = microtime();
-
-	$result = $db->sql_query("SELECT * FROM users LIMIT 5,200");
-	$rowresult = $db->sql_fetchrowset($result);
+	print "<p>\n<a href=\"$PHP_SELF\">Back to the overview page</a>\n";
+}
 
-	$endtime = microtime();
 
-	for($i=0;$i<count($rowresult);$i++){
-		print $rowresult[$i]['user_id']." : ".$rowresult[$i]['username']."<BR>";
+function filldb($newposts)
+{
+	global $nr_of_forums;
+	global $nr_of_users;
+  
+	$forum_topic_counts = array();
+  
+	for ($i = 1; $i <= $nr_of_forums; $i++)
+	{
+  		$forum_topic_counts[$i] = get_topic_count($i);
 	}
+  
+	for($i = 0; $i < $newposts; $i++)
+	{
+		$userid   = rand(2, $nr_of_users - 1);
+		$forum    = rand(1,$nr_of_forums);
+		
+		if ((rand(0,30) < 1) || ($forum_topic_count[$forum] == 0))
+		{
+			// create a new topic 1 in 30 times (or when there are none);
+			$topic = make_topic($userid, "Testing topic $i", $forum);
+			$forum_topic_count[$forum]++;
+		} 
+		else 
+		{
+			// Otherwise create a reply(posting) somewhere.
+			$topic = get_smallest_topic($forum);
+			create_posting($userid, $topic, $forum, "reply");
+		}
+		
+		if (($i % 1000) == 0)
+		{
+			echo "ping.pong.<br>";
+			flush();
+		}
+	 
+	}
+}
 
-//	while($row = $db->sql_fetchrow()){
-//		print $row['user_id']."<BR>";
-//	}
-
-	list ($starttime_msec,$starttime_sec) = explode(" ",$starttime);
-	list ($endtime_msec,$endtime_sec) = explode(" ",$endtime);
-	$timetaken_sec = ($endtime_sec+$endtime_msec) - ($starttime_sec+$starttime_msec);
-	print "<B>TIME TAKEN : ".$timetaken_sec."s</B><BR>\n"; 
 
-	print "<p>\n<a href=\"$PHP_SELF\">Back to the overview page</a>\n";
+function get_smallest_topic($forum_id)
+{
+	global $db;
+	
+	$sql = "SELECT topic_id
+		FROM " . TOPICS_TABLE . "
+		WHERE (forum_id = $forum_id)
+		ORDER BY topic_replies ASC LIMIT 1";
+	if($result = $db->sql_query($sql))
+	{
+		$row = $db->sql_fetchrow($result);
+		$topic_id = $row['topic_id'];
+
+		unset($result);
+		unset($row);
+		return $topic_id;
+	}
+	else
+	{
+		message_die(GENERAL_ERROR, "Couldn't get smallest topic.", "", __LINE__, __FILE__, $sql);
+	}
+	
 }
 
-function filldb($newposts){
-  global $nr_of_topics;
-  global $nr_of_forums;
-  global $nr_of_users;
-  for($i=0 ; $i<=$newposts; $i++){
-    $userid   = rand(1,$nr_of_users);
-    $forum    = rand(1,$nr_of_forums);
-    if (rand(0,20) < 1 || $nr_of_topics == 0){
-      // create a new topic 1 in 20 times (or when there are none);
-      $topic    = create_topic($userid, "This is test topic nr. $i", $forum);
-    } else {
-      // Otherwise create a reply(posting) somewhere.
-      $topic = rand(1,$nr_of_topics);
-    }
-    create_posting($userid, $topic, $forum);
-  }
+
+function get_topic_count($forum_id)
+{
+	global $db;
+	
+	$sql = "SELECT forum_topics
+		FROM " . FORUMS_TABLE . "
+		WHERE (forum_id = $forum_id)";
+	if($result = $db->sql_query($sql))
+	{
+		$row = $db->sql_fetchrow($result);
+		$topic_count = $row['forum_topics'];
+
+		unset($result);
+		unset($row);
+		return $topic_count;
+	}
+	else
+	{
+		message_die(GENERAL_ERROR, "Couldn't get topic count.", "", __LINE__, __FILE__, $sql);
+	}
+	
 }
 
 
-function create_topic($userid, $subject, $forum){
-  global $db;
-  global $nr_of_topics;
-  $userdata = get_userdata($username, $db);
-  $time = time();
-  $sql = "INSERT INTO ".TOPICS_TABLE." (topic_title, topic_poster, forum_id, topic_time, topic_notify) VALUES ('$subject', '$userid', '$forum', '$time', 0)";
-   if (!$result = $db->sql_query($sql)) {
-     print "Couldn't create Topic $subject in DB!<br>\n";
-     print "This is the sql statement:<br>\n$sql\n<br>\n";
-     die;
-   } else {
-     print "<br>Topic '$subject' created!<br>\n";
-     $nr_of_topics++;
-     flush();
-     return mysql_insert_id($db->db_connect_id);
-   }
-}
+function make_topic($user_id, $subject, $forum_id)
+{
+	global $db;
+	$topic_type = POST_NORMAL;
+	$topic_vote = 0;
+	$current_time = time();
+	
+	$sql  = "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote)
+			VALUES ('$subject', $user_id, $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote)";
 
-function create_posting($userid, $topic_id, $forum){
-  global $db;
-  $message = generatepost(650);
-  $time = time();
-  $poster_ip = "234234232";
-
-  $sql = "INSERT INTO ".POSTS_TABLE." (forum_id, topic_id, poster_id, post_time, poster_ip) VALUES ('$forum', '$topic_id', '$userid', '$time', '$poster_ip')";
-   if (!$result = $db->sql_query($sql)) {
-     print "Couldn't create post in $forum!<br>\n";
-     print "This is the sql statement:<br>\n$sql\n<br>\n";
-     die;
-   } else {
-
-	$post_id = mysql_insert_id($db->db_connect_id);
-	$sql = "INSERT INTO ".POSTS_TEXT_TABLE." (post_id, post_text) VALUES ('$post_id', '$message')";
-	if (!$result = $db->sql_query($sql)) {
-		print "Couldn't create post text in $forum!<br>\n";
-		print "This is the sql statement:<br>\n$sql\n<br>\n";
-		die;
+	if( $result = $db->sql_query($sql, BEGIN_TRANSACTION) )
+	{
+		$new_topic_id = $db->sql_nextid();
 	}
-	 print "$forum ";
-     return 0;
-   }
+	else
+	{
+		message_die(GENERAL_ERROR, "Error inserting data into topics table", "", __LINE__, __FILE__, $sql);
+	}
+	
+	create_posting($user_id, $new_topic_id, $forum_id);
+	
+	return $new_topic_id;
 }
 
-function create_forums($totalforums){
-  global $db;
-  global $nr_of_cats;
-  $j=0;
-  for($i=0 ; $i<$totalforums; $i++){
-    if (rand(0,5) <= 2 || $nr_of_cats == 0){
-      // create a new cat at random times  or when there are no cats yet.
-      $j++;
-      $catid    = create_cat("Category $j");
-    } else {
-      // Otherwise create a forum in one of the cats.
-      $catid = rand(0,$nr_of_cats);
-    }
-    $forum = "Test forum number $i";
-    create_forum($catid, $forum);
-  }
-}
 
-function create_cat($category){
-  global $db;
-  global $nr_of_cats;
-  // At the moment cat_order is always one, oh well..
-  echo $sql = "INSERT INTO ".CATEGORIES_TABLE." (cat_title, cat_order) VALUES ('$category', '1')";
-  if (!$result = $db->sql_query($sql)) {
-    print "Couldn't create category \"$category\"!<br>\n";
-    die;
-  } else {
-    print "Category \"$category\" created!<br>\n";
-    $nr_of_cats++;
-    return mysql_insert_id($db->db_connect_id);
-  }
-}
 
-function create_forum($catid, $forum){
-  global $db;
-  global $nr_of_forums;
- 
-  $sql = "INSERT INTO ".FORUMS_TABLE." (forum_name, forum_desc, forum_access, cat_id, forum_type) VALUES ('$forum', 'This is a forum created for the benchmark', '2', '$catid', '0')";
-  if (!$result = $db->sql_query($sql)) {
-    print "Couldn't create forum \"$forum\"!<br>\n";
-    die;
-  } else {
-    print "Forum \"$forum\" created!<br>\n";
-    $nr_of_forums++;
-    $forum_id = mysql_insert_id($db->db_connect_id);
-      // Sorry, no error checking. We just assume that if the forum can be
-      // created the moderator can be assigned too :)
-      $sql = "INSERT INTO ".FORUM_MODS_TABLE." (forum_id, user_id) VALUES ('$forum_id', '1')";
-      $result = $db->sql_query($sql);
-    return $forum_id;
-  }
+function create_posting($userid, $topic_id, $forum, $mode='newtopic')
+{
+	$message = generatepost();
+
+	return make_post($topic_id, $forum, $userid, "", $message, $mode);
+
 }
 
 
-function generatepost($size=850){
-   // Returns a string with a length between $size and $size*0.2
-   $size = rand(0.2*$size, $size);
-   $text = "Step 1: Untar the soure into the directory phpBB will run from. Seeing as you
-are reading this file you have probably gotten that far. (Or if you are on a
-different machine then your webserver FTP the resulting phpBB dir over to where
-it will run from on the server. ie /www/yourdomain.com/phpBB)
 
-Step 2: Edit config.php and change the following values:
+function make_post($new_topic_id, $forum_id, $user_id, $post_username, $text, $mode='newtopic')
+{
+	global $db;
+	$current_time = time();
+	$user_ip = "ac100202";
+	$bbcode_on = 1;
+	$html_on = 1;
+	$smilies_on = 1;
+	$attach_sig = 1;
+	$bbcode_uid = make_bbcode_uid();
+	
+	$post_subject = 'random subject';
+	
+	$post_message = prepare_message($text, $html_on, $bbcode_on, $smilies_on, $bbcode_uid);	
+	
+	$sql = "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, bbcode_uid, enable_bbcode, enable_html, enable_smilies, enable_sig)
+		VALUES ($new_topic_id, $forum_id, $user_id, '$post_username', $current_time, '$user_ip', '$bbcode_uid', $bbcode_on, $html_on, $smilies_on, $attach_sig)";
+	$result = $db->sql_query($sql);
+	
+	if($result)
+	{
+		$new_post_id = $db->sql_nextid();
+	
+		$sql = "INSERT INTO " . POSTS_TEXT_TABLE . " (post_id, post_subject, post_text)
+			VALUES ($new_post_id, '$post_subject', '$post_message')";
+	
+		if($db->sql_query($sql))
+		{
+			$sql = "UPDATE " . TOPICS_TABLE . "
+				SET topic_last_post_id = $new_post_id";
+			if($mode == "reply")
+			{
+				$sql .= ", topic_replies = topic_replies + 1 ";
+			}
+			$sql .= " WHERE topic_id = $new_topic_id";
+	
+			if($db->sql_query($sql))
+			{
+				$sql = "UPDATE " . FORUMS_TABLE . "
+					SET forum_last_post_id = $new_post_id, forum_posts = forum_posts + 1";
+				if($mode == "newtopic")
+				{
+					$sql .= ", forum_topics = forum_topics + 1";
+				}
+				$sql .= " WHERE forum_id = $forum_id";
+	
+				if($db->sql_query($sql))
+				{
+					$sql = "UPDATE " . USERS_TABLE . "
+						SET user_posts = user_posts + 1
+						WHERE user_id = " . $user_id;
+	
+					if($db->sql_query($sql, END_TRANSACTION))
+					{
+						// SUCCESS.
+						return true;
+					}
+					else
+					{
+						message_die(GENERAL_ERROR, "Error updating users table", "", __LINE__, __FILE__, $sql);
+					}
+				}
+				else
+				{
+					message_die(GENERAL_ERROR, "Error updating forums table", "", __LINE__, __FILE__, $sql);
+				}
+			}
+			else
+			{
+				message_die(GENERAL_ERROR, "Error updating topics table", "", __LINE__, __FILE__, $sql);
+			}
+		}
+		else
+		{
+			// Rollback
+			if(SQL_LAYER == "mysql")
+			{
+				$sql = "DELETE FROM " . POSTS_TABLE . "
+					WHERE post_id = $new_post_id";
+				$db->sql_query($sql);
+			}
+			message_die(GENERAL_ERROR, "Error inserting data into posts text table", "", __LINE__, __FILE__, $sql);
+		}
+	}
+	else
+	{
+		message_die(GENERAL_ERROR, "Error inserting data into posts table", "", __LINE__, __FILE__, $sql);
+	}	
 
-The url fields my work for you if you're running phpBB from a domain 
-like this: http://www.phpbb.com/phpBB
+}
 
-However if you access phpBB like this: http://www.domain.com/~you/phpBB you
-will have to change these values.
 
-Also, config.php MUST be writeable by the webserver or the install will fail.
-To set this on UNIX systems you can use chmod
-ie: chmod 777 config.php (after the install if finsished set it back to 755 
-via chmod 755 config.php so it can't be written by anyone again.)";
-   $textsize = strlen($text);
+function generatepost($size=850)
+{
+   global $bigass_text;
+   // Returns a string with a length between $size and $size*0.2
+   $size = rand(0.2*$size, $size);
+   
+   $textsize = strlen($bigass_text);
    $currentsize = 0;
    // Add whole $text multiple times
-   while($currentsize < $size && $size-$currentsize <= $textsize){
-      $message .= $text;
+   while($currentsize < $size && $size-$currentsize <= $textsize)
+   {
+      $message .= $bigass_text;
       $currentsize += $textsize;
    }
    // Add the remainder number of chars and return it.
-   $message .= substr($text, 0, $size-$currentsize);
+   $message .= substr($bigass_text, 0, $size-$currentsize);
 
-   // WARNING!! THIS IS NOT GOOD, THESE FUNCTIONS WILL ADD CHARACTERS!!!
-   return (nl2br(addslashes($message)));
+   return (addslashes($message));
 }
    
       
-function nrof($table){
-    global $db;
-    $sql = "SELECT count(*) AS counted FROM $table";
-    $result = $db->sql_query($sql);
-    $topics = $db->sql_fetchrow($result);
-    return $topics[counted];
+function nrof($table)
+{
+	global $db;
+	$sql = "SELECT count(*) AS counted FROM $table";
+	$result = $db->sql_query($sql);
+	$topics = $db->sql_fetchrow($result);
+	return $topics[counted];
 }
 
 
-function createuser($name){
-   global $db;
-   global $nr_of_users;
-   $username    = $name;
-   $regdate    = time();
-   $email    = $username . "@phpbb.com";
-   $icq        = "29317129";
-   $passwd    = md5("test");
-   $occ        = "";
-   $intrest    = "";
-   $from    = "";
-   $website    = "http://www.phpBB.com/";
-   $sig        = "To Bla, or Not to Bla";
-   $aim     = "";
-   $sqlviewemail = "1";
-   $yim     = "";
-   $msnm     = "";
-
-   $userdata = get_userdata($username, $db);
-   if($userdata["username"]) {
-     print "Username '$username' has been already used...<br>\n";
-     return 1;
-   }
-   
-   $sql = "INSERT INTO ".USERS_TABLE." (username, user_regdate, user_email, user_icq, user_password, user_occ, user_intrest, user_from, user_website, user_sig, user_aim, user_viewemail, user_yim, user_msnm) VALUES ('$username', '$regdate', '$email', '$icq', '$passwd', '$occ', '$intrest', '$from', '$website', '$sig', '$aim', '$sqlviewemail', '$yim', '$msnm')";
-
-  if (!$result = $db->sql_query($sql)) {
-     print "Couldn't create user $username in DB!<br>\n";
-     print "This is the sql statement:<br>\n$sql\n<br>\n";
-     return 1;
-   } else {
-//     print "User $username created!<br>\n";
-     $nr_of_users++;
- //    flush();
-     return 0;
-   }
-}
+function make_user($username)
+{
+	global $db, $board_config;
+
+	$password = md5("benchpass");
+	$email = "nobody@localhost";
+	$icq = "12345678";
+	$website = "http://www.phpbb.com";
+	$occupation = "phpBB tester";
+	$location = "phpBB world hq";
+	$interests = "Eating, sleeping, living, and breathing phpBB";
+	$signature = "$username: phpBB tester.";
+	$signature_bbcode_uid = "";
+	$avatar_filename = "";
+	$viewemail = 0;
+	$aim = 0;
+	$yim = 0;
+	$msn = 0;
+	$attachsig = 1;
+	$allowsmilies = 1;
+	$allowhtml = 1;
+	$allowbbcode = 1;
+	$allowviewonline = 1;
+	$notifyreply = 0;
+	$notifypm = 0;
+	$user_timezone = $board_config['board_timezone'];
+	$user_dateformat = $board_config['default_dateformat'];
+	$user_lang = $board_config['default_lang'];
+	$user_style = $board_config['default_style'];
+
+
+	$sql = "SELECT MAX(user_id) AS total
+		FROM " . USERS_TABLE;
+	if($result = $db->sql_query($sql))
+	{
+		$row = $db->sql_fetchrow($result);
+		$new_user_id = $row['total'] + 1;
+
+		unset($result);
+		unset($row);
+	}
+	else
+	{
+		message_die(GENERAL_ERROR, "Couldn't obtained next user_id information.", "", __LINE__, __FILE__, $sql);
+	}
+
+	$sql = "SELECT MAX(group_id) AS total
+		FROM " . GROUPS_TABLE;
+	if($result = $db->sql_query($sql))
+	{
+		$row = $db->sql_fetchrow($result);
+		$new_group_id = $row['total'] + 1;
+
+		unset($result);
+		unset($row);
+	}
+	else
+	{
+		message_die(GENERAL_ERROR, "Couldn't obtained next user_id information.", "", __LINE__, __FILE__, $sql);
+	}
 
-function get_userdata($username, $db) {
-	$sql = "SELECT * FROM ".USERS_TABLE." WHERE username = '$username' AND user_level != -1";
-	if(!$result = $db->sql_query($sql))
-		$userdata = array("error" => "1");
-	if(!$myrow = $db->sql_fetchrow($result))
-		$userdata = array("error" => "1");
+
+	$sql = "INSERT INTO " . USERS_TABLE . "	(user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)
+		VALUES ($new_user_id, '$username', " . time() . ", '$password', '$email', '$icq', '$website', '$occupation', '$location', '$interests', '$signature', '$signature_bbcode_uid', '$avatar_filename', $viewemail, '$aim', '$yim', '$msn', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $user_timezone, '$user_dateformat', '$user_lang', $user_style, 0, 1, ";
+
+	
+	$sql .= "1, '')";
 	
-	return($myrow);
+	if($result = $db->sql_query($sql, BEGIN_TRANSACTION))
+	{
+		$sql = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_name, group_description, group_single_user, group_moderator)
+			VALUES ($new_group_id, '', 'Personal User', 1, 0)";
+		if($result = $db->sql_query($sql))
+		{
+			$sql = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending)
+				VALUES ($new_user_id, $new_group_id, 0)";
+			if($result = $db->sql_query($sql, END_TRANSACTION))
+			{
+				
+				// SUCCESS.
+				return true;
+			}
+			else
+			{
+				message_die(GENERAL_ERROR, "Couldn't insert data into user_group table", "", __LINE__, __FILE__, $sql);
+			}
+		}
+		else
+		{
+			message_die(GENERAL_ERROR, "Couldn't insert data into groups table", "", __LINE__, __FILE__, $sql);
+		}
+	}
+	else
+	{
+		message_die(GENERAL_ERROR, "Couldn't insert data into users table", "", __LINE__, __FILE__, $sql);
+	}
+
 }
 
+
+
+ 
   
 ?>
author	natec <natec@users.sourceforge.net>	2001-10-05 19:41:20 +0000
committer	natec <natec@users.sourceforge.net>	2001-10-05 19:41:20 +0000
commit	e6f668724c0522ead22a11f666ba19f94ab9b7f6 (patch)
tree	9d93c5d4a0122ab60394df9957a0549e3118c2dd /phpBB/develop
parent	53cde745a3ffb07584bdda89e0908a9826dc9cc7 (diff)
download	forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.tar forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.tar.gz forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.tar.bz2 forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.tar.xz forums-e6f668724c0522ead22a11f666ba19f94ab9b7f6.zip