Eduardo Munizaga's questions

I must send mails to different users with different messages depending on specific parameters. Currently I have the text to send, parameterized in hard, that is, in this way as an example:

$nombre  = $usuario->__GET('Nombre');
$email = $usuario->__GET('Email');  
$informacion= $reportes->__GET('Reporte');  
$texto = "Estimado ".$nombre.", este correo es para informarle qué ".$informacion.";

enviar_mail($nombre ,$email, $texto );

What I want is that the text is not written in the code but in the database with the same parameters (since there are many different ones and they vary over time) to be able to have this type of script:

$nombre = $usuario->__GET('Nombre');
$email = $usuario->__GET('Email ');  
$informacion = $reportes->__GET('Reporte');  
$texto = $reportes->__GET('Texto'); 

enviar_mail($nombre ,$email, $texto );

But the text that appears in the parameter $textoappears with the parameters as a string.

"Estimado ".$nombre.", este correo es para informarle qué ".$informacion.";

I have tried to store it in the database in the following ways:

• "Dear ".$name.", This email is to let you know what ".$information."
• Dear ".$name.", this email is to inform you what ".$information.
• Dear $name, this email is to inform you what $information

I don't know if it's not possible or I'm very lost on how to do this.

Cheers

I am working with a very simple mobile progressive web (the application is very simple and it is not enough to make an app). Correspondingly, this mobile website installs a Service Workers (sw.js) to cache offline elements and their corresponding manifest.json. At the beginning of the Service Workers indicate the following:

var cacheName = 'v1.0.3.0:static';

In what I thought that every time the version value changed as indicated in the Google Developers post , the user would receive the new update, but this does not work. The user keeps his old version without receiving the changes and the only way, so far, is for users to delete the history from their mobile (and in some cases reinstall the PWA).

Is there a way to do this automatically or notify the user (without using push notifications) of new changes? I attach my sw.js in case it is useful for analysis.

var cacheName = 'v1.0.3.0:static';

self.addEventListener('install', function(e) {   
    e.waitUntil(
        caches.open(cacheName).then(function(cache) {
            return cache.addAll([
                'https://www.......com',
                'https://www.......com/js/app.js',
                ....
                ....

            ]).then(function() {
                self.skipWaiting();
            });
        })
    );
});

self.addEventListener('fetch', function(event) {   
    event.respondWith(
        caches.match(event.request).then(function(response) {
            if (response) {              
                return response;
            }          
            return fetch(event.request);
        })
    );
});

What I need to do is give a proper name to localhosta Linux machine (where the Apache server is located with a web system). The idea is that this name can be resolved by all the machines connected to the same Local Network [This is a small intranet]. This, to avoid having to type the IP of the server. Namely; if before you had to type http://192.168.1.100in the browser, now you should be able to type http://sistema.hometo display the system hosted on the machine. Before, I solved it by typing the name of the machine with the .home extension, but many users find it difficult to write http://Ubuntu-Server-HP-154.home(very long and difficult to remember)

For this, the first thing I did was change the /etc/host file, leaving it like this:

127.0.0.1       sistema.home
127.0.1.1       Ubuntu-Server-HP-154.home

And then modify the servername of the /etc/apache2/sites-available/000-default.conf file:

ServerName  sistema.home

Then I realized that this way I could only access locally by typing http://sistema.home(it only resolved if I was browsing on the same server machine) so I also changed the name of my machine to de Ubuntu-Server-HP-154 a sistemaand configured the file /etc/hostname

sistema  

I also made the corresponding changes in /etc/host like this:

127.0.0.1       sistema.home
127.0.1.1       sistema

Network restarts, systemctl restart systemd-hostnamed, Apache, Machine, etc

Well, from another machine I still can't access through http://sistema.home, but I can through the old name of the machine http:// Ubuntu-Server-HP-154.home. What's more, when I do a ping -a 192.168.1.100it still resolves as Ubuntu-Server-HP-154.homeand not assistema.home

So I started to check the configuration with the command hostnameof the server machine:

