WordPress | Scripting and security

Abrir las categorías de una página web en WordPress que se listan mediante botones en un formulario de PowerShell

19/06/201907/06/2019

$buttons_functionslist=@(
    $json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON
    $json.name
)

$buttons_functionbuttoncount = $buttons_functionslist.count

$loop = 0

#Formulario
$Form = New-Object System.Windows.Forms.Form
$Form.Text="Formulario"
$Form.Size=New-Object System.Drawing.Size(500,500)
$Form.StartPosition="CenterScreen"

while($loop -lt $buttons_functionbuttoncount)
	{
	$thisbutton = New-Object System.Windows.Forms.Button
	[string]$thisbuttonname = $buttons_functionslist[$loop]
	$thisbutton.Text = $thisbuttonname
	$thisbutton.size = New-Object System.Drawing.Size(100,20)
	$thisbutton.Location = New-Object System.Drawing.Size(200,(20*$loop+1))
	$thisbutton.Add_Click({
            if($json.name.indexof($this.Text))
            {
                start chrome $json.link[$json.name.indexof($this.Text)]
            }
		})
	$Form.Controls.Add($thisbutton)
	$loop += 1
	}

$Form.ShowDialog()

$buttons_functionslist=@(

$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON

$json.name

)

$buttons_functionbuttoncount = $buttons_functionslist.count

$loop = 0

#Formulario

$Form = New-Object System.Windows.Forms.Form

$Form.Text="Formulario"

$Form.Size=New-Object System.Drawing.Size(500,500)

$Form.StartPosition="CenterScreen"

while($loop -lt $buttons_functionbuttoncount)

{

$thisbutton = New-Object System.Windows.Forms.Button

[string]$thisbuttonname = $buttons_functionslist[$loop]

$thisbutton.Text = $thisbuttonname

$thisbutton.size = New-Object System.Drawing.Size(100,20)

$thisbutton.Location = New-Object System.Drawing.Size(200,(20*$loop+1))

$thisbutton.Add_Click({

if($json.name.indexof($this.Text))

{

start chrome $json.link[$json.name.indexof($this.Text)]

}

})

$Form.Controls.Add($thisbutton)

$loop += 1

}

$Form.ShowDialog()

Ver mediante una lista de botones en un formulario de PowerShell las categorías de una página en WordPress

17/06/201907/06/2019

$buttons_functionslist=@(
    $json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON
    $json.name
)

$buttons_functionbuttoncount = $buttons_functionslist.count

$loop = 0

#Formulario
$Form = New-Object System.Windows.Forms.Form
$Form.Text="Formulario"
$Form.Size=New-Object System.Drawing.Size(500,500)
$Form.StartPosition="CenterScreen"

while($loop -lt $buttons_functionbuttoncount)
	{
	$thisbutton = New-Object System.Windows.Forms.Button
	[string]$thisbuttonname = $buttons_functionslist[$loop]
	$thisbutton.Text = $thisbuttonname
	$thisbutton.size = New-Object System.Drawing.Size(100,20)
	$thisbutton.Location = New-Object System.Drawing.Size(200,(20*$loop+1))
	$thisbutton.Add_Click({
	        Write-Host $this.Text
		})
	$Form.Controls.Add($thisbutton)
	$loop += 1
	}

$Form.ShowDialog()

$buttons_functionslist=@(

$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON

$json.name

)

$buttons_functionbuttoncount = $buttons_functionslist.count

$loop = 0

#Formulario

$Form = New-Object System.Windows.Forms.Form

$Form.Text="Formulario"

$Form.Size=New-Object System.Drawing.Size(500,500)

$Form.StartPosition="CenterScreen"

while($loop -lt $buttons_functionbuttoncount)

{

$thisbutton = New-Object System.Windows.Forms.Button

[string]$thisbuttonname = $buttons_functionslist[$loop]

$thisbutton.Text = $thisbuttonname

$thisbutton.size = New-Object System.Drawing.Size(100,20)

$thisbutton.Location = New-Object System.Drawing.Size(200,(20*$loop+1))

$thisbutton.Add_Click({

Write-Host $this.Text

})

$Form.Controls.Add($thisbutton)

$loop += 1

}

