示例#1
0
             $me_url = $gg_a['link'];
             if ($r_dby['s_n'] != $me_url || $r_dby['s_id'] != $gg_a['id']) {
                 $u_db = sprintf('update %s set s_n=%s, s_id=%s where id=%s', $dbprefix . 'm_sync', SQLString($me_url, 'text'), SQLString($gg_a['id'], 'text'), $r_dby['id']);
                 $result = mysql_query($u_db) or die('');
             }
             $content .= '当前已绑定Google账号<table width="200"><tr><td align="center"><img src="' . $gg_a['picture'] . '" alt=""/><br/><a href="' . $me_url . '" target="_blank">' . $gg_a['name'] . '</a>(<a href="?m=profile&amp;t=sync&amp;n=' . $nct . '&amp;lt=1">取消绑定</a>)</td></tr></table>';
             $content .= '<br/><br/><form method="post" action=""><input type="checkbox" name="is_show" value="1"' . ($r_dby['is_show'] > 0 ? ' checked="checked"' : '') . '/>隐藏已绑定Google账号相关信息<br/><input type="submit" value="更新" class="button"/><input type="hidden" name="isl_google_h" value="' . $r_dby['id'] . '"/></form>';
         } else {
             $d_db = sprintf('delete from %s where aid=%s and name=%s', $dbprefix . 'm_sync', $r_dbu['id'], SQLString($nct, 'text'));
             $result = mysql_query($d_db) or die('');
         }
     }
     mysql_free_result($q_dby);
     if ($is_sync == 0) {
         $gg_o = new googlePHP($config['google_key'], $config['google_se']);
         $aurl = $gg_o->login_url($config['site_url'] . 'google_callback.php', 'https://www.googleapis.com/auth/userinfo.profile');
         $content .= '<a href="' . $aurl . '">点击此处和您的Google账号建立连接</a>';
     }
     $content .= '<br/><br/>绑定Google账号后将实现以下功能:<ol><li>使用Google账号登录</li><li>注:Google账号不可以重复绑定,用户绑定后,其他用户绑定的同一Google账号将自动解除绑定</li></ol>';
     break;
 case 'live':
     if (isset($_GET['lt']) && $_GET['lt'] == 1) {
         $d_db = sprintf('delete from %s where aid=%s and name=%s', $dbprefix . 'm_sync', $r_dbu['id'], SQLString($nct, 'text'));
         $result = mysql_query($d_db) or die('');
         header('Location:./?m=profile&t=sync&n=' . $nct);
         exit;
     }
     require_once 'lib/live.php';
     $is_sync = 0;
     $s_dby = sprintf('select id, s_id, s_t, s_r, edate, is_show from %s where aid=%s and name=%s limit 1', $dbprefix . 'm_sync', $r_dbu['id'], SQLString($nct, 'text'));
     $q_dby = mysql_query($s_dby) or die('');