Author Topic: New Gallery  (Read 1972 times)

0 Members and 1 Guest are viewing this topic.

Offline Tìtstewan

  • LearnNavi Zeykoyu
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 9704
  • de Germany
  • Karma: 318
  • Ke lu oeru kea krr krrtalun!
    • My YouTube Channel
Re: New Gallery
« Reply #20 on: November 08, 2015, 08:38:24 am »
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...

-| Dict-Na'vi.com | Na'viteri Files | FAQ | LM | Puk Pxaw 'Rrta | Kem si fu kem rä'ä si, ke lu tìfmi. |-

Offline Tìtstewan

  • LearnNavi Zeykoyu
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 9704
  • de Germany
  • Karma: 318
  • Ke lu oeru kea krr krrtalun!
    • My YouTube Channel
Re: New Gallery
« Reply #21 on: November 08, 2015, 09:44:42 am »
Btw, this is the home page of the new gallery:
« Last Edit: January 12, 2017, 01:24:49 pm by Tìtstewan »

-| Dict-Na'vi.com | Na'viteri Files | FAQ | LM | Puk Pxaw 'Rrta | Kem si fu kem rä'ä si, ke lu tìfmi. |-

Offline Vawmataw

  • Palulukan Makto
  • *****
  • *
  • Posts: 5618
  • nv Eywa'eveng
  • Karma: 93
Re: New Gallery
« Reply #22 on: November 08, 2015, 09:47:39 am »
*___________*

:D
Fmawn Ta 'Rrta
Stop by the Omatikayan Memes Center for some good quality Na'vi memes.

Offline Toliman

  • Palulukan Makto
  • *****
  • Posts: 3488
  • nv Eywa'eveng
  • Karma: 16
  • Alpha Centauri, Toliman, HD12862, HIP71683
Re: New Gallery
« Reply #23 on: November 08, 2015, 09:48:12 am »
Very good  :D

Offline Hahaw[hhvhhvcz]

  • Taronyu
  • ****
  • Posts: 630
  • nv Eywa'eveng
  • Karma: 8
  • Hahaw te Sewìkxi Ma'rrtxì'itan
Re: New Gallery
« Reply #24 on: November 08, 2015, 09:49:59 am »
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

Offline Eana Unil

  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 1193
  • de Germany
  • Karma: 104
  • Kamäleon angul
    • Tskxekeng ne tìyo - pìlok Eana Unilä
Re: New Gallery
« Reply #25 on: November 08, 2015, 12:27:57 pm »
Very nice, can't wait :) Thanks for the hard work already :D

Kifkeyl oeti fneyku. | ART should comfort the disturbed, and disturb the comfortable.
LearnNavi Discord Server
Learn Na'vi Member Map

Offline Tìtstewan

  • LearnNavi Zeykoyu
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 9704
  • de Germany
  • Karma: 318
  • Ke lu oeru kea krr krrtalun!
    • My YouTube Channel
Re: New Gallery
« Reply #26 on: November 09, 2015, 04:14:56 am »
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.

-| Dict-Na'vi.com | Na'viteri Files | FAQ | LM | Puk Pxaw 'Rrta | Kem si fu kem rä'ä si, ke lu tìfmi. |-

Offline Toliman

  • Palulukan Makto
  • *****
  • Posts: 3488
  • nv Eywa'eveng
  • Karma: 16
  • Alpha Centauri, Toliman, HD12862, HIP71683
Re: New Gallery
« Reply #27 on: November 09, 2015, 07:42:01 am »
Txantsan nìtxan  :D

New Gallery looks very good  :)

Quote
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.
Good luck with this  :)

Offline Toruk Makto

  • LearnNavi Admin
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • Posts: 6031
  • us United States
  • Karma: 211
  • . Txepsiyu Markì .
    • Learn Na'vi
Re: New Gallery
« Reply #28 on: November 09, 2015, 11:16:55 am »
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://eanaeltu.learnnavi.org/dicts/NaviDictionary.pdf

Offline Vawmataw

  • Palulukan Makto
  • *****
  • *
  • Posts: 5618
  • nv Eywa'eveng
  • Karma: 93
Re: New Gallery
« Reply #29 on: November 09, 2015, 04:01:27 pm »


Good job :D
Fmawn Ta 'Rrta
Stop by the Omatikayan Memes Center for some good quality Na'vi memes.

Offline Tìtstewan

  • LearnNavi Zeykoyu
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 9704
  • de Germany
  • Karma: 318
  • Ke lu oeru kea krr krrtalun!
    • My YouTube Channel
Re: New Gallery
« Reply #30 on: November 10, 2015, 06:41:01 am »
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...

-| Dict-Na'vi.com | Na'viteri Files | FAQ | LM | Puk Pxaw 'Rrta | Kem si fu kem rä'ä si, ke lu tìfmi. |-

Offline archaic

  • Palulukan Makto
  • *****
  • Posts: 2960
  • Karma: 73
  • Trying again with the language.
Re: New Gallery
« Reply #31 on: November 10, 2015, 03:31:47 pm »
I've rated more pic's than anyone else?  :D  8)
The Dragon Affair my current fanfic - now complete.

