Who vandalized the wiki?

[starkind]

https://i.imgur.com/bKJWo2k.jpg

You don't deserve this community.

[loramin]

It probably wasn't vandalism :) Those "dynamic zone tables" use custom PHP code (written by Ravhin, our wiki master extraordinaire) to collect data from pages in the related wiki category (https://wiki.project1999.com/Category:Permafrost). Thus, if they break, it's because of a code problem.

If I had to guess, I imagine someone made a change to one of the 84 pages in that category, and for some reason it broke the dynamic table code. But unless someone wants to try rolling back the most recent hundreds of changes in that category, all we can do is ask for the original code creator to take a look.

Paging Ravhin!

[starkind]

The wiki is sacred and should include more stuff like this:


My research has yielded Bertoxxulous’ greatest gift, eternal life. With my human heart safe in Najena’s hands I shall be able to wreak The Plaguebringer’s revenge upon Jahnda and her temple soon. The ancient power of the Ruins of Geupal is almost mine. I only need another’s rage to complete my journey to immortality. Mayong’s minions still seek my demise but their efforts shall be in vain. That vampire shall never possess my hearts. — From the Journal of Varsoon the Undying

Ruins of Geupal almost certainly refers to the skeleton ruins in qeynos hills and his tomb... R.I.P. the classic Everquest that was and could have been.

And fuck you to all who would abuse and vandalize and exploit such a beautiful thing over mob stat data in a hotzone. For whatever pixosexual DKP dragonragey reasons, allegedly.

I just couldn't sit back silently without bringing this to the attention of the community.

[onlyrockerfan]

probably joey's fault

[Bhairava]

The wiki is sacred and should include more stuff like this:


Ruins of Geupal almost certainly refers to the skeleton ruins in qeynos hills and his tomb... R.I.P. the classic Everquest that was and could have been.

And fuck you to all who would abuse and vandalize and exploit such a beautiful thing over mob stat data in a hotzone. For whatever pixosexual DKP dragonragey reasons, allegedly.

I just couldn't sit back silently without bringing this to the attention of the community.

intensely cool lore

that one paragraph is cooler than every raid in the game simutaneously, way more immersive

[Maliant]

Wiki needs to have to be approved by an elder council (I nominate Loramin as council president).

I literally edited the angry goblin roll rules to add that premature rolls would negate your roll just so I could sleep during roll and my GINA trigger wouldn’t wake me up until angry spawned. I then deleted it after I got angry. This is my confession and apology but seriously when I actively played I noticed so many people intentionally edit certain details selfishly, just to fuck with people.

[RevSaber]

I have enough krono to pay you poorbies some subs on TLP...

[Swish]

I have enough krono to pay you poorbies some subs on TLP...

Eww.

[HalflingSpergand]

Shitted in ya lawn

[BlackBellamy]

Hmm the edit for the zone tables on the perma page happened last year

https://wiki.project1999.com/index.php?title=Permafrost&diff=289638&oldid=279541

also it looks like someone was trying to fix the tables by adding [[Category:Loc Mapped]] so not sure how long these tables have been broken

don't see any other relevant edits

[starkind]

it mahy not have been that edit, it's probably a table tag in one of the billion mob descriptions listed for the permafrost category, or a broken </

[starkind]

it was definatley working quite awhile ago

[loramin]

Hmm the edit for the zone tables on the perma page happened last year

https://wiki.project1999.com/index.php?title=Permafrost&diff=289638&oldid=279541

also it looks like someone was trying to fix the tables by adding [[Category:Loc Mapped]] so not sure how long these tables have been broken

don't see any other relevant edits

Yeah, it couldn't have been that; it's probably something in one of the related pages ... ie. a page with a Category:Permafrost.

[starkind]

i have a sub to allakahzam which is mostly good so it's not hurting me but i do care about the community and hope ya'll can get it worked out so newbies here don't suffer uneccissarily

I wish i had the technical expertise to look at the individual edit's on each page and do a ctrl F for whatever code that is possibly screwin it

[starkind]

i have a sub to allakahzam which is mostly good so it's not hurting me but i do care about the community and hope ya'll can get it worked out so newbies here don't suffer uneccissarily

I wish i had the technical expertise to look at the individual edit's on each page and do a ctrl F for whatever code that is possibly screwin it

