打印

[提问] 给大家做个数据库添加任何物品的C程序，少句INSERT

chenlin

小妖

Rank: 1

UID: 24438
精华: 0
积分: 5
威望: 0 度

阁楼大中小发表于 2010-3-28 07:08 只看该作者

给大家做个数据库添加任何物品的C程序，少句INSERT

给大家做个数据库添加任何物品的C程序，少句INSERT，由于是超级菜鸟，不熟悉数据库的插入，请大家帮助，完善后连代码详细注释发给大家一起共同学习，老鸟可以跳过，我们新手上！& S) q+ R& J Y3 n' Q
我的插入语句不正确，请那个前辈帮助修改下，语句发这里请高手前辈帮下修改：/ L4 b! x* z9 Y/ @- J4 ~# e4 o

魔力私服,最新魔力宝贝私服技术交流3 B, y7 d$ O2 Y. V2 J3 y% M7 Y

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 (145.2 KB)

2010-3-28 07:08

未命名.JPG

2.jpg (26.63 KB)

2010-3-28 07:08

3.jpg (14.61 KB)

2010-3-28 07:08

TOP

sin

妖将

Rank: 5 Rank: 5

UID: 3281
精华: 1
积分: 2002
威望: 0 度
性别: 男

妖城妖使勋章灌水天才勋章小财主专用勋章笑脸人勋章

沙发大中小发表于 2010-3-28 09:58 只看该作者

很好,支持下~

你在我身边时，你是一切；你不在我身边时，一切是你。

TOP

★ヽ若惜莫离

承接：任务脚本制作。

妖精

Rank: 2 Rank: 2

UID: 24978
精华: 1
积分: 307
威望: 0 度
性别: 女

妖城妖精勋章

板凳大中小发表于 2010-3-28 12:54 只看该作者

我在精神上支持你一下。

?
?
?
?
***　　“ 那一寂落花、退却青春的浮华。”
?
?
?
?

TOP

chenlin

小妖

Rank: 1

UID: 24438
精华: 0
积分: 5
威望: 0 度

地板大中小发表于 2010-3-28 22:56 只看该作者

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

TOP

叶子

妖使

Rank: 3 Rank: 3 Rank: 3

UID: 3172
精华: 8
积分: 731
威望: 0 度

地下室 大中小发表于 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');魔力私服,最新魔力宝贝私服技术交流; u. }" h) D3 m
例:
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');妖城在线论坛; r6 }* p8 I0 B
暂时这样吧,其他的我忘记了- -

本帖最近评分记录