editing # of DLs in the shared files module

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
12/14/2010 1:10:53 AM
Gravatar
Total Posts 147
Download Free Mojo Skins http://crypticsites.net

editing # of DLs in the shared files module

Here's a weird question:  is there any way to manually edit, or set the counter's starting point, for the number of downloads of files in the shared files module?  Because I am moving my site to a new non-subdomain URL and updating all my skins, but keeping copies of the older-version skins, I would like to manually set the number of times each was downloaded at the old, subdomain site.  I know this can be done in a MySQL database, usually by manually setting the beginning number of a counter field, but I don't know that much about using MS-SQL or that SQL Server Mgmt software -- is this possible?

Thx!

Andria

 

12/14/2010 7:43:08 AM
Gravatar
Total Posts 18439

Re: editing # of DLs in the shared files module

Hi Andria,

If you have a tool of some kind to manage the database, you can go into the mp_SharedFiles table and directly edit the DownloadCount field on any row. Each file is represented by a row in the table. There is no seed number per se, when you upload a new file it creates a row with a default value of 0 for the DownloadCount but you could edit that value after the row exists.

Hope it helps,

Joe

12/14/2010 12:23:21 PM
Gravatar
Total Posts 147
Download Free Mojo Skins http://crypticsites.net

Re: editing # of DLs in the shared files module

Well, it's good to know the capability is there; I'm wandering around in SQL Server Mgmt Studio, and I have located my database, a table in it called dbo.mp_SharedFiles, and I can see the structure - Columns, Keys, Constraints, Triggers, Indexes [shouldn't that be 'indices'?], and Statistics, and in the one called Columns, one called DownloadCount (int, null), and if I double-click that I can see the structure of it -- but I don't know how to find the data.  I know some or most of this is probably analogous or comparable to MySQL, but as yet I am unable to translate a lot of it.  It seems that MySQL dbs are more plain-text oriented, while this appears to be more of a "compiled" sort of thing, very relational and hierarchical (if that's a word).  I was always better at Lotus 1-2-3 than dBase,  wink but no doubt I will locate some sort of docs for using MS SQL to best advantage -- the internet, ah, what a concept!

Thx!

Andria

12/14/2010 12:29:23 PM
Gravatar
Total Posts 18439

Re: editing # of DLs in the shared files module

right click on the table name and you should get an option to edit data

12/17/2010 10:06:38 AM
Gravatar
Total Posts 147
Download Free Mojo Skins http://crypticsites.net

Re: editing # of DLs in the shared files module

Thanks Joe; no telling how long that would have taken me to find or figure out. wink  I was able to edit them, and get the original stats for the original files.

Thx!

Andria

You must sign in to post in the forums. This thread is closed to new posts.