Database problem

[BBH]

Wes Copeland, "wc" on the Donkey Kong Forum, and in charge there since Jeff Harrist passed away, indicates that if he can be of assistance with a Python or SQL issue he is willing.

https://donkeykongforum.net/index.php?t ... n#msg46318

Just posting to confirm that Wes Copeland is definitely interested in bringing the site back up. He's done a lot of work over at the RetroAchievements website as well, so I certainly trust his expertise. I don't know if this is just a matter of nobody being able to give admin privileges to another user or what - if there's any worries that he's going to hijack the website, I can assure you that's not going to happen.

[BBH]

No updates on anything, huh.

I'll just say that http://replay.marpirc.net/txt/scores3.htm was working up until everything died a month ago, and can still be checked if you're looking for historical information on each game's top 3.

If you're trying to grab random replays off the site, you can try looking up individual game pages on the Internet Archive's Wayback Machine (example: https://web.archive.org/web/20150217082730/http://replay.marpirc.net/r/bongo). Unfortunately, a lot of pages do not have captures newer than 2015, which is a definite problem if you're looking for some recent records. But at the very least, all the old stuff is not gone forever.

[Weehawk]

No updates on anything, huh.

I'll just say that http://replay.marpirc.net/txt/scores3.htm was working up until everything died a month ago, and can still be checked if you're looking for historical information on each game's top 3.

If you're trying to grab random replays off the site, you can try looking up individual game pages on the Internet Archive's Wayback Machine (example: https://web.archive.org/web/20150217082730/http://replay.marpirc.net/r/bongo). Unfortunately, a lot of pages do not have captures newer than 2015, which is a definite problem if you're looking for some recent records. But at the very least, all the old stuff is not gone forever.

(BBH knows this but for anyone else's benefit:)

All MARP replays are still available at:

Code: Select all

http://marp.retrogames.com/inp/log_romname_xxxxxx_wolf106.zip

Where:
"log" is the player's login ID
"romname" is the name of the ROMset in MAME
"xxxxxx" is the score
"wolf106" is the MAME version used

If the score is confirmed, all of this information except the MAME version can be found on the Confirms page, which still works:

http://replay.marpirc.net/confirm.htm

The MAME version can often be guessed from the time period.

[PG3]

http://replay.marpirc.net/upload.htm - 28.03.24
http://replay.marpirc.net/confirm.htm - 28.03.24
http://replay.marpirc.net/txt/scores3.htm - 28.03.24
http://replay.marpirc.net/txt/scores.htm - 28.03.24
http://replay.marpirc.net/news.cgi - 26.03.24
http://marp.retrogames.com/test/frames.htm - [19.11.00]

https://web.archive.org/web/20231130131 ... lympic.htm - 30.11.23
https://web.archive.org/web/20220628094 ... xlines=999 - [28.06.22]
https://web.archive.org/web/20230607081 ... r/vendetta - 07.06.23

https://web.archive.org/web/20210128155 ... re.com/PG3 - 28.01.21
https://web.archive.org/web/20170916084 ... .php?n=297 - 16.09.17

[Weehawk]

https://web.archive.org/web/20231130131 ... lympic.htm - 30.11.23

Putting http://replay.marpirc.net/r/romname into the Wayback Machine turns up the list for everything I tried.

archive.org is amazing.

[mahlemiut]

All MARP replays are still available at:

Code: Select all

http://marp.retrogames.com/inp/log_romname_xxxxxx_wolf106.zip

Where:
"log" is the player's login ID
"romname" is the name of the ROMset in MAME
"xxxxxx" is the score
"wolf106" is the MAME version used

That this still works suggests that some code is still working, as it has to find the exact folder the zip file is located. (It was split up into multiple folders as the server hated giant folders)
Hopefully this means than any changes that need to be made, are fairly simple and are just related to the MySQL update.

[Weehawk]

Hopefully this means than any changes that need to be made, are fairly simple and are just related to the MySQL update.

Everybody seems to think it's probably something pretty simple.

Out of curiosity, has anybody tried actually talking to a human being at Dreamhost?