[DiscordArchive] <@203326888888893440> sorry once again for the ping. If i was to change an existing tele location. I
[DiscordArchive] <@203326888888893440> sorry once again for the ping. If i was to change an existing tele location. I
Original source
<@203326888888893440> sorry once again for the ping. If i was to change an existing tele location. I'm to delete the old entry and make a new one or update the old entry?
rektbyfaith
10-22-2024, 08:24 PM #1Archived author: Ryan Turner • Posted: 2024-10-22T20:24:54.852000+00:00
Original source
<@203326888888893440> sorry once again for the ping. If i was to change an existing tele location. I'm to delete the old entry and make a new one or update the old entry?
Original source
I would say update
rektbyfaith
10-22-2024, 08:25 PM #2Archived author: Bench • Posted: 2024-10-22T20:25:39.261000+00:00
Original source
I would say update
Original source
Is there any proper way to update query it? or if i add the new information into the existing query and remove and add the same ID (as its) with the updated value is considered an update?
rektbyfaith
10-22-2024, 08:26 PM #3Archived author: Ryan Turner • Posted: 2024-10-22T20:26:57.420000+00:00
Original source
Is there any proper way to update query it? or if i add the new information into the existing query and remove and add the same ID (as its) with the updated value is considered an update?
Original source
I would probably do
```sql
UPDATE `game_tele` SET `position_x` = 15, `position_y` = 72, `position_z` = 2, `orientation` = 0, `map` = 2 WHERE `id` = 4002 AND `name` = 'TheTeleportSpot';
```
rektbyfaith
10-22-2024, 08:28 PM #4Archived author: Bench • Posted: 2024-10-22T20:28:51.823000+00:00
Original source
I would probably do
```sql
UPDATE `game_tele` SET `position_x` = 15, `position_y` = 72, `position_z` = 2, `orientation` = 0, `map` = 2 WHERE `id` = 4002 AND `name` = 'TheTeleportSpot';
```
Original source
Thanks it works
rektbyfaith
10-22-2024, 08:37 PM #5Archived author: Ryan Turner • Posted: 2024-10-22T20:37:47.621000+00:00
Original source
Thanks it works
Original source
<@203326888888893440> Once again i shall ping you.
While creating these teleports I've encounter many times where i seacrh for example `.tele garm` and it takes to something that has partially that word like `Zangarmarsh` or `.tele Thunderfall` take would take me to `Thunder Falls`.
The problem is that if i try to create a "garm" teleport will not be able to. I will have to find what teleport (Zangarmarsh) is giving the partial value and change it temporaly like to ZangTADarmarsh than i can create the teleport this case garm.
It's this intended or it's something that can be adjusted in the core code of the searching?
Edit: Always .reload all after the changes
rektbyfaith
10-22-2024, 10:34 PM #6Archived author: Ryan Turner • Posted: 2024-10-22T22:34:47.999000+00:00
Original source
<@203326888888893440> Once again i shall ping you.
While creating these teleports I've encounter many times where i seacrh for example `.tele garm` and it takes to something that has partially that word like `Zangarmarsh` or `.tele Thunderfall` take would take me to `Thunder Falls`.
The problem is that if i try to create a "garm" teleport will not be able to. I will have to find what teleport (Zangarmarsh) is giving the partial value and change it temporaly like to ZangTADarmarsh than i can create the teleport this case garm.
It's this intended or it's something that can be adjusted in the core code of the searching?
Edit: Always .reload all after the changes