以下两条SQL可以用于UCH2.0的程序中执行,执行前记得修改uchome_(表前缀)两条SQL按顺序执行
UPDATE uchome_space SET notenum=notenum+1
INSERT INTO uchome_notification (`uid`, `type`, `new`, `note`, `dateline`)
SELECT uid, '1066497', '1', '<div>
<div style=\"width: 75px; text-align: center; vertical-align: middle;float: left;\">
<a href=\"userapp.php?mod=app&id=1066497\"><img src=\"http://appicon.manyou.com/icons/1066497\"></a>
</div>
<div class=\"app_left_right\" style=\"width: 300px; float: left; padding-left: 3px;\">
<div class=\"app_name\"><a href=\"userapp.php?mod=app&id=1066497\"><strong>火影世界</strong></a></div>
<div style=\"clear: both;\"></div>
<div style=\"line-height:21px\">横版页游扛鼎之作 体验漫画中忍术打斗的空前刺激,七大活动带您畅游火影世界!<a href=\"userapp.php?mod=app&id=1066497\">【点击此加入游戏】</a></div>
</div>
</div>', '1294813998' FROM uchome_space
|