[For Newbies]Most Requested Queries

11/08/2012 05: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 08: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 14: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 18:10 ~Sword~Stalker~.#4
INSERT ? not REPLACE if ur inserting new stuff ..
11/10/2012 02:10 pretzel666#5
Didnt realize that , thx sword ^_^