![aa2 character database search by traits aa2 character database search by traits](https://s.uvlist.net/l/y2020/04/201179.jpg)
Relying on only the base game maker, you are presented with a dismal amount of options.
AA2 CHARACTER DATABASE SEARCH BY TRAITS HOW TO
There is this wonderful guide being updated for AAU if you find yourself at a loss on how to use it to its full potential. I’m really excited to see where the program goes from here. Also anytime I want to do some subtle edits to a game file I can preserve the original copy and just make a set with my little change. When working on my clothing collection the Shadow Sets feature is invaluable by saving me so much time when checking my work. With the new styles and triggers I find myself swimming in new possibilities for girls to make and ways to give each of them their own unique characteristics. Without AAU I don’t know if I’d still be playing this game today. To use just run the exe after you start your Play/Make launcher on the startup window. While not a mod, this program is a must have and immensely enhances the game. The program is being regularly updated with new concepts and ways to push the game further and further. Body adjustment sliders, POV H-Scenes, H-Ai, card by card mesh editing, tans not restricted to finite slots with colorability, additional hair slots with advanced sizing and positioning, and an in-game poser to name only few features. This program unlocks the true potential of AA2. I’ve posted this list before in other places but I’d like to repost it with more of my opinions and less objectivity.
AA2 CHARACTER DATABASE SEARCH BY TRAITS MODS
And the second SUBSTRING I added +0 at the end because without plus 1 the result datatype is string so the ordering will mess up.This is merely a list I put together of good mods to use to get started with creating and playing ジンコウガクエン2 (Artificial Academy 2). *If you notice, in the first SUBSTRING I've added lv-1 because without minus 1, the SUBSTRING will return together with the first number occurrence. Of course, if you want to look at the value, you can simply add the statement in ORDER BY to SELECT like : SELECT val, SUBSTRING(val,1,lv-1), SUBSTRING(val,lv)+0 FROM *Will return the value on the first number onwards. (e.g ZZZ-AA1 to ZZZ-AA OR ZZZ-AAA1 to ZZZ-AAA). *Will return the value before the first number occurrence. as the centre of SUBSTRING in the ORDER BY: SUBSTRING(val,1,lv-1) Īfter that, I make the query as a sub-query then uses the result from LEAST(IF(LOCATE. I replace them because I'm using LEAST to return the smallest value which is the first number occurrence: LEAST(IF(LOCATE. Then, if LOCATE return 0 as result, replace it with 999. Since these are numbers we're looking for, it's much easier because I'll only need to locate 0 to 9 number values. *translate to "If you can't locate the number 1 in `val`, return 999 *translate to "Locate the number 1 in `val` column". The idea is to get the first number occurrence then use that to separate between the values before numbers and the numbers itself using LOCATE function: LOCATE(1, val) ORDER BY SUBSTRING(val,1,lv-1) ASC, SUBSTRING(val,lv)+0 ASC
![aa2 character database search by traits aa2 character database search by traits](https://aina18ie.files.wordpress.com/2015/03/2015_0310_2147_05466.png)
However, since you're using MysQL v5.7, this is what I come up with: SELECT val FROM In MySQL v8.0, one possible solution is using REGEXP_REPLACE like: SELECT * FROM testĪBS(REGEXP_REPLACE(val, "", "")) ASC On MySQL prior to 8.0, trying to achieve this is quite a long way.