Insert the following line in configuration.php.
$allow_adminarea_invoice_mutation = true;
/usr/local/bin/php -q /home/username/public_html/whmcs/crons/cron.php all --force -vvv
journalctl -u dovecot -g "auth failed"
./ipswap.sh Old_IP New_IP
for example:
./ipswap.sh 35.224.2.88 104.197.113.37
-- Disable foreign key checks (important for InnoDB)
SET
FOREIGN_KEY_CHECKS = 0;
-- Delete product meta
DELETE
pm
FROM
wp_postmeta pm
JOIN wp_posts p ON
pm.post_id = p.ID
WHERE
p.post_type = 'product' AND p.post_status != 'draft';
-- Delete term relationships
DELETE
tr
FROM
wp_term_relationships tr
JOIN wp_posts p ON
tr.object_id = p.ID
WHERE
p.post_type = 'product' AND p.post_status != 'draft';
-- Delete the products
DELETE
FROM
wp_posts
WHERE
post_type = 'product' AND post_status != 'draft';
-- Enable foreign key checks again
SET
FOREIGN_KEY_CHECKS = 1;
Steps:
Apply your filter in Sheet1.
Select the range where you want to paste the formula (e.g., A2:A100) but only visible cells will be selected.
Select the range.
Press F5 or Ctrl+G → Click Special… → Choose Visible cells only → OK.
Type your formula (e.g.):
Press Ctrl+Enter (instead of just Enter).
Resetting the Password via SSH:
passwd <username> (replace <username> with your DirectAdmin username, often admin or your server username). service directadmin restart. Sub save_pdf_and_attach_in_email()
Dim OutApp As Object
Dim OutMail As Object
Dim ws As Worksheet
Dim pdf_range As Range
Dim pdf_path As String
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
Set ws = ThisWorkbook.Sheets("Sheet 1")
Set pdf_range = ws.Range("A1:C11")
pdf_path = "C:\Users\greggowaffles\Documents\Youtube Videos\Test\Stats\" & _
"Population Data.pdf"
'align range in pdf
ws.PageSetup.CenterHorizontally = True
pdf_range.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=pdf_path, OpenAfterPublish:=False
'create email
On Error Resume Next
With OutMail
.to = "team@abc.com"
.CC = ""
.BCC = ""
.Subject = "Country Population Data " & Format(Date, "mm-dd-yyyy")
.Display
.HTMLBody = "＜BODY style = 'font-size:12pt; font-family:Calibri'＞" & _
"Hi Team,＜p＞Please see attached pdf file.＜p＞Thanks,＜br＞Greg" & .HTMLBody
.Attachments.Add pdf_path
End With
On Error GoTo 0
Set OutApp = Nothing
Set OutMail = Nothing
'Kill pdf_path
End Sub
# Add Docker's official GPG key:
sudo apt-get update
sudo apt-get install ca-certificates curl
sudo install -m 0755 -d /etc/apt/keyrings
sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc
sudo chmod a+r /etc/apt/keyrings/docker.asc
# Add the repository to Apt sources:
echo \
"deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \
$(. /etc/os-release && echo "${UBUNTU_CODENAME:-$VERSION_CODENAME}") stable" | \
sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
sudo apt-get update
Install Latest version:
sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
sudo docker run hello-world
Try configuring unconfigured packages:
sudo dpkg --configure -a
Update the contents of the repositories
sudo apt-get update
Try to fix missing dependencies:
sudo apt-get -f install
Update all packages with new versions available:
sudo apt-get full-upgrade
Reinstall Ubuntu desktop:
sudo apt-get install --reinstall ubuntu-desktop
Remove unnecessary packages:
sudo apt-get autoremove
Delete downloaded packages already installed:
sudo apt-get clean
Reboot the system to see if the issue was resolved:
sudo reboot
o create a new user in Ubuntu with a password and grant them all permissions (including administrative privileges), follow these steps:
Run the following command, replacing username with your desired username:
To grant full administrative permissions, add the user to the sudo group:
sudo.Switch to the new user:
Then check if the user can run sudo commands:
If it returns root, the user has full administrative access.
If you want the user to execute sudo commands without entering a password:
Now the user has full administrative privileges.
sudo apt update
sudo apt upgrade
sudo apt install wget gcc g++ make flex bison openssl libssl-dev
cd /usr/local/src
wget https://www.directadmin.com/setup.sh
chmod +x setup.sh
sudo ./setup.sh
sudo ufw enable
sudo ufw allow 2222
sudo ufw allow 80
https://YOUR_SERVER_IP:2222
Also you can follow the official guidelines here: https://docs.directadmin.com/getting-started/installation/installguide.html
scp file_name.zip username@server_ip/server_address:/directory_path
@echo off
title Activate Microsoft Office 2021 (ALL versions) for FREE - office.com&cls&echo =====================================================================================&echo #Project: Activating Microsoft software products for FREE without additional software&echo =====================================================================================&echo.&echo #Supported products:&echo - Microsoft Office Standard 2021&echo - Microsoft Office Professional Plus 2021&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office16")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles(x86)%\Microsoft Office\Office16")&(for /f %%x in ('dir /b ..\root\Licenses16\ProPlus2021VL_KMS*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&echo.&echo =====================================================================================&echo Activating your product...&cscript //nologo slmgr.vbs /ckms >nul&cscript //nologo ospp.vbs /setprt:1688 >nul&cscript //nologo ospp.vbs /unpkey:6F7TH >nul&set i=1&cscript //nologo ospp.vbs /inpkey:FXYTK-NJJ8C-GB6DW-3DYQT-6F7TH >nul||goto notsupported
:skms
if %i% GTR 10 goto busy
if %i% EQU 1 set KMS=kms7.office.com
if %i% EQU 2 set KMS=e8.us.to
if %i% EQU 3 set KMS=e9.us.to
if %i% GTR 3 goto ato
cscript //nologo ospp.vbs /sethst:%KMS% >nul
:ato
echo =====================================================================================&echo.&echo.&cscript //nologo ospp.vbs /act | find /i "successful" && (echo.&echo =====================================================================================&echo.&echo #Please consider supporting this project: donate to my paypal "devomman@gmail" &echo #Your support is helping me keep my servers running 24/7!&echo.&echo =====================================================================================&choice /n /c YN /m "Would you like to visit my blog [Y,N]?" & if errorlevel 2 exit) || (echo The connection to my KMS server failed! Trying to connect to another one... & echo Please wait... & echo. & echo. & set /a i+=1 & goto skms)
explorer "https://www.office.com/"&goto halt
:notsupported
echo =====================================================================================&echo.&echo Sorry, your version is not supported.&echo.&goto halt
:busy
echo =====================================================================================&echo.&echo Sorry, the server is busy and can't respond to your request. Please try again.&echo.
:halt
pause >nul
Source: https://gist.github.com/AneurysAdames/2bcbfc58707168a0bc87c2754f62014a