|
|
Post by Blind on Apr 15, 2009 6:52:00 GMT -5
Wel i have release the beta version of Jforums  I know there are a few errors, but they will be fixed. Sign up, post, edit your profile and test it out. Let me know what you think, suggestions and any bugs you find. www.forum.asilentdivine.com |
|
Wrighty
Junior Member
[M:10]
Posts: 55
|
Post by Wrighty on Apr 15, 2009 14:54:20 GMT -5
Posts column is blank on main page for a start - fix that.
|
|
|
|
Post by iDesign on Apr 15, 2009 19:06:27 GMT -5
It's deleting random parts of my messages O.o
|
|
|
|
Post by Blind on Apr 15, 2009 21:53:30 GMT -5
Posts column is blank on main page for a start - fix that. I made a post about that. The problem there, is that when making a reply, the post is saved into the id of the original thread, where as the main page is using MYSQL to groupd the threads and posts with the board id. So i need to go through and add the board id into each reply as well as the threads. I will look into that Idesign. |
|
Wrighty
Junior Member
[M:10]
Posts: 55
|
Post by Wrighty on Apr 17, 2009 2:56:23 GMT -5
What's the MYSQL structure like? Table for: -Posts -Topic -Members -PMs -Boards -Categories -Settings Or is there more?  |
|
|
|
Post by Blind on Apr 17, 2009 3:06:41 GMT -5
What's the MYSQL structure like? Table for: -Posts -Topic -Members -PMs -Boards -Categories -Settings Or is there more? Actually only 3 at the moment. - Post+reply - Members - Boards I have the private message table set up but not included yet. I haven't put any more work into this for the past day, just had a few other projects to work on. I will begin fixing all the errors that were found, tomorrow  |
|
Jasek
Full Member
[M:85]
Negoita Cosmin
Posts: 100
|
Post by Jasek on Apr 17, 2009 4:46:24 GMT -5
hahahahah Jye you master! love ur forum! make sure that it's easy customizable like ProBoards. I can't wait for a full release |
|
Wrighty
Junior Member
[M:10]
Posts: 55
|
Post by Wrighty on Apr 17, 2009 6:01:10 GMT -5
How can you have post/reply in the same? |
|
|
|
Post by xcessive on Apr 17, 2009 6:15:29 GMT -5
How can you have post/reply in the same? Cause he is a genius. And a little bit magical. |
|
|
|
Post by Blind on Apr 17, 2009 6:27:57 GMT -5
Thanks Jasek. How can you have post/reply in the same? What Xcessive said  ---- Same way you would do it with both  Basically i have the table which is predominately used for posts but i have the reply and number of replies in that table. All posts are defined by an ID number. So if a post has no ID it means that it is a thread, first post made, and then any replies are given the ID of that original post and nested under it. I find it much easier this way. But i have done it in such a way that will allow me to easily include any other reply feature. |
|
Wrighty
Junior Member
[M:10]
Posts: 55
|
Post by Wrighty on Apr 17, 2009 10:29:27 GMT -5
Ah having them seperate is easier in my opinion but *shrugs* ... How would you get a thread ID specified? Having them seperate allows for more things & reduces database redundancy. Take adding in a thread Description for example. In your way - there will be loads more entries with nothing for 'description' My method - there would only be one table with a few without a description. See where it'd work better having them separate, together-ness things can all be done if separate, separate things can't be done with together-ness |
|
|
|
Post by Blind on Apr 17, 2009 10:39:04 GMT -5
You can pretty much do the same things whether they are separate or together, it is a matter of knowing how.
But i guess it is a matter of what is easier for each person.
I generally use a table for the main rows of a certain element of the coding and use a different one for the smaller parts to that. Then just use MYSQL joins for the 2 tables.
|
|
|
|
Post by Twiggy on Apr 17, 2009 11:00:40 GMT -5
Very nice... But I can't get a thing on what you guys talk about. |
|
|
|
Post by Blind on Apr 17, 2009 18:18:17 GMT -5
Thanks Richard.
|
|
|
|
Post by Blind on Apr 18, 2009 4:44:09 GMT -5
Will be fixing a few of the errors over the next few hours.
Updates will be posted in the development board of the forum.
|
|