.$ hostname
sistema 

Perfect, it tells me that the hostname of my machine is called system

.$ hostname -f 
sistema   

Perfect, it tells me that the FQDN (Full Domain Name) is called system

 .$ hostname -A 
 Ubuntu-server-HP-88454154.home Ubuntu-server-HP-88454154.home

What? It tells me that there are more FQDNs on my machine and they are called Ubuntu-Server-HP-154But then: Where are those other FQDNs to delete them? Why is this happening? and then what is the correct way to change the localhost name so that it is available to the rest of the local network?

I have a function that is called by several different functions. It is called directly or, depending on the routine, it is called by a process Process. This function also uses a global variable defined at the beginning of the script. The problem is that when the function is called via a Processglobal variable is no longer defined. I expose an example [Very simplified]:

 #!/usr/bin/python3.5
 from multiprocessing import Process

 def funcion1():

    print(mi_variable)


 def funcionProceso():

    try:

        evaluacion = Process(target=funcion1)
        evaluacion.start()
        evaluacion.join()     

    except Exception as e:
        e = str(e)      
        print(e)     


if __name__ == '__main__':        

    mi_variable = 'Hola'

    ##Al llamar la función obviamente se imprime mi_variable en forma correcta 
    funcion1()

    ##Al llamar la función a través  de la función funcionProceso
    # ocurre el error: NameError: name 'mi_variable' is not defined
    funcionProceso()

In funcion1, I could check if the variable is defined or not and define it in case it is not, but I still have the question since I have no idea why what I expose above happens:

  def funcion1():

     global mi_variable   

      try:
        mi_variable
     except NameError:
        mi_variable = 'Hola'
        print(mi_variable)

     else:

        print(mi_variable)

I need to back up a folder of pdf files on a daily basis. This is a large number of files so I first pack it in Gzipand then delete the old Gzip. To achieve this I have the following code in a file .shwhich is run by a cron every day at 5:00 AM:

#!/bin/sh
#Empaqueto los archivos y lo dejo en la carpeta archivos_empresas
cd /var/www/html/sistema/respaldo/respaldopdf && tar -cpzf $(date +%d%m%Y)-respaldo.tar.gz  /var/www/html/sistema/archivos_empresas

