scripts Archives » 100% Best Unlimited Private Proxies: Fast, Cheap and Secure

Google Scripts Sheets Conditional Sorting

I just recently discovered Google Scripts, and I was wondering if there was a way to sort by a function. For example, if the values in column B were in the range of all real numbers, would there be a way to sort the rows by increasing b^2? Obviously in this scenario it would be the same as sorting by ascending absolute value but this is just an example. I have Java experience so I don’t have a problem writing the actual function, but I just need to get used to all the new functions. I’m already aware range.sort(x) sorts the rows by increasing x, but after a bit of searching I couldn’t find a way to sort by a function of the values in a column.

Also while I’m asking, how do you apply a script to only one tab in a Google Sheets?

database – Is it considered as best practice to use migration scripts for one-off large data manipulation over a table?

I have inherited a project via laravel that uses its database migration mechanism coming from the framework. The application has the following table named actions:

action_log_id SERIAL PK
user_id INT 
action_desc VARCHAR
awarded_points INT
date

And I want to add a column that records that awardee hence, I did the following migration script:

use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;

class ActionAwardee extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('actions', function (Blueprint $table){
            if (!Schema::hasColumn('actions', 'awardee')) {
                $table->string('awardee')->nullable();
            }
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('actions', function (Blueprint $table){
            if (Schema::hasColumn('actions', 'awardee')) {
                $table->dropColumn('awardee')
            }
        });
    }
}

But also I know that under some circumstances the awardee can take some dixed values for example if a record is before 2018 the awardee has value website, hence I can populate the table with some values. The population will be en bulk and it will be one-off field population.

Therefore I want to ask the $ 1.000.000 question (in zibabwe dollars) is it good idea to create yet another migration script for data manipulation or I should do it manually once my application is deployed?

How to enable execution of PowerShell scripts?

The accepted answer is right, but the policy modification is only available for the currently running instance of the Powershell, meaning once the instance of the Powershell is shut down. The policy will be reset. If a user reopens another instance of Powershell, the default policy will be applied which is Restricted

For me, I need to use the VisualStudio Code console and g++ from cygwin to build things. The console is using Powershell, with the default policy, nothing can be done. One solution is changing the policy everytime the console is fired in VisualStudio Code console, maybe a script of changing the policy.

I am lazy, so another solution is when I run the Powershell in admin mode, similar to what the accepted answer does. but with an extra parameter which changes values in the Registry table. Once it been done. Other instances of Powershell will use the RemoteSigned policy by default.

set-executionpolicy remotesigned -Scope CurrentUser

boot – Run a script automatically without “init.d” and no good ‘xbin’ scripts

My android didn’t have ‘init.d’ but I managed to create it. I think the phone still doesn’t run the script associated with it (/system/etc/init.sec.boot.sh) because it uses strace and I don’t have it in my /bin or /xbin folders.

It also has very limited files in /system/xbin and I’m not sure if any of them run on boot.
Anyway I know this question is pretty popular but none of the topics already creted could help me so far.

8 – JS scripts not loading on certain pages

When logged in as a user (not admin), some JS scripts do not load on certain pages.

I found out about this issue because I am using the module EU Cookie Compliance and the scripts it uses (eu_cookie_compliance.js, jquery.cookie.shim.js, js.cookie.min.js) aren’t always loaded.

I am using a JS method provided by the EU Cookie Compliance module in my custom theme and found out it triggered an error on some pages (because the scripts aren’t loaded).

For example, the scripts load on /user/2 but don’t on /user/2/orders or /user/2/customer as you can see on the below image. Why does this happen?

I can see no option in EU Cookie Compliance module that prevents loading the script on some pages. Nor did I find anything in the code.

Edit:

I have now included eu_cookie_compliance as a dependency in my theme:

dependencies:
  - core/drupal
  - core/jquery
  - core/jquery.once
  - core/drupalSettings
  - eu_cookie_compliance/eu_cookie_compliance
  - eu_cookie_compliance/eu_cookie_compliance_bare

And this fixed the fact that the scripts weren’t loaded on all pages. That said, I now have errors on these specific pages.

All I do in my theme’s JS (radix_sub.script.js) is using Drupal.eu_cookie_compliance.hasAgreed() which now triggers the following errors:

I have tried declaring only eu_cookie_compliance and only eu_cookie_compliance_bare and both in my theme libraries, and the errors are identical.

unity – How can I make a script that I will be able to lock/unlock the mouse movements from any other scripts?

I’m using on the player the components : ThirdPersonUserControl and ThirdPersonCharacter.

And I have started this script :

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

public class MouseController
{
   public static void MouseControl(bool MouseLockState)
    {
        if(MouseLockState == true)
        {
            Cursor.visible = false;
            Cursor.lockState = CursorLockMode.Locked;
        }
    }
}

The main goal is to control the mouse movements for example in dialogues to disable the mouse or in cutscenes and then to enable it again.

networking – Network scripts style configuration in Ubuntu 20.04

I’m configuring a VM template for Hyper-V which requires the use of network scripts, i.e. ifcfg-ethX.cfg style of configuration for network adapters to support static IP injection.

How can this be accomplished on Ubuntu Server 20.04? I’ve already disabled NetworkManager via

sudo systemctl stop NetworkManager
sudo systemctl disable NetworkManager
sudo systemctl mask NetworkManager

How to Create Find and Replace Function for Google Drive File Names with Google Scripts

Basically, I have a bunch of files in a shared google drive, let’s say:

AA123_1.jpg
AA123_2.jpg
AA123_3.jpg
…

I am trying to get rid of all of the “123”‘s and replace them with an empty space, or just replace “123_” with “_”. I am not particularly familiar with google scripts (I do understand basic programming logic though), but yeah, basically I was wondering if anyone knows how I could make a script for this as there is a very large amount of files. Thanks ever so much.

In Unity, I’m trying to understand what code gets generated when I attach scripts to GameObjects

I’m trying to observe any file changes that happen when I attach a script to a GameObject.

I am able to attach a script to a GameObject, and verify that it was attached by looking at the console log. (In my case I attached MainPlayer to some random GameObject like WeaponCamera.)

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

public class MainPlayer : MonoBehaviour
{
    public string myName;
    // Start is called before the first frame update
    void Start()
    {
        Debug.Log("I am alive and my name is " + myName);
    }

    // Update is called once per frame
    void Update()
    {
        
    }
}

However, I don’t see any actual code change (eg: line additions) to any files in my unity project (using git status or git diff). I would think that something would get updated in my repo, unless I’m misunderstanding how attachment works? For example, if someone else were to copy my repo and try it on their computer, shouldn’t they have the attachment I just made?