​✅ Saiba como montar a sua ferramenta de redirecionamento automático para grupos de WhatsApp de graça com WordPress.

📁​ Arquivos prontos para download nessa aula.

​👉 ​INSTRUÇÕES BÁSICAS VÍDEO 1:

1- Acessar o BD (PHPMyAdmin)

2- Criar duas tabelas (REDIRECT_LIMIT e REDIRECT_ZDG)

3- TABELA redirect_limit 4- TABELA redirect_ZDG 5- Página – Painel 6- Página – Link de Redirect

​👉 ​INSTRUÇÕES BÁSICAS VÍDEO 2:

CREATE TABLE redirect_limit (    id INT(11) AUTO_INCREMENT PRIMARY KEY,	limite INT(11) NOT NULL    ) 
CREATE TABLE redirect_zdg (    id INT(11) AUTO_INCREMENT PRIMARY KEY,
	LinkRedirect VARCHAR(550) NOT NULL,
	Total INT(11) NOT NULL
    ) 
function contador()
{

/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost:3306", "bn_wordpress", "0461f67d5e", "bitnami_wordpress");
	
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
	
//select limit
$selectLimit = mysqli_query($link,"SELECT Limite FROM redirect_limit");				  
$row=mysqli_fetch_row($selectLimit );
$selectINT = $row[0];

//update total
$contador = "UPDATE redirect_ZDG SET Total = Total + 1 WHERE Total < $selectINT LIMIT 1";
if(mysqli_query($link, $contador)){
    echo "
Aguarde 5 segundos para ser redirecionado...";
} else {
    echo "ERROR: Could not able to execute $contador. " . mysqli_error($link);
}
	
//redirect com select
$redirectLink = mysqli_query($link,"SELECT LinkRedirect FROM redirect_ZDG WHERE Total < $selectINT LIMIT 1");				  
$row=mysqli_fetch_row($redirectLink);
$linkString = $row[0];
header("refresh:5;url=$linkString");
	
}

// Close connection
mysqli_close($link);

// Add shortcode
add_shortcode( 'contador', 'contador' );



function contador2()
{

/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost:3306", "bn_wordpress", "0461f67d5e", "bitnami_wordpress");
	
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
	
//select limit
$selectURL = mysqli_query($link,"SELECT LinkRedirect FROM redirect_zdg WHERE Total =  ( SELECT MIN(Total) FROM redirect_zdg )");				  
$row=mysqli_fetch_row($selectURL);
$selectLINK = $row[0];

//update total
$contador = "UPDATE redirect_ZDG SET Total = Total + 1 WHERE LinkRedirect = '" . $selectLINK . "'";
if(mysqli_query($link, $contador)){
    echo "
Aguarde 5 segundos para ser redirecionado...";
} else {
    echo "ERROR: Could not able to execute $contador. " . mysqli_error($link);
}
	
//redirect com select
//$redirectLink = mysqli_query($link,"SELECT LinkRedirect FROM redirect_ZDG WHERE Total < $selectINT LIMIT 1");				  
//$row=mysqli_fetch_row($redirectLink);
//$linkString = $row[0];
header("refresh:5;url=$selectLINK");
	
}

// Close connection
mysqli_close($link);

// Add shortcode
add_shortcode( 'contador2', 'contador2' );