[help]in make suit

05/04/2011 11:51 wolfvb#1
hi ineed a sql
for an male suit
i try that sql but not work
[Only registered and activated users can see links. Click Here To Register...]
Code:
delete from cq_itemtype where id >= 194600 and id <= 194600;

INSERT INTO `cq_itemtype` VALUES ('194600', 'Tigersuit', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
[Only registered and activated users can see links. Click Here To Register...]
so can any one help me
the client side
ani
ItemMinIcon
Code:
[Item194600]
FrameAmount=1
Frame0=data/ItemMinIcon/194600.dds
MapItemIcon
Code:
[194600]
FrameAmount=1
Frame0=data/ItemMinIcon/194600.dds
[Only registered and activated users can see links. Click Here To Register...]
ini
3dobj
Code:
001194600=c3/mesh/001194600.c3 (001)
3dtexture
Code:
001194600=c3/texture/001194600.dds
armor
Code:
[001194600]
Part=1
Mesh0=1194600
Texture0=1194600
MixTex0=0
MixOpt0=0
Asb0=5
Adb0=6
Material0=default
[Only registered and activated users can see links. Click Here To Register...]
05/04/2011 12:57 DuaSelipar#2
i think everthing in your post is fine...so what your prob? cant wear or what?
05/04/2011 13:22 ~*Kronic*~#3
Quote:
delete from cq_itemtype where id >= 194600 and id <= 194600;

DELETE from cq_itemtype WHERE id = 194600;

That is a much better formatted SQL, not that it matters much here but it might help in the future.
Quote:
3dobj

001194600=c3/mesh/001194600.c3 (001)
3dtexture
001194600=c3/texture/001194600.dds

armor
[001194600]
Part=1
Mesh0=1194600
Texture0=1194600
MixTex0=0
MixOpt0=0
Asb0=5
Adb0=6
Material0=default
I'm not sure if it makes a difference but you have 00 before the id some places and not others, make them all the same and see if it works. If not then make sure all the other files are in the correct spot (mesh and texture mainly). Also don't forget to add it to itemtype.dat
05/04/2011 13:36 wolfvb#4
i do all in this guide
see
the guide
form here
[Only registered and activated users can see links. Click Here To Register...]
maby for get some thing
and dds and .c3 file in there place so what the woring
the ploblem is i can get it
i use /awarditem 194600
ibout it in shop the same ploblem can't buy it i add ids in cq_goods
so what is the ploblem
05/04/2011 15:15 josh468#5
Did u edit itemtype.dat?

Without this u won't be ale to see the new current item ....

if u did then check if this id 194600 isn't already exist in ur .ini files, if so then your msg won't be able to read it correctly...


So if you want to check if this kind of problem casued your files then "cut" all code of item and "paste" it on the top...



But

if u edited itemtype.dat correctly then you should be able to see item in game....
05/05/2011 19:49 magewarior2#6
Code:
INSERT INTO `cq_itemtype` VALUES ('194600', 'Tigersuit', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
no price? no weight? no nothing? :bandit:


however i dunno it has something to do with not able to see :D


if your not able to see, check over your ini file`s and your ani file´s

and ofcourse also itemtype.dat

also be sure you don`t have the id`s twice into your file´s ... its useless junk than :D


and always be sure if you have an new added item you restart your server!

more basic tips i am not able to give i guess :rolleyes:
05/05/2011 21:01 josh468#7
Quote:
Originally Posted by magewarior2 View Post
Code:
INSERT INTO `cq_itemtype` VALUES ('194600', 'Tigersuit', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
no price? no weight? no nothing? :bandit:


however i dunno it has something to do with not able to see :D


if your not able to see, check over your ini file`s and your ani file´s

and ofcourse also itemtype.dat

also be sure you don`t have the id`s twice into your file´s ... its useless junk than :D


and always be sure if you have an new added item you restart your server!

more basic tips i am not able to give i guess :rolleyes:

i dont really know why wolf didnt answeer for this thread,

i used team viewer and i told him whhats the problem


He said he edited itemtype.dat but...

he opened it from folder where itemtype editor was instaled...


So in client/ini/itemtype.dat wasnt edited...

Thats main problem why he could get item...

but

he didnt tell me that it works... if not then change id of item, i have noticed some times when id of item was incorupted and didnt work...
05/05/2011 21:39 wolfvb#8
i do that its in client folder man u see that
and i can't get it not see it
05/06/2011 07:41 josh468#9
Quote:
Originally Posted by wolfvb View Post
i do that its in client folder man u see that
and i can't get it not see it
...


Read last part of my latest post....
05/07/2011 09:17 wolfvb#10
ok iwill try and reply but thanks for all for tray to help