i used2 but the meds reaslly fucked tht up (

[BlackBellamy]

If the issue was caused by a mob, I suspect that the other entries would display until they got to that mob then they would be blank or malformed. Unless the first mob pulled in was the problem...

[BlackBellamy]

January 27th last archived version was working ok

https://web.archive.org/web/20210127004156/http://wiki.project1999.com/Permafrost

[loramin]

January 27th last archived version was working ok

https://web.archive.org/web/20210127004156/http://wiki.project1999.com/Permafrost

You've reduced a needle in several haystacks down to a needle in one (large) haystack :)

But still, the core problem is that all we know is sometime between January 27th and now, someone changed one of the 84 pages in https://wiki.project1999.com/Category:Permafrost, in a way that cheesed off the wiki's custom PHP code.

Without Ravhin's assistance (as he can presumably check the error logs to find the offending page) this will be difficult to track down: essentially someone would have to click through the history of all 84 pages, checking every entry for anything "funny-looking".

If that didn't work, they'd have to try reverting every change (up to Jan 27) on like half the pages, then wait a day or two (the wiki code doesn't update things instantly, but like every night or something). if that fixes things, you could restore half of the changed pages, wait, see if things break, etc.

Not a fun process.

[Pulgasari]

Revision history of "Runed Circlet"

(cur | prev) 17:59, 23 April 2021‎ Garthin (Talk | contribs)‎ . . (1,103 bytes) (+18)

get him!

[loramin]

Revision history of "Runed Circlet"

(cur | prev) 17:59, 23 April 2021‎ Garthin (Talk | contribs)‎ . . (1,103 bytes) (+18)

get him!

LOL that commit was unnecessary (Runed Circlet is already in the "Fashion: Chain" category) ... but I don't think it's to blame :)

[Baler]

Without me being an old man and yelling at people on the wiki.

People do mess up the wiki from time to time. Whether that is removing information they disagree with or don't know. Sometimes people accidentally breaking sections.

These kind of issues don't pop up regularly which is good but it does happen. So it's important to check the History tab if a page looks funny. This will tell you who has been doing what. You can check their edit to see if they were genuine.

Wiki trolls are seldom, They don't get attention messing up the wiki so it takes someone who is unusually angry at the world to purposely damage it.

[RecondoJoe]

Permafrost loot is so bad

I used to try to give random low level barbs the mace and hat that dropped there on my way out and they refused to take it

[starkind]

for me it was about just chillin and getting a few yelows with my friend and getting 807 copper per 1 weight of ore, 5p / 7 weight, which is a pretty solid deal pretty just randomly low effort

[starkind]

for me it was about just chillin and getting a few yelows with my friend and getting 807 copper per 1 weight of ore, 5p / 7 weight, which is a pretty solid deal pretty just randomly low effort

almost as good as looting raw platinum

[RecondoJoe]

for me it was about just chillin and getting a few yelows with my friend and getting 807 copper per 1 weight of ore, 5p / 7 weight, which is a pretty solid deal pretty just randomly low effort

For me it was about PLing my friends because of the crazy ZEM

[RecondoJoe]

For me it was about PLing my friends because of the crazy ZEM

And the fact that zone is empty so you don’t have to worry about pissing off other players

[starkind]

ya 99% of the time it is its a great place to pl

[BlackBellamy]

I went through the history of all 84 pages here https://wiki.project1999.com/Category:Permafrost and rolled back any change made in Jan 2021 and later. I refreshed the Perma zone page after every change. Nothing I did made a difference, I undid all my changes and are at a loss...

[BlackBellamy]

@loramin did you or anyone edit the Loc Map or the scripts that pull them in recently? Grasping at straws here

[OuterChimp]

Learn to code.

[loramin]

I went through the history of all 84 pages here https://wiki.project1999.com/Category:Permafrost and rolled back any change made in Jan 2021 and later. I refreshed the Perma zone page after every change. Nothing I did made a difference, I undid all my changes and are at a loss...

I don't know exactly how it works, but the wiki scripts that control the dynamic zone stuff don't update immediately. Instead, they update daily? nightly? weekly?

So, even if all your reverts did fix it, you'd have to wait at least 24 hours (and maybe as long as a week, if you want to be truly certain) before you'd know whether it actually fixed things.

@loramin did you or anyone edit the Loc Map or the scripts that pull them in recently? Grasping at straws here

I didn't, but another wiki admin (Kaejer) recently did "loc map" Permafrost.

However, without getting super technical, the "loc map" feature (ie. being able to see maps with red Xs on them to show where NPCs are) is completely "client-side": it happens entirely in your browser (in Javascript).

But the dynamic zone stuff is done "server-side", using PHP. In a technical sense they are entirely distinct, and the loc map stuff can't cause a problem like this (because, to the server, the only change the loc map stuff makes is to add a category to the page ... and that's 100% harmless).

[Barm McLir]

If the issue was caused by a mob, I suspect that the other entries would display until they got to that mob then they would be blank or malformed. Unless the first mob pulled in was the problem...

I'd guess that the PHP code for the Wiki page contains an initial SQL call to get the list of NPCs;

SELECT name FROM npc_table WHERE zone CONTAINS "Permafrost";

To get a list of NPCs. Then the list of names is looped through and for each do an SQL call like;
SELECT race, class, level, location, known_loot, description FROM npc_table WHERE name = name LIMIT 1;

This is the one that is failing but the name still prints because it came from the first SQL call.

[Barm McLir]

It would help to see if PHP reports an error. There server for the wiki returned this to me;
Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/5.4.16.

