SQL Error in Tap Tap Revenge 4

如下所示,这个SQL没有做任何处理,当city出现 ‘ 这样的符号时,将会在客户端直接报出错误来。

INSERT INTO tapulous.users_location(
    device_id,
    ip_address,
    city,
    state,
    country,
    latitude,
    longitude,
    time,
    last_updated)
VALUES
(...)
ON DUPLICATE KEY UPDATE
    ip_address='',
    city='',
    state='',
    country='',
    latitude='',
    longitude='',
    last_updated=NOW()
Advertisements

浅析Facebook新的消息系统

今天Facebook发布了这样一个页面(传送门),点击按钮后就加入了新的消息功能的邀请队列。

Facebook的这一功能之前被称为Project Titan,号称“Gmail杀手”。

在这个页面上体现的功能不多,在这个页面有不少细节。现进行一些分析:

  • All your messages together

Get Facebook messages, chats and texts all in the same place, including email by activating your optional Facebook email address, and control who can send you messages through your privacy settings.

新的信息系统是对Facebook内各种feed和聊天记录的一个整合。——对我这样的人来说完全没有意义。

  • Full conversion history

See everything you’ve ever discussed with each friend as a single conversation, no need for subject lines or other formalities, and you can easily leave large converstaions that no longer interest you.

按好友分类的信息……好吧,现在貌似是个邮件系统都支持这个功能……应该说是Gmail首创的吧。这个实在没啥卖点……

并且,目前无法从对话中删除单条消息(you cannot delete an individual message from a conversion)。

  • The message you want

Focus on messages from your friends, messages from unknown senders and bulk email go into the Other folder, and spam is hidden from view automatically.

貌似垃圾邮件和自动分类也是Gmail做的最好吧……

在FAQ中,花了不少篇幅讲解这个“可定制的”隐私系统,大意是说,虽然所有人都能给你发消息,但是除了你的好友之外的人发的消息都会自动跑到“Other”这个文件夹里面去(不得不说,把这些和垃圾邮件放一起实在是个很烂的决定)。

不过,apps需要得到用户许可才能给用户发消息,这一点做的还是不错的。

Test update from iPT

Hello world from iPod Touch!

更新一下吧

今天Windows Live Space换用WordPress了,功能的确强大,那么就来冒个泡吧。

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!

校内网 BT 的用户协议

我们都知道很多用户协议其实都是霸王条款,但是大家往往都没有仔细研究。今天突然心血来潮,想考察一下著名的SNS的用户协议。那么,就从本人深恶痛绝的校内网开刀吧!

校内网服务条款全文

 

下面只摘抄比较BT的部分:

2、考虑到千橡公司产品服务的重要性,用户同意:
(1)提供及时、详尽及准确个人资料
(2)不断更新注册资料,符合及时、详尽准确的要求。所有原始键入的资料将引用为注册资料。

注意后面还有这个:

4、如果用户提供的资料不准确,不真实,不合法有效,千橡公司保留结束用户使用千橡公司各项服务的权利。

因此,如果哪天有人整容以后没有及时更新自己的头像,可能会被封停帐号哦……

 

再来看这个:

3、用户可授权千橡公司向第三方透露其注册资料,否则千橡公司不能公开用户的姓名、住址、出件地址、电子邮箱、帐号。除非:
(1)事先获得用户明确授权后,用户要求千橡公司或授权某人通过电子邮件服务或其他方式透露这些信息。(2)相应的法律、法规要求以及按照有关政府主管部门的要求,需要千橡公司提供用户的个人资料。
(3)为了维护公众以及校内网合法利益。
(4)校内网可能会与第三方合作向用户提供相关的网络服务,在此情况下,如该第三方同意承担与校内网同等的保护用户隐私的责任,则校内网有权将用户的注册资料等提供给该第三方。
(5)在不透露单个用户隐私资料的前提下,校内网有权对整个用户数据库进行分析并对用户数据库进行商业上的利用。

第(4)的意思:如果有第四方、第五方以及第N方,其中任意一方愿意“与第N+1方合作,向用户提供相关的网络服务”(垃圾邮件也算是相关的网络服务吧……)并同意承担与校内网同等的责任,那么都能获得用户在校内网上的注册资料(注意这些都是真实、有效和及时的资料)。

第(5)的意思是校内网可以在透露“多于一个”的用户的隐私资料的前提下,对用户数据库进行商业上的利用。

 

