Jump to content

dannyluked

Members
  • Posts

    95
  • Joined

  • Last visited

    Never

Everything posted by dannyluked

  1. Hi, I have 2 tables, Table 1 ID | Name 1 | Item 1 2 | Item 2 Table 2 ID | Name | nomb 1 | Product 1 | 1 3 5 I want to make something that will echo the rows in Table 2. However, if the user selects a product from 'Table 1' (like Item 1) they cant have certain item(s) from 'Table 2'. Example, If user chooses Item 1 (with id '1') they cant have a product from Table 2 because it is not compatible. Whether it is compatible is stated in the 'nomb' column. In there the ID's of none compatible items from Table 1 will be stored. At the moment the 'nomb' column states that it is not compatible with items from Table 1 that have the ID 1, 3 or 5. Basically I need to split up the column 'nomb' (remove the space) and give it its own variable. Further exaple, 1) User Chooses Item 2 from Table 1 so they can have the Product in Table 2 2) If user chooses Item 1 then they cant have another product because it is not compatible with Product 1 (the 'nomb' column contains the ID of Item 1) Thanks in advance and I'm sorry it is so hard to understand
  2. The forum is now finished! I need it testing again as code has been changed and added. Also tell me what you think of the 'statistics' and 'who is online' in the index of the site. Thanks
  3. Hello, How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ago? Also, what type of field will I need to create in the database? date/time or just time? And, what type of date/time function would I use to insert the data? would I just use UNIX Timestamp? Thanks!
  4. Thanks for the reply but I cant filter ' because some websites contain the (i think!) Is there anything else I need to filter apart from the ones mentioned?
  5. Hi, Thanks for testing. I was just wondering if you could ellaborat more on the above post! I think I have stopped the onclick functon along with some others!
  6. UPDATE: I have now changed the navigation accordingly and I have added formatting. Please continue to review and update me on any thoughts. BBcode is now enabled also
  7. Hi, I like the site, there dosent seem to be any major problems. The only thing I would maybe do is have a way of seeing what you have uploaded. You could show all images uploaded by IP. So for example when I upload the image it logs my IP. Then on the homepage it shows all images uploaded on that IP. Its isnt the best methos but probably the easiest! If you didnt want to do that you could make a simple login section for regular users?
  8. Hi, I looked at your site and cant find a way of fixing your problem however, you dont want users to need to scroll to read an article but on my netbook I have to scroll left and right to see the whole page! I would focus on making the page fit a screen that has a width of 1024! Maybe add a button to make the page smaller?
  9. Thanks for the replies! Does anyone know how I can make inputed text format the way the user typed it. For example when the user goes down a line (presses enter) the text will be formatted with a line break (<br>)?
  10. Hi, Does anyone have a link to a good BBcode tutorial. It may even just be a download or a script. I am struggling to understand it so far! Thanks
  11. Thanks for the good 'review'. I am next goint to be looking at introducing BBcode. This would make the forum a lot better but when looking for info about bbcode I am struggling to find some help!. I will add another profile button on the forum page right away! The forum is mainly to practice my PHP but if good enough I may use it if I go into PHP when I'm older! It is ment to be simple so that when implemented on someones site (e.g. client...) they will be able to use it even with basic computer knowledge. If they did want a complicated forum I would just install one!! I am not 100% keen on the white page messages but I dont like forwarding users straight to a page. I feel it is like someone is controlling you! Thanks for the comment again!!
  12. The way I wanted, sortof! I could have made it wider but I wanted it to be inside the site rather than attached (I wanted to keep the lefta nd right of the site) Thanks for the comment...
  13. Hi, I have recentley made a forum! Please test it, and tell me how it looks on your browser. I'm not too bothered about the code for the moment just functionality, looks and usability. Test with; Username: test passowrd: test My forum is here: http://dannyluked.comze.com/forum Please only comment on the forum as I have another thread to comment on the rest of the site...here
  14. Thanks, I have changed the message and hopefully I have stopped any xss into the forum! The forum will only be used by simple computer users anyway but I may use the code again, when I'm older if I go into PHP coding. Could someone please comment on the functionality of the forum and design please but I am still willing to hear of any other security threats...
  15. Again, thanks for the testing but could you ellaborate on how you are doing that! Also could you tell me of any ways to stop it. EDIT: I have now added code so hopefully you can't now XSS into a reply...
  16. Hi again, I think I have stopped the XSS (resulting in not being able to do any of the things you commented on) and I have also stopped the ability to post blank comments/topics. Please tell me if you find any other security threats! Thanks
  17. Thanks for the testing. But could you please tell me how you have done these things and what file you can xss into? Thanks again!
  18. I read it lol, what was I doing wrong? and thanks anyway
  19. When are they going to approve it? Its putting me off the forum lol
  20. Hi, Just wondering how long it takes for a topic to get approved in that forum as I added one at 10:23 am and it still hasnt been approved! Also why do they have to be approved? Thanks
  21. Hi, I have been working on a forum for a while now (2 months). I have only been doing it slowly and the main reason I have done it is so that it is simple and easy for me to edit. Please test the forum for all practical things and security flaws. Anyway enough blab, have a look and please give me constructive critasism on the forum either via; - dannyluked@blueyonder.co.uk - through my forum - or through this forum! Log in with; Username = test Password = test http://dannyluked.comze.com/forum This is the link to my profile: Here Thanks, PS. I only want you to test the forum, not the whole site!
  22. Hi, could someone please combine these 2 queries as they both work seperately but I need them together for a reason that is impossible to explain but I will try if it works! Query 1; SELECT forum.*, forum.id AS fid, cat.*, Deriv1.fforumcount FROM cat LEFT OUTER JOIN forum ON cat.id = forum.catid LEFT OUTER JOIN (SELECT catid, count(forum.id) AS fforumcount FROM forum GROUP BY catid) Deriv1 ON cat.id = Deriv1.catid WHERE forum.forumlevel = 5 ORDER BY forum.catid, forum.id ASC Query 2; SELECT *, SUM(replycount) FROM topics GROUP BY forumid PS. the codes both need to show the results the same way they do now so it cant be a whole new code! Thanks
  23. I'm just a beginner! Could you go into more detail please
  24. I think you may not fully uderstand me! I need to add this query; SELECT *, SUM(replycount) FROM topics GROUP BY forumid Into this; SELECT forum.*, forum.id AS fid, cat.*, Deriv1.fforumcount, topics.*, SUM(replycount) FROM cat, topics LEFT OUTER JOIN forum ON cat.id = forum.catid LEFT OUTER JOIN (SELECT catid, count(forum.id) AS fforumcount FROM forum GROUP BY catid) Deriv1 ON cat.id = Deriv1.catid WHERE forum.forumlevel = 5 ORDER BY forum.catid, forum.id ASC I think that should make it easier!
  25. Thanks for the reply. The table structure for topics; topicname | forumid | postcount Topic - 1 | 10 Topic - 2 | 3 I want the postcount to be added up and shown next to the correct forum. This is the qry I have so far to show forums and categorys; mysql_query("SELECT forum.*, forum.id AS fid, cat.*, Deriv1.fforumcount FROM cat LEFT OUTER JOIN forum ON cat.id = forum.catid LEFT OUTER JOIN (SELECT catid, count(forum.id) AS fforumcount FROM forum GROUP BY catid) Deriv1 ON cat.id = Deriv1.catid WHERE forum.forumlevel = 5 ORDER BY forum.catid, forum.id ASC")
×
×
  • 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.