cr_.php
2.54 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<?php
//error_reporting (0);
set_time_limit(30);
@include_once(dirname ( __FILE__ )."/new_csv/mysql.class.php");
define ("DBHOST", "db");
define ("DBNAME", "extrem");
define ("DBUSER", "extrem");
define ("DBPASS", "9gvs7AbI");
$db = new db;
$link = mysql_connect(DBHOST,DBNAME,DBPASS);
if(@$link) echo "ok";
else echo "not";
$res = $db->query("UPDATE `catalogs_rubrics` SET `translit`='' WHERE `translit`!='';");
$res = $db->query("SELECT * FROM `catalogs_rubrics` WHERE `translit`='';");
while($row = $db->get_row($res)){
$tra = totranslit($row['name']);
$sss = $db->super_query("SELECT COUNT(*) as count FROM `catalogs_rubrics` WHERE `translit`='".$tra."'");
if($sss['count']>0) $sss['count']++;
else $sss['count']="";
if(trim($sss['count'])!='') $tra=$tra."-".$sss['count'];
echo $tra."<br/>";
@$db->query("UPDATE `catalogs_rubrics` SET `translit`='".$tra."' WHERE `id`='".$row['id']."';");
}
function totranslit($var, $lower = true, $punkt = true) {
global $langtranslit;
if ( is_array($var) ) return "";
if (!is_array ( $langtranslit ) OR !count( $langtranslit ) ) {
$langtranslit = array(
'à' => 'a', 'á' => 'b', 'â' => 'v',
'ã' => 'g', 'ä' => 'd', 'å' => 'e',
'¸' => 'e', 'æ' => 'zh', 'ç' => 'z',
'è' => 'i', 'é' => 'y', 'ê' => 'k',
'ë' => 'l', 'ì' => 'm', 'í' => 'n',
'î' => 'o', 'ï' => 'p', 'ð' => 'r',
'ñ' => 's', 'ò' => 't', 'ó' => 'u',
'ô' => 'f', 'õ' => 'h', 'ö' => 'c',
'÷' => 'ch', 'ø' => 'sh', 'ù' => 'sch',
'ü' => '', 'û' => 'y', 'ú' => '',
'ý' => 'e', 'þ' => 'yu', 'ÿ' => 'ya',
"¿" => "yi", "º" => "ye",
'À' => 'A', 'Á' => 'B', 'Â' => 'V',
'Ã' => 'G', 'Ä' => 'D', 'Å' => 'E',
'¨' => 'E', 'Æ' => 'Zh', 'Ç' => 'Z',
'È' => 'I', 'É' => 'Y', 'Ê' => 'K',
'Ë' => 'L', 'Ì' => 'M', 'Í' => 'N',
'Î' => 'O', 'Ï' => 'P', 'Ð' => 'R',
'Ñ' => 'S', 'Ò' => 'T', 'Ó' => 'U',
'Ô' => 'F', 'Õ' => 'H', 'Ö' => 'C',
'×' => 'Ch', 'Ø' => 'Sh', 'Ù' => 'Sch',
'Ü' => '', 'Û' => 'Y', 'Ú' => '',
'Ý' => 'E', 'Þ' => 'Yu', 'ß' => 'Ya',
"¯" => "yi", "ª" => "ye",
);
}
$var = str_replace( ".php", "", $var );
$var = trim( strip_tags( $var ) );
$var = preg_replace( "/\s+/ms", "-", $var );
$var = strtr($var, $langtranslit);
if ( $punkt ) $var = preg_replace( "/[^a-z0-9\_\-.]+/mi", "", $var );
else $var = preg_replace( "/[^a-z0-9\_\-]+/mi", "", $var );
$var = preg_replace( '#[\-]+#i', '-', $var );
if ( $lower ) $var = strtolower( $var );
if( strlen( $var ) > 200 ) {
$var = substr( $var, 0, 200 );
if( ($temp_max = strrpos( $var, '-' )) ) $var = substr( $var, 0, $temp_max );
}
return $var;
}
?>