用户在享用千橡公司各项服务的同时,同意接受千橡公司提供的各类信息服务。
5、千橡公司定义的信息内容包括:文字、软件、声音、相片、录像、图表;在广告中全部内容;千橡公司为用户提供的商业信息等,所有这些内容受版权、商标权、和其它知识产权及所有权法律的保护。所以,用户只能在千橡公司授权下才能使用这些内容,而不能擅自复制、修改、编撰这些内容、或创造与内容有关的衍生产品。

典型的强X广告吧……

 

六、用户隐私制度
尊重用户个人隐私是千橡公司的一项基本政策。所以,作为对以上第二点个人注册资料分析的补充,千橡公司一定不会公开、编辑或透露用户的注册资料及保存在千橡公司各项服务中的非公开内容,除非千橡公司在诚信的基础上认为透露这些信息在以下几种情况是必要的:
(1)遵守有关法律规定,包括在国家有关机关查询时,提供用户在校内网的网页上发布的信息内容及其发布时间、互联网地址或者域名以及其他用户上传至校内网的信息。
(2)遵从校内网产品服务程序。
(3)保持维护千橡公司的商标所有权。
(4)在紧急情况下维护用户个人和社会大众的隐私安全。
(5)千橡公司认为必要的其他情况下。
用户在此授权千橡公司可以向其电子邮箱发送商业信息。

看完隐私制度,你有什么感觉?我觉得“千橡公司认为必要的其他情况下”这句太XX了……

 

十七、知识产权
用户保证和声明对其所提供的作品拥有完整的合法的著作权或完整的合法的授权可以用于其在校内网上从事的活动,保证千橡公司使用该作品不违反国家的法律法规,也不侵犯第三方的合法权益或承担任何义务。
用户应对其所提供作品因形式、内容及授权的不完善、不合法所造成的一切后果承担完全责任。
用户同意千橡公司对其创作并上传的作品在全世界范围内享有免费的、永久性的、不可撤消的、独家的和完全的许可和再许可权利,以使用、复制、出版、发行、以原有或其他形式进行改编、转载、翻译、传播、表演和展示此等内容(整体或部分)。此许可和再许可权利包括但不限于此作品的著作权、邻接权及获得利益等权利。
用户同时承诺,不就上述作品以及上述作品的改编作品对任何第三方进行任何形式的许可使用。
对于经用户本人创作并上传到校内网的文本、图片、图形、音频和/或视频等资料的商标和/或其它财产权利归属于千橡公司,未经千橡公司同意,用户保证不以任何形式直接或间接发布、播放、出于播放或发布目的而改编或再发行,或者用于其他任何商业目的。同时保证不许可任何第三方从事上述行为。
千橡校内网公司保留对其网站所有内容进行实时监控的权利,并有权依其独立判断对任何违反本协议约定的作品实施删除。千橡公司对于删除用户作品引起的任何后果或导致用户的任何损失不负任何责任。
因用户作品的违法或侵害第三人的合法权益而导致千橡公司或其关联公司对第三方承担任何性质的赔偿、补偿或罚款而遭受损失(直接的、间接的、偶然的、惩罚性的和继发的损失),用户对于千橡公司或其关联公司蒙受的上述损失承担全面的赔偿责任。

如果由于用户的帖子,校内网被GFW了,那么用户将承担所有赔偿责任……

 

用户在校内网上发表的一切东西都失去了版权……并且后面还有这个:

十九、内容的所有权
内容的定义包括:文字、软件、声音、相片、录象、图表;在广告中的全部内容;电子邮件的全部内容;校内网虚拟社区服务为用户提供的商业信息。所有这些内容均受版权、商标、标签和其它财产所有权法律的保护。所以,用户只能在千橡公司和广告商授权下才能使用这些内容,而不能擅自复制、再造这些内容、或创造与内容有关的派生产品

“与内容有关的派生产品”,很强大……

 

二十一、法律
用户和千橡公司一致同意有关本协议以及使用千橡公司的服务产生的争议交由仲裁解决,但是千橡公司有权选择采取诉讼方式,并有权选择受理该诉讼的有管辖权的法院。若有任何服务条款与法律相抵触,那这些条款将按尽可能接近的方法重新解析,而其它条款则保持对用户产生法律效力和影响。

囧,估计南山法院给了千橡很大提示……

 

最后当然没有忘了这条:

以上条款的解释权归千橡公司最终所有。

 

不过还有这么一句,很和谐……

本服务条款执行过程中所产生的任何问题本网站和用户都将友好协商解决。

