Making YaBB Read User Info From Drupal

16 posts / 0 new
Last post
BDub's picture
Offline
Last seen: 2 years 9 months ago
Joined: Dec 20 2003 - 10:38
Posts: 703
Making YaBB Read User Info From Drupal

I'm going to work on making it do this tonight, but first I thought I'd start a thread about the process in case I get stuck, or in case you want to follow along.

First thing I'm doing is poking at the Drupal database, trying to get an idea of the structure. First, to figure out just what databases it used, I looked at the file http://www.applefritter.com/database/database.mysql This is the file that Drupal uses to initally setup the databases (I think, keep in mind I'm just poking at this point)

So I ssh'd into the Applefritter server and tried to take a look at the database drupal.forum from within the mysql prompt. It's telling me I don't have enough access to do that.

Tom, would you like to up my access on the server. If you don't post back within an hour or so, I'll just write a quick PHP script to pull up the same data.

Thanks.

-BDub

Tom Owad's picture
Offline
Last seen: 15 hours 35 min ago
Joined: Dec 16 2003 - 15:14
Posts: 3384
Wait

I apprecaite the enthusiasm! We don't have to use YABB, though. There are some other pretty nice BBS's. Let me look around.

I'll be in IRC.

Tom Owad's picture
Offline
Last seen: 15 hours 35 min ago
Joined: Dec 16 2003 - 15:14
Posts: 3384
phpBB

I'm thinking phpBB looks like the best choice. Simple Machines (formerly YABB SE) is another possibility.

BDub's picture
Offline
Last seen: 2 years 9 months ago
Joined: Dec 20 2003 - 10:38
Posts: 703
Other Options

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

jt
Offline
Last seen: 17 years 9 months ago
Joined: Dec 20 2003 - 10:38
Posts: 447
paging tomlevens!

I really think you should knock this around with the resident AF/MLA bug squasher. He did some really slick hacking to the MLA's phpBB site just today, we now have fully linkable search strings just like google does over at the barracks . . . so there'll be no more telling people to go search "holy . . ."/whatever!

. . . and the more talented folks in on the collaborative effort, the better!

jt Wink

BDub's picture
Offline
Last seen: 2 years 9 months ago
Joined: Dec 20 2003 - 10:38
Posts: 703
Probably a good idea.

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.

BDub's picture
Offline
Last seen: 2 years 9 months ago
Joined: Dec 20 2003 - 10:38
Posts: 703
Usernames and Passwords

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

Mackie's picture
Offline
Last seen: 18 years 5 months ago
Joined: Dec 19 2003 - 17:34
Posts: 92
phpBB would be really, really

phpBB would be really, really, good. They even have a YaBB converter, I think.

Offline
Last seen: 2 months 1 week ago
Joined: Dec 19 2003 - 17:40
Posts: 566
Re: phpBB would be really, really

phpBB would be really, really, good. They even have a YaBB converter, I think.

yeah phpBB is my favourite ... but heres a thought ... do we really need to stick with Drupal? ... i mean there are other decent CMS that integrate with phpBB out of the box! ... i mean it would be abit of work to move things over ... but it might be a smoother ride there after Beee

BTW ... Tom, i cant connect to the server with my SSH account ... its coming up with a username/password incorrect error ...

TOM

Tom Owad's picture
Offline
Last seen: 15 hours 35 min ago
Joined: Dec 16 2003 - 15:14
Posts: 3384
I've been unable to find anyt

I've been unable to find anything that has Drupal's elaborate taxonomy setup or versatility in modules.

Offline
Last seen: 2 months 1 week ago
Joined: Dec 19 2003 - 17:40
Posts: 566
Re: I've been unable to find anyt

I've been unable to find anything that has Drupal's elaborate taxonomy setup or versatility in modules.

hmm so what we are looking at is a forum based on phpBB/YaBB hacked onto Drupal ... personally i think phpBB would probably be easier because Drupal and it are both based on php ...

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 ...

TOM

Dr. Webster's picture
Offline
Last seen: 1 day 18 hours ago
Joined: Dec 19 2003 - 17:34
Posts: 1760
I'd just like to use a CMS th

I'd just like to use a CMS that allows plain HTML files to be used. The new MacQuarium site is ready to go, but I don't know PHP and I can't find a way to import HTML files while keeping the layout (including imagemaps) the same as I designed it.

Tom Owad's picture
Offline
Last seen: 15 hours 35 min ago
Joined: Dec 16 2003 - 15:14
Posts: 3384
Email me the files.

Email me the files.

BDub's picture
Offline
Last seen: 2 years 9 months ago
Joined: Dec 20 2003 - 10:38
Posts: 703
Re: I've been unable to find anyt


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

Mackie's picture
Offline
Last seen: 18 years 5 months ago
Joined: Dec 19 2003 - 17:34
Posts: 92
I checked out YaBB SE (simple

I checked out YaBB SE (simple machines)...eeyuccchh...

Offline
Last seen: 11 years 4 months ago
Joined: Jan 31 2004 - 13:41
Posts: 100
I like vBulletin, but it cost

I like vBulletin, but it costs $160. I don't mind Drupal, though.

Log in or register to post comments