public function getGachaContentsData()
{
$db = CommonDB::connectMasterDB();
$sql = "\n\t\t\tSELECT \n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\tmaster_gacha_contents\n\t\t\t;\n\t\t\t";
$stml = $db->prepare($sql);
$stml->execute();
$ret = $stml->fetchAll(PDO::FETCH_ASSOC);
return $ret;
}
public function getPassFromUid($uid)
{
$db = CommonDB::connectDB();
$sql = "\n\t\t\tSELECT\n\t\t\t\tuid\n\t\t\t\t,pass\n\t\t\t\t,name\n\t\t\tFROM\n\t\t\t\tuser_base_data\n\t\t\tWHERE\n\t\t\t\tuid = :uid\n\t\t\t;\n\t\t";
$stml = $db->prepare($sql);
$stml->bindParam(':uid', $uid);
$stml->execute();
$ret = $stml->fetch(PDO::FETCH_ASSOC);
return $ret;
}
