Raw Source Toggle Dropdown

• Minified Source

  Alternate update check target.

reznikovkg / SQL, suck

// ==UserScript==
// @name         SQL, suck
// @description This script even does the laundry!
// @copyright 2018, reznikovkg (https://github.com/reznikovkg)
// @license MIT
// @icon https://upload.wikimedia.org/wikipedia/commons/f/f4/Adblockplus_icon.png
// @homepageURL https://github.com/reznikovkg
// @supportURL https://github.com/reznikovkg
// @version 1.0.0
// @updateURL https://openuserjs.org/meta/reznikovkg/My_Script.meta.js
// ==/UserScript==

(function() {
    'use strict';

    var baseSQL = [
        //1
        "SELECT model, speed, hd FROM PC WHERE price < 500",
        //2
        "SELECT maker FROM Product WHERE type = 'Printer' GROUP BY maker",
        //3
        "SELECT model,ram,screen FROM Laptop WHERE price > 1000"
    ];



    console.log( "start suck big dick" );
    var whatIsIt = window.location.pathname;
    whatIsIt = whatIsIt.substr(0, 10);
    console.log(whatIsIt);


    if ("/learn_exe" == whatIsIt) {

        var listHead = document.getElementById("LN");
        var list = listHead.getElementsByTagName('option');

        for (var i = 0; i < 70; i++) {

            var listItemContent = list[i].innerHTML;

            if ("Ok" != listItemContent.substr(listItemContent.length-2, listItemContent.length)) {
                if ("-&gt;" == listItemContent.substr(listItemContent.length-5, listItemContent.length)) {
                    list[i].innerHTML = listItemContent.substr(0, listItemContent.length-5) + "Ok";
                } else {
                    list[i].innerHTML += "Ok";
                }
            }

            if (list[i].hasAttribute("selected")) {
                console.log("Это номер: "+i);
                var textsqlq = document.getElementById("txtsql");
                if (textsqlq.value.length<10){
                    textsqlq.value = baseSQL[i];
                }
            }
        }
    }

    if ("/dmlexerci" == whatIsIt) {
        var listHead = document.getElementById("N");
        var list = listHead.getElementsByTagName('option');

        for (var i = 0; i < 20; i++) {

            var listItemContent = list[i].innerHTML;

            if ("Ok" != listItemContent.substr(listItemContent.length-2, listItemContent.length)) {
                if ("-&gt;" == listItemContent.substr(listItemContent.length-5, listItemContent.length)) {
                    list[i].innerHTML = listItemContent.substr(0, listItemContent.length-5) + "Ok";
                } else {
                    list[i].innerHTML += "Ok";
                }
            }
        }
    }




    document.body.style.opacity = 1;
})();