<?xml version="1.0" standalone="no"?>
<!DOCTYPE WyCode SYSTEM "WyCode.dtd">

<product name="wysql">
  <module name="wycode">
    <file name="wycode_scan.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>common.php</string>
      <string>LC_ALL=C</string>
      <string>-name '*.</string>
      <string>' -name '*.</string>
      <string>'</string>
      <string>xml</string>
      <string>Content-type: $wycode_xmlfile</string>
      <string>Content-disposition: inline; filename=wycode_scan.xml</string>
      <string> -nohead</string>
      <string><?xml version=\"1.0\" standalone=\"no\"</string>
      <string>$PROG $VER</string>
      <string>text</string>
      <string>s</string>
      <string> for strings</string>
      <string>q</string>
      <string> for queries</string>
      <string>t</string>
      <string> for tables</string>
      <string> for strings, queries and table</string>
      <string>db</string>
      <string> (inserted database records)</string>
      <string> -</string>
      <string>db</string>
      <string>html</string>
      <string> -html</string>
      <string>xml</string>
      <string> -xml</string>
      <string> -$scn</string>
      <string> -cache=$wycode_cachein</string>
      <string>::</string>
      <string></product>\n</string>
      <string><product name=\"$wycode_prod\">\n</string>
      <string>  <module name=\"$wycode_module\">\n</string>
      <string>/usr/bin/find $wycode_path -type f $findext -print 2>/dev/null</string>
      <string>$cmd</string>
      <string>r</string>
      <string>^.*\.</string>
      <string>^$wycode_path/?</string>
      <string>    <file name=\"</string>
      <string>\" path=\"</string>
      <string>\">\n</string>
      <string>html</string>
      <string><pre></string>
      <string>./wycode_scan.pl -dbms=$wy_ms -host=$wy_host -name=$wy_name -user=$wy_user -password=$wy_password -prefix=$wy_fix -count $opt -prod=$wycode_prod -module=$wycode_module -lang=$lang $filename 2>&1</string>
      <string>$cmd</string>
      <string>r</string>
      <string>xml</string>
      <string>xml</string>
      <string>Scan error on file</string>
      <string>html</string>
      <string></pre></string>
      <string>    </file>\n</string>
      <string>  </module>\n</string>
      <string>wycode_back.php</string>
      <string></product>\n</string>
    </file>
    <file name="wycode_tables.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>copyright.php</string>
      <string>$PROG $VER</string>
      <string>../wysql/console.php</string>
      <string>:</string>
      <string>:</string>
      <string>../wysql/connect.php</string>
      <string>query</string>
      <string>
delete from $DBfix_wycodedbinfo
where host = '$wy_host' and dbname = '$wy_name' and type='a'</string>
      <string>list_tables</string>
      <string>fetch_row</string>
      <string>Query .*$</string>
      <string>desc $tabname</string>
      <string>query</string>
      <string>
