1 2 3 4 5

// Print numbers from 1 to 5
for ($i = 1; $i <= 5; $i++) {
    echo $i . " ";
}

for (initialization; condition; iteration) {
    // code to be executed during each iteration
}

<?php
$temperature = 25;

if ($temperature > 30) {
    echo "It's hot outside!";
} elseif ($temperature >= 20 && $temperature <= 30) {
    echo "The weather is pleasant.";
} else {
    echo "It's cold outside.";
}
?>

php
if (condition1) {
    // code to be executed if condition1 is true
} elseif (condition2) {
    // code to be executed if condition2 is true
} else {
    // code to be executed if none of the conditions are true
}

if (condition) {
    // code to be executed if the condition is true
} else {
    // code to be executed if the condition is false
}

if (condition) {
    // code to be executed if the condition is true
}

sudo /opt/lampp/lampp start

sudo ./xampp-linux-*-installer.run

chmod +x xampp-linux-*-installer.run

#include <iostream>
using namespace std;
int main()
{
    int n, r, i, t, q, w, a, s, d;
    cin>>r;
    for(i=1;i<=r;i++)
    {
        cin>>n;
        q=w=a=s=d=0;
        t=n%60;
        q+=n/60;
        if(t>35)
        {
            q++;
            if(t%10<5)
            {
                a+=6-t/10;
                s+=t%10;
            }
            else
            {
                a+=(60-t)/10;
                d+=(60-t)%10;
            }
        }
        else
        {
            if(t%10<=5)
            {
                w+=t/10;
                s+=t%10;
            }
            else
            {
                w+=t/10+1;
                d+=10-t%10;
            }
        }
        cout<<q<<" "<<w<<" "<<a<<" "<<s<<" "<<d<<"\n";
    }
    return 0;
}

ocelotapigw:
    container_name: ocelotapigw
    environment:
      - ASPNETCORE_ENVIRONMENT=Development
    depends_on: 
      - catalog.api
      - discount.api
      - basket.api
      - ordering.api
    ports:
      - "8010:80"

ordering.api:
  container_name: ordering.api
  environment:
    - ASPNETCORE_ENVIRONMENT=Development
    - "ConnectionStrings: OrderingConnectionString=Server=orderDB;Database=OrderDb;User Id=sa;Password=SwN12345678; TrustServerCertificate=True"
    - "EventBusSettings:HostAddress=amqp://guest:guest@localhost:5672"
  depends_on: 
    - orderdb
    - rabbitmq
  ports:
    - "8004:80"

Right Click on Project -> Add -> Container Orchestration Support -> Docker Compose -> Linux

<?php
// Konfigurasi koneksi ke database
$servername = "localhost"; // Ganti dengan nama server Anda
$username = "adminmaster"; // Ganti dengan username database Anda
$password = "DTCMtolong313"; // Ganti dengan password database Anda
$dbname = "master"; // Ganti dengan nama database Anda

// Membuat koneksi
$conn = new mysqli($servername, $username, $password, $dbname);

// Memeriksa koneksi
if ($conn->connect_error) {
    die("Koneksi gagal: " . $conn->connect_error);
}

// Ambil term dari input pengguna
//$term = $_POST["term"];
$term = mysqli_real_escape_string($conn, $_POST['term']);

// Query untuk mengambil data nama lengkap dari master_data_staff dengan jantina = 0
$sql = "SELECT DISTINCT nama_lengkap FROM master_data_staff WHERE jantina = 0 AND nama_lengkap LIKE '%$term%' LIMIT 10";
$result = $conn->query($sql);

// Menyimpan hasil query dalam bentuk array
$data = array();
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $data[] = $row["nama_lengkap"];
    }
}

// Mengirimkan data dalam format JSON
echo json_encode($data);

// Menutup koneksi database
$conn->close();
?>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <script>
        $(document).ready(function() {
            $("#nama_suami").autocomplete({
                source: function(request, response) {
                    $.ajax({
                        url: "fetch_nama_lengkap.php",
                        type: "POST",
                        dataType: "json",
                        data: {
                            term: request.term
                        },
                        success: function(data) {
                            response(data);
                        }
                    });
                },
                minLength: 2 // Jumlah minimum karakter sebelum autocomplete mulai
            });
        });
    </script>

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Edit Staff</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
    <link rel="stylesheet" href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<link rel="stylesheet" href="adminer.css" />

