妖城在线论坛 - Powered by Discuz! Board

标题: [提问] 给大家做个数据库添加任何物品的C程序，少句INSERT [打印本页]

作者: chenlin 时间: 2010-3-28 07:08 标题: 给大家做个数据库添加任何物品的C程序，少句INSERT

给大家做个数据库添加任何物品的C程序，少句INSERT，由于是超级菜鸟，不熟悉数据库的插入，请大家帮助，完善后连代码详细注释发给大家一起共同学习，老鸟可以跳过，我们新手上！
我的插入语句不正确，请那个前辈帮助修改下，语句发这里请高手前辈帮下修改：妖城在线论坛: z. {* w2 C7 S9 ]! V: T

bbs.mocwww.com# V& e( a+ W+ s7 Y' ]+ g; Q
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート+ e' z8 b' f* f- F" Z; L2 X( e6 t

INSERT INTO tbl_item (Index,BASEIMAGENUMBER,Gold,4,5,6,7,8,9,Count,11,Rank,13,Dur,15,16,17,18,ATK,DEF,AGL,MND,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,Durable,67,sequence,69,70,71,72,73,74,75,Type,Name,78,79,80,81,82,ussage,84,85,86,87,88,Bank,CdKey,RegistNumber,ItemSpace,93) VALUES(9000770,27491,0,26,0,0,0,0,0,10,999,10,0,0,0,0,0,0,0,0,0,0,0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,100,0,0,0,1,0,0,0,时间序列,-1,0,0,0,0,0,0,"卡片","代金卡1元",0,"",0,0,"ITEM_DeleteTimeWatched","",0,0,0,0,0,0,"帐户",RegistNumber,ItemSpace,"-1");

图片附件: 未命名.JPG (2010-3-28 07:08, 145.2 KB) / 该附件被下载次数 163
http://bbs.mocwww.com/attachment.php?aid=12743

图片附件: 2.jpg (2010-3-28 07:08, 26.63 KB) / 该附件被下载次数 109
http://bbs.mocwww.com/attachment.php?aid=12744

图片附件: 3.jpg (2010-3-28 07:08, 14.61 KB) / 该附件被下载次数 112
http://bbs.mocwww.com/attachment.php?aid=12745

作者: sin 时间: 2010-3-28 09:58

很好,支持下~

作者: ★ヽ若惜莫离 时间: 2010-3-28 12:54

我在精神上支持你一下。

作者: chenlin 时间: 2010-3-28 22:56

那个大哥SOS下啊！！给个能用的插入语句就OK ！！卡在这里了。。。谢谢啊

作者: 叶子 时间: 2010-3-29 00:28

INSERT INTO `tbl_item` VALUES ('道具编号','样式编号','0','物品类别','0','0','1','0','0','堆叠数','堆叠上限','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','100','0','0','0','1','0','0','0','生成时间','-1','0','0','0','0','0','0','未坚定名','道具名称','','对应TXT文件名','0','0','ITEM_DeleteTimeWatched','道具调用函数','0','0','0','0','0','是否银行','账号','角色registnumber','道具位置','-1');
例:妖城在线论坛6 k6 P8 `) Q% X( O: E( q) x
INSERT INTO `tbl_item` VALUES ('12345','26534','0','26','0','0','1','0','0','1','999','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','100','0','0','0','1','0','0','0','1241161840','-1','0','0','0','0','0','0','卡片？','技能栏增加卡','','ITEM_技能栏.txt','0','0','ITEM_DeleteTimeWatched','ITEM_useMystery','0','0','0','0','0','0','admin','1','8','-1');
暂时这样吧,其他的我忘记了- -

作者: chenlin 时间: 2010-3-29 10:31

谢谢叶子前辈！！！！

作者: 全熟牛排溅血 时间: 2010-3-29 10:37

虽然不在偶滴技术领域范围内无法证实其正确性支持热心答覆

欢迎光临妖城在线论坛 (http://bbs.mocwww.com/)