sql it makes easier

someone can make a sql for me that autopmatical add some items to a char
so i only have to edit wich cid and item id

someone can make that for me
it should be very fine


already thanks
jur13n

Replace the text thats between the <> including <> to the value it needs

Inserting item by using cid

Code:

---

INSERT INTO CharacterItem (CID,ItemID) VALUES ('<cid>','<itemid>')

---

Inserting by using character name

Code:

---

INSERT INTO CharacterItem (CID,ItemID) SELECT CID,'<itemid>' FROM Characters WHERE Name='<character name>'

---

Note : Not tested but it should be something like this..

ty i really wanted it

INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<8714>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1914>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<8713>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<8712>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<8715>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<4234>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<4235>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<4236>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<4237>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<4238>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1340>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1337>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1338>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1359>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1339>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1348>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1335>')
INSERT INTO CharacterItem (CID,ItemID) VALUES ('<24>','<1335>')


i did this _^_
II
II
but it says characteritem is not right what i have to do?
its my set for gm's

They should be separated with a semicolon..
and also.. the < and > should be removed..


Like this..

Code:

---

INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','8714');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1914');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','8713');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','8712');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','8715');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','4234');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','4235');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','4236');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','4237');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','4238');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1340');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1337');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1338');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1359');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1339');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1348');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1335');
INSERT INTO CharacterItem (CID,ItemID) VALUES ('24','1335')

---

it says same:
Msg 208, Level 16, State 1, Line 1
Item Name Item Character is invalid

They work fine i just tested them

Some Help..
- The CID needs to be an existing CID or else i will give errors.
- Be sure to execute it under the "GunZ Database" and not "master" use the drop down menu to select it
- Each separate query needs to be ended with a semicolon when using a next query
- U need to have the right permissions under the account ur connected with to the database

ok ty
didnt know i had to drop down the db

Use Admin Panel :O >.<

and if the admin panel gives errors?

then either fix them or add them manually. If you dont know how to do that then your screwed (this is the point where you stop trying to do anything with a server)