PS: 在校内网的隐私声明中还有这个:

隐私政策

校内网非常重视对用户隐私权的保护,承诺不会在未获得用户许可的情况下擅自将用户的个人资料信息出租或出售给任何第三方,但以下情况除外:

  • 您同意让第三方共享资料;
  • 您同意公开你的个人资料,享受为您提供的产品和服务;
  • 本站需要听从法庭传票、法律命令或遵循法律程序;
  • 本站发现您违反了本站服务条款或本站其它使用规定。

根据这个声明,只要发现用户“违反了服务条款或其他使用规定”(其他使用规定,这个也很XX啊),就可以把用户的个人资料信息出租或出售给任何第三方。

IELTS口语考官常见170问

1. What’s your name?

Xiaoyu Guo

2. Does your name have any special meaning?

3. Where were you come from?

4. What kind of landscape surrounds your hometown?

5. What is the main crop in your hometown?

6. What is the difference between Beijing and your hometown?

7. What are the main places of interest in your hometown?

8. What is the climate like in your hometown?

9. What is the character of the people like in the region where you live?

10. What are the differences in accent between the people of your hometown and Beijing?

11. What is people’s favorite food in your region?

12. How do you make dumplings?

13. What do you do during the Spring Festival?

14. Why is the Spring Festival so important to Chinese people?

15. Can you describe one of the main festivals celebrated in your country?

16. Tell me something about the Lantern Festival.

17. Tell me something about the Qing Ming Festival.

18. Tell me something about the customs of your country.

19. How long have you lived in Beijing?

20. What is the weather like in Beijing?

21. How do you compare the climate in Beijing with that in your hometown?

22. What place in Beijing do you like best? Why ?

23. Which is the worst place you"ve been to China?

24. Which is the best place you"ve been to China?

25. What places in Beijing should a foreigner visit? Why?

26. What are the major social problems in Beijing? How can they be solved?

27. What is the biggest problem China faces?

28. What places in Beijing should a foreigner visit? Why?

29. Could you tell me something about your family?

30. Have you any children?

31. What is your child’s name? Does his name have a meaning?

32. What does your wife/husband do?

33. When did you get married?

34. Describe your wedding.

35. How have weddings changed in recent years?

36. Are there any special customs about wedding in your region?

37. Describe a traditional wedding ceremony.

38. Where did you go for your honeymoon?

39. Did you have to ask for permission from your parents before you got married?

40. Is it acceptable for couples to live together without marrying?

41. Where do you think a newly couple should live? Living with their parents or on their own?

42. What responsibilities should a couple take?

43. How do Chinese usually celebrate birthdays?

44. Are there any traditions concerning the birth of a baby?

45. What kind of parent do you intend to be?

46. What do you think of One-Child Policy in China?

47. Why do people in China traditionally want to have a son?

48. What difficulties do Chinese farmers have concerning their old age?

49. What do you think needs to be done in order to relieve the farmer"s worries?

50. What hope or fears do you have for your children?

51. What sort of culture do you hope your child will grow up in?

52. Are you going to bring up your child differently from the way you were brought up? How?

53. Do you enjoy shopping?

54. Who does most of the shopping in your family?

55. What are you good at cooking? What is your favorite dish?

56. Who does most of cooking in your family?

57. Is there *** discrimination in China?

58. How do you sum up women"s conditions in China?

59. What are the causes of *** discrimination?

60. Should government pay certain salaries to those housewives? Why or why not?

61. Would you want your wife to continue with her career or to stay at home taking care of the household after you get married?

62. Have you ever wished to be one of the opposite ***? Why (why not)?

63. What would you do if your next-door neighbour were noisy nearly all the time?

64. Do you have a lot of friend?

65. What does friendship mean to you? What kind of people do you make friend with?

66. What is your major?

67. How do you like your major?

68. When and where did you graduate? What qualifications have you obtained?

69. Do you still remember your school days?

70. What impressed you most when you were at university?

71. Which is the best university in your country?

72. Could you sum up your own study habits in a few points?

73. What do you think of the practice of setting up key schools in primary and secondary school education in China?

74. Do you think the subjects you are studying today are relevant to present-day society? Why ?

75. What do you think education should be? Should it be a process of learning what is useful for your future life or should it be simply learning for enjoyment? Why?

76. What do you do for a living?

77. What do you do in the office every day?

78. Since your job seems too professional to me, could you explain it in detail?

79. What are your job prospects?