#Luego busco el anterior gz y lo elimino 
find /var/www/html/sistema/respaldo/respaldopdf/*.gz -mtime +0 -exec rm {} \;

All good, but something curious happens: It doesn't always delete the previous file and the worst thing is that I can't find the pattern to foresee it. So every day I have to check if the file was deleted or not to do it manually with an RM since being very heavy it uses a lot of disk space.

Scopes:

1.- This would be solved by keeping the same file name since it would be replaced, but I don't want to do that since, for security reasons, I need the new one to be generated first and if it is generated correctly, delete the old one.

2.- I know that the command -mtime +0should be -mtime +1but that way the file from the day before yesterday deletes it, not the one from yesterday.

What I need is to do a professional backup (this solution I made seems to be kind of amateurish). Thanks for your help.

What I need to do is score the words in a sentence that are closest to a predefined concept. What I have managed to do is exactly that but with only one sentence. I am attaching an example where if the answer phrase contains the word house, it is awarded 4 points, little house 3 and so on. If there are no matches it is zero and if there are more than one they are added.

puntaje = {'casa':4, 'casita':3, 'casona':2, 'hogar':1}
respuesta = ['Esta', 'es', 'mi', 'casa', 'mi', 'hogar']

suma=[]

for k in respuesta:
        if k in puntaje:
              suma.append(puntaje[k])

print sum(suma) 

In this example, it gives me 5 as a result , which is correct since in the sentence there are two matches with the dictionary: House that is worth 4 and Home that is worth 1 . Perfect.

My problem (apart from not knowing much about python) is that I can't do this with a list of multiple phrases (the idea is not to do another cycle, foralthough I couldn't either). I have been trying with compressed lists but I have not been able to find the result.

What I need is to parse a list like this:

respuestas = [['Esta', 'es', 'mi', 'casa', 'mi', 'hogar'], 
['Esta', 'es', 'una', 'casa', 'grande'],
['Esto', 'parece', 'una', 'casona'],
['Esto' 'es' 'un' 'departamento'],
[...etc]]

And the expected result would be the following:

{'Esta es mi casa mi hogar':5,
'Esta es una casa grande':4,
'Esto parece una casona':2,
'Esto es un departamento':0}

I have the following code (simplified example):

$(function () {
    var chart = new Highcharts.Chart({

        chart: {
            renderTo: 'container'
        },

        xAxis: {
            type: 'datetime'
        },
        series: [{
            data: [
                [Date.UTC(2016, 0, 1), 29.9],               
                [Date.UTC(2016, 0, 2), 106.4],               
                [Date.UTC(2016, 0, 3), 75],
                [Date.UTC(2016, 0, 4), 129.2],
                [Date.UTC(2016, 1, 10), 176.0],
                [Date.UTC(2016, 1, 11), 176.0]

             ]
        }],

    });
});

Which gives me the following graph:

As you will see, there is a time gap in which there is no data, obtaining an unattractive result, especially when there are many points at both ends. What I hope to achieve is something like this:

This means that the plotted points only show the dates that exist.

Note: I am using Highcharts-4.2.6

I have a table that is fed data from a JSON. The table is updated every x seconds and when new data arrives the table obviously receives a new row of data. What I'm trying to do is add an effect (fade or slide, or change color for a few seconds) to this first row that just arrived, but I can't figure out how to do it.

In this link there is a table with exactly the same effect that I want (You may have to wait a bit for the effect to occur since it is real-time data)

Here goes my code:

javascript

<script type="text/javascript">
  $(document).ready(function(){
        refreshTable();
    });

 function refreshTable(){
    $.ajax({
        url: "ordenajson.php", 
        type: "POST",
        contentType: "application/x-www-form-urlencoded",
        dataType: "json",  
        success: function(data){                    
            $("#contenido").html('');
            if(data != null && $.isArray(data)){
                $.each(data, function(index, value){
                $("#contenido").append("<tr><td>" + value.camion + "</td><td>" + value.estado + "</td><td>" + value.tespera + "</td><td>" + value.tcarga + "</td><td>" + value.tcarga + "</td></tr>").fadeIn(3000);
                });
            }
             setTimeout(refreshTable, 2000);
        }
    });
}
</script>

HTML

<table  class="rwd-table" width='100%' id="tablajson" >
    <thead>
        <tr>
            <th width='20%'>CAMIÓN</th>
            <th width='20%'>ESTADO</th>
            <th width='20%'>T ESPERA</th>
            <th width='20%'>T CARGA</th>
            <th width='20%'>T TOTAL</th>
        </tr>
    </thead>
<tbody id='contenido'></tbody>
</table>

I am working with a case of a client in which he applies to use the Knapsack Problem algorithm . I am using the attached code, it works more or less and it has bugs.

The example has 12 packages of different weights (which in total weigh 1260 Kilos) with an associated value or price. The goal is to load the maximum number of packages, prioritizing the highest value without exceeding the maximum load of the truck.

For example;

1.- If the maximum load of the truck is 9 Kilos, this code should select Paquete 2 Peso :9 valor :160and not Paquete 2 Peso :9 valor :150(But it does not, it selects zero).

2.- On the other hand, if the maximum load of the truck is 500 Kilos, select the following:

Paquete 9 Peso :230 valor :591
Paquete 3 Peso :153 valor :200
Paquete 4 Peso :50 valor :160
Paquete 2 Peso :9 valor :160
Paquete 1 Peso :9 valor :150

Peso total paquetes: 451
Valor total paquetes: 1261

Does the job but not very well (would be short of 7 and 5 to complete a 493 charge)

3.- If the maximum load of the truck is 230, select the following:

Paquete 9 Peso :9 valor :230 

If it does the job but badly, because the best option would be the following:

Paquetes 1, 2, 4 y 5
Con un peso peso total de 83
y un valor valor total de 530 

Since it is more efficient.

Code :

from itertools import takewhile

#Paquetes: "Nombre del paquete", Kilos, Precio
PAQUETES = (
    ("Paquete 1", 9, 150), ("Paquete 2", 9, 160), ("Paquete 3", 153, 200), ("Paquete 4", 50, 160),
    ("Paquete 5", 15, 60), ("Paquete 6", 66, 45), ("Paquete 7", 27, 60), ("Paquete 8", 39, 40),
    ("Paquete 9", 230, 591), ("Paquete 10", 520, 10), ("Paquete 11", 110, 70), ("Paquete 12", 32, 30))

def proceso_valor(item):
    nombre, peso, valor = item
    return float(valor)

def proceso_peso(item):
    nombre, peso, valor = item
    proceso_peso.peso_maximo -= peso
    return proceso_peso.peso_maximo >= 0    

#carga máxima del camión
proceso_peso.peso_maximo = 750


carga_lista = list(takewhile(proceso_peso, reversed(sorted(PAQUETES, key=proceso_valor))))

sumacarga = 0
sumavalor = 0

for item in carga_lista:
    print item[0] + ' Peso :%i' % item[1] + ' valor :%i' % item[2]
    sumacarga = sumacarga + item[1]
    sumavalor = sumavalor + item[2]

print ''
print 'Peso total paquetes: %i' % sumacarga
print 'Valor total paquetes: %i' % sumavalor

There is something that I am not seeing, I need help and the questions are: What makes my code not work with small maximum load values ​​(9 or 100 for example)? and what mathematical operation is missing here to improve the result?

I am working with Highcharts charts by generating a request jQuery.get()from the chart to the temperature3.php file . For the chart to work properly, the JSON must be in the following format:

[{"item": "minima", "data":[["2015-12-28",8.8],["2015-12-29",10.8],["2015-12-30",15.3]]},
{"item": "maxima", "data":[["2015-12-28",28.7],["2015-12-29",27.5],["2015-12-30",31.1]]}]

The routine (summarized) that I am using to obtain this format is the following:

$minima='{"item": "minima", "data":[';
$maxima='{"item": "maxima", "data":[';

foreach($stm->fetchAll(PDO::FETCH_ASSOC) as $r)
{
    $minima.='["'. $r['fecha'].'",'.$r['minima'].'],';
    $maxima.='["'. $r['fecha'].'",'.$r['maxima'].'],';
}

$minima.=']}';
$maxima.=']}';

$datos = '['.$minima.','.$maxima.']';
$datos= str_replace(",]", "]", $datos); 
echo json_encode($datos,JSON_NUMERIC_CHECK);

The summary table has the following format

id       fecha       maxima  minima  
------  ----------  ------  --------
     1  2015-12-28    28.7       8.8
     2  2015-12-29    27.5      10.8
     3  2015-12-30    31.1      15.3

It is effective but not optimal and less efficient. So I guess there must be some less naive way to do it, either through a multidimensional array of objects or some solution that I haven't been able to see.

In order to celebrate this February 14, it would be good to know how a computer scientist can represent the formula of love.

The first thing is to indicate that this is the formula:

If we clear the we will have the following solutions:

And the task is to represent it in Python.

I'm working with sorting algorithms and wanted to check, just out of curiosity, the old question What is the fastest sorting algorithm?

I made the typical PHP script to get the time an algorithm takes but the result confuses me:

<?PHP

function microtime_float(){

    list($useg, $seg) = explode(" ", microtime());
    return ((float)$useg + (float)$seg);
}

$tiempo_inicio = microtime_float();

/* inicio del algoritmo de ordenación */

