function create_music($params)
{
    $limit = 50;
    if (array_key_exists('limit', $params)) {
        $limit = $params['limit'];
    }
    $res = '';
    $query = sprintf('SELECT id,title,track,artist,album,comment,year,genre,filename,date FROM TbMsHearing ORDER BY date DESC LIMIT %s', $limit);
    $result = my_mysql_query($query);
    $res .= multi_accordion_start();
    while ($row = $result->fetch_assoc()) {
        $header = $row['title'] . ' / ' . $row['album'] . ' / ' . $row['artist'];
        $body = '';
        $body .= '<ul>';
        $body .= '<li>id: ' . $row['id'] . '</li>';
        $body .= '<li>title: ' . $row['title'] . '</li>';
        $body .= '<li>track: ' . $row['track'] . '</li>';
        $body .= '<li>artist: ' . $row['artist'] . '</li>';
        $body .= '<li>album: ' . $row['album'] . '</li>';
        $body .= '<li>comment: ' . $row['comment'] . '</li>';
        $body .= '<li>year: ' . $row['year'] . '</li>';
        $body .= '<li>genre: ' . $row['genre'] . '</li>';
        $body .= '<li>filename: ' . $row['filename'] . '</li>';
        $body .= '<li>date: ' . $row['date'] . '</li>';
        $body .= '</ul>';
        $res .= multi_accordion_entry($header, $body);
    }
    my_mysql_free_result($result);
    $res .= multi_accordion_end();
    return $res;
}

function has_child($id)
{
    //$query = "select count(*) from collections where parent_id=$id";
    $query = select_query("count(*)", "collections", "parent_id={$id}");
    $rs = my_mysql_query($query);
    $row = my_mysql_fetch_array($rs);
    return $row[0] > 0 ? true : false;
}

function create_certification($params)
{
    $res = '';
    // sending query
    $query = sprintf('SELECT id,name,slug,url,imageId,fromDate FROM TbOrganization where funcCertification order by name asc');
    $result = my_mysql_query($query);
    $res .= get_start_table();
    $res .= '<tr>';
    $res .= '<td style=\'width:20%\'>type of certification</td>';
    $res .= '<td style=\'width:80%\'>date from which I am certified</td>';
    $res .= '<td style=\'width:20%\'>image</td>';
    $res .= '</tr>';
    // printing table rows
    while ($row = $result->fetch_assoc()) {
        $id = $row['id'];
        $name = $row['name'];
        $slug = $row['slug'];
        $url = $row['url'];
        $fromDate = $row['fromDate'];
        $imageId = $row['imageId'];
        $link_img = link_to_direct('GetBlob.php?table=TbImage&select_field=id&select_id=' . $imageId . '&data_field=smallData&name_field=slug&mime_field=smallMime');
        $res .= '</tr>';
        $res .= '<td><a href=\'' . $url . '\'>' . $name . '</a></td>';
        $res .= '<td>' . $fromDate . '</td>';
        $res .= '<td><img src=\'' . $link_img . '\'/></td>';
        $res .= '</tr>';
    }
    $result->free();
    $res .= '</table>';
    return $res;
}

<?php