<script>
        $(document).ready(function() {
            $("#nama_suami").autocomplete({
                source: function(request, response) {
                    $.ajax({
                        url: "fetch_nama_lelaki.php",
                        type: "POST",
                        dataType: "json",
                        data: {
                            term: request.term
                        },
                        success: function(data) {
                            response(data);
                        }
                    });
                },
                minLength: 2, // Jumlah minimum karakter sebelum autocomplete mulai
                select: function(event, ui) {
                    $("#nama_suami").val(ui.item.value);
                    $.ajax({
                        url: "fetch_id_number.php",
                        type: "POST",
                        dataType: "json",
                        data: {
                            nama_lengkap: ui.item.value
                        },
                        success: function(data) {
                            $("#id_suami").val(data.id_number);
                        }
                    });
                    return false;
                }
            });
        });
    </script>

// Slick Script
function site_styles() {
	wp_register_style('slick', 'https://cdn.jsdelivr.net/npm/slick-carousel@1.8.1/slick/slick.css', array(), false, 'all');
    wp_enqueue_style('slick');
	wp_register_style('slick-theme', 'https://cdn.jsdelivr.net/npm/slick-carousel@1.8.1/slick/slick-theme.css', array(), false, 'all');
    wp_enqueue_style('slick-theme');
}
add_action('wp_enqueue_scripts', 'site_styles');

// Slick Script
add_action('wp_body_open', function() { ?>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/slick-carousel@1.8.1/slick/slick.min.js"></script>
<?php });

***
  
<script type="text/javascript">    
	jQuery('.history-timeline').slick({
	  dots: true,
	  infinite: false,
	  speed: 300,
	  slidesToShow: 3,
	  slidesToScroll: 3,
	  responsive: [
	    {
	      breakpoint: 1024,
	      settings: {
	        slidesToShow: 2,
	        slidesToScroll: 2
	      }
	    },
	    {
	      breakpoint: 767,
	      settings: {
	        slidesToShow: 1,
	        slidesToScroll: 1
	      }
	    }
	    // You can unslick at a given breakpoint now by adding:
	    // settings: "unslick"
	    // instead of a settings object
	  ]
	});
</script>

// C++ code to find count of largest consectutive subset
#include <iostream>
#include <stdlib.h>
#include <unordered_set>
using namespace std;

int main() {
    int sz, num;
    unordered_set<int> numbers;
    int maxLen = 0;
    cin>>sz;
    for (int i=0;i<sz;i++) {
        cin>>num;
        numbers.insert(num);
    }
    
    for (int i : numbers) {
        if (numbers.find(i-1) == numbers.end()) {
            int temp = i;
            while (numbers.find(temp) != numbers.end()) temp++;
            
            if (maxLen < (temp-i)) maxLen = temp-i;
        }
    }

    cout<< maxLen;
    return 0;
}

<?php
  $greeting = "Hello, ";
  $name = "John";

  $greeting .= $name;

  echo $greeting; // Outputs: Hello, John
?>

<?php
  $firstName = "John";
  $lastName = "Doe";

  $fullName = $firstName . " " . $lastName;

  echo $fullName; // Outputs: John Doe
?>

def qo_shish(son1, son2):
    return son1 + son2

# Test qilish
son1 = 5
son2 = 3
natija = qo_shish(son1, son2)
print(f"{son1} + {son2} = {natija}")

docker images

docker ps

docker ps

 docker-compose -f docker-compose.yml -f docker-compose.override.yml down

docker-compose -f docker-compose.yml -f docker-compose.override.yml up -d

mklink "C:\Users\[your_user_name]\AppData\Roaming\FileZilla\sitemanager.xml" "C:\Users\[your_user_name]\Dropbox\application-sync\Filezilla\sitemanager.xml"

<?php
  $message = "Hello, World!";
  echo $message; // Outputs: Hello, World!

  $message = "Greetings, Universe!";
  echo $message; // Outputs: Greetings, Universe!
