Welcome to the E-Blah Community!
We would like to welcome you to our community and invite you to register an account or login.
Being a registered member is important, as it gives you several advantages over the normal Guest status. After registering you will be able to download files and images, post messages, and access member-only portions of the forum - just to name a few. Registration is quick and simple, and only takes about a minute of your time.

E-Blah Community    E-Blah Discussion    E-Blah Bugs  ›  Why do Posts have BoardIDs?
Users Browsing Forum
No Members and 2 Guests

Why do Posts have BoardIDs?  This thread currently has 459 views. Print
1 Pages 1 Recommend Thread
Computer Guru
March 28, 2007, 12:28pm Report to Moderator Report to Moderator

E-Blah Member
Posts: 21
Gender: Male
Posts Per Day: 0.03
Time Online: 2 hours 23 minutes
I'm writing a converter for eBlah SQL, and I came across a small thing that can be changed in upcoming betas maybe?

The posts table has boardID column and a threadID column.
ThreadID table has a boardID column and a threadID column.

Technically there is no need for a boardID column in the posts table since from the threadID you can get it directly anyway......
Logged Offline
Site Site Private Message Private message
Computer Guru
March 28, 2007, 12:30pm Report to Moderator Report to Moderator

E-Blah Member
Posts: 21
Gender: Male
Posts Per Day: 0.03
Time Online: 2 hours 23 minutes
Another thing to add to that list:
The email field. Since it has a userID is the email necessary? Since it'll get the email won't be changing per-post, it's technically unnecssary, right?
Logged Offline
Site Site Private Message Private message Reply: 1 - 4
Justin
March 28, 2007, 2:36pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,070
Gender: Male
Posts Per Day: 6.55
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 14 minutes
Location: Tallassee, AL
Age: 22
They are both required.  I almost removed the first one like you said, but it helps a lot during moderation functions I believe.  


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV

Logged Offline
Site Site Private Message Private message Reply: 2 - 4
Computer Guru
March 28, 2007, 4:17pm Report to Moderator Report to Moderator

E-Blah Member
Posts: 21
Gender: Male
Posts Per Day: 0.03
Time Online: 2 hours 23 minutes
Oh OK...

My converter from MyTopix to eBlah is almost done. No real problems to speak of, though I have to add a SALT column to the members database in order to support MyTopix's MD5+Salt password encryption.
Logged Offline
Site Site Private Message Private message Reply: 3 - 4
Justin
March 28, 2007, 7:57pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,070
Gender: Male
Posts Per Day: 6.55
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 23 hours 14 minutes
Location: Tallassee, AL
Age: 22
Yeah, I was thinking of adding it to E-Blah but may not.  The vB converter for E-Blah has to make E-Blah use that.


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV

Logged Offline
Site Site Private Message Private message Reply: 4 - 4
1 Pages 1 Recommend Thread
Print

E-Blah Community    E-Blah Discussion    E-Blah Bugs  ›  Why do Posts have BoardIDs?