How can I reference a cell in a custom function while setting up data validation in Google spreadsheets?

I made the following Google script to check whether a string is less than some length:

function isLengthLessThan(length, text) {   return (text.length < length) }; 

How can I set up data validation using this custom formula to check the length of cells? What can I put where the question mark is so that it will represent the value of the cell?

custom formula data validation screen

How can I reference a cell in a custom function while setting up data validation in Google spreadsheets?

I made the following Google script to check whether a string is less than some length:

function isLengthLessThan(length, text) {   return (text.length < length) }; 

How can I set up data validation using this custom formula to check the length of cells? What can I put where the question mark is so that it will represent the value of the cell?

custom formula data validation screen

Hydra. Need help with setting up a query! (reward from me)


hydra -l ZOnEx -P /home/22/Documents/top WEBSITE.COM http-get-form “/login:username=^USER^&password=^PASS^&act=login&submit=Login:S=Logout:C=__cfduid=dc7dc335f1591484f690d3626677f462d1561143346; language=en_EN; date=2%7CSat%2C%2022%20Jun%202019%2007%3A11%3A08%20GMT; PHPSESSID=8d8d10696b5b9146c722f0d63ad9aea3” -vV -f

Hydra returns 0 password found on my own account. What could be wrong in the query above? I can easily login to the account via

https://website.com/login?username=^ZOnEx^&password=^qwerty^&act=login&submit=Login

As I found out, this website requires cookies for a successful login, it works in Chrome and Firefox with cookies on.

Thanks in advance guys, I will send $ 20 in BTC for the correct query.

Info from burp:

POST /login HTTP/1.1 Host: https://WEBSITE.COM User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:61.0) Gecko/20100101 Firefox/61.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Referer: https://WEBSITE.COM Content-Type: application/x-www-form-urlencoded Content-Length: 55 Cookie: __cfduid=dc7dc335f1591484f690d3626677f462d1561143346; language=en_EN; date=2%7CSat%2C%2022%20Jun%202019%2007%3A11%3A08%20GMT; PHPSESSID=8d8d10696b5b9146c722f0d63ad9aea3 Connection: close Upgrade-Insecure-Requests: 1  username=ZOnEx&password=qwerty&act=login&submit=Login 

Setting up a virtual machine in a client’s environment [migrated]

I’m a junior penetration tester and recently went into the client’s office in order to test an internal server of theirs.

They gave me their laptop with Windows installed that is connected to the AD domain and the laptop had VirtualBox installed so I could use a Kali machine for testing.

I wanted a direct connection between me and the server so I set up the machine to be on a bridged connection. Unfortunately, what happened next wasted most of my day:

  1. It seems that the laptop (Windows machine) was no longer connected to any network adapter.

  2. The laptop was blocked by the secure connector (ForeScout) but I asked the guy in charge to release the laptop.

  3. After releasing the blocked laptop, the problem persisted and I didn’t have any connection to the network.

Unfortunately, the client is the type of client that has a lot of money to spend on technologies but not so much on how to properly troubleshoot them.


My questions:

From your experience, what could be the issue?

I think it might be a layer 2 problem (the switch might have blocked the network port) but I think that would be weird because the Kali machine would have a different MAC address and a different IP address. Could it be that the switch detects 2 IP/MAC addresses coming from the same port?

Any recommendation on what would be the best procedure in these cases?

(sadly, VPN connections are not an option for this client)

Trackpad’s accessibility setting Enable Dragging gets randomly tuned off

I enable System Preferences → Accessibility Mouse & Trackpad → Trackpad Options… Enable dragging. However, it gets unchecked (disabled) on its own. It happens after a few hours, as I face this issue at least once a day.

enter image description here

Does anyone know the cause or the solution? I’m using 13″ 2015 MacBook Pro running macOS Mojave 10.14.5. Nothing else is installed that can muddle the Trackpad settings.

Setting a variable out of Do-Try Block [Swift]

I need to set a variable such that I can access it out of the do-try block. I use the do-try to exit early if there are any errors. This is what I currently use, but I am not sure that it is the best-practise or if there is any other better way to do it.

let rulesXml: XMLElement     do {         rulesXml = try XMLElement(xmlString: rules.string)     } catch let error {         self.showWarning(message: "Unable to create XML from the LRML Statements. Please validate the statements and try again.\nError: \(error)", title: "Error : LRML File Merge")         return nil     } 

Of course, I could use guard try? but then I cannot access the error message.

Official Google Webmaster Central Blog: Bye Bye Preferred Domain setting

If you used the preferred domain setting in Google’s Search Console they are removing this setting:

Quote:

As we progress with the migration to the new Search Console experience, we will be saying farewell to one of our settings: preferred domain…


Bye Bye Preferred Domain setting
June 18, 2019

I have imported around 90 million unique URLs as new targets and they get deleted with these setting

I have crawled myself quite a few URLs and made them unique

I import them into a fresh project

After a while target URLs of the project get deleted

Here my settings

Are there a maximum amount of URLs file size that GSA ser supports?

Imported target urls file is 6.13 GB

The import process is being success because i see target urls file in projects folder

The GSA ser starts with around fetching 16k urls

And today when i wake up after like 10 hours i see target urls in project folder got reset and there are only several megabytes target urls

I am trying again

the fresh project starts as 

Loaded 16777 URLs from imported sites

And damn target urls already got reset

WPF MVVM validate property before setting when user’s change value in DataGrid [migrated]

Issue: I have a list of a class that’s being displayed in a Datagrid, one of the values needs to ask the user if they really want to change it. This was implemented with a YesNo MessageBox in the value’s Setter.

The problem is that this messagebox should not come up every time the Setter is called, like when a new object is being added to the datagrid with a dialog, it will still ask if you are sure you want to change the value of what is currently being created.

I’m not sure if there’s a clean way of doing this, so any help is appreciated.

Right now the setter in the class looks like this:

public string Value {   get { return _value; }   set    {        string message = "Are you sure you want to modify this value?";        MessageBoxResult result = MessageBox.Show(message, "Confirmation",        MessageBoxButton.YesNo, MessageBoxImage.Question);        if (result == MessageBoxResult.Yes)        {           _value = value;        }        else        {         // Set to previously used value         Value = _value;        }           RaisePropertyChanged("Value");   } } 

Google play service is deleted, and the cellphone is stuck in setting up

I finished unlocking the bootloader on my android, then I downgraded Google Play Service, then I reset the phone to factory default. After the reset, I was asked to set up the phone. However, in the last step the notification appears

Not signed in to use this phone, you first have to sign in to an owner's  Google account in use on this phone when it was last reset.  Because you haven't done so, you have to set up the phone again.  

The setup can’t be completed maybe because it can’t log into a Google account because its Google service is uninstalled/deleted, I can’t go into a setting because it’s still in the stage of preparing the cellphone. I reset the Android again to the factory reset, but it didn’t work and still like that. Please help.

I use ASUS Zen Fone Maxpro M1 OS Oreo (8.1)