niyazialpay / alphablog

About This Project

Alpha Blog

I had previously designed the database of this system using MongoDB, but due to various compatibility issues, I had to redesign it using MySQL.

The in-site search engine is provided by Meilisearch.

The following PHP functions need to be enabled on the server for this system to work:

escapeshellarg, escapeshellcmd, proc_open, proc_get_status, proc_close 

For installation after git clone process

composer update --no-dev

cp .env.example .env

Edit the .env file for database information, Meilisearch, Email SMTP and Cloudflare Turnstile (similar to Google Recaptcha) definitions

php artisan key:generate

php artisan storage:link

php artisan migrate

MeiliSearch Integration

You need to use Meilisearch for the in-site search engine. After registering at https://www.meilisearch.com/, you can get the master key and add it to your .env file with the address given to you. If you do not want to create an account on the Meilisearch website, you can use it by installing it on your own server. You can get information about this from this link.

MEILISEARCH_HOST=
MEILISEARCH_KEY=

php artisan scout:sync-index-settings

After all this, if you want, you can change the admin panel path from the ADMIN_PANEL_PATH variable in the .env file

php artisan optimize

To create a user after these operations

php artisan app:create-user

To delete posts and comments in the trash, as well as words you don't intend to use in search words

php artisan app:clear-trash

Cron job definition to automatically delete unused search words, trashed posts and comments from the last 30 days

* * * * * php artisan schedule:run >> /dev/null 2>&1

or

0 0 * * *  php artisan clear-trash >> /dev/null 2>&1

For activate Gemini Chatbot

If you want to activate Gemini Chatbot you have to get an API key from https://makersuite.google.com/app/apikey and add it to the .env file

GEMINI_API_KEY=

For activate ChatGPT Chatbot

If you want to activate ChatGPT Chatbot you have to get an API key from https://platform.openai.com/api-keys and add it to the .env file

OPENAI_API_KEY=

Also you can change ChatGPT model from the .env file

OPENAI_MODEL=

Cloudflare Turnstile Integration

By creating an account on Cloudflare, you can get your site key and secret key for Turnstile and add it to your .env file.

CF_TURNSTILE_SITE_KEY=
CF_TURNSTILE_SECRET_KEY=

Note

By default, notification and contact emails are sent directly. If you change this to queue in the .env file, these sends will be queued and happen in the background

MAIL_SEND_METHOD=queue
NOTIFICATION_SEND_METHOD=queue

Features

• Blogs with Categories
• Page
• Personal notes
  • Your personal notes are stored encrypted in the database.
  • Your encryption key is not stored in the database. If you forget your encryption key, you will not be able to access your notes.
  • Your notes can not accessed by the admin or any other user.
• In-site search engine (Meilisearch)
  • The words searched in the search engine are kept in the database
    • It saves the words that are not found among the words in the on-site searches to generate ideas for content on that topic later.
• Admin panel
• OneSignal Push Notification for Admin
  • New Comment Notification
  • Searched Word Notification
• Webauthn Login
• 2-Factor Authentication
• AI Chatbot - Based by Gemini or ChatGPT
• IP Filter (Blacklist and Whitelist)
• User management
• Cloudflare Turnstile (similar to Google Recaptcha)
• Email SMTP
• Media Library
• MySQL
• Laravel 11
• PHP 8.3
• Bootstrap 5
• Font Awesome 6.5.1 (Pro)