homer.favenir Posted October 18, 2007 Share Posted October 18, 2007 i want to make forum in php for my company, so that we have an open topic or discussions while on work. pls tell me. thanks Quote Link to comment Share on other sites More sharing options...
cmgmyr Posted October 18, 2007 Share Posted October 18, 2007 You can do a couple things: 1. Use something like SMF or PHPBB 2. Read tutorials about how to make a simple BB Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 thanks, ill search for BB tutorial now. any other advice? Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted October 18, 2007 Share Posted October 18, 2007 Yeah, what kind of stuff do you want help with? I'm currently coding my own here: http://projects.reflexprojects.net/forumbuild/ - so I can help with most stuff. Once you think through the structures, it isn't that complex. Also, mine is 100% my work. Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 can i try this? thanks Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted October 18, 2007 Share Posted October 18, 2007 Working on the posting as we speak. Did the personal message stuff and the setup workings first. But, if you think about it, pm systems are the same as posting. You just query the database to show rows for a certain person/page. Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 you made just 1 db, right?how many tables and fields? first i have to analyze how many tables, and fields in each table. then i have to make a script to retrieve the messages? what steps did you made? thanks Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted October 18, 2007 Share Posted October 18, 2007 My db currently has the following tables (NOTE: Will probably not stay like this, but it's enough to start you off): Categories: Divides the forums up. EG. the first is 'test 2' and the second is 'test' (don't ask why they're that way around, I was feeling random). Forums: 'Test' and 'Space filler' are in these. Members: Take a guess. PM: for personal messages. Posts: For posts. Topics: for Topics. In categories, I have category ID and category name In forums, I have forum ID, forum name, forum description and category ID (for which category to place it in). Members, I have user ID, username, password (md5), posts, avatar (display pic, if you like), signature, msn, aim, website (for people with websites), IP (useful for banning), email address, rank (moderator, member, admin etc.), last active (For the online list and profile), birthday (just for personals), location (JFP), interests (JFP) and title (the line of text that appears under the avatar). PM has PM ID, to (who's it to), from (who's it from), subject (of message), and the actual message. Posts has post ID, poster, post, and topic ID (will have more in the end). Topic has topic ID, topic name, topic description, poster, and forum ID. Any queries, just ask. Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 what tables will appear in index?2nd page,3rd page and so on... Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted October 18, 2007 Share Posted October 18, 2007 what do you mean? Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 ok. i made a db, named forum, im making now the tables... Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 what is md5 in password? Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted October 18, 2007 Share Posted October 18, 2007 it's the encryption. When users register, the password is entered into the database as md5($password). Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 what are the type of each field?e.g. what is the field type of avatar?and for the other field? thanks Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted October 18, 2007 Share Posted October 18, 2007 avatar can just be varchar(255). It's the URL to an image. Then, when you put it in the database, put in '<img src="'. $avatarurl .'">'; Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 i made all the tables in db. then i have to make php scrpt? Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted October 18, 2007 Share Posted October 18, 2007 Yup. The rest is all logical, if you think about it. Just work out what would be called where to do what, and you're laughing. Quote Link to comment Share on other sites More sharing options...
homer.favenir Posted October 18, 2007 Author Share Posted October 18, 2007 maybe that is still a long way, but the first step helps a lot. can i see your forum? thanks! Quote Link to comment Share on other sites More sharing options...
LemonInflux Posted October 18, 2007 Share Posted October 18, 2007 As posted earlier, http://projects.reflexprojects.net/forumbuild/ - posting is being worked on. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.