I'm a Debian guy, so I googled for the PHP error log location for CentOS and it seems to be;
/var/log/php-fpm/www-error.log

[starkind]

It's like p99 has alzhiemers.

Thanks for the effort guys!

[starkind]

It's like p99 has alzhiemers.

Thanks for the effort guys!

It may be easier to recreate that page from scratch at this point.

[loramin]

It would help to see if PHP reports an error. There server for the wiki returned this to me;
Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/5.4.16.

I'm a Debian guy, so I googled for the PHP error log location for CentOS and it seems to be;
/var/log/php-fpm/www-error.log

Agreed ... but (unfortunately) only Rogean and Ravhin have access to the PHP error logs.

However, if you're curious you can find the PHP code here: https://wiki.project1999.com/utils/wikiUtils.php (under the "Custom Extensions Source" link).

[loramin]

P.S. Typically what happens in these sorts of situations is that Ravhin comes "out of retirement" at some point, checks the logs, finds the problem, and fixes it. So really, all we need to do is wait.

That being said, if anyone is a PHP coder who wants to be more involved, first check out the source code (linked above), and then ... if you're still serious about helping out ... send a PM to Ravhin.

[UrkTheSlayer]

You got an intro to php vid bookmarked you could share loramin? There’s a bunch of quests I want to add to the Druid and wizard quests pages.

[Barm McLir]

However, if you're curious you can find the PHP code here: https://wiki.project1999.com/utils/wikiUtils.php (under the "Custom Extensions Source" link).

Wow I didn't catch the guy did everything as a MediaWiki extension but yeah that makes sense.

In DynamicZoneList_body.php, lines 590-591 it generates the list of NPC names from the page's NPC table itself;

$catNames = array($zoneName,"NPCs");
$NPCs = DynamicZoneList::getCatIntersection($db,$parser,$c atNames);


I guess the idea is you just need to manually add an existing NPC in the first column and the extension fills in the next six.

Line 671 is the loop for each table row:
foreach ( $NPCs as $row )

To get the column values, it calls parseNPCPage at line 184. The most complex section is the one dealing with loot, lines 223 - 252.

My first suspicion is that one of the NPC's loot entries contains some text that is choking the parser.

[Barm McLir]

So I went to edit the page and have to take back that part about manually added NPC's to a table... Does not work like that at all.

I wish this forum was more forgiving about edits.

[starkind]

well i posted it here cuz i'm a paranoid schizo but liek, i really do appreciate your intelligent thought!

sorry it's in rnf!

it wasnt a complaint

I was just being randomly angry at the universe for breaking things I love and worry about

[loramin]

You got an intro to php vid bookmarked you could share loramin? There’s a bunch of quests I want to add to the Druid and wizard quests pages.

I don't. However, you don't need to know PHP to edit the wiki! All you need to know is this: https://wiki.project1999.com/Editing

The first link on the page explains the basics of wiki-editing, and the rest of the page explains some of the P99-specific parts.

So I went to edit the page and have to take back that part about manually added NPC's to a table... Does not work like that at all.

I wish this forum was more forgiving about edits.

This is the fun of trying to "grok" someone else's code ... in public :)

[Barm McLir]

Dang I thought I found it, The Goblin Sage's loot list was missing almost all the closing list item tags: </li>

No joy.

[Tunabros]

half the wiki is false information anyways

[Nirgon]

Shamans can't even port

The people who made this game were cavemen that knew nothing of good mmo design

(2 loud honks)

[RecondoJoe]

It is crazy that Shamans couldn't teleport because that's what the class is based around, literally:

Walk the Ages
Mark your current location in time. When you activate Walk the Ages again, you will become Timeless, instantly returning to the location you had previously marked.

[UrkTheSlayer]

I don't. However, you don't need to know PHP to edit the wiki! All you need to know is this: https://wiki.project1999.com/Editing

The first link on the page explains the basics of wiki-editing, and the rest of the page explains some of the P99-specific parts.

Thanks G!

Stoked to see nirgon and joe finding some common interests, I hope this romance brings a beautiful relationship to fruition. Please don’t forget to invite me to your wedding.

[Barm McLir]

BlackBellamy idea to roll back edits was solid but Loramin is right about the updates taking a while to show on the DynamicZoneGuide. I found two quotes from Ravhin;

>> it is cached (up to a week), so it will eventually appear. Thanks! --Ravhin (talk) 16:24, 26 August 2014 (UTC)]

>> These lists do not update immediately, so if you add a category to a page it may take a day or two before it appears in the dynamic zone list.

The second is years later so probably more accurate. I cleaned up a couple of glitches in some NPC and item templates so let's see what happens in a day or two.

[Pulgasari]

this is fixed

[starkind]

this is fixed

Woot awesome.

[Jontheripper]

I have enough krono to pay you poorbies some subs on TLP...

Live isn't eq

[UrkTheSlayer]

Live isn't eq

[Jimjam]

this is fixed

Well done team!!