[DiscordArchive] is this for 243 or 335?
[DiscordArchive] is this for 243 or 335?
Original source
Yes, looks correct
rektbyfaith
08-12-2023, 10:36 AM #11Archived author: robinsch • Posted: 2023-08-12T10:36:36.972000+00:00
Original source
Yes, looks correct
Original source
I think if you wanted to get fancy though and have region based knowledge article things, You could add a "lang" column in your db and then filter the first 2 chars the game sends with `locale=enGB` so enUS and enGB would both be en English. zhCN and zhTW would both be zh simplified Chinese.
But I think you said wow 2 doesn't sent this `locale=` search term? Only uses the `languageId=`? sorry wasn't paying that much attention, going to bed soon.
Think just ignoring it and only return English should work for most people.
for the most part though, it seems like you can ignore most of the query tags and just use a few of them, mostly the `articleId=` to get a specific article, that does most of the heavy lifting.
Then you can use sql for the get 20 articles ordered by hot and new, and then new when you run out of hot for the `getKBSetup.xml` script, that being said, haven't worked out how to do more then one page.. well like more then one real page. got page numbers working but I only have one page worth of data if that makes sense.
rektbyfaith
08-12-2023, 10:48 AM #12Archived author: MobCat • Posted: 2023-08-12T10:48:41.567000+00:00
Original source
I think if you wanted to get fancy though and have region based knowledge article things, You could add a "lang" column in your db and then filter the first 2 chars the game sends with `locale=enGB` so enUS and enGB would both be en English. zhCN and zhTW would both be zh simplified Chinese.
But I think you said wow 2 doesn't sent this `locale=` search term? Only uses the `languageId=`? sorry wasn't paying that much attention, going to bed soon.
Think just ignoring it and only return English should work for most people.
for the most part though, it seems like you can ignore most of the query tags and just use a few of them, mostly the `articleId=` to get a specific article, that does most of the heavy lifting.
Then you can use sql for the get 20 articles ordered by hot and new, and then new when you run out of hot for the `getKBSetup.xml` script, that being said, haven't worked out how to do more then one page.. well like more then one real page. got page numbers working but I only have one page worth of data if that makes sense.
Original source
well unicode arsrey not withstanding that is..
![[Image: image.png?ex=690c7e74&is=690b2cf4&hm=088...f0659d663&]](https://cdn.discordapp.com/attachments/1086807686571642900/1139874610502975568/image.png?ex=690c7e74&is=690b2cf4&hm=0886a37da7200dd2cb2ba892e90afb93d6fdf22332ba4c3fbeceafcf0659d663&)
rektbyfaith
08-12-2023, 10:54 AM #13Archived author: MobCat • Posted: 2023-08-12T10:54:44.981000+00:00
Original source
well unicode arsrey not withstanding that is..
Original source
but yeah
![[Image: image.png?ex=690c7e8c&is=690b2d0c&hm=52f...763c4a5c6&]](https://cdn.discordapp.com/attachments/1086807686571642900/1139874708830036048/image.png?ex=690c7e8c&is=690b2d0c&hm=52fc8f9373ae48bb40cfe9251d4c6b0b64923f0f7050d08e9883b15763c4a5c6&)
rektbyfaith
08-12-2023, 10:55 AM #14Archived author: MobCat • Posted: 2023-08-12T10:55:08.484000+00:00
Original source
but yeah
Original source
3.3.5 queries like this: `/kb/getKBSetup.xml?languageId=X&numArticles=Y&pageNumber=Z&locale=U`. So both, languageId and locale are send. And yes, you may not need them, I didn't either, but I wanted to mention them for completeness sake. Somebody else may have a use for them
rektbyfaith
08-12-2023, 10:55 AM #15Archived author: Ike • Posted: 2023-08-12T10:55:32.654000+00:00
Original source
3.3.5 queries like this: `/kb/getKBSetup.xml?languageId=X&numArticles=Y&pageNumber=Z&locale=U`. So both, languageId and locale are send. And yes, you may not need them, I didn't either, but I wanted to mention them for completeness sake. Somebody else may have a use for them
Original source
Yee I might add them for completeness sake too, but will probs have some sort of way for it to just pull English as a default if it can't find anything else.
It might also be fun but also OP AF to do a check for if the sent locale != the one listed in the db. try and translate it on the fly with a google api or deepL.
rektbyfaith
08-12-2023, 10:58 AM #16Archived author: MobCat • Posted: 2023-08-12T10:58:32.147000+00:00
Original source
Yee I might add them for completeness sake too, but will probs have some sort of way for it to just pull English as a default if it can't find anything else.
It might also be fun but also OP AF to do a check for if the sent locale != the one listed in the db. try and translate it on the fly with a google api or deepL.
1 Guest(s)
1 Guest(s)