Jump to content

SparkleGirlSparkle

Members
  • Posts

    8
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

SparkleGirlSparkle's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hi, thanks for the email notification. I too no longer do this kind of work, so no longer need my account. Please could you delete my account when you start removing others? No need to let me know when, just go for it! Thank you for telling us all about what happened
  2. My goodness! Thank you so much for going that extra mile and explaining how it would all work - that was above and beyond, so I thank you so much for that. That gives me the perfect chance to go through it step by step and pick it apart from the inside out, so I understand it for future use. You have been absolutely wonderful and helpful! Can't wait to try it out in the morning!
  3. Thanks for the reply. I sort of see where you are going with that. Can I just clarify something? Of the tables I mentioned earlier: - tasks_members (id, task, value) - for the individual tasks - tasks_teams (id, task, value) - for the team tasks - tasks_events (id, task, value, date) - for the once a year tasks - has date included as it can only occur once - tasks_date (id, date) - for the weekly date for the year (e.g. 1=1st Jan, 2=8th Jan, 3=15th Jan, etc) I just need to delete the date one, and then condence all the task tables (be they member, team or special) into one? Meetings are the same day every week, however the special events are only every so often, and never on the same day as a meeting. Would it be better to keep the tables I have already, and then have a completed task table for each one (similar to what you suggested above)? Then I can call from each completed table to work out total points? Especially if different tasks are worth different points? Thanks again
  4. I have some records that would benefit from being in a relational database; they are currently spread across multiple worksheets in Excel. Now, I made a start on the easier side of the information gathering, but I am getting to the point where I'm not sure how to break stuff done and which relationship and keys are required with which table. The database is to record the number of points earned by the group I run, so that we can see which team has earned the most points over a specific period, and which individual has earned the most. I have written this so many times. Apparently it is really complicated to explain, which is maybe why I can't figure out how to proceed with the rest of the design, so please bear with me. I am going to start with what this is all about. We have a group that works on a points system. The group is split into teams, with specific roles, and the teams can gather points for completely certain tasks, both as individual team members, and as a team. These points get added up over the year, so we can work out which team was the best, and which individual was the best. The first part of my database works fine, with the following tables: - members (id, name, teamsidfk, rolesidfk) - teams (id, name) [e.g. blue, green, red] - roles (id, name) [e.g. leader, assistant leader, member] I have happily assigned each team member a team, and their position. So, I can call all leaders, or all members of blue team, without any hassle. Now comes the difficult part of working out how I relate the tasks, their points, and who gets what points for what tasks. The idea is that team members get points for completely individual tasks and special event tasks. These points are added together to make their individual total for the year. Then there are team tasks, which have to be completed as a team. The team total is then made up of the team task totals PLUS individual task totals PLUS individual special events. So, an example might help here: Individual tasks: turn up, wear the correct shoes, bring your equipment - each can be achieved only once per week by each individual, regardless of team, but will be added to weekly team total Team tasks: be first to complete a task, complete assigned duties - some can only be achieved once per week like the complete duties, whereas the first to complete a task could be achieved by the same team more than once a week, (say there were three tasks and they finished all three tasks first) Special event: attend first aid, day trip to the zoo - each can be achieved only one over the whole year by each individual, regardless of team, but will be added to weekly team total So, I have made these independent tables: - tasks_members (id, task, value) - for the individual tasks - tasks_teams (id, task, value) - for the team tasks - tasks_events (id, task, value, date) - for the once a year tasks - has date included as it can only occur once - tasks_date (id, date) - for the weekly date for the year (e.g. 1=1st Jan, 2=8th Jan, 3=15th Jan, etc) Now, I know tasks_events will need a one-to-many relationship between it and the members, as many members can do each special task. tasks_members and members is going to need a many-to-many-to many relationship, as many members can do many tasks on many different dates (ie. every week for the whole year). tasks_teams needs a mixture of one-to-many-to-many and many-to-many-to-many, as some tasks can be done once a week only, and other many times per week. tasks_date needs a one-to-many-to-many as one date will hold many team members doing many tasks. This much I know, but how to break the tables down, and which foreign keys to import to which table in order to add things is where I am getting stuck, because it's that additional relationship I don't know where to add. So, time for another example, I think. Say this is the information I want to add for the first week: Fred, on team blue, on the 1st Jan, turned up and brought his equipment. The blue team completed three tasks first that night. John, on team blue, on the 1st Jan, turned up with the correct shoes. The blue team completed three tasks first that night. Fred's tasks = 2 points John's tasks = 2 point Blue team tasks = 3 points Blue Team Total (Team + team member points) = 7 points Anne, on team green, on the 1st Jan, turned up, wore the right shoes, and brough her equipment. The green team completed one task first that night. Anne also attended the trip to the zoo. Bob, on team green, on the 1st Jan, turned up. The green team completed one task first that night. Anne's tasks= 3 points + 1 point (for the zoo) = 4 points Bob's tasks = 1 point Green team tasks = 1 point Green Team Total (Team + team member points) = 6 points So, on the 1st Jan, the results we should get are that Anne was the best individual, and Blue were the best team. If the same information was repeated for the following week (without Anne going to the zoo), then we would get a total of: Fred's tasks = 4 points John's tasks = 4 points Blue team tasks = 6points Blue team total = 14points Anne's tasks = 7 points Bob's tasks = 2 points Green team tasks = 2 points Green team total = 11 points So, Anne is still the best individual, and blue the best team. The idea is to keep that going all year, so we can eventually add up all the points gained, individually, as a team, and from special events to work out the best team and best individual. Once constructed, I hope to also be able to make calls to the database so that I can see all points from team blue, and how they were made up over the year e.g. 55 points from Fred (22 showing up, 13 right shoes, 15 bringing equiptment, 5 special events - zoo, museum, concert, gallery, theatre; 12 points from John (7 showing up, 2 right shoes, 3 bringing equiptment, 0 sepcial events); 33 blue team tasks (22 finishing first, 11 completing duties); 100 blue team total. Please, absolutely feel free to ask any questions! I'm pretty confused myself, so I imagine there will be some. I know the answer lies in getting the right construction and layout between the tables, although I'm not sure if I need another to draw everything together or not. I do feel like I'm really on the verge of solving this, and I just need one or two pointers to achieve the right outcome. I look forward to the questions and suggestions. Thank you in advance for any help.
  5. I hope this is in the right place, and I apologise if it is not. I wanted to know what people felt about using portals. I want the main index of my site (mysite.com/index) to have a similar layout to the portals I have seen, but I do not want to be doing this direct from the message board. Reading some of the instructions for some portals, I've noticed that in order for it to run off the message board data, it has to be located at mysite.com/board/portal.php. That is not what I am after. I would like the main index page to contain some data that would be collected from the phpBB (no of members, latest posts, etc), but also I wish for it to contain stuff from the actually website, like news headlines. Then, a couple of things, like interesting information, newsletter sign-ups, would be seperate from the main website content and the phpBB. With that in mind, those who have used portals, would you suggest using a portal system, or running the whole thing off seperate MODs, like 'Topics Anywhere'? Any input would be gratefully received.
  6. Thanks for the advice! Following your suggestions I was able to create what I wanted to achieve, and it was a lot simpler than I thought, mainly because I was under the impression I needed to create it in a different way. Anyway common sense, and a little trial and error, have prevailed and I have completed the task! So thanks again for the pointers! [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]
  7. Background: I'm creating a news system using a database, so that I update the database with any news and (because of the coding) will automatically update on my website. So far, I have scripted my pages so that a title and summary of a news item appears on the homepage, followed by a link to the main news page. The main news page is scripted so that everything in the database shows up. My aim is to be able to add an anchor to each of the news articles on the main page, the name of the anchor to be determined by the id in the database. But I cannot figure out how to make that happen. Once that is achieved, I also need to be able to rescript to the link on the home page so that it will take you to the actual news article, so rather than having www.mysite.com/news, the link could then be www.mysite.com/news#2 (again, scripting it so it automatically adds the appropriate id to the link.) I've no idea if this is possible, but it's worth a try at finding out. Otherwise I'm quite happy to stick with all the articles on one page and making my readers sift their way through the articles! [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.