[Guide]Change Character Starting Items -
06-23-2008
Hello mmowned this is my first guide. I would like to introduce myself, I am Darksid, i am a very good friend of volitle if anyone has heard of him, we have had a private server together for about 1 year now. I just want to share my knowledge on mmowned here which i use all the time. I hope i can help everyone out.
So to change a players starting items there is this simple website. It will produce the sql you need to use.
visit [Only registered and activated users can see links. ]
After you click Submit copy and paste that into a notepad saving it as (name).sql
If you have questions post here
Coolkid1, you take the code and copy it to a notepad document, then you generate the new code, and copy to that document. You will have a long code, but it will work.
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 2
Reputation: 1
Posts: 15
Join Date: Jan 2007
09-03-2008
Aw, I hope we can get a link that works!
I wanted to have every new character get [Only registered and activated users can see links. ], a 36 slot bag.
Starting out is always hard when all the quests say "hold this" and "deliver this" when you have no space!
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 1
Reputation: 3
Posts: 20
Join Date: Jul 2008
09-04-2008
Quote:
Originally Posted by Tambu
Aw, I hope we can get a link that works!
I wanted to have every new character get [Only registered and activated users can see links. ], a 36 slot bag.
Starting out is always hard when all the quests say "hold this" and "deliver this" when you have no space!
Code:
INSERT INTO playercreateinfo_items VALUES ('1', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('44', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('56', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('44', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('56', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('44', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('56', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('1', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('2', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('3', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('4', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('5', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('6', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('7', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('8', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('44', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('56', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('9', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('10', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('45', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('50', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('9', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('10', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('45', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('50', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('9', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('10', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('45', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('50', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('9', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('10', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('45', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('50', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('11', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('12', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('15', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('16', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('17', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('46', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('51', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('11', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('12', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('15', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('16', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('17', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('46', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('51', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('11', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('12', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('15', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('16', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('17', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('46', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('51', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('11', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('12', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('15', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('16', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('17', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('46', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('51', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('18', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('19', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('20', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('21', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('22', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('23', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('24', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('52', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('18', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('19', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('20', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('21', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('22', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('23', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('24', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('52', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('18', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('19', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('20', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('21', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('22', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('23', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('24', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('52', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('18', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('19', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('20', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('21', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('22', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('23', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('24', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('52', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('25', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('26', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('27', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('28', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('29', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('47', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('53', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('25', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('26', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('27', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('28', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('29', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('47', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('53', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('25', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('26', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('27', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('28', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('29', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('47', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('53', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('25', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('26', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('27', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('28', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('29', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('47', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('53', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('30', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('31', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('32', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('48', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('30', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('31', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('32', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('48', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('30', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('31', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('32', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('48', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('30', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('31', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('32', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('48', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('34', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('35', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('36', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('37', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('49', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('54', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('34', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('35', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('36', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('37', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('49', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('54', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('34', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('35', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('36', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('37', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('49', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('54', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('34', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('35', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('36', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('37', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('49', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('54', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('38', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('39', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('40', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('41', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('55', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('38', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('39', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('40', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('41', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('55', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('38', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('39', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('40', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('41', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('55', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('38', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('39', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('40', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('41', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('55', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('42', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('43', '23162', '19', '1');
INSERT INTO playercreateinfo_items VALUES ('42', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('43', '23162', '20', '1');
INSERT INTO playercreateinfo_items VALUES ('42', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('43', '23162', '21', '1');
INSERT INTO playercreateinfo_items VALUES ('42', '23162', '22', '1');
INSERT INTO playercreateinfo_items VALUES ('43', '23162', '22', '1');
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 2
Reputation: 1
Posts: 15
Join Date: Jan 2007
09-05-2008
Thanks!
When I had entered them all by hand, some spawned with 2, one in their chest slot 1 in their bags, and they had multiple shirts and such. It was messy.