home *** CD-ROM | disk | FTP | other *** search
/ Chip 2004 October / CMCD1004.ISO / Software / Shareware / Programare / cnstats / reports / config.php < prev    next >
Encoding:
PHP Script  |  2004-06-19  |  8.1 KB  |  196 lines

  1. <?php
  2. $action=$HTTP_GET_VARS["action"];
  3. $filter=$HTTP_GET_VARS["filter"];
  4.  
  5. if ($action==2) {
  6.     $start=intval($HTTP_GET_VARS["start"]);
  7.     $n=intval($HTTP_GET_VARS["n"]);
  8.     $per=intval($HTTP_GET_VARS["per"]);
  9.     if ($per<500) $per=500;
  10.  
  11. ?>
  12. <HTML>
  13. <HEAD>
  14. <TITLE>Reading file GeoIPCountryWhois.csv from <?=$start;?></TITLE>
  15. <STYLE>
  16. body {font-family:tahoma;font-size:11px;}
  17. </STYLE>
  18. </HEAD>
  19. <BODY>
  20. <?php
  21.     $fw=@fopen("GeoIPCountryWhois.csv","rt");
  22.     if (!$fw) {
  23.         print $LANG["geoipnotfound"];
  24.         exit;
  25.         }
  26.     if ($start==0) {
  27.         cnstats_sql_query("DELETE FROM cns_countries;");
  28.         }
  29.     else fseek($fw,$start,SEEK_SET);
  30.  
  31.     $str=0;
  32.     while (!feof($fw)) {
  33.         $d=fgets($fw,1024);
  34.         $e=explode(",",$d);
  35.         $tld=substr($e[4],1,-1);
  36.         $e[4]=ord($e[4][1])*256+ord($e[4][2]);
  37.         $e[0]=substr($e[0],1,-1);
  38.         $e[1]=substr($e[1],1,-1);
  39.         if ($e[4]!=0) {
  40.             $sql="INSERT INTO cns_countries SET c='".$e[4]."', ip1=INET_ATON('".$e[0]."'), ip2=INET_ATON('".$e[1]."');";
  41.             cnstats_sql_query($sql);
  42.             }
  43.         
  44.         if ($str%100==0) {
  45.             print "<B>".$n."</B>: ".$tld." ".$e[0]."-".$e[1]."<br>\n";
  46.             flush();
  47.             }
  48.         $str++;$n++;
  49.         if ($str>=$per) {
  50. ?>
  51. <SCRIPT language="JavaScript" type="text/javascript">
  52. <!--
  53. document.location="index.php?action=2&nowrap=1&st=<?=$st;?>&stm=<?=$stm;?>&ftm=<?=$ftm;?>&start=<?=ftell($fw);?>&n=<?=$n;?>&per=<?=$per;?>&filter=<?=urlencode($filter);?>";
  54. //-->
  55. </SCRIPT>
  56. </BODY>
  57. </HTML>
  58. <?php
  59.             fclose($fw);
  60.             exit;
  61.             }
  62.         }
  63.     print "<br><B>Done!</B>";
  64. ?>
  65. <SCRIPT language="JavaScript" type="text/javascript">
  66. <!--
  67. document.location="index.php?st=<?=$st;?>&stm=<?=$stm;?>&ftm=<?=$ftm;?>&filter=<?=urlencode($filter);?>";
  68. //-->
  69. </SCRIPT>
  70. </BODY>
  71. </HTML>
  72. <?php
  73.     fclose($fw);
  74.     exit;    
  75.     }
  76.  
  77. if ($action==1) {
  78.     $lang=$HTTP_GET_VARS["lang"];
  79.     $lang=str_replace(";","_",$lang);$lang=str_replace(",","_",$lang);$lang=str_replace(".","_",$lang);
  80.     $lang=cnstats_mhtml($lang);
  81.  
  82.     $gauge=$HTTP_GET_VARS["gauge"]=="on"?1:0;
  83.     $percents=$HTTP_GET_VARS["percents"]=="on"?1:0;
  84.     $hints=$HTTP_GET_VARS["hints"]=="on"?1:0;
  85.     $antialias=$HTTP_GET_VARS["antialias"]=="on"?1:0;
  86.     $diagram=intval($HTTP_GET_VARS["diagram"]);
  87.     $date_format=cnstats_mhtml($HTTP_GET_VARS["date_format"]);
  88.     $shortdate_format=cnstats_mhtml($HTTP_GET_VARS["shortdate_format"]);
  89.     $shortdm_format=cnstats_mhtml($HTTP_GET_VARS["shortdm_format"]);
  90.     $datetime_format=cnstats_mhtml($HTTP_GET_VARS["datetime_format"]);
  91.     $datetimes_format=cnstats_mhtml($HTTP_GET_VARS["datetimes_format"]);
  92.  
  93.     cnstats_sql_query("UPDATE cns_config SET diagram='".$diagram.
  94.                                          "', antialias='".$antialias.
  95.                                          "', language='".$lang.
  96.                                          "', gauge='".$gauge.
  97.                                          "', hints='".$hints.
  98.                                          "', percents='".$percents.
  99.                                          "', date_format='".$date_format.
  100.                                          "', shortdate_format='".$shortdate_format.
  101.                                          "', shortdm_format='".$shortdm_format.
  102.                                          "', datetime_format='".$datetime_format.
  103.                                          "', datetimes_format='".$datetimes_format.
  104.                                          "';");
  105.     header("Location: index.php?st=config&stm=".$stm."&ftm=".$ftm."&filter=".$filter);
  106.     exit;
  107.     }
  108.  
  109. function YesNo($name,$value,$disabled="",$def="") {
  110.     if (!empty($disabled)) $value=$def;
  111.  
  112.     print "<SELECT name=\"".$name."\" ".$disabled.">\n";
  113.     print "<OPTION value=\"on\"".($value==1?" selected":"").">Yes\n";
  114.     print "<OPTION value=\"off\"".($value==0?" selected":"").">No\n";
  115.     print "</SELECT>\n";
  116.     }
  117.  
  118. $r=cnstats_sql_query("SELECT * FROM cns_config;");
  119. $a=mysql_fetch_array($r);
  120.  
  121. if (empty($a["date_format"])) $a["date_format"]=$LANG["date_format"];
  122. if (empty($a["shortdate_format"])) $a["shortdate_format"]=$LANG["shortdate_format"];
  123. if (empty($a["shortdm_format"])) $a["shortdm_format"]=$LANG["shortdm_format"];
  124. if (empty($a["datetime_format"])) $a["datetime_format"]=$LANG["datetime_format"];
  125. if (empty($a["datetimes_format"])) $a["datetimes_format"]=$LANG["datetimes_format"];
  126.  
  127. if ($a["timeoffset"]==1) $a["timeoffset"]=date("Z")/3600;
  128. ?>
  129. <form action='index.php' method='get'>
  130. <?=$TABLE;?>
  131. <tr class="tbl0"><td></td><td width="170"></td></tr>
  132. <tr class="tbl0"><td colspan="2" align="center"><b><?=$LANG["configmain"];?></b></td></tr>
  133. <tr class="tbl2"><td width="100%"><?=$LANG["show diagrams"];?></td><td width="1%"><?=YesNo("gauge",$a["gauge"]);?></td></tr>
  134. <tr class="tbl2"><td><?=$LANG["show percents"];?></td><td><?=YesNo("percents",$a["percents"]);?></td></tr>
  135. <tr class="tbl2"><td><?=$LANG["default diagrams"];?></td><td>
  136.  
  137. <table>
  138. <tr><td><input <?=(gdVersion()==0?"disabled":"");?> type="radio" name="diagram" value="1" <?=($a["diagram"]==1?"checked":"");?>></td><td><img src="img/graph_1_c.gif" vspace="2" width="130" height="75"></td></tr>
  139. <tr><td><input <?=(gdVersion()==0?"disabled":"");?> type="radio" name="diagram" value="2" <?=($a["diagram"]==2?"checked":"");?>></td><td><img src="img/graph_2_c.gif" vspace="2" width="130" height="75"></td></tr>
  140. <tr><td><input <?=(gdVersion()==0?"disabled":"");?> type="radio" name="diagram" value="3" <?=($a["diagram"]==3?"checked":"");?>></td><td><img src="img/graph_3_c.gif" vspace="2" width="130" height="75"></td></tr>
  141. </table>
  142.  
  143. <tr class="tbl2"><td><?=$LANG["antialias"];?></td><td><?=YesNo("antialias",$a["antialias"],gdVersion()<2?"disabled":"","no");?></td></tr>
  144.  
  145.  
  146. <tr class="tbl2"><td><?=$LANG["text_date_format"];?></td><td><input type="text" name="date_format" value="<?=$a["date_format"];?>" style="width:160px"></td></tr>
  147. <tr class="tbl2"><td><?=$LANG["text_shortdate_format"];?></td><td><input type="text" name="shortdate_format" value="<?=$a["shortdate_format"];?>" style="width:160px"></td></tr>
  148. <tr class="tbl2"><td><?=$LANG["text_shortdm_format"];?></td><td><input type="text" name="shortdm_format" value="<?=$a["shortdm_format"];?>" style="width:160px"></td></tr>
  149. <tr class="tbl2"><td><?=$LANG["text_datetime_format"];?></td><td><input type="text" name="datetime_format" value="<?=$a["datetime_format"];?>" style="width:160px"></td></tr>
  150. <tr class="tbl2"><td><?=$LANG["text_datetimes_format"];?></td><td><input type="text" name="datetimes_format" value="<?=$a["datetimes_format"];?>" style="width:160px"></td></tr>
  151. <tr class="tbl2"><td><?=$LANG["language"];?></td><td><SELECT name="lang" style="width:160px">
  152. <?php
  153. $lng=$a["language"];
  154.  
  155. $d=dir("lang/");
  156. while ($entry=$d->read()) {
  157.     if (substr($entry,0,4)=="lang") {
  158.         $lang=substr($entry,5,-4);
  159.         if ($lang!=$lng) print "<OPTION>".$lang."\n";
  160.         else print "<OPTION SELECTED>".$lang."\n";
  161.         }
  162.     }
  163. ?>
  164. </SELECT></td></tr>
  165. <tr class="tbl1"><td colspan="2" align="center"><input type="submit" value="<?=$LANG["save"];?>"></td></tr>
  166. </table>
  167. <input type="hidden" name="action" value="1">
  168. <input type="hidden" name="st" value="config">
  169. <input type="hidden" name="nowrap" value="1">
  170. <input type="hidden" name="hints" value="off">
  171. <?php
  172. print "<input type='hidden' name='stm' value='".$stm."'>\n";
  173. print "<input type='hidden' name='ftm' value='".$ftm."'>\n";
  174. print "<input type='hidden' name='filter' value='".urlencode($filter)."'>\n";
  175. ?>
  176. </form>
  177.  
  178. <form action='index.php' method='get'>
  179. <?=$TABLE;?>
  180. <tr class="tbl0"><td></td><td width="170"></td></tr>
  181. <tr class="tbl0"><td colspan="2" align=center><b><?=$LANG["geocountries"];?>: <?=intval(@mysql_result(mysql_query("SELECT count(*) FROM cns_countries;"),0,0));?>)</b></td></tr>
  182. <tr class='tbl2'><td><?=$LANG["geoipperpage"];?>:</td><td><input type="text" name="per" value="5000" style="width:160px"></td></tr>
  183. <tr class='tbl1'><td colspan="2" align='center'><input type='submit' value='<?=$LANG["update"];?>'></td></tr>
  184. </table>
  185. <input type='hidden' name='action' value='2'>
  186. <?php
  187. print "<input type='hidden' name='st' value='config'>\n";
  188. print "<input type='hidden' name='stm' value='".$stm."'>\n";
  189. print "<input type='hidden' name='ftm' value='".$ftm."'>\n";
  190. print "<input type='hidden' name='filter' value='".$filter."'>\n";
  191. print "<input type='hidden' name='nowrap' value='1'>\n";
  192. ?>
  193. </form>
  194. <?php
  195. $NOFILTER=1;
  196. ?>