/* aqui va el algoritmo a observar*/

/* Fin del algoritmo de ordenación */

$tiempo_fin = microtime_float();
$tiempo = $tiempo_fin - $tiempo_inicio;

echo "Tiempo empleado: " . ($tiempo_fin - $tiempo_inicio);

?>

I did some tests with different sorting methods with a small sequence of numbers. and the results are too different in each test:

For example: the results of the Quick Sort Method: for the same sequence of 5 numbers was the following:

1 2 3 4 5 Tiempo empleado: 4.8160552978516
1 2 3 4 5 Tiempo empleado: 3.0994415283203
1 2 3 4 5 Tiempo empleado: 9.0122222900391
1 2 3 4 5 Tiempo empleado: 5.5074691772461
etc, etc

As this seemed crazy to me, I tried with a sequence of 9999 random numbers and the result was much more stable since the integer was almost always the same and only the decimals changed,

However, the question arises: Is this method of testing performance in PHP professional? Is there any better? Will we always have to take our algorithms to the extreme to test them?

I'm learning pentesting with the book "Violent Python" (highly recommended) and one of the exercises is to generate a script to brute force a ZIP file encrypted with a password.

The script works very well when it comes to ZIP 2.0 (portable) encryption (128-Bit AES and 256-Bit AES algorithms are more secure and take longer to find). The issue is that it not only quickly finds the password when using a dictionary, but also finds more than one valid password and I don't understand it and I need to know why this happens.

