Code Monkey home page Code Monkey logo

borumforum's Introduction

Borum

Start Date for Project: November 13, 2018

Preventing SQL Injection to Secure Databases

This project uses PHP, MySQL, and SQL to create a website that is not vulnerable to SQL Injection. The project uses functions such as mysqli_real_escape_string() and urlencode() to deal with hacking techniques designed to alter, destroy, expose, or exploit the database.

bforborum

Borum/bforborum is the extension to the above project. Now that I have extensive knowledge of PHP, I can create a secure website while accomplishing another task - in this case a forum. Borum is a Q&A Community for categories starting with Bor- or rhyming with bore, mainly on Boron. The user can navigate Borum like it is a regular, professional website through the sitemap header at the top. The urls are user-friendly using the .htaccess file in the root directory.

Open Source

There is yet another branch to the Borum project. And that is the open source aspect to this. As this is my first project that might actually attract people to contribute to it and use it due to its real-world-applicable nature, I am welcoming open-source. That means pull requests, issues, and feedback.

To start contributing, head over to documents/CONTRIBUTING.md

Directory Organization

CSS makes the page look better and more stylish, and the JavaScript makes it more interactive. The styles are written in css and can be found in the css folder. The databases are written in sql and are found in the databases folder. The images are jpgs, jpegs, gifs, or pngs and can be found in the images folder. The pages are HTML and PHP pages. Within the pages is the includes folder. This is made up of the files that all pages use as a template. The documents are .txt and markdown documents for information. The JavaScript files can be found in the scripts folder.

More Information

More information about each of these can be found on the Borum Wiki!

borumforum's People

Contributors

dependabot[bot] avatar varunsingh87 avatar

Stargazers

 avatar  avatar  avatar

borumforum's Issues

Users without any notifications see all questions

Describe the bug
All the questions show up in a broken-website like way that stop the person from using the site when the user has just made an account

Update
This was fixed and moved to inside the notification bar, but none of these questions should be showing.

To Reproduce
Steps to reproduce the behavior:

  1. Make a new account
  2. Log in
  3. See bug

Expected behavior
No notifications showing up in the notification bar

Screenshots
Screenshot (74)

Additional information

Credit to Vincent for first finding this bug

Post Deletion Redirecting Bug

Description:
The bug occurs when a user deletes their post and clicks the confirmation button, and is then given a message that says "The post was successfully deleted. Redirecting you now..." However, the message does not trigger a redirection prompt, and leaves the user waiting until they realize they need to refresh the page.

Steps to reproduce the behavior:

  1. Go to bforborum.com.
  2. Log into user's account.
  3. Click "Latest Questions". Alternatively, click "Ask a Question".
  4. Click an existing question and write a comment on it. Alternatively, write a question and post it.
  5. Click "delete" under the comment and confirm deletion. Alternatively, click "delete" under the question and confirm deletion.
  6. See bug,

Expected Behavior:
The expected result is a redirection from the deletion screen back to the "Home" page or the "Latest Questions" page.

Screenshot:
image

Desktop (please complete the following information):

  • OS: Microsoft Windows
  • Browser Google Chrome
  • Versions:
    Microsoft Windows: Version 1903
    Google Chrome: Version 72.0.3626.121

Accept cookies shows up on every page

Describe the bug
Whether a user refreshes or goes to a new page, even a page with different query parameters, the "this page uses cookies" message appears at the bottom.

To Reproduce
Steps to reproduce the behavior:

  1. Go to Borum
  2. Click accept
  3. Click on another page through the sidebar, OR refresh, OR click on another page through the header
  4. See bug

Expected behavior
The message should go away

  • If the user is logged in, they accepted it once
  • If the user is not logged in, for every time

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop:

  • OS: Windows
  • Browser: Chrome
  • Version: 81.0.4044.138

Additional context
Add any other context about the problem here.

cant use search function to search users

You can't use the search function to search for Borum users.

Steps to reproduce the behavior:

  1. Go to bforborum.com
  2. Click on search bar
  3. Type in name of a user
  4. See error

You are supposed to be able to search for a viewer.

Desktop (please complete the following information):

  • OS: Windows 10
  • Browser: Chrome
  • Version 78.0.3904.70

Change "no profile picture" picture

Is your feature request related to a problem? Please describe.
The image of the "U" is not very user-friendly. One does not know for what the U stands and why it isn't the first letter of their entered name and such.

Describe the solution you'd like
Change the U to be the first letter of the first name that the user entered for their account if they have not uploaded a profile picture yet.

Describe alternatives you've considered
Use a consistent, more user-friendly image

Additional context
Here is one example of the alternative described:
unavailable

User does not log out on account deletion

Describe the bug
When a user deletes their account, he or she is not automatically logged out.

To Reproduce
Steps to reproduce the behavior:

  1. Log in
  2. Go to Settings
  3. Click Delete Account
  4. Click Delete my Account
  5. See error - in top right corner you still see a profile picture

Expected behavior
The user should be sent to log out after it says "the user has been deleted" which itself should change to "Your account has been deleted." This redirection should occur through a JavaScript setTimeout function.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

  • OS: Windows
  • Browser: Chrome
  • Version 81.0.4044.138

Additional context
Add any other context about the problem here.

Nav Menu for Phones

Add the phone navigation menu as part of the Mobile Update

Additional context
Related to #43, which is kind of a "parent issue."