$Form.ShowDialog()

PowerShell Web

Listar las categorías de una página en WordPress con PowerShell

15/06/201907/06/2019

$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON
$json.name

1 2	$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content \| ConvertFrom-JSON $json.name

PowerShell Web

Ver categorías de WordPress JSON API desde PowerShell y mostrar el resultado en una tabla interactiva

30/03/201828/03/2018

$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON
$json.name | Out-GridView

1 2	$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content \| ConvertFrom-JSON $json.name \| Out-GridView

PowerShell Web Web scraping

Enviar un formulario de contacto de WordPress desde PowerShell

10/10/201715/09/2017

$postParams = @{'your-name'='name';'your-email'='email@email.com';'your-message'='message';}
Invoke-WebRequest -Uri "https://www.jesusninoc.com/wp-json/contact-form-7/v1/contact-forms/34/feedback" -Method POST -Body $postParams

1 2	$postParams = @{'your-name'='name';'your-email'='email@email.com';'your-message'='message';} Invoke-WebRequest -Uri "https://www.jesusninoc.com/wp-json/contact-form-7/v1/contact-forms/34/feedback" -Method POST -Body $postParams

Automation Web Web scraping

Detectar los parámetros de un formulario de contacto de WordPress con PowerShell

08/10/201715/09/2017

El primer paso es conocer la dirección URL donde se realiza el método POST del formulario de contacto Desde PowerShell detectar los parámetros

$resultado=(((Invoke-WebRequest 'https://www.jesusninoc.com/contact/').AllElements).where{$_.tagName -eq "form"})
$detectar=$resultado.outerHTML -split "`n" | Select-String "wpcf7-form"
$detectar

$resultado=(((Invoke-WebRequest 'https://www.jesusninoc.com/contact/').AllElements).where{$_.tagName -eq "form"})

$detectar=$resultado.outerHTML -split "`n" | Select-String "wpcf7-form"

$detectar

PowerShell Security Web Web scraping

Detectar con PowerShell si un formulario de contacto de WordPress tiene campos obligatorios

06/10/201715/09/2017

$resultado=(((Invoke-WebRequest 'https://www.jesusninoc.com/contact/').AllElements).where{$_.tagName -eq "form"})
$resultado.outerHTML | Select-String "as-required"
$resultado.outerHTML -split "`n" | Select-String "as-required"

$resultado=(((Invoke-WebRequest 'https://www.jesusninoc.com/contact/').AllElements).where{$_.tagName -eq "form"})

$resultado.outerHTML | Select-String "as-required"

$resultado.outerHTML -split "`n" | Select-String "as-required"

Automation Web Web scraping

Detectar los parámetros de un formulario de contacto de WordPress con Fiddler

04/10/201715/09/2017

Arrancar Fiddler Enviar un formulario de WordPress Analizar la información enviada desde el formulario

Automation PowerShell

Crear un fichero HTML con el contenido de la tabla posts de WordPress con PowerShell

20/09/201709/09/2017

Antes de ejecutar el código en PowerShell es necesario arrancar MySQL Comprobar la base de datos a la que nos vamos a conectar Ejecutar el código para crear el HTML con los datos de la base de datos

#Conexión a MySQL
[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"jesusninoc"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

#Consulta para obtener título y contenido a la base de datos de Wordpress
$Query='select post_title, post_content from wp_posts where id=5'
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
$DataSet = New-Object System.Data.DataSet
$RecordCount = $dataAdapter.Fill($dataSet, "data")
$DataSet.Tables[0].post_content

#Para cada elemento de la tabla añadir al documento HMTL
$DataSet.Tables[0] | %{
"<title>"+$_.post_title+"</title>" | Out-File output.html
"<H1>"+$_.post_title+"</H1>" | Out-File output.html -Append
$_.post_content | Out-File output.html -Append
}

#Cerrar conexión a MySQL
$Connection.Close()

#Abrir el PDF creado
Start-Process .\output.html

#Conexión a MySQL

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"jesusninoc"

$Connection.ConnectionString = $ConnectionString

$Connection.Open()

#Consulta para obtener título y contenido a la base de datos de Wordpress

$Query='select post_title, post_content from wp_posts where id=5'

$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)

