[Release] Bapes Portal Generator || V2

[Power of Illuminati]

I entered the sql query with no problem, and set up the lua script. it loads with no prob in the debug window. I logged back in after restarting the server, since teh new files were added, and the portal wasn't there. OK, I spawned it. How can I make it save it's location, or spawn on reboot by itself?


** sorry, forgot to say thanks as well
this would be perfect if I could get them to automatically spawn after a reboot.

When you spawn the object, add a 1 after the id, for example like this if the object ID is 1337

.go spawn 1337 1

[fatalmind]

thanks hehe I found it in a random help file the other night XD

(found a ton of usefull scripts from the past that I'm trying to update for 462



Oh and I forgot, I found this .sql last night. I did NOT write this. (I didn't see an author so I don't know who to give credit to)

MAJOR CITY PORTALS
///////////////////////////

make a new query for the world server and enter the following

insert into `gameobject_spawns` (`id`, `Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`, `stateNpcLink`) values(Null,'183319','530','9406.15','-7264.7','14.1507','4.1956','0','0','0.864319','-0.502945','1','0','0','1','0'),
(Null,'183327','530','9406.15','-7264.7','14.1507','4.1956','0','0','0.864319','-0.502945','1','0','0','1','0'),
(Null,'183319','530','9401.66','-7261.49','14.197','4.54117','0','0','0.764978','-0.644057','1','0','0','1','0'),
(Null,'183326','530','9401.66','-7261.49','14.197','4.54117','0','0','0.764978','-0.644057','1','0','0','1','0'),
(Null,'183319','530','9406.04','-7289.38','14.2697','2.26744','0','0','0.905994','0.423291','1','0','0','1','0'),
(Null,'183323','530','9406.04','-7289.38','14.2697','2.26744','0','0','0.905994','0.423291','1','0','0','1','0'),
(Null,'184594','530','9402.23','-7292.79','14.2585','1.8127','0','0','0.787258','0.616624','1','0','0','1','0'),
(Null,'183319','530','9402.23','-7292.79','14.2585','1.8127','0','0','0.787258','0.616624','1','0','0','1','0'),
(Null,'183319','1','-1308.03','141.562','131.437','0.00549689','0','0','0.00274844','0.999996','1','0','0','1','0'),
(Null,'183327','1','-1308.03','141.562','131.437','0.00549689','0','0','0.00274844','0.999996','1','0','0','1','0'),
(Null,'183319','1','-1305.08','135.588','131.387','0.547422','0','0','0.270306','0.962774','1','0','0','1','0'),
(Null,'183323','1','-1305.08','135.588','131.387','0.547422','0','0','0.270306','0.962774','1','0','0','1','0'),
(Null,'184594','1','-1263.81','163.78','132.866','3.65917','0','0','0.966701','-0.255909','1','0','0','1','0'),
(Null,'183319','1','-1263.81','163.78','132.866','3.65917','0','0','0.966701','-0.255909','1','0','0','1','0'),
(Null,'183319','1','-1269.17','168.604','132.108','3.97961','0','0','0.913492','-0.406856','1','0','0','1','0'),
(Null,'183324','1','-1269.17','168.604','132.108','3.97961','0','0','0.913492','-0.406856','1','0','0','1','0'),
(Null,'184594','0','1739.56','217.542','61.6565','2.0923','0','0','0.865501','0.500908','1','0','0','1','0'),
(Null,'183319','0','1739.56','217.542','61.6565','2.0923','0','0','0.865501','0.500908','1','0','0','1','0'),
(Null,'183319','0','1745.45','220.997','61.9125','2.21403','0','0','0.894368','0.447331','1','0','0','1','0'),
(Null,'183326','0','1745.45','220.997','61.9125','2.21403','0','0','0.894368','0.447331','1','0','0','1','0'),
(Null,'183319','0','1745.63','256.641','61.9396','3.97725','0','0','0.913971','-0.405779','1','0','0','1','0'),
(Null,'183323','0','1745.63','256.641','61.9396','3.97725','0','0','0.913971','-0.405779','1','0','0','1','0'),
(Null,'183319','0','1740.57','261.204','61.6394','3.97725','0','0','0.913971','-0.405779','1','0','0','1','0'),
(Null,'183324','0','1740.57','261.204','61.6394','3.97725','0','0','0.913971','-0.405779','1','0','0','1','0'),
(Null,'183319','1','1435.4','-4432.59','25.2355','1.65797','0','0','0.737246','0.675624','1','0','0','1','0'),
(Null,'183326','1','1435.4','-4432.59','25.2355','1.65797','0','0','0.737246','0.675624','1','0','0','1','0'),
(Null,'184594','1','1427.04','-4419.83','25.2355','0.144508','0','0','0.0721913','0.997391','1','0','0','1','0'),
(Null,'183319','1','1427.04','-4419.83','25.2355','0.144508','0','0','0.0721913','0.997391','1','0','0','1','0'),
(Null,'183319','1','1428.11','-4427.22','25.2355','0.124873','0','0','0.0623961','0.998051','1','0','0','1','0'),
(Null,'183324','1','1428.11','-4427.22','25.2355','0.124873','0','0','0.0623961','0.998051','1','0','0','1','0'),
(Null,'183319','1','1442.76','-4432.84','25.2355','1.65326','0','0','0.735652','0.677359','1','0','0','1','0'),
(Null,'183327','1','1442.76','-4432.84','25.2355','1.65326','0','0','0.735652','0.677359','1','0','0','1','0'),
(Null,'184594','530','-4028.36','-11941.6','1.69758','2.34206','0','0','0.921151','0.389204','1','0','0','1','0'),
(Null,'183319','530','-4028.36','-11941.6','1.69758','2.34206','0','0','0.921151','0.389204','1','0','0','1','0'),
(Null,'183319','530','-4033.11','-11946.2','2.46388','2.34206','0','0','0.921151','0.389204','1','0','0','1','0'),
(Null,'183317','530','-4033.11','-11946.2','2.46388','2.34206','0','0','0.921151','0.389204','1','0','0','1','0'),
(Null,'183319','530','-4051.42','-11927','0.57013','5.4703','0','0','0.395346','-0.918532','1','0','0','1','0'),
(Null,'183322','530','-4051.42','-11927','0.57013','5.4703','0','0','0.395346','-0.918532','1','0','0','1','0'),
(Null,'183319','530','-4046.54','-11923','-0.332532','5.4703','0','0','0.395346','-0.918532','1','0','0','1','0'),
(Null,'183325','530','-4046.54','-11923','-0.332532','5.4703','0','0','0.395346','-0.918532','1','0','0','1','0'),
(Null,'184594','1','9936.28','2599.2','1316.44','0.0175862','0','0','0.008793','0.999961','1','0','0','1','0'),
(Null,'183319','1','9936.28','2599.2','1316.44','0.0175862','0','0','0.008793','0.999961','1','0','0','1','0'),
(Null,'183319','1','9936.17','2605.26','1316.76','0.0175862','0','0','0.008793','0.999961','1','0','0','1','0'),
(Null,'183321','1','9936.17','2605.26','1316.76','0.0175862','0','0','0.008793','0.999961','1','0','0','1','0'),
(Null,'183319','1','9959.18','2611.23','1315.85','3.16389','0','0','0.999938','-0.0111496','1','0','0','1','0'),
(Null,'183322','1','9959.18','2611.23','1315.85','3.16389','0','0','0.999938','-0.0111496','1','0','0','1','0'),
(Null,'183319','1','9959.31','2605.29','1316.27','3.16782','0','0','0.999914','-0.0131129','1','0','0','1','0'),
(Null,'183325','1','9959.31','2605.29','1316.27','3.16782','0','0','0.999914','-0.0131129','1','0','0','1','0'),
(Null,'184594','0','-4955.15','-879.439','501.661','2.28022','0','0','0.908678','0.417497','1','0','0','1','0'),
(Null,'183319','0','-4955.15','-879.439','501.661','2.28022','0','0','0.908678','0.417497','1','0','0','1','0'),
(Null,'183319','0','-4960.15','-883.73','501.661','2.3077','0','0','0.914331','0.404968','1','0','0','1','0'),
(Null,'183321','0','-4960.15','-883.73','501.661','2.3077','0','0','0.914331','0.404968','1','0','0','1','0'),
(Null,'183319','0','-4988.56','-907.492','501.66','2.26351','0','0','0.90516','0.425071','1','0','0','1','0'),
(Null,'183317','0','-4988.56','-907.492','501.66','2.26351','0','0','0.90516','0.425071','1','0','0','1','0'),
(Null,'183319','0','-4983.36','-903.173','501.645','2.26351','0','0','0.90516','0.425071','1','0','0','1','0'),
(Null,'183325','0','-4983.36','-903.173','501.645','2.26351','0','0','0.90516','0.425071','1','0','0','1','0'),
(Null,'184594','0','-8976.87','562.706','93.8583','5.4381','0','0','0.410081','-0.912049','1','0','0','1','0'),
(Null,'183319','0','-8976.87','562.706','93.8583','5.4381','0','0','0.410081','-0.912049','1','0','0','1','0'),
(Null,'183319','0','-8973.58','565.616','93.86','5.4381','0','0','0.410081','-0.912049','1','0','0','1','0'),
(Null,'183321','0','-8973.58','565.616','93.86','5.4381','0','0','0.410081','-0.912049','1','0','0','1','0'),
(Null,'183319','0','-8965.64','572.664','93.8453','5.4381','0','0','0.410081','-0.912049','1','0','0','1','0'),
(Null,'183322','0','-8965.64','572.664','93.8453','5.4381','0','0','0.410081','-0.912049','1','0','0','1','0'),
(Null,'183319','0','-8961.97','575.918','93.8371','5.42239','0','0','0.417232','-0.9088','1','0','0','1','0');

Reboot your world server, and log in to find all the major city portals spawned and working. I installed it into my server last night. I'm running ascent 4268

[Power of Illuminati]

If you are using Ascent 4268 and a self "compled" DB, you should have all major city portals Go to shattrath and look as example.

[Syrup]

Thank you, very handy.

[wefwef123]

I really dont got this, I make it and click on it it does nothing just looks pretty

[dotoriton]

TY this is soo sweet :-D

[Yamajee]

I only get a .lua file... anyone can help me?

[Saint-Pasdoy]

very nice man, good work