Settings page does not work!

Describe the bug
The settings page is not found!

To Reproduce
Steps to reproduce the behavior:

  1. Log in
  2. Go to your profile
  3. Click on Settings
  4. See 404 error

Expected behavior
A good-looking familiar settings page with working functionality

Search bar for questions

Most Q & A Website that are popular, secure, and trusted have a search bar at the top. Borum should also be a website with a search bar at the top on the Latest Questions page that searches for the questions. A starter for this should be, that when they press enter, it sends what they typed to the url as a query string, and then this is accessed using $_GET to be injected into an SQL statement (after everything is sanitized) using BOOLEAN FULLTEXT search.

Delete and Edit Answer & Question

There should be a delete button/link and edit button/link under every question and answer that only shows for the post author.

Enhancement

This allows people to fix mistakes in their question or completely remove their answer or question if they deem it necessary.

Forums and Tags

Feature Request

Add an option for a tag, or let the user choose a category

Interface

Borum is a cybersecurity project in essence. However, it is also an impactful website with a caring community. Web design is very important to any website, and the interface for Borum is lacking, to say the least. Attractive web design encourages viewers to see more of the site, and an easy and creative layout helps make the experience all that much better. Borum needs to have a more vibrant design, as well as a more unique layout. This would make the Q&A site a rival to, say, Quora's fantastic layout.

Forgot/Reset Password System

Is your feature request related to a problem? Please describe.
I'm always frustrated when a fellow Borum user forgets his or her password. It pains me to see him or her create a new account because he or she cannot just reset his or her password. There is currently a link in the Login page, but it does not work. In version 0.13.1, please fix all prominent bugs related to the resetting of a user's password.

Describe the solution you'd like
Please complete the functionality for resetting one's password through email. The user should get an email, click the link, fill out their new password, and then immediately be able to log in.

Describe alternatives you've considered
I have not considered any alternatives.

Additional context
ResetPassword1

is the page I am talking about

Add ability to comment

Feature
Add a comment section to questions and answers alike. This will give people more chances to talk on the site which in turn gives the site more traffic.

Describe alternatives you've considered
There are no alternatives because we cannot contact the other person unless through an answer.

Additional context
I would like an interface like Stack Overflow's:
image

Borum Products

I would like three new subdomains:
weather.bforborum.com - called Borum Weather
news.bforborum.com - called Borum News
meta.bforborum.com - called the meta site

Borum Weather should display the weather using the Weather Underground API and HTTP Requests
Borum News should display the latest news with links to news stories using Twitter API
The meta site should look just like the main site, but there should be a clear indication what it is about

email verification doesn't work

When checking the emailed account verification for Borum, the accompanying verification link doesn't work.

Steps to reproduce the behavior:

  1. Go to bforborum.com
  2. Click on sign up and create an account
  3. Check inputted email's "spam" category
  4. Open Borum verification link
  5. See error

The verification link is supposed to appear in the email to be able to verify the account,

Desktop (please complete the following information):

  • OS: Windows 10
  • Browser: Chrome
  • Version 78.0.3904.70

Interesting Questions page

Is your feature request related to a problem? Please describe.
Interesting questions page would be a unique, out-of-the-box page for questions personalized to the user. It will be based on what tags the user is following, and tags the user commonly votes up.

Describe the solution you'd like
The page, which is linked from the sidebar, should be set up similar to the currently named "Latest Questions" page.

Describe alternatives you've considered
Incorporate this into the currently named "Latest Questions" page.

Notification Bar

I'm always frustrated when I have to check every part of the website in order to find whether somebody has replied to a post of mine or voted on it. I wish there was an easier way to check this.

Preferably, I would like a notification menu at the top which shows all answers to a question a logged in user posted and who voted what on any of his or her posts. This should link to that post's question page. The notifications could cover other things such as, in the future, if a topic proposal was approved, or somebody commented on a post. The notification menu should appear as a bell, but when you click it, the menu pops up. Additionally, there should be a badge in the corner of the notification bell. This badge should tell the user how many unread notifications he or she has.

An alternative solution would be to use email as the source of notifications. The problem with this, although it is more likely to alert them, may get annoying because lots of notifications at once

Error message for trying to comment while not signed in

When you are not signed into your Borum account, you can still view topics started by other users. But, the commenting feature is supposedly disabled. When you try to comment while not signed in, nothing happened. This can be quite confusing for some users.

The console should give an error message prompting the user to sign in before commenting when clicking the comment button while not signed in.

Dark Mode flashes light mode on refresh and page change

Describe the bug
In dark mode, the page flashes in light mode

To Reproduce
Steps to reproduce the behavior:

  1. Log in
  2. Turn on dark mode if you have not already
  3. Refresh
  4. See error

Expected behavior
No flash, just dark mode.

Screenshots
I would take a screenshot, but that would be extremely difficult to capture a millisecond, and I am too lazy to take a video.

Additional context
Borum may be sued for causing seizures?

Make Borum Q&A mobile compatible and mobile friendly

Is your feature request related to a problem? Please describe.
I'm always frustrated when I cannot do the same tasks on a phone that I can on my computer.

Describe the solution you'd like
I would like a clean new interface for mobile devices that lets me log in and out as well as ask questions and search.

Describe alternatives you've considered
Use the "Request desktop site" feature on many mobile browsers.

Additional context
Make this regular size again!
image

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.