/home/gitRepos/CAcert/CAcert-devel/pages/advertising/0.php 27-> $res = mysql_query($query); 28-> if(mysql_num_rows($res) > 0) 30-> $row = mysql_fetch_assoc($res); 33-> mysql_query($query); 41-> $res = mysql_query($query); 42-> if(mysql_num_rows($res) > 0) 44-> $row = mysql_fetch_assoc($res); 47-> mysql_query($query); 72-> $res = mysql_query($query); 73-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/3.php 41-> $res = mysql_query($query); 42-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/15.php 24-> $res = mysql_query($query); 25-> if(mysql_num_rows($res) <= 0) 31-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/account/27.php 19-> $row = mysql_fetch_assoc(mysql_query("select * from `orginfo` where `id`='".intval($_REQUEST['orgid'])."'")); /home/gitRepos/CAcert/CAcert-devel/pages/account/59.php 24->if (mysql_num_rows($res) <= 0) 30->$user = mysql_fetch_assoc($res); 162->if (mysql_num_rows($dres) > 0) { 164-> while ($drow = mysql_fetch_assoc($dres)) 188->if (mysql_num_rows($dres) > 0) { 190-> while ($drow = mysql_fetch_assoc($dres)) 214->if (mysql_num_rows($dres) > 0) { 216-> while ($drow = mysql_fetch_assoc($dres)) 240->if (mysql_num_rows($dres) > 0) { 242-> while ($drow = mysql_fetch_assoc($dres)) 270->if (mysql_num_rows($dres) > 0) { 272-> while ($drow = mysql_fetch_assoc($dres)) 300->if (mysql_num_rows($dres) > 0) { 302-> while ($drow = mysql_fetch_assoc($dres)) 330->if (mysql_num_rows($dres) > 0) { 332-> while ($drow = mysql_fetch_assoc($dres)) 365->if (mysql_num_rows($dres) > 0) { 367-> while ($drow = mysql_fetch_assoc($dres)) /home/gitRepos/CAcert/CAcert-devel/pages/account/35.php 27->$res = mysql_query($query); 28->while($row = mysql_fetch_assoc($res)) 58-> $res1 = mysql_query($query); 59-> while($domain = mysql_fetch_assoc($res1)) 79-> $res2 = mysql_query($query); 80-> while($org = mysql_fetch_assoc($res2)) 82-> $user = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($org['memid'])."'")); /home/gitRepos/CAcert/CAcert-devel/pages/account/33.php 20-> $row = mysql_fetch_assoc(mysql_query($query)); /home/gitRepos/CAcert/CAcert-devel/pages/account/19.php 24-> $res = mysql_query($query); 25-> if(mysql_num_rows($res) <= 0) 32-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/account/41.php 57-> $res = mysql_query($query); 58-> while($row = mysql_fetch_assoc($res)) 60-> $lang = mysql_fetch_assoc(mysql_query("select * from `languages` where `locale`='".mysql_escape_string($row['lang'])."'")); 73-> $res = mysql_query($query); 74-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/34.php 20-> $row = mysql_fetch_assoc(mysql_query($query)); 22-> $org = mysql_fetch_assoc(mysql_query($query)); 24-> $user = mysql_fetch_assoc(mysql_query($query)); /home/gitRepos/CAcert/CAcert-devel/pages/account/28.php 20-> $row = mysql_fetch_assoc(mysql_query($query)); /home/gitRepos/CAcert/CAcert-devel/pages/account/5.php 56-> $res = mysql_query($query); 57-> if(mysql_num_rows($res) <= 0) 64-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/53.php 19-> $town = array_key_exists('town',$_REQUEST)?mysql_escape_string(stripslashes($_REQUEST['town'])):""; 32-> $reg = mysql_fetch_assoc(mysql_query("select * from `regions` where `id`='$regid'")); 41-> $cnt = mysql_fetch_assoc(mysql_query("select * from `countries` where `id`='$ccid'")); 54-> $res = mysql_query($query); 55-> while($row = mysql_fetch_assoc($res)) 62-> $res = mysql_query($query); 63-> while($row = mysql_fetch_assoc($res)) 77-> $start = mysql_num_rows(mysql_query($query)); 80-> $res = mysql_query($query); 81-> while($row = mysql_fetch_assoc($res)) 92-> $rc = mysql_num_rows(mysql_query("select * from `locations` where `regid`='$regid'")); /home/gitRepos/CAcert/CAcert-devel/pages/account/23.php 24-> $res = mysql_query($query); 25-> if(mysql_num_rows($res) <= 0) 31-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/account/6.php 42->$res = mysql_query($query); 43->if(mysql_num_rows($res) <= 0) { 49->$row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/account/18.php 40-> $reso = mysql_query($query); 41-> if(mysql_num_rows($reso) >= 1){ 42-> while($row = mysql_fetch_assoc($reso)){ 109-> $res = mysql_query($query); 110-> if(mysql_num_rows($res) <= 0) 119-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/54.php 22-> $name = array_key_exists('name',$_REQUEST)?mysql_escape_string($_REQUEST['name']):""; 44-> $row = mysql_fetch_assoc(mysql_query($query)); 92-> $row = mysql_fetch_assoc(mysql_query($query)); 128-> $res = mysql_query($query); 129-> $rc = mysql_num_rows($res); 146-> while($row = mysql_fetch_assoc($res)) 172-> $row = mysql_fetch_assoc(mysql_query($query)); 189-> $res = mysql_query($query); 190-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/12.php 52-> $res = mysql_query($query); 53-> if(mysql_num_rows($res) <= 0) 60-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/51.php 22-> $res = mysql_query($query); 23-> if(mysql_num_rows($res) > 0) { ?> 27-> $res = mysql_query($query); 28-> if(mysql_num_rows($res) > 0) /home/gitRepos/CAcert/CAcert-devel/pages/account/58.php 24-> $res = mysql_query($query); 25-> if(mysql_num_rows($res) != 1){ 28-> if ($row = mysql_fetch_assoc($res)){ 34-> $res1 = mysql_query($query);?> 36-> if (mysql_num_rows($res1) <= 0) {?> 48-> while($drow = mysql_fetch_assoc($res1)){?> /home/gitRepos/CAcert/CAcert-devel/pages/account/9.php 30-> $res = mysql_query($query); 31-> if(mysql_num_rows($res) <= 0) 38-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/55.php 34-> $res = mysql_query($query); 35-> if(mysql_num_rows($res) <= 0) 39-> $row = mysql_fetch_assoc($res); 64-> $res = mysql_query($query); 67-> while($row = mysql_fetch_array($res, MYSQL_NUM)) 102-> $res = mysql_query($query); 106-> $row = mysql_fetch_array($res, MYSQL_NUM); /home/gitRepos/CAcert/CAcert-devel/pages/account/43.php 40-> $emailsearch = $email = mysql_real_escape_string(stripslashes($_REQUEST['email'])); 66-> $res = mysql_query($query); 67-> if(mysql_num_rows($res) > 1) { 78-> while($row = mysql_fetch_assoc($res)) 88-> if(mysql_num_rows($res) >= 100) { 97-> 104-> } elseif(mysql_num_rows($res) == 1) { 105-> $row = mysql_fetch_assoc($res); 116-> if(mysql_num_rows($res) <= 0) { 119-> $row = mysql_fetch_assoc($res); 121-> $dres = mysql_query($query); 122-> $drow = mysql_fetch_assoc($dres); 135-> $res = mysql_query("select `to` from `notary` where `id`='".intval($assurance)."' and `deleted` = 0"); 137-> $trow = mysql_fetch_assoc($res); 139-> mysql_query("update `notary` set `deleted`=NOW() where `id`='".intval($assurance)."'"); 406-> if(mysql_num_rows($dres) > 0) { 413-> while($drow = mysql_fetch_assoc($dres)) { 429-> if(mysql_num_rows($dres) > 0) { 436-> while($drow = mysql_fetch_assoc($dres)) { 491-> select * from `users` where `email`='".mysql_real_escape_string(stripslashes($_POST['email']))."' 530-> $dres = mysql_query($query); 531-> $drow = mysql_fetch_assoc($dres); 541-> $dres = mysql_query($query); 542-> if ($drow = mysql_fetch_assoc($dres)) { 549-> $dres = mysql_query($query); 550-> $drow = mysql_fetch_assoc($dres); 629-> $dres = mysql_query($query); 630-> $drow = mysql_fetch_assoc($dres); 647-> $dres = mysql_query($query); 648-> $drow = mysql_fetch_assoc($dres); 658-> $dres = mysql_query($query); 659-> $drow = mysql_fetch_assoc($dres); 669-> $dres = mysql_query($query); 670-> $drow = mysql_fetch_assoc($dres); 695-> $dres = mysql_query($query); 696-> $drow = mysql_fetch_assoc($dres); 712-> $dres = mysql_query($query); 713-> $drow = mysql_fetch_assoc($dres); 722-> $dres = mysql_query($query); 723-> $drow = mysql_fetch_assoc($dres); 732-> $dres = mysql_query($query); 733-> $drow = mysql_fetch_assoc($dres); 758-> $dres = mysql_query($query); 759-> $drow = mysql_fetch_assoc($dres); 774-> $dres = mysql_query($query); 775-> $drow = mysql_fetch_assoc($dres); 784-> $dres = mysql_query($query); 785-> $drow = mysql_fetch_assoc($dres); 812-> $dres = mysql_query($query); 813-> $drow = mysql_fetch_assoc($dres); 830-> $dres = mysql_query($query); 831-> $drow = mysql_fetch_assoc($dres); 841-> $dres = mysql_query($query); 842-> $drow = mysql_fetch_assoc($dres); 852-> $dres = mysql_query($query); 853-> $drow = mysql_fetch_assoc($dres); 880-> $dres = mysql_query($query); 881-> $drow = mysql_fetch_assoc($dres); 898-> $dres = mysql_query($query); 899-> $drow = mysql_fetch_assoc($dres); 909-> $dres = mysql_query($query); 910-> $drow = mysql_fetch_assoc($dres); 920-> $dres = mysql_query($query); 921-> $drow = mysql_fetch_assoc($dres); 988-> $dres = mysql_query($query); 990-> while($drow = mysql_fetch_assoc($dres)) { 991-> $fromuser = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($drow['from'])."'")); 1035-> $dres = mysql_query($query); 1037-> while($drow = mysql_fetch_assoc($dres)) { 1038-> $fromuser = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($drow['to'])."'")); /home/gitRepos/CAcert/CAcert-devel/pages/account/52.php 24-> $res = mysql_query($query); 25-> if(mysql_num_rows($res) > 0) { 26-> $row = mysql_fetch_assoc($res); 30-> $rc2 = mysql_num_rows(mysql_query($query2)); 39-> $notary = mysql_fetch_assoc(mysql_query($query)); 41-> $user = mysql_fetch_assoc(mysql_query($query)); 77-> $res = mysql_query($query); 78-> if(mysql_num_rows($res) > 0) { 86-> $res = mysql_query($query); 87-> if(mysql_num_rows($res) > 0) { 89-> while($row = mysql_fetch_assoc($res)) { 92-> $rc3 = mysql_num_rows(mysql_query($query3)); /home/gitRepos/CAcert/CAcert-devel/pages/account/49.php 22-> $domainsearch = $domain = mysql_escape_string(stripslashes($_POST['domain'])); 33-> $res = mysql_query($query); 34-> if(mysql_num_rows($res) >= 1) { ?> 40-> while($row = mysql_fetch_assoc($res)) 47->= 100) { ?> 53-> 57-> $row = mysql_fetch_assoc($res); 69-> $res = mysql_query($query); 70-> if(mysql_num_rows($res) >= 1) { ?> 76-> while($row = mysql_fetch_assoc($res)) 83->= 100) { ?> 89-> 93-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/account/13.php 20-> $res = mysql_query($query); 21-> $user = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/account/32.php 20-> $row = mysql_fetch_assoc(mysql_query($query)); 35-> $res = mysql_query($query); 36-> while($row = mysql_fetch_assoc($res)) 38-> $user = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($row['memid'])."'")); /home/gitRepos/CAcert/CAcert-devel/pages/account/29.php 20-> $row = mysql_fetch_assoc(mysql_query($query)); 22-> $org = mysql_fetch_assoc(mysql_query($query)); /home/gitRepos/CAcert/CAcert-devel/pages/account/22.php 40-> $reso = mysql_query($query); 41-> if(mysql_num_rows($reso) >= 1){ 42-> while($row = mysql_fetch_assoc($reso)){ 112-> $res = mysql_query($query); 113-> if(mysql_num_rows($res) <= 0) 121-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/2.php 31-> $res = mysql_query($query); 32-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/31.php 20-> $org = mysql_fetch_assoc(mysql_query($query)); /home/gitRepos/CAcert/CAcert-devel/pages/account/57.php 28-> $res = mysql_query($query); 29-> if(mysql_num_rows($res) <= 0) 33-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/account/25.php 57-> $res = mysql_query($query); 58-> while($row = mysql_fetch_assoc($res)) 60-> $r2 = mysql_query("select * from `org` where `orgid`='".intval($row['id'])."'"); 61-> $admincount = mysql_num_rows($r2); 62-> $r2 = mysql_query("select * from `orgdomains` where `orgid`='".intval($row['id'])."'"); 63-> $domcount = mysql_num_rows($r2); /home/gitRepos/CAcert/CAcert-devel/pages/account/56.php 28-> $res = mysql_query($query); 29-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/26.php 20-> $row = mysql_fetch_assoc(mysql_query($query)); 33-> $res = mysql_query($query); 34-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/pages/account/30.php 20-> $row = mysql_fetch_assoc(mysql_query($query)); 22-> $org = mysql_fetch_assoc(mysql_query($query)); /home/gitRepos/CAcert/CAcert-devel/pages/wot/1.php 19-> $res=mysql_fetch_assoc(mysql_query("select sum(acount) as summe from countries")); 32-> $loc = mysql_fetch_assoc(mysql_query("select * from `locations` where `id`='".$locid."'")); 41-> $reg = mysql_fetch_assoc(mysql_query("select * from `regions` where `id`='".$regid."'")); 50-> $cnt = mysql_fetch_assoc(mysql_query("select * from `countries` where `id`='".$ccid."'")); 63-> $res = mysql_query($query); 64-> while($row = mysql_fetch_assoc($res)) 72-> $res = mysql_query($query); 73-> while($row = mysql_fetch_assoc($res)) 81-> $res = mysql_query($query); 82-> while($row = mysql_fetch_assoc($res)) 96-> $list = mysql_query($query); 97-> if(mysql_num_rows($list) > 0) 109-> /home/gitRepos/CAcert/CAcert-devel/pages/wot/10.php 31-> $res = mysql_query($query); 32-> $row = mysql_fetch_assoc($res); 43-> $rank = mysql_num_rows(mysql_query($query)) + 1; 68-> $res = mysql_query($query); 69-> while($row = mysql_fetch_assoc($res)) 71-> $fromuser = mysql_fetch_assoc(mysql_query("select `fname`, `lname` from `users` where `id`='".intval($row['from'])."'")); 118-> $res = mysql_query($query); 119-> while($row = mysql_fetch_assoc($res)) 121-> $fromuser = mysql_fetch_assoc(mysql_query("select `fname`, `lname` from `users` where `id`='".intval($row['to'])."'")); /home/gitRepos/CAcert/CAcert-devel/pages/wot/12.php 68-> $loc = trim(mysql_escape_string($bits['0'])); 69-> $reg = ""; if(array_key_exists('1',$bits)) $reg=trim(mysql_escape_string($bits['1'])); 70-> $ccname = ""; if(array_key_exists('2',$bits)) $ccname=trim(mysql_escape_string($bits['2'])); 76-> $res = mysql_query($query); 77-> if($reg != "" && $ccname == "" && mysql_num_rows($res) <= 0) 83-> $res = mysql_query($query); 85-> if(mysql_num_rows($res) <= 0) 87-> $row = mysql_fetch_assoc($res); 95-> $loc = mysql_fetch_assoc(mysql_query($query)); 111-> $res = mysql_query($query); 120-> $res = mysql_query("select * from `users` where `id`='".intval($_REQUEST['userid'])."' and `listme`='1'"); 23-> if(mysql_num_rows($res) <= 0) 28-> $user = mysql_fetch_array($res); 30-> $points = mysql_num_rows(mysql_query("select sum(`points`) as `total` from `notary` 57-> $res = mysql_query($query); 58-> while($row = mysql_fetch_assoc($res)) 60-> $lang = mysql_fetch_assoc(mysql_query("select * from `languages` where `locale`='".mysql_real_escape_string($row['lang'])."'")); /home/gitRepos/CAcert/CAcert-devel/pages/wot/13.php 24-> $loc = trim(mysql_escape_string($bits['0'])); 25-> $reg = ''; if(array_key_exists('1',$bits)) $reg=trim(mysql_escape_string($bits['1'])); 26-> $ccname = ''; if(array_key_exists('2',$bits)) $ccname=trim(mysql_escape_string($bits['2'])); 31-> $res = mysql_query($query); 32-> if($reg != "" && $ccname == "" && mysql_num_rows($res) <= 0) 38-> $res = mysql_query($query); 40-> if(mysql_num_rows($res) <= 0) 43-> $row = mysql_fetch_assoc($res); 49-> $res = mysql_query($query); 50-> if(mysql_num_rows($res) > 0) 52-> $loc = mysql_fetch_assoc($res); 57-> mysql_query($query); 65-> $res = mysql_query($query); 66-> $loc = mysql_fetch_assoc($res); 68-> $res = mysql_query($query); 69-> $reg = mysql_fetch_assoc($res); 71-> $res = mysql_query($query); 72-> $cc = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/gpg/3.php 21-> $res = mysql_query($query); 22-> if(mysql_num_rows($res) <= 0) 28-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/pages/gpg/2.php 36-> $res = mysql_query($query); 37-> if(mysql_num_rows($res) <= 0) 44-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/CommModule/usbclient.pl 101->my $password="";$password=$1 if($content=~m/mysql_connect\("[^"]+",\s*"\w+",\s*"(\w+)"/); 136->sub mysql_query($) /home/gitRepos/CAcert/CAcert-devel/CommModule/client.pl 71->$password=$1 if($content=~m/mysql_connect\s*\("[^"]+",\s*"\w+",\s*"(\w+)"/); 136->sub mysql_query($) /home/gitRepos/CAcert/CAcert-devel/stamp/report.php 18-> $arr = explode("//", mysql_real_escape_string(trim($_SESSION['_stamp']['ref'])), 2); 22-> $refer = mysql_real_escape_string(strip_tags(trim($_SESSION['_stamp']['ref']))); 55-> $IP = mysql_real_escape_string(trim($_SERVER['REMOTE_ADDR'])); 57-> mysql_query("insert into `abusereports` set `when`=NOW(), `IP`='$iplong', `url`='$refer', `name`='$name', `email`='$email', 59-> $id = mysql_insert_id(); /home/gitRepos/CAcert/CAcert-devel/stamp/common.php 23-> return(mysql_real_escape_string(strip_tags(trim($_REQUEST[$key])))); 34-> $res = mysql_query($query); 35-> if(mysql_num_rows($res) > 0) 37-> $row = mysql_fetch_assoc($res); 49-> $res = mysql_query($query); 50-> if(mysql_num_rows($res) > 0) 55-> mysql_query($query); 71-> $res = mysql_query($query); 72-> if(mysql_num_rows($res) <= 0) 91-> $res = mysql_query($query); 92-> if(mysql_num_rows($res) <= 0) 104-> $res = mysql_query($query); 105-> if(mysql_num_rows($res) <= 0) 116-> $cert = mysql_fetch_assoc($res); 121-> $user = mysql_fetch_assoc(mysql_query($query)); 124-> $orgi = mysql_fetch_assoc(mysql_query($query)); 137-> mysql_query($query); 139-> mysql_query("update `stampcache` set `cacheexpire`='".(date("U")+600)."' where `id`='$stampid'"); 142-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/stamp/certdet.php 22-> $arr = explode("//", mysql_real_escape_string(trim($_REQUEST['refer'])), 2); 26-> $arr = explode("//", mysql_real_escape_string(trim($_SERVER['HTTP_REFERER'])), 2); /home/gitRepos/CAcert/CAcert-devel/stamp/displogo.php 19-> $arr = explode("//", mysql_real_escape_string(trim($_REQUEST['refer'])), 2); 23-> $arr = explode("//", mysql_real_escape_string(trim($_SERVER['HTTP_REFERER'])), 2); /home/gitRepos/CAcert/CAcert-devel/includes/lib/general.php 35-> `serial`='".mysql_escape_string($serial)."' and 37-> `Cert_Text`='".mysql_escape_string($issuer_cn)."') and 40-> $res = mysql_query($query); 41-> if(mysql_num_rows($res) > 0) 43-> $row = mysql_fetch_assoc($res); 142-> $query = mysql_query('SELECT * FROM `cats_passed` AS `tp`, `cats_variant` AS `cv` '. 144-> if(mysql_num_rows($query) < 1) 149-> $query = mysql_query('SELECT SUM(`points`) AS `points` FROM `notary` AS `n` WHERE `n`.`to` = \''.(int)intval($userID).'\' AND `n`.`expire` < now() and `deleted` = 0'); 150-> $row = mysql_fetch_assoc($query); 155-> $query = mysql_query('SELECT `assurer_blocked` FROM `users` WHERE `id` = \''.(int)intval($userID).'\''); 156-> $row = mysql_fetch_assoc($query); /home/gitRepos/CAcert/CAcert-devel/includes/lib/l10n.php 173-> // mysql_real_escape() or escapeshellarg(), but take care of 363-> $res = mysql_query($query); 364-> if (mysql_num_rows($res)>=0) { 365-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/includes/lib/account.php 58-> $query = mysql_query($sql); 94-> $query = mysql_query($sql); /home/gitRepos/CAcert/CAcert-devel/includes/general_stuff.php 72-> $res = mysql_query($query); 73-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/includes/loggedin.php 47-> $_SESSION['profile'] = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($uid)."'")); 73-> $_SESSION['profile'] = mysql_fetch_assoc(mysql_query( 106-> $res = mysql_query($query); 107-> $row = mysql_fetch_assoc($res); 114-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/includes/mysql.php.sample 19-> $_SESSION['mconn'] = mysql_connect("127.0.0.1", "username", "password"); 22-> mysql_select_db("database"); /home/gitRepos/CAcert/CAcert-devel/includes/notary.inc.php 24-> return mysql_query($query); 29-> $row1 = mysql_fetch_assoc($res); 35-> return intval(mysql_num_rows($resultset)); 128-> return mysql_fetch_assoc($res); 136-> return mysql_num_rows($res); 590-> while($row = mysql_fetch_assoc($res)) 620-> while($row = mysql_fetch_assoc($res)) 664-> while($row = mysql_fetch_assoc($res)) 677-> while($row = mysql_fetch_assoc($res)) 863-> ",`document`='".mysql_real_escape_string($document)."',`date`=NOW(), `active`=".intval($active).",`method`='".mysql_real_escape_string($method)."',`comment`='".mysql_real_escape_string($comment)."'" ; 864-> $res = mysql_query($query); 876-> WHERE u.`document` = '" . mysql_real_escape_string($type) . "' AND u.`memid`=" . intval($memid) ; 877-> $res = mysql_query($query); 878-> if(mysql_num_rows($res) <=0){ 900-> $filter .= " AND u.`document` = '".mysql_real_escape_string($type)."'"; 911-> $res = mysql_query($query); 912-> if(mysql_num_rows($res) >0){ 913-> $rec = mysql_fetch_assoc($res); 935-> $filter .= " AND u.`document` = '".mysql_real_escape_string($type)."'"; 946-> $res = mysql_query($query); 947-> if(mysql_num_rows($res) >0){ 948-> $rec = mysql_fetch_assoc($res); 969-> $filter .= " AND u.`document` = '".mysql_real_escape_string($type)."'"; 980-> return mysql_query($query); 994-> $filter = " and `document` = '" . mysql_real_escape_string($type) . "'"; 996-> mysql_query("delete from `user_agreements` where `memid`=" . intval($memid) . $filter ); 1098-> mysql_query($query); 1109-> mysql_query( 1120-> $arbno = mysql_real_escape_string($arbno); 1131-> mysql_query("update `users` set `password`=sha1('".$password."') where `id`='".$id."'"); 1135-> mysql_query($query); 1136-> $emailid = mysql_insert_id(); 1140-> mysql_query($query); 1144-> $res=mysql_query($query); 1145-> while($row = mysql_fetch_assoc($res)){ 1151-> $res=mysql_query($query); 1152-> while($row = mysql_fetch_assoc($res)){ 1157-> mysql_query( 1167-> mysql_query($query); 1171-> mysql_query($query); 1175-> mysql_query("update `users` set `language`='en_AU' where `id`='".$id."'"); 1177-> mysql_query("delete from `addlang` where `userid`='".$id."'"); 1189-> mysql_query($query); 1199-> mysql_query($query); 1202-> mysql_query( 1217-> mysql_query("update `users` set `locked`='1' where `id`='$id'"); //, `deleted`=Now() 1224-> $email = mysql_real_escape_string($email); 1226-> $res = mysql_query($query); 1227-> return mysql_num_rows($res) > 0; 1239-> $res = mysql_query($query); 1240-> return mysql_num_rows($res) > 0; 1254-> $res = mysql_query($query1); 1255-> $r1 = mysql_num_rows($res)>0; 1256-> $res = mysql_query($query2); 1257-> $r2 = mysql_num_rows($res)>0; 1290-> $res = mysql_query($query1); 1291-> $r1 = mysql_num_rows($res)>0; 1292-> $res = mysql_query($query2); 1293-> $r2 = mysql_num_rows($res)>0; 1301-> $res = mysql_query($query); 1302-> return mysql_num_rows($res) > 0; 1314-> $dres = mysql_query($query); 1315-> while($drow = mysql_fetch_assoc($dres)){ 1316-> mysql_query("update `emailcerts` set `revoked`='1970-01-01 10:00:01', `disablelogin`=1 where `id`='".$drow['id']."'"); 1332-> $dres = mysql_query($query); 1333-> while($drow = mysql_fetch_assoc($dres)) 1335-> mysql_query( 1348-> $res=mysql_query($query); 1349-> while($row = mysql_fetch_assoc($res)){ 1355-> $res=mysql_query($query); 1356-> while($row = mysql_fetch_assoc($res)){ 1418-> $type = mysql_real_escape_string($type); 1419-> $info = mysql_real_escape_string($info); 1422-> return mysql_query($query); 1456-> return mysql_query($query); 1465-> return mysql_fetch_assoc(mysql_query("select * from `alerts` where `memid`='".intval($userid)."'")); 1483-> $filter .= " and `email`!='".mysql_real_escape_string($exclude)."'"; 1486-> return mysql_query($query); 1503-> return mysql_query($query); 1518-> return mysql_query($query); 1532-> return mysql_query($query); 1563-> return mysql_query($query); 1593-> return mysql_query($query); 1614-> return mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/includes/account_stuff.php 209-> 0 || $_SESSION['profile']['orgadmin'] == 1) { ?> 219-> 0 || $_SESSION['profile']['orgadmin'] == 1) { ?> /home/gitRepos/CAcert/CAcert-devel/includes/general.php 82-> $locked = mysql_fetch_assoc(mysql_query("select `locked` from `users` where `id`='".intval($_SESSION['profile']['id'])."'")); 86-> $res = mysql_query($query); 87-> $row = mysql_fetch_assoc($res); 289-> $dom = mysql_real_escape_string($dom); 291-> $res = mysql_query($query); 292-> if(mysql_num_rows($res) > 0) 295-> $_SESSION['_config']['row'] = mysql_fetch_assoc($res); 347-> $dom = mysql_real_escape_string($dom); 349-> $res = mysql_query($query); 350-> if(mysql_num_rows($res) > 0) 353-> $_SESSION['_config']['altrow'] = mysql_fetch_assoc($res); 391-> $dom = mysql_real_escape_string($dom); 397-> $res = mysql_query($query); 398-> if(mysql_num_rows($res) > 0) 400-> $_SESSION['_config']['row'] = mysql_fetch_assoc($res); 443-> $dom = mysql_real_escape_string($dom); 449-> $res = mysql_query($query); 450-> if(mysql_num_rows($res) > 0) 452-> $_SESSION['_config']['altrow'] = mysql_fetch_assoc($res); 479-> $dom = mysql_real_escape_string($dom); 485-> $res = mysql_query($query); 486-> if(mysql_num_rows($res) > 0) 488-> $_SESSION['_config']['row'] = mysql_fetch_assoc($res); 501-> $row = mysql_fetch_assoc(mysql_query($query)); 506-> if(mysql_num_rows(mysql_query($query)) < 1) 557-> $myemail = mysql_real_escape_string($email); 667-> $line = mysql_real_escape_string(trim(strip_tags($line))); 670-> mysql_query($query); 681-> mysql_query($query); 702-> $res = mysql_query($query); 703-> if(mysql_num_rows($res) > 0) 715-> $res = mysql_query($query); 718-> if(mysql_num_rows($res) > 0) 745-> mysql_query($query); 746-> $ticket = mysql_insert_id(); 874-> * The resource returned by mysql_query is 877-> * It should be safe to replace every mysql_query 878-> * call by a mysql_extended_query call. 880-> function mysql_timed_query($sql) 884-> $res = mysql_query($sql); /home/gitRepos/CAcert/CAcert-devel/includes/account.php 123-> if(trim(mysql_real_escape_string(stripslashes($_REQUEST['newemail']))) == "") 131-> $_REQUEST['email'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['newemail']))); 155-> mysql_query($query); 156-> $emailid = mysql_insert_id(); 175-> $res = mysql_query($query); 176-> if(mysql_num_rows($res) <= 0) 183-> $row = mysql_fetch_assoc($res); 194-> $query = "update `users` set `email`='".mysql_real_escape_string($row['email'])."' where `id`='".intval($_SESSION['profile']['id'])."'"; 195-> mysql_query($query); 219-> `email`!='".mysql_real_escape_string($_SESSION['profile']['email'])."'"; 220-> $res = mysql_query($query); 221-> if(mysql_num_rows($res) > 0) 223-> $row = mysql_fetch_assoc($res); 329-> $res = mysql_query("select * from `email` where `memid`='".intval($_SESSION['profile']['id'])."' and `id`='".intval($id)."'"); 330-> if(mysql_num_rows($res) > 0) 332-> $row = mysql_fetch_assoc($res); 348-> $user = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($_SESSION['profile']['id'])."'")); 392-> `md`='".mysql_real_escape_string($_SESSION['_config']['hash_alg'])."', 393-> `description`='".mysql_real_escape_string($_SESSION['_config']['description'])."'"; 394-> mysql_query($query); 395-> $emailid = mysql_insert_id(); 398-> mysql_query("insert into `emaillink` set `emailcertsid`='$emailid', `emailid`='$addy'"); 414-> mysql_query("update `emailcerts` set `csr_name`='$CSRname' where `id`='".intval($emailid)."'"); 437-> $user = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($_SESSION['profile']['id'])."'")); 453-> $res = mysql_query("select * from `email` where `memid`='".intval($_SESSION['profile']['id'])."' and `id`='".intval($id)."'"); 454-> if(mysql_num_rows($res) > 0) 456-> $row = mysql_fetch_assoc($res); 493-> `subject`='".mysql_real_escape_string($csrsubject)."', 497-> `md`='".mysql_real_escape_string($_SESSION['_config']['hash_alg'])."', 498-> `description`='".mysql_real_escape_string($_SESSION['_config']['description'])."'"; 499-> mysql_query($query); 500-> $emailid = mysql_insert_id(); 503-> mysql_query("insert into `emaillink` set `emailcertsid`='$emailid', `emailid`='".mysql_real_escape_string($addy)."'"); 508-> mysql_query("update `emailcerts` set `csr_name`='$CSRname' where `id`='$emailid'"); 512-> $res = mysql_query($query); 513-> if(mysql_num_rows($res) <= 0) 550-> $newdomain = mysql_real_escape_string(trim($newdomain)); 552-> $res1 = mysql_query("select * from `orgdomains` where `domain`='$newdomain'"); 554-> $res2 = mysql_query($query); 555-> if(mysql_num_rows($res1) > 0 || mysql_num_rows($res2)) 582-> $addy[] = trim(mysql_real_escape_string(stripslashes($line))); 600-> $addy[] = trim(mysql_real_escape_string(stripslashes($line))); 609-> $_SESSION['_config']['domain'] = mysql_real_escape_string($newdomain); 618-> $authaddy = trim(mysql_real_escape_string(stripslashes($_REQUEST['authaddy']))); 636-> $query = "select * from `domains` where `domain`='".mysql_real_escape_string($_SESSION['_config']['domain'])."' and `deleted`=0"; 637-> $res = mysql_query($query); 638-> if(mysql_num_rows($res) > 0) 662-> $query = "insert into `domains` set `domain`='".mysql_real_escape_string($_SESSION['_config']['domain'])."', 664-> mysql_query($query); 665-> $domainid = mysql_insert_id(); 692-> $res = mysql_query($query); 693-> if(mysql_num_rows($res) > 0) 695-> $row = mysql_fetch_assoc($res); 813-> `CN`='".mysql_real_escape_string($_SESSION['_config']['rows']['0'])."', 814-> `domid`='".mysql_real_escape_string($_SESSION['_config']['rowid']['0'])."', 815-> `created`=NOW(),`subject`='".mysql_real_escape_string($subject)."', 816-> `rootcert`='".mysql_real_escape_string($_SESSION['_config']['rootcert'])."', 817-> `md`='".mysql_real_escape_string($_SESSION['_config']['hash_alg'])."', 818-> `description`='".mysql_real_escape_string($_SESSION['_config']['description'])."'"; 821-> `CN`='".mysql_real_escape_string($_SESSION['_config']['altrows']['0'])."', 822-> `domid`='".mysql_real_escape_string($_SESSION['_config']['altid']['0'])."', 823-> `created`=NOW(),`subject`='".mysql_real_escape_string($subject)."', 824-> `rootcert`='".mysql_real_escape_string($_SESSION['_config']['rootcert'])."', 825-> `md`='".mysql_real_escape_string($_SESSION['_config']['hash_alg'])."', 826-> `description`='".mysql_real_escape_string($_SESSION['_config']['description'])."'"; 834-> mysql_query($query); 835-> $CSRid = mysql_insert_id(); 839-> mysql_query("insert into `domlink` set `certid`='$CSRid', `domid`='$dom'"); 842-> mysql_query("insert into `domlink` set `certid`='$CSRid', `domid`='$dom'"); 847-> mysql_query("update `domaincerts` set `CSR_name`='$CSRname' where `id`='$CSRid'"); 850-> $res = mysql_query($query); 851-> if(mysql_num_rows($res) <= 0) 881-> $res = mysql_query($query); 882-> if(mysql_num_rows($res) <= 0) 888-> $row = mysql_fetch_assoc($res); 897-> mysql_query("update `domaincerts` set `renewed`='1' where `id`='$id'"); 900-> `CN`='".mysql_real_escape_string($row['CN'])."', 901-> `subject`='".mysql_real_escape_string($row['subject'])."',". 903-> "`created`='".mysql_real_escape_string($row['created'])."', 907-> `pkhash`='".mysql_real_escape_string($row['pkhash'])."', 908-> `description`='".mysql_real_escape_string($row['description'])."'"; 909-> mysql_query($query); 910-> $newid = mysql_insert_id(); 932-> $subject = mysql_real_escape_string($subject); 933-> mysql_query("update `domaincerts` set `subject`='$subject',`csr_name`='$newfile' where `id`='$newid'"); 938-> $res = mysql_query($query); 939-> if(mysql_num_rows($res) <= 0) 943-> $drow = mysql_fetch_assoc($res); 974-> $res = mysql_query($query); 975-> if(mysql_num_rows($res) <= 0) 980-> $row = mysql_fetch_assoc($res); 986-> mysql_query("update `domaincerts` set `revoked`='1970-01-01 10:00:01' where `id`='$id'"); 1009-> $res = mysql_query($query); 1010-> if(mysql_num_rows($res) <= 0) 1015-> $row = mysql_fetch_assoc($res); 1021-> mysql_query("delete from `domaincerts` where `id`='$id'"); 1039-> $comment=trim(mysql_real_escape_string(stripslashes($_REQUEST['comment_'.$cid]))); 1040-> mysql_query("update `domaincerts` set `description`='$comment' where `id`='$cid'"); 1060-> $res = mysql_query($query); 1061-> if(mysql_num_rows($res) <= 0) 1067-> $row = mysql_fetch_assoc($res); 1076-> mysql_query("update `emailcerts` set `renewed`='1' where `id`='$id'"); 1079-> `CN`='".mysql_real_escape_string($row['CN'])."', 1080-> `subject`='".mysql_real_escape_string($row['subject'])."', 1081-> `keytype`='".mysql_real_escape_string($row['keytype'])."', 1082-> `csr_name`='".mysql_real_escape_string($row['csr_name'])."', 1083-> `created`='".mysql_real_escape_string($row['created'])."', 1088-> `description`='".mysql_real_escape_string($row['description'])."'"; 1089-> mysql_query($query); 1090-> $newid = mysql_insert_id(); 1093-> mysql_query("update `emailcerts` set `csr_name`='$newfile' where `id`='$newid'"); 1094-> $res = mysql_query("select * from `emaillink` where `emailcertsid`='".$row['id']."'"); 1095-> while($r2 = mysql_fetch_assoc($res)) 1097-> mysql_query("insert into `emaillink` set `emailid`='".$r2['emailid']."', 1102-> $res = mysql_query($query); 1103-> if(mysql_num_rows($res) <= 0) 1134-> $res = mysql_query($query); 1135-> if(mysql_num_rows($res) <= 0) 1140-> $row = mysql_fetch_assoc($res); 1146-> mysql_query("update `emailcerts` set `revoked`='1970-01-01 10:00:01' where `id`='$id'"); 1166-> $res = mysql_query($query); 1167-> if(mysql_num_rows($res) <= 0) 1172-> $row = mysql_fetch_assoc($res); 1178-> mysql_query("delete from `emailcerts` where `id`='$id'"); 1197-> mysql_query("update `emailcerts` set `disablelogin`='$dis' where `id`='$cid' and `memid`='".intval($_SESSION['profile']['id'])."'"); 1203-> $comment=trim(mysql_real_escape_string(stripslashes($_REQUEST['comment_'.$cid]))); 1204-> mysql_query("update `emailcerts` set `description`='$comment' where `id`='$cid' and `memid`='".intval($_SESSION['profile']['id'])."'"); 1218-> $_SESSION['_config']['user']['Q1'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['Q1'])))); 1219-> $_SESSION['_config']['user']['Q2'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['Q2'])))); 1220-> $_SESSION['_config']['user']['Q3'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['Q3'])))); 1221-> $_SESSION['_config']['user']['Q4'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['Q4'])))); 1222-> $_SESSION['_config']['user']['Q5'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['Q5'])))); 1223-> $_SESSION['_config']['user']['A1'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['A1'])))); 1224-> $_SESSION['_config']['user']['A2'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['A2'])))); 1225-> $_SESSION['_config']['user']['A3'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['A3'])))); 1226-> $_SESSION['_config']['user']['A4'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['A4'])))); 1227-> $_SESSION['_config']['user']['A5'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['A5'])))); 1279-> $ddres = mysql_query($ddquery); 1280-> $ddrow = mysql_fetch_assoc($ddres); 1285-> $_SESSION['_config']['user']['fname'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['fname'])))); 1286-> $_SESSION['_config']['user']['mname'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['mname'])))); 1287-> $_SESSION['_config']['user']['lname'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['lname'])))); 1288-> $_SESSION['_config']['user']['suffix'] = trim(mysql_real_escape_string(stripslashes(strip_tags($_REQUEST['suffix'])))); 1319-> mysql_query($query); 1333-> mysql_query($query); 1337-> $_SESSION['profile'] = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($_SESSION['profile']['id'])."'")); 1341-> $ddres = mysql_query($ddquery); 1342-> $ddrow = mysql_fetch_assoc($ddres); 1355-> $_SESSION['_config']['user']['oldpass'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['oldpassword']))); 1356-> $_SESSION['_config']['user']['pword1'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['pword1']))); 1357-> $_SESSION['_config']['user']['pword2'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['pword2']))); 1374-> $match = mysql_query("select * from `users` where `id`='".intval($_SESSION['profile']['id'])."' and 1377-> $rc = mysql_num_rows($match); 1395-> mysql_query("update `users` set `password`=sha1('".$_SESSION['_config']['user']['pword1']."') 1420-> $val = mysql_real_escape_string(stripslashes(trim($val))); 1437-> $_SESSION['_config']['name'] = mysql_real_escape_string(stripslashes(trim($_REQUEST['name']))); 1507-> $emails .= "organizationalUnitName = ".mysql_real_escape_string($_SESSION['_config']['OU'])."\n"; 1532-> `ou`='".mysql_real_escape_string($_SESSION['_config']['OU'])."', 1538-> `md`='".mysql_real_escape_string($_SESSION['_config']['hash_alg'])."', 1539-> `description`='".mysql_real_escape_string($_SESSION['_config']['description'])."'"; 1540-> mysql_query($query); 1541-> $emailid = mysql_insert_id(); 1544-> mysql_query("insert into `domemaillink` set `emailcertsid`='$emailid', `emailid`='$addy'"); 1561-> mysql_query("update `orgemailcerts` set `csr_name`='$CSRname' where `id`='$emailid'"); 1632-> `ou`='".mysql_real_escape_string($_SESSION['_config']['OU'])."', 1636-> `subject`='".mysql_real_escape_string($csrsubject)."', 1639-> `md`='".mysql_real_escape_string($_SESSION['_config']['hash_alg'])."', 1640-> `description`='".mysql_real_escape_string($_SESSION['_config']['description'])."'"; 1641-> mysql_query($query); 1642-> $emailid = mysql_insert_id(); 1645-> mysql_query("insert into `domemaillink` set `emailcertsid`='$emailid', `emailid`='$addy'"); 1651-> mysql_query("update `orgemailcerts` set `csr_name`='$CSRname' where `id`='$emailid'"); 1655-> $res = mysql_query($query); 1656-> if(mysql_num_rows($res) <= 0) 1684-> $res = mysql_query($query); 1685-> if(mysql_num_rows($res) <= 0) 1691-> $row = mysql_fetch_assoc($res); 1700-> mysql_query("update `orgemailcerts` set `renewed`='1' where `id`='$id'"); 1708-> `CN`='".mysql_real_escape_string($row['CN'])."', 1709-> `ou`='".mysql_real_escape_string($row['ou'])."', 1710-> `subject`='".mysql_real_escape_string($row['subject'])."', 1711-> `keytype`='".mysql_real_escape_string($row['keytype'])."', 1712-> `csr_name`='".mysql_real_escape_string($row['csr_name'])."', 1713-> `created`='".mysql_real_escape_string($row['created'])."', 1717-> `description`='".mysql_real_escape_string($row['description'])."'"; 1718-> mysql_query($query); 1719-> $newid = mysql_insert_id(); 1722-> mysql_query("update `orgemailcerts` set `csr_name`='$newfile' where `id`='$newid'"); 1725-> $res = mysql_query($query); 1726-> if(mysql_num_rows($res) > 0) 1757-> $res = mysql_query($query); 1758-> if(mysql_num_rows($res) <= 0) 1763-> $row = mysql_fetch_assoc($res); 1769-> mysql_query("update `orgemailcerts` set `revoked`='1970-01-01 10:00:01' where `id`='$id'"); 1790-> $res = mysql_query($query); 1791-> if(mysql_num_rows($res) <= 0) 1796-> $row = mysql_fetch_assoc($res); 1802-> mysql_query("delete from `orgemailcerts` where `id`='$id'"); 1820-> $comment=trim(mysql_real_escape_string(stripslashes($_REQUEST['comment_'.$cid]))); 1821-> mysql_query("update `orgemailcerts` set `description`='$comment' where `id`='$cid'"); 1882-> `orgdomains`.`domain`='".mysql_real_escape_string($_SESSION['_config']['0.CN'])."'"; 1883-> $_SESSION['_config']['CNorg'] = mysql_fetch_assoc(mysql_query($query)); 1888-> `orgdomains`.`domain`='".mysql_real_escape_string($_SESSION['_config']['0.subjectAltName'])."'"; 1889-> $_SESSION['_config']['SANorg'] = mysql_fetch_assoc(mysql_query($query)); 1949-> $org = mysql_fetch_assoc(mysql_query($query)); 1975-> `CN`='".mysql_real_escape_string($_SESSION['_config']['rows']['0'])."', 1978-> `subject`='".mysql_real_escape_string($csrsubject)."', 1980-> `md`='".mysql_real_escape_string($_SESSION['_config']['hash_alg'])."', 1982-> `description`='".mysql_real_escape_string($_SESSION['_config']['description'])."'"; 1985-> `CN`='".mysql_real_escape_string($_SESSION['_config']['altrows']['0'])."', 1988-> `subject`='".mysql_real_escape_string($csrsubject)."', 1990-> `md`='".mysql_real_escape_string($_SESSION['_config']['hash_alg'])."', 1992-> `description`='".mysql_real_escape_string($_SESSION['_config']['description'])."'"; 1994-> mysql_query($query); 1995-> $CSRid = mysql_insert_id(); 2000-> mysql_query("update `orgdomaincerts` set `CSR_name`='$CSRname' where `id`='$CSRid'"); 2003-> mysql_query("insert into `orgdomlink` set `orgdomid`='".intval($id)."', `orgcertid`='$CSRid'"); 2006-> mysql_query("insert into `orgdomlink` set `orgdomid`='".intval($id)."', `orgcertid`='$CSRid'"); 2009-> $res = mysql_query($query); 2010-> if(mysql_num_rows($res) <= 0) 2038-> $res = mysql_query($query); 2039-> if(mysql_num_rows($res) <= 0) 2045-> $row = mysql_fetch_assoc($res); 2054-> mysql_query("update `orgdomaincerts` set `renewed`='1' where `id`='$id'"); 2062-> `CN`='".mysql_real_escape_string($row['CN'])."', 2063-> `csr_name`='".mysql_real_escape_string($row['csr_name'])."', 2064-> `created`='".mysql_real_escape_string($row['created'])."', 2066-> `subject`='".mysql_real_escape_string($row['subject'])."', 2069-> `description`='".mysql_real_escape_string($row['description'])."'"; 2070-> mysql_query($query); 2071-> $newid = mysql_insert_id(); 2075-> mysql_query("update `orgdomaincerts` set `csr_name`='$newfile' where `id`='$newid'"); 2077-> $res = mysql_query("select * from `orgdomlink` where `orgcertid`='".$row['id']."'"); 2078-> while($r2 = mysql_fetch_assoc($res)) 2079-> mysql_query("insert into `orgdomlink` set `orgdomid`='".intval($r2['orgdomid'])."', `orgcertid`='$newid'"); 2082-> $res = mysql_query($query); 2083-> if(mysql_num_rows($res) <= 0) 2087-> $drow = mysql_fetch_assoc($res); 2117-> $res = mysql_query($query); 2118-> if(mysql_num_rows($res) <= 0) 2123-> $row = mysql_fetch_assoc($res); 2129-> mysql_query("update `orgdomaincerts` set `revoked`='1970-01-01 10:00:01' where `id`='$id'"); 2152-> $res = mysql_query($query); 2153-> if(mysql_num_rows($res) <= 0) 2158-> $row = mysql_fetch_assoc($res); 2164-> mysql_query("delete from `orgdomaincerts` where `id`='$id'"); 2182-> $comment=trim(mysql_real_escape_string(stripslashes($_REQUEST['comment_'.$cid]))); 2183-> mysql_query("update `orgdomaincerts` set `description`='$comment' where `id`='$cid'"); 2222-> $_SESSION['_config']['O'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['O']))); 2223-> $_SESSION['_config']['contact'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['contact']))); 2224-> $_SESSION['_config']['L'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['L']))); 2225-> $_SESSION['_config']['ST'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['ST']))); 2226-> $_SESSION['_config']['C'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['C']))); 2227-> $_SESSION['_config']['comments'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['comments']))); 2233-> mysql_query("insert into `orginfo` set `O`='".$_SESSION['_config']['O']."', 2250-> $_SESSION['_config']['O'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['O']))); 2251-> $_SESSION['_config']['contact'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['contact']))); 2252-> $_SESSION['_config']['L'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['L']))); 2253-> $_SESSION['_config']['ST'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['ST']))); 2254-> $_SESSION['_config']['C'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['C']))); 2255-> $_SESSION['_config']['comments'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['comments']))); 2261-> mysql_query("update `orginfo` set `O`='".$_SESSION['_config']['O']."', 2277-> $domain = $_SESSION['_config']['domain'] = trim(mysql_real_escape_string(stripslashes($_REQUEST['domainname']))); 2278-> $res1 = mysql_query("select * from `orgdomains` where `domain`='$domain'"); 2279-> if(mysql_num_rows($res1) > 0) 2295-> mysql_query("insert into `orgdomains` set `orgid`='".intval($_SESSION['_config']['orgid'])."', `domain`='$domain'"); 2305-> $domain = mysql_real_escape_string(stripslashes(trim($_REQUEST['domainname']))); 2307-> $res1 = mysql_query("select * from `orgdomains` where `domain` like '$domain' and `id`!='".intval($domid)."'"); 2308-> $res2 = mysql_query("select * from `domains` where `domain` like '$domain' and `deleted`=0"); 2309-> if(mysql_num_rows($res1) > 0 || mysql_num_rows($res2) > 0) 2323-> $res = mysql_query($query); 2324-> while($row = mysql_fetch_assoc($res)) 2325-> mysql_query("update `orgdomaincerts` set `revoked`='1970-01-01 10:00:01' where `id`='".$row['id']."'"); 2331-> $res = mysql_query($query); 2332-> while($row = mysql_fetch_assoc($res)) 2333-> mysql_query("update `orgemailcerts` set `revoked`='1970-01-01 10:00:01' where `id`='".intval($row['id'])."'"); 2338-> $row = mysql_fetch_assoc(mysql_query("select * from `orgdomains` where `id`='".intval($domid)."'")); 2339-> mysql_query("update `orgdomains` set `domain`='$domain' where `id`='".intval($domid)."'"); 2349-> $row = mysql_fetch_assoc(mysql_query("select * from `orgdomains` where `id`='".intval($domid)."'")); 2351-> mysql_query("delete from `orgdomains` where `id`='".intval($domid)."'"); 2368-> $dres = mysql_query($query); 2369-> while($drow = mysql_fetch_assoc($dres)) 2375-> $res = mysql_query($query); 2376-> while($row = mysql_fetch_assoc($res)) 2378-> mysql_query("update `orgdomaincerts` set `revoked`='1970-01-01 10:00:01' where `id`='".intval($row['id'])."'"); 2379-> mysql_query("delete from `orgdomaincerts` where `orgid`='".intval($row['id'])."'"); 2380-> mysql_query("delete from `orgdomlink` where `domid`='".intval($row['id'])."'"); 2387-> $res = mysql_query($query); 2388-> while($row = mysql_fetch_assoc($res)) 2390-> mysql_query("update `orgemailcerts` set `revoked`='1970-01-01 10:00:01' where `id`='".intval($row['id'])."'"); 2391-> mysql_query("delete from `orgemailcerts` where `id`='".intval($row['id'])."'"); 2392-> mysql_query("delete from `orgemaillink` where `domid`='".intval($row['id'])."'"); 2395-> mysql_query("delete from `org` where `orgid`='".intval($_SESSION['_config']['orgid'])."'"); 2396-> mysql_query("delete from `orgdomains` where `orgid`='".intval($_SESSION['_config']['orgid'])."'"); 2397-> mysql_query("delete from `orginfo` where `id`='".intval($_SESSION['_config']['orgid'])."'"); 2409-> $_macc = mysql_num_rows(mysql_query($query)); 2422-> $is_orguser = mysql_num_rows(mysql_query($query)); 2436-> $res = mysql_query($query); 2437-> if(mysql_num_rows($res) <= 0) 2450-> $_REQUEST['email'] = $_SESSION['_config']['email'] = mysql_real_escape_string(stripslashes(trim($_REQUEST['email']))); 2452-> $comments = $_SESSION['_config']['comments'] = mysql_real_escape_string(stripslashes(trim($_REQUEST['comments']))); 2453-> $res = mysql_query("select * from `users` where `email`='".$_REQUEST['email']."' and `deleted`=0"); 2454-> if(mysql_num_rows($res) <= 0) 2460-> $row = mysql_fetch_assoc($res); 2468-> mysql_query( 2473-> `OU`='".mysql_real_escape_string($_SESSION['_config']['OU'])."', 2482-> $res = mysql_query("select * from `org` where `orgid`='$orgid' and `memid`='".intval($_SESSION['profile']['id'])."' and `masteracc`='1'"); 2483-> if(mysql_num_rows($res) <= 0) 2492-> mysql_query($query); 2504-> $row = mysql_fetch_assoc(mysql_query("select * from `alerts` where `memid`='".intval($_SESSION['profile']['id'])."'")); 2513-> $rc = mysql_num_rows(mysql_query("select * from `alerts` where `memid`='".intval($_SESSION['profile']['id'])."'")); 2528-> mysql_query($query); 2536-> $lang = mysql_real_escape_string($_REQUEST['lang']); 2541-> mysql_query("update `users` set `language`='$lang' where `id`='".intval($_SESSION['profile']['id'])."'"); 2559-> $addlang = mysql_real_escape_string($_REQUEST['addlang']); 2561-> mysql_query("insert into `addlang` set `userid`='".intval($_SESSION['profile']['id'])."', `lang`='$addlang'"); 2571-> $remove = mysql_real_escape_string($_REQUEST['remove']); 2572-> mysql_query("delete from `addlang` where `userid`='".intval($_SESSION['profile']['id'])."' and `lang`='$remove'"); 2607-> $name = array_key_exists('name',$_REQUEST)?mysql_real_escape_string(strip_tags($_REQUEST['name'])):""; 2615-> mysql_query($query); 2616-> $row = mysql_fetch_assoc(mysql_query("select * from `locations` where `id`='$locid'")); 2623-> mysql_query($query); 2624-> $row = mysql_fetch_assoc(mysql_query("select * from `regions` where `id`='$regid'")); 2630-> $row = mysql_fetch_assoc(mysql_query("select `ccid` from `regions` where `id`='$regid'")); 2633-> mysql_query($query); 2639-> mysql_query($query); 2640-> $row = mysql_fetch_assoc(mysql_query("select * from `locations` where `id`='$locid'")); 2645-> $row = mysql_fetch_assoc(mysql_query("select * from `locations` where `id`='$locid'")); 2647-> mysql_query("delete from `localias` where `locid`='$locid'"); 2648-> mysql_query("delete from `locations` where `id`='$locid'"); 2653-> $row = mysql_fetch_assoc(mysql_query("select * from `locations` where `id`='$locid'")); 2655-> mysql_query("update `locations` set `regid`='$newreg' where `id`='$locid'"); 2656-> mysql_query("update `users` set `regid`='$newreg' where `regid`='$oldregid'"); 2657-> $row = mysql_fetch_assoc(mysql_query("select * from `locations` where `id`='$locid'")); 2663-> $row = mysql_fetch_assoc(mysql_query("select * from `regions` where `id`='$regid'")); 2665-> mysql_query("delete from `locations` where `regid`='$regid'"); 2666-> mysql_query("delete from `regions` where `id`='$regid'"); 2675-> $row = mysql_query("insert into `localias` set `locid`='$locid',`name`='$name'"); 2680-> $row = mysql_query("delete from `localias` where `locid`='$locid' and `name`='$name'"); 2717-> $fname = mysql_real_escape_string($_REQUEST['fname']); 2718-> $mname = mysql_real_escape_string($_REQUEST['mname']); 2719-> $lname = mysql_real_escape_string($_REQUEST['lname']); 2720-> $suffix = mysql_real_escape_string($_REQUEST['suffix']); 2725-> mysql_query($query); 2764-> $row = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($_REQUEST['userid'])."'")); 2784-> mysql_query("update `users` set `password`=sha1('".mysql_real_escape_string(stripslashes($_REQUEST['newpass']))."') where `id`='".intval($_REQUEST['userid'])."'"); 2785-> $row = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($_REQUEST['userid'])."'")); 2875-> mysql_query($query); 2876-> $CSRid = mysql_insert_id(); 2879-> mysql_query("insert into `domlink` set `certid`='$CSRid', `domid`='".intval($dom)."'"); 2882-> mysql_query("insert into `domlink` set `certid`='$CSRid', `domid`='".intval($dom)."'"); 2888-> mysql_query("update `domaincerts` set `CSR_name`='$CSRname' where `id`='$CSRid'"); 2891-> $res = mysql_query($query); 2892-> if(mysql_num_rows($res) <= 0) 2916-> $row = mysql_fetch_assoc(mysql_query($query)); 2918-> mysql_query("update `users` set `tverify`='$ver' where `id`='$memid'"); 2935-> $row = mysql_fetch_assoc(mysql_query($query)); 2937-> mysql_query("update `users` set `assurer`='$ver' where `id`='$memid'"); 2953-> $row = mysql_fetch_assoc(mysql_query($query)); 2955-> mysql_query("update `users` set `assurer_blocked`='$ver' where `id`='$memid'"); 2972-> $row = mysql_fetch_assoc(mysql_query($query)); 2974-> mysql_query("update `users` set `locked`='$ver' where `id`='$memid'"); 2991-> $row = mysql_fetch_assoc(mysql_query($query)); 2993-> mysql_query("update `users` set `codesign`='$ver' where `id`='$memid'"); 3010-> $row = mysql_fetch_assoc(mysql_query($query)); 3012-> mysql_query("update `users` set `orgadmin`='$ver' where `id`='$memid'"); 3029-> $row = mysql_fetch_assoc(mysql_query($query)); 3031-> mysql_query("update `users` set `ttpadmin`='$ver' where `id`='$memid'"); 3047-> $row = mysql_fetch_assoc(mysql_query($query)); 3051-> mysql_query("update `users` set `adadmin`='$ver' where `id`='$memid'"); 3067-> $row = mysql_fetch_assoc(mysql_query($query)); 3069-> mysql_query("update `users` set `locadmin`='$ver' where `id`='$memid'"); 3086-> $row = mysql_fetch_assoc(mysql_query($query)); 3088-> mysql_query("update `users` set `admin`='$ver' where `id`='$memid'"); 3104-> $row = mysql_fetch_assoc(mysql_query($query)); 3106-> mysql_query("update `alerts` set `general`='$ver' where `memid`='$memid'"); 3122-> $row = mysql_fetch_assoc(mysql_query($query)); 3124-> mysql_query("update `alerts` set `country`='$ver' where `memid`='$memid'"); 3140-> $row = mysql_fetch_assoc(mysql_query($query)); 3142-> mysql_query("update `alerts` set `regional`='$ver' where `memid`='$memid'"); 3158-> $row = mysql_fetch_assoc(mysql_query($query)); 3160-> mysql_query("update `alerts` set `radius`='$ver' where `memid`='$memid'"); 3172-> $row = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($_REQUEST['userid'])."'")); /home/gitRepos/CAcert/CAcert-devel/tverify/index/0.php 37-> $account = mysql_query($query); 38-> if(mysql_num_rows($account)) 54-> $row = mysql_fetch_assoc($account); 60-> $res = mysql_query($query); 61-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/tverify/index.php 52-> $email = mysql_escape_string(trim($_REQUEST["email"])); 53-> $password = mysql_escape_string(stripslashes(trim($_REQUEST["pword"]))); 54-> $URL = mysql_escape_string(trim($_REQUEST["notaryURL"])); 55-> $CN = mysql_escape_string($_SESSION['_config']['CN']); 57-> $user = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='$memid'")); 58-> $tmp = mysql_fetch_assoc(mysql_query("select sum(`points`) as `points` from `notary` where `to`='$memid'")); 91-> if(mysql_num_rows(mysql_query($query)) <= 0) 97-> mysql_query($query); 98-> $tverify = mysql_insert_id(); 102-> $newfile = mysql_escape_string('/www/photoid/'.$tverify.".".$ext); 105-> mysql_query($query); 128-> mysql_query("insert into `notary` set `from`='0', `to`='$memid', `points`='$points', 133-> mysql_query("update `tverify` set `modified`=NOW() where `id`='$tverify'"); /home/gitRepos/CAcert/CAcert-devel/www/ac.php 23-> $s = mysql_real_escape_string($_REQUEST['s']); 25-> $id = mysql_real_escape_string(strip_tags($_REQUEST['id'])); 30-> $loc = trim(mysql_real_escape_string($bits['0'])); 31-> $reg = trim(mysql_real_escape_string($bits['1'])); 32-> $ccname = trim(mysql_real_escape_string($bits['2'])); 38-> $res = mysql_query($query); 39-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/www/advertising.php 38-> $title = mysql_real_escape_string(strip_tags(trim(htmlentities($_POST['title'])))); 39-> $link = mysql_real_escape_string(strip_tags(trim($_POST['link']))); 76-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/www/verify.php 46-> $hash = mysql_escape_string(stripslashes($_REQUEST['hash'])); 49-> $res = mysql_query($query); 50-> if(mysql_num_rows($res) > 0) 52-> $row = mysql_fetch_assoc($res); 56-> mysql_query("update `email` set `hash`='', `attempts`='$row[attempts]', `deleted`=NOW() where `id`='$emailid'"); 62-> mysql_query("update `email` set `attempts`='$row[attempts]' where `id`='$emailid'"); 66-> $res = mysql_query($query); 67-> if(mysql_num_rows($res) <= 0) 74-> $row = mysql_fetch_assoc($res); 78-> mysql_query($query); 80-> mysql_query($query); 104-> $hash = mysql_escape_string(stripslashes($_REQUEST['hash'])); 107-> $res = mysql_query($query); 108-> if(mysql_num_rows($res) > 0) 110-> $row = mysql_fetch_assoc($res); 121-> mysql_query($query); 125-> $res = mysql_query($query); 126-> if(mysql_num_rows($res) <= 0) 133-> $row = mysql_fetch_assoc($res); 137-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/www/sqldump.php 28-> $tables = mysql_query("SHOW TABLES"); 29-> while(list($table_name) = mysql_fetch_array($tables)) 35-> $create = mysql_fetch_assoc(mysql_query("SHOW CREATE TABLE `$table_name`")); /home/gitRepos/CAcert/CAcert-devel/www/rss.php 15-> $res = mysql_query($query); 16-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/www/api/edu.php 23-> $serial=mysql_escape_string($_REQUEST["serial"]); 27-> $query= mysql_query($sql); 28-> if(mysql_num_rows($query) != 1) 34-> $memid = mysql_fetch_assoc($query); /home/gitRepos/CAcert/CAcert-devel/www/api/cemails.php 18-> $username = mysql_escape_string($_REQUEST['username']); 19-> $password = mysql_escape_string($_REQUEST['password']); 22-> $res = mysql_query($query); 23-> if(mysql_num_rows($res) != 1) 26-> $user = mysql_fetch_assoc($res); 29-> $row = mysql_fetch_assoc(mysql_query($query)); 44-> $res = mysql_query($query); 45-> while($row = mysql_fetch_assoc($res)) { /home/gitRepos/CAcert/CAcert-devel/www/api/ccsr.php 21-> $username = mysql_real_escape_string($_REQUEST['username']); 22-> $password = mysql_real_escape_string($_REQUEST['password']); 25-> $res = mysql_query($query); 26-> if(mysql_num_rows($res) != 1) 28-> $user = mysql_fetch_assoc($res); 33-> $email = mysql_real_escape_string(trim($email)); 35-> $res = mysql_query($query); 36-> if(mysql_num_rows($res) > 0) 38-> $row = mysql_fetch_assoc($res); 46-> $row = mysql_fetch_assoc(mysql_query($query)); 50-> $newname = mysql_real_escape_string(trim($_REQUEST['name'])); 87-> $query = "insert into `emailcerts` set `CN`='".mysql_real_escape_string($user['email'])."', `keytype`='MS', 89-> `subject`='".mysql_real_escape_string($csrsubject)."', `codesign`='".intval($codesign)."'"; 90-> mysql_query($query); 91-> $certid = mysql_insert_id(); 95-> mysql_query("update `emailcerts` set `csr_name`='$CSRname' where `id`='$certid'"); 98-> mysql_query("insert into `emaillink` set `emailcertsid`='$certid', `emailid`='".intval($emailid)."'"); 103-> $res = mysql_query($query); 104-> if(mysql_num_rows($res) <= 0) 106-> $cert = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/www/index.php 56-> $_SESSION['lostpw']['A1'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A1'])))); 64-> $_SESSION['lostpw']['A2'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A2'])))); 72-> $_SESSION['lostpw']['A3'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A3'])))); 80-> $_SESSION['lostpw']['A4'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A4'])))); 88-> $_SESSION['lostpw']['A5'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A5'])))); 95-> $_SESSION['lostpw']['pw1'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['newpass1'])))); 96-> $_SESSION['lostpw']['pw2'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['newpass2'])))); 122-> mysql_query($query) || die(mysql_error()); 133-> $email = $_SESSION['lostpw']['email'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['email'])))); 139-> $res = mysql_query($query); 140-> if(mysql_num_rows($res) <= 0) 147-> $_SESSION['lostpw']['user'] = mysql_fetch_assoc($res); 160-> $_SESSION['profile'] = mysql_fetch_assoc(mysql_query( 189-> $email = mysql_escape_string(stripslashes(strip_tags(trim($_REQUEST['email'])))); 190-> $pword = mysql_escape_string(stripslashes(trim($_REQUEST['pword']))); 193-> $res = mysql_query($query); 195-> $rateLimit = mysql_num_rows(mysql_query($query)) > 0; 196-> if(mysql_num_rows($res) > 0 && $rateLimit) 200-> $_SESSION['profile'] = mysql_fetch_assoc($res); 202-> mysql_query($query); 208-> mysql_query($query); 214-> $res = mysql_query($query); 215-> $row = mysql_fetch_assoc($res); 238-> mysql_query($query); 243-> $res = mysql_query($query); 244-> if(!$rateLimit || mysql_num_rows($res) <= 0) { 292-> $_SESSION['signup']['email'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['email'])))); 293-> $_SESSION['signup']['fname'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['fname'])))); 294-> $_SESSION['signup']['mname'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['mname'])))); 295-> $_SESSION['signup']['lname'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['lname'])))); 296-> $_SESSION['signup']['suffix'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['suffix'])))); 300-> $_SESSION['signup']['pword1'] = trim(mysql_escape_string(stripslashes($_REQUEST['pword1']))); 301-> $_SESSION['signup']['pword2'] = trim(mysql_escape_string(stripslashes($_REQUEST['pword2']))); 302-> $_SESSION['signup']['Q1'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['Q1'])))); 303-> $_SESSION['signup']['Q2'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['Q2'])))); 304-> $_SESSION['signup']['Q3'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['Q3'])))); 305-> $_SESSION['signup']['Q4'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['Q4'])))); 306-> $_SESSION['signup']['Q5'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['Q5'])))); 307-> $_SESSION['signup']['A1'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A1'])))); 308-> $_SESSION['signup']['A2'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A2'])))); 309-> $_SESSION['signup']['A3'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A3'])))); 310-> $_SESSION['signup']['A4'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A4'])))); 311-> $_SESSION['signup']['A5'] = trim(mysql_escape_string(stripslashes(strip_tags($_REQUEST['A5'])))); 406-> $res1 = mysql_query($query); 409-> $res2 = mysql_query($query); 410-> if(mysql_num_rows($res1) > 0 || mysql_num_rows($res2) > 0) 417-> $res = mysql_query($query); 418-> if(mysql_num_rows($res) > 0) 420-> $domain = mysql_fetch_assoc($res); 465-> mysql_query($query); 466-> $memid = mysql_insert_id(); 471-> mysql_query($query); 472-> $emailid = mysql_insert_id(); 478-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/www/gpg.php 83-> if(mysql_num_rows(mysql_query("select * from `email` where `memid`='".$_SESSION['profile']['id']."' and `email`='".mysql_real_escape_string($email)."' and `deleted`=0 and `hash`=''")) > 0) return 1; 317-> $description= trim(mysql_real_escape_string(stripslashes($_REQUEST['description']))); 321-> `email`='".mysql_real_escape_string($lastvalidemail)."', 323-> `expires`='".mysql_real_escape_string($expires)."', 324-> `multiple`='".mysql_real_escape_string($multiple)."', 325-> `keyid`='".mysql_real_escape_string($keyid)."', 326-> `description`='".mysql_real_escape_string($description)."'"; 327-> mysql_query($query); 328-> $insert_id = mysql_insert_id(); 530-> mysql_query("update `gpg` set `csr`='$csrname' where `id`='$insert_id'"); 536-> $res = mysql_query($query); 537-> if(mysql_num_rows($res) <= 0) 559-> $comment=trim(mysql_real_escape_string(stripslashes($_REQUEST['comment_'.$cid]))); 560-> mysql_query("update `gpg` set `description`='$comment' where `id`='$cid' and `memid`='".$_SESSION['profile']['id']."'"); /home/gitRepos/CAcert/CAcert-devel/www/stats.php 28-> $res = mysql_query($sql); 29-> if ($res && mysql_numrows($res) > 0) { 30-> $ar = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/www/wot.php 137-> mysql_escape_string(stripslashes($_POST['country'])).".\n\n"; 184-> $query = "select * from `users` where `email`='".mysql_escape_string(stripslashes($_POST['email']))."' and `deleted`=0"; 185-> $res = mysql_query($query); 186-> if(mysql_num_rows($res) != 1) 194-> $_SESSION['_config']['notarise'] = mysql_fetch_assoc($res); 212-> $query = "select * from `users` where `email`='".mysql_escape_string(stripslashes($_POST['email']))."' and `locked`=1"; 213-> $res = mysql_query($query); 214-> if(mysql_num_rows($res) >= 1) 239-> $res = mysql_query($query); 240-> if(mysql_num_rows($res) > 0) 324-> $res = mysql_query($query); 325-> $row = mysql_fetch_assoc($res); 346-> $res = mysql_query($query); 347-> $drow = mysql_fetch_assoc($res); 358-> if(mysql_real_escape_string(stripslashes($_POST['date'])) == "") 364-> `location`='".mysql_real_escape_string(stripslashes($_POST['location']))."' AND 365-> `date`='".mysql_real_escape_string(stripslashes($_POST['date']))."' AND 367-> $res = mysql_query($query); 368-> if(mysql_num_rows($res) > 0) 380-> `location`='".mysql_real_escape_string(stripslashes($_POST['location']))."', 381-> `date`='".mysql_real_escape_string(stripslashes($_POST['date']))."', 391-> mysql_query($query); 405-> `location`='".mysql_real_escape_string(stripslashes($_POST['location']))."', 406-> `date`='".mysql_real_escape_string(stripslashes($_POST['date']))."', 409-> mysql_query($query); 464-> $info = mysql_real_escape_string(strip_tags(stripslashes($_POST['contactinfo']))); 473-> mysql_query($query); 493-> $user = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='".intval($userid)."' and `listme`=1")); 494-> $points = mysql_num_rows(mysql_query("select sum(`points`) as `total` from `notary` /home/gitRepos/CAcert/CAcert-devel/www/disputes.php 31-> $hash = mysql_escape_string(trim($_SESSION['_config']['hash'])); 33-> $res = mysql_query("select * from `disputeemail` where `id`='$emailid' and `hash`='$hash'"); 34-> if(mysql_num_rows($res) <= 0) 41-> $row = mysql_fetch_assoc($res); 46-> mysql_query("update `disputeemail` set hash='',action='reject' where `id`='".intval($emailid)."'"); 58-> $res = mysql_query($query); 59-> if(mysql_num_rows($res) > 0) 61-> $row = mysql_fetch_assoc($res); 65-> mysql_query("update `disputeemail` set hash='',action='accept' where `id`='$emailid'"); 66-> $rc = mysql_num_rows(mysql_query("select * from `domains` where `memid`='$oldmemid' and `deleted`=0")); 67-> $rc2 = mysql_num_rows(mysql_query("select * from `email` where `memid`='$oldmemid' and `deleted`=0 and `id`!='$emailid'")); 68-> $res = mysql_query("select * from `users` where `id`='$oldmemid'"); 69-> $user = mysql_fetch_assoc($res); 72-> mysql_query("update `users` set `deleted`=NOW() where `id`='$oldmemid'"); 84-> $hash = trim(mysql_escape_string(stripslashes($_REQUEST['hash']))); 93-> $res = mysql_query("select * from `disputeemail` where `id`='$emailid' and `hash`='$hash'"); 94-> if(mysql_num_rows($res) <= 0) 96-> $res = mysql_query("select * from `disputeemail` where `id`='$emailid' and hash!=''"); 97-> if(mysql_num_rows($res) > 0) 99-> $row = mysql_fetch_assoc($res); 100-> mysql_query("update `disputeemail` set `attempts`='".intval($row['attempts'] + 1)."' where `id`='".$row['id']."'"); 105-> mysql_query("update `disputeemail` set hash='',action='failed' where `id`='$emailid'"); 119-> $row = mysql_fetch_assoc(mysql_query("select * from `disputeemail` where `id`='$emailid'")); 130-> $hash = mysql_escape_string(trim($_SESSION['_config']['hash'])); 132-> $res = mysql_query("select * from `disputedomain` where `id`='$domainid' and `hash`='$hash'"); 133-> if(mysql_num_rows($res) <= 0) 143-> mysql_query("update `disputedomain` set hash='',action='reject' where `id`='$domainid'"); 156-> $res = mysql_query($query); 157-> if(mysql_num_rows($res) > 0) 162-> mysql_query("update `disputedomain` set hash='',action='accept' where `id`='$domainid'"); 171-> $hash = trim(mysql_escape_string(stripslashes($_REQUEST['hash']))); 180-> $res = mysql_query("select * from `disputedomain` where `id`='$domainid' and `hash`='$hash'"); 181-> if(mysql_num_rows($res) <= 0) 183-> $res = mysql_query("select * from `disputedomain` where `id`='$domainid' and hash!=''"); 184-> if(mysql_num_rows($res) > 0) 186-> $row = mysql_fetch_assoc($res); 187-> mysql_query("update `disputedomain` set `attempts`='".intval($row['attempts'] + 1)."' where `id`='".$row['id']."'"); 192-> mysql_query("update `disputedomain` set hash='',action='failed' where `id`='$domainid'"); 206-> $row = mysql_fetch_assoc(mysql_query("select * from `disputedomain` where `id`='$domainid'")); 217-> $email = trim(mysql_escape_string(stripslashes($_REQUEST['dispute']))); 227-> $res = mysql_query("select 1 from `email`, `users` where `email`.`email`='$email' and `email`.`memid`=`users`.`id` and (`users`.`assurer_blocked`=1 or `users`.`locked`=1)"); 228-> if(mysql_num_rows($res) > 0) 243-> $res = mysql_query("select * from `disputeemail` where `email`='$email' and hash!=''"); 244-> if(mysql_num_rows($res) > 0) 254-> $res = mysql_query($query); 255-> if(mysql_num_rows($res) <= 0) 262-> $row = mysql_fetch_assoc($res); 273-> $res = mysql_query("select * from `users` where `id`='$oldmemid'"); 274-> $user = mysql_fetch_assoc($res); 275-> $rc = mysql_num_rows(mysql_query("select * from `domains` where `memid`='$oldmemid' and `deleted`=0")); 276-> $rc2 = mysql_num_rows(mysql_query("select * from `email` where `memid`='$oldmemid' and `deleted`=0 and `id`!='$emailid'")); 289-> mysql_query($query); 310-> $domain = trim(mysql_escape_string(stripslashes($_REQUEST['dispute']))); 320-> $res = mysql_query("select 1 from `domains`, `users` where `domains`.`domain`='$domain' and `domains`.`memid`=`users`.`id` and (`users`.`assurer_blocked`=1 or `users`.`locked`=1)"); 321-> if(mysql_num_rows($res) > 0) 337-> $res = mysql_query($query); 338-> if(mysql_num_rows($res) > 0) 347-> $res = mysql_query($query); 348-> if(mysql_num_rows($res) <= 0) 351-> $res = mysql_query($query); 352-> if(mysql_num_rows($res) > 0) 364-> $row = mysql_fetch_assoc($res); 392-> $addy[] = trim(mysql_escape_string(stripslashes($line))); 409-> $addy[] = trim(mysql_escape_string(stripslashes($line))); 426-> $authaddy = trim(mysql_escape_string(stripslashes($_REQUEST['authaddy']))); 437-> $res = mysql_query($query); 438-> if(mysql_num_rows($res) <= 0) 449-> $domain = mysql_escape_string($_SESSION['_config']['domain']); 454-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/www/cats/cats_import.php 88->$query = mysql_query('SELECT `id` FROM `cats_type` WHERE `type_text` = \''.mysql_real_escape_string($type).'\';'); 95->if (mysql_num_rows($query) > 0) { 96-> $result = mysql_fetch_array($query); 99-> $query = mysql_query('INSERT INTO `cats_type` (`type_text`) VALUES (\''.mysql_real_escape_string($type).'\');'); 106-> $typeID = mysql_insert_id(); 109->$query = mysql_query('SELECT `id` FROM `cats_variant` WHERE `type_id` = \''.(int)intval($typeID).'\' AND `test_text` = \''.mysql_real_escape_string($variant).'\';'); 116->if (mysql_num_rows($query) > 0) { 117-> $result = mysql_fetch_array($query); 120-> $query = mysql_query('INSERT INTO `cats_variant` (`type_id`, `test_text`) VALUES (\''.(int)intval($typeID).'\', \''.mysql_real_escape_string($variant).'\');'); 127-> $variantID = mysql_insert_id(); 131->$query = mysql_query('SELECT `ec`.`memid` FROM `emailcerts` AS `ec`, `root_certs` AS `rc` WHERE `ec`.`rootcert` = `rc`.`id` AND `ec`.`serial` = \''.mysql_real_escape_string($serial).'\' AND `rc`.`cert_text` = \''.mysql_real_escape_string($root).'\';'); 138->if (mysql_num_rows($query) > 0) { 139-> $result = mysql_fetch_array($query); 144-> trigger_error('Cannot find cert '.$serial.' / '.$root.'!'.mysql_error(), E_USER_ERROR); 149->$query = mysql_query('INSERT INTO `cats_passed` (`user_id`, `variant_id`, `pass_date`) VALUES (\''.(int)intval($userID).'\', \''.(int)intval($variantID).'\', \''.mysql_real_escape_string($date).'\');'); 151-> if (mysql_errno() != 1062) { // Duplicate Entry is considered success /home/gitRepos/CAcert/CAcert-devel/www/news.php 28-> $row = mysql_fetch_assoc(mysql_query($query)); 36-> $res = mysql_query($query); 37-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/www/account.php 59-> $res = mysql_query($query); 60-> if(mysql_num_rows($res)) 62-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/www/alert_hash_collision.php 17-> mysql_query("update emailcerts set coll_found=1 where memid='".mysql_escape_string(substr(@$_POST['usernym'],4))."' and pkhash!='' and pkhash='".$_POST['pkhash']."';"); 18-> mysql_query("update domaincerts set coll_found=1 where memid='".mysql_escape_string(substr(@$_POST['usernym'],4))."' and pkhash!='' and pkhash='".$_POST['pkhash']."';"); 22-> mysql_query("update orgemailcerts set coll_found=1 where memid='".mysql_escape_string(substr(@$_POST['usernym'],4))."' and pkhash!='' and pkhash='".$_POST['pkhash']."';"); 23-> mysql_query("update orgdomaincerts set coll_found=1 where memid='".mysql_escape_string(substr(@$_POST['usernym'],4))."' and pkhash!='' and pkhash='".$_POST['pkhash']."';"); /home/gitRepos/CAcert/CAcert-devel/scripts/addpoints.php 25-> $res = mysql_query($query); 26-> while($row = mysql_fetch_assoc($res)) 29-> $drow = mysql_fetch_assoc(mysql_query($query)); 33-> $num = mysql_num_rows(mysql_query($query)); 35-> $newnum = mysql_num_rows(mysql_query($query)); 48-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/scripts/send_policy_cca_20140916.php 119->$res = mysql_query($query); 121->while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/send_thawte.php.txt 123-> $res = mysql_query($query); 125-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/mass-revoke.php 47-> if (!mysql_query($query)) { 50-> $num_domain+=mysql_affected_rows(); 56-> if (!mysql_query($query)) { 59-> $num_client+=mysql_affected_rows(); 65-> if (!mysql_query($query)) { 68-> $num_orgdomain+=mysql_affected_rows(); 74-> if (!mysql_query($query)) { 77-> $num_orgclient+=mysql_affected_rows(); /home/gitRepos/CAcert/CAcert-devel/scripts/56at-ate-oberwart-mail.php.txt 112-> $loc = mysql_fetch_assoc(mysql_query($query)); 130-> $res = mysql_query($query); 131-> $xrows = mysql_num_rows($res); 133-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/50de-ate-luebeck-mail.php.txt 88-> $loc = mysql_fetch_assoc(mysql_query($query)); 106-> $res = mysql_query($query); 107-> $xrows = mysql_num_rows($res); 109-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/cron/permissionreview.php 120-> if(! $res = mysql_query($query) ) { 124-> mysql_error() 132-> while ($row = mysql_fetch_assoc($res)) { /home/gitRepos/CAcert/CAcert-devel/scripts/cron/updatesort.php 29-> mysql_query("update `locations` set `acount`=0"); 33-> $res = mysql_query($query); 34-> while($row = mysql_fetch_assoc($res)) 38-> mysql_query($query); 42-> mysql_query("update `regions` set `acount`=0"); 46-> $res = mysql_query($query); 47-> while($row = mysql_fetch_assoc($res)) 51-> mysql_query($query); 57-> mysql_query("update `countries` set `acount`=0"); 61-> $res = mysql_query($query); 62-> while($row = mysql_fetch_assoc($res)) 66-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/scripts/cron/removedead.php 26-> $res = mysql_query($query); 27-> while($row = mysql_fetch_assoc($res)) 29-> mysql_query("delete from `email` where `memid`='".$row['id']."'"); 30-> mysql_query("delete from `users` where `id`='".$row['id']."'"); 36-> mysql_query($query); 40-> mysql_query($query); 44-> mysql_query($query); 48-> mysql_query($query); 54-> $res = mysql_query($query); 55-> while($row = mysql_fetch_assoc($res)) 58-> $dres = mysql_query($query); 59-> $drow = mysql_fetch_assoc($dres); 66-> mysql_query($query); 70-> $data = mysql_fetch_assoc(mysql_query("select * from `users` where `id`='$row[to]'")); 87-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/scripts/cron/warning.php 36-> $res = mysql_query($query); 37-> while($row = mysql_fetch_assoc($res)) 73-> mysql_query($query); 110-> $res = mysql_query($query); 111-> while($row = mysql_fetch_assoc($res)) 131-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/scripts/cron/refresh_stats.php 24-> * Wrapper around mysql_query() to provide some error handling. Prints an error 33-> $res = mysql_query($sql); 35-> fwrite(STDERR, "MySQL query failed:\n\"$sql\"\n".mysql_error()); 43-> $row = mysql_fetch_assoc(sql_query($sql)); 55-> ('$timestamp', '".mysql_real_escape_string(serialize($stats))."')"; 61-> if (mysql_num_rows($res) !== 1) { /home/gitRepos/CAcert/CAcert-devel/scripts/57at-ate-graz-mail.php.txt 95-> $loc = mysql_fetch_assoc(mysql_query($query)); 113-> $res = mysql_query($query); 114-> $xrows = mysql_num_rows($res); 116-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/49de-lt2013-berlin-mail.php.txt 84-> $loc = mysql_fetch_assoc(mysql_query($query)); 102-> $res = mysql_query($query); 103-> $xrows = mysql_num_rows($res); 105-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/55de-ate-wiesbaden-mail.php.txt 87-> $loc = mysql_fetch_assoc(mysql_query($query)); 105-> $res = mysql_query($query); 106-> $xrows = mysql_num_rows($res); 108-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/52at-ate-wien-mail.php.txt 95-> $loc = mysql_fetch_assoc(mysql_query($query)); 113-> $res = mysql_query($query); 114-> $xrows = mysql_num_rows($res); 116-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/gpgfillmissingemail.php 45-> $res = mysql_query("SELECT * FROM gpg WHERE crt != '' and email=''"); 53-> while ($row = mysql_fetch_assoc($res)) { 77-> mysql_query("update gpg set email='$mail' where id=$row[id];"); 85-> mysql_free_result($res); /home/gitRepos/CAcert/CAcert-devel/scripts/db_migrations/version1.sh 34-> Usage: $0 [MYSQL_OPTIONS] 46->mysql_opt=" --batch --skip-column-names $@" 48->schema_version=$( mysql $mysql_opt <<- 'SQL' 68->mysql $mysql_opt <<- 'SQL' /home/gitRepos/CAcert/CAcert-devel/scripts/db_migrations/version2.sh 34-> Usage: $0 [MYSQL_OPTIONS] 46->mysql_opt=" --batch --skip-column-names $@" 48->schema_version=$( mysql $mysql_opt <<- 'SQL' 61->mysql $mysql_opt <<- 'SQL' /home/gitRepos/CAcert/CAcert-devel/scripts/db_migrations/version3.sh 34-> Usage: $0 [MYSQL_OPTIONS] 46->mysql_opt=" --batch --skip-column-names $@" 48->schema_version=$( mysql $mysql_opt <<- 'SQL' 61->mysql $mysql_opt <<- 'SQL' /home/gitRepos/CAcert/CAcert-devel/scripts/db_migrations/version5.sh 30-> Usage: $0 [MYSQL_OPTIONS] 42->mysql_opt=" --batch --skip-column-names $@" 44->schema_version=$( mysql $mysql_opt <<- 'SQL' 57->mysql $mysql_opt <<- 'SQL' /home/gitRepos/CAcert/CAcert-devel/scripts/db_migrations/version6.sh 30-> Usage: $0 [MYSQL_OPTIONS] 42->mysql_opt=" --batch --skip-column-names $@" 44->schema_version=$( mysql $mysql_opt <<- 'SQL' 57->mysql $mysql_opt <<- 'SQL' /home/gitRepos/CAcert/CAcert-devel/scripts/db_migrations/version4.sh 34-> Usage: $0 [MYSQL_OPTIONS] 46->mysql_opt=" --batch --skip-column-names $@" 48->schema_version=$( mysql $mysql_opt <<- 'SQL' 61->mysql $mysql_opt <<- 'SQL' 76->mysql $mysql_opt <<- 'SQL' /home/gitRepos/CAcert/CAcert-devel/scripts/scanforexponents.php 56-> $res = mysql_query($query); 57-> if(mysql_num_rows($res) <= 0) 64-> $row = mysql_fetch_assoc($res); 72-> $res = mysql_query($query); 73-> if(mysql_num_rows($res) <= 0) 80-> $row = mysql_fetch_assoc($res); 88-> $res = mysql_query($query); 89-> if(mysql_num_rows($res) <= 0) 96-> $row = mysql_fetch_assoc($res); 104-> $res = mysql_query($query); 105-> if(mysql_num_rows($res) <= 0) 112-> $row = mysql_fetch_assoc($res); /home/gitRepos/CAcert/CAcert-devel/scripts/country.php 23-> $res = mysql_query($query); 24-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/resetpermissions.php 29-> if(! $res = mysql_query($query) ) { 33-> mysql_error() 39-> while ($row = mysql_fetch_assoc($res)) { 43-> if(! $res2 = mysql_query($update) ) { 48-> mysql_error() /home/gitRepos/CAcert/CAcert-devel/scripts/gpgcheck3.php 71-> $res = mysql_query("SELECT id, memid FROM gpg WHERE crt != ''"); 78-> while ($row = mysql_fetch_row($res)) { 81-> mysql_free_result($res); 90-> $res = mysql_query("SELECT fname, mname, lname, suffix FROM users WHERE id = " . $key[1]); 95-> $user = mysql_fetch_assoc($res); 100-> mysql_free_result($res); 102-> $res = mysql_query("SELECT email FROM email WHERE hash = '' AND memid = " . $key[1]); 108-> while ($addr = mysql_fetch_row($res)) { 111-> mysql_free_result($res); /home/gitRepos/CAcert/CAcert-devel/scripts/gpgfillmissingkeyid.php 30-> $res = mysql_query("SELECT * FROM gpg WHERE crt != '' and keyid is null"); 38-> while ($row = mysql_fetch_assoc($res)) { 57-> mysql_query("update gpg set keyid='$bits[4]' where id=$row[id]\n"); 70-> mysql_free_result($res); /home/gitRepos/CAcert/CAcert-devel/scripts/58at-ate-wien-mail.php.txt 99-> $loc = mysql_fetch_assoc(mysql_query($query)); 117-> $res = mysql_query($query); 118-> $xrows = mysql_num_rows($res); 120-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/51at-ate-graz-mail.php.txt 91-> $loc = mysql_fetch_assoc(mysql_query($query)); 109-> $res = mysql_query($query); 110-> $xrows = mysql_num_rows($res); 112-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/send_heartbleed.php 225->$res = mysql_query($query); 227->while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/cleanthem.pl 5->sub mysql_query($) /home/gitRepos/CAcert/CAcert-devel/scripts/assurer.php 41-> $res = mysql_query($query); 42-> $xrows = mysql_num_rows($res); 43-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/53de-ate-amberg-mail.php.txt 98-> $loc = mysql_fetch_assoc(mysql_query($query)); 116-> $res = mysql_query($query); 117-> $xrows = mysql_num_rows($res); 119-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/newslettercebit.php 32-> $loc = mysql_fetch_assoc(mysql_query($query)); 41-> $res = mysql_query($query); 42-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/54at-ate-linz-mail.php.txt 105-> $loc = mysql_fetch_assoc(mysql_query($query)); 123-> $res = mysql_query($query); 124-> $xrows = mysql_num_rows($res); 126-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/newsletter.php 31-> $loc = mysql_fetch_assoc(mysql_query($query)); 38-> $res = mysql_query($query); 39-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/consistence.php 25-> $res = mysql_query($query); 26-> while($row = mysql_fetch_assoc($res)) 30-> //mysql_query($query); 37-> $res = mysql_query($query); 38-> while($row = mysql_fetch_assoc($res)) 42-> //mysql_query($query); 48-> $res = mysql_query($query); 49-> echo mysql_error(); 50-> while($row = mysql_fetch_assoc($res)) 56-> if($row['regid']=="1182") mysql_query($query); 62-> mysql_query("update `locations` set `acount`=0"); 66-> $res = mysql_query($query); 67-> while($row = mysql_fetch_assoc($res)) 71-> mysql_query($query); 75-> mysql_query("update `regions` set `acount`=0"); 79-> $res = mysql_query($query); 80-> while($row = mysql_fetch_assoc($res)) 84-> mysql_query($query); 90-> mysql_query("update `countries` set `acount`=0"); 94-> $res = mysql_query($query); 95-> while($row = mysql_fetch_assoc($res)) 99-> mysql_query($query); /home/gitRepos/CAcert/CAcert-devel/scripts/mailing archive/47us-fudcon-lawrence-mail.php.txt 74-> $loc = mysql_fetch_assoc(mysql_query($query)); 92-> $res = mysql_query($query); 93-> $xrows = mysql_num_rows($res); 95-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/mailing archive/oa02-orgainformation.php.txt 76-> $res = mysql_query($query); 77-> $xrows = mysql_num_rows($res); 84-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/mailing archive/45au-ate-melbourne-mail.php.txt 71-> $loc = mysql_fetch_assoc(mysql_query($query)); 89-> $res = mysql_query($query); 90-> $xrows = mysql_num_rows($res); 92-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/mailing archive/48de-ate-kiel-mail.php.txt 79-> $loc = mysql_fetch_assoc(mysql_query($query)); 97-> $res = mysql_query($query); 98-> $xrows = mysql_num_rows($res); 100-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/mailing archive/46us-ate-raleigh-mail.php.txt 77-> $loc = mysql_fetch_assoc(mysql_query($query)); 95-> $res = mysql_query($query); 96-> $xrows = mysql_num_rows($res); 98-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/mailing archive/oa01-allowance.php.txt 76-> $res = mysql_query($query); 77-> $xrows = mysql_num_rows($res); 79-> while($row = mysql_fetch_assoc($res)) /home/gitRepos/CAcert/CAcert-devel/scripts/notify.php 26-> $res = mysql_query($query); 27-> while($row = mysql_fetch_assoc($res)) 33-> mysql_query("update `email` set `hash`='$hash' where `id`='".$row['id']."'");