/** * connect to mysql * */ public static function connect_main($id, $flag = 0) { if ($flag == 1) { //useid $id = floor($id / USERNUM_PERDB); } if (!isset(BasicConfig::$main_mysql_db[$id])) { error_log("get_mysql:conf not set: id={$id}"); return false; } else { return ServerConfig::connect_mysql(BasicConfig::$main_mysql_db[$id]); } }
$weekday = date('N', $now); $day_starttime = strtotime($datestr); $day_endtime = $day_starttime + 86400; echo "date:{$datestr} \nweekday:{$weekday}\n"; $mail_body .= "date:{$datestr} \nweekday:{$weekday}\n"; require_once '../../web/renren/renren.php'; $ren = new Renren(); $ren->api_key = 'a32cb73bea154d2c9d40703b66dc9142'; $ren->secret = '023a6201a9b04955b1af79b1e9037c16'; $ren->init(); $dbconfig = array('host' => '127.0.0.1', 'username' => 'admin', 'password' => '123456', 'port' => '3307', 'charset' => 'utf8', 'dbname' => 'mall_stat'); $cmd = "mysql -u{$dbconfig['username']} -P{$dbconfig['port']} -h{$dbconfig['host']} "; if ($dbconfig['password']) { $cmd .= " -p'{$dbconfig['password']}'"; } $db = ServerConfig::connect_mysql($dbconfig); function getModel($name) { global $db; $m = new DBModel($name, false); $m->setDb($db); $m->useCache(false); return $m; } $g_dgm = getModel('daily_varibles'); function store_varible($pairs) { if (!$pairs) { return; } global $g_dgm, $datestr, $db;
static function setid($id, $strKey, $strKeyName = 'userid') { $db = ServerConfig::connect_mysql(BasicConfig::$genid_mysql_db); $db->delete($strKeyName, "`id`={$id}"); $db->delete($strKeyName, "keyvalue='{$strKey}'"); $db->insert($strKeyName, array('keyvalue' => $strKey, 'id' => $id)); $id = $db->lastInsertId(); if ($id > 0) { //alredy generated self::cache_set($id, $strKey, $strKeyName); return $id; } throw new Exception(__METHOD__ . " failed id={$id} key='{$strKeyName}' value='{$strKey}'"); }
/** * * @param $md5 * @return unknown_type */ static function getMd5($md5) { if (!$md5) { return array(); } $mc = ServerConfig::connect_memcached('cache_server'); $key = $md5; if ($mc) { $ret = $mc->get($key, null); } if ($ret) { return $ret; } $db = ServerConfig::connect_mysql(BasicConfig::$text_mysql_db); $sql = "select * from `texts` where md5sign='{$md5}' "; $row = $db->fetchRow($sql); if ($row) { //alredy generated if ($mc) { $mc->add($key, $row); } return $row; } return $row; }