/home/gitRepos/CAcert/CAcert-devel/pages/advertising/0.php

27->		$res = mysqli_query($_SESSION['mconn'], $query);
28->		if(mysqli_num_rows($res) > 0)
30->			$row = mysqli_fetch_assoc($res);
33->			mysqli_query($_SESSION['mconn'], $query);
41->		$res = mysqli_query($_SESSION['mconn'], $query);
42->		if(mysqli_num_rows($res) > 0)
44->			$row = mysqli_fetch_assoc($res);
47->			mysqli_query($_SESSION['mconn'], $query);
72->	$res = mysqli_query($_SESSION['mconn'], $query);
73->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/3.php

40->	$res = mysqli_query($_SESSION['mconn'], $query);
41->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/15.php

24->	$res = mysqli_query($_SESSION['mconn'], $query);
25->	if(mysqli_num_rows($res) <= 0)
31->	$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/account/27.php

19->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `orginfo` where `id`='".intval($_REQUEST['orgid'])."'"));


/home/gitRepos/CAcert/CAcert-devel/pages/account/35.php

27->$res = mysqli_query($_SESSION['mconn'], $query);
28->while($row = mysqli_fetch_assoc($res))
58->	$res1 = mysqli_query($_SESSION['mconn'], $query);
59->	while($domain = mysqli_fetch_assoc($res1))
79->	$res2 = mysqli_query($_SESSION['mconn'], $query);
80->	while($org = mysqli_fetch_assoc($res2))
82->		$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($org['memid'])."'"));


/home/gitRepos/CAcert/CAcert-devel/pages/account/33.php

20->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));


/home/gitRepos/CAcert/CAcert-devel/pages/account/19.php

24->	$res = mysqli_query($_SESSION['mconn'], $query);
25->	if(mysqli_num_rows($res) <= 0)
32->	$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/account/41.php

57->	$res = mysqli_query($_SESSION['mconn'], $query);
58->	while($row = mysqli_fetch_assoc($res))
60->		$lang = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `languages` where `locale`='".mysql_real_escape_string($row['lang'])."'"));
73->	$res = mysqli_query($_SESSION['mconn'], $query);
74->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/34.php

20->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
22->	$org = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
24->	$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));


/home/gitRepos/CAcert/CAcert-devel/pages/account/28.php

20->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));


/home/gitRepos/CAcert/CAcert-devel/pages/account/5.php

55->	$res = mysqli_query($_SESSION['mconn'], $query);
56->	if(mysqli_num_rows($res) <= 0)
63->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/53.php

32->		$reg = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `regions` where `id`='$regid'"));
41->		$cnt = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `countries` where `id`='$ccid'"));
54->		$res = mysqli_query($_SESSION['mconn'], $query);
55->		while($row = mysqli_fetch_assoc($res))
62->		$res = mysqli_query($_SESSION['mconn'], $query);
63->		while($row = mysqli_fetch_assoc($res))
77->			$start = mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query));
80->		$res = mysqli_query($_SESSION['mconn'], $query);
81->		while($row = mysqli_fetch_assoc($res))
92->		$rc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `locations` where `regid`='$regid'"));


/home/gitRepos/CAcert/CAcert-devel/pages/account/23.php

24->	$res = mysqli_query($_SESSION['mconn'], $query);
25->	if(mysqli_num_rows($res) <= 0)
31->	$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/account/6.php