The code used is the following:

1. ZIP file encrypted with the password: yoda

2. TXT file with 2300 single words

3. Script used:

   import zipfile
   from threading import Thread
   
   def extractFile(zFile, password):
       try:
           zFile.extractall(pwd=password)
           print '[+] Found password ' + password + '\n'
       except:
           pass
   
   def main():
       zFile = zipfile.ZipFile('archivo.zip')
       passFile = open('passwords.txt')
   
       for line in passFile.readlines():
           password = line.strip('\n')
           t = Thread(target=extractFile, args=(zFile, password))
           t.start()
   
   if __name__ == '__main__':
       main()
   

4. Result

   >>> 
   [+] Found password Carrie
   [+] Found password cocacola
   [+] Found password eagle1
   [+] Found password jean
   [+] Found password panda
   [+] Found password Grover
   [+] Found password cfi
   [+] Found password beautifu
   [+] Found password yoda <- lo puse al final del diccionario 
   >>> 
   

As you can see, it finds more than one password and worst of all, all these passwords work. That is, it is possible to decrypt the ZIP file with any of these passwords.

In order to investigate further, the questions are:

• What algorithm does ZIP use for this encryption?
• How is it possible to decrypt with more than one password?

The problem is the following: I have the host http://www.midominio.clthat through a routine .htaccess, in the public, is redirected to https://www.midominio.clSo far so good. The problem arises that, with the attached routine, it redirects everything including subdomains and additional domains that do not have the SSL certificate. The idea is: Only redirect from http to https , midominio.cland its dependencies and not to consultora.midominio.clor another folder where you have an addon domain. I've also tried including a PHP routine in the subdomain's index header but obviously I get a redirect loop.

Options +FollowSymLinks -MultiViews
# Turn mod_rewrite on
RewriteEngine On

RewriteCond %{HTTPS} off
RewriteCond %{HTTP_HOST} !^midominio\.cl$ [NC]
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]

// hasta aquí funciona la redirección de hhtp a https //

// Las siguientes líneas no funcionan //

RewriteCond %{HTTP_HOST} ^consultora.midominio\.cl [NC]
RewriteRule ^ http://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]

I searched on stackoverflow.com and there is a similar query whose answer didn't work (or I couldn't understand it). [ https://stackoverflow.com/questions/17715724/modrewrite-rewritecond-to-turn-off-ssl-redirect-for-a-certain-requested-url ]

Well, the help is appreciated.

Update.

I was able to prevent the redirect to a subdomain with the following line

RewriteCond %{HTTPS} off
RewriteCond %{HTTP_HOST} !=subdominio.midominio.cl #Nueva línea
RewriteCond %{HTTP_HOST} !^midominio\.cl$ [NC]
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]

But I still can't avoid the redirection to a otrodominio.clparked one.