[REQUEST] playercreateinfo (template)

[kimmern]

Hi and welcome to this thread.
i was wondering if anyone could edit a playercreateinfo template to make all classes start at GM island?
(For a Trinity DB)

Thanks

~Frankie~

[stoneharry]

Errr, no. You haven't even stated for which emulator.

However, you can change it all yourself by going to GM Island, do .gps, and then update the database using these types of queries:

UPDATE `playercreateinfo` SET `mapID` = '1';
UPDATE `playercreateinfo` SET `zoneID` = '0';
UPDATE `playercreateinfo` SET `positionX` = '0';
UPDATE `playercreateinfo` SET `positionY` = '0';
UPDATE `playercreateinfo` SET `positionZ` = '0';

[kimmern]

Errr, no. You haven't even stated for which emulator.

However, you can change it all yourself by going to GM Island, do .gps, and then update the database using these types of queries:

UPDATE `playercreateinfo` SET `mapID` = '1';
UPDATE `playercreateinfo` SET `zoneID` = '0';
UPDATE `playercreateinfo` SET `positionX` = '0';
UPDATE `playercreateinfo` SET `positionY` = '0';
UPDATE `playercreateinfo` SET `positionZ` = '0';

will that update for ALL the classes?

[stoneharry]

Yes .

[kimmern]

Yes .

Save as a SQL n just execute?

Thanks.

[Facerolling]

You need to fill in these yourself:

UPDATE `playercreateinfo` SET `mapID` = '1';
UPDATE `playercreateinfo` SET `zoneID` = '0';
UPDATE `playercreateinfo` SET `positionX` = '0';
UPDATE `playercreateinfo` SET `positionY` = '0';
UPDATE `playercreateinfo` SET `positionZ` = '0';

Go to GM Island and type ".gps", then match up the map, zone, and x,y,z coordinates into the queries and save and execute.

[stoneharry]

Yes. Or use the query editor/box to execute it through a MySQL GUI such as SQLyog.

You just need to change the values to the GM Island coordinates and values.

edit: What facerolling said, which is basically what I said in my first post.

[kimmern]

uh yeah, lol thanks guys

edit: ok so i made the sql and all.. tried executing... i got this

[Err] 1054 - Unknown column 'mapID' in 'field list'
[Err] UPDATE `playercreateinfo` SET `mapID` = '1';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

EDIT: ok i got it to work, had to change it a little bit

SQL For making all classes start on GM island.
playercreateinfo update template (TRINITY ONLY)

UPDATE `playercreateinfo` SET `map` = '1';
UPDATE `playercreateinfo` SET `zone` = '876';
UPDATE `playercreateinfo` SET `position_X` = '16225.725586';
UPDATE `playercreateinfo` SET `position_Y` = '16255.918945';
UPDATE `playercreateinfo` SET `position_Z` = '13.094419';