diff --git "a/taehui-fe/src/app/\133language\135/want/\133wantVariety\135/\133\133...want\135\135/page.tsx" "b/taehui-fe/src/app/\133language\135/want/\133wantVariety\135/\133\133...want\135\135/page.tsx" index afd966c..fac28a7 100644 --- "a/taehui-fe/src/app/\133language\135/want/\133wantVariety\135/\133\133...want\135\135/page.tsx" +++ "b/taehui-fe/src/app/\133language\135/want/\133wantVariety\135/\133\133...want\135\135/page.tsx" @@ -38,10 +38,11 @@ <>
- {isWantLoaded && ( - - - {t("wantView")} + + + {t("wantView")} + + {isWantLoaded && ( - - - )} + )} + + ); } diff --git a/taehui-fe/src/app/www/system/DB.ts b/taehui-fe/src/app/www/system/DB.ts index ebb9311..a6cd2c8 100644 --- a/taehui-fe/src/app/www/system/DB.ts +++ b/taehui-fe/src/app/www/system/DB.ts @@ -754,7 +754,7 @@ >( `SELECT Forum_ID, Essay_ID, tn_essay.Avatar_ID, Avatar_Name, tn_essay.Date, Title FROM tn_essay, tn_avatar - WHERE tn_avatar.Avatar_ID = tn_essay.Avatar_ID AND MATCH(Text) AGAINST(? IN BOOLEAN MODE) + WHERE tn_avatar.Avatar_ID = tn_essay.Avatar_ID AND MATCH(Text) AGAINST(?) ORDER BY tn_essay.Date DESC LIMIT ?, ?`, [wantInput, (page - 1) * viewUnit, viewUnit], @@ -795,7 +795,7 @@ >( `SELECT Forum_ID, tn_comment.Essay_ID, tn_comment.Avatar_ID, Avatar_Name, tn_comment.Date, tn_comment.Text FROM tn_essay, tn_comment, tn_avatar - WHERE tn_essay.Essay_ID = tn_comment.Essay_ID AND tn_comment.Avatar_ID = tn_avatar.Avatar_ID AND MATCH(tn_comment.Text) AGAINST(? IN BOOLEAN MODE) + WHERE tn_essay.Essay_ID = tn_comment.Essay_ID AND tn_comment.Avatar_ID = tn_avatar.Avatar_ID AND MATCH(tn_comment.Text) AGAINST(?) ORDER BY tn_comment.Date DESC LIMIT ?, ?`, [wantInput, (page - 1) * viewUnit, viewUnit],