80. If you had the opportunity to change your job, what would you do with it?

81. Do you have any ambitious?

82. Will any possible future changes affect your job in any way?

83. What are your spare time interests?

84. How do you spend your weekends?

85. What is your favorite sport? What are the rules?

86. What is the most popular sport in your country?

87. What are the sporting facilities like in your university/Beijing?

88. What do you know about Qigong? Do you believe in Qigong?

89. What do you do in your spare time?

90. Do you often read newspapers? If not, why ones do you read?

91. What do you think of computer?

92. Do you think computer has changed our life so much?

93. Do you often go to the cinema/theatre?

94. What kind of films do you like best?

95. Do you often watch TV? What is your favorite program?

96. Do you think watching TV too much is a waste of time?

97. What kind of music do you enjoy?

98. Who is your favorite film star? Will you describe him/her to me?

99. Do you enjoy travelling?

100. Where have you been travelling to? Which place interested you most?

101. Do you smoking?

102. Do you think smoking is a problem that needs special attention and has to be solved? If so, why?

103. What do you know about ABC?

104. What problem do you think you will have in ABC?

105. How will you overcome the difficulties?

106. Do you think you will be able to cope with English-demands of your intended study program in ABC?

107. What difficulties do you think you’ll encounter in your studies in ABC?

108. Can you imagine what life in Britain/Canada/Australia/London, etc. would be like?

109. How will you fare in Britain/Canada/Australia, etc. without your family?

110. What do you intend to study?

111. Which university are you going to study at?

112. Why did you choose this university?

113. Where are you going to study in ABC?

114. What are you plans in ABC?

115. What is your research proposal all about?

116. What do you hope for most from your study abroad?

117. Will your study abroad help your job prospects after come back to China?

118. Should you study more theory or do more practice? Give your reasons, please.

119. What kind of differences in the cultures are you expecting between China and the ABC?

120. How will your study in Britain benefit your work in China when you come back to China?

121. What do you intend to do after you finish studying?

122. What will be your main problem when you are study in a foreign country?

123. What problem can you foresee in the future when you come back to China?

124. Will there be any adjustment problems in your life when you come back to China? If so, what are they?

125. Will you have to make any changes in your work/life when you come back to China?

126. Do you think there will be a gap between your knowledge gained in China and the level of knowledge you are going to encounter on arrival? If so, what will it be?

127. What do you think of the future of China keeps an open policy?

128. What do you regard as the most significant events in your country’s recent history?

129. Are there any special places you want to see in Canada? What are they?

130. What do you especially want to do in Canada?

131. How do you like your life in ABC University?

132. What do you think of the training in the university?

133. In what way do you think university training is helpful or falls short?

134. What aspect of English do you find the most difficult?

135. Do you find American English easier to understand than Britain English?

136. What sports are played in your country?

137. Could you describe the traditional architecture of your country?

138. What role dose religion play in everyday life in your country?

139. What would you regard as the most significant events in your country"s recent history?

140. How aware do you think people are nowadays about environmental issues?

141. Could you tell me why you chose to study at the university of ABC?

142. What role dose tourism play in your country"s economy?

143. How serious is unemployment in your country?

144. In your opinion, what are the most serious problems associated with modern life?

145. What do you think have been the most important changes in your field over the past 5 years?

146. What are you going to major in ?

147. Are you going to do your own cooking when you are at university?

148. Some local students feel that overseas students get preferential treatment. What is your opinion?

149. Do you think you will be able to cope with the English-language demands of your intended program?

150. What do you think are the main causes of road accidents?

151. Do you think the government is doing enough to prevent road accidents?

152. As there are more and more private cars, what do you think the government should do in order to encourage citizens to use public transport?

153. How do you see yourself in ten years’ time?

154. Have you ever thought to have your own business?

155. What business do you hope to have?

156. Do you know about any policies about opening a business abroad?

157. What are your plans for your future?

158. Why do you think there are more and more people leaving to immigrate to other countries?

159. Is it good for China that so many people are going to other countries?

160. Will your life change a lot after you immigrate to ABC?

161. What will you do if you are ill abroad?

162. Do you know what to do in case of emergency?

163. What will do if you cannot find a job in ABC?

164. Why do you want to immigrate to ABC?

165. What will you do after the IELTS test?

166. What will do if you fail the IELTS test?

167. What’s your dream job?

168. How long have you been learning English?

169. What troubles you most at the moment?

170. Does your family support your decision on going ABC? What help do they offer?