The Dragons Clutch, my last fanfic, non Avatar related.

Machine, my last Avatar related fanfic.

Offline Vawmataw

  • Palulukan Makto
  • *****
  • *
  • Posts: 5618
  • nv Eywa'eveng
  • Karma: 93
Re: New Gallery
« Reply #32 on: November 10, 2015, 04:02:06 pm »
Do the ratings matter? :)

Also, is it possible to bring back the [1] icon?
« Last Edit: November 10, 2015, 04:13:35 pm by Vawmataw »
Fmawn Ta 'Rrta
Stop by the Omatikayan Memes Center for some good quality Na'vi memes.

Offline Tìtstewan

  • LearnNavi Zeykoyu
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 9704
  • de Germany
  • Karma: 318
  • Ke lu oeru kea krr krrtalun!
    • My YouTube Channel
Re: New Gallery
« Reply #33 on: November 10, 2015, 08:21:44 pm »
Also, is it possible to bring back the [1] icon?
Activated.

-| Dict-Na'vi.com | Na'viteri Files | FAQ | LM | Puk Pxaw 'Rrta | Kem si fu kem rä'ä si, ke lu tìfmi. |-

Offline Vawmataw

  • Palulukan Makto
  • *****
  • *
  • Posts: 5618
  • nv Eywa'eveng
  • Karma: 93
Re: New Gallery
« Reply #34 on: November 10, 2015, 08:30:31 pm »
Also, is it possible to bring back the [1] icon?
Activated.
Gallery0?
Well, thanks. :D
Fmawn Ta 'Rrta
Stop by the Omatikayan Memes Center for some good quality Na'vi memes.

Offline Tìtstewan

  • LearnNavi Zeykoyu
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 9704
  • de Germany
  • Karma: 318
  • Ke lu oeru kea krr krrtalun!
    • My YouTube Channel
Re: New Gallery
« Reply #35 on: November 10, 2015, 08:31:50 pm »
Ain't my fault :P ;D Still lolin' about it. ;D

-| Dict-Na'vi.com | Na'viteri Files | FAQ | LM | Puk Pxaw 'Rrta | Kem si fu kem rä'ä si, ke lu tìfmi. |-

Offline Vawmataw

  • Palulukan Makto
  • *****
  • *
  • Posts: 5618
  • nv Eywa'eveng
  • Karma: 93
Re: New Gallery
« Reply #36 on: November 10, 2015, 08:32:23 pm »
Ain't my fault :P ;D Still lolin' about it. ;D
ok LOL
Fmawn Ta 'Rrta
Stop by the Omatikayan Memes Center for some good quality Na'vi memes.

Offline Tìtstewan

  • LearnNavi Zeykoyu
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 9704
  • de Germany
  • Karma: 318
  • Ke lu oeru kea krr krrtalun!
    • My YouTube Channel
Re: New Gallery
« Reply #37 on: November 10, 2015, 09:04:25 pm »
Well, there is no way to "remove" that 0 without banging to much in the code...disabled.

-| Dict-Na'vi.com | Na'viteri Files | FAQ | LM | Puk Pxaw 'Rrta | Kem si fu kem rä'ä si, ke lu tìfmi. |-

Offline Tìtstewan

  • LearnNavi Zeykoyu
  • Toruk Makto
  • Palulukan Makto
  • *****
  • *
  • *
  • Posts: 9704
  • de Germany
  • Karma: 318
  • Ke lu oeru kea krr krrtalun!
    • My YouTube Channel
Re: New Gallery
« Reply #38 on: November 11, 2015, 12:35:11 am »
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...
« Last Edit: November 11, 2015, 12:50:15 am by Tìtstewan »

-| Dict-Na'vi.com | Na'viteri Files | FAQ | LM | Puk Pxaw 'Rrta | Kem si fu kem rä'ä si, ke lu tìfmi. |-

Offline archaic

  • Palulukan Makto
  • *****
  • Posts: 2960
  • Karma: 73
  • Trying again with the language.
Re: New Gallery
« Reply #39 on: November 11, 2015, 04:00:56 pm »
Stick at it, you are making great things happen there. Cookies waiting 4 U!  :D 8)
The Dragon Affair my current fanfic - now complete.

The Dragons Clutch, my last fanfic, non Avatar related.

Machine, my last Avatar related fanfic.

 

Become LearnNavi's friend on Facebook Follow LearnNavi on Twitter! Watch LearnNavi's videos on YouTube

SMF 2.0.15 | SMF © 2017, Simple Machines | XHTML | RSS | WAP2 | Site Rules

LearnNavi is not affiliated with the official Avatar website,
James Cameron, or the Twentieth Century-Fox Film Corporation.
All trademarks and servicemarks are the properties of their respective owners.
Images in the LearnNavi.org Forums and Gallery may not be used without permission.

LearnNavi Affiliates:
ToS

LearnNavi is the community to learn Na'vi, the Avatar Language
"A place where real friendships are made." -Paul Frommer

AvatarMeet | Learn Na'vi Forum | Learn Na'vi Wiki | Na'viteri

LearnNavi