$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)

$DataSet = New-Object System.Data.DataSet

$RecordCount = $dataAdapter.Fill($dataSet, "data")

$DataSet.Tables[0].post_content

#Para cada elemento de la tabla añadir al documento HMTL

$DataSet.Tables[0] | %{

"<title>"+$_.post_title+"</title>" | Out-File output.html

"<H1>"+$_.post_title+"</H1>" | Out-File output.html -Append

$_.post_content | Out-File output.html -Append

}

#Cerrar conexión a MySQL

$Connection.Close()

#Abrir el PDF creado

Start-Process .\output.html

Automation PowerShell

Crear un fichero PDF con el contenido de la tabla posts de WordPress con PowerShell

08/09/201707/09/2017

Antes de ejecutar el código en PowerShell es necesario arrancar MySQL Comprobar la base de datos a la que nos vamos a conectar Ejecutar el código para crear el PDF con los datos de la base de datos

#Conexión a MySQL
[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"jesusninoc"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

#Consulta para obtener título y contenido a la base de datos de Wordpress
$Query='select post_title, post_content from wp_posts where id=5'
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
$DataSet = New-Object System.Data.DataSet
$RecordCount = $dataAdapter.Fill($dataSet, "data")
$DataSet.Tables[0].post_content

#Crear el PDF con el título y el contenido
#Descargar https://sourceforge.net/projects/itextsharp/
[System.Reflection.Assembly]::LoadFrom("E:\programas\itextsharp-dll-core\itextsharp.dll")

#Crear el documento PDF
$document=New-Object itextsharp.text.document
$stream=[IO.File]::OpenWrite("output.pdf")
[itextsharp.text.pdf.PdfWriter]::GetInstance($document, $stream)

#Para cada elemento de la tabla añadir al documento PDF
$document.Open()
$DataSet.Tables[0] | %{
$title=New-Object itextsharp.text.Paragraph($_.post_title)
$document.Add($title)
$content=New-Object itextsharp.text.Paragraph($_.post_content)
$document.Add($content)
}

#Cerrar documento PDF
$document.Close()
$stream.Close()

#Cerrar conexión a MySQL
$Connection.Close()

#Abrir el PDF creado
Start-Process .\output.pdf

#Conexión a MySQL

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"jesusninoc"

$Connection.ConnectionString = $ConnectionString

$Connection.Open()

#Consulta para obtener título y contenido a la base de datos de Wordpress

$Query='select post_title, post_content from wp_posts where id=5'

$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)

$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)

$DataSet = New-Object System.Data.DataSet

$RecordCount = $dataAdapter.Fill($dataSet, "data")

$DataSet.Tables[0].post_content

#Crear el PDF con el título y el contenido

#Descargar https://sourceforge.net/projects/itextsharp/

[System.Reflection.Assembly]::LoadFrom("E:\programas\itextsharp-dll-core\itextsharp.dll")

#Crear el documento PDF

$document=New-Object itextsharp.text.document

$stream=[IO.File]::OpenWrite("output.pdf")

[itextsharp.text.pdf.PdfWriter]::GetInstance($document, $stream)

#Para cada elemento de la tabla añadir al documento PDF

$document.Open()

$DataSet.Tables[0] | %{

$title=New-Object itextsharp.text.Paragraph($_.post_title)

$document.Add($title)

$content=New-Object itextsharp.text.Paragraph($_.post_content)

$document.Add($content)

}

#Cerrar documento PDF

$document.Close()

$stream.Close()

#Cerrar conexión a MySQL

$Connection.Close()

#Abrir el PDF creado

Start-Process .\output.pdf

Older Posts