| Server IP : 195.130.67.5 / Your IP : 216.73.217.154 Web Server : Microsoft-IIS/10.0 System : Windows NT WEBSERVER1 10.0 build 17763 (Windows Server 2016) i586 User : IUSR ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Old Sites/dastafiles/admin/functions/ |
Upload File : |
<?php
$no_sex_names_d=mysql_query("SELECT * FROM ".DB_PREFIX."registered_students WHERE sex IS NULL OR sex=0");
$i=0;
while($no_sex_names_i=mysql_fetch_array($no_sex_names_d)) {
mysql_query("UPDATE ".DB_PREFIX."registered_students SET sex='".name_to_sex($no_sex_names_i["system_first_name"])."' WHERE id='".$no_sex_names_i["id"]."'");
if(mysql_affected_rows()) $i++;
}
if($i>0) echo'<div class="valid_box">Ενημερώθηκαν <b>'.$i.'</b> φοιτητές.</div>';
else echo'<div class="error_box">Δεν ενημερώθηκε κανένας φοιτητής.</div>';
require_once("manage-registered-students.php");
?>