WordPress Download Manager

May 25, 2023 at 7:10 pm in reply to: Update URLs in mass update #187417

Participant

is there another table that i need to update too with this new URL? or special SQL command to use when dealing with . or – or / in the request?

May 25, 2023 at 7:04 pm in reply to: Update URLs in mass update #187416

renzukoken

Participant

I will update this thread,

I cannot use default value plugin as my WPDM plugin is too old to support it, but i presume as i paid for the plugin yearly, i would still have support. I know i’m not using the latest version of the plugin but my old server stop in a week and i’m seeking for help.

My main purpose is not to ask for any new wpdm code or addon, but basically to understand how it work

something simple : update wp_postmeta set meta_value = replace(meta_value, 'ns37xxxxx.ip-213-32-0.eu/folder1', 'ns30yyyyy.ip-149-202-85.eu/folder2') WHERE meta_key = '__wpdm_files'; exact SQL request right?

Result : On Phpmyadmin, the field is perfectly replaced by the new “folder2” with new server URL but on the Website, under the WPDM plugin downloads setting, the field “attached files” gets empty!

Another something simple : Export database, edit database with notepad++, replace old download server link with new server link on the 7500 lines concerned, then re-import SQL database
Same… all links were replaced under phpMyAdmin correctly, but “attached file” field on wpdm got empty again…

3rd simple example? doing same but replacing just “ns37xxxxx” by “ns30yyyyy” without any – or . or / or special characters
works great, attached file got updated under phpmyadmin AND wpdm “attached files” badly i need to change the full url…

why???
Is there some joint tables that are linked to wpdm_files that i need to change too?

I’m out of ideas badly, and really need for support. i don’t see myself changing 1 by 1 all the 7500 different wpdm links.

Thanks in advance.

Renz

May 19, 2023 at 9:39 am in reply to: Update URLs in mass update #186911

renzukoken

Participant

Thanks for your quick answer.

For this website i’m trying to update, it is still an old version 4.X of WPDM and the addon will not be compatible.

Any hint on updating all link using a php script or SQL without messing with “attached files” getting empty after?

Thanks

May 18, 2023 at 8:13 am in reply to: Update URLs in mass update #186875

renzukoken

Participant

For an update, with the SQL command, if i use only

update wp_postmeta set meta_value = replace(meta_value, 'nsXXXX', 'nsYYY'); without .ip-213-32-0.eu/Folder
it seem to work, the attached file is still here but with the correct new server name but the wrong .ip-xxx.eu. as i removed it from the SQL request

Is there a reason why a ., – or a / could cause issue in the meta_value SQL injection for WPDM that cause attached file to be empty?

Feb 20, 2020 at 5:14 pm in reply to: Download Manager packages order #120484

renzukoken

Participant

sent a private reply

Feb 18, 2020 at 4:57 pm in reply to: Download Manager packages order #120363

renzukoken

Participant

didn’t managed to find in which file i should add this code and how to make the loop 😉 sry

Feb 17, 2020 at 5:09 pm in reply to: Download Manager packages order #120322

renzukoken

Participant

Hi,
Thanks for the annswer.

Trying to understand, when displaying package, using the link of a category, it diplay by added date, it mean there is a query somewhere that say order by added time,
mean, somewhere in a php file of the WPDM, there is a query requesting “order by time added”? or it’s the WordPress itself that made that query?

It’s been a while that i didn’t play with database, so if you have any idea which file to modify that query ONLY for WPDM categories (as i don’t want my WP articles to be alphabetically ordered hehe :))

that would help me as right now, it’s all by time added, and moving to a “page” format with shortcode (just tried) works but will make some of my other plugins not working anymore

thank you

Feb 14, 2020 at 3:38 pm in reply to: Download Manager packages order #120185

renzukoken

Participant

I should maybe start working on short codes and a page haha, but right now, wanted to have a temporary solution

Feb 14, 2020 at 3:26 pm in reply to: Download Manager packages order #120183

renzukoken

Participant

i’m just creating categories, categories have a link to see everything that are inside. that’s it, no pages, and d’ont want to use thoses shortcodes as they are not usable in my case.

Exemple : http://www.psxrenzukoken.com/nk2/downloads/fan-trad-e/

This is just a link to the category, not a page, so i would be glad to be able to modify the SQL request, as it seem it’s the only way for me

Thanks again

Feb 20, 2019 at 3:41 pm in reply to: Order by alphabetical order #94022

