[DiscordArchive] I've got most of the basics down and got keira working to let a buddy who doesn't know sql help, any
[DiscordArchive] I've got most of the basics down and got keira working to let a buddy who doesn't know sql help, any
Original source
I've got most of the basics down and got keira working to let a buddy who doesn't know sql help, any good way to place the creatures in the game world accurately/lined up properly? What would be the proper way here?
rektbyfaith
06-11-2022, 08:54 AM #1Archived author: WaDaFruCK • Posted: 2022-06-11T08:54:19.670000+00:00
Original source
I've got most of the basics down and got keira working to let a buddy who doesn't know sql help, any good way to place the creatures in the game world accurately/lined up properly? What would be the proper way here?
Original source
You can do .npc add temp [ID] and do .npc info or whatever it is to get the coordinates/orientation when you get it how you want it to put it in the DB, or you can stand in that position and do .gps (Not sure if that'll get you orientation value though)
rektbyfaith
06-11-2022, 08:56 AM #2Archived author: Bench • Posted: 2022-06-11T08:56:59.636000+00:00
Original source
You can do .npc add temp [ID] and do .npc info or whatever it is to get the coordinates/orientation when you get it how you want it to put it in the DB, or you can stand in that position and do .gps (Not sure if that'll get you orientation value though)
Original source
ya, problem is that everything here is crooked basically, both x and y values change when I move linearly
rektbyfaith
06-11-2022, 09:03 AM #3Archived author: WaDaFruCK • Posted: 2022-06-11T09:03:20.987000+00:00
Original source
ya, problem is that everything here is crooked basically, both x and y values change when I move linearly
Original source
wasn't sure if there was a cleaner way to do it by reference or something
rektbyfaith
06-11-2022, 09:05 AM #4Archived author: WaDaFruCK • Posted: 2022-06-11T09:05:15.881000+00:00
Original source
wasn't sure if there was a cleaner way to do it by reference or something
Original source
my OCD will murder me if they are even a tiny bit uneven
rektbyfaith
06-11-2022, 09:05 AM #5Archived author: WaDaFruCK • Posted: 2022-06-11T09:05:32.263000+00:00
Original source
my OCD will murder me if they are even a tiny bit uneven
Original source
I can recommend a tiny script which updates the DB via query. With Eluna these scripts can be changed and reloaded while the server is running. Ofc you'll only see the changes after a restart.
rektbyfaith
06-11-2022, 09:05 AM #6Archived author: Honey • Posted: 2022-06-11T09:05:58.929000+00:00
Original source
I can recommend a tiny script which updates the DB via query. With Eluna these scripts can be changed and reloaded while the server is running. Ofc you'll only see the changes after a restart.
Original source
Let me find an example
rektbyfaith
06-11-2022, 09:06 AM #7Archived author: Honey • Posted: 2022-06-11T09:06:05.064000+00:00
Original source
Let me find an example
Original source
that might help. As of right now, we have a lootlist site that categorizes every single drop by boss and location, so I'm using that database to generate the SQL for creating 100's of vendors for basically every tag we had in our site to springboard an item mall.
rektbyfaith
06-11-2022, 09:07 AM #8Archived author: WaDaFruCK • Posted: 2022-06-11T09:07:03.242000+00:00
Original source
that might help. As of right now, we have a lootlist site that categorizes every single drop by boss and location, so I'm using that database to generate the SQL for creating 100's of vendors for basically every tag we had in our site to springboard an item mall.
Original source
planning on building it out in tyr's hand; simply because we had a TBC test server that the item mall module we found was there, so many of our guildies will be used to it etc, but the chapel of tyr's hand isn't squared up with the map ><
rektbyfaith
06-11-2022, 09:08 AM #9Archived author: WaDaFruCK • Posted: 2022-06-11T09:08:18.367000+00:00
Original source
planning on building it out in tyr's hand; simply because we had a TBC test server that the item mall module we found was there, so many of our guildies will be used to it etc, but the chapel of tyr's hand isn't squared up with the map ><
Original source
Let's take custom stuff to <#353919176714354698>
rektbyfaith
06-11-2022, 09:08 AM #10Archived author: Honey • Posted: 2022-06-11T09:08:42.046000+00:00
Original source
Let's take custom stuff to <#353919176714354698>