require 'utils.php';
utils_init();
$debug = 0;
if ($debug) {
    print_r($_POST) . "\n";
}
# parameters for this script...
$p_workId = my_get_post_or_null('workId');
$p_typeId = my_get_post_or_null('typeId');
$p_organizationId = my_get_post_or_null('organizationId');
my_mysql_start_transaction();
$query = sprintf('insert into TbWkWorkContrib (workId,typeId,organizationId) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_typeId), my_mysql_real_escape_string($p_organizationId));
my_mysql_query($query);
$p_id = my_mysql_insert_id();
my_mysql_commit();
echo 'new record successfully inserted with id [' . $p_id . ']';

function make_table($query, $desc)
{
    $result = my_mysql_query($query);
    $res = '';
    $res .= '<a title="' . $query . '">' . $desc . '</a>';
    $res .= '<table><tbody>';
    $first = true;
    while ($row = $result->fetch_assoc()) {
        if ($first) {
            $res .= '<tr>';
            # iterate the result and print the headers...
            foreach ($row as $k => $v) {
                $res .= '<td>' . $k . '</td>';
            }
            $first = false;
            $res .= '</tr>';
        }
        $res .= '<tr>';
        # iterate the result and print the content
        foreach ($row as $k => $v) {
            $res .= '<td>' . $v . '</td>';
        }
        $res .= '</tr>';
    }
    $res .= '</tbody></table>';
    $res .= '<br/>';
    my_mysql_free_result($result);
    return $res;
}

             }
         }
         if ($twit === null) {
             send($sock, "PRIVMSG {$nick} :Name/Password Error!");
         } else {
             if ($twit->numChans() > 10) {
                 send($sock, "PRIVMSG {$nick} :You can have a maximum of 10 channels");
             } else {
                 if ($twit->isChan($words[3])) {
                     send($sock, "PRIVMSG {$nick} :Duplicate channel {$words[3]}");
                 } else {
                     // Check user is op on chan
                     $nSql = mysql_real_escape_string($nick);
                     $cSql = mysql_real_escape_string(strtolower($words[3]));
                     $sql = "SELECT COUNT(*) AS `cnt` FROM chan c INNER JOIN ison i ON c.chanid=i.chanid INNER JOIN user u ON u.nickid=i.nickid WHERE (u.nick='{$nSql}' AND c.channel='{$cSql}' AND ((i.mode_la = 'Y' OR i.mode_lo = 'Y' OR i.mode_lq = 'Y') OR (u.mode_lo = 'Y')))";
                     $result = my_mysql_query($sql);
                     $line = mysql_fetch_assoc($result);
                     if ($line['cnt'] > 0) {
                         $twit->addChan($words[3]);
                         $twit->save(SAVE_DIR . "/{$twit->name}.save");
                         send($sock, "JOIN {$words[3]}");
                         send($sock, "PRIVMSG {$nick} :Channel {$words[3]} added");
                     } else {
                         send($sock, "PRIVMSG {$nick} :You are not an op in {$words[3]}");
                     }
                 }
             }
         }
     }
     break;
 case 'delchan':

<?php

// url to use this script:
// http://veltzer.net/~mark/php/pages/GetBlob.php?table=TbMsLilypond&id=5&field=pdf&type=application/pdf&name_field=filebasename
require 'setup.php';
my_include('src/utils.php');
$p_slug = $_GET['slug'];
$debug = 0;
my_mysql_connect();
$query = sprintf('SELECT id,name,slug,mime,data FROM TbRsBlob where slug="%s"', $p_slug);
if ($debug == 1) {
    echo $query . '<br/>';
}
$result = my_mysql_query($query);
# make sure we really have a result
assert($result);
# we should only get one result...
assert(mysql_num_rows($result) == 1);
$row = $result->fetch_assoc();
$r_id = $row['id'];
$r_name = $row['name'];
$r_slug = $row['slug'];
$r_mime = $row['mime'];
$r_data = $row['data'];
# You can see more HTTP headers that may improve stuff in
# http://en.wikipedia.org/wiki/List_of_HTTP_headers
# ideas are: Content-MD5, Content-Length, Last-Modified
# if you want to debug HTTP headers just use wget -S on the
# command line and compared the headers that you are generating
# with the headers that a regular content generates by using
# the web server...

