纯绿色■开心农场■Final 091216 09/12/16 19:42【数据库升级】

回复  iamxyh

Maybe This can Help:
793, 795, 799 & 802#


你可以把内容清空,message字段放这个 ...
hotllus 发表于 2009-11-21 15:18

您说的办法当然可以，但问题是用户的短信息里包含不少朋友送的礼物，这一清空就礼物就没了，必然会遭到用户投诉。
我觉得如果只是这种情况可以在读取message数据的时候对这个null，进行一下替换再显示出来。存回数据库的时候更不更改都问题不大。

新日志高亮盖过去会初始化失败的。。。怎么解决？

谢谢分享科技好的即可富华大厦开关机啊

回复 1# fbean 、、

没事来顶顶

回复 957# guizi6


    谢谢柜子哥，已修正。

回复 1# fbean


    952＃的UTF8补丁已修正兑换F币问题，现在比较完整了，请fbean更改一下首楼附件。

能否在商店的工具内增加狗粮的购买呢？

回复 977# iamxyh

1.用户message字段没有信息 OR null 放

1. 
   
2. {"a":[],"b":[],"c":[],"d":[],"e":[]}
   

复制代码

2.如用户message字段有信息
A.如信息是:

1. 
   
2. {"e":[{"id":1257997500,"formulaId":3,"friendId":"305","fName":"\u54aa\u96c5","charm":13,"validTime":0,"msg":"juz for u...hehe...","sendTime":1257997500,"status":2,"x":"39","y":"84","z":"3"},{"id":1258421335,"formulaId":1,"friendId":"361","fName":"\u963f\u5e0c","charm":13,"validTime":0,"msg":"","sendTime":1258421335,"status":2,"x":"-17","y":"114","z":"3"}]}
   

复制代码

改为这样就正确了:

1. 
   
2. {"a":[],"b":[],"c":[],"d":[],"e":[{"id":1257997500,"formulaId":3,"friendId":"305","fName":"\u54aa\u96c5","charm":13,"validTime":0,"msg":"juz for u...hehe...","sendTime":1257997500,"status":2,"x":"39","y":"84","z":"3"},{"id":1258421335,"formulaId":1,"friendId":"361","fName":"\u963f\u5e0c","charm":13,"validTime":0,"msg":"","sendTime":1258421335,"status":2,"x":"-17","y":"114","z":"3"}]}
   

复制代码

=

{"a":[],"b":[],"c":[],"d":[],"e":[{"id":1257997500,"formulaId":3,"friendId":"305","fName":"\u54aa\u96c5","charm":13,"validTime":0,"msg":"juz for u...hehe...","sendTime":1257997500,"status":2,"x":"39","y":"84","z":"3"},{"id":1258421335,"formulaId":1,"friendId":"361","fName":"\u963f\u5e0c","charm":13,"validTime":0,"msg":"","sendTime":1258421335,"status":2,"x":"-17","y":"114","z":"3"}]}

B.如信息是:

1. 
   
2. {"c":[{"fromId":"1","sendTime":1257563698,"eDesc":"\u6211\u68c0\u67e5\u8fc7\u60a8\u7684\u6570\u636e\u5e93\uff0c\u6ca1\u95ee\u9898\u554a\uff1f\u600e\u6837\u8bf4\u4e0d\u53ef\u4ee5\u52a0\u8349\uff1f\u8bf4\u8be6\u7ec6\u4e9b\uff0c\u6bd4\u5982\u600e\u6837\u4e0d\u53ef\u4ee5\u52a0\uff1f\u6709\u6ca1\u63d0\u793a\u4ec0\u4e48\u4e4b\u7c7b\u7684\uff1f","status":1,"id":1257563698,"name":"\u5e73\u51e1\u7684\u50bb\u4ed4"}]}
   

复制代码

改为这样就正确了:

1. 
   
2. {"a":[],"b":[],"c":[{"fromId":"1","sendTime":1257563698,"eDesc":"\u6211\u68c0\u67e5\u8fc7\u60a8\u7684\u6570\u636e\u5e93\uff0c\u6ca1\u95ee\u9898\u554a\uff1f\u600e\u6837\u8bf4\u4e0d\u53ef\u4ee5\u52a0\u8349\uff1f\u8bf4\u8be6\u7ec6\u4e9b\uff0c\u6bd4\u5982\u600e\u6837\u4e0d\u53ef\u4ee5\u52a0\uff1f\u6709\u6ca1\u63d0\u793a\u4ec0\u4e48\u4e4b\u7c7b\u7684\uff1f","status":1,"id":1257563698,"name":"\u5e73\u51e1\u7684\u50bb\u4ed4"}],"d":[],"e":[]}
   

复制代码

=

{"a":[],"b":[],"c":[{"fromId":"1","sendTime":1257563698,"eDesc":"\u6211\u68c0\u67e5\u8fc7\u60a8\u7684\u6570\u636e\u5e93\uff0c\u6ca1\u95ee\u9898\u554a\uff1f\u600e\u6837\u8bf4\u4e0d\u53ef\u4ee5\u52a0\u8349\uff1f\u8bf4\u8be6\u7ec6\u4e9b\uff0c\u6bd4\u5982\u600e\u6837\u4e0d\u53ef\u4ee5\u52a0\uff1f\u6709\u6ca1\u63d0\u793a\u4ec0\u4e48\u4e4b\u7c7b\u7684\uff1f","status":1,"id":1257563698,"name":"\u5e73\u51e1\u7684\u50bb\u4ed4"}],"d":[],"e":[]}

然后就不会出错了.

可在下一版本提速嗎?

关于强化兑换的。

1. 
   
2. MySQL Error
   
3. Message: MySQL Query Error
   
4. SQL: SELECT extcredits1 FROM cdb_members where uid=1
   
5. Error: Table 'elfbbs_home.cdb_members' doesn't exist
   
6. Errno.: 1146
   
7. Click here to seek help.
   

复制代码