Who vandalized the wiki?

[loramin]

Originally Posted by BlackBellamy [You must be logged in to view images. Log in or Register.]

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.

Originally Posted by BlackBellamy [You must be logged in to view images. Log in or Register.]

@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]

Originally Posted by BlackBellamy [You must be logged in to view images. Log in or Register.]

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]

Originally Posted by starkind [You must be logged in to view images. Log in or Register.]

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]

Originally Posted by Barm McLir [You must be logged in to view images. Log in or Register.]

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]

Originally Posted by loramin [You must be logged in to view images. Log in or Register.]

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,$catNames);

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.