Nocturnal Proxies

To see the proxy server address on your PS, you need to do the following steps:

Launch PlayStation 4.
In the "Library" category, go to "Settings".
Select "Network.
Click on "Establish an Internet connection.
Select "Use LAN cable" or "Use Wi-Fi". In the second case, select an access point and specify the password. On a new page, select "Special". In categories "IP-address settings", click on the item "Automatic". You do not need to specify the DHCP hostname.
DNS settings - "Automatic".
MTU settings - "Automatic".
In the "Proxy Server" section, click on "Use".
On the page that opens, the data of the proxy server will be specified.

When working with OpenXML, you may need to parse date values from date-formatted cells in Excel spreadsheets. The date values in OpenXML are represented as numeric values, and you need to convert these numeric values to DateTime objects.

Here's an example using C# and the DocumentFormat.OpenXml library to parse date values from an Excel spreadsheet:

1. Install the Open XML SDK:

   • If you haven't already, install the DocumentFormat.OpenXml NuGet package:

nuget install DocumentFormat.OpenXml

Write the Parsing Code:

• Create a C# script or add the following code to your project:

using System;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

class Program
{
    static void Main()
    {
        string filePath = "path/to/your/excelfile.xlsx"; // Replace with the path to your Excel file

        // Call the function to parse dates from the Excel file
        ParseDatesFromExcel(filePath);
    }

    static void ParseDatesFromExcel(string filePath)
    {
        using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(filePath, false))
        {
            WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
            SharedStringTablePart sharedStringTablePart = workbookPart.GetPartsOfType().FirstOrDefault();

            if (sharedStringTablePart != null)
            {
                foreach (WorksheetPart worksheetPart in workbookPart.WorksheetParts)
                {
                    foreach (Cell cell in worksheetPart.Worksheet.Descendants())
                    {
                        if (cell.DataType != null && cell.DataType.Value == CellValues.SharedString)
                        {
                            int sharedStringIndex = int.Parse(cell.InnerText);
                            string sharedStringValue = sharedStringTablePart.SharedStringTable.Elements().ElementAt(sharedStringIndex).InnerText;

                            if (DateTime.TryParse(sharedStringValue, out DateTime parsedDate))
                            {
                                Console.WriteLine($"Parsed Date: {parsedDate.ToShortDateString()}");
                            }
                            else
                            {
                                Console.WriteLine("Not a valid date format.");
                            }
                        }
                        else if (cell.CellValue != null)
                        {
                            if (DateTime.TryParse(cell.CellValue.Text, out DateTime parsedDate))
                            {
                                Console.WriteLine($"Parsed Date: {parsedDate.ToShortDateString()}");
                            }
                            else
                            {
                                Console.WriteLine("Not a valid date format.");
                            }
                        }
                    }
                }
            }
        }
    }
}

2. • Replace "path/to/your/excelfile.xlsx" with the actual path to your Excel file.

3. Run the Code:

   • Execute the code, and it will print parsed date values from the Excel file.

This code uses the SpreadsheetDocument class from the DocumentFormat.OpenXml.Packaging namespace to open the Excel file, and it iterates through the cells to parse and print date values. It checks if the cell contains a shared string (string stored in the shared string table) or a direct value. If it's a valid date, it parses and prints it. Adjust the code according to your specific needs and Excel file structure.

To upload files using Selenium, you can follow these general steps:

Locate the file input element: Use Selenium's methods like find_element_by_id(), find_element_by_name(), or find_element_by_xpath() to locate the file input element on the webpage.

Send keys to the file input element: Use the send_keys() method to send the file path to the file input element. This will upload the file.

Here's an example using Python:

from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys

# Replace 'your_url' with the URL of the webpage you want to open
driver = webdriver.Chrome()
driver.get('your_url')

# Replace 'file_input_id' with the ID of the file input element on the webpage
file_input = driver.find_element(By.ID, 'file_input_id')

# Replace 'path/to/your/file' with the path to the file you want to upload
file_path = 'path/to/your/file'
file_input.send_keys(file_path)

# Rest of your code

driver.quit()

Keep in mind that the specific method to locate the file input element and the file input element's ID or name may vary depending on the webpage you're working with.

Additionally, some websites may have specific requirements or restrictions for uploading files. In such cases, you may need to use JavaScript or other methods to bypass these restrictions. If you encounter any issues or need further assistance, please provide more information about the webpage and the specific error message or problem you're facing.

Setting up a proxy on your TV depends on the type of TV and the operating system it uses. Some smart TVs run on platforms like Android TV, webOS, or Tizen, which allow you to install apps and configure network settings. Here, I will provide instructions for popular smart TV platforms:

Android TV:
- Press the "Home" button on your remote control.
- Scroll up or down to "Apps" and highlight "Settings."
- Select "Network" or "Network & Internet."
- Choose "Advanced settings" or "More settings."
- Select "Manage proxy settings" or "Proxy settings."
- Choose "Enable proxy" and enter the proxy server address, port, and authentication credentials (if required).
- Save the settings and restart your TV if necessary.

webOS (LG Smart TV):
- Press the "Home" button on your remote control.
- Scroll up or down to "Settings" and select it.
- Choose "All Settings" or "General."
- Select "Network" or "Internet."
- Choose "Wi-Fi Direct" or "Wired" depending on your connection type.
- Select "Advanced settings" or "Internet settings."
- Choose "Manual proxy settings" and enter the proxy server address, port, and authentication credentials (if required).
- Save the settings and restart your TV if necessary.

Tizen (Samsung Smart TV):
- Press the "Menu" button on your remote control.
- Scroll up or down to "Settings" and select it.
- Choose "General" or "Network."
- Select "Network status" or "Internet."
- Choose "Wi-Fi" or "Wired" depending on your connection type.
- Select "Advanced settings" or "Internet settings."
- Choose "Manual proxy settings" and enter the proxy server address, port, and authentication credentials (if required).
- Save the settings and restart your TV if necessary.

In the messenger settings, go to "Data and Drive". Click on "Proxy settings", and then, enabling the "Use proxy settings" tab, enter the server, port, username and password in the specially highlighted fields. If you are going to make settings in the Desktop version, you will need to go to the menu. There, in the "Connection method" item, click on "TSP via Socks5" and enter the required data.