I Can't Download Any Maps, because of MySQL database error Options

[蛊真人]

Error!

An error occurred during the operation:

Internal error in the MySQL database.

Please check your data. In doubt, thank you for reporting this error to the forum.

helpme cannot download map and SEE this . how to fix it thank you

[Sloggy]

i have the same problem

[2141700552]

所以要怎么解决？

[DedSec]

same problem x(

[tamoqohuhe]

Same.

Made an account just because I could no longer download maps but that obviously didn't help.

This site has more maps than gamebanana, maybe someone should upload them there instead.

This post has been edited by tamoqohuhe: 21/06/2024 - 18:15:09

[tamoqohuhe]

It actually worked on the 19th for a bit and I quickly snatched a bunch of them, mostly zp_
But I'm using tor here, so I was trying new circuits until it worked, could have been a coincidence tho.

Also got this as an alternative error:

An error occurred during the operation:

1 - You can't access this file directly.

I'll add that I use firefox based browsers if that helps.

This post has been edited by Safety1st: 27/09/2024 - 21:45:57

[EnborianPL]

I also can't download ANYTHING.

[buckets]

been broken for months now (IMG:style_emoticons/default/sad.gif)

[Izuko_Fukuda]

So what's going on?did the opreators of the site run away or is there something wrong with their servers?

[mihailm]

Ошибка!

Произошла ошибка во время выполнения операции:

Internal error in the MySQL database.

Пожалуйста проверьте свои данные. Благодарим за сообщение об этой ошибке на форуме.

This post has been edited by mihailm: 15/07/2024 - 07:46:22

[cs3248]

ITS SHOW ME MYSQL ERROR, wth
any fix??

[finez]

Yep, same here, can't download any map , no matter if i'm logged in or not + even captcha test does not work, it says i put wrong characters but i did not.

[cs3248]

Yep, same here, can't download any map , no matter if i'm logged in or not + even captcha test does not work, it says i put wrong characters but i did not.

Did you find how to fix it?

[El Abuelo]

Hello guys, I can't download maps either, without registering it indicates that the captcha is incorrect, and registering it gives me an error from mySQL

We need support from a moderator

[Dr. Y. J. Shazbo...]

I really hope this gets addressed. This would be a tragic loss to the HL community if this site is lost.

[Dr. Y. J. Shazbo...]

A temporary fix is available. Go to any map you wish to download, right click the page, go to inspect, then go to console, and paste this script there. All you need is the Map ID Number from the URL to make it work. Once you've copied the Map ID Number over the text that needs to be replaced, just press enter and the download should trigger.

Spoiler:

CODE

//Created bypolat
//Altered and butchered by YellowJello
GlblUrl = "https://www.17buddies.rocks/17b2/"
sTyp = "Map";
//The Map URL ID is the number that appears in the url just before the name of the map.
//Example: For cs_haste (17buddies.rocks/17b2/View/Map/1530/cs_haste.html), the Map ID is 1530.
nId = window.location.href.match(/(PASTE THE MAP URL ID NUMBER HERE)/)[1];
bHlbox = 1;
sCph = "x";
szUrl = GlblUrl + "Push/PreDown/" + sTyp + "/" + nId + "/" + sCph + "/" + bHlbox + "/index.html";
zipName = window.location.href.split('/').pop().split('.')[0];
async function download() {
try {
let response = await fetch(szUrl);
if (!response.ok) throw new Error('Network response was not ok.');
let sResult = await response.text();
let FileDatas = sResult.split('|');
let FileName = FileDatas[2];
while(true)
if(await zipDownload(FileName))
return
} catch (error) {
console.error('Dosya indirilirken hata oluştu:', error);
}
}
async function zipDownload(FileName) {
try {
let response = await fetch( GlblUrl + "Get/" + FileName + ".zip");
if (!response.ok) throw new Error('File download failed.');
let arrayBuffer = await response.arrayBuffer();
let blob = new Blob([arrayBuffer], { type: response.headers.get('content-type') || 'application/octet-stream' });
let text = await new Response(blob).text();
if(!text.includes(FileName))
saveAsFile(new Blob([arrayBuffer], { type: 'application/zip' }), zipName + ".zip")
return !text.includes(FileName)
} catch (error) {
throw new Error('Dosya indirme işlemi sırasında hata oluştu:', error);
}
}
function saveAsFile(blob, fileName) {
var link = document.createElement('a');
link.href = window.URL.createObjectURL(blob);
link.download = fileName;
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
download();

This post has been edited by Safety1st: 28/09/2024 - 21:33:20

Reason for edit: added spoiler

[byplt]

I updated the script;

Spoiler:

CODE

// Created bypolat, thanks to YellowJello

// How to use;
// Firstly, login your account (17buddies.rocks)
// Goto the map
// Right click to the page and click inspect button
// Click console tab, and paste this code to console and enter
// And the map will be downloaded automatically.

GlblUrl = "https://www.17buddies.rocks/17b2/"
sTyp = "Map";
nId = window.location.href.match(/\/Map\/(\d+)\//)[1];
bHlbox = 1;
sCph = "x";
szUrl = GlblUrl + "Push/PreDown/" + sTyp + "/" + nId + "/" + sCph + "/" + bHlbox + "/index.html";
zipName = window.location.href.match(/\/([^\/]+)\.html$/)[1];

async function startDownload() {
    try {

        console.log("Downloading: " + zipName + ".zip, please wait.." )

        let response = await fetch(szUrl);
        if (!response.ok)
            {
                throw new Error('Network response was not ok.');
            }
        
        let sResult = await response.text();
        let FileDatas = sResult.split('|');
        let FileName = FileDatas[2];

        while(true)
        {
            if(await requestZipData(FileName))
            {
                return
            }
        }

    } catch (error) {
        throw new Error(error)
    }
}

async function requestZipData(FileName) {
    try {
        let response = await fetch( GlblUrl + "Get/" + FileName + ".zip");
        if (!response.ok){
            throw new Error('File download failed.');
        }

        let arrayBuffer = await response.arrayBuffer();
        let blob = new Blob([arrayBuffer], { type: response.headers.get('content-type') || 'application/octet-stream' });
        let text = await new Response(blob).text();

        if(!text.includes(FileName))
        {
            saveZipFile(new Blob([arrayBuffer], { type: 'application/zip' }), zipName + ".zip")
        }

        return !text.includes(FileName)
    } catch (error) {
        throw new Error(error);
    }
}

function saveZipFile(blob, fileName) {

    var link = document.createElement('a');
    link.href = window.URL.createObjectURL(blob);
    link.download = fileName;

    document.body.appendChild(link);
    link.click();

    document.body.removeChild(link);
}

startDownload().then(() => {
    console.log("Download completed: " + zipName + ".zip!")
}).catch(error => {
    throw new Error('An error occurred while downloading the file:', error);
});

This post has been edited by Safety1st: 28/09/2024 - 21:33:07

Reason for edit: added spoiler

[DarkGenius]

I updated the script

Thank you, this updated script works for me. (IMG:style_emoticons/default/ami2.gif) (IMG:style_emoticons/default/ami2.gif)

This post has been edited by Safety1st: 28/09/2024 - 21:32:41

Reason for edit: removed overquoting

[Artir]

I updated the script

thank you, it's works!

This post has been edited by Safety1st: 27/09/2024 - 21:34:46

Reason for edit: removed overquoting

[Safety1st]

Created complete guide about both download workarounds as the announcement which is visible in every forum.

[sxie]

Created complete guide about both download workarounds as the announcement which is visible in every forum.

what should we do to download wad files ?

[Safety1st]

I don't know a way, sorry. Try to ask byplt or Dr. Y. J. Shazbot about needed script…

[Th3-822]

what should we do to download wad files ?

I tried making a userscript with the hlbox method, seems to work fine with /Map/ and /Wad/ links (as those seems the only ones that are supported by Click'n Play)

userscript it's at here:
https://pastebin.com/RS46HX9Y

I tested it with TamperMonkey on Chrome, dunno if it needs fixing for other browsers or userscript managers.

Install userscript, then search any map/wad while logged in then click on Download or Click'n Play (both work as I'm changing the normal download to Click'n Play on the script)

Edit: if you get a whitepage with some code in it just press F5 and the download will start

This post has been edited by Th3-822: 09/10/2024 - 19:44:27

[siriusryu]

How to download models? not only maps

[death2024]

None of these scripts work

[Safety1st]

Script is fine. Without detailed info there is no way to help you.

[caizi]

Script is fine. Without detailed info there is no way to help you.

After the website's certificate expired, I am unable to download anything, whether through Click'n Play or via a script. What could be the reason for this?

The result after clicking to download

Click'n Play
File not found (Session has expired). Canceling...

script
bbe593ba960e44a1461de17659a07828|he_dustfield|18914|10|1

Alright, I tried using IDM with the script and was finally able to download it. However, I still want to report the situation.

But I can use it normally in the old version of Google Chrome

This post has been edited by caizi: 16/10/2024 - 07:37:00

[Safety1st]

caizi, thank you very much! (IMG:style_emoticons/default/ba.gif) (IMG:style_emoticons/default/ba.gif) (IMG:style_emoticons/default/ba.gif)

This post has been edited by Safety1st: 16/10/2024 - 07:20:12

[Safety1st]

Trying to reach the owner…

(IMG:https://i.ibb.co/C2tgqq4/17b.jpg)

This post has been edited by Safety1st: 16/10/2024 - 06:47:48

[death2024]

So if chrome works and what script to use

[Safety1st]

Just reread carefully and try to understand, you'll win (IMG:style_emoticons/default/felicitation.gif)

[ImPuLsS]

Hi, I'm Alex

I created this script to make map downloads from 17Buddies fast and easy. Inspired by the auto-download script originally posted by Safety1st, I wanted to expand on it with added features for a quicker experience.

**17Buddies Quick Downloader**

Description:
The 17Buddies Quick Downloader script allows you to instantly download maps from the 17Buddies website. It works for both individual map pages and the map list, making downloading maps a simple and fast process. Once installed, each map link is transformed into a direct download button, allowing you to get the maps without manually navigating through download pages.

How the Script Works:
1. **Identify Map Information**: The script fetches the map ID and name from each page or list.
2. **Prepare Download**: For each map, it forms the correct download link.
3. **Initiate Download**: It fetches the map file and prompts an automatic download.
4. **Retry Mechanism**: If the download link fails, it retries until successful.
5. **Applies to Buttons and Links**: The script detects and updates download buttons on individual pages and map lists, enabling direct downloads.

Installation Steps:
1. Make sure you have Tampermonkey installed in your browser.
2. View the script on GitHub here: 17Buddies Quick Downloader on GitHub.
3. For direct installation, use this link (Tampermonkey must be installed): Install 17Buddies Quick Downloader.
4. Click "Install" on the Tampermonkey page that opens, and the script will be added to your Tampermonkey scripts.

YouTube Video: here

Script Code:

Spoiler:

CODE

// ==UserScript==
// @name 17Buddies Quick Downloader
// @namespace http://tampermonkey.net/
// @version 2.4
// @description Instant map download for 17Buddies, applies to individual maps and map list
// @author @LeX
// @match https://www.17buddies.rocks/*
// @grant none
// @run-at document-start
// ==/UserScript==

(function() {
'use strict';

// Function to initiate the download process for a specific map using its ID and name
function startDownloadFromUrl(nId, zipName) {
const GlblUrl = "https://www.17buddies.rocks/17b2/";
const sTyp = "Map";
const bHlbox = 1;
const sCph = "x";
const szUrl = `${GlblUrl}Push/PreDown/${sTyp}/${nId}/${sCph}/${bHlbox}/index.html`;

async function startDownload() {
const loadingDiv = document.getElementById('Loading');
if (loadingDiv) loadingDiv.style.display = 'block';
try {
let response = await fetch(szUrl);
if (!response.ok) return;

let sResult = await response.text();
let FileDatas = sResult.split('|');
let FileName = FileDatas[2];

while (true) {
if (await requestZipData(FileName)) return;
}
} finally {
if (loadingDiv) loadingDiv.style.display = 'none';
}
}

// Requests and validates the zip file; retries if initial request fails
async function requestZipData(FileName) {
try {
let response = await fetch(`${GlblUrl}Get/${FileName}.zip`);
if (!response.ok) return false;

let arrayBuffer = await response.arrayBuffer();
let blob = new Blob([arrayBuffer], { type: response.headers.get('content-type') || 'application/octet-stream' });
let text = await new Response(blob).text();

if (!text.includes(FileName)) {
saveZipFile(new Blob([arrayBuffer], { type: 'application/zip' }), `${zipName.toLowerCase()}.zip`);
}

return !text.includes(FileName);
} catch {
return false;
}
}

// Saves the downloaded file to the user's device
function saveZipFile(blob, fileName) {
let link = document.createElement('a');
link.href = URL.createObjectURL(blob);
link.download = fileName;
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}

startDownload();
}

// Overrides default download button behavior on individual map pages
function overrideDownloadButton(button) {
const nId = window.location.href.match(/\/Map\/(\d+)\//)[1];
const zipName = window.location.href.match(/\/([^\/]+)\.html$/)[1];
button.removeAttribute('onclick');
button.addEventListener('click', function(event) {
event.preventDefault();
startDownloadFromUrl(nId, zipName);
});
}

// Overrides download links in the map list to initiate quick download
function overrideListDownloadLink(link, nId, zipName) {
link.removeAttribute('onclick');
link.addEventListener('click', function(event) {
event.preventDefault();
startDownloadFromUrl(nId, zipName);
});
}

// Observes DOM changes for individual map page buttons and applies override
new MutationObserver((mutations, observer) => {
for (const mutation of mutations) {
for (const node of mutation.addedNodes) {
if (node.nodeType === 1 && node.matches('.MapBtn.MapDown')) {
overrideDownloadButton(node);
observer.disconnect();
}
}
}
}).observe(document, { childList: true, subtree: true });

// Observes DOM changes for download links in map lists and applies override
new MutationObserver((mutations) => {
for (const mutation of mutations) {
for (const node of mutation.addedNodes) {
if (node.nodeType === 1 && node.matches('.MapActions a[onclick^="GoDown"]')) {
const parentDiv = node.closest('div[id^="usrl_"]');
if (parentDiv) {
const nId = parentDiv.id.split('_')[1];
const zipName = parentDiv.querySelector('.ObjectName span[itemprop="itemListElement"]').textContent;
overrideListDownloadLink(node, nId, zipName.toLowerCase());
}
}
}
}
}).observe(document, { childList: true, subtree: true });
})();

This post has been edited by ImPuLsS: 26/10/2024 - 12:49:23

[Safety1st]

Trying to reach the server operator…
(IMG:https://i.ibb.co/NxBPFfn/ark.jpg)

[Arkshine]

Sorry for the delay.

It should be fixed. I used a workaround; hopefully, it will work fine. (IMG:style_emoticons/default/yes3.gif)

[Safety1st]

Hallelujah!
(IMG:style_emoticons/default/malades2.gif)

This post has been edited by Safety1st: 10/11/2024 - 02:32:16