42->$res = mysqli_query($_SESSION['mconn'], $query);
43->if(mysqli_num_rows($res) <= 0) {
49->$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/account/18.php

40->    $reso = mysqli_query($_SESSION['mconn'], $query);
41->    if(mysqli_num_rows($reso) >= 1){
42->      while($row = mysqli_fetch_assoc($reso)){
108->  $res = mysqli_query($_SESSION['mconn'], $query);
109->  if(mysqli_num_rows($res) <= 0)
118->  while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/54.php

44->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
92->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
128->	$res = mysqli_query($_SESSION['mconn'], $query);
129->	$rc = mysqli_num_rows($res);
146->	while($row = mysqli_fetch_assoc($res))
172->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
189->	$res = mysqli_query($_SESSION['mconn'], $query);
190->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/12.php

49->	$res = mysqli_query($_SESSION['mconn'], $query);
50->	if(mysqli_num_rows($res) <= 0)
57->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/51.php

22->	$res = mysqli_query($_SESSION['mconn'], $query);
23->	if(mysqli_num_rows($res) > 0) { ?>
27->        $res = mysqli_query($_SESSION['mconn'], $query);
28->        if(mysqli_num_rows($res) > 0)


/home/gitRepos/CAcert/CAcert-devel/pages/account/58.php

24->	$res = mysqli_query($_SESSION['mconn'], $query);
25->	if(mysqli_num_rows($res) != 1){
28->		if ($row = mysqli_fetch_assoc($res)){
34->			$res1 = mysqli_query($_SESSION['mconn'], $query);?>
36->			if (mysqli_num_rows($res1) <= 0) {?>
48->				while($drow = mysqli_fetch_assoc($res1)){?>


/home/gitRepos/CAcert/CAcert-devel/pages/account/9.php

30->	$res = mysqli_query($_SESSION['mconn'], $query);
31->	if(mysqli_num_rows($res) <= 0)
38->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/55.php

34->    $res = mysqli_query($_SESSION['mconn'], $query);
35->    if(mysqli_num_rows($res) <= 0)
39->      $row = mysqli_fetch_assoc($res);
64->        $res = mysqli_query($_SESSION['mconn'], $query);
67->        while($row = mysqli_fetch_array($res, MYSQL_NUM))
92->        $res = mysqli_query($_SESSION['mconn'], $query);
96->          $row = mysqli_fetch_array($res, MYSQL_NUM);


/home/gitRepos/CAcert/CAcert-devel/pages/account/43.php

26->    $res = mysqli_query($_SESSION['mconn'], "select `to` from `notary` where `id`='$assurance'");
28->      $row = mysqli_fetch_assoc($res);
30->    mysqli_query($_SESSION['mconn'], "delete from `notary` where `id`='$assurance'");
66->    $res = mysqli_query($_SESSION['mconn'], $query);
67->    if(mysqli_num_rows($res) > 1) { ?>
77->  while($row = mysqli_fetch_assoc($res))
83-><? } if(mysqli_num_rows($res) >= 100) { ?>
89->    <td class="DataTD" colspan="2"><? printf(_("%s rows displayed."), mysqli_num_rows($res)); ?></td>
93-><?    } elseif(mysqli_num_rows($res) == 1) {
94->      $row = mysqli_fetch_assoc($res);
105->    $res = mysqli_query($_SESSION['mconn'], $query);
106->    if(mysqli_num_rows($res) <= 0)
110->      $row = mysqli_fetch_assoc($res);
112->      $dres = mysqli_query($_SESSION['mconn'], $query);
113->      $drow = mysqli_fetch_assoc($dres);
114->      $alerts = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `alerts` where `memid`='".intval($row['id'])."'"));
306->  $dres = mysqli_query($_SESSION['mconn'], $query);
307->  if(mysqli_num_rows($dres) > 0) { ?>
312->  $rc = mysqli_num_rows($dres);
313->  while($drow = mysqli_fetch_assoc($dres))
324->  $dres = mysqli_query($_SESSION['mconn'], $query);
325->  if(mysqli_num_rows($dres) > 0) { ?>
330->  $rc = mysqli_num_rows($dres);
331->  while($drow = mysqli_fetch_assoc($dres))
419->  $dres = mysqli_query($_SESSION['mconn'], $query);
420->  $drow = mysqli_fetch_assoc($dres);
430->  $dres = mysqli_query($_SESSION['mconn'], $query);
431->  if ($drow = mysqli_fetch_assoc($dres)) {
438->    $dres = mysqli_query($_SESSION['mconn'], $query);
439->    $drow = mysqli_fetch_assoc($dres);
516->	$dres = mysqli_query($_SESSION['mconn'], $query);
517->	$drow = mysqli_fetch_assoc($dres);
532->		$dres = mysqli_query($_SESSION['mconn'], $query);
533->		$drow = mysqli_fetch_assoc($dres);
541->		$dres = mysqli_query($_SESSION['mconn'], $query);
542->		$drow = mysqli_fetch_assoc($dres);
550->		$dres = mysqli_query($_SESSION['mconn'], $query);
551->		$drow = mysqli_fetch_assoc($dres);
574->	$dres = mysqli_query($_SESSION['mconn'], $query);
575->	$drow = mysqli_fetch_assoc($dres);
589->		$dres = mysqli_query($_SESSION['mconn'], $query);
590->		$drow = mysqli_fetch_assoc($dres);
597->		$dres = mysqli_query($_SESSION['mconn'], $query);
598->		$drow = mysqli_fetch_assoc($dres);
605->		$dres = mysqli_query($_SESSION['mconn'], $query);
606->		$drow = mysqli_fetch_assoc($dres);
629->	$dres = mysqli_query($_SESSION['mconn'], $query);
630->	$drow = mysqli_fetch_assoc($dres);
643->		$dres = mysqli_query($_SESSION['mconn'], $query);
644->		$drow = mysqli_fetch_assoc($dres);
651->		$dres = mysqli_query($_SESSION['mconn'], $query);
652->		$drow = mysqli_fetch_assoc($dres);
678->	$dres = mysqli_query($_SESSION['mconn'], $query);
679->	$drow = mysqli_fetch_assoc($dres);
694->		$dres = mysqli_query($_SESSION['mconn'], $query);
695->		$drow = mysqli_fetch_assoc($dres);
703->		$dres = mysqli_query($_SESSION['mconn'], $query);
704->		$drow = mysqli_fetch_assoc($dres);
712->		$dres = mysqli_query($_SESSION['mconn'], $query);
713->		$drow = mysqli_fetch_assoc($dres);
738->	$dres = mysqli_query($_SESSION['mconn'], $query);
739->	$drow = mysqli_fetch_assoc($dres);
754->		$dres = mysqli_query($_SESSION['mconn'], $query);
755->		$drow = mysqli_fetch_assoc($dres);
763->		$dres = mysqli_query($_SESSION['mconn'], $query);
764->		$drow = mysqli_fetch_assoc($dres);
772->		$dres = mysqli_query($_SESSION['mconn'], $query);
773->		$drow = mysqli_fetch_assoc($dres);
832->  $dres = mysqli_query($_SESSION['mconn'], $query);
834->  while($drow = mysqli_fetch_assoc($dres))
836->    $fromuser = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($drow['from'])."'"));
878->  $dres = mysqli_query($_SESSION['mconn'], $query);
880->  while($drow = mysqli_fetch_assoc($dres))
882->    $fromuser = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".$drow['to']."'"));


/home/gitRepos/CAcert/CAcert-devel/pages/account/52.php

22->	$res = mysqli_query($_SESSION['mconn'], $query);
23->	if(mysqli_num_rows($res) > 0)
25->		$row = mysqli_fetch_assoc($res);
29->                $rc2 = mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query2));
39->		$notary = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
41->		$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
70->	$res = mysqli_query($_SESSION['mconn'], $query);
71->	if(mysqli_num_rows($res) > 0)
80->	$res = mysqli_query($_SESSION['mconn'], $query);
81->	if(mysqli_num_rows($res) > 0)
84->		while($row = mysqli_fetch_assoc($res))
88->			$rc3 = mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query3));


/home/gitRepos/CAcert/CAcert-devel/pages/account/49.php

33->		$res = mysqli_query($_SESSION['mconn'], $query);
34->		if(mysqli_num_rows($res) >= 1) { ?>
40->	while($row = mysqli_fetch_assoc($res))
47-><? } if(mysqli_num_rows($res) >= 100) { ?>
53->    <td class="DataTD" colspan="3"><? printf(_("%s rows displayed."), mysqli_num_rows($res)); ?></td>
57-><?		} elseif(mysqli_num_rows($res) == 1) {
58->			$row = mysqli_fetch_assoc($res);
69->		$res = mysqli_query($_SESSION['mconn'], $query);
70->		if(mysqli_num_rows($res) >= 1) { ?>
76->	while($row = mysqli_fetch_assoc($res))
83-><? } if(mysqli_num_rows($res) >= 100) { ?>
89->    <td class="DataTD" colspan="3"><? printf(_("%s rows displayed."), mysqli_num_rows($res)); ?></td>
93-><?		} elseif(mysqli_num_rows($res) == 1) {
94->			$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/account/13.php

20->  $res = mysqli_query($_SESSION['mconn'], $query);
21->  $user = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/account/32.php

20->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
35->	$res = mysqli_query($_SESSION['mconn'], $query);
36->	while($row = mysqli_fetch_assoc($res))
38->		$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($row['memid'])."'"));


/home/gitRepos/CAcert/CAcert-devel/pages/account/29.php

20->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
22->	$org = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));


/home/gitRepos/CAcert/CAcert-devel/pages/account/22.php

40->    $reso = mysqli_query($_SESSION['mconn'], $query);
41->    if(mysqli_num_rows($reso) >= 1){
42->      while($row = mysqli_fetch_assoc($reso)){
110->  $res = mysqli_query($_SESSION['mconn'], $query);
111->  if(mysqli_num_rows($res) <= 0)
119->  while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/2.php

31->	$res = mysqli_query($_SESSION['mconn'], $query);
32->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/31.php

20->	$org = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));


/home/gitRepos/CAcert/CAcert-devel/pages/account/57.php

28->    $res = mysqli_query($_SESSION['mconn'], $query);
29->    if(mysqli_num_rows($res) <= 0)
33->      $row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/account/25.php

57->	$res = mysqli_query($_SESSION['mconn'], $query);
58->	while($row = mysqli_fetch_assoc($res))
60->		$r2 = mysqli_query($_SESSION['mconn'], "select * from `org` where `orgid`='".intval($row['id'])."'");
61->		$admincount = mysqli_num_rows($r2);
62->		$r2 = mysqli_query($_SESSION['mconn'], "select * from `orgdomains` where `orgid`='".intval($row['id'])."'");
63->		$domcount = mysqli_num_rows($r2);


/home/gitRepos/CAcert/CAcert-devel/pages/account/56.php

28->    $res = mysqli_query($_SESSION['mconn'], $query);
29->    while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/26.php

20->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
33->	$res = mysqli_query($_SESSION['mconn'], $query);
34->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/account/30.php

20->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
22->	$org = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));


/home/gitRepos/CAcert/CAcert-devel/pages/wot/1.php

19->        $res=mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select sum(acount) as summe from countries"));
32->		$loc = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `locations` where `id`='".$locid."'"));
41->		$reg = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `regions` where `id`='".$regid."'"));
50->		$cnt = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `countries` where `id`='".$ccid."'"));
63->		$res = mysqli_query($_SESSION['mconn'], $query);
64->		while($row = mysqli_fetch_assoc($res))
72->		$res = mysqli_query($_SESSION['mconn'], $query);
73->		while($row = mysqli_fetch_assoc($res))
81->		$res = mysqli_query($_SESSION['mconn'], $query);
82->		while($row = mysqli_fetch_assoc($res))
96->	$list = mysqli_query($_SESSION['mconn'], $query);
97->	if(mysqli_num_rows($list) > 0)
109-><? while($row = mysqli_fetch_assoc($list)) { ?>


/home/gitRepos/CAcert/CAcert-devel/pages/wot/10.php

31->	$res = mysqli_query($_SESSION['mconn'], $query);
32->	$row = mysqli_fetch_assoc($res);
43->	$rank = mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query)) + 1;
68->	$res = mysqli_query($_SESSION['mconn'], $query);
69->	while($row = mysqli_fetch_assoc($res))
71->		$fromuser = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($row['from'])."'"));
118->	$res = mysqli_query($_SESSION['mconn'], $query);
119->	while($row = mysqli_fetch_assoc($res))
121->		$fromuser = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($row['to'])."'"));


/home/gitRepos/CAcert/CAcert-devel/pages/wot/12.php

76->		$res = mysqli_query($_SESSION['mconn'], $query);
77->		if($reg != "" && $ccname == "" && mysqli_num_rows($res) <= 0)
83->			$res = mysqli_query($_SESSION['mconn'], $query);
85->		if(mysqli_num_rows($res) <= 0)
87->		$row = mysqli_fetch_assoc($res);
95->	$loc = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
111->	$res = mysqli_query($_SESSION['mconn'], $query);
120-><?	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/pages/wot/9.php

22->	$res = mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($_REQUEST['userid'])."' and `listme`='1'");
23->	if(mysqli_num_rows($res) <= 0)
28->		$user = mysqli_fetch_array($res);
30->		$points = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select sum(`points`) as `total` from `notary`
58->	$res = mysqli_query($_SESSION['mconn'], $query);
59->	while($row = mysqli_fetch_assoc($res))
61->		$lang = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `languages` where `locale`='${row['lang']}'"));


/home/gitRepos/CAcert/CAcert-devel/pages/wot/13.php

31->		$res = mysqli_query($_SESSION['mconn'], $query);
32->                if($reg != "" && $ccname == "" && mysqli_num_rows($res) <= 0)
38->                        $res = mysqli_query($_SESSION['mconn'], $query);
40->                if(mysqli_num_rows($res) <= 0)
43->		$row = mysqli_fetch_assoc($res);
49->	$res = mysqli_query($_SESSION['mconn'], $query);
50->	if(mysqli_num_rows($res) > 0)
52->		$loc = mysqli_fetch_assoc($res);
57->		mysqli_query($_SESSION['mconn'], $query);
65->	$res = mysqli_query($_SESSION['mconn'], $query);
66->	$loc = mysqli_fetch_assoc($res);
68->	$res = mysqli_query($_SESSION['mconn'], $query);
69->	$reg = mysqli_fetch_assoc($res);
71->	$res = mysqli_query($_SESSION['mconn'], $query);
72->	$cc = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/gpg/3.php

21->	$res = mysqli_query($_SESSION['mconn'], $query);
22->	if(mysqli_num_rows($res) <= 0)
28->	$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/pages/gpg/2.php

36->	$res = mysqli_query($_SESSION['mconn'], $query);
37->	if(mysqli_num_rows($res) <= 0)
44->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/stamp/report.php

