PageRenderTime 62ms CodeModel.GetById 19ms RepoModel.GetById 1ms app.codeStats 0ms

/source/includes/function/base.php

http://prosporous.googlecode.com/
PHP | 1076 lines | 872 code | 61 blank | 143 comment | 129 complexity | 993b3fa9e6e6af58f544ad7db7e78f21 MD5 | raw file
Possible License(s): LGPL-2.1 
    

  1. <?php

    2. 

  2. //define('ROOT_PATH','sevenel/');

    3. 

  3. function __autoload($class){

    4. 

  4. Sf('ext',$class)&&$class='ext';

    5. 

  5. switch($class){

    6. 

  6. 		case "Smarty" :{

    7. 

  7. 		include($_SERVER['DOCUMENT_ROOT'].ROOT_PATH."Plug-in/smarty/Smarty.class.php");

    8. 

  8. 		break;

    9. 

  9. 		}

    10. 

  10. 		case "xajax" :{

    11. 

  11. 		include($_SERVER['DOCUMENT_ROOT'].ROOT_PATH."Plug-in/xajax/xajax_core/xajax.inc.php");

    12. 

  12. 		break;

    13. 

  13. 		}

    14. 

  14. 		case "ext" :{

    15. 

  15. 		include($_SERVER['DOCUMENT_ROOT'].ROOT_PATH."includes/classes/ext/".$class.".php");

    16. 

  16. 		break;

    17. 

  17. 		}

    18. 

  18. 		default:{

    19. 

  19. 		include($_SERVER['DOCUMENT_ROOT'].ROOT_PATH."includes/classes/".ucfirst($class).".php");

    20. 

  20. 		break;

    21. 

  21. 		}

    22. 

  22. 	}

    23. 

  23. }

    24. 

  24. /**array_unique;array ???? $xian ???????

    25. 

  25.  * @param unknown_type $ar

    26. 

  26.  * @xian str   0 ???????   1 ??????????

    27. 

  27.  * @return  array ???? $xian ???????

    28. 

  28.  */

    29. 

  29. function Au($ar,$xian=0){

    30. 

  30. 	$ar= array_unique($ar);

    31. 

  31. 		switch($xian){

    32. 

  32. 			case 0:{

    33. 

  33. 				return $ar;

    34. 

  34. 			}

    35. 

  35. 			case 1:{

    36. 

  36. 				$var1=array();

    37. 

  37. 				foreach($ar as $valar){

    38. 

  38. 					if($valar!=''){

    39. 

  39. 						$var1[]=$valar;

    40. 

  40. 					}

    41. 

  41. 				}

    42. 

  42. 				return $var1;

    43. 

  43. 

    44. 

  44. 			}

    45. 

  45. 

    46. 

  46. 			default :{

    47. 

  47. 				$var1=array();

    48. 

  48. 			foreach($ar as $valar){

    49. 

  49. 					if(!in_array($valar,$xian)){

    50. 

  50. 						$var1[]=$valar;

    51. 

  51. 					}

    52. 

  52. 

    53. 

  53. 				}

    54. 

  54. 				return $var1;

    55. 

  55. 

    56. 

  56. 			}

    57. 

  57. 		}

    58. 

  58. 

    59. 

  59. }

    60. 

  60. function Dgd($arr){

    61. 

  61. //tn tablename

    62. 

  62. //cd condition

    63. 

  63. //limit num

    64. 

  64. //sql

    65. 

  65. //rt  return type json serialize default return array

    66. 

  66. //start

    67. 

  67. //count

    68. 

  68. //column

    69. 

  69. //tp

    70. 

  70. //db database handle

    71. 

  71. //ce  test sql 1 echo sql and exit 2 only echo sql;

    72. 

  72. 	$arg=func_get_args();

    73. 

  73. 	//print_r($arg);

    74. 

  74. 	$arg=$arg[0];

    75. 

  75. 	global ${$arg['db']};

    76. 

  76. 

    77. 

  77. 	autoAddField(${$arg['db']}->getc('prefix')."_".$arg['tn'],'del');

    78. 

  78. 

    79. 

  79. 	switch(1){

    80. 

  80. 			case $arg['tn']&&$arg['cd']&&$arg['limit']&&$arg['start']=='':{

    81. 

  81. 				$sql="SELECT * FROM `".${$arg['db']}->getc('prefix')."_".$arg['tn']."` WHERE 1 and ".$arg['cd']." limit ".$arg['limit'].";";

    82. 

  82. 				$arg['column']&&$sql="SELECT ".$arg['column']." FROM `".${$arg['db']}->getc('prefix')."_".$arg['tn']."` WHERE 1 and ".$arg['cd']." limit ".$arg['limit'].";";

    83. 

  83. 				break;

    84. 

  84. 				}

    85. 

  85. 			case $arg['tn']&&$arg['cd']&&$arg['limit']&&$arg['start']!='':{

    86. 

  86. 				$sql="SELECT * FROM `".${$arg['db']}->getc('prefix')."_".$arg['tn']."` WHERE 1 and ".$arg['cd']." limit  ".$arg['start'].",".$arg['limit'].";";

    87. 

  87. 				$arg['column']&&$sql="SELECT ".$arg['column']." FROM `".${$arg['db']}->getc('prefix')."_".$arg['tn']."` WHERE 1 and ".$arg['cd']." limit ".$arg['start'].",".$arg['limit'].";";

    88. 

  88. 				break;

    89. 

  89. 				}

    90. 

  90. 			case $arg['sql']!='':{

    91. 

  91. 				$sql=$arg['sql'];

    92. 

  92. 				break;

    93. 

  93. 				}

    94. 

  94. 			default:{

    95. 

  95. 				$sql="SELECT * FROM `".${$arg['db']}->getc('prefix')."_".$arg['tn']."` WHERE 1 and ".$arg['cd']." ;";

    96. 

  96. 				$arg['column']&&$sql="SELECT ".$arg['column']." FROM `".${$arg['db']}->getc('prefix')."_".$arg['tn']."` WHERE 1 and ".$arg['cd']." ;";				break;

    97. 

  97. 				}

    98. 

  98. 		}

    99. 

  99. 				$arg['ce']==1 && die($sql);

    100. 

  100. 				$arg['ce']==2 && Ja($sql);

    101. 

  101. 				$result_arr=${$arg['db']}->Dqsql($sql);

    102. 

  102. 				//print_r($result_arr);

    103. 

  103. 				if($arg['total']){

    104. 

  104. 				$result_total=${$arg['db']}->Dqsql("SELECT count(*) as arrtotal FROM `".${$arg['db']}->getc('prefix')."_".$arg['tn']."` WHERE 1 and ".$arg['cd'].";");

    105. 

  105. 				$result_arr1['data']=$result_arr;

    106. 

  106. 				$result_arr1['total']=$result_total[0]['arrtotal'];

    107. 

  107. 				$result_arr=$result_arr1;

    108. 

  108. 					}

    109. 

  109. 	if($result_arr){

    110. 

  110. 		if ($arg['limit'] == 1) {

    111. 

  111.             if($result_arr[0]){

    112. 

  112.                 $result_arr = $result_arr[0];

    113. 

  113.             }

    114. 

  114.         }

    115. 

  115. 				//$arg['limit']==1&&$result_arr=$result_arr[0];

    116. 

  116. 				if($arg['tp']){

    117. 

  117. 					Tr($result_arr,$arg['tp']);

    118. 

  118. 					}

    119. 

  119. 				if($arg['rt']=='json'){

    120. 

  120. 				$result_arr=json_encode($result_arr);

    121. 

  121. 					}

    122. 

  122. 				if($arg['rt']=='serialize'){

    123. 

  123. 				$result_arr=serialize($result_arr);

    124. 

  124. 					}

    125. 

  125. 				return $result_arr;

    126. 

  126. 		}else{

    127. 

  127. 				return false;

    128. 

  128. 		}

    129. 

  129. }

    130. 

  130. 

    131. 

  131. //initialization class

    132. 

  132. function iniClass($name){

    133. 

  133. 		foreach($name as $value){

    134. 

  134. 		global ${$value['handle']};

    135. 

  135. 		${$value['handle']} = new $value['name']($value['args']);

    136. 

  136. 		Sys::setc($value['name'],$value['handle']);

    137. 

  137. 		//Ja($value['name']);

    138. 

  138. 		}

    139. 

  139. 	}

    140. 

  140. //initialization js Plug-in

    141. 

  141. function iniJs($name){

    142. 

  142. global $jsstr;

    143. 

  143. 		if(!is_array($name)){

    144. 

  144. 			$temp[]=$name;

    145. 

  145. 			$name=$temp;

    146. 

  146. 		}

    147. 

  147. 		foreach($name as $value){

    148. 

  148. 			switch($value){

    149. 

  149. 				case "ext":{

    150. 

  150. 				$jsstr.="<link rel=\"stylesheet\" type=\"text/css\" href=\"".Js_path."/Plug-in/ext/resources/css/ext-all.css\" />

    151. 

  151. 				<link rel=\"stylesheet\" type=\"text/css\" href=\"/Plug-in/ext/resources/css/xtheme-slate.css\" />

    152. 

  152.     <script type=\"text/javascript\" charset=\"utf-8\" src=\"".Js_path."/Plug-in/ext/adapter/ext/ext-base.js\"></script>

    153. 

  153.     <script type=\"text/javascript\" charset=\"utf-8\"  src=\"".Js_path."/Plug-in/ext/ext-all.js\"></script><script type=\"text/javascript\">

    154. 

  154. 	Ext.BLANK_IMAGE_URL = '".Js_path."/Plug-in/ext/resources/images/default/s.gif';

    155. 

  155. 	</script>";

    156. 

  156. 

    157. 

  157. 				break;

    158. 

  158. 				}

    159. 

  159. 				case "jsform":{

    160. 

  160. 

    161. 

  161. 				break;

    162. 

  162. 				}

    163. 

  163. 				case "my97":{

    164. 

  164. 

    165. 

  165. 				break;

    166. 

  166. 				}

    167. 

  167. 				case "lightbox":{

    168. 

  168. 				$jsstr.="<link rel=\"stylesheet\" href=\"/Plug-in/lightbox/css/lightbox.css\" type=\"text/css\" media=\"screen\" />

    169. 

  169. <script type=\"text/javascript\" src=\"/Plug-in/lightbox/prototype.js\"></script>

    170. 

  170. <script type=\"text/javascript\" src=\"/Plug-in/lightbox/scriptaculous.js?load=effects\"></script>

    171. 

  171. <script type=\"text/javascript\" src=\"/Plug-in/lightbox/lightbox.js\"></script>";

    172. 

  172. 				break;

    173. 

  173. 				}

    174. 

  174. 				default:{

    175. 

  175. 				}

    176. 

  176. 			}

    177. 

  177. 		}

    178. 

  178. 	}

    179. 

  179. /**

    180. 

  180.  * *********************

    181. 

  181.  * if No added the function json (javascript object notation) added

    182. 

  182.  */

    183. 

  183. if ( !function_exists('json_decode') ){

    184. 

  184.     function json_decode($content, $assoc=false){

    185. 

  185.                 require_once ($_SERVER['DOCUMENT_ROOT'].ROOT_PATH."includes/classes/Json.php");

    186. 

  186.                 if ( $assoc ){

    187. 

  187.                     $json = new Services_JSON(SERVICES_JSON_LOOSE_TYPE);

    188. 

  188.         } else {

    189. 

  189.                     $json = new Services_JSON;

    190. 

  190.                 }

    191. 

  191.         return $json->decode($content);

    192. 

  192.     }

    193. 

  193. }

    194. 

  194. 

    195. 

  195. if ( !function_exists('json_encode') ){

    196. 

  196.     function json_encode($content){

    197. 

  197.                 require_once ($_SERVER['DOCUMENT_ROOT'].ROOT_PATH."includes/classes/Json.php");

    198. 

  198.                 $json = new Services_JSON;

    199. 

  199.         return $json->encode($content);

    200. 

  200.     }

    201. 

  201. }

    202. 

  202. function stripslashes_deep($value)

    203. 

  203. {

    204. 

  204.     $value = is_array($value) ?

    205. 

  205.                 array_map('stripslashes_deep', $value) :

    206. 

  206.                 stripslashes($value);

    207. 

  207. 

    208. 

  208.     return $value;

    209. 

  209. }

    210. 

  210. 

    211. 

  211. function _uri()

    212. 

  212. {

    213. 

  213.     if (isset($_SERVER['REQUEST_URI']))

    214. 

  214.     {

    215. 

  215.         $uri = $_SERVER['REQUEST_URI'];

    216. 

  216.     }

    217. 

  217.     else

    218. 

  218.     {

    219. 

  219.         if (isset($_SERVER['argv']))

    220. 

  220.         {

    221. 

  221.             $uri = $_SERVER['PHP_SELF'] .'?'. $_SERVER['argv'][0];

    222. 

  222.         }

    223. 

  223.         else

    224. 

  224.         {

    225. 

  225.             $uri = $_SERVER['PHP_SELF'] .'?'. $_SERVER['QUERY_STRING'];

    226. 

  226.         }

    227. 

  227.     }

    228. 

  228.     return $uri;

    229. 

  229. }

    230. 

  230. function Sf($findme,$mystring ){

    231. 

  231. $pos = strpos($mystring, $findme);

    232. 

  232. if ($pos === false) {

    233. 

  233. return false;

    234. 

  234. } else {

    235. 

  235.  return true;

    236. 

  236. }

    237. 

  237. }

    238. 

  238. 

    239. 

  239. function Tr($value,$tmpname){

    240. 

  240. global $Tp;

    241. 

  241. $Tp->assign($tmpname,$value);

    242. 

  242. }

    243. 

  243. function Ts($template,$type=0){

    244. 

  244.   global $Tp;

    245. 

  245.   $Tp->display($template);

    246. 

  246.   if($type ==1){

    247. 

  247.   exit;

    248. 

  248.   }

    249. 

  249. }

    250. 

  250. //????.

    251. 

  251. function Mct(){

    252. 

  252.     list($usec, $sec) = explode(" ", microtime());

    253. 

  253.     return 100*(((float)$usec + (float)$sec));

    254. 

  254. }

    255. 

  255. //??gid??(????author by wangzuolong,????)

    256. 

  256. function Bic() {

    257. 

  257.     list($usec, $sec) = explode(" ", microtime());

    258. 

  258.     $usec = $usec + (rand(1, 400) * rand(400, 900) * rand(900, 1300));

    259. 

  259.     $sec = $sec + (rand(1, 400) * rand(400, 900) * rand(900, 1300));

    260. 

  260.     return floor(100 * (((float) $usec + (float) $sec)));

    261. 

  261. }

    262. 

  262. function getip(){

    263. 

  263.   if (getenv("HTTP_CLIENT_IP") && strcasecmp(getenv("HTTP_CLIENT_IP"), "unknown"))

    264. 

  264.           $ip = getenv("HTTP_CLIENT_IP");

    265. 

  265.       else if (getenv("HTTP_X_FORWARDED_FOR") && strcasecmp(getenv("HTTP_X_FORWARDED_FOR"), "unknown"))

    266. 

  266.           $ip = getenv("HTTP_X_FORWARDED_FOR");

    267. 

  267.       else if (getenv("REMOTE_ADDR") && strcasecmp(getenv("REMOTE_ADDR"), "unknown"))

    268. 

  268.           $ip = getenv("REMOTE_ADDR");

    269. 

  269.       else if (isset($_SERVER['REMOTE_ADDR']) && $_SERVER['REMOTE_ADDR'] && strcasecmp($_SERVER['REMOTE_ADDR'], "unknown"))

    270. 

  270.           $ip = $_SERVER['REMOTE_ADDR'];

    271. 

  271.       else

    272. 

  272.           $ip = "unknown";

    273. 

  273.   return($ip);

    274. 

  274. }

    275. 

  275. //????.

    276. 

  276. function Ja($ar,$url=false){

    277. 

  277. echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">

    278. 

  278. <html xmlns=\"http://www.w3.org/1999/xhtml\">

    279. 

  279. <head>

    280. 

  280. <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />

    281. 

  281. 

    282. 

  282. <script language=\"javascript\"  charset=\"utf-8\">

    283. 

  283. alert('".addslashes($ar)."');";

    284. 

  284. 	if($url){

    285. 

  285. 	echo "window.location ='".$url."';";

    286. 

  286. 	}

    287. 

  287. echo "</script>";

    288. 

  288. }

    289. 

  289. function Di($database,$table,$pairs,$type=0){

    290. 

  290. $app= new Dbt('d_'.$database,$table,$pairs);

    291. 

  291. return $app->getInsertSQL($type);

    292. 

  292. }

    293. 

  293. function Du($database,$table,$pairs,$a,$b,$type=0){

    294. 

  294. $app= new Dbt('d_'.$database,$table,$pairs);

    295. 

  295. return $app->getUpdateSQL($a,$b,$type);

    296. 

  296. }

    297. 

  297. function Dd($database,$table,$a,$b,$type=0,$num){

    298. 

  298. $app= new Dbt('d_'.$database,$table,$pairs);

    299. 

  299. return $app->getDeleteSQL($a,$b,$type,$num);

    300. 

  300. }

    301. 

  301. function get_naps_bot()

    302. 

  302. {

    303. 

  303.         $useragent = strtolower($_SERVER['HTTP_USER_AGENT']);

    304. 

  304. 

    305. 

  305.         if (strpos($useragent, 'googlebot') !== false){

    306. 

  306. 				exit;

    307. 

  307. 				exit;

    308. 

  308. 

    309. 

  309.         }

    310. 

  310. 

    311. 

  311.         if (strpos($useragent, 'msnbot') !== false){

    312. 

  312. 				exit;

    313. 

  313. 				exit;

    314. 

  314.         }

    315. 

  315. 

    316. 

  316.         if (strpos($useragent, 'slurp') !== false){

    317. 

  317. 				exit;

    318. 

  318. 				exit;

    319. 

  319.         }

    320. 

  320. 

    321. 

  321.         if (strpos($useragent, 'baiduspider') !== false){

    322. 

  322. 				exit;

    323. 

  323. 				exit;

    324. 

  324.         }

    325. 

  325. 

    326. 

  326.         if (strpos($useragent, 'sohu-search') !== false){

    327. 

  327. 				exit;

    328. 

  328. 				exit;

    329. 

  329.         }

    330. 

  330. 

    331. 

  331.         if (strpos($useragent, 'lycos') !== false){

    332. 

  332. 				exit;

    333. 

  333. 				exit;

    334. 

  334.         }

    335. 

  335. 

    336. 

  336.         if (strpos($useragent, 'robozilla') !== false){

    337. 

  337. 				exit;

    338. 

  338. 				exit;

    339. 

  339. 				}

    340. 

  340. }

    341. 

  341. //get_naps_bot();

    342. 

  342. //!eregi('win',$_SERVER['HTTP_USER_AGENT'])&&exit;

    343. 

  343. 

    344. 

  344. function adxx($string) {

    345. 

  345. 		if(!get_magic_quotes_gpc()) {

    346. 

  346. 			if(is_array($string)) {

    347. 

  347. 				foreach($string as $key => $val) {

    348. 

  348. 					$string[$key] = adxx($val);

    349. 

  349. 				}

    350. 

  350. 			} else {

    351. 

  351. 				$string = addslashes($string);

    352. 

  352. 			}

    353. 

  353. 		}

    354. 

  354. 		return $string;

    355. 

  355. 	}

    356. 

  356. 

    357. 

  357. function Jt($url,$text="",$time="0.5",$go="0",$templates="loading.html"){

    358. 

  358.      global $Tp;

    359. 

  359.          if (!isset($url)) {

    360. 

  360.               $url="/index.php";

    361. 

  361.          }

    362. 

  362. 		 $time*=1000;

    363. 

  363. 		 if($go!="0"){

    364. 

  364. 			echo "<script LANGUAGE=\"Javascript\">";

    365. 

  365. 			echo "window.location= \"$url\" ";

    366. 

  366. 			echo "</script>";

    367. 

  367. 			exit;

    368. 

  368. 		 }

    369. 

  369.          $Tp->assign('url',$url);

    370. 

  370. 	     $Tp->assign('msg',$text);

    371. 

  371. 		 $Tp->assign('time',$time);

    372. 

  372.         Ts($templates);

    373. 

  373.       exit();

    374. 

  374. }

    375. 

  375. 

    376. 

  376. function Jc($var){ global $_POST ,$_GET,$_FILES,$_SESSION,$_REQUEST,$_SERVER,$_COOKIE,$ttt;

    377. 

  377. 

    378. 

  378. 	print("<pre>");

    379. 

  379. switch ($var)

    380. 

  380. 	{

    381. 

  381. 	  case 'p':

    382. 

  382. 	  	print_r($_POST);

    383. 

  383. 		break;

    384. 

  384. 	  case 'g':

    385. 

  385. 	  	print_r($_GET);

    386. 

  386. 		break;

    387. 

  387. 	  case 'r':

    388. 

  388. 	  	print_r($_REQUEST);

    389. 

  389. 		break;

    390. 

  390. 	  case 's':

    391. 

  391. 	  	print_r($_SESSION);

    392. 

  392. 		break;

    393. 

  393. 	  case 'f':

    394. 

  394. 	  	print_r($_FILES);

    395. 

  395. 		break;

    396. 

  396. 	  case 'c':

    397. 

  397. 	  	print_r($_COOKIE);

    398. 

  398. 		break;

    399. 

  399. 	  case 'e':

    400. 

  400. 	  	print_r($_SERVER);

    401. 

  401. 		break;

    402. 

  402. 	  case 't':

    403. 

  403. 		$ttt->debugging = true;

    404. 

  404. 		break;

    405. 

  405. 	default:

    406. 

  406. 		  	print_r($var);

    407. 

  407. 	}

    408. 

  408. print("</pre>");

    409. 

  409. }

    410. 

  410. function judge($para){

    411. 

  411. 	return $para?'<font color=green>??<b>?</b></font>':'<font color=red>???<b>×</b></font>';

    412. 

  412. 	}

    413. 

  413. function ext_request($msg){

    414. 

  414. 		echo "{success:true,msg:'$msg'}";

    415. 

  415. 		exit();

    416. 

  416. 	}

    417. 

  417. function ext_request_failure($msg){

    418. 

  418. 		echo "{failure:true,msg:'$msg'}";

    419. 

  419. 		exit();

    420. 

  420. 	}

    421. 

  421. function randomkeys($length)

    422. 

  422.   {

    423. 

  423.    $pattern = "1234567890abcdefghijklmnopqrstuvwxyz";

    424. 

  424.    for($i=0;$i<$length;$i++)

    425. 

  425.    {

    426. 

  426.      $key .= $pattern{rand(0,35)};

    427. 

  427.    }

    428. 

  428.    return $key;

    429. 

  429.   }

    430. 

  430. function gettabname($parent_id,$prefix,$noprefix=false){

    431. 

  431. 	$table=Dgd(array(

    432. 

  432. 		  'db'=>'d_sevenel',

    433. 

  433. 		  'cd'=>"id = $parent_id",

    434. 

  434. 		  'tn'=>"datamod",

    435. 

  435. 		  'limit'=>'1'

    436. 

  436. 		  ));

    437. 

  437. 		if($noprefix){

    438. 

  438. 			return $table['tabname'];

    439. 

  439. 		}else{

    440. 

  440. 		$tabname = $prefix.'_'.$table['tabname'];

    441. 

  441. 		return $tabname;

    442. 

  442. 		}

    443. 

  443. }

    444. 

  444. function getItemType($items_array,$compare){

    445. 

  445. 	foreach($items_array as $arrow=>$value){

    446. 

  446. 					if($value['value']==$compare){

    447. 

  447. 						$type = $value['type'];

    448. 

  448. 					}

    449. 

  449. 		}

    450. 

  450. 		$type==''&&$type = " varchar(50) NOT NULL";

    451. 

  451. 	return $type;

    452. 

  452. }

    453. 

  453. function getCommend($value){

    454. 

  454. 	if($value==''){

    455. 

  455. 					$value='';

    456. 

  456. 				}else{

    457. 

  457. 					$value=" COMMENT '".$value."'";

    458. 

  458. 				}

    459. 

  459. 	return $value;

    460. 

  460. }

    461. 

  461. function get_date($format,$timestamp = ''){

    462. 

  462. 		$timeoffset = 8;

    463. 

  463. 		empty($timestamp) && $timestamp = time();

    464. 

  464. 		return gmdate($format,$timestamp+$timeoffset*3600);

    465. 

  465. 	}

    466. 

  466. function is_odd($num){

    467. 

  467. 			if($num%2==0){

    468. 

  468. 				return false;

    469. 

  469. 			}

    470. 

  470. 			else{

    471. 

  471. 				return true;

    472. 

  472. 			}

    473. 

  473. 		}

    474. 

  474. function tableid($tp,$table,$id){

    475. 

  475. 				$temp=Dgd(array(

    476. 

  476. 					  'db'=>'d_sevenel',

    477. 

  477. 					  'cd'=>"id = '".$id."' ",

    478. 

  478. 					  'tn'=>$table,

    479. 

  479. 					  'limit'=>1,

    480. 

  480. 					  'tp'=>$tp

    481. 

  481. 					));

    482. 

  482. 	}

    483. 

  483. function Dga($name,$var,$tttttt=0){

    484. 

  484. $sql="SELECT * FROM `se_".$name."` WHERE 1 and ".$var." limit 1;";

    485. 

  485. if($tttttt!=0)

    486. 

  486. {echo $sql;

    487. 

  487. exit;

    488. 

  488. }mysql_query("Set Names '".DEFAULT_CHARSET."' ");

    489. 

  489. $resouce=mysql_query($sql);

    490. 

  490. if($temp=mysql_fetch_assoc($resouce)){

    491. 

  491. //echo $temp."is".$temp[0];

    492. 

  492. return $temp;

    493. 

  493. }

    494. 

  494. else

    495. 

  495. {

    496. 

  496. return false;

    497. 

  497. }

    498. 

  498. }

    499. 

  499. 

    500. 

  500. function Dgs($name,$var,$tttttt=0){

    501. 

  501. global $prefix;

    502. 

  502. $sql="SELECT * FROM se_".$name." WHERE 1 and ".$var.";";

    503. 

  503. if($tttttt!=0)

    504. 

  504. {echo $sql;

    505. 

  505. exit;

    506. 

  506. }//echo $sql;

    507. 

  507. mysql_query("Set Names '".DEFAULT_CHARSET."' ");

    508. 

  508. $resouce=mysql_query($sql);

    509. 

  509. 

    510. 

  510. $nownum=mysql_num_rows($resouce);

    511. 

  511. while($temp=mysql_fetch_array($resouce))

    512. 

  512. {

    513. 

  513. $temp[znum]=$nownum;

    514. 

  514. $t[]=$temp;

    515. 

  515. //print_r($t);

    516. 

  516. }

    517. 

  517. 

    518. 

  518. if($t){

    519. 

  519. return $t;

    520. 

  520. }

    521. 

  521. else

    522. 

  522. {

    523. 

  523. return false;

    524. 

  524. }

    525. 

  525. }

    526. 

  526. 

    527. 

  527. function fy(

    528. 

  528. 			$param=array(

    529. 

  529. 				'result'	=>'result',

    530. 

  530. 				'table'		=>'',

    531. 

  531. 				'condition'	=>'',

    532. 

  532. 				'perpage'	=>8,

    533. 

  533. 				'type'		=>1,

    534. 

  534. 				'nav'		=>'nav',

    535. 

  535. 				'pagename'	=>'page',

    536. 

  536. 				'debug'

    537. 

  537. 				)

    538. 

  538. ){

    539. 

  539. 	$result		=	$param['result']==''?'result':$param['result'];

    540. 

  540. 	$table		=	$param['table'];

    541. 

  541. 	$condition	=	$param['condition'];

    542. 

  542. 	$perpage	=	$param['perpage']==''?8:$param['perpage'];

    543. 

  543. 	$type		=	$param['type']==''?1:$param['type'];

    544. 

  544. 	$nav		=	$param['nav']==''?'nav':$param['nav'];

    545. 

  545. 	$page_name	=	$param['page_name']==''?'page':$param['page_name'];

    546. 

  546. 

    547. 

  547. 	//????

    548. 

  548. 	!$condition && $condition=1;

    549. 

  549. 	!$result && $result='result';

    550. 

  550. 	!$nav && $nav='nav';

    551. 

  551. 	$sql = "SELECT count(id) as num

    552. 

  552. 		FROM se_{$table}

    553. 

  553. 		where 1  and del!=1  and ".$condition;

    554. 

  554. 

    555. 

  555. 	$res = mysql_query($sql);

    556. 

  556. 

    557. 

  557. 	$num_row = mysql_num_rows($res);

    558. 

  558. 	if(strrpos($condition,'group by')!==false){

    559. 

  559. 		$temp['num'] = $num_row;

    560. 

  560. 	}else{

    561. 

  561. 		$temp = mysql_fetch_array($res);

    562. 

  562. 	}

    563. 

  563. 	//??

    564. 

  564. 	$perpage = $perpage;

    565. 

  565. 	!$_GET[$page_name] && $_GET[$page_name] = 1;

    566. 

  566. 	$ajaxpage = new lm_page( array ('total'=>$temp[num], 'perpage'=>$perpage,'page_name'=>$page_name));

    567. 

  567. 	mysql_free_result($res);

    568. 

  568. 	Tr($ajaxpage->show($type),$nav);

    569. 

  569. 

    570. 

  570. 	if($param['debug']!=''){

    571. 

  571. 

    572. 

  572. 		Jc('<b>SQL:</b><br />');

    573. 

  573. 		Jc("SELECT * FROM se_{$table} WHERE 1 AND del!=1 and {$condition} limit ".($_GET[$page_name]-1)*$perpage.",".$perpage);

    574. 

  574. 

    575. 

  575. 		Jc('<b>Result:</b><br />');

    576. 

  576. 		Jc(Dgs($table,"del!=1 and {$condition} limit ".($_GET[$page_name]-1)*$perpage.",".$perpage));

    577. 

  577. 

    578. 

  578. 		Jc('<b>SQL:</b><br />');

    579. 

  579. 		Dgs($table,"del!=1 and {$condition} limit ".($_GET[$page_name]-1)*$perpage.",".$perpage,1);

    580. 

  580. 	}

    581. 

  581. 	$R=Dgs($table,"del!=1 and {$condition} limit ".($_GET[$page_name]-1)*$perpage.",".$perpage.$debug);

    582. 

  582. 	Tr($R,$result);

    583. 

  583. 	return $R;

    584. 

  584. }

    585. 

  585. function cutstr($string, $sublen, $start = 0, $code = 'UTF-8'){

    586. 

  586.     if($code == 'UTF-8')

    587. 

  587.     {

    588. 

  588.         $pa = "/[\x01-\x7f]|[\xc2-\xdf][\x80-\xbf]|\xe0[\xa0-\xbf][\x80-\xbf]|[\xe1-\xef][\x80-\xbf][\x80-\xbf]|\xf0[\x90-\xbf][\x80-\xbf][\x80-\xbf]|[\xf1-\xf7][\x80-\xbf][\x80-\xbf][\x80-\xbf]/";

    589. 

  589.         preg_match_all($pa, $string, $t_string);

    590. 

  590. 

    591. 

  591.         if(count($t_string[0]) - $start > $sublen) return join('', array_slice($t_string[0], $start, $sublen))."...";

    592. 

  592.         return join('', array_slice($t_string[0], $start, $sublen));

    593. 

  593.     }

    594. 

  594.     else

    595. 

  595.     {

    596. 

  596.         $start = $start*2;

    597. 

  597.         $sublen = $sublen*2;

    598. 

  598.         $strlen = strlen($string);

    599. 

  599.         $tmpstr = '';

    600. 

  600. 

    601. 

  601.         for($i=0; $i<$strlen; $i++)

    602. 

  602.         {

    603. 

  603.             if($i>=$start && $i<($start+$sublen))

    604. 

  604.             {

    605. 

  605.                 if(ord(substr($string, $i, 1))>129)

    606. 

  606.                 {

    607. 

  607.                     $tmpstr.= substr($string, $i, 2);

    608. 

  608.                 }

    609. 

  609.                 else

    610. 

  610.                 {

    611. 

  611.                     $tmpstr.= substr($string, $i, 1);

    612. 

  612.                 }

    613. 

  613.             }

    614. 

  614.             if(ord(substr($string, $i, 1))>129) $i++;

    615. 

  615.         }

    616. 

  616.         if(strlen($tmpstr)<$strlen ) $tmpstr.= "...";

    617. 

  617.         return $tmpstr;

    618. 

  618.     }

    619. 

  619. }

    620. 

  620. 

    621. 

  621. function createthumb($src,$otype,$album,$wd,$hd,$ml,$im_des){

    622. 

  622. 	if($otype!=".bmp")

    623. 

  623. 	{

    624. 

  624. 	$type=strtolower($otype);

    625. 

  625. 	if($im_des==''){

    626. 

  626. 	$im_des="../../uplods/thumb".$ml."/".$album.".jpg";

    627. 

  627. 	}

    628. 

  628. 	if($type==".jpg"||$type==".jpeg")

    629. 

  629. 		$im=@imagecreatefromjpeg($src);

    630. 

  630. 	if($type==".gif")

    631. 

  631. 		$im=@imagecreatefromgif($src);

    632. 

  632. 	if($type==".png")

    633. 

  633. 		$im=@imagecreatefrompng($src);

    634. 

  634. 	$width=@imagesx($im);

    635. 

  635. 	$height=@imagesy($im);

    636. 

  636. 	@$ratio=$height/$width;

    637. 

  637. 	if($ratio<0.9)

    638. 

  638. 	{

    639. 

  639. 		$newwidth=$wd;

    640. 

  640. 		@$newheight=$height*($wd/$width);

    641. 

  641. 	}

    642. 

  642. 	else

    643. 

  643. 	{

    644. 

  644. 		$newheight=$hd;

    645. 

  645. 		$newwidth=$width*($hd/$height);

    646. 

  646. 	}

    647. 

  647. 	$im_s=@imagecreatetruecolor($newwidth,$newheight);

    648. 

  648. 	@imagecopyresized($im_s,$im,0,0,0,0,$newwidth,$newheight,$width,$height);

    649. 

  649. 	@imagejpeg($im_s,$im_des,70);

    650. 

  650. 	chmod($im_des,0777);

    651. 

  651. 	@imagedestroy($im);

    652. 

  652. 	}

    653. 

  653. }

    654. 

  654. /*

    655. 

  655. * ???PHP???? (?????????)

    656. 

  656. * ???

    657. 

  657. *      $groundImage    ???????????????????GIF,JPG,PNG???

    658. 

  658. *      $waterPos        ??????10????0??????

    659. 

  659. *                        1??????2??????3??????

    660. 

  660. *                        4??????5??????6??????

    661. 

  661. *                        7??????8??????9??????

    662. 

  662. *      $waterImage        ??????????????????GIF,JPG,PNG???

    663. 

  663. *      $waterText        ?????????????????ASCII????????

    664. 

  664. *      $textFont        ????????12???????

    665. 

  665. *      $textColor        ??????????????????#FF0000(??)?

    666. 

  666. *

    667. 

  667. * ???Support GD 2.0?Support FreeType?GIF Read?GIF Create?JPG ?PNG

    668. 

  668. *      $waterImage ? $waterText ????????????????????? $waterImage?

    669. 

  669. *      ?$waterImage??????$waterString?$stringFont?$stringColor?????

    670. 

  670. *      ???????????? $groundImage ???

    671. 

  671. * ???longware @ 2004-11-3 14:15:13

    672. 

  672. * ???Zuolong @ 2010?01?29? ??? 14?34?54?

    673. 

  673. *       ??????????????????????

    674. 

  674. */

    675. 

  675. function imageWaterMark($groundImage,$bcmz,$waterPos=0,$waterImage="",$waterText="",$textFont=12,$syzt="wqy-microhei-lite.ttc",$textColor="#FF0000")

    676. 

  676. {

    677. 

  677.     $isWaterImage = FALSE;

    678. 

  678.     $formatMsg = "????????????????????????GIF?JPG?PNG???";

    679. 

  679.     $font_file="../fonts/".$syzt;     //?????????

    680. 

  680. 

    681. 

  681.     //??????

    682. 

  682.     if(!empty($waterImage) && file_exists($waterImage))

    683. 

  683.     {

    684. 

  684.         $isWaterImage = TRUE;

    685. 

  685.         $water_info = getimagesize($waterImage);

    686. 

  686.         $water_w    = $water_info[0];//????????

    687. 

  687.         $water_h    = $water_info[1];//????????

    688. 

  688. 

    689. 

  689.         switch($water_info[2])//?????????

    690. 

  690.         {

    691. 

  691.             case 1:$water_im = imagecreatefromgif($waterImage);break;

    692. 

  692.             case 2:$water_im = imagecreatefromjpeg($waterImage);break;

    693. 

  693.             case 3:$water_im = imagecreatefrompng($waterImage);break;

    694. 

  694.             default:ja($formatMsg);

    695. 

  695.         }

    696. 

  696.     }

    697. 

  697. 

    698. 

  698.     //??????

    699. 

  699.     if(!empty($groundImage) && file_exists($groundImage))

    700. 

  700.     {

    701. 

  701.         $ground_info = getimagesize($groundImage);

    702. 

  702.         $ground_w    = $ground_info[0];//????????

    703. 

  703.         $ground_h    = $ground_info[1];//????????

    704. 

  704. 

    705. 

  705.         switch($ground_info[2])//?????????

    706. 

  706.         {

    707. 

  707.             case 1:$ground_im = imagecreatefromgif($groundImage);break;

    708. 

  708.             case 2:$ground_im = imagecreatefromjpeg($groundImage);break;

    709. 

  709.             case 3:$ground_im = imagecreatefrompng($groundImage);break;

    710. 

  710.             default:ja($formatMsg);

    711. 

  711.         }

    712. 

  712.     }

    713. 

  713.     else

    714. 

  714.     {

    715. 

  715.         Ja("????????????");

    716. 

  716.     }

    717. 

  717. 

    718. 

  718.     //????

    719. 

  719.     if($isWaterImage)//????

    720. 

  720.     {

    721. 

  721.         $w = $water_w;

    722. 

  722.         $h = $water_h;

    723. 

  723.         $label = "???";

    724. 

  724.     }

    725. 

  725.     else//????

    726. 

  726.     {

    727. 

  727.         $temp = imagettfbbox($textFont,0,$font_file,$waterText);//???? TrueType ????????

    728. 

  728.         $w = $temp[2] - $temp[6];

    729. 

  729.         $h = $temp[3] - $temp[7];

    730. 

  730.         unset($temp);

    731. 

  731.         $label = "????";

    732. 

  732.     }

    733. 

  733.     if( ($ground_w<$w) || ($ground_h<$h) )

    734. 

  734.     {

    735. 

  735.        ja("?????????????????".$label."??????????");

    736. 

  736.         return;

    737. 

  737.     }

    738. 

  738.     switch($waterPos)

    739. 

  739.     {

    740. 

  740.         case 0://??

    741. 

  741.             $posX = rand(0,($ground_w - $w));

    742. 

  742.             $posY = rand(0,($ground_h - $h));

    743. 

  743.             break;

    744. 

  744.         case 1://1?????

    745. 

  745.             $posX = 0;

    746. 

  746.             $posY = 0;

    747. 

  747.             break;

    748. 

  748.         case 2://2?????

    749. 

  749.             $posX = ($ground_w - $w) / 2;

    750. 

  750.             $posY = 0;

    751. 

  751.             break;

    752. 

  752.         case 3://3?????

    753. 

  753.             $posX = $ground_w - $w;

    754. 

  754.             $posY = 0;

    755. 

  755.             break;

    756. 

  756.         case 4://4?????

    757. 

  757.             $posX = 0;

    758. 

  758.             $posY = ($ground_h - $h) / 2;

    759. 

  759.             break;

    760. 

  760.         case 5://5?????

    761. 

  761.             $posX = ($ground_w - $w) / 2;

    762. 

  762.             $posY = ($ground_h - $h) / 2;

    763. 

  763.             break;

    764. 

  764.         case 6://6?????

    765. 

  765.             $posX = $ground_w - $w;

    766. 

  766.             $posY = ($ground_h - $h) / 2;

    767. 

  767.             break;

    768. 

  768.         case 7://7?????

    769. 

  769.             $posX = 0;

    770. 

  770.             $posY = $ground_h - $h;

    771. 

  771.             break;

    772. 

  772.         case 8://8?????

    773. 

  773.             $posX = ($ground_w - $w) / 2;

    774. 

  774.             $posY = $ground_h - $h;

    775. 

  775.             break;

    776. 

  776.         case 9://9?????

    777. 

  777.             $posX = $ground_w - $w;

    778. 

  778.             $posY = $ground_h - $h;

    779. 

  779.             break;

    780. 

  780.         default://??

    781. 

  781.             $posX = rand(0,($ground_w - $w));

    782. 

  782.             $posY = rand(0,($ground_h - $h));

    783. 

  783.             break;

    784. 

  784.     }

    785. 

  785. 

    786. 

  786.     //?????????

    787. 

  787.     imagealphablending($ground_im, true);

    788. 

  788. 

    789. 

  789.     if($isWaterImage)//????

    790. 

  790.     {

    791. 

  791.         imagecopy($ground_im, $water_im, $posX, $posY, 0, 0, $water_w,$water_h);//?????????

    792. 

  792.     }

    793. 

  793.     else//????

    794. 

  794.     {

    795. 

  795.         if( !empty($textColor) && (strlen($textColor)==7) )

    796. 

  796.         {

    797. 

  797.             $R = hexdec(substr($textColor,1,2));

    798. 

  798.             $G = hexdec(substr($textColor,3,2));

    799. 

  799.             $B = hexdec(substr($textColor,5));

    800. 

  800.         }

    801. 

  801.         else

    802. 

  802.         {

    803. 

  803.             ja("????????????");

    804. 

  804.         }

    805. 

  805.         if(!is_file($font_file)){

    806. 

  806.             ja("???????????????????{$font_file}");

    807. 

  807.         }

    808. 

  808.         //imagestring ( $ground_im, $textFont, $posX, $posY, $waterText, imagecolorallocate($ground_im, $R, $G, $B));

    809. 

  809.         imagettftext ( $ground_im, $textFont, 0, $posX, $posY, imagecolorallocate($ground_im, $R, $G, $B), $font_file, $waterText);

    810. 

  810.     }

    811. 

  811. 

    812. 

  812.     //????????

    813. 

  813.     @unlink($bcmz);

    814. 

  814.     switch($ground_info[2])//?????????

    815. 

  815.     {

    816. 

  816.         case 1:imagegif($ground_im,$bcmz);break;

    817. 

  817.         case 2:imagejpeg($ground_im,$bcmz);break;

    818. 

  818.         case 3:imagepng($ground_im,$bcmz);break;

    819. 

  819.         default:ja($errorMsg);

    820. 

  820.     }

    821. 

  821. 

    822. 

  822.     //????

    823. 

  823.     if(isset($water_info)) unset($water_info);

    824. 

  824.     if(isset($water_im)) imagedestroy($water_im);

    825. 

  825.     unset($ground_info);

    826. 

  826.     imagedestroy($ground_im);

    827. 

  827. }

    828. 

  828. function getfirstchar($s0){

    829. 

  829. 	$fchar = ord($s0{0});

    830. 

  830. 	if($fchar >= ord("A") and $fchar <= ord("z") )return strtoupper($s0{0});

    831. 

  831. 	$s1 = iconv("UTF-8","gb2312", $s0);

    832. 

  832. 	$s2 = iconv("gb2312","UTF-8", $s1);

    833. 

  833. 	if($s2 == $s0){$s = $s1;}else{$s = $s0;}

    834. 

  834. 	$asc = ord($s{0}) * 256 + ord($s{1}) - 65536;

    835. 

  835. if($asc>=-20319 and $asc<=-20284)return "a";

    836. 

  836.  if($asc>=-20283 and $asc<=-19776)return "b";

    837. 

  837.  if($asc>=-19775 and $asc<=-19219)return "c";

    838. 

  838.  if($asc>=-19218 and $asc<=-18711)return "d";

    839. 

  839.  if($asc>=-18710 and $asc<=-18527)return "e";

    840. 

  840.  if($asc>=-18526 and $asc<=-18240)return "f";

    841. 

  841.  if($asc>=-18239 and $asc<=-17923)return "g";

    842. 

  842.  if($asc>=-17922 and $asc<=-17418)return "h";

    843. 

  843. if($asc>=-17417 and $asc<=-16475)return "j";

    844. 

  844. if($asc>=-16474 and $asc<=-16213)return "k";

    845. 

  845. if($asc>=-16212 and $asc<=-15641)return "l";

    846. 

  846. if($asc>=-15640 and $asc<=-15166)return "m";

    847. 

  847. if($asc>=-15165 and $asc<=-14923)return "n";

    848. 

  848. if($asc>=-14922 and $asc<=-14915)return "o";

    849. 

  849. if($asc>=-14914 and $asc<=-14631)return "p";

    850. 

  850. if($asc>=-14630 and $asc<=-14150)return "q";

    851. 

  851. if($asc>=-14149 and $asc<=-14091)return "r";

    852. 

  852. if($asc>=-14090 and $asc<=-13319)return "s";

    853. 

  853. if($asc>=-13318 and $asc<=-12839)return "t";

    854. 

  854. if($asc>=-12838 and $asc<=-12557)return "w";

    855. 

  855. if($asc>=-12556 and $asc<=-11848)return "x";

    856. 

  856. if($asc>=-11847 and $asc<=-11056)return "y";

    857. 

  857. if($asc>=-11055 and $asc<=-10247)return "z";

    858. 

  858. 

    859. 

  859. 	return null;

    860. 

  860. }

    861. 

  861. function pinyin1($zh){

    862. 

  862. 	$ret = "";

    863. 

  863.     $s1 = iconv("UTF-8","gb2312", $zh);

    864. 

  864.     $s2 = iconv("gb2312","UTF-8", $s1);

    865. 

  865.     if($s2 == $zh){$zh = $s1;}

    866. 

  866. 	for($i = 0; $i < strlen($zh); $i++){

    867. 

  867. 		$s1 = substr($zh,$i,1);

    868. 

  868. 		$p = ord($s1);

    869. 

  869. 		if($p > 160){

    870. 

  870. 			$s2 = substr($zh,$i++,2);

    871. 

  871. 			$ret .= getfirstchar($s2);

    872. 

  872. 		}else{

    873. 

  873. 			$ret .= $s1;

    874. 

  874. 		}

    875. 

  875. 	}

    876. 

  876. 	return $ret;

    877. 

  877. }

    878. 

  878. 

    879. 

  879. /*

    880. 

  880. ????1?

    881. 

  881. 

    882. 

  882. RewriteEngine on

    883. 

  883. RewriteCond %{HTTP_USER_AGENT} ^Baiduspider [NC]

    884. 

  884. RewriteRule .* - [F]

    885. 

  885. 

    886. 

  886. ????2?

    887. 

  887. 

    888. 

  888. SetEnvIfNoCase User-Agent "^Baiduspider" bad_bot

    889. 

  889. 

    890. 

  890. <Limit GET POST>

    891. 

  891. Order Allow,Deny

    892. 

  892. Allow from all

    893. 

  893. Deny from env=bad_bot

    894. 

  894. </Limit>

    895. 

  895. */

    896. 

  896. 

    897. 

  897. function Dz($sql, $ttttt=0) {

    898. 

  898.     global $db;

    899. 

  899.     mysql_query("Set Names '" . DEFAULT_CHARSET . "' ");

    900. 

  900.     if ($ttttt != 0) {

    901. 

  901.         echo $sql;

    902. 

  902.         exit;

    903. 

  903.     }

    904. 

  904.     $result = mysql_query($sql);

    905. 

  905.     while ($temp = mysql_fetch_array($result)) {

    906. 

  906.         $tempa[] = $temp;

    907. 

  907.     }

    908. 

  908.     mysql_free_result($result);

    909. 

  909.     return $tempa;

    910. 

  910. }

    911. 

  911. 

    912. 

  912. /**

    913. 

  913.  * *******************

    914. 

  914.  * ?????html??

    915. 

  915.  */

    916. 

  916. function clearhtml($str) {

    917. 

  917.     $strtemp = trim($str);

    918. 

  918.     $search = array(

    919. 

  919.         "|'|Uis",

    920. 

  920.         "|<script[^>]*?>.*?</script>|Uis", // ?? javascript

    921. 

  921.         "|<[\/\!]*?[^<>]*?>|Uis", // ?? HTML ??

    922. 

  922.         "'&(quot|#34);'i", // ?? HTML ??

    923. 

  923.         "'&(amp|#38);'i",

    924. 

  924.         "|,|Uis",

    925. 

  925.         "|[\s]{2,}|is",

    926. 

  926.         "[&nbsp;]isu",

    927. 

  927.         "|[$]|Uis",

    928. 

  928.     );

    929. 

  929.     $replace = array(

    930. 

  930.         "`",

    931. 

  931.         "",

    932. 

  932.         "",

    933. 

  933.         "",

    934. 

  934.         "","",

    935. 

  935.  " ",

    936. 

  936.  " ",

    937. 

  937.  " dollar ",

    938. 

  938. );

    939. 

  939. $text = preg_replace($search, $replace, $strtemp);

    940. 

  940. return $text;

    941. 

  941. }

    942. 

  942. /**

    943. 

  943.  * ?????

    944. 

  944.  *  ????5.3????? date_diff???? ?date_diff_bic

    945. 

  945.  *

    946. 

  946.  * @param string time $date1	Y-m-d H:i:s

    947. 

  947.  * @param string time $date2	Y-m-d H:i:s

    948. 

  948.  * @param string $return_type

    949. 

  949.  * 		????:'s'-?	'i'-?	'h'-??		'd'-?	'w'-??		'm'-?	'y'-?

    950. 

  950.  * 		??:'d'-?

    951. 

  951.  * @param bool $ceil

    952. 

  952.  * 		??????

    953. 

  953.  * 		??:false

    954. 

  954.  * @return numeric

    955. 

  955.  * @author Bic

    956. 

  956.  * 		2009?9?26? 10?28?46?

    957. 

  957.  * 		2010?6?9?   ?????

    958. 

  958.  */

    959. 

  959. function date_diff_bic($date1, $date2, $return_type='d',$ceil=false) {

    960. 

  960.     $timestamp1 = is_numeric($date1)?$date1:strtotime($date1);

    961. 

  961.     $timestamp2 = is_numeric($date2)?$date2:strtotime($date2);

    962. 

  962.     switch ($return_type){

    963. 

  963.         case 's':

    964. 

  964.         case 'second':

    965. 

  965.             $result = ($timestamp2-$timestamp1);

    966. 

  966.             break;

    967. 

  967.         case 'i':

    968. 

  968.         case 'minute':

    969. 

  969.             $result = ($timestamp2-$timestamp1)/60;

    970. 

  970.             break;

    971. 

  971.         case 'h':

    972. 

  972.         case 'hour':

    973. 

  973.             $result = ($timestamp2-$timestamp1)/3600;

    974. 

  974.             break;

    975. 

  975.         case 'd':

    976. 

  976.         case 'day':

    977. 

  977.             $result = ($timestamp2-$timestamp1)/86400;

    978. 

  978.             break;

    979. 

  979.         case 'w':

    980. 

  980.         case 'week':

    981. 

  981.             $result = ($timestamp2-$timestamp1)/604800;

    982. 

  982.             break;

    983. 

  983.         case 'm':

    984. 

  984.         case 'month':

    985. 

  985.             $result = ($timestamp2-$timestamp1)/2592000;

    986. 

  986.             break;

    987. 

  987.         case 'y':

    988. 

  988.         case 'year':

    989. 

  989.             $result = ($timestamp2-$timestamp1)/946080000;

    990. 

  990.             break;

    991. 

  991.     }

    992. 

  992.     return $ceil?ceil($result):floor($result);

    993. 

  993. }

    994. 

  994. 

    995. 

  995. /**

    996. 

  996.  *????del??

    997. 

  997.  * @param type $table   ??

    998. 

  998.  * @param type $fields  ????????????“,”

    999. 

  999.  * @param type $fieldType ????

    1000. 

  1000.  * @param type $fieldLength ????

    1001. 

  1001.  */

    1002. 

  1002. function autoAddField($table,$fields,$fieldType='TINYINT',$fieldLength=1){

    1003. 

  1003.     $rec = mysql_query("SHOW FULL FIELDS FROM {$table}");

    1004. 

  1004.     $fields = explode(',',$fields);

    1005. 

  1005.     foreach ($fields as $k => $v){

    1006. 

  1006.         $hadDelField = 0;

    1007. 

  1007.         while($fullfields = mysql_fetch_array($rec)){

    1008. 

  1008.             if($fullfields['Field']==$v){

    1009. 

  1009.                 $hadDelField = 1;

    1010. 

  1010.                 break;

    1011. 

  1011.             }

    1012. 

  1012.         }

    1013. 

  1013.         if($hadDelField != 1){

    1014. 

  1014.             mysql_query("ALTER TABLE `{$table}` ADD `{$v}` {$fieldType}( {$fieldLength} ) NOT NULL ;");

    1015. 

  1015.         }

    1016. 

  1016.     }

    1017. 

  1017. }

    1018. 

  1018. 

    1019. 

  1019. /**

    1020. 

  1020.  *???????

    1021. 

  1021.  * ???Du?????

    1022. 

  1022.  * @param type $table   ??

    1023. 

  1023.  * @param type $pairs   ??

    1024. 

  1024.  * @param type $debug   ??

    1025. 

  1025.  * @return type

    1026. 

  1026.  */

    1027. 

  1027. function I($table,$pairs,$debug=false){

    1028. 

  1028.     $app = new Dbt('d_sevenel',$table,$pairs);

    1029. 

  1029.     $app -> debug($debug);

    1030. 

  1030.     return $app->getInsertSQL(2);

    1031. 

  1031. }

    1032. 

  1032. 

    1033. 

  1033. /**

    1034. 

  1034.  *???????

    1035. 

  1035.  * ???Du?????

    1036. 

  1036.  * @param type $table   ??

    1037. 

  1037.  * @param type $pairs   ??

    1038. 

  1038.  * @param type $field   ??

    1039. 

  1039.  * @param type $val   ?

    1040. 

  1040.  * @param type $debug   ??

    1041. 

  1041.  * @return type

    1042. 

  1042.  */

    1043. 

  1043. function U($table,$pairs,$field,$val,$debug=false){

    1044. 

  1044.     $app= new Dbt('d_sevenel',$table,$pairs);

    1045. 

  1045.     $app -> debug($debug);

    1046. 

  1046.     return $app->getUpdateSQL($field,$val,2);

    1047. 

  1047. }

    1048. 

  1048. 

    1049. 

  1049. 

    1050. 

  1050. /**

    1051. 

  1051.  *Dga + Tr

    1052. 

  1052.  * @param type $tpl     ???

    1053. 

  1053.  * @param type $table   ??

    1054. 

  1054.  * @param type $con     ??

    1055. 

  1055.  * @param type $debug   ????SQL??

    1056. 

  1056.  * @return type

    1057. 

  1057.  */

    1058. 

  1058. function Tra($tpl,$table,$con,$debug=0){

    1059. 

  1059. 	$tmp = Dga($table,$con,$debug);

    1060. 

  1060. 	Tr($tmp,$tpl);

    1061. 

  1061. 	return $tmp;

    1062. 

  1062. }

    1063. 

  1063. 

    1064. 

  1064. /**

    1065. 

  1065.  *Dgs + Tr

    1066. 

  1066.  * @param type $tpl     ???

    1067. 

  1067.  * @param type $table   ??

    1068. 

  1068.  * @param type $con     ??

    1069. 

  1069.  * @param type $debug   ????SQL??

    1070. 

  1070.  * @return type

    1071. 

  1071.  */

    1072. 

  1072. function Trs($tpl,$table,$con,$debug=0){

    1073. 

  1073. 	$tmp = Dgs($table,$con,$debug);

    1074. 

  1074. 	Tr($tmp,$tpl);

    1075. 

  1075. 	return $tmp;

    1076. 

  1076. }

    1077. 

  1077.