function conv_name($str)
{
$str = str_replace(array('É'), 'e', $str);
$str = strtolower(conv($str));
$str = str_replace(array('é', 'è', 'ë', 'ê'), 'e', $str);
$str = str_replace(array('à', 'ä', 'â'), 'a', $str);
$str = str_replace(array('î', 'ï'), 'i', $str);
$str = str_replace(array('ç'), 'c', $str);
return preg_replace("/[^a-z0-9_-]/", "", $str);
}
function convertir($formula, $columna = '', $fila)
{
$d = explode(" ", $formula);
$formu = "";
$a = conv($d[0], $columna, $fila);
$b = conv($d[1], $columna, $fila);
$o = $d[2];
$formu = $a . $o . $b;
$cantidad = count($d) - 1;
for ($i = 3; $i <= $cantidad; $i = $i + 2) {
$a = $formu;
$b = conv($d[$i], $columna, $fila);
$o = $d[$i + 1];
if ($o == "/" or $o == "*") {
$formu = "(" . $a . ")" . $o . $b;
} else {
$formu = $a . $o . $b;
}
}
return $formu;
}
function CodeFunc($Id, $artist, $title)
{
$Id = (int) $Id;
$utf8Str = SetToHexString($artist . $title);
$length = strlen($utf8Str) / 2;
for ($i = 0; $i <= $length - 1; $i++) {
eval('$song[' . $i . '] = 0x' . substr($utf8Str, $i * 2, 2) . ';');
}
$tmp2 = 0;
$tmp3 = 0;
$tmp1 = ($Id & 0xff00) >> 8;
//右移8位后为0x0000015F
if (($Id & 0xff0000) == 0) {
$tmp3 = 0xff & ~$tmp1;
//CL 0x000000E7
} else {
$tmp3 = 0xff & ($Id & 0xff0000) >> 16;
//右移16位后为0x00000001
}
$tmp3 = $tmp3 | (0xff & $Id) << 8;
//tmp3 0x00001801
$tmp3 = $tmp3 << 8;
//tmp3 0x00180100
$tmp3 = $tmp3 | 0xff & $tmp1;
//tmp3 0x0018015F
$tmp3 = $tmp3 << 8;
//tmp3 0x18015F00
if (($Id & 0xff000000) == 0) {
$tmp3 = $tmp3 | 0xff & ~$Id;
//tmp3 0x18015FE7
} else {
$tmp3 = $tmp3 | 0xff & $Id >> 24;
//右移24位后为0x00000000
}
$i = $length - 1;
while ($i >= 0) {
$char = $song[$i];
if ($char >= 0x80) {
$char = $char - 0x100;
}
$tmp1 = $char + $tmp2 & 0xffffffff;
$tmp2 = $tmp2 << $i % 2 + 4 & 0xffffffff;
$tmp2 = $tmp1 + $tmp2 & 0xffffffff;
$i -= 1;
}
$i = 0;
$tmp1 = 0;
while ($i <= $length - 1) {
$char = $song[$i];
if ($char >= 128) {
$char = $char - 256;
}
$tmp7 = $char + $tmp1 & 0xffffffff;
$tmp1 = $tmp1 << $i % 2 + 3 & 0xffffffff;
$tmp1 = $tmp1 + $tmp7 & 0xffffffff;
$i += 1;
}
$t = conv($tmp2 ^ $tmp3);
$t = conv($t + ($tmp1 | $Id));
$t = conv(bcmul($t, $tmp1 | $tmp3));
$t = conv(bcmul($t, $tmp2 ^ $Id));
if (bccomp($t, 2147483648) > 0) {
$t = bcadd($t, -4294967296);
}
return $t;
}
function printXML($arr)
{
foreach ($arr as $key => $val) {
if (is_array($val)) {
$folder_title = substr($key, $omit_folder_chars);
ksort($val);
printXML($val);
} else {
$file = $val;
if (substr($file, -3) == 'mp3' || substr($file, -3) == 'MP3') {
$file_title = substr($file, 0, strlen($file) - 4);
// ID3v1 and ID3v2 tags parser
$nome_arq = $file;
$myId3 = new ID3($nome_arq);
if ($myId3->getInfo()) {
$f_title = $myId3->getTitle();
$f_artist = $myId3->getArtist();
}
if (!$myId3->getArtist()) {
$id3 = new MP3_Id();
$result = $id3->read($file);
$f_title = $id3->getTag('name');
$f_artist = $id3->getTag('artists');
}
if ($f_artist == '0' && $f_title == '0') {
$arr_names = explode('/', strrev($nome_arq));
$substr = substr($arr_names[0], 4, strlen($arr_names[0]));
$arr_names_last = explode('_', strrev($substr));
$f_artist = '';
$f_title = strrev($substr);
}
if ($f_artist == '0') {
$f_artist = '';
}
$f_id = str_replace("/", "", $file_title);
$f_id = str_replace(".", "", $f_id);
$f_id = str_replace(">", "", $f_id);
$f_id = str_replace("<", "", $f_id);
$f_id = str_replace("=", "", $f_id);
$f_id = str_replace("(", "", $f_id);
$f_id = str_replace(")", "", $f_id);
$f_id = str_replace("\"", "", $f_id);
if ($sEncoding = mb_detect_encoding($f_title, 'auto', true) != 'UTF-8') {
$f_title = mb_convert_encoding($f_title, 'UTF-8', $sEncoding);
}
if ($sEncoding = mb_detect_encoding($f_artist, 'auto', true) != 'UTF-8') {
$f_artist = mb_convert_encoding($f_artist, 'UTF-8', $sEncoding);
}
$f_title = conv($f_title);
$f_artist = conv($f_artist);
if (substr($f_title, 0, 4) == 'ÿþ') {
$f_title = substr($f_title, 4);
}
if (substr($f_artist, 0, 4) == 'ÿþ') {
$f_artist = substr($f_artist, 4);
}
$f_title = str_replace(">", "", $f_title);
$f_title = str_replace("<", "", $f_title);
$f_artist = str_replace(">", "", $f_artist);
$f_artist = str_replace("<", "", $f_artist);
$f_id = encoding($f_id);
$path = $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
$path = dirname($path);
$defaul_dir = substr($val, 0, strrpos($val, '/'));
$file_name_ = substr(strrchr($val, '/'), 1);
$url_dec = rawurlencode($file_name_);
$val = $defaul_dir . '/' . $url_dec;
$file = $val;
$file = 'http://' . $path . '/' . $file;
// Writing in XML
print '
<song id="' . $f_id . '" title="' . $f_title . '" artist="' . $f_artist . '" src="' . $file . '" />';
}
}
}
}
$inputtime = $recordSet->fields[11];
$inputtime = strtotime($inputtime);
$pattern = "/<[img|IMG].*?src=[\\'|\"](.*?(?:[\\.gif|\\.jpg]))[\\'|\"].*?[\\/]?>/";
preg_match_all($pattern, $content, $match);
//print_r($match);
if (isset($match[1][0])) {
//echo $match[1][0] , "\r\n";
$thumb = $match[1][0];
$ret = strpos($thumb, 'www.nmwomen.org.cn');
if ($ret === false) {
$thumb = "http://www.nmwomen.org.cn" . $thumb;
}
insert_article($id, $nid, $title, $keyword, $content, $inputtime, $copyfrom, $thumb);
} else {
insert_article($id, $nid, $title, $keyword, $content, $inputtime, $copyfrom, null);
}
//die;
$recordSet->MoveNext();
}
}
$recordSet->Close();
$db->Close();
}
//conv(57,3);
conv(59, 36);
conv(60, 37);
conv(61, 38);
conv(62, 39);
conv(63, 40);
conv(64, 41);
//$content = preg_replace("'<\s*a\s.*?href\s*=\s*([\"\'])?(?(1)(.*?)\\1|([^\s\>]+))[^>]*>?(.*?)</a>'isx", "", $content);
$author = $recordSet->fields[7];
$author = iconv("GBK", "UTF-8", $author);
$copyfrom = $recordSet->fields[8];
$copyfrom = iconv("GBK", "UTF-8", $copyfrom);
$inputtime = $recordSet->fields[11];
$inputtime = strtotime($inputtime);
$pattern = "/<[img|IMG].*?src=[\\'|\"](.*?(?:[\\.gif|\\.jpg]))[\\'|\"].*?[\\/]?>/";
preg_match_all($pattern, $content, $match);
//print_r($match);
if (isset($match[1][0])) {
//echo $match[1][0] , "\r\n";
$thumb = $match[1][0];
insert_article($id, $nid, $title, $keyword, $content, $inputtime, $copyfrom, $thumb);
} else {
insert_article($id, $nid, $title, $keyword, $content, $inputtime, $copyfrom, null);
}
//die;
$recordSet->MoveNext();
}
}
$recordSet->Close();
$db->Close();
}
/// jingping xinxi
conv(59, 85);
conv(60, 86);
conv(61, 87);
conv(62, 88);
conv(63, 89);
echo $compteurMarqueur;
?>
});
var pos_<?php
echo $compteurMarqueur;
?>
= new google.maps.Marker({
position: new google.maps.LatLng(<?php
echo $donnees_transports['gps'];
?>
),
map: carte,
icon: arretBusIco,
title: '<?php
echo conv($donnees_transports['arret']);
?>
'
});
pos_<?php
echo $compteurMarqueur;
?>
.addListener('click', function() {
fenetre_<?php
echo $compteurMarqueur;
?>
.open(carte, pos_<?php
echo $compteurMarqueur;
?>
);
$tmp .= '1';
/* echo 1; */
} else {
$tmp_strr .= '0';
$tmp .= '0';
/* echo 0; */
}
if (strlen($tmp_strr) % 4 == 0) {
$ttmp_str .= mybin2hex($tmp_strr);
$tmp_strr = '';
}
}
/* echo "\n" . $len . "\n"; */
return $ttmp_str;
}
$api_con = conv($request_api, 'view');
/* DEBUG */
/*####################################### */
if ($DEBUG_MOD == ON) {
echo '</pre><h2>api section</h2><hr />';
echo "request_api=" . $request_api . "<br />api con =" . $api_con . "<br />";
}
/*####################################### */
/* DEBUG */
/* exit(' request exit here '); */
/*################ 存储req_token ################*/
$right = $api_con;
$fail_time = date("Y-m-d H:i:s", time() + 120);
$sql = "INSERT INTO token_info (app_id,request_token,request_secret,verify_code,token_right,access_token,access_secret,faile_t) VALUES('{$app_id}','{$request_token}','{$request_secret}','{$verify_code}','{$right}','{$access_token}','{$access_secret}','{$fail_time}')";
mysql_query($sql);
echo mysql_error();
function CodeFunc($Id, $artist, $title)
{
$Id = (int) $Id;
$utf8Str = SetToHexString(iconv('GBK', 'UTF-8', $artist . $title));
$length = strlen($utf8Str) / 2;
for ($i = 0; $i <= $length - 1; $i++) {
eval('$song[' . $i . '] = 0x' . substr($utf8Str, $i * 2, 2) . ';');
}
$tmp2 = 0;
$tmp3 = 0;
$tmp1 = ($Id & 0xff00) >> 8;
if (($Id & 0xff0000) == 0) {
$tmp3 = 0xff & ~$tmp1;
} else {
$tmp3 = 0xff & ($Id & 0xff0000) >> 16;
}
$tmp3 = $tmp3 | (0xff & $Id) << 8;
$tmp3 = $tmp3 << 8;
$tmp3 = $tmp3 | 0xff & $tmp1;
$tmp3 = $tmp3 << 8;
//tmp3 0x18015F00
if (($Id & 4278190080.0) == 0) {
$tmp3 = $tmp3 | 0xff & ~$Id;
} else {
$tmp3 = $tmp3 | 0xff & $Id >> 24;
}
$i = $length - 1;
while ($i >= 0) {
$char = $song[$i];
if ($char >= 0x80) {
$char = $char - 0x100;
}
$tmp1 = $char + $tmp2 & 4294967295.0;
$tmp2 = $tmp2 << $i % 2 + 4 & 4294967295.0;
$tmp2 = $tmp1 + $tmp2 & 4294967295.0;
$i -= 1;
}
$i = 0;
$tmp1 = 0;
while ($i <= $length - 1) {
$char = $song[$i];
if ($char >= 128) {
$char = $char - 256;
}
$tmp7 = $char + $tmp1 & 4294967295.0;
$tmp1 = $tmp1 << $i % 2 + 3 & 4294967295.0;
$tmp1 = $tmp1 + $tmp7 & 4294967295.0;
$i += 1;
}
$t = conv($tmp2 ^ $tmp3);
$t = conv($t + ($tmp1 | $Id));
$t = conv(bcmul($t, $tmp1 | $tmp3));
$t = conv(bcmul($t, $tmp2 ^ $Id));
if (bccomp($t, 2147483648.0) > 0) {
$t = bcadd($t, -4294967296.0);
}
return $t;
}
}
closedir($handler);
}
}
if (isset($_GET['file_dir'])) {
ReadFolderDirectory($_GET['file_dir']);
}
natcasesort($listDir);
print '<?xml version="1.0" encoding="utf-8"?>';
print '
<pics>';
$directory = $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'];
$directory = dirname($directory);
foreach ($listDir as $val) {
$title = substr(strrchr($val, '/'), 1);
if ($sEncoding = mb_detect_encoding($title, 'auto', true) != 'UTF-8') {
$title = mb_convert_encoding($title, 'UTF-8', $sEncoding);
}
$title = conv($title);
if (substr($title, 0, 4) == 'ÿþ') {
$title = substr($title, 4);
}
$defaul_dir = substr($val, 0, strrpos($val, '/'));
$file_name_ = substr(strrchr($val, '/'), 1);
$url_dec = rawurlencode($file_name_);
$val = $defaul_dir . '/' . $url_dec;
print '
<pic src="' . 'http://' . $directory . '/' . $val . '" title="' . $title . '" />';
}
print '
</pics>';
function getCode($Id, $utf8Str)
{
$Id = (int) $Id;
$length = strlen($utf8Str) / 2;
for ($i = 0; $i < $length; $i++) {
eval('$song[' . $i . '] = 0x' . substr($utf8Str, $i * 2, 2) . ';');
}
$tmp2 = 0;
$tmp3 = 0;
$tmp1 = ($Id & 0xff00) >> 8;
if (($Id & 0xff0000) == 0) {
$tmp3 = 0xff & ~$tmp1;
} else {
$tmp3 = 0xff & ($Id & 0xff0000) >> 16;
}
$tmp3 = $tmp3 | (0xff & $Id) << 8;
$tmp3 = $tmp3 << 8;
$tmp3 = $tmp3 | 0xff & $tmp1;
$tmp3 = $tmp3 << 8;
if (($Id & 0xff000000) == 0) {
$tmp3 = $tmp3 | 0xff & ~$Id;
} else {
$tmp3 = $tmp3 | 0xff & $Id >> 24;
}
$i = $length - 1;
while ($i >= 0) {
$char = $song[$i];
if ($char >= 0x80) {
$char = $char - 0x100;
}
$tmp1 = $char + $tmp2 & 0xffffffff;
$tmp2 = $tmp2 << $i % 2 + 4 & 0xffffffff;
$tmp2 = $tmp1 + $tmp2 & 0xffffffff;
$i -= 1;
}
$i = 0;
$tmp1 = 0;
while ($i <= $length - 1) {
$char = $song[$i];
if ($char >= 128) {
$char = $char - 256;
}
$tmp7 = $char + $tmp1 & 0xffffffff;
$tmp1 = $tmp1 << $i % 2 + 3 & 0xffffffff;
$tmp1 = $tmp1 + $tmp7 & 0xffffffff;
$i += 1;
}
$t = conv($tmp2 ^ $tmp3);
$t = conv($t + ($tmp1 | $Id));
$t = conv(bcmul($t, $tmp1 | $tmp3));
$t = conv(bcmul($t, $tmp2 ^ $Id));
if (bccomp($t, 2147483648) > 0) {
$t = bcadd($t, -4294967296);
}
return $t;
}
function convertfield ($result, $ISCcolumnname, $reserved) {
switch ($ISCcolumnname) {
case "ZVTH":
switch (conv(_odbc_result($result, 'ZVTH'))) {
case "-" : $housetype= 1; break;
case "Хру" : $housetype= 2; break;
case "МС" : $housetype= 3; break;
case "Улу" : $housetype= 4; break;
case "Ста" : $housetype= 5; break;
case "Эли" : $housetype= 6; break;
case "Гос" : $housetype= 7; break;
case "Мал" : $housetype= 8; break;
case "Лен" : $housetype= 9; break;
case "Ком" : $housetype=10; break;
case "Стф" : $housetype=11; break;
case "НС" : $housetype=12; break;
case "90" : $housetype=13; break;
default : $housetype= 1; break;
}
return $housetype;
break;
case "ZVMATER":
case "ZVMATERWALL":
switch (conv(_odbc_result($result, 'ZVMATER'))) {
case "-" : $wallsmaterial= 1; break;
case "Кир" : $wallsmaterial= 2; break;
case "Пан" : $wallsmaterial= 3; break;
case "Дер" : $wallsmaterial= 4; break;
case "Ком" : $wallsmaterial= 5; break;
case "Шла" : $wallsmaterial= 6; break;
case "Мон" : $wallsmaterial= 7; break;
case "Бре" : $wallsmaterial= 8; break;
case "Кар" : $wallsmaterial= 9; break;
case "ПБ" : $wallsmaterial=10; break;
default : $wallsmaterial= 1; break;
}
return $wallsmaterial;
break;
case "ZCONDITION":
case "ZCONDITIONID":
if ($t=="RoomsSell") {
$condition=1;
} else {
switch (conv(_odbc_result($result, 'ZCONDITION'))) {
case ('1303'): $condition=2; break;
case ('1304'): $condition=3; break;
case ('1305'): $condition=4; break;
case ('1306'): $condition=5; break;
case ('1307'): $condition=6; break;
case ('812' ): $condition=1; break;
case ('823' ): $condition=2; break;
case ('822' ): $condition=3; break;
case ('813' ): $condition=4; break;
case ('824' ): $condition=5; break;
case ('928' ): $condition=6; break;
case ('929' ): $condition=7; break;
case ('-1' ): $condition=1; break;
default : $condition=1; break;
}
}
return $condition;
break;
case "ZVPHONE":
switch (conv(_odbc_result($result, 'ZVPHONE'))) {
case ('-' ): $landline=2; break;
case ('+' ): $landline=3; break;
case ('IP'): $landline=4; break;
default : $landline=1; break;
}
return $landline;
break;
case "ZVWC":
switch (conv(_odbc_result($result, 'ZVWC'))) {
case ('-' ): $toilettype=1; break;
case ('Р' ): $toilettype=2; break;
case ('С' ): $toilettype=3; break;
case ('Т' ): $toilettype=4; break;
case ('2C'): $toilettype=5; break;
default : $toilettype=1; break;
}
return $toilettype;
break;
case "ZVPLAN":
switch (_odbc_result($result, 'ZVPLAN')) {
case('Изол.'): $layouttype=4; break;
case('Смежн'): $layouttype=3; break;
case('Трамв'): $layouttype=2; break;
default : $layouttype=1; break;
}
break;
case "ZVSELLTYPE":
switch (conv(_odbc_result($result, 'ZVSELLTYPE'))) {
case "-" : $selltypeid=1; break;
case "А" : $selltypeid=2; break;
case "П" : $selltypeid=3; break;
case "О" : $selltypeid=4; break;
case "Ч" : $selltypeid=5; break;
case "С" : $selltypeid=6; break;
case "ПО": $selltypeid=7; break;
default : $selltypeid=1; break;
}
return $selltypeid;
break;
case "ZVDOCS":
switch (conv(_odbc_result($result, 'ZVDOCS'))) {
case "Экскл." : $relationship=1; break;
case "Откр." : $relationship=2; break;
case "Без дог." : $relationship=3; break;
default : $relationship=4; break;
}
return $relationship;
break;
case "ZDOCSID":
switch (conv(_odbc_result($result, 'ZDOCSID'))) {
case "15" : $relationship=1; break;
case "16" : $relationship=2; break;
case "17" : $relationship=3; break;
default : $relationship=4; break;
}
return $relationship;
break;
case "ZVFROM":
switch (conv(_odbc_result($result, 'ZVFROM'))) {
case "Продавца" : $source=1; break;
case "АН" : $source=2; break;
case "Эксклюз." : $source=3; break;
case "Застройщик" : $source=4; break;
default : $source=5; break;
}
return $source;
break;
case "ZFROMID":
switch (conv(_odbc_result($result, 'ZFROMID'))) {
case "341" : $source=1; break;
case "342" : $source=2; break;
case "343." : $source=3; break;
case "344" : $source=4; break;
default : $source=5; break;
}
return $source;
break;
case "ZVSALETYPE":
$offertypeid = 0;
switch (conv(_odbc_result($result, 'ZVSALETYPE'))) {
case "Продаю" : $offertypeid=2; break;
case "Продажа" : $offertypeid=2; break;
case "Сдам в аренду" : $offertypeid=4; break;
case "Аренда" : $offertypeid=4; break;
case "Сдам в субаренду" : $offertypeid=6; break;
case "Меняю" : $offertypeid=7; break;
case "Аренда ПВ" : $offertypeid=8; break;
default : $offertypeid=1; break;
}
if ($offertypeid==0) echo "Unknown offertypeid: "._odbc_result($result, 'ZVSALETYPE');
return $offertypeid;
break;
case "ZVGARAGE":
$ret = 0;
switch (conv(_odbc_result($result, 'ZVGARAGE'))) {
case "Нет" : $ret=2; break;
case "Встроенный" : $ret=3; break;
case "Отдельный" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ZVGARAGE result: "._odbc_result($result, 'ZVGARAGE');
return $ret;
break;
case "ZVBANIA":
$ret = 0;
switch (conv(_odbc_result($result, 'ZVBANIA'))) {
case "Нет" : $ret=2; break;
case "Есть" : $ret=3; break;
case "Сауна" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ZVGARAGE result: "._odbc_result($result, 'ZVBANIA');
return $ret;
break;
case "ZVFLOOR":
$ret = 0;
switch (conv(_odbc_result($result, 'ZVFLOOR'))) {
case "-" : $ret=1; break;
case "Бет" : $ret=2; break;
case "Дер" : $ret=3; break;
case "Гру" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ZVFLOOR result: "._odbc_result($result, 'ZVFLOOR');
return $ret;
break;
case "ZVROOF":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "Кир" : $ret=2; break;
case "Жел" : $ret=3; break;
case "Жл1" : $ret=4; break;
case "Бет" : $ret=5; break;
case "Залитая" : $ret=6; break;
case "Смешанная" : $ret=7; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZVWHAT":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "Гараж" : $ret=2; break;
case "Участок" : $ret=3; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZVPOD":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "Асфальт" : $ret=2; break;
case "Грунт" : $ret=3; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZCONDITIONID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "839" : $ret=2; break;
case "840" : $ret=3; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZRIGHTBUILDID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "835" : $ret=2; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZPROPISKAID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "837" : $ret=2; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZTARGET":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "1047" : $ret=2; break;
case "1048" : $ret=3; break;
case "1049" : $ret=4; break;
case "1050" : $ret=5; break;
case "1051" : $ret=6; break;
case "1052" : $ret=7; break;
case "1053" : $ret=8; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZVOWNING":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "частная" : $ret=2; break;
case "Фед." : $ret=4; break;
case "Мун." : $ret=5; break;
case "Вед." : $ret=6; break;
case "Ар.с пр.вык." : $ret=7; break;
case "Суб КУГИ" : $ret=8; break;
case "БСП" : $ret=9; break;
case "Не оф." : $ret=17; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZOTDELID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "209" : $ret=2; break;
case "210" : $ret=3; break;
case "211" : $ret=4; break;
case "212" : $ret=5; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZWALLSID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "214" : $ret=2; break;
case "215" : $ret=3; break;
case "216" : $ret=5; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZFLOORID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "218" : $ret=2; break;
case "219" : $ret=3; break;
case "220" : $ret=4; break;
case "221" : $ret=5; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZWCID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "230" : $ret=2; break;
case "231" : $ret=3; break;
case "232" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZGASID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "234" : $ret=2; break;
case "235" : $ret=3; break;
case "236" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZDOORSID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "226" : $ret=2; break;
case "227" : $ret=3; break;
case "228" : $ret=4; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZWINDOWSID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "223" : $ret=2; break;
case "224" : $ret=3; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZVHEAT":
case "ZVHEATING":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "нет" : $ret=2; break;
case "АГВ" : $ret=3; break;
case "котельная" : $ret=4; break;
case "паровое" : $ret=5; break;
case "комбинир." : $ret=6; break;
case "центр." : $ret=7; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZSECURITYID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "818" : $ret=3; break;
case "292" : $ret=2; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZTYPEOWNINGID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "52" : $ret=2; break;
case "53" : $ret=3; break;
case "310" : $ret=1; break;
case "311" : $ret=4; break;
case "312" : $ret=5; break;
case "313" : $ret=6; break;
case "314" : $ret=7; break;
case "315" : $ret=8; break;
case "316" : $ret=9; break;
case "317" : $ret=17; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZSTANDID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "809" : $ret=2; break;
case "810" : $ret=3; break;
case "811" : $ret=4; break;
case "930" : $ret=5; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZPLACEPUBLICID": // this list field in ISC to be converted to 1/0 in sl.
$ret = -1;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "819" : $ret=0; break;
case "820" : $ret=1; break;
default : $ret=0; break;
}
if ($ret==-1) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZINTERNETID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "804" : $ret=1; break;
case "805" : $ret=2; break;
case "806" : $ret=4; break;
case "807" : $ret=3; break;
case "808" : $ret=6; break;
case "825" : $ret=5; break;
case "827" : $ret=7; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
case "ZINSERTIONID":
$ret = 0;
switch (conv(_odbc_result($result, $ISCcolumnname))) {
case "-" : $ret=1; break;
case "814" : $ret=1; break;
case "815" : $ret=2; break;
default : $ret=1; break;
}
if ($ret==0) echo "Unknown ".$ISCcolumnname." result: "._odbc_result($result, $ISCcolumnname);
return $ret;
break;
default:
return (conv(_odbc_result($result, $ISCcolumnname)));
break;
}
}
$tmp = $text;
//--------------------------------------------- SOSTITUISCO AL TESTO DEL MODELLO I CAMPI UNO A MOLTI ---------------------------------------------------
print_debug($tabella);
if ($cicli) {
foreach ($cicli as $txt) {
$out = sostituisci_campi($txt, $tabella);
//$out=conv($out);
//$tmp=str_replace("<#".$txt."#>",utf8_decode($out),$tmp);//utf8_encode(html_entity_decode($pippo)) // TAG della lista di campi
$tmp = str_replace("<#" . $txt . "#>", $out, $tmp);
print_debug($txt, null, "rtf");
}
}
//--------------------------------------------- SOSTITUISCO I AL TESTO DEL MODELLO I CAMPI UNO A UNO ---------------------------------------------------
if ($campi) {
foreach ($campi as $txt) {
$aux = conv($tabella["{$txt}"][0]);
//$tmp=str_replace("<*".$txt."*>",utf8_decode($aux),$tmp);
$tmp = str_replace("<*" . $txt . "*>", $aux, $tmp);
}
}
//--------------------------------------------- SOSTITUISCO I AL TESTO DEL MODELLO I CARATTERI TERMINALI ---------------------------------------------------
if ($finali) {
foreach ($finali as $txt) {
$tmp = str_replace("</" . $txt . "/>", "", $tmp);
}
}
//--------------------------------------------- SCRIVO IL NUOVO FILE ---------------------------------------------------
if (file_exists($outfile)) {
@unlink($outfile);
}
$handle = fopen($outfile, "x+");
function getagent($result) { // look for desired agent and return its ID. if not found then create one and return its ID. also manage company ID in similar way.
global $ca;
$debug = 0;
if ($debug) echo $sql_ag."<hr>";
$ret=new stdClass();
$zvagent = conv(_odbc_result($result, 'ZVAGENT'));
$zvagph = conv(_odbc_result($result, 'ZVAGPH'));
$zvcomp = conv(_odbc_result($result, 'ZVCOMP'));
$sql_ag="
SELECT `ID`
FROM `agentinfo`
WHERE
(`FirstName`='".$zvagent."') AND
( `Phone`='".$zvagph."')
LIMIT 0, 1
;
";
if ($debug) echo $sql_ag."<br>";
$row=$this->db->query_first($sql_ag);
$ret->lastid_agent = -1; // $row['ID'];
if ($debug) echo "Row: ".print_r($row,true)."<br>";
// if ($debug) echo "Row: ".print_r($row,true)."<br>";
if (!$row->ID) { // desired agent not found - we will create the new agent
if ($debug) echo "Adding agentinfo record.<br>";
// echo "MySQL Agent C: ".$row['ID'].", ";
// echo "MS Access zagentc: "._odbc_result($result, 'ZAGENTC')."<br>";
// find corresponding company
$sql_ag="SELECT `ID` FROM `companies` WHERE `Name`='".$zvcomp."' ; ";
$row=$this->db->query_first($sql_ag);
// echo "Company ID: ".$row['ID']."<br>";
if (!$row->ID) { // if not found then create
$sql_ag="INSERT INTO `companies` (`Name`, `IsTemplate`) VALUES ('".$zvcomp."','0') ; ";
if ($debug) echo $sql_ag."<br>";
$row=$this->db->exec($sql_ag);
$mar=$row->rowsAffected;
if ($debug) echo "Result: ".$mar."<br>";
// if ($debug) echo "Result: ".print_r($row,true)."<br>";
$ret->lastid_company=$row->lastInsertID;
} else { // if found then use it
$ret->lastid_company = $row->ID;
}
// echo "Company ID to insert to agentinfo: ".$lastid_company."<br>";
// $ret->lastid_agent = (int)_odbc_result($result, 'ZAGENTC');
if (!$ca) $ca=0;
$sql_ag="INSERT INTO `agentinfo`
(
".(($ret->lastid_agent==-1)?"":"`ID`,")."
`FirstName`,
`LastName`,
`Phone`,
`Email`,
`AuxPhone`,
`CompanyID`,
`Username`,
`Password`,
`LastAccess`
) VALUES (
".(($ret->lastid_agent==-1)?"":"'".$ret->lastid_agent."',")."
'".$zvagent."',
'',
'".$zvagph."',
'',
'',
'".$ret->lastid_company."',
'User_".$ca."',
'".md5("User_".$ca)."',
'".(date("Y-m-d H:i:s"))."'
) ;
";
// ajax_echo ($sql_ag."<br>");
if ($debug) echo $sql_ag."<br>";
$r=$this->db->exec($sql_ag);
// if ($debug) echo "Result: ".print_r($r,true)."<br>";
$mar=$r->rowsAffected;
if ($debug) echo "Result: ".$mar."<br>";
$ret->lastid_agent = $r->lastInsertID;
if ($mar>0) {
$ca++;
} else {
echo_r ("Cannot execute SQL statement: ".$sql_ag);
}
} else {
$ret->lastid_agent = $row->ID;
}
return $ret;
}
$ret = strpos($thumb, 'www.nmwomen.org.cn');
if ($ret === false) {
$thumb = "http://www.nmwomen.org.cn" . $thumb;
}
insert_article($id, $nid, $title, $keyword, $content, $inputtime, $copyfrom, $thumb);
} else {
insert_article($id, $nid, $title, $keyword, $content, $inputtime, $copyfrom, null);
}
//die;
$recordSet->MoveNext();
}
}
$recordSet->Close();
$db->Close();
}
conv(57, 3);
/*
conv(5,16);
conv(6,18);
conv(7,19);
conv(29,34);
conv(30,34);
conv(28,34);
conv(45,30);
conv(45,31);
conv(46,50);
conv(41,52);
conv(42,51);
conv(48,57);
conv(47,54);
function Check($pTmp, $key)
{
switch ($key) {
case 'appid':
if (preg_match('/^[0-9a-zA-Z]{16}$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid appid', $pTmp);
IAuthException::$Info['appid'] = $pTmp;
}
break;
case 'nonce':
if (preg_match('/^[0-9a-zA-Z]{16}$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid nonce', $pTmp);
}
break;
case 'state':
if (preg_match('/^[0-9a-zA-Z]{16}$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid state', $pTmp);
}
break;
case 'token':
if (preg_match('/^[0-9a-zA-Z]{40}$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid token', $pTmp);
}
break;
case 'time':
if (preg_match('/^[0-9]{10}$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid time', $pTmp);
}
$time = $_SERVER['REQUEST_TIME'];
if ($pTmp <= $time - IAUTH_TIME_OFFSET || $pTmp >= $time + IAUTH_TIME_OFFSET) {
throw new IAuthException('server time=' . $time . ' your time=' . $pTmp);
}
break;
case 'version':
if ($pTmp != '2.0') {
throw new IAuthException('invalid version', $pTmp);
}
break;
case 'sig':
break;
case 'sigmethod':
if ($pTmp != 'HMAC-SHA1' && $pTmp != 'MD5') {
throw new IAuthException('unsuported signature method', $pTmp);
}
break;
case 'verifier':
if (preg_match('/^[0-9a-zA-Z]{16}$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid verifier');
}
break;
case 'api_id':
if (preg_match('/^[0-9]+$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid api id');
}
break;
case 'uid':
if (preg_match('/^[0-9]+$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid uid, need login');
}
break;
case 'rights':
if (preg_match('/^(\\d)+[:(\\d)+]*$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid rights format');
}
return conv($pTmp);
case 'url':
if (preg_match('/^(http)|(https):\\/\\/[\\w\\/\\.]+$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid url');
}
break;
case 'httpmethod':
if ($pTmp != 'GET' && $pTmp != 'POST') {
throw new IAuthException('unsupport HTTP method');
}
break;
case 'faile_t':
if (preg_match('/^(\\d\\d\\d\\d)-(\\d\\d)-(\\d\\d) (\\d\\d):(\\d\\d):(\\d\\d)$/', $pTmp, $match) == 0) {
throw new IAuthException('invalid faile time format', $pTmp);
}
$time = mktime($match[4], $match[5], $match[6], $match[2], $match[3], $match[1]);
if ($time < $_SERVER['REQUEST_TIME']) {
throw new IAuthException('faile time earlier than now', $pTmp);
}
break;
default:
break;
}
return $pTmp;
}
