phpBB.de

Code: Alles auswählen

$sql = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending)
				VALUES ($user_id, $group_id, 0)";
			if( !($result = $db->sql_query($sql, END_TRANSACTION)) )
			{
				message_die(GENERAL_ERROR, 'Could not insert data into user_group table', '', __LINE__, __FILE__, $sql);
			}

Code: Alles auswählen

$forum_notify_ids = array();
                         $sql = "SELECT forum_id
                                 FROM " . FORUMS_TABLE;
                         if( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not read out data from forums table', '', __LINE__, __FILE__, $sql);
			}

                         while ( $row = $db->sql_fetchrow($result) )
                         {
                                 $forum_notify_ids[] = $row['forum_id'];
                         }

                         foreach( $forum_notify_ids as $id )
                         {
                                $sql = "INSERT INTO " . FORUMS_WATCH_TABLE . " (forum_id,user_id,notify_status) VALUES($id,$user_id,$notifyreply)";
                                	if( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not insert data into forum_watch table', '', __LINE__, __FILE__, $sql);
			}
                         }