[DiscordArchive] I have noticed interesting moment
[DiscordArchive] I have noticed interesting moment
Original source
I have noticed interesting moment
when ran this query
`SELECT ID,EndText,ObjectiveText1 FROM quest_template_locale WHERE EndText NOT LIKE ObjectiveText1 and locale LIKE '`<langLANG>`' AND ObjectiveText1 NOT LIKE '' AND EndText NOT LIKE '';`
We have a fully duplicated column. Is it really necessary?
rektbyfaith
01-21-2022, 06:05 AM #1Archived author: Bogir • Posted: 2022-01-21T06:05:39.082000+00:00
Original source
I have noticed interesting moment
when ran this query
`SELECT ID,EndText,ObjectiveText1 FROM quest_template_locale WHERE EndText NOT LIKE ObjectiveText1 and locale LIKE '`<langLANG>`' AND ObjectiveText1 NOT LIKE '' AND EndText NOT LIKE '';`
We have a fully duplicated column. Is it really necessary?
Original source
There are several unknown combinations in quest_template_locale
like `$Gmale:female:c;` - what is the last one `:c` for? For case if character is not male and not female?
and `|3-6 ($c)` , `|3-6 ($r)` or other numbers - what are these numbers for ?
In my native locale we replaced all |3-6 ($c) and similar to the `$c` and have not seen any difference
rektbyfaith
01-21-2022, 06:59 AM #2Archived author: Bogir • Posted: 2022-01-21T06:59:34.490000+00:00
Original source
There are several unknown combinations in quest_template_locale
like `$Gmale:female:c;` - what is the last one `:c` for? For case if character is not male and not female?
and `|3-6 ($c)` , `|3-6 ($r)` or other numbers - what are these numbers for ?
In my native locale we replaced all |3-6 ($c) and similar to the `$c` and have not seen any difference
1 Guest(s)
1 Guest(s)