Alternc  3.2
Alternc logiel libre pour l'h├ębergement
 All Data Structures Namespaces Files Functions Variables Pages
adm_dnsweberror.php
Go to the documentation of this file.
1 <?php
2 /*
3  $Id: adm_dnsweberror.php,v 1.4 2004/11/29 17:27:04 anonymous Exp $
4  ----------------------------------------------------------------------
5  AlternC - Web Hosting System
6  Copyright (C) 2002 by the AlternC Development Team.
7  http://alternc.org/
8  ----------------------------------------------------------------------
9  Based on:
10  Valentin Lacambre's web hosting softwares: http://altern.org/
11  ----------------------------------------------------------------------
12  LICENSE
13 
14  This program is free software; you can redistribute it and/or
15  modify it under the terms of the GNU General Public License (GPL)
16  as published by the Free Software Foundation; either version 2
17  of the License, or (at your option) any later version.
18 
19  This program is distributed in the hope that it will be useful,
20  but WITHOUT ANY WARRANTY; without even the implied warranty of
21  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
22  GNU General Public License for more details.
23 
24  To read the license please visit http://www.gnu.org/copyleft/gpl.html
25  ----------------------------------------------------------------------
26  Original Author of file: Alan Garcia
27  Purpose of file: Report domains and websites having error in the DB
28  ----------------------------------------------------------------------
29 */
30 require_once("../class/config.php");
31 
32 if (!$admin->enabled) {
33  __("This page is restricted to authorized staff");
34  exit();
35 }
36 
37 include_once("head.php");
38 
39 ?>
40 <h3><?php __("Domains and Websites having errors"); ?></h3>
41 <hr id="topbar" />
42  <br />
43 <?php
44  if (isset($error) && $error) {
45  echo "<p class=\"alert alert-danger\">$error</p>";
46  }
47 
48 ?>
49 <br/>
50 <h3><?php __("List of the websites having errors in the domain database."); ?></h3>
51 <table class="tlist">
52  <tr>
53  <th><?php __("Uid"); ?></th>
54  <th><?php __("Account"); ?></th>
55  <th><?php __("Domain name"); ?></th>
56  <th><?php __("FQDN"); ?></th>
57  <th><?php __("Value"); ?></th>
58  <th><?php __("Description"); ?></th>
59  <th><?php __("Web Result field"); ?></th>
60  </tr>
61 
62 <?php
64 $db->query("select sd.compte, m.login, sd.domaine, if(length(sub)>0,concat_ws('.',sd.sub,sd.domaine),sd.domaine) as fqdn, sd.valeur, dt.description, sd.web_result from sub_domaines sd,membres m, domaines_type dt where sd.web_action='OK' and length(sd.web_result)<>0 and upper(dt.name)=upper(sd.type) order by sd.domaine, sd.sub, sd.valeur;");
65 
66 while($db->next_record()) { ?>
67 <tr class="lst">
68  <td><?php echo $db->f('compte');?></td>
69  <td><?php echo $db->f('login');?> </td>
70  <td><?php echo $db->f('domaine');?> </td>
71  <td><?php echo $db->f('fqdn');?></td>
72  <td><?php echo $db->f('valeur');?></td>
73  <td><?php echo $db->f('description');?></td>
74  <td><?php echo $db->f('web_result');?></td>
75 </tr>
76 <?php } // end while ?>
77 </table>
78 <hr/>
79 
80 <h3><?php __("List of the domain names having errors in the domain database."); ?></h3>
81 <table class="tlist">
82  <tr>
83  <th><?php __("Uid"); ?></th>
84  <th><?php __("Account"); ?></th>
85  <th><?php __("Domain name"); ?></th>
86  <th><?php __("DNS Result field"); ?></th>
87  </tr>
88 
89 <?php
90 $pair=0;
91 $db->query("select d.compte, m.login, d.domaine, d.dns_result from domaines d, membres m where d.dns_action='OK' and dns_result <> 0 and dns_result <> '' and m.uid = d.compte;");
92 
93 while($db->next_record()) { ?>
94 <tr class="lst">
95  <td><?php echo $db->f('compte');?></td>
96  <td><?php echo $db->f('login');?> </td>
97  <td><?php echo $db->f('domaine');?> </td>
98  <td><?php echo $db->f('dns_result');?></td>
99 </tr>
100 <?php } // end while ?>
101 </table>
102 <?php include_once("foot.php"); ?>