?>

<?php
  $message = "Hello, World!"; // This creates a variable named $message and assigns the text "Hello, World!" to it.
  $number = 42; // This creates a variable named $number and assigns the value 42 to it.
?>

<?php
echo "Hello, World!";
// or
print("Welcome to PHP!");
?>

<?php
// PHP code goes here
?>

document.addEventListener("DOMContentLoaded", function () {
  const toggleButton = document.getElementById("fulltoggleButton");
  const myDiv = document.getElementById("fulldetailssection");
  const halfdetailssection = document.getElementById("halfdetailssection");

  if (toggleButton) {
    toggleButton.addEventListener("click", function () {
      toggleSections();
    });
  }

  const halftoggleButton = document.getElementById("halftoggleButton");

  if (halftoggleButton) {
    halftoggleButton.addEventListener("click", function () {
      toggleSections();
    });
  }

  // Attach click event to the document body for specific slick buttons
  document.body.addEventListener("click", function (event) {
    const target = event.target;
    const isSlickButton = target.matches(".wpl-el-property-slider-section .slick-next, .wpl-el-property-slider-section .slick-prev, .wpl-el-testimonial-section .slick-next, .wpl-el-testimonial-section .slick-prev");

    if (isSlickButton) {
      if (myDiv.style.display !== "none") {
        myDiv.style.display = "none";
        halfdetailssection.style.display = "block";
      }
    }
  });

  function toggleSections() {
    if (myDiv.style.display === "none") {
      myDiv.style.display = "block";
      halfdetailssection.style.display = "none";
    } else {
      myDiv.style.display = "none";
      halfdetailssection.style.display = "block";
    }
  }
});

console.log('Hi')

const func = () => {
    return new Promise(resolve => {
        setTimeout(() => {
            console.log('2nd Hi')
            resolve();
        }, 2000)
    })
}

(async () => {
    await func();
    console.log('3rd Hi');
})();

use core {*}

// Using #dyncall dynamically loads the library at runtime.
#foreign #dyncall "libc.so" {
    write :: (fd: i32, data: [&] u8, count: i32) -> i32 ---
}

main :: () {
    msg: [] u8 = "Hello, libc!";

    write(1, msg.data, msg.length);
}
    

Arrays.sort(numsWithIndices, (a,b) -> Integer.compare(a[1],b[1]));

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQChkQQuPfHZ6DM1Rd2rZARH4kHS7t+Zf5F7lsfSGxNaVj670Wnjy6QZZY6a2BBLO5PtOBd0Xpc6Y+2d0wEq2YBzgOO1Pujl1SqkU9bIwrbou2Pq1LGHXySxt+R99aFK4CP4ckJGMhvcTBVPtsdxxb9zab4mRquVITt2Mmkop3DSl7zjl3GVxVB/wn/BAuHaROpAKE33kK0bxdSmRVYhqKXnKx5PdGd1rIONP28znFNk5Fz7gA8398/45vJEAFxv+r5Ti8BLhVdXapz95edMS20VMvlN7wBPncLF7gLCSB8yjp7ozV/X9cbn6oxWdeFOwcYRF8JjiC1J37muOw1w/kLL r.spiridonov@astondevs.ru

 docker image prune -a --force --filter "until=2160h"

const cleanSort = function(x,y)

{

    x = x.toLowerCase();

    y = y.toLowerCase();

    return x < y ? -1 : +(x!=y);

};

const sortInLayer = function(/*str*/name,  o,a,s)

