/**
* 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;
}
