New Gallery

Started by Toruk Makto, October 06, 2015, 03:55:06 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Tìtstewan

Ma 'Eylan Ayfalulukanä,

Irayo! I'll try to get all the work finished as fast as possble. And yes, that is a rather painful work. O_o




Ma Vawmataw,

One need admin power to be able to help. I think, /I/ should complete the manual import. My first priority is to not cause any chaotic mess there.




FIY,
I found out that the importer got trouble with albums that have an apostrophe in their name. It hasn't imported stuff into those albums. And the weird thing is, after I noticed it, I tested wherter the importer works after I have removed the apostrophes, but unfortunately the result was exactly the same.

Interestingly, the importer just imported all comments and ratings, but 2500 are "invisible" just because those comments belong to the missing items. The only way to make those comments and ratings visible is to correct the ID in the database. I still debating with me if it is worth the effort...

-| Na'vi Vocab + Audio | Na'viteri as one HTML file | FAQ | Useful Links for Beginners |-
-| Kem si fu kem rä'ä si, ke lu tìfmi. |-

Tìtstewan

#21
Btw, this is the home page of the new gallery:

-| Na'vi Vocab + Audio | Na'viteri as one HTML file | FAQ | Useful Links for Beginners |-
-| Kem si fu kem rä'ä si, ke lu tìfmi. |-

Vawmataw

Fmawn Ta 'Rrta - News IN NA'VI ONLY (Discord)
Traducteur francophone de Kelutral.org, dict-navi et Reykunyu

Toliman


Hahaw[hhvhhvcz]

Txantsan nìtxan nang! :D :D
My Steam Profile (from SteamDB)
  • Worth: $1551 ($396 with sales) (updated 17.3.16)
  • Games owned: 97
  • Games not played: 34 (35%)
  • Hours on record: 1,825.3h

Eana Unil

Very nice, can't wait :) Thanks for the hard work already :D

Tìtstewan

The new gallery is open now. Just check the menu bar "Gallery". :D

Some notes:
There is missing a few audio/video files. I can upload them, but can't correct the owner, only by some SQL tricks, same also for the ~2500 missing comments that actually have been imported in the database. I'll fix these fails tomorrow when my head is clean, lol.

-| Na'vi Vocab + Audio | Na'viteri as one HTML file | FAQ | Useful Links for Beginners |-
-| Kem si fu kem rä'ä si, ke lu tìfmi. |-

Toliman

Txantsan nìtxan  :D

New Gallery looks very good  :)

QuoteThere is missing a few audio/video files. I can upload them, but can't correct the owner, only by some SQL tricks, same also for the ~2500 missing comments that actually have been imported in the database. I'll fix these fails tomorrow when my head is clean, lol.
Good luck with this  :)

Toruk Makto

Well done, ma Tìtstewan.  Huge thanks!

*applause!*

Lì'fyari leNa'vi 'Rrtamì, vay set 'almong a fra'u zera'u ta ngrrpongu
Na'vi Dictionary: http://files.learnnavi.org/dicts/NaviDictionary.pdf

Vawmataw

Fmawn Ta 'Rrta - News IN NA'VI ONLY (Discord)
Traducteur francophone de Kelutral.org, dict-navi et Reykunyu

Tìtstewan

Something about the image ratings...

I was just checking what one have to do to correct the ratings for the new one. I literally fell off my chair when I saw that the importer totally failed to import the correct member who rated an item. So, I have truncated the complete smf_gallery_rating table and used the avea rating table to rebuild the completely wrong table.
Now, the ratings are now correct also the stats make now more sense:


archaic       317
HiyikTompa       129
Kifkeyä Nari       77
Ertew       70
Tsanten Eywa 'eveng       38
na'rìngä hawnuyu       38
'Itan Atxur       36
Hufwe ta'em       35
oe munge hrrap       33
Kamean       32



And after further thinking about the ratings, I am not going to correct ratings of the re-imported items, because it would be a huge effort to do so. For the ratings, it is also required to edit the rating counter that is stored in the item table...

-| Na'vi Vocab + Audio | Na'viteri as one HTML file | FAQ | Useful Links for Beginners |-
-| Kem si fu kem rä'ä si, ke lu tìfmi. |-

archaic

I've rated more pic's than anyone else?  :D  8)
Pasha, an Avatar story, my most recent fanfic, Avatar related, now complete.

The Dragon Affair my last fanfic, non Avatar related.

Vawmataw

#32
Do the ratings matter? :)

Also, is it possible to bring back the [1] icon?
Fmawn Ta 'Rrta - News IN NA'VI ONLY (Discord)
Traducteur francophone de Kelutral.org, dict-navi et Reykunyu

Tìtstewan

Quote from: Vawmataw on November 10, 2015, 04:02:06 PM
Also, is it possible to bring back the [1] icon?
Activated.

-| Na'vi Vocab + Audio | Na'viteri as one HTML file | FAQ | Useful Links for Beginners |-
-| Kem si fu kem rä'ä si, ke lu tìfmi. |-

Vawmataw

Fmawn Ta 'Rrta - News IN NA'VI ONLY (Discord)
Traducteur francophone de Kelutral.org, dict-navi et Reykunyu

Tìtstewan

Ain't my fault :P ;D Still lolin' about it. ;D

-| Na'vi Vocab + Audio | Na'viteri as one HTML file | FAQ | Useful Links for Beginners |-
-| Kem si fu kem rä'ä si, ke lu tìfmi. |-

Vawmataw

Fmawn Ta 'Rrta - News IN NA'VI ONLY (Discord)
Traducteur francophone de Kelutral.org, dict-navi et Reykunyu

Tìtstewan

Well, there is no way to "remove" that 0 without banging to much in the code...disabled.

-| Na'vi Vocab + Audio | Na'viteri as one HTML file | FAQ | Useful Links for Beginners |-
-| Kem si fu kem rä'ä si, ke lu tìfmi. |-

Tìtstewan

#38
Missing audio and video files added and owner fixed. :)

Now, the comments...

EDIT:
Damn, there is the same issue like the ratings... Comments are shown, but the total comment value is not. Meh...

-| Na'vi Vocab + Audio | Na'viteri as one HTML file | FAQ | Useful Links for Beginners |-
-| Kem si fu kem rä'ä si, ke lu tìfmi. |-

archaic

Stick at it, you are making great things happen there. Cookies waiting 4 U!  :D 8)
Pasha, an Avatar story, my most recent fanfic, Avatar related, now complete.

The Dragon Affair my last fanfic, non Avatar related.