| Server IP : 64.202.187.69 / Your IP : 216.73.217.74 Web Server : Apache System : Linux 69.187.202.64.host.secureserver.net 3.10.0-1160.144.1.el7.tuxcare.els6.x86_64 #1 SMP Fri May 29 16:22:24 UTC 2026 x86_64 User : transmarket ( 1001) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/transmarket/translator/controllers/ |
Upload File : |
<?php
include 'connection.php';
$sqlSettings1 = 'select id from tbl_translators';
$resultOpenSentence1 = $mysqli->query($sqlSettings1);
if($resultOpenSentence1->num_rows > 0) {
while ($row1 = $resultOpenSentence1->fetch_object()) {
$user_id = $row1->id;
$sqlSettings = 'select GROUP_CONCAT(sentence_id) as ids from tbl_user_suggestion_mapping where user_id = "'.$user_id.'" or FIND_IN_SET("'.$user_id.'",voted_user_id)';
$resultOpenSentence = $mysqli->query($sqlSettings);
if($resultOpenSentence->num_rows > 0) {
while ($row = $resultOpenSentence->fetch_object()) {
$ids = $row->ids.",";
if($row->ids == '')
$ids = "0,";
echo "<br>User id====".$user_id."<br>".$ids;
$sqlUpdateUS = 'UPDATE `tbl_translators` SET voting_sentences = concat(ifnull(voting_sentences,""), "' . $ids . '") where id = ' . $user_id;
$resultUpdateUS = $mysqli->query($sqlUpdateUS);
}
}
}
}?>