andreyuhai

/etc/default/grub GRUB_CMDLINE_LINUX_DEFAULT="quiet splash acpi_backlight=vendor"

sudo update-grub

if this does not work then try

/etc/default/grub GRUB_CMDLINE_LINUX_DEFAULT="quiet splash acpi_backlight=video"

andreyuhai

select 
    cust_id,
    gender,
    weight
from customer c
WHERE weight >  (SELECT AVG(weight)  
                 FROM customer 
                 WHERE gender = c.gender)
order by c.gender

andreyuhai

WITH Orders (customerID, orderNum) AS
(
	SELECT CustomerID, COUNT(*) 'number of orders'
	FROM Sales.SalesOrderHeader
	GROUP BY CustomerID
)
SELECT customerID, 'Value' =
	CASE
		WHEN orderNum > (SELECT (AVG(CAST(orderNum AS FLOAT)))
						 FROM Orders

andreyuhai

How to change Apache's root directory to some other directory

You'll have to edit apache2.conf and 000-default.conf to change the document root of apache.

The Apache server is installed on var/www/html.This is the default root directory of apache.

Either change the root directory of Apache or move the project to /var/www/html.

To change Apache's root directory, run:

andreyuhai

How to create laravel projects

To create laravel dependent projects using composer:

composer create-project laravel/laravel your_project_name --prefer-dist

andreyuhai

<div class="card-columns">
  <div class="card">
    <img class="card-img-top" src="..." alt="Card image cap">
    <div class="card-body">
      <h5 class="card-title">Card title that wraps to a new line</h5>
      <p class="card-text">This is a longer card with supporting text below as a natural lead-in to additional content. This content is a little bit longer.</p>
    </div>
  </div>
  <div class="card p-3">
    <blockquote class="blockquote mb-0 card-body">

andreyuhai

// Just set the action command and test it in the action listener
// Once clicked this button below it pauses the thread, and when clicked once again it notifies thread to resume. Kinda  start/stop
        pauseButton.addActionListener(e -> {
            if (e.getActionCommand().equals("resume")) {
                accountCheckerBot.setRunning(true);
                pauseButton.setActionCommand("pause");
                pauseButton.setText("Pause");
                synchronized (accountCheckerBot) {
                    accountCheckerBot.notify();
                }

andreyuhai

How to sync a forked repo with the original one

First add your upstream

git remote -v

git remote add upstream https://github.com/ORIGINAL_OWNER/ORIGINAL_REPOSITORY.git

git remote -v

andreyuhai

How to set up an alias for your laravel project in a folder other than /var/www/html

Put your alias configuration in /etc/apache2/mods-enable/alias.conf

Alias /alias "/home/user/your_laravel_project_folder_/public"

    <Directory "/home/user/your_laravel_project_folder_/public">
            Options Indexes FollowSymLinks Includes ExecCGI MultiViews
            AllowOverride All

Require all granted

andreyuhai

How to create a controller and model with php artisan

To create a controller with php artisan just type

php artisan make:controller YourController

If you want to create your controller with resources ( index, update, edit, store...) then

php artisan make:controller YourController --resource