57->		mysqli_query($_SESSION['mconn'], "insert into `abusereports` set `when`=NOW(), `IP`='$iplong', `url`='$refer', `name`='$name', `email`='$email',
59->		$id = mysqli_insert_id();


/home/gitRepos/CAcert/CAcert-devel/stamp/common.php

34->		$res = mysqli_query($_SESSION['mconn'], $query);
35->		if(mysqli_num_rows($res) > 0)
37->			$row = mysqli_fetch_assoc($res);
49->					$res = mysqli_query($_SESSION['mconn'], $query);
50->					if(mysqli_num_rows($res) > 0)
55->						mysqli_query($_SESSION['mconn'], $query);
71->		$res = mysqli_query($_SESSION['mconn'], $query);
72->		if(mysqli_num_rows($res) <= 0)
91->			$res = mysqli_query($_SESSION['mconn'], $query);
92->			if(mysqli_num_rows($res) <= 0)
104->				$res = mysqli_query($_SESSION['mconn'], $query);
105->				if(mysqli_num_rows($res) <= 0)
116->			$cert = mysqli_fetch_assoc($res);
121->				$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
124->				$orgi = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
137->			mysqli_query($_SESSION['mconn'], $query);
139->			mysqli_query($_SESSION['mconn'], "update `stampcache` set `cacheexpire`='".(date("U")+600)."' where `id`='$stampid'");
142->			mysqli_query($_SESSION['mconn'], $query);


/home/gitRepos/CAcert/CAcert-devel/includes/lib/general.php

40->	$res = mysqli_query($_SESSION['mconn'], $query);
41->	if(mysqli_num_rows($res) > 0)
43->		$row = mysqli_fetch_assoc($res);
142->		$query = mysqli_query($_SESSION['mconn'], 'SELECT * FROM `cats_passed` AS `tp`, `cats_variant` AS `cv` '.
144->		if(mysqli_num_rows($query) < 1)
149->		$query = mysqli_query($_SESSION['mconn'], 'SELECT SUM(`points`) AS `points` FROM `notary` AS `n` WHERE `n`.`to` = \''.(int)intval($userID).'\' AND `n`.`expire` < now()');
150->		$row = mysqli_fetch_assoc($query);
155->		$query = mysqli_query($_SESSION['mconn'], 'SELECT `assurer_blocked` FROM `users` WHERE `id` = \''.(int)intval($userID).'\'');
156->		$row = mysqli_fetch_assoc($query);


/home/gitRepos/CAcert/CAcert-devel/includes/lib/account.php

57->	$query = mysqli_query($_SESSION['mconn'], $sql);
92->	$query = mysqli_query($_SESSION['mconn'], $sql);


/home/gitRepos/CAcert/CAcert-devel/includes/general_stuff.php

72->	$res = mysqli_query($_SESSION['mconn'], $query);
73->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/includes/loggedin.php

46->		$_SESSION['profile'] = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='$uid'"));
72->			$_SESSION['profile'] = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], 
117->		$res = mysqli_query($_SESSION['mconn'], $query);
118->		$row = mysqli_fetch_assoc($res);
125->			mysqli_query($_SESSION['mconn'], $query);


/home/gitRepos/CAcert/CAcert-devel/includes/mysql.php.sample

19->	$_SESSION['mconn'] = mysqli_connect("127.0.0.1", "username", "password", "database");


/home/gitRepos/CAcert/CAcert-devel/includes/notary.inc.php

21->		return mysqli_query($_SESSION['mconn'], $query);
26->		$row1 = mysqli_fetch_assoc($res);
32->		return intval(mysqli_num_rows($resultset));
105->		return mysqli_fetch_assoc($res);
113->		return mysqli_num_rows($res);
389->		while($row = mysqli_fetch_assoc($res))
406->		while($row = mysqli_fetch_assoc($res))
487->		while($row = mysqli_fetch_assoc($res))
500->		while($row = mysqli_fetch_assoc($res))
639->		$res = mysqli_query($_SESSION['mconn'], $query);
652->		$res = mysqli_query($_SESSION['mconn'], $query);
653->		if(mysqli_num_rows($res) <=0){
673->		$res = mysqli_query($_SESSION['mconn'], $query);
674->		if(mysqli_num_rows($res) >0){
675->			$rec = mysqli_fetch_assoc($res);
692->		$res = mysqli_query($_SESSION['mconn'], $query);
693->		if(mysqli_num_rows($res) >0){
694->			$rec = mysqli_fetch_assoc($res);
715->		mysqli_query($_SESSION['mconn'], "delete from `user_agreements` where `memid`=" . intval($memid) . $filter );
817->		mysqli_query($_SESSION['mconn'], $query);
828->		mysqli_query($_SESSION['mconn'], 
850->		mysqli_query($_SESSION['mconn'], "update `users` set `password`=sha1('".$password."') where `id`='".$id."'");
854->		mysqli_query($_SESSION['mconn'], $query);
855->		$emailid = mysqli_insert_id();
859->		mysqli_query($_SESSION['mconn'], $query);
863->		$res=mysqli_query($_SESSION['mconn'], $query);
864->		while($row = mysqli_fetch_assoc($res)){
870->		$res=mysqli_query($_SESSION['mconn'], $query);
871->		while($row = mysqli_fetch_assoc($res)){
876->		mysqli_query($_SESSION['mconn'], 
886->		mysqli_query($_SESSION['mconn'], $query);
890->		mysqli_query($_SESSION['mconn'], $query);
894->		mysqli_query($_SESSION['mconn'], "update `users` set `language`='en_AU' where `id`='".$id."'");
896->		mysqli_query($_SESSION['mconn'], "delete from `addlang` where `userid`='".$id."'");
908->			mysqli_query($_SESSION['mconn'], $query);
913->		$details = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
916->		mysqli_query($_SESSION['mconn'], $query);
923->		mysqli_query($_SESSION['mconn'], $query);
926->		mysqli_query($_SESSION['mconn'], 
941->		mysqli_query($_SESSION['mconn'], "update `users` set `locked`='1' where `id`='$id'");  //, `deleted`=Now()
950->		$res = mysqli_query($_SESSION['mconn'], $query);
951->		return mysqli_num_rows($res) > 0;
963->		$res = mysqli_query($_SESSION['mconn'], $query);
964->		return mysqli_num_rows($res) > 0;
978->		$res = mysqli_query($_SESSION['mconn'], $query1);
979->		$r1 = mysqli_num_rows($res)>0;
980->		$res = mysqli_query($_SESSION['mconn'], $query2);
981->		$r2 = mysqli_num_rows($res)>0;
1014->		$res = mysqli_query($_SESSION['mconn'], $query1);
1015->		$r1 = mysqli_num_rows($res)>0;
1016->		$res = mysqli_query($_SESSION['mconn'], $query2);
1017->		$r2 = mysqli_num_rows($res)>0;
1025->		$res = mysqli_query($_SESSION['mconn'], $query);
1026->		return mysqli_num_rows($res) > 0;
1038->		$dres = mysqli_query($_SESSION['mconn'], $query);
1039->		while($drow = mysqli_fetch_assoc($dres)){
1040->			mysqli_query($_SESSION['mconn'], "update `emailcerts` set `revoked`='1970-01-01 10:00:01', `disablelogin`=1 where `id`='".$drow['id']."'");
1056->		$dres = mysqli_query($_SESSION['mconn'], $query);
1057->		while($drow = mysqli_fetch_assoc($dres))
1059->			mysqli_query($_SESSION['mconn'], 
1072->		$res=mysqli_query($_SESSION['mconn'], $query);
1073->		while($row = mysqli_fetch_assoc($res)){
1079->		$res=mysqli_query($_SESSION['mconn'], $query);
1080->		while($row = mysqli_fetch_assoc($res)){


/home/gitRepos/CAcert/CAcert-devel/includes/account_stuff.php

202-><? if(mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `org` where `memid`='".intval($_SESSION['profile']['id'])."'")) > 0 || $_SESSION['profile']['orgadmin'] == 1) { ?>
212-><? if(mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `org` where `memid`='".intval($_SESSION['profile']['id'])."'")) > 0 || $_SESSION['profile']['orgadmin'] == 1) { ?>


/home/gitRepos/CAcert/CAcert-devel/includes/general.php

82->		$locked = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select `locked` from `users` where `id`='".$_SESSION['profile']['id']."'"));
86->			$res = mysqli_query($_SESSION['mconn'], $query);
87->			$row = mysqli_fetch_assoc($res);
291->				$res = mysqli_query($_SESSION['mconn'], $query);
292->				if(mysqli_num_rows($res) > 0)
295->					$_SESSION['_config']['row'] = mysqli_fetch_assoc($res);
343->				$res = mysqli_query($_SESSION['mconn'], $query);
344->				if(mysqli_num_rows($res) > 0)
347->					$_SESSION['_config']['altrow'] = mysqli_fetch_assoc($res);
385->				$res = mysqli_query($_SESSION['mconn'], $query);
386->				if(mysqli_num_rows($res) > 0)
388->					$_SESSION['_config']['row'] = mysqli_fetch_assoc($res);
433->				$res = mysqli_query($_SESSION['mconn'], $query);
434->				if(mysqli_num_rows($res) > 0)
436->					$_SESSION['_config']['altrow'] = mysqli_fetch_assoc($res);
465->			$res = mysqli_query($_SESSION['mconn'], $query);
466->			if(mysqli_num_rows($res) > 0)
468->				$_SESSION['_config']['row'] = mysqli_fetch_assoc($res);
481->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
486->		if(mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query)) < 1)
585->					mysqli_query($_SESSION['mconn'], $query);
596->		mysqli_query($_SESSION['mconn'], $query);
617->			$res = mysqli_query($_SESSION['mconn'], $query);
618->			if(mysqli_num_rows($res) > 0)
630->			$res = mysqli_query($_SESSION['mconn'], $query);
633->			if(mysqli_num_rows($res) > 0)
660->		mysqli_query($_SESSION['mconn'], $query);
661->		$ticket = mysqli_insert_id();
789->	  * The resource returned by mysqli_query is
792->	  * It should be safe to replace every mysqli_query
793->	  * call by a mysqli_extended_query call.
799->		$res = mysqli_query($_SESSION['mconn'], $sql);


/home/gitRepos/CAcert/CAcert-devel/includes/account.php

150->		mysqli_query($_SESSION['mconn'], $query);
151->		$emailid = mysqli_insert_id();
170->		$res = mysqli_query($_SESSION['mconn'], $query);
171->		if(mysqli_num_rows($res) <= 0)
178->		$row = mysqli_fetch_assoc($res);
190->		mysqli_query($_SESSION['mconn'], $query);
215->				$res = mysqli_query($_SESSION['mconn'], $query);
216->				if(mysqli_num_rows($res) > 0)
218->					$row = mysqli_fetch_assoc($res);
324->				$res = mysqli_query($_SESSION['mconn'], "select * from `email` where `memid`='".$_SESSION['profile']['id']."' and `id`='".intval($id)."'");
325->				if(mysqli_num_rows($res) > 0)
327->					$row = mysqli_fetch_assoc($res);
343->			$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".$_SESSION['profile']['id']."'"));
388->			mysqli_query($_SESSION['mconn'], $query);
389->			$emailid = mysqli_insert_id();
392->				mysqli_query($_SESSION['mconn'], "insert into `emaillink` set `emailcertsid`='$emailid', `emailid`='$addy'");
407->			mysqli_query($_SESSION['mconn'], "update `emailcerts` set `csr_name`='$CSRname' where `id`='".intval($emailid)."'");
430->			$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($_SESSION['profile']['id'])."'"));
446->				$res = mysqli_query($_SESSION['mconn'], "select * from `email` where `memid`='".intval($_SESSION['profile']['id'])."' and `id`='".intval($id)."'");
447->				if(mysqli_num_rows($res) > 0)
449->					$row = mysqli_fetch_assoc($res);
489->			mysqli_query($_SESSION['mconn'], $query);
490->			$emailid = mysqli_insert_id();
493->				mysqli_query($_SESSION['mconn'], "insert into `emaillink` set `emailcertsid`='$emailid', `emailid`='".mysql_real_escape_string($addy)."'");
498->			mysqli_query($_SESSION['mconn'], "update `emailcerts` set `csr_name`='$CSRname' where `id`='$emailid'");
502->		$res = mysqli_query($_SESSION['mconn'], $query);
503->		if(mysqli_num_rows($res) <= 0)
542->		$res1 = mysqli_query($_SESSION['mconn'], "select * from `orgdomains` where `domain`='$newdomain'");
544->		$res2 = mysqli_query($_SESSION['mconn'], $query);
545->		if(mysqli_num_rows($res1) > 0 || mysqli_num_rows($res2))
627->		$res = mysqli_query($_SESSION['mconn'], $query);
628->		if(mysqli_num_rows($res) > 0)
654->		mysqli_query($_SESSION['mconn'], $query);
655->		$domainid = mysqli_insert_id();
682->				$res = mysqli_query($_SESSION['mconn'], $query);
683->				if(mysqli_num_rows($res) > 0)
685->					$row = mysqli_fetch_assoc($res);
824->		mysqli_query($_SESSION['mconn'], $query);
825->		$CSRid = mysqli_insert_id();
829->				mysqli_query($_SESSION['mconn'], "insert into `domlink` set `certid`='$CSRid', `domid`='$dom'");
832->			mysqli_query($_SESSION['mconn'], "insert into `domlink` set `certid`='$CSRid', `domid`='$dom'");
837->		mysqli_query($_SESSION['mconn'], "update `domaincerts` set `CSR_name`='$CSRname' where `id`='$CSRid'");
840->		$res = mysqli_query($_SESSION['mconn'], $query);
841->		if(mysqli_num_rows($res) <= 0)
871->				$res = mysqli_query($_SESSION['mconn'], $query);
872->				if(mysqli_num_rows($res) <= 0)
878->				$row = mysqli_fetch_assoc($res);
887->				mysqli_query($_SESSION['mconn'], "update `domaincerts` set `renewed`='1' where `id`='$id'");
899->				mysqli_query($_SESSION['mconn'], $query);
900->				$newid = mysqli_insert_id();
922->				mysqli_query($_SESSION['mconn'], "update `domaincerts` set `subject`='$subject',`csr_name`='$newfile' where `id`='$newid'");
927->				$res = mysqli_query($_SESSION['mconn'], $query);
928->				if(mysqli_num_rows($res) <= 0)
932->					$drow = mysqli_fetch_assoc($res);
962->				$res = mysqli_query($_SESSION['mconn'], $query);
963->				if(mysqli_num_rows($res) <= 0)
968->				$row = mysqli_fetch_assoc($res);
974->				mysqli_query($_SESSION['mconn'], "update `domaincerts` set `revoked`='1970-01-01 10:00:01' where `id`='$id'");
993->				$res = mysqli_query($_SESSION['mconn'], $query);
994->				if(mysqli_num_rows($res) <= 0)
999->				$row = mysqli_fetch_assoc($res);
1005->				mysqli_query($_SESSION['mconn'], "delete from `domaincerts` where `id`='$id'");
1024->				mysqli_query($_SESSION['mconn'], "update `domaincerts` set `description`='$comment' where `id`='$cid'");
1044->				$res = mysqli_query($_SESSION['mconn'], $query);
1045->				if(mysqli_num_rows($res) <= 0)
1051->				$row = mysqli_fetch_assoc($res);
1060->				mysqli_query($_SESSION['mconn'], "update `emailcerts` set `renewed`='1' where `id`='$id'");
1073->				mysqli_query($_SESSION['mconn'], $query);
1074->				$newid = mysqli_insert_id();
1077->				mysqli_query($_SESSION['mconn'], "update `emailcerts` set `csr_name`='$newfile' where `id`='$newid'");
1078->				$res = mysqli_query($_SESSION['mconn'], "select * from `emaillink` where `emailcertsid`='".$row['id']."'");
1079->				while($r2 = mysqli_fetch_assoc($res))
1081->					mysqli_query($_SESSION['mconn'], "insert into `emaillink` set `emailid`='".$r2['emailid']."',
1086->				$res = mysqli_query($_SESSION['mconn'], $query);
1087->				if(mysqli_num_rows($res) <= 0)
1118->				$res = mysqli_query($_SESSION['mconn'], $query);
1119->				if(mysqli_num_rows($res) <= 0)
1124->				$row = mysqli_fetch_assoc($res);
1130->				mysqli_query($_SESSION['mconn'], "update `emailcerts` set `revoked`='1970-01-01 10:00:01' where `id`='$id'");
1147->				$res = mysqli_query($_SESSION['mconn'], $query);
1148->				if(mysqli_num_rows($res) <= 0)
1153->				$row = mysqli_fetch_assoc($res);
1159->				mysqli_query($_SESSION['mconn'], "delete from `emailcerts` where `id`='$id'");
1178->				mysqli_query($_SESSION['mconn'], "update `emailcerts` set `disablelogin`='$dis' where `id`='$cid' and `memid`='".$_SESSION['profile']['id']."'");
1185->					mysqli_query($_SESSION['mconn'], "update `emailcerts` set `description`='$comment' where `id`='$cid' and `memid`='".$_SESSION['profile']['id']."'");
1260->		$ddres = mysqli_query($_SESSION['mconn'], $ddquery);
1261->		$ddrow = mysqli_fetch_assoc($ddres);
1300->			mysqli_query($_SESSION['mconn'], $query);
1314->			mysqli_query($_SESSION['mconn'], $query);
1324->			mysqli_query($_SESSION['mconn'], $query);
1328->		$_SESSION['profile'] = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".$_SESSION['profile']['id']."'"));
1332->		$ddres = mysqli_query($_SESSION['mconn'], $ddquery);
1333->		$ddrow = mysqli_fetch_assoc($ddres);
1365->				$match = mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".$_SESSION['profile']['id']."' and
1368->				$rc = mysqli_num_rows($match);
1386->				mysqli_query($_SESSION['mconn'], "update `users` set `password`=sha1('".$_SESSION['_config']['user']['pword1']."')
1537->			mysqli_query($_SESSION['mconn'], $query);
1538->			$emailid = mysqli_insert_id();
1541->				mysqli_query($_SESSION['mconn'], "insert into `domemaillink` set `emailcertsid`='$emailid', `emailid`='$addy'");
1557->			mysqli_query($_SESSION['mconn'], "update `orgemailcerts` set `csr_name`='$CSRname' where `id`='$emailid'");
1629->			mysqli_query($_SESSION['mconn'], $query);
1630->			$emailid = mysqli_insert_id();
1633->				mysqli_query($_SESSION['mconn'], "insert into `domemaillink` set `emailcertsid`='$emailid', `emailid`='$addy'");
1639->			mysqli_query($_SESSION['mconn'], "update `orgemailcerts` set `csr_name`='$CSRname' where `id`='$emailid'");
1643->		$res = mysqli_query($_SESSION['mconn'], $query);
1644->		if(mysqli_num_rows($res) <= 0)
1672->				$res = mysqli_query($_SESSION['mconn'], $query);
1673->				if(mysqli_num_rows($res) <= 0)
1679->				$row = mysqli_fetch_assoc($res);
1688->				mysqli_query($_SESSION['mconn'], "update `orgemailcerts` set `renewed`='1' where `id`='$id'");
1706->				mysqli_query($_SESSION['mconn'], $query);
1707->				$newid = mysqli_insert_id();
1710->				mysqli_query($_SESSION['mconn'], "update `orgemailcerts` set `csr_name`='$newfile' where `id`='$newid'");
1713->				$res = mysqli_query($_SESSION['mconn'], $query);
1714->				if(mysqli_num_rows($res) > 0)
1745->				$res = mysqli_query($_SESSION['mconn'], $query);
1746->				if(mysqli_num_rows($res) <= 0)
1751->				$row = mysqli_fetch_assoc($res);
1757->				mysqli_query($_SESSION['mconn'], "update `orgemailcerts` set `revoked`='1970-01-01 10:00:01' where `id`='$id'");
1775->				$res = mysqli_query($_SESSION['mconn'], $query);
1776->				if(mysqli_num_rows($res) <= 0)
1781->				$row = mysqli_fetch_assoc($res);
1787->				mysqli_query($_SESSION['mconn'], "delete from `orgemailcerts` where `id`='$id'");
1806->				mysqli_query($_SESSION['mconn'], "update `orgemailcerts` set `description`='$comment' where `id`='$cid'");
1872->		$_SESSION['_config']['CNorg'] = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
1878->		$_SESSION['_config']['SANorg'] = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
1936->		$org = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
1979->		mysqli_query($_SESSION['mconn'], $query);
1980->		$CSRid = mysqli_insert_id();
1985->		mysqli_query($_SESSION['mconn'], "update `orgdomaincerts` set `CSR_name`='$CSRname' where `id`='$CSRid'");
1988->				mysqli_query($_SESSION['mconn'], "insert into `orgdomlink` set `orgdomid`='$id', `orgcertid`='$CSRid'");
1991->				mysqli_query($_SESSION['mconn'], "insert into `orgdomlink` set `orgdomid`='$id', `orgcertid`='$CSRid'");
1994->		$res = mysqli_query($_SESSION['mconn'], $query);
1995->		if(mysqli_num_rows($res) <= 0)
2023->				$res = mysqli_query($_SESSION['mconn'], $query);
2024->				if(mysqli_num_rows($res) <= 0)
2030->				$row = mysqli_fetch_assoc($res);
2039->				mysqli_query($_SESSION['mconn'], "update `orgdomaincerts` set `renewed`='1' where `id`='$id'");
2055->				mysqli_query($_SESSION['mconn'], $query);
2056->				$newid = mysqli_insert_id();
2060->				mysqli_query($_SESSION['mconn'], "update `orgdomaincerts` set `csr_name`='$newfile' where `id`='$newid'");
2062->				$res = mysqli_query($_SESSION['mconn'], "select * from `orgdomlink` where `orgcertid`='".$row['id']."'");
2063->				while($r2 = mysqli_fetch_assoc($res))
2064->					mysqli_query($_SESSION['mconn'], "insert into `orgdomlink` set `orgdomid`='".$r2['id']."', `orgcertid`='$newid'");
2067->				$res = mysqli_query($_SESSION['mconn'], $query);
2068->				if(mysqli_num_rows($res) <= 0)
2072->					$drow = mysqli_fetch_assoc($res);
2101->				$res = mysqli_query($_SESSION['mconn'], $query);
2102->				if(mysqli_num_rows($res) <= 0)
2107->				$row = mysqli_fetch_assoc($res);
2113->				mysqli_query($_SESSION['mconn'], "update `orgdomaincerts` set `revoked`='1970-01-01 10:00:01' where `id`='$id'");
2133->				$res = mysqli_query($_SESSION['mconn'], $query);
2134->				if(mysqli_num_rows($res) <= 0)
2139->				$row = mysqli_fetch_assoc($res);
2145->				mysqli_query($_SESSION['mconn'], "delete from `orgdomaincerts` where `id`='$id'");
2164->				mysqli_query($_SESSION['mconn'], "update `orgdomaincerts` set `description`='$comment' where `id`='$cid'");
2214->			mysqli_query($_SESSION['mconn'], "insert into `orginfo` set `O`='".$_SESSION['_config']['O']."',
2242->			mysqli_query($_SESSION['mconn'], "update `orginfo` set `O`='".$_SESSION['_config']['O']."',
2259->		$res1 = mysqli_query($_SESSION['mconn'], "select * from `orgdomains` where `domain`='$domain'");
2260->		if(mysqli_num_rows($res1) > 0)
2276->		mysqli_query($_SESSION['mconn'], "insert into `orgdomains` set `orgid`='".intval($_SESSION['_config']['orgid'])."', `domain`='$domain'");
2288->		$res1 = mysqli_query($_SESSION['mconn'], "select * from `orgdomains` where `domain` like '$domain' and `id`!='".intval($domid)."'");
2289->		$res2 = mysqli_query($_SESSION['mconn'], "select * from `domains` where `domain` like '$domain' and `deleted`=0");
2290->		if(mysqli_num_rows($res1) > 0 || mysqli_num_rows($res2) > 0)
2304->		$res = mysqli_query($_SESSION['mconn'], $query);
2305->		while($row = mysqli_fetch_assoc($res))
2306->			mysqli_query($_SESSION['mconn'], "update `orgdomaincerts` set `revoked`='1970-01-01 10:00:01' where `id`='".$row['id']."'");
2312->		$res = mysqli_query($_SESSION['mconn'], $query);
2313->		while($row = mysqli_fetch_assoc($res))
2314->			mysqli_query($_SESSION['mconn'], "update `orgemailcerts` set `revoked`='1970-01-01 10:00:01' where `id`='".intval($row['id'])."'");
2319->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `orgdomains` where `id`='".intval($domid)."'"));
2320->		mysqli_query($_SESSION['mconn'], "update `orgdomains` set `domain`='$domain' where `id`='".intval($domid)."'");
2330->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `orgdomains` where `id`='".intval($domid)."'"));
2332->		mysqli_query($_SESSION['mconn'], "delete from `orgdomains` where `id`='".intval($domid)."'");
2349->		$dres = mysqli_query($_SESSION['mconn'], $query);
2350->		while($drow = mysqli_fetch_assoc($dres))
2356->			$res = mysqli_query($_SESSION['mconn'], $query);
2357->			while($row = mysqli_fetch_assoc($res))
2359->				mysqli_query($_SESSION['mconn'], "update `orgdomaincerts` set `revoked`='1970-01-01 10:00:01' where `id`='".intval($row['id'])."'");
2360->				mysqli_query($_SESSION['mconn'], "delete from `orgdomaincerts` where `orgid`='".intval($row['id'])."'");
2361->				mysqli_query($_SESSION['mconn'], "delete from `orgdomlink` where `domid`='".intval($row['id'])."'");
2368->			$res = mysqli_query($_SESSION['mconn'], $query);
2369->			while($row = mysqli_fetch_assoc($res))
2371->				mysqli_query($_SESSION['mconn'], "update `orgemailcerts` set `revoked`='1970-01-01 10:00:01' where `id`='".intval($row['id'])."'");
2372->				mysqli_query($_SESSION['mconn'], "delete from `orgemailcerts` where `id`='".intval($row['id'])."'");
2373->				mysqli_query($_SESSION['mconn'], "delete from `orgemaillink` where `domid`='".intval($row['id'])."'");
2376->		mysqli_query($_SESSION['mconn'], "delete from `org` where `orgid`='".intval($_SESSION['_config']['orgid'])."'");
2377->		mysqli_query($_SESSION['mconn'], "delete from `orgdomains` where `orgid`='".intval($_SESSION['_config']['orgid'])."'");
2378->		mysqli_query($_SESSION['mconn'], "delete from `orginfo` where `id`='".intval($_SESSION['_config']['orgid'])."'");
2390->		$_macc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query));
2403->		$is_orguser = mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query));
2417->		$res = mysqli_query($_SESSION['mconn'], $query);
2418->		if(mysqli_num_rows($res) <= 0)
2434->		$res = mysqli_query($_SESSION['mconn'], "select * from `users` where `email`='".$_REQUEST['email']."' and `deleted`=0");
2435->		if(mysqli_num_rows($res) <= 0)
2441->			$row = mysqli_fetch_assoc($res);
2449->				mysqli_query($_SESSION['mconn'], 
2463->		$res = mysqli_query($_SESSION['mconn'], "select * from `org` where `orgid`='$orgid' and `memid`='".$_SESSION['profile']['id']."' and `masteracc`='1'");
2464->		if(mysqli_num_rows($res) <= 0)
2473->		mysqli_query($_SESSION['mconn'], $query);
2485->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `alerts` where `memid`='".intval($_SESSION['profile']['id'])."'"));
2494->		$rc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `alerts` where `memid`='".intval($_SESSION['profile']['id'])."'"));
2509->		mysqli_query($_SESSION['mconn'], $query);
2522->				mysqli_query($_SESSION['mconn'], "update `users` set `language`='$lang' where `id`='".$_SESSION['profile']['id']."'");
2542->		mysqli_query($_SESSION['mconn'], "insert into `addlang` set `userid`='".intval($_SESSION['profile']['id'])."', `lang`='$addlang'");
2553->		mysqli_query($_SESSION['mconn'], "delete from `addlang` where `userid`='".intval($_SESSION['profile']['id'])."' and `lang`='$remove'");
2596->			mysqli_query($_SESSION['mconn'], $query);
2597->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `locations` where `id`='$locid'"));
2604->			mysqli_query($_SESSION['mconn'], $query);
2605->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `regions` where `id`='$regid'"));
2611->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select `ccid` from `regions` where `id`='$regid'"));
2614->			mysqli_query($_SESSION['mconn'], $query);
2620->			mysqli_query($_SESSION['mconn'], $query);
2621->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `locations` where `id`='$locid'"));
2626->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `locations` where `id`='$locid'"));
2628->			mysqli_query($_SESSION['mconn'], "delete from `localias` where `locid`='$locid'");
2629->			mysqli_query($_SESSION['mconn'], "delete from `locations` where `id`='$locid'");
2634->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `locations` where `id`='$locid'"));
2636->			mysqli_query($_SESSION['mconn'], "update `locations` set `regid`='$newreg' where `id`='$locid'");
2637->			mysqli_query($_SESSION['mconn'], "update `users` set `regid`='$newreg' where `regid`='$oldregid'");
2638->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `locations` where `id`='$locid'"));
2644->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `regions` where `id`='$regid'"));
2646->			mysqli_query($_SESSION['mconn'], "delete from `locations` where `regid`='$regid'");
2647->			mysqli_query($_SESSION['mconn'], "delete from `regions` where `id`='$regid'");
2656->			$row = mysqli_query($_SESSION['mconn'], "insert into `localias` set `locid`='$locid',`name`='$name'");
2661->			$row = mysqli_query($_SESSION['mconn'], "delete from `localias` where `locid`='$locid' and `name`='$name'");
2690->		$details = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2693->		mysqli_query($_SESSION['mconn'], $query);
2695->		mysqli_query($_SESSION['mconn'], $query);
2721->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($_REQUEST['userid'])."'"));
2735->			mysqli_query($_SESSION['mconn'], "update `users` set `password`=sha1('".mysql_real_escape_string(stripslashes($_REQUEST['newpass']))."') where `id`='".intval($_REQUEST['userid'])."'");
2736->			$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($_REQUEST['userid'])."'"));
2816->		mysqli_query($_SESSION['mconn'], $query);
2817->		$CSRid = mysqli_insert_id();
2820->			mysqli_query($_SESSION['mconn'], "insert into `domlink` set `certid`='$CSRid', `domid`='$dom'");
2823->			mysqli_query($_SESSION['mconn'], "insert into `domlink` set `certid`='$CSRid', `domid`='$dom'");
2829->		mysqli_query($_SESSION['mconn'], "update `domaincerts` set `CSR_name`='$CSRname' where `id`='$CSRid'");
2832->		$res = mysqli_query($_SESSION['mconn'], $query);
2833->		if(mysqli_num_rows($res) <= 0)
2850->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2852->		mysqli_query($_SESSION['mconn'], "update `users` set `tverify`='$ver' where `id`='$memid'");
2860->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2862->		mysqli_query($_SESSION['mconn'], "update `users` set `assurer`='$ver' where `id`='$memid'");
2869->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2871->		mysqli_query($_SESSION['mconn'], "update `users` set `assurer_blocked`='$ver' where `id`='$memid'");
2879->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2881->		mysqli_query($_SESSION['mconn'], "update `users` set `locked`='$ver' where `id`='$memid'");
2889->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2891->		mysqli_query($_SESSION['mconn'], "update `users` set `codesign`='$ver' where `id`='$memid'");
2899->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2901->		mysqli_query($_SESSION['mconn'], "update `users` set `orgadmin`='$ver' where `id`='$memid'");
2909->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2911->		mysqli_query($_SESSION['mconn'], "update `users` set `ttpadmin`='$ver' where `id`='$memid'");
2918->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2922->		mysqli_query($_SESSION['mconn'], "update `users` set `adadmin`='$ver' where `id`='$memid'");
2929->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2931->		mysqli_query($_SESSION['mconn'], "update `users` set `locadmin`='$ver' where `id`='$memid'");
2939->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2941->		mysqli_query($_SESSION['mconn'], "update `users` set `admin`='$ver' where `id`='$memid'");
2948->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2950->		mysqli_query($_SESSION['mconn'], "update `alerts` set `general`='$ver' where `memid`='$memid'");
2957->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2959->		mysqli_query($_SESSION['mconn'], "update `alerts` set `country`='$ver' where `memid`='$memid'");
2966->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2968->		mysqli_query($_SESSION['mconn'], "update `alerts` set `regional`='$ver' where `memid`='$memid'");
2975->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
2977->		mysqli_query($_SESSION['mconn'], "update `alerts` set `radius`='$ver' where `memid`='$memid'");
2985->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='".intval($_REQUEST['userid'])."'"));
3048->		$rc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query));
3061->		$rc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query));
3082->		mysqli_query($_SESSION['mconn'], $query);
3084->		$rc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `tverify-vote` where `tverify`='$uid' and `vote`='1'"));
3087->			mysqli_query($_SESSION['mconn'], "update `tverify` set `modified`=NOW() where `id`='$uid'");
3088->			$tverify = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `tverify` where `id`='$uid'"));
3090->			$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='$memid'"));
3091->			$tmp = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select sum(`points`) as `points` from `notary` where `to`='$memid'"));
3106->				mysqli_query($_SESSION['mconn'], "insert into `notary` set `from`='0', `to`='$memid', `points`='$points',
3113->			$res = mysqli_query($_SESSION['mconn'], "select * from `tverify-vote` where `tverify`='$uid' and `vote`='1'");
3114->			while($row = mysqli_fetch_assoc($res))
3123->		$rc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `tverify-vote` where `tverify`='$uid' and `vote`='-1'"));
3126->			mysqli_query($_SESSION['mconn'], "update `tverify` set `modified`=NOW() where `id`='$uid'");
3127->			$tverify = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `tverify` where `id`='$uid'"));
3129->			$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='$memid'"));
3132->			$res = mysqli_query($_SESSION['mconn'], "select * from `tverify-vote` where `tverify`='$uid' and `vote`='-1'");
3133->			while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/tverify/index/0.php

37->				$account = mysqli_query($_SESSION['mconn'], $query);
38->				if(mysqli_num_rows($account))
54->		$row = mysqli_fetch_assoc($account);
60-> 		$res = mysqli_query($_SESSION['mconn'], $query);
61-> 		$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/tverify/index.php

57->		$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='$memid'"));
58->		$tmp = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select sum(`points`) as `points` from `notary` where `to`='$memid'"));
91->		if(mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query)) <= 0)
97->			mysqli_query($_SESSION['mconn'], $query);
98->			$tverify = mysqli_insert_id();
105->				mysqli_query($_SESSION['mconn'], $query);
128->			mysqli_query($_SESSION['mconn'], "insert into `notary` set `from`='0', `to`='$memid', `points`='$points',
133->		mysqli_query($_SESSION['mconn'], "update `tverify` set `modified`=NOW() where `id`='$tverify'");


/home/gitRepos/CAcert/CAcert-devel/www/ac.php

38->	$res = mysqli_query($_SESSION['mconn'], $query);
39->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/www/advertising.php

76->		mysqli_query($_SESSION['mconn'], $query);


/home/gitRepos/CAcert/CAcert-devel/www/verify.php

49->		$res = mysqli_query($_SESSION['mconn'], $query);
50->		if(mysqli_num_rows($res) > 0)
52->			$row = mysqli_fetch_assoc($res);
56->				mysqli_query($_SESSION['mconn'], "update `email` set `hash`='', `attempts`='$row[attempts]', `deleted`=NOW() where `id`='$emailid'");
62->			mysqli_query($_SESSION['mconn'], "update `email` set `attempts`='$row[attempts]' where `id`='$emailid'");
66->		$res = mysqli_query($_SESSION['mconn'], $query);
67->		if(mysqli_num_rows($res) <= 0)
74->		$row = mysqli_fetch_assoc($res);
78->			mysqli_query($_SESSION['mconn'], $query);
80->			mysqli_query($_SESSION['mconn'], $query);
107->		$res = mysqli_query($_SESSION['mconn'], $query);
108->		if(mysqli_num_rows($res) > 0)
110->			$row = mysqli_fetch_assoc($res);
121->			mysqli_query($_SESSION['mconn'], $query);
125->		$res = mysqli_query($_SESSION['mconn'], $query);
126->		if(mysqli_num_rows($res) <= 0)
133->		$row = mysqli_fetch_assoc($res);
137->			mysqli_query($_SESSION['mconn'], $query);


/home/gitRepos/CAcert/CAcert-devel/www/sqldump.php

28->    $tables = mysqli_query($_SESSION['mconn'], "SHOW TABLES");
29->    while(list($table_name) = mysqli_fetch_array($tables))
35->        $create = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "SHOW CREATE TABLE `$table_name`"));


/home/gitRepos/CAcert/CAcert-devel/www/rss.php

15->	$res = mysqli_query($_SESSION['mconn'], $query);
16->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/www/api/edu.php

27->    $query= mysqli_query($_SESSION['mconn'], $sql);
28->    if(mysqli_num_rows($query) != 1)
34->      $memid = mysqli_fetch_assoc($query);


/home/gitRepos/CAcert/CAcert-devel/www/api/cemails.php

22->	$res = mysqli_query($_SESSION['mconn'], $query);
23->	if(mysqli_num_rows($res) != 1)
26->	$user = mysqli_fetch_assoc($res);
29->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
44->	$res = mysqli_query($_SESSION['mconn'], $query);
45->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/www/api/ccsr.php

25->	$res = mysqli_query($_SESSION['mconn'], $query);
26->	if(mysqli_num_rows($res) != 1)
28->	$user = mysqli_fetch_assoc($res);
35->		$res = mysqli_query($_SESSION['mconn'], $query);
36->		if(mysqli_num_rows($res) > 0)
38->			$row = mysqli_fetch_assoc($res);
46->	$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
88->	mysqli_query($_SESSION['mconn'], $query);
89->	$certid = mysqli_insert_id();
93->	mysqli_query($_SESSION['mconn'], "update `emailcerts` set `csr_name`='$CSRname' where `id`='$certid'");
96->		mysqli_query($_SESSION['mconn'], "insert into `emaillink` set `emailcertsid`='$certid', `emailid`='$emailid'");
101->	$res = mysqli_query($_SESSION['mconn'], $query);
102->	if(mysqli_num_rows($res) <= 0)
104->	$cert = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/www/index.php

122->				mysqli_query($_SESSION['mconn'], $query) || die(mysqli_error());
139->		$res = mysqli_query($_SESSION['mconn'], $query);
140->		if(mysqli_num_rows($res) <= 0)
147->			$_SESSION['lostpw']['user'] = mysqli_fetch_assoc($res);
159->			$_SESSION['profile'] = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], 
258->		$res = mysqli_query($_SESSION['mconn'], $query);
259->		if(mysqli_num_rows($res) <= 0)
262->			$otpres = mysqli_query($_SESSION['mconn'], $otpquery);
263->			if(mysqli_num_rows($otpres) > 0)
265->				$otp = mysqli_fetch_assoc($otpres);
278->				mysqli_query($_SESSION['mconn'], $query);
281->				if(mysqli_num_rows(mysqli_query($_SESSION['mconn'], $query)) <= 0)
284->					mysqli_query($_SESSION['mconn'], $query);
300->							$res = mysqli_query($_SESSION['mconn'], $otpquery);
305->		if(mysqli_num_rows($res) > 0)
309->			$_SESSION['profile'] = mysqli_fetch_assoc($res);
311->			mysqli_query($_SESSION['mconn'], $query);
317->				mysqli_query($_SESSION['mconn'], $query);
323->			$res = mysqli_query($_SESSION['mconn'], $query);
324->			$row = mysqli_fetch_assoc($res);
345->		$res = mysqli_query($_SESSION['mconn'], $query);
346->		if(mysqli_num_rows($res) <= 0)
475->			$res1 = mysqli_query($_SESSION['mconn'], $query);
478->			$res2 = mysqli_query($_SESSION['mconn'], $query);
479->			if(mysqli_num_rows($res1) > 0 || mysqli_num_rows($res2) > 0)
486->			$res = mysqli_query($_SESSION['mconn'], $query);
487->			if(mysqli_num_rows($res) > 0)
489->				$domain = mysqli_fetch_assoc($res);
534->			mysqli_query($_SESSION['mconn'], $query);
535->			$memid = mysqli_insert_id();
540->			mysqli_query($_SESSION['mconn'], $query);
541->			$emailid = mysqli_insert_id();
547->			mysqli_query($_SESSION['mconn'], $query);


/home/gitRepos/CAcert/CAcert-devel/www/gpg.php

77->	if(mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `email` where `memid`='".$_SESSION['profile']['id']."' and `email`='".mysql_real_escape_string($email)."' and `deleted`=0 and `hash`=''")) > 0) return 1;
321->		mysqli_query($_SESSION['mconn'], $query);
322->		$insert_id = mysqli_insert_id();
524->		mysqli_query($_SESSION['mconn'], "update `gpg` set `csr`='$csrname' where `id`='$insert_id'");
530->		$res = mysqli_query($_SESSION['mconn'], $query);
531->		if(mysqli_num_rows($res) <= 0)
554->				mysqli_query($_SESSION['mconn'], "update `gpg` set `description`='$comment' where `id`='$cid' and `memid`='".$_SESSION['profile']['id']."'");


/home/gitRepos/CAcert/CAcert-devel/www/stats.php

28->		$res = mysqli_query($_SESSION['mconn'], $sql);
29->		if ($res && mysqli_numrows($res) > 0) {
30->			$ar = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/www/wot.php

186->		$res = mysqli_query($_SESSION['mconn'], $query);
187->		if(mysqli_num_rows($res) != 1)
195->			$_SESSION['_config']['notarise'] = mysqli_fetch_assoc($res);
203->		$res = mysqli_query($_SESSION['mconn'], $query);
204->		if(mysqli_num_rows($res) >= 1)
229->		$res = mysqli_query($_SESSION['mconn'], $query);
230->		if(mysqli_num_rows($res) > 0)
314->		$res = mysqli_query($_SESSION['mconn'], $query);
315->		$row = mysqli_fetch_assoc($res);
336->		$res = mysqli_query($_SESSION['mconn'], $query);
337->		$drow = mysqli_fetch_assoc($res);
356->		$res = mysqli_query($_SESSION['mconn'], $query);
357->		if(mysqli_num_rows($res) > 0)
380->		mysqli_query($_SESSION['mconn'], $query);
398->			mysqli_query($_SESSION['mconn'], $query);
490->		mysqli_query($_SESSION['mconn'], $query);
510->			$user = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='$userid' and `listme`=1"));
511->			$points = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select sum(`points`) as `total` from `notary`


/home/gitRepos/CAcert/CAcert-devel/www/disputes.php

32->		$res = mysqli_query($_SESSION['mconn'], "select * from `disputeemail` where `id`='$emailid' and `hash`='$hash'");
33->		if(mysqli_num_rows($res) <= 0)
40->		$row = mysqli_fetch_assoc($res);
45->			mysqli_query($_SESSION['mconn'], "update `disputeemail` set hash='',action='reject' where `id`='".intval($emailid)."'");
57->			$res = mysqli_query($_SESSION['mconn'], $query);
58->			if(mysqli_num_rows($res) > 0)
60->				$row = mysqli_fetch_assoc($res);
64->			mysqli_query($_SESSION['mconn'], "update `disputeemail` set hash='',action='accept' where `id`='$emailid'");
65->			$rc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `domains` where `memid`='$oldmemid' and `deleted`=0"));
66->			$rc2 = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `email` where `memid`='$oldmemid' and `deleted`=0 and `id`!='$emailid'"));
67->			$res = mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='$oldmemid'");
68->			$user = mysqli_fetch_assoc($res);
71->				mysqli_query($_SESSION['mconn'], "update `users` set `deleted`=NOW() where `id`='$oldmemid'");
92->		$res = mysqli_query($_SESSION['mconn'], "select * from `disputeemail` where `id`='$emailid' and `hash`='$hash'");
93->		if(mysqli_num_rows($res) <= 0)
95->			$res = mysqli_query($_SESSION['mconn'], "select * from `disputeemail` where `id`='$emailid' and hash!=''");
96->			if(mysqli_num_rows($res) > 0)
98->				$row = mysqli_fetch_assoc($res);
99->				mysqli_query($_SESSION['mconn'], "update `disputeemail` set `attempts`='".intval($row['attempts'] + 1)."' where `id`='".$row['id']."'");
104->					mysqli_query($_SESSION['mconn'], "update `disputeemail` set hash='',action='failed' where `id`='$emailid'");
118->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `disputeemail` where `id`='$emailid'"));
131->		$res = mysqli_query($_SESSION['mconn'], "select * from `disputedomain` where `id`='$domainid' and `hash`='$hash'");
132->		if(mysqli_num_rows($res) <= 0)
142->			mysqli_query($_SESSION['mconn'], "update `disputedomain` set hash='',action='reject' where `id`='$domainid'");
155->			$res = mysqli_query($_SESSION['mconn'], $query);
156->			if(mysqli_num_rows($res) > 0)
161->			mysqli_query($_SESSION['mconn'], "update `disputedomain` set hash='',action='accept' where `id`='$domainid'");
179->		$res = mysqli_query($_SESSION['mconn'], "select * from `disputedomain` where `id`='$domainid' and `hash`='$hash'");
180->		if(mysqli_num_rows($res) <= 0)
182->			$res = mysqli_query($_SESSION['mconn'], "select * from `disputedomain` where `id`='$domainid' and hash!=''");
183->			if(mysqli_num_rows($res) > 0)
185->				$row = mysqli_fetch_assoc($res);
186->				mysqli_query($_SESSION['mconn'], "update `disputedomain` set `attempts`='".intval($row['attempts'] + 1)."' where `id`='".$row['id']."'");
191->					mysqli_query($_SESSION['mconn'], "update `disputedomain` set hash='',action='failed' where `id`='$domainid'");
205->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `disputedomain` where `id`='$domainid'"));
226->		$res = mysqli_query($_SESSION['mconn'], "select 1 from `email`, `users` where `email`.`email`='$email' and `email`.`memid`=`users`.`id` and (`users`.`assurer_blocked`=1 or `users`.`locked`=1)");
227->		if(mysqli_num_rows($res) > 0)
242->		$res = mysqli_query($_SESSION['mconn'], "select * from `disputeemail` where `email`='$email' and hash!=''");
243->		if(mysqli_num_rows($res) > 0)
253->		$res = mysqli_query($_SESSION['mconn'], $query);
254->		if(mysqli_num_rows($res) <= 0)
261->		$row = mysqli_fetch_assoc($res);
272->		$res = mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='$oldmemid'");
273->		$user = mysqli_fetch_assoc($res);
274->		$rc = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `domains` where `memid`='$oldmemid' and `deleted`=0"));
275->		$rc2 = mysqli_num_rows(mysqli_query($_SESSION['mconn'], "select * from `email` where `memid`='$oldmemid' and `deleted`=0 and `id`!='$emailid'"));
288->		mysqli_query($_SESSION['mconn'], $query);
315->		$res = mysqli_query($_SESSION['mconn'], "select 1 from `domains`, `users` where `domains`.`domain`='$domain' and `domains`.`memid`=`users`.`id` and (`users`.`assurer_blocked`=1 or `users`.`locked`=1)");
316->		if(mysqli_num_rows($res) > 0)
332->		$res = mysqli_query($_SESSION['mconn'], $query);
333->		if(mysqli_num_rows($res) > 0)
342->		$res = mysqli_query($_SESSION['mconn'], $query);
343->		if(mysqli_num_rows($res) <= 0)
346->			$res = mysqli_query($_SESSION['mconn'], $query);
347->			if(mysqli_num_rows($res) > 0)
359->		$row = mysqli_fetch_assoc($res);
432->                $res = mysqli_query($_SESSION['mconn'], $query);
433->                if(mysqli_num_rows($res) <= 0)
449->		mysqli_query($_SESSION['mconn'], $query);


/home/gitRepos/CAcert/CAcert-devel/www/cats/cats_import.php

88->$query = mysqli_query($_SESSION['mconn'], 'SELECT `id` FROM `cats_type` WHERE `type_text` = \''.mysql_real_escape_string($type).'\';');
95->if (mysqli_num_rows($query) > 0) {
96->  $result = mysqli_fetch_array($query);
99->  $query = mysqli_query($_SESSION['mconn'], 'INSERT INTO `cats_type` (`type_text`) VALUES (\''.mysql_real_escape_string($type).'\');');
106->  $typeID = mysqli_insert_id();
109->$query = mysqli_query($_SESSION['mconn'], 'SELECT `id` FROM `cats_variant` WHERE `type_id` = \''.(int)intval($typeID).'\' AND `test_text` = \''.mysql_real_escape_string($variant).'\';');
116->if (mysqli_num_rows($query) > 0) {
117->  $result = mysqli_fetch_array($query);
120->  $query = mysqli_query($_SESSION['mconn'], 'INSERT INTO `cats_variant` (`type_id`, `test_text`) VALUES (\''.(int)intval($typeID).'\', \''.mysql_real_escape_string($variant).'\');');
127->  $variantID = mysqli_insert_id();
131->$query = mysqli_query($_SESSION['mconn'], '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 (mysqli_num_rows($query) > 0) {
139->  $result = mysqli_fetch_array($query);
144->  trigger_error('Cannot find cert '.$serial.' / '.$root.'!'.mysqli_error(), E_USER_ERROR);
149->$query = mysqli_query($_SESSION['mconn'], 'INSERT INTO `cats_passed` (`user_id`, `variant_id`, `pass_date`) VALUES (\''.(int)intval($userID).'\', \''.(int)intval($variantID).'\', \''.mysql_real_escape_string($date).'\');');
151->  if (mysqli_errno() != 1062) { // Duplicate Entry is considered success


/home/gitRepos/CAcert/CAcert-devel/www/news.php

28->		$row = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], $query));
36->		$res = mysqli_query($_SESSION['mconn'], $query);
37->		while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/www/account.php

59->		$res = mysqli_query($_SESSION['mconn'], $query);
60->		if(mysqli_num_rows($res))
62->			$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/www/alert_hash_collision.php

17->  mysqli_query($_SESSION['mconn'], "update emailcerts set coll_found=1 where memid='".mysql_real_escape_string(substr(@$_POST['usernym'],4))."' and pkhash!='' and pkhash='".$_POST['pkhash']."';");
18->  mysqli_query($_SESSION['mconn'], "update domaincerts set coll_found=1 where memid='".mysql_real_escape_string(substr(@$_POST['usernym'],4))."' and pkhash!='' and pkhash='".$_POST['pkhash']."';");
22->  mysqli_query($_SESSION['mconn'], "update orgemailcerts set coll_found=1 where memid='".mysql_real_escape_string(substr(@$_POST['usernym'],4))."' and pkhash!='' and pkhash='".$_POST['pkhash']."';");
23->  mysqli_query($_SESSION['mconn'], "update orgdomaincerts set coll_found=1 where memid='".mysql_real_escape_string(substr(@$_POST['usernym'],4))."' and pkhash!='' and pkhash='".$_POST['pkhash']."';");


/home/gitRepos/CAcert/CAcert-devel/scripts/cron/permissionreview.php

120->	if(! $res = mysqli_query($_SESSION['mconn'], $query) ) {
124->				mysqli_error()
132->	while ($row = mysqli_fetch_assoc($res)) {


/home/gitRepos/CAcert/CAcert-devel/scripts/cron/updatesort.php

29->	mysqli_query($_SESSION['mconn'], "update `locations` set `acount`=0");
33->	$res = mysqli_query($_SESSION['mconn'], $query);
34->	while($row = mysqli_fetch_assoc($res))
38->		mysqli_query($_SESSION['mconn'], $query);
42->	mysqli_query($_SESSION['mconn'], "update `regions` set `acount`=0");
46->	$res = mysqli_query($_SESSION['mconn'], $query);
47->	while($row = mysqli_fetch_assoc($res))
51->		mysqli_query($_SESSION['mconn'], $query);
57->	mysqli_query($_SESSION['mconn'], "update `countries` set `acount`=0");
61->	$res = mysqli_query($_SESSION['mconn'], $query);
62->	while($row = mysqli_fetch_assoc($res))
66->		mysqli_query($_SESSION['mconn'], $query);


/home/gitRepos/CAcert/CAcert-devel/scripts/cron/removedead.php

26->	$res = mysqli_query($_SESSION['mconn'], $query);
27->	while($row = mysqli_fetch_assoc($res))
29->		mysqli_query($_SESSION['mconn'], "delete from `email` where `memid`='".$row['id']."'");
30->		mysqli_query($_SESSION['mconn'], "delete from `users` where `id`='".$row['id']."'");
36->	mysqli_query($_SESSION['mconn'], $query);
40->	mysqli_query($_SESSION['mconn'], $query);
44->	mysqli_query($_SESSION['mconn'], $query);
48->	mysqli_query($_SESSION['mconn'], $query);
54->	$res = mysqli_query($_SESSION['mconn'], $query);
55->	while($row = mysqli_fetch_assoc($res))
58->		$dres = mysqli_query($_SESSION['mconn'], $query);
59->		$drow = mysqli_fetch_assoc($dres);
66->			mysqli_query($_SESSION['mconn'], $query);
70->		$data = mysqli_fetch_assoc(mysqli_query($_SESSION['mconn'], "select * from `users` where `id`='$row[to]'"));
87->		mysqli_query($_SESSION['mconn'], $query);


/home/gitRepos/CAcert/CAcert-devel/scripts/scanforexponents.php

55->			$res = mysqli_query($_SESSION['mconn'], $query);
56->			if(mysqli_num_rows($res) <= 0)
63->			$row = mysqli_fetch_assoc($res);
71->			$res = mysqli_query($_SESSION['mconn'], $query);
72->			if(mysqli_num_rows($res) <= 0)
79->			$row = mysqli_fetch_assoc($res);
87->			$res = mysqli_query($_SESSION['mconn'], $query);
88->			if(mysqli_num_rows($res) <= 0)
95->			$row = mysqli_fetch_assoc($res);
103->			$res = mysqli_query($_SESSION['mconn'], $query);
104->			if(mysqli_num_rows($res) <= 0)
111->			$row = mysqli_fetch_assoc($res);


/home/gitRepos/CAcert/CAcert-devel/scripts/country.php

23->	$res = mysqli_query($_SESSION['mconn'], $query);
24->	while($row = mysqli_fetch_assoc($res))


/home/gitRepos/CAcert/CAcert-devel/scripts/gpgcheck3.php

71->	$res = mysqli_query($_SESSION['mconn'], "SELECT id, memid FROM gpg WHERE crt != ''");
78->	while ($row = mysqli_fetch_row($res)) {
81->	mysqli_free_result($res);
90->		$res = mysqli_query($_SESSION['mconn'], "SELECT fname, mname, lname, suffix FROM users WHERE id = " . $key[1]);
95->		$user = mysqli_fetch_assoc($res);
100->		mysqli_free_result($res);
102->		$res = mysqli_query($_SESSION['mconn'], "SELECT email FROM email WHERE hash = '' AND memid = " . $key[1]);
108->		while ($addr = mysqli_fetch_row($res)) {
111->		mysqli_free_result($res);


/home/gitRepos/CAcert/CAcert-devel/scripts/gpgfillmissingkeyid.php

30->	$res = mysqli_query($_SESSION['mconn'], "SELECT * FROM gpg WHERE crt != '' and keyid is null");
38->	while ($row = mysqli_fetch_assoc($res)) {
57->					mysqli_query($_SESSION['mconn'], "update gpg set keyid='$bits[4]' where id=$row[id]\n");
69->	mysqli_free_result($res);


/home/gitRepos/CAcert/CAcert-devel/scripts/consistence.php

25->	$res = mysqli_query($_SESSION['mconn'], $query);
26->	while($row = mysqli_fetch_assoc($res))
30->		//mysqli_query($_SESSION['mconn'], $query);
37->	$res = mysqli_query($_SESSION['mconn'], $query);
38->	while($row = mysqli_fetch_assoc($res))
42->		//mysqli_query($_SESSION['mconn'], $query);
48->	$res = mysqli_query($_SESSION['mconn'], $query);
49->	echo mysqli_error();
50->	while($row = mysqli_fetch_assoc($res))
56->		if($row['regid']=="1182") mysqli_query($_SESSION['mconn'], $query);
62->	mysqli_query($_SESSION['mconn'], "update `locations` set `acount`=0");
66->	$res = mysqli_query($_SESSION['mconn'], $query);
67->	while($row = mysqli_fetch_assoc($res))
71->		mysqli_query($_SESSION['mconn'], $query);
75->	mysqli_query($_SESSION['mconn'], "update `regions` set `acount`=0");
79->	$res = mysqli_query($_SESSION['mconn'], $query);
80->	while($row = mysqli_fetch_assoc($res))
84->		mysqli_query($_SESSION['mconn'], $query);
90->	mysqli_query($_SESSION['mconn'], "update `countries` set `acount`=0");
94->	$res = mysqli_query($_SESSION['mconn'], $query);
95->	while($row = mysqli_fetch_assoc($res))
99->		mysqli_query($_SESSION['mconn'], $query);