{

    o = app.properties.activeDocument;

    if( !o ){ alert( "No document." ); return; }

    o = o.layers.itemByName(String(name));

    if( !o || !o.isValid ){ alert("No layer with that name."); return; }

    for

    (

        (a=(o=o.pageItems).everyItem().na

{
  "name": "{086f665e-6a55-4107-9147-f9a14e72b137}",
  "description": "managed storage for Open-in-Chrome extension",
  "type": "storage",
  "data":
  {
    "hosts": ["www.bing.com"],
    "urls": []
  }
}

[
    {
      "$lookup": {
        "from": "Assessment",
        "localField": "assessmentId",
        "foreignField": "_id",
        "as": "assessment"
      }
    },
    {
      "$unwind": {
        "path": "$assessment",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$match": {
        "$and": [
          {
            "assessmentId": {
              "$oid": "622072b1aaeb4e5955319304"
            },
            "endCode": {
              "$ne": ""
            }
          }
        ]
      }
    },
   {
  "$project": {
    "_id": 1,
    "name": {
      "$cond": {
        "if": { "$ifNull": ["$assessmentType", false] },
        "then": "$assessmentType",
        "else": "IDRS"
      }
    },
    "assessmentId": "$_id",
    "ok": "$assessment.type",
    "createdAt": 1
  }
}
,
   {
      "$sort": {
        "createdAt": -1
      }
    }

  ]

add_filter( 'eapro_field_typography_customwebfonts', 'eapro_field_typography_customwebfonts_modified' );
if( ! function_exists('eapro_field_typography_customwebfonts_modified')) {
    function eapro_field_typography_customwebfonts_modified() {
        // your custom fonts 
	$custom_fonts = array(
            'Spartan Light',
            'Spartan Regular',
        );
        return $custom_fonts;
    }
}

SELECT 
  content.title,
  content.body,
  content.published,
  author.url,
FROM 
  `3000_forum_boards___updated_daily___english.socialgist_boards_english_public`
  -- Make sure these parameters match the names you set for the dataset and tables
WHERE 
  content.published BETWEEN '2023-01-01' AND '2024-02-29'
  AND (content.body LIKE '%Super Bowl%' OR content.title LIKE '%Super Bowl%')
LIMIT 10;

SELECT
  content.title,
  content.body,
  content.published,
  author.url
FROM
  `200_boards___updated_daily___chinese.socialgist_boards_chinese_public`
-- Make sure the dataset and table selectors use the same name you set when you linked the dataset.
WHERE
  LOWER(content.body) LIKE '%经济%' 
-- The keyword is the word 'economy' in Chinese characters. You can change this to any keyword you wish to scan for in the content body. 
ORDER BY
  content.published DESC
LIMIT 10 -- Limits the results to 100 for demonstration purposes.

//All images in this app come from Code.organd are
//Creative Commons free to use 
var namesList = getColumn("100 Birds of the World", "Name");
var colorsList = getColumn("100 Birds of the World", "Primary Color");
var birdImageList = getColumn("100 Birds of the World", "Image of Bird");
var index = 0;

//Filtered Lists
var filternameList = [];
var filterbirdImageList = [];

onEvent("colorDropDown", "click", function( ) {
  var color = getText("colorDropDown");
  createFilteredList(color);
});

onEvent("leftButton", "click", function( ) {
  index = index - 1;
  updatescreen();
});

onEvent("rightButton", "click", function( ) {
  index = index + 1;
  updatescreen();
});

function createFilteredList(color) {
filterbirdImageList = [];
filternameList = [];
  for (var i = 0; i < colorsList.length; i++) {
    if (color == colorsList[i]) {
      appendItem(filterbirdImageList, birdImageList[i]);
      appendItem(filternameList, namesList[i]);
    }
  }
console.log(filternameList); 
updatescreen();
}

function updatescreen(){
  if (index > 0 && index < filternameList.length){
    setImageURL("birdImage", filterbirdImageList[index]);
    setText("nameLabel", filternameList[index]);
  } else {
    index = 0;
    setImageURL("birdImage", filterbirdImageList[index]);
    setText("nameLabel", filternameList[index]);
  }
}

//forgot to call the function "updatescreen" 

function product_dropdown_shortcode() {
    ob_start();

    // Query to get all products
    $products = get_posts(array(
        'post_type' => 'product',
        'posts_per_page' => -1,
    ));

    // Output the dropdown HTML
    ?>
    <select id="product_dropdown">
        <option value="">Select a product</option>
        <?php foreach ($products as $product) : ?>
            <option value="<?php echo esc_attr($product->ID); ?>"><?php echo esc_html($product->post_title); ?></option>
        <?php endforeach; ?>
    </select>
    <script>
        jQuery(function($) {
            // Initialize select2 for searchable dropdown
            $('#product_dropdown').select2();
        });
    </script>
    <?php

    return ob_get_clean();
}
add_shortcode('product_dropdown', 'product_dropdown_shortcode');
function enqueue_select2() {
    // Enqueue Select2 library
    wp_enqueue_script('select2', 'https://cdnjs.cloudflare.com/ajax/libs/select2/4.1.0-beta.1/js/select2.min.js', array('jquery'), '4.1.0-beta.1', true);
    wp_enqueue_style('select2', 'https://cdnjs.cloudflare.com/ajax/libs/select2/4.1.0-beta.1/css/select2.min.css', array(), '4.1.0-beta.1');
}
add_action('wp_enqueue_scripts', 'enqueue_select2');

-- SQL USER VOOR KLANT MET RESTRICTIES
CREATE USER aagbi_klant WITH PASSWORD = 'zm]vU!Cc<DBaUtJA';
GRANT SELECT ON SCHEMA :: [rep] TO aagbi_klant;
GRANT SELECT ON SCHEMA :: [rep_crs] TO aagbi_klant;
GRANT SELECT ON SCHEMA :: [pbi] TO aagbi_klant;
GRANT SELECT ON SCHEMA :: [aut] TO aagbi_klant;
 
-- MANAGED IDENTITY
CREATE USER [adf-aagbigen-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p01];
GRANT EXECUTE TO [adf-aagbigen-p01];
 
-- SQL ONSDB USER ZONDER RESTRICTIES
CREATE USER aagbi_onsdb_klant WITH PASSWORD = '_WP_-@z[A<6e)55A';
ALTER ROLE db_datareader ADD MEMBER aagbi_onsdb_klant;
ALTER ROLE db_datawriter ADD MEMBER aagbi_onsdb_klant;
ALTER ROLE db_ddladmin ADD MEMBER aagbi_onsdb_klant;
GRANT EXECUTE TO aagbi_onsdb_klant;
 
-- MANAGED IDENTITY GEN
CREATE USER [adf-aagbigen-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p01];
CREATE USER [adf-aagbigen-p02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p02];
CREATE USER [adf-aagbigen-s01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-s01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-s01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-s01];
CREATE USER [adf-aagbimgt-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbimgt-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbimgt-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbimgt-p01];
 
 
-- MANAGED IDENTITY CUS
CREATE USER [adf-aagbicus-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbicus-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbicus-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbicus-p01];
CREATE USER [adf-aagbigen-p02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p02];
CREATE USER [adf-aagbigen-s01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-s01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-s01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-s01];
CREATE USER [adf-aagbimgt-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbimgt-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbimgt-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbimgt-p01];
 
-- MANAGED IDENTITY STO
CREATE USER [adf-aagbigen-d01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-d01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-d01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-d01];
CREATE USER [adf-aagbigen-d02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-d02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-d02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-d02];
CREATE USER [adf-aagbigen-a01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-a01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-a01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-a01];
CREATE USER [adf-aagbigen-a02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-a02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-a02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-a02];
CREATE USER [adf-aagbigen-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p01];
CREATE USER [adf-aagbigen-p02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p02];
 
-- SQL USER ZONDER RESTRICTIES
CREATE USER aagbi_klant WITH PASSWORD = 'wm2[>E-@q^aZm$-T';
ALTER ROLE db_datareader ADD MEMBER aagbi_klant;
ALTER ROLE db_datawriter ADD MEMBER aagbi_klant;
ALTER ROLE db_ddladmin ADD MEMBER aagbi_klant;
GRANT EXECUTE TO aagbi_klant;
 
-- SQL USER WACHTWOORD AANPASSEN
ALTER USER aagbi_klant WITH PASSWORD = '_WP_-@z[A<6e)55A';

 SELECT state_desc
    ,permission_name
    ,'ON'
    ,class_desc
    ,SCHEMA_NAME(major_id)
    ,'TO'
    ,USER_NAME(grantee_principal_id)
FROM sys.database_permissions AS PERM
JOIN sys.database_principals AS Prin
    ON PERM.grantee_principal_id  = Prin.principal_id
        AND class_desc = 'SCHEMA'

sudo -i sed '/deb cdrom:/s/ universe//' /etc/apt/sources.list