Making YaBB Read User Info From Drupal

I was thinking YaBB because then we'd have all of the old posts there. However, they're stored as fairly simply formatted text files, and it wouldn't be that hard to write a parser to convert them into whatever format is chosen.

Anyhow, at the moment I'm still working on what mysql statements are going to be used to grab the right data from the Drupal database. As that stands, I'm still going to need to either have my access to that allowed, or use a PHP script to gather the same info. Whichever you prefer.

I'm really interested in how Drupal stores the login information, as I'm just about done a new CMS for The 'Fritter, and I'd like to be able to integrate it in there as well.

-BDub

Most likely a good idea. Personally, I'd really like to find out the user info format so that I can tie it in with The 'Fritter CMS.

I'm sure he's got way more experience dealing with forums than me. If you're around Tom (Levens), jump on IRC.

Normally, I think of myself as a fairly intelligent person. So here I am, wondering why the MD5 hash I'm generating isn't lineing up with the one stored in the database for me.

Forgot I changed my password a month ago.

Excuse me as I bang my head against this table.

I haven't implemented it yet, it'd probably be a good idea to get T.L. in on this before that. But from what I see, in PHP, the authentication would go like this:

$password = mysql_query("select pass from drupal.users where name=$inputted_user_name;");
$to_compare = md5("$inputted_password");
if ("$to_compare" == "$password") {
$verified = "1";
};

In the code sample above, you'd go on and say that if verified was equal to one, then (do whatever the forum does to authenticate a user. Generate a session ID, or give a cookie or whatever.)

Any comments?

-BDub

but there are definitely some things i like about the Drupal forums ... the red/gray stripes for new/old posts ... makes fast scrolling alot easier ... maybe thats something that could be implemented in the new forums ...

I'm starting to lean towards phpBB myself, mostly because I know my way around PHP and YaBB is written in Perl (IIRC).

I completely agree with the red lines by the way. It'd be great if we could implement it so that you could click on where is says "3 New" and have it go right to the new ones. Save us scrolling to the new information.

I really want to get rid of all the whitespace at the bottom (which is a sympton of the Drupal sidebar, and will be gone once we switch) because you hit Command-Down Arrow to go to the bottom, and then you have to scroll up half the time.

Does anybody dislike phpBB for any reason? If so, speak now, or forever hold your peace. If we swap over, and immediately get 'I hate this new layout' posts, it'll be mildly irritating.

-BDub