function create_lilypond($params)
{
    $res = '';
    // sending query
    $query = sprintf('SELECT id,uuid,title,subtitle,composer,poet,style,piece,copyright,pages,idyoutube,epdfs FROM TbMsLilypond order by title asc');
    $result = my_mysql_query($query);
    $res .= multi_accordion_start();
    while ($row = $result->fetch_assoc()) {
        $id = $row['id'];
        $s_uuid = $row['uuid'];
        $s_title = val_or_na($row['title']);
        $s_subtitle = val_or_na($row['subtitle']);
        $s_composer = val_or_na($row['composer']);
        $s_poet = val_or_na($row['poet']);
        $s_style = val_or_na($row['style']);
        $s_piece = val_or_na($row['piece']);
        $s_copyright = val_or_na($row['copyright']);
        $s_pages = val_or_na($row['pages']);
        $s_epdfs = val_or_na($row['epdfs']);
        $link_ly = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-ly');
        $link_pdf = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-pdf');
        $link_ps = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-ps');
        $link_midi = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-midi');
        $link_wav = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-wav');
        $link_mp3 = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-mp3');
        $link_ogg = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-ogg');
        $s_a_ly = '<a href=' . $link_ly . '>ly</a>';
        $s_a_pdf = '<a href=' . $link_pdf . '>pdf</a>';
        $s_a_ps = '<a href=' . $link_ps . '>ps</a>';
        $s_a_midi = '<a href=' . $link_midi . '>midi</a>';
        $s_a_wav = '<a href=' . $link_wav . '>wav</a>';
        $s_a_mp3 = '<a href=' . $link_mp3 . '>mp3</a>';
        $s_a_ogg = '<a href=' . $link_ogg . '>ogg</a>';
        $s_idyoutube = $row['idyoutube'];
        $header = $s_title;
        if ($row['composer'] != NULL) {
            $header .= ' / ' . $s_composer;
        }
        if ($row['poet'] != NULL && $s_poet != $s_composer) {
            $header .= ', ' . $s_poet;
        }
        $body = '';
        $body .= '<ul>';
        if ($row['id'] != NULL) {
            $body .= '<li>id: ' . $id . '</li>';
        }
        if ($row['title'] != NULL) {
            $body .= '<li>title: ' . $s_title . '</li>';
        }
        if ($row['subtitle'] != NULL) {
            $body .= '<li>subtitle: ' . $s_subtitle . '</li>';
        }
        if ($row['composer'] != NULL) {
            $body .= '<li>composer: ' . $s_composer . '</li>';
        }
        if ($row['poet'] != NULL) {
            $body .= '<li>poet: ' . $s_poet . '</li>';
        }
        if ($row['style'] != NULL) {
            $body .= '<li>style: ' . $s_style . '</li>';
        }
        if ($row['piece'] != NULL) {
            $body .= '<li>piece: ' . $s_piece . '</li>';
        }
        if ($row['copyright'] != NULL) {
            $body .= '<li>copyright: ' . $s_copyright . '</li>';
        }
        if ($row['pages'] != NULL) {
            $body .= '<li>pages: ' . $s_pages . '</li>';
        }
        if ($row['epdfs'] != NULL) {
            $body .= '<li>epdfs: ' . $s_epdfs . '</li>';
        }
        $links = array();
        # TODO: only add the links if I have the blobs...
        array_push($links, $s_a_ly);
        array_push($links, $s_a_pdf);
        array_push($links, $s_a_ps);
        array_push($links, $s_a_midi);
        array_push($links, $s_a_wav);
        array_push($links, $s_a_mp3);
        array_push($links, $s_a_ogg);
        # lets look and add links to the pngs...
        for ($i = 0; $i < $s_pages; $i++) {
            $j = $i + 1;
            $link = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-png' . $j);
            $link = '<a href=\'' . $link . '\'>png' . $j . '</a>';
            array_push($links, $link);
        }
        for ($i = 0; $i < $s_epdfs; $i++) {
            $link = link_to_direct('GetRsBlob.php?slug=' . $s_uuid . '-epdf' . $i);
            $link = '<a href=\'' . $link . '\'>epdf' . $i . '</a>';
            array_push($links, $link);
        }
        $body .= '<li>links: ' . join(', ', $links) . '</li>';
        $body .= '<li>uuid: ' . $s_uuid . '</li>';
        $body .= '</ul>';
        # lets put a link to play the audio, currently it looks like the
        # audio plugin can only play mp3 so that's the only link that we
        # put...
//.........这里部分代码省略.........

 function create_mvlog($v_schema_name, $v_table_name)
 {
     $v_done = FALSE;
     $v_column_name = NULL;
     $v_data_type = NULL;
     $v_sql = NULL;
     $cursor_sql = "SELECT COLUMN_NAME, IF(COLUMN_TYPE='TIMESTAMP', 'TIMESTAMP', COLUMN_TYPE) COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='{$v_table_name}' AND TABLE_SCHEMA = '{$v_schema_name}'";
     $cur_columns = my_mysql_query($cursor_sql, $this->source);
     $v_sql = '';
     while (1) {
         if ($v_sql != '') {
             $v_sql = FlexCDC::concat($v_sql, ', ');
         }
         $row = mysql_fetch_array($cur_columns);
         if ($row === false) {
             $v_done = true;
         }
         if ($row) {
             $v_column_name = '`' . $row[0] . '`';
             $v_data_type = $row[1];
         }
         if ($v_done) {
             mysql_free_result($cur_columns);
             break;
         }
         $v_sql = FlexCDC::concat($v_sql, $v_column_name, ' ', $v_data_type);
     }
     if (trim($v_sql) == "") {
         trigger_error('Could not access table:' . $v_table_name, E_USER_ERROR);
     }
     $v_sql = FlexCDC::concat('CREATE TABLE IF NOT EXISTS`', $this->mvlogDB, '`.`', $v_schema_name, '_', $v_table_name, '` ( dml_type INT DEFAULT 0, uow_id BIGINT, `fv$server_id` INT UNSIGNED,fv$gsn bigint, ', $v_sql, 'KEY(uow_id, dml_type) ) ENGINE=INNODB');
     $create_stmt = my_mysql_query($v_sql, $this->dest);
     if (!$create_stmt) {
         die1('COULD NOT CREATE MVLOG. ' . $v_sql . "\n");
     }
     $exec_sql = " INSERT IGNORE INTO `" . $this->mvlogDB . "`.`" . $this->mvlogs . "`( table_schema , table_name , mvlog_name ) values('{$v_schema_name}', '{$v_table_name}', '" . $v_schema_name . "_" . $v_table_name . "')";
     my_mysql_query($exec_sql) or die1($exec_sql . ':' . mysql_error($this->dest) . "\n");
     return true;
 }

 protected function process_rows()
 {
     #echo "IN PROCESS ROWS\n";
     #print_r($this);
     foreach ($this->table_map as $table_id => $info) {
         #FIXME: smartly (and transactionally) invalidate the cache
         if ($info->db === $this->mvlogDB && $info->table === $this->mvlogs) {
             $this->refresh_mvlog_cache();
         }
         if (empty($this->mvlogList[$info->db . $info->table])) {
             continue;
         }
         if (!$this->sent_fde) {
             $sql = "BINLOG '\n" . chunk_split(base64_encode($this->encode_fde()), 76, "\n") . "'/*!*/;\n";
             my_mysql_query($sql, $this->dest) or die1("Could not execute statement:\n" . $sql);
             unset($sql);
         }
         $events = $this->encode_remap_table($table_id);
         $events = chunk_split(base64_encode($events), 76, "\n");
         if (!empty($this->rows[$table_id]) && $this->rows[$table_id]['old']['images'] != "") {
             $events .= chunk_split(base64_encode($this->encode_row_events($table_id, 'old')), 76, "\n");
         }
         if (!empty($this->rows[$table_id]) && $this->rows[$table_id]['new']['images'] != "") {
             $events .= chunk_split(base64_encode($this->encode_row_events($table_id, 'new')), 76, "\n");
         }
         $sql = "BINLOG '\n{$events}'/*!*/;\n";
         unset($events);
         my_mysql_query($sql, $this->dest) or die1("Could not execute statement:\n" . $sql);
         unset($sql);
     }
 }

 function get_moyenne_dla()
 {
     $sql = "SELECT sum( -DLAH*60-DLAM ) as dla";
     $sql .= " FROM " . _TABLEVTT_;
     $sql .= " WHERE PVs IS NOT NULL";
     $query_result = my_mysql_query($sql);
     $row = mysql_fetch_array($query_result);
     return intval($row["dla"] / $this->nb_troll);
 }

     while ($f = readdir($fp)) {
         if ($f == '.' || $f == '..') {
             continue;
         }
         $f = $tpldir . '/css/' . $f;
         $c = @file_get_contents($f);
         if (!$c) {
             continue;
         }
         $c = str_replace('../design/', '../imgs/', $c);
         @chmod($f, 0777);
         $r = @file_put_contents($f, $c);
         @chmod($f, 0755);
     }
     closedir($fp);
     my_mysql_query("REPLACE INTO `settings` SET `word`='THEME', `value`='default' ", $conn);
     if (!file_exists('../../themes/include_in_footer.php')) {
         $tmp = "<" . "?php\n\n\t\n\t";
         $tmp .= "/" . "**\n\t\t\n\t\t";
         $tmp .= "This file in included to the Footer of all themes, right before the </body> tag\n\t\t\n\t\t";
         $tmp .= "Here you can place web counters.\n\t\t\n\t";
         $tmp .= "*/\n\t\n";
         $tmp .= "?" . ">\n";
         @file_put_contents('../../themes/include_in_footer.php', $tmp);
     }
 }
 if (!$error) {
     directory_tree_delete(INCPATH . '../../system/templates/');
     directory_tree_delete(INCPATH . '../../i/design/');
     directory_tree_delete(INCPATH . '../../i/css/');
     directory_tree_delete(INCPATH . '../../i/js/');

 function statement($sql)
 {
     $sql = trim($sql);
     if (substr($sql, 0, 6) == '/*!\\C ') {
         return;
     }
     /*	
     		if($sql[0] == '/') {
     			$end_comment = strpos($sql, ' ');
     			$sql = trim(substr($sql, $end_comment, strlen($sql) - $end_comment));
     		}
     */
     preg_match("/([^ ]+)(.*)/", $sql, $matches);
     //print_r($matches);
     $command = $matches[1];
     $command = str_replace($this->delimiter, '', $command);
     $args = $matches[2];
     switch (strtoupper($command)) {
         #register change in delimiter so that we properly capture statements
         case 'DELIMITER':
             $this->delimiter = trim($args);
             break;
             #NEW TRANSACTION
         #NEW TRANSACTION
         case 'BEGIN':
             $this->start_transaction();
             break;
             #END OF BINLOG, or binlog terminated early, or mysqlbinlog had an error
         #END OF BINLOG, or binlog terminated early, or mysqlbinlog had an error
         case 'ROLLBACK':
             $this->rollback_transaction();
             break;
         case 'COMMIT':
             $this->commit_transaction();
             break;
         case 'USE':
             #fall through and execute the use
             $this->activeDB = trim($args);
             $this->activeDB = str_replace($this->delimiter, '', $this->activeDB);
         default:
             my_mysql_query($sql, $this->dest) or die('Could not execute [SBR] statement:' . $sql . ':' . mysql_error($this->dest) . "\n");
             break;
     }
 }

<?php

include_once 'config.php';
include_once 'variables.php';
include_once 'inc_define_vars.php';
?>

<?php 
$blason = $_REQUEST["blason"];
if ($blason == "init") {
    # il faut tirer au sort le troll à afficher
    # tirage au sort d'une ligne de la table
    $query_result = my_mysql_query("SELECT nom_image_troll FROM trolls WHERE guilde_troll=" . ID_GUILDE . " ORDER BY rand() LIMIT 1");
    $row = mysql_fetch_array($query_result);
    $pseudo = $row["nom_image_troll"];
} else {
    $pseudo = $blason;
}
# récupération des infos
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>

<HEAD>
    <TITLE>Blason</TITLE>
</HEAD>

<BODY bgcolor="#000000" TEXT="yellow" link="cyan" vlink="cyan">

<center>

function parseline($bm_row, $ID)
{
    debug("raw: {$bm_row}");
    // debugging love.
    if (get_magic_quotes_gpc() == 1) {
        // auto-escape is on...
        $bm_row = stripslashes($bm_row);
    }
    // so remove extra slashes.
    debug("final: {$bm_row}");
    // debugging love.
    $bm_row = trim($bm_row);
    // get rid of ooky whitespace.
    $cmd = substr($bm_row, 0, 1);
    // first char is what command to perform.
    $bm_row = substr($bm_row, 3);
    // strip token of COMMAND,COMMA,SLASH.
    $l = strpos($bm_row, "\"");
    // find the end of our bookmark path.
    $tpath = substr($bm_row, 0, $l);
    // and save the path itself into $tpath.
    $path = addslashes($tpath);
    // encode slashes and apostraphes for SQL.
    // add bookmark
    if ($cmd == "A") {
        $url = substr($bm_row, strlen($tpath) + 3);
        // get the URL from our row.
        $url = addslashes(trim($url, "\"\r\n"));
        // remove ookiness and junk.
        $surl = addslashes(substr($url, 7, 55) . substr($url, -200));
        // MySQL indexes can only be 255.
        // insert the bookmark.
        my_mysql_query("insert into syncit_bookmarks (url, surl) values ('{$url}', '{$surl}')");
        $res = my_mysql_query("select bookid from syncit_bookmarks where surl='{$surl}'");
        // and check the expiration date. deleted URLs should
        // be regularly purged from the database after a certain
        // amount of time, but if the current URL is set to be
        // deleted, but hasn't yet, we resurrect it.
        if ($data = mysql_fetch_assoc($res)) {
            $bid = $data['bookid'];
            // shorter.
            $res = my_mysql_query("insert into syncit_link (expiration, person_id, access, path, " . "book_id) values (NULL, '{$ID}', now(), '{$path}', '{$bid}')");
            // bookmark exists already, but expired. Unexpire!
            if (!$res) {
                my_mysql_query("update syncit_link set expiration = NULL, book_id = '{$bid}' " . "where person_id = '{$ID}' and path = '{$path}'");
            }
        }
    } else {
        if ($cmd == "D") {
            my_mysql_query("update syncit_link set expiration = now() where path = '{$path}' and person_id = '{$ID}'");
        } else {
            if ($cmd == "M") {
                $res = my_mysql_query("insert into syncit_link (expiration, person_id, access, " . "path) values (NULL, '{$ID}', now(), '{$path}')");
                if (!$res) {
                    // resurrect a deleted directory.
                    my_mysql_query("update syncit_link set expiration = NULL, book_id = NULL " . "where person_id = '{$ID}' and path = '{$path}'");
                }
            } else {
                if ($cmd == "R") {
                    my_mysql_query("update syncit_link set expiration = now() where path = '{$path}' and person_id = '{$ID}'");
                } else {
                    my_echo("*E");
                    my_echo("Invalid Bookmark Command: {$cmd} ");
                    debug("Invalid Bookmark Command: [{$cmd}].");
                    return true;
                }
            }
        }
    }
    return false;
}

function initBlason($no)
{
    //$no = $_REQUEST["no"];
    if ($no == 0) {
        # il faut tirer au sort le troll à afficher
        # tirage au sort d'une ligne de la table
        $query_result = my_mysql_query("SELECT * , nom_troll FROM " . _TABLEVTT_ . ", trolls WHERE No=id_troll ORDER BY rand() LIMIT 1");
    } else {
        # il faut extraire les infos du troll numéro 'no'
        $query_result = my_mysql_query("SELECT *, nom_troll FROM " . _TABLEVTT_ . ", trolls WHERE No={$no} AND id_troll=No");
    }
    # récupération des infos
    $row = mysql_fetch_array($query_result);
    $pseudo = $row["nom_image_troll"];
    $cacherdata = $row["CacherData"];
    $text .= "<center>";
    $text .= "<table class=mh_tdborder  width=280>";
    $text .= "<tr class=mh_tdpage><td>";
    $text .= " <table width=280 cellspacing=0>";
    $text .= "    <tr class=mh_tdtitre align=center>";
    $text .= "       <td>";
    $text .= "<img src=http://www.pipeshow.net/RM/blasons/{$pseudo}.gif alt={$pseudo} border=0 name=blason>";
    $text .= "       </td>";
    $text .= "    </tr>";
    $text .= "  </table>";
    $text .= " </td>";
    $text .= " <td>";
    $text .= " <table width=280 border=0 cellpadding=3 cellspacing=3>";
    $text .= " <tr><td valign=top>";
    //	$text .= "<tr><td class=mh_tdpage colspan=2 align=center></td></tr>";
    //	$text .= "<tr>";
    //	$text .= "</table></td></tr></table>";
    $text .= "        <h2>{$pseudo} (n°{$no})</h2>";
    $text .= "\t\t\t\t<img src=http://www.pipeshow.net/RM/avatars/complets/" . $pseudo . "_avatar.gif";
    $text .= "\t\t\t\t\t\talt=[Avatar de {$pseudo}] border=0 width=110 height=110>";
    $text .= "<table>";
    $text .= "<tr class=mh_tdpage><td  colspan=2 align=center>";
    $text .= "<b>Les informations ci dessous n engagent que le Joueur. Le webmaster se réserve le droit de restreindre ou de supprimer comme bon lui semble laccès au joueur à ces champs de libre expression.</b>";
    $text .= "</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>Comp&eacute;tences</td><td class=blasond align=left>" . ($cacherdata ? "--" : $row["Comps"]) . "&nbsp;</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>Nom (complet)<br>du Troll</td><td class=blasond align=left>";
    if (non_vide($row["nom_troll"])) {
        $text .= htmlspecialchars($row["nom_troll"]);
    } else {
        $text .= "&nbsp;";
    }
    $text .= "</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>Joueur</td><td class=blasond align=left>";
    if (non_vide($row["Joueur"])) {
        $text .= htmlspecialchars($row["Joueur"]);
    } else {
        $text .= "&nbsp;";
    }
    $text .= "</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>Age du Joueur</td><td class=blasond align=left>";
    if (non_vide($row["AgeJoueur"]) and $row["AgeJoueur"] >= 1) {
        $text .= htmlspecialchars($row["AgeJoueur"]);
    } else {
        $text .= "&nbsp;";
    }
    $text .= "</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>Ville du Joueur</td><td class=blasond align=left>";
    if (non_vide($row["VilleJoueur"])) {
        $text .= htmlspecialchars($row["VilleJoueur"]);
    } else {
        $text .= "&nbsp;";
    }
    $text .= "</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>MSN</td><td class=blasond align=left>";
    if (non_vide($row["MSN"])) {
        $text .= htmlspecialchars($row["MSN"]);
    } else {
        $text .= "&nbsp;";
    }
    $text .= "</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>ICQ</td><td class=blasond align=left>";
    if (non_vide($row["ICQ"])) {
        $text .= htmlspecialchars($row["ICQ"]);
    } else {
        $text .= "&nbsp;";
    }
    $text .= "</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>Email</td><td class=blasond align=left>";
    if (non_vide($row["EMail"])) {
        $text .= htmlspecialchars($row["EMail"]);
    } else {
        $text .= "&nbsp;";
    }
    $text .= "</td></tr>";
    $text .= "<tr class=mh_tdpage><td class=blasong align=right>Divers</td><td class=blasond align=left>";
    if (non_vide($row["Divers"])) {
        $text .= preg_replace("/(\n|\r)/", "<br>", htmlspecialchars($row["Divers"]));
    } else {
        $text .= "&nbsp;";
    }
    $text .= "</td></tr>";
    $text .= "</table>";
    $text .= "</td></tr>";
    $text .= "</table>";
    $text .= "</td><tr>";
//.........这里部分代码省略.........

function database_drop_tables_with_prefix($prefix)
{
    if (empty($prefix)) {
        return FALSE;
    }
    global $s;
    $conn = my_mysql_connect($s['MYSQL_HOST'], $s['MYSQL_USER'], $s['MYSQL_PASS']);
    $dbs = my_mysql_select_db($s['MYSQL_DBNAME'], $conn);
    if (!$conn || !$dbs) {
        return FALSE;
    }
    $tmp = my_mysql_query('SHOW TABLES FROM ' . $s['MYSQL_DBNAME'], $conn);
    while ($tbl = my_mysql_fetch_row($tmp)) {
        $tbl = $tbl[0];
        if (substr($tbl, 0, strlen($prefix)) == $prefix) {
            my_mysql_query("DROP TABLE IF EXISTS `" . $tbl . "`;", $conn);
        }
    }
}

 public function parse_cate($parser, $content, $base)
 {
     $dom = $parser->engine->init($content);
     $xpath = "/html/body/div[3]/div[3]/div[1]/div[2]/a";
     $res = $dom->find($xpath);
     $base_url = 'http://' . implode('/', $base);
     $base_url_1 = 'http://' . $base[0];
     $xpath_1 = "//*[@id=\"list1\"]/li";
     $content = $dom->find($xpath_1);
     if ($res) {
         $pattern = '/href=\\"([^\\"]+)\\"/i';
         foreach ($res as $value) {
             preg_match($pattern, $value, $mat);
             if (isset($mat[1])) {
                 if (strpos($mat[1], '/') === 0) {
                     $url = trim($base_url_1, '/') . '/' . trim($mat[1], '/');
                 } else {
                     $url = trim($base_url, '/') . '/' . trim($mat[1], '/');
                 }
             }
             if (strpos($url, '.htm')) {
                 $end = strripos($url, '/');
                 $int = substr($url, $end + 1, -4);
                 if (intval($int) > 5) {
                     break;
                 }
             }
             push_to_crawler($url);
         }
     }
     return;
     if ($content) {
         foreach ($content as $value) {
             $value = trim(strip_tags($value));
             $time = time();
             $value = mb_substr($value, 0, strlen($value), 'utf-8');
             $cate_id = 0;
             $sql = "select id from qq_cates where cate_mark = '{$base[1]}'";
             $cate = my_mysql_query($sql);
             if ($cate) {
                 $cate_id = $cate[0]['id'];
             }
             $sub_sql = $cate_id ? ' and cate_id = ' . $cate_id : '';
             $sql = "select id from qq_sign where sign_title = '{$value}'" . $sub_sql;
             $res = my_mysql_query($sql);
             if ($res) {
                 return;
             }
             $sql = "insert into qq_sign (sign_title, cate_id, created_time, updated_time) values('{$value}', {$cate_id}, {$time}, {$time})";
             $id = my_mysql_insert($sql);
             echo $id . "\n";
         }
     }
 }

<body bgcolor="#30395D" TEXT="white">

<form method="post" action="login.php">
<center>
<img src="visiotrollotron.gif">
<br>
<?php 
if ($reason == "login") {
    echo "<font color=yellow>Login refus&eacute;, veuillez essayer de nouveau</font><br>\n";
}
?>
Nom d'utilisateur : <SELECT name="no_membre">

<?php 
# récupération des nos et des pseudos des trolls
$query_result = my_mysql_query("SELECT No, Pseudo from trolls ORDER BY Pseudo");
while ($row = mysql_fetch_array($query_result)) {
    echo "\n\t<OPTION value=\"" . $row["No"] . "\">" . $row["Pseudo"] . "</OPTION>";
}
?>

</SELECT>
Mot de passe : <input type="password" name="passe_membre"><br>
<br><input type="submit" name="SubmitVTT" value="VisioTrollotron">

</form>
</center>

<H4>Vous ne connaissez pas votre mot de passe ?</H4>
<H4>Vous avez oubli&eacute; votre mot de passe ?</H4>
<b><font color=yellow>Envoyez votre demande de mot de passe au Troll Lobo (no 10866), Garbrag (no 30271) ou Grognon (no 2690) qui vous le communiquera.</font></b>

        }
    }
    if (!$error && strlen($s['ADMIN_PASS']) < 5) {
        $error = TRUE;
        $errmsg = 'Password must be at least 5 characters long.';
    }
    if (!$error && $s['ADMIN_PASS'] != $s['ADMIN_PASS2']) {
        $error = TRUE;
        $errmsg = 'Passwords don`t match.';
    }
    if (!$error && !is_valid_email($s['ADMIN_EMAIL'])) {
        $error = TRUE;
        $errmsg = 'Invalid E-mail address.';
    }
    if (!$error) {
        $res = my_mysql_query('SELECT id FROM users WHERE email="' . addslashes($s['ADMIN_EMAIL']) . '" LIMIT 1', $conn);
        if ($res) {
            if (my_mysql_num_rows($res) > 0) {
                $error = TRUE;
                $errmsg = 'This e-mail is already registered.';
            }
        }
    }
    if (!$error) {
        unset($s['ADMIN_PASS2']);
        $_SESSION['INSTALL_STEP'] = 7;
        header('Location: ?next&r=' . rand(0, 99999));
    }
}
$html .= '
							<div class="ttl">