insert into $DBfix_wycodedbinfo (host, dbname, tablename, crc32)
values ('$wy_host', '$wy_name', '$tabname', </string>
      <string>)</string>
      <string>free_result</string>
      <string>error</string>
      <string>:</string>
      <string>wycode_back.php</string>
      <query> delete from $DBfix_wycodedbinfo where host = '$wy_host' and dbname = '$wy_name' and type='a'</query>
      <query> insert into $DBfix_wycodedbinfo (host, dbname, tablename, crc32) values ('$wy_host', '$wy_name', '$tabname', </query>
      <table name="$DBfix_wycodedbinfo">
        <privilege grant="DELETE" type="auto"/>
        <privilege grant="INSERT" type="auto"/>
      </table>
    </file>
    <file name="setup.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>common.php</string>
      <string>$PROG $VER</string>
      <string>create table if not exists $DBfixstrings (
  prod varchar(32) not null,
  module varchar(32) not null,
  lang varchar(16) not null,
  path varchar(255) not null,
  filename varchar(64) not null,
  fileuniq char(32) not null,
  string text,
  type enum('a', 'm', 'd') default 'a' not null,
  index by_mod (prod, module, filename),
  index by_file (filename)
 )</string>
      <string>create table if not exists $DBfixqueries (
  prod varchar(32) not null,
  module varchar(32) not null,
  lang varchar(16) not null,
  path varchar(255) not null,
  filename varchar(64) not null,
  fileuniq char(32) not null,
  query text,
  type enum('a', 'm', 'd') default 'a' not null,
  index by_mod (prod, module, filename),
  index by_file (filename)
 )</string>
      <string>create table if not exists $DBfixtables (
  prod varchar(32) not null,
  module varchar(32) not null,
  lang varchar(16) not null,
  path varchar(255) not null,
  filename varchar(64) not null,
  fileuniq char(32) not null,
  tablename varchar(100) not null,
  priv varchar(16) not null,
  type enum('a', 'm', 'd') default 'a' not null,
  index by_mod (module, filename),
  index by_file (filename),
  index by_tab (tablename, priv),
  unique by_all (prod, module, fileuniq, tablename, priv)
 )</string>
      <string>create table if not exists $DBfixdbinfo (
  host varchar(64) not null,
  dbname varchar(64) not null,
  tablename varchar(100) not null,
  crc32 int not null,
  type enum('a', 'm', 'd') default 'a' not null,
  primary key (host, dbname, tablename, crc32)
 )</string>
      <string>query</string>
      <string>wycode_back.php</string>
      <query>create table if not exists $DBfixstrings (   prod varchar(32) not null,   module varchar(32) not null,   lang varchar(16) not null,   path varchar(255) not null,   filename varchar(64) not null,   fileuniq char(32) not null,   string text,   type enum('a', 'm', 'd') default 'a' not null,   index by_mod (prod, module, filename),   index by_file (filename)  )</query>
      <query>create table if not exists $DBfixqueries (   prod varchar(32) not null,   module varchar(32) not null,   lang varchar(16) not null,   path varchar(255) not null,   filename varchar(64) not null,   fileuniq char(32) not null,   query text,   type enum('a', 'm', 'd') default 'a' not null,   index by_mod (prod, module, filename),   index by_file (filename)  )</query>
      <query>create table if not exists $DBfixtables (   prod varchar(32) not null,   module varchar(32) not null,   lang varchar(16) not null,   path varchar(255) not null,   filename varchar(64) not null,   fileuniq char(32) not null,   tablename varchar(100) not null,   priv varchar(16) not null,   type enum('a', 'm', 'd') default 'a' not null,   index by_mod (module, filename),   index by_file (filename),   index by_tab (tablename, priv),   unique by_all (prod, module, fileuniq, tablename, priv)  )</query>
      <query>create table if not exists $DBfixdbinfo (   host varchar(64) not null,   dbname varchar(64) not null,   tablename varchar(100) not null,   crc32 int not null,   type enum('a', 'm', 'd') default 'a' not null,   primary key (host, dbname, tablename, crc32)  )</query>
      <table name="$DBfixqueries">
        <privilege grant="CREATE" type="auto"/>
      </table>
      <table name="$DBfixstrings">
        <privilege grant="CREATE" type="auto"/>
      </table>
      <table name="$DBfixtables">
        <privilege grant="CREATE" type="auto"/>
      </table>
      <table name="$DBfixdbinfo">
        <privilege grant="CREATE" type="auto"/>
      </table>
    </file>
    <file name="index.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>common.php</string>
      <string>$PROG $VER</string>
      <string>../wysql/database.php</string>
      <string>load</string>
      <string>none</string>
      <string>r</string>
      <string><?</string>
      <string>::</string>
      <string>&nbsp;&nbsp;</string>
      <string>(^.*:)(.*)(:[^:]*$)</string>
      <string>\\1******\\3</string>
      <string>(^.*:)(.*)(:[^:]*$)</string>
      <string>\\1******\\3</string>
      <string>:</string>
      <string> selected</string>
      <string>chk_cache$wycode_cachein</string>
      <string> checked</string>
      <string> checked</string>
      <string>a</string>
      <string>chk_$wycode_scan[0]</string>
      <string> checked</string>
      <string> checked</string>
      <string>chk_$wycode_scanout</string>
      <string> checked</string>
      <string> checked</string>
      <string> checked</string>
      <string> checked</string>
      <string> checked</string>
      <string> checked</string>
      <string>connect</string>
      <string>select_db</string>
      <string>query</string>
      <string>select count(*) from $DBfixstrings</string>
      <string>query</string>
      <string>select count(*) from $DBfixqueries</string>
      <string>query</string>
      <string>select count(*) from $DBfixtables</string>
      <string>query</string>
      <string>select count(*) from $DBfixdbinfo</string>
      <string>or specify WyCode database access information (and connect) </string>
      <query>select count(*) from $DBfixstrings</query>
      <query>select count(*) from $DBfixqueries</query>
      <query>select count(*) from $DBfixtables</query>
      <query>select count(*) from $DBfixdbinfo</query>
      <table name="$DBfixqueries">
        <privilege grant="SELECT" type="auto"/>
      </table>
      <table name="$DBfixstrings">
        <privilege grant="SELECT" type="auto"/>
      </table>
      <table name="$DBfixtables">
        <privilege grant="SELECT" type="auto"/>
      </table>
      <table name="$DBfixdbinfo">
        <privilege grant="SELECT" type="auto"/>
      </table>
    </file>
    <file name="wycode_back.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>wycode_cmd</string>
      <string>[]</string>
      <string> onClick=\"document.forms['back'].submit();return false\"</string>
      <string>$onclick</string>
    </file>
    <file name="wycode_dbtabmod.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>common.php</string>
      <string>no query matched</string>
      <string><a href="#" onClick="alert(\'</string>
      <string>\');return false"></string>
      <string>([^ ]*) .*$</string>
      <string>\\1</string>
      <string></a><br />\n</string>
      <string>$PROG $VER</string>
      <string>../wysql/console.php</string>
      <string>::</string>
      <string>:</string>
      <string>:</string>
      <string>../wysql/connect.php</string>
      <string>query</string>
      <string>
delete from $DBfix_wycodedbinfo
where host = '$wy_host' and dbname = '$wy_name' and type='a'</string>
      <string>list_tables</string>
      <string>fetch_row</string>
      <string><br /></string>
      <string>Query .*$</string>
      <string>desc $tabname</string>
      <string>
select distinct filename, priv, fileuniq
  from $DBfixtables
 where tablename = '$tabname'
   and prod = '$key'
   and module = '$val[$j]'
   and type != 'd'
 order by filename, priv
</string>
      <string>
select distinct priv
  from $DBfixtables
 where tablename = '$tabname'
   and prod = '$key'
   and module = '$val[$j]'
   and type != 'd'
 order by priv
</string>
      <string>,'</string>
      <string>$wy_fix</string>
      <string>$DBfix_wycode</string>
      <string>','</string>
      <string>$wy_fix</string>
      <string>$DBfix</string>
      <string>','</string>
      <string>$wy_fix</string>
      <string>$wy_fix</string>
      <string>'</string>
      <string>
select distinct filename, priv, fileuniq
  from $DBfixtables
 where tablename in ('$tabname'$repfix)
   and prod = '$key'
   and module = '$val[$j]'
   and type != 'd'
 order by filename, fileuniq, priv
</string>
      <string>
select distinct priv
  from $DBfixtables
 where tablename in ('$tabname'$repfix)
   and prod = '$key'
   and module = '$val[$j]'
   and type != 'd'
 order by priv
</string>
      <string>query</string>
      <string>fetch_array</string>
      <string>free_result</string>
      <string><font size="1" face="Courier, System, Arial, Verdana"></string>
      <string>LOCK TABLES</string>
      <string>LOCK&nbsp;TABLES</string>
      <string>, </string>
      <string></font><br /><br /></string>
      <string>&nbsp;</string>
      <string>query</string>
      <string>fetch_array</string>
      <string>^ *((insert|replace)( +low_priority| +delayed)?( +into)? +)|select +.* +from +|update +|(create|drop|optimize|alter) +table|lock +tables? +.|delete +from +</string>
      <string>
select distinct query
    from $DBfixqueries
   where query regexp '$rexp$tabname( +|$)'
     and prod = '$key'
     and module = '$val[$j]'
     and fileuniq = '$row2[2]'
     and type != 'd'
</string>
      <string>(</string>
      <string>$wy_fix</string>
      <string>$DBfix_wycode</string>
      <string>|</string>
      <string>$wy_fix</string>
      <string>$DBfix</string>
      <string>|</string>
      <string>$wy_fix</string>
      <string>$wy_fix</string>
      <string>)</string>
      <string>
select distinct query
    from $DBfixqueries
   where (query regexp '$rexp$tabname( +|$)' or
          query regexp '$rexp$repfix( +|$)')
     and prod = '$key'
     and module = '$val[$j]'
     and fileuniq = '$row2[2]'
     and type != 'd'
</string>
      <string>query</string>
      <string>fetch_array</string>
      <string>free_result</string>
      <string>, </string>
      <string><br /><br /></string>
      <string>, $row2[1]</string>
      <string>free_result</string>
      <string>&nbsp;</string>
      <string>error</string>
      <string>&nbsp;</string>
      <string>query</string>
      <string>
insert into $DBfix_wycodedbinfo (host, dbname, tablename, crc32)
values ('$wy_host', '$wy_name', '$tabname', </string>
      <string>)</string>
      <string>free_result</string>
      <string>error</string>
      <string>:</string>
      <string>wycode_back.php</string>
      <query> delete from $DBfix_wycodedbinfo where host = '$wy_host' and dbname = '$wy_name' and type='a'</query>
      <query> select distinct filename, priv, fileuniq   from $DBfixtables  where tablename = '$tabname'    and prod = '$key'    and module = '$val[$j]'    and type != 'd'  order by filename, priv</query>
      <query> select distinct priv   from $DBfixtables  where tablename = '$tabname'    and prod = '$key'    and module = '$val[$j]'    and type != 'd'  order by priv</query>
      <query> select distinct filename, priv, fileuniq   from $DBfixtables  where tablename in ('$tabname'$repfix)    and prod = '$key'    and module = '$val[$j]'    and type != 'd'  order by filename, fileuniq, priv</query>
      <query> select distinct priv   from $DBfixtables  where tablename in ('$tabname'$repfix)    and prod = '$key'    and module = '$val[$j]'    and type != 'd'  order by priv</query>
      <query> select distinct query     from $DBfixqueries    where query regexp '$rexp$tabname( +|$)'      and prod = '$key'      and module = '$val[$j]'      and fileuniq = '$row2[2]'      and type != 'd'</query>
      <query> select distinct query     from $DBfixqueries    where (query regexp '$rexp$tabname( +|$)' or           query regexp '$rexp$repfix( +|$)')      and prod = '$key'      and module = '$val[$j]'      and fileuniq = '$row2[2]'      and type != 'd'</query>
      <query> insert into $DBfix_wycodedbinfo (host, dbname, tablename, crc32) values ('$wy_host', '$wy_name', '$tabname', </query>
      <table name="$DBfixqueries">
        <privilege grant="SELECT" type="auto"/>
      </table>
      <table name="$DBfixtables">
        <privilege grant="SELECT" type="auto"/>
      </table>
      <table name="$DBfix_wycodedbinfo">
        <privilege grant="DELETE" type="auto"/>
        <privilege grant="INSERT" type="auto"/>
      </table>
    </file>
    <file name="wycode_saveconf.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>Content-type: application/php</string>
      <string>Content-disposition: inline; filename=wycode_config.php</string>
      <string>common.php</string>
      <string>wycode_cmd</string>
      <string>wycode_dataset</string>
      <string>[]</string>
      <string>\$$key='</string>
      <string>';\n</string>
      <string><?\n$script?></string>
    </file>
    <file name="copyright.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>WyCode</string>
      <string>V0.3.1a</string>
      <string>2002-2003</string>
      <string>Mauro Franzoni</string>
      <string><a href="index.php?show_c=1">click here</a></string>
      <string><a href="index.php?show_w=1">click here</a></string>
      <string>
    $PROG $VER, Copyright (C) $YEAR $AUTHOR
    $PROG comes with ABSOLUTELY NO WARRANTY;  for details $CMD_W.
    This is free software, and you are welcome to redistribute it
    under certain conditions; $CMD_C for details.
</string>
      <string>
    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.
    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
    <img align=\"middle\" src=\"osi-certified-60x50-t.png\" />OSI Certified Open Source Software.
</string>
      <string>
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.
 
    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
</string>
    </file>
    <file name="common.php" path="/home/www/www.franzoni.info/open/wycode">
      <string>mysql</string>
      <string>copyright.php</string>
      <string>../wysql/database.php</string>
      <string>../wysql/common.php</string>
      <string>../wysql/driver.php</string>
      <string>connect</string>
      <string>select_db</string>
      <string>ERRORE query: [$query]<br />\n</string>
      <string>error</string>
      <string><br />\n</string>
      <string>DEBUG: In $file at line $line <br />\n</string>
      <string>WyCode_</string>
      <string>WyCode_</string>
    </file>
  </module>
</product>