[For Newbies]Most Requested Queries

11/08/2012 04:02 pretzel666#1
Ok So I See A Couple Posts On Here About Queries On Adding These Items So Here You Go
Casuals:
Quote:
Insert into `cq_itemtype` VALUES (CasualID, 'CasualName', 0, 0, Level, SEX, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9900, 9900, 0, 0, 0, 0, 0, 0, 0, 0, 00, 800, 84, 0000, 0000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Weapons ( Remember To Add This 5 Times , XXXXX0,1,2,3,4,)
Quote:
Insert into `cq_itemtype` VALUES (WEPID, 'WeaponName', Class, 0, Level, 0, 0, 0, 0, 0, 12, 0, 0, 0, ATKMAX, ATKMIN, 0, 0, 0, 0, 0, 9900, 9900, 0, 0, 0, 0, 0, 0, 0, 0, 00, 800, 84, 0000, 0000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Just Fill In The Spots That Say Which Is Which , No Need To Change Anything Else
11/08/2012 07:18 georgeion92#2
That is only when you have client side added already but if you want to take it from other client is something more to add!
11/08/2012 13:51 pretzel666#3
Most Requested Queries <- , Says nothing about client side , theres guides for them , this is just to help newbies out adding these to DB
11/09/2012 17:10 ~Sword~Stalker~.#4
INSERT ? not REPLACE if ur inserting new stuff ..
11/10/2012 01:10 pretzel666#5
Didnt realize that , thx sword ^_^