renzukoken

Participant

ok thanks, will update and let you know

Feb 19, 2019 at 1:35 pm in reply to: Order by alphabetical order #93962

renzukoken

Participant

I tried to modify the template “panel” in the “link template” as seen on the attached jpg,
didn’t find in the template variable those short-code. didn’t find in settings any place for categories shortcode

To be honest, i do not understand at all how thoses short codes are working even after reading the documentation,

I would like to go back to my first idea, using WPDM 4.1.3, which file and line should i modify to force all SQL requests to display by title and not by ID, i saw function.php had some but not sure they are used for this purpose.

Thanks

Feb 17, 2019 at 4:30 pm in reply to: Order by alphabetical order #93876

renzukoken

Participant

Hi, Thanks for your reply.

But don’t understand what you mean by shortcode, never used any since i’m using WPDM
I create categories, then package to include in thoses catégories then create a menu on wordpress with a link to those categories.
Simple and work like a charm.
There is just the SQL request to display packages in categories that diplay them by “time added”

unless i missed something, my only thought was to force the SQL request to display ‘by alphaetic order”

thanks

Feb 13, 2019 at 12:53 pm in reply to: Order by alphabetical order #93655

renzukoken

Participant

Google brought me to some forum talking about download-manager.php to edit, but on the 4.1.3, there is no such sql query inside :/ any help will be apreciated 🙂

thanks

Nov 27, 2017 at 11:46 am in reply to: TOP Downloads #66029

renzukoken

Participant

Thanks for the answer, does it work only with the latest version of WPDM?

Oct 28, 2017 at 10:29 am in reply to: Changing files URL's in mass #64959

renzukoken

Participant

Found the issue 🙂

It was a simple mistake, there is mey_key in the script, a T is missing : meta_key

In the end i created a simple php file at the root of the serveur with inside

include_once('wp-load.php' );
mysql connect etc...

then the script with the missing letter T

And all works perfectly ^^ thanks

Oct 27, 2017 at 9:17 am in reply to: Changing files URL's in mass #64929

renzukoken

Participant

Hi

Sorry to open this old topic, but now changing to a soyoustart server, i decided to follow the steps from this topic to change the files path

From the previous comments look like it woks well, badly, got no clue where to put this code, can anyone guide me for this part?

just tried by copying paste on a template page without result :

Code

Thanks 😉

PS : Can’t it be replaced by an SQL request to do the same thing?

Jul 3, 2017 at 12:52 pm in reply to: Changing files URL's in mass #59899

renzukoken

Participant

thanks a lot

Jul 1, 2017 at 4:10 pm in reply to: Changing files URL's in mass #59859

renzukoken

Participant

awsome news 🙂 you just copy past the code into the SQL request of phpmyadmin? or just in a PHP script you run from your webpage

Jul 1, 2017 at 3:06 pm in reply to: Changing files URL's in mass #59854

renzukoken

Participant

Hi, I actually managed to un-hack my server so didn’t had to use this script yet (i kept it on a safe place to try as soon as i change server)
But i’ll be very happy to hear about it if someone tries it ^^

Feb 15, 2017 at 5:43 pm in reply to: Changing files URL's in mass #53752

renzukoken

Participant

Thanks, will try that and keep you posted 🙂

Feb 13, 2017 at 12:13 pm in reply to: Changing files URL's in mass #53655

renzukoken

Participant

Hope there is lol, would be hell annoying to update each package. Still trying to find a solution

Feb 10, 2017 at 2:24 pm in reply to: Changing files URL's in mass #53573

renzukoken

Participant

I mean each time you add a package, for the attached file, I add an URL for the file to download (on an external server, i don’t use the “upload” function), this URL is set by me.

now all my packages have a URL http://ns32……… but i’m moving all my files to a server named http://ns42….. (still an external server, not the one where WordPress is set)
so all my downloads will not work, i can actually go inside each packages 1 by 1 to update the link to the new server, but doing than more than 3000 times is not what i want.

I tryied to modify those packages link directly into the database, but when i do that, when i edit a package, attached file URL is empty.

What are my solutions?

Feb 9, 2017 at 10:33 am in reply to: Changing files URL's in mass #53522

renzukoken

Participant

Any moderator available to answer? i searched the addon list without finding anything usefull

renzukoken

Forum Replies Created

Quick Access

Blog

Support

Add-ons

Customization Service

renzukoken

Forum Replies Created