vb.org Archive - Whodownloaded

Page 3 of 4

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Whodownloaded_IP with Dates (https://vborg.vbsupport.ru/showthread.php?t=93167)

eNforce

12-09-2005 04:18 AM

Installation went well, permissions set, plugin enabled in the main. But nothing is showing up on the attachments

I'm running vB 3.5.2 , it it not compatible?

Edit: Apparently the image I was using was too small in resolution or something.. . that's why I saw nothing, it works now with large images and zip etc :tired:

Mr Blunt

12-09-2005 04:38 AM

Quote:

Originally Posted by eNforce

Installation went well, permissions set, plugin enabled in the main. But nothing is showing up on the attachments

I'm running vB 3.5.2 , it it not compatible?

1) I'll have to download 3.5.2 and play I guess. I didn't know it was out. Thanks for the head's up. You might have to give me a few days if there is a true compatability problem.

2) Upon installation, you won't have any data in the table, so login to your forum and download one from any thread. Afterwards, come back to the admincp and see if the download appears in the quick search. If you have some crons setup do only update things like once an hour .... then of course you'll have to wait for that period of time.

3) If you had a previous 3.0.x version, and your expecting to see the old data immediately, that's not how my v1.1.0 is setup. I made importing an "option" which you will be able to use after you gain access to the search engine (by downloading one file to start things).

If #2 & #3 don't solve the mystery, then it's probably #1.

eNforce

12-09-2005 04:40 AM

Ahh, please read the edit of my previous post, now I feel bad for having you type all that up...

It's up and running fine :)

During installation it told me I had previously installed it on 3.0.x, I don't even remember that far back! :speechless:

Mr Blunt

12-09-2005 04:50 AM

Don't worry about my typing bro.
I talk a lot.
Glad it's all good.

Feedback would be helpful.
I always like to hear ideas, good and bad.
And I like to fix things.

mhammed

12-09-2005 05:59 AM

Quote:

Originally Posted by Mr Blunt

It's failing on line 17 of install code 1.0.6
This is where it adds values to each of the new usergroup permission's fields.

Only thing that I can think of is that maybe you don't have permission to "alter database tables" in SQL, meaning the column isn't getting created. You should be able to check this if you can log into phpmyadmin.

If your not the main administrator who installed the forum, please ask him to verify that you have permission to alter tables AND please ask him to try installing the product for you.

If you are the only administrator, and you can't solve this, then PM me with login details for your Forum's AdminCP and your Server's Control Panel (like phpmyadmin).

If you figure out what the problem was, please reply so I'll know the source of that problem in the future.

I am sole owner. I have all the permissions.
I can execute requests SQL from my admincp

in my config.php
$config['SpecialUsers']['canrunqueries'] = '1';

it's me

ok

other thing to make for this permission?

warrenrees

12-09-2005 01:07 PM

There definately appears to be compatibility issues with 3.5.2. Here's what I get when someone downloads the file:

Code:

Database error in vBulletin 3.5.2:



Invalid SQL:

INSERT INTO blunts_whodownloaded_ip (userid, username, filename, fileid, ipaddress, alt_ip, dateline)

                VALUES (1427,

                        '',

                        '',

                        2661,

                        '',

                        '',

                        1134139939);



MySQL Error  : 

Error Number : 

Date         : Friday, December 9th 2005 @ 09:52:19 AM

Script       : http://myforum/forum/attachment.php?attachmentid=2661&d=1133518215

Referrer     : http://myforum/forum/showthread.php?t=6349

IP Address   : x.x.x.x

Username     : blabla

Classname    : vb_database

and here's what's attached to files when I download them:

Code:

<br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_query(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>395</strong><br /><br /><strong>Warning</strong>: mysql_error(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>837</strong><br /><br /><strong>Warning</strong>: mysql_errno(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>855</strong><br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

and then the whole "Database error" stuff. It gets attached to the file.

bashy

12-09-2005 01:33 PM

I have vb 3.5.2 also and i get the exact error!!
Its not showing who has downloaded what either, when i click Who Downloaded, it says 2 downloads of File but no names or IP's also it is not logging downloads at all, and the Quick Search Engine is not finding anything....

Bashy

Quote:

Originally Posted by warrenrees

There definately appears to be compatibility issues with 3.5.2. Here's what I get when someone downloads the file:

Code:

Database error in vBulletin 3.5.2:



Invalid SQL:

INSERT INTO blunts_whodownloaded_ip (userid, username, filename, fileid, ipaddress, alt_ip, dateline)

                VALUES (1427,

                        '',

                        '',

                        2661,

                        '',

                        '',

                        1134139939);



MySQL Error  : 

Error Number : 

Date         : Friday, December 9th 2005 @ 09:52:19 AM

Script       : http://myforum/forum/attachment.php?attachmentid=2661&d=1133518215

Referrer     : http://myforum/forum/showthread.php?t=6349

IP Address   : x.x.x.x

Username     : blabla

Classname    : vb_database

and here's what's attached to files when I download them:

Code:

<br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_query(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>395</strong><br /><br /><strong>Warning</strong>: mysql_error(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>837</strong><br /><br /><strong>Warning</strong>: mysql_errno(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>855</strong><br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

and then the whole "Database error" stuff. It gets attached to the file.

belinea

12-09-2005 07:39 PM

I also have upgarded to vB3.5.2. I get the same error.

so, I have de-installed the Whodownloaded Plugin and tried to reinstall it. But i get th following error message:

Quote:

Warning: Invalid argument supplied for foreach() in /admincpanel/plugin.php(1239) : eval()'d code on line 17

The current version of WhoeDownloaded doesn?t support vBulletin3.5.2

Mr.Blunts: Can you have a look at it and release a new version of "WhoDownloaded" ??? Many, many, many thanks.

Mr Blunt

12-09-2005 09:55 PM

I get the error too.
I'll probably have it fixed by morning.

PLEASE DO NOT UNINSTALL!!!
PLEASE DO NOT UNINSTALL!!!
PLEASE DO NOT UNINSTALL!!!
PLEASE DO NOT UNINSTALL!!!

JUST "DISABLE" THE PRODUCT!!!
You do NOT have to worry about anything if you do this.

warrenrees

12-11-2005 06:43 AM

Thanks Mr. Blunt :)

Mr Blunt

12-11-2005 06:57 AM

I'm still testing but the major fix is as follows:

1) Go into "Plugin Manager" (not Product Manager).
2) Find "Whodownloaded IP - Enable Logging" plugin and click Edit.
3) At top, Change the Hook to "attachment_display" (1 above attachment_complete).

Or wait another few hours and I'll upload fix.
Sorry for the delays.
I think I found a couple other real minor issues that I'm working on as I type.

mhammed

12-11-2005 10:58 AM

Quote:

Originally Posted by Mr Blunt

thank you very much. I would wait in what relates to me. but, if you want to think well of those uninstall it.
what is necessary to make?

Mr Blunt

12-11-2005 11:39 AM

Quote:

Originally Posted by mhammed

thank you very much. I would wait in what relates to me. but, if you want to think well of those uninstall it.
what is necessary to make?

Your problem is what I'm working on, and is why everyone else has to wait.
I do see the installation bug, but I'm not sure yet on how to fix it.
This is not an easy one to solve.

It appears to me like vB352 addressed an issue pertaining to unused bitfields, like for people who forget to delete the bitfield file after installation, which in turn is screwing around with my installation/uninstallation codes.

Do not install this.
Do not uninstall this.
Even if you really want to!!!

There are only 2 fixes right now.

"Disable" my product until I fix the install/uninstall codes.
...Or...
Edit the plugin called "Enable Logging" and change hook so it says "attachment_display".

Replicators

12-11-2005 06:50 PM

I take it this hack is for attachments and not external url's?

Would it be possible for a hack like this do the same for external url links?

Mr Blunt

12-12-2005 09:35 AM

v-1.2.0 - December 12th, 2005:

MANDATORY FIX to correct issues which made 1.1.0 incompatible with vb351+ .... I strongly recommend updating this product before upgrading to vb351 or vb352, if you haven't yet.
Moved a lot of the install code from the product file to the admin file.
Condensed the rest of the install/uninstall code.
Changed the format of all files from Windows to UNIX.
Updated all the screenshots (some are not shown).
Removed the Beta Tag from the product.

To Do and/or Wish List:

I'm still looking for someone to help me add better language support.

Known Bug List:

Installation messages are english only since code installs before phrases.
Non-IE5.5 shows horizontal href text next to thumbs IF THE BMP isn't found ... which looks REALLY dumb ... so make sure you upload the BMP to the proper folder on your server!!

belinea

12-12-2005 02:43 PM

GREAT JOB, Mr.Blunt !!!

Mastar

12-12-2005 02:57 PM

Works flawless so far. Love that you have included the usergroup in the menu. I wish that more of these hack would include a menu where permissions and other options are added.

Thanks!

Mastar

12-12-2005 03:33 PM

I have 2 quick search engines my ACP https://vborg.vbsupport.ru/attachmen...chmentid=39224

Mr Blunt

12-12-2005 04:19 PM

Quote:

Originally Posted by Mastar

I have 2 quick search engines my ACP https://vborg.vbsupport.ru/attachmen...chmentid=39224

Yes, one engine at top and another engine at bottom. I figure after a few years of downloads, your searches will return large numbers of results, so maybe this will help cut down on scrolling.

Mr Blunt

12-12-2005 04:35 PM

Quote:

Originally Posted by Replicators

I take it this hack is for attachments and not external url's?

Would it be possible for a hack like this do the same for external url links?

Sorry, but this only collects information about downloaded attachments.
I don't forsee myself merging a links manager into this, but anything is possible.
The topic is open for discussion though.

bashy

12-13-2005 09:08 AM

Hi Mr Blunt

Please can you tell me where i can edit the button as it looks a little too long?

Regards

bashy

Mr Blunt

12-13-2005 09:43 AM

Quote:

Originally Posted by bashy

Hi Mr Blunt

Please can you tell me where i can edit the button as it looks a little too long?

Regards

bashy

I wish I could.
That's the best I.E. can do.

Your not going to save a lot, but I suppose you could force the "postbit_attachmentthumbnail" template to use my BMP file instead of the html code (or your own picture).

Find this:

Code:

        <if condition="is_browser('ie', '5.5')">

                <input type="button" class="button" value="$vbphrase[blunts_whodl_who_downloaded]" tabindex="1" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]fid=$attachment[attachmentid]','blunts_whodownloaded_ip','toolbar=no, scrollbars=yes, resizable=yes, width=$show[blunts_whodl_width], height=450, top=50, left=50'); return false;" title="$vbphrase[blunts_whodl_who_downloaded]: $attachment[attachmentid]" style="writing-mode:tb-rl" />

        <else />

                <a href="blunts_whodownloaded_ip.php?$session[sessionurl]fid=$attachment[attachmentid]"<if condition="$show['newwindow']"> target="_blank"</if>><img class="button" src="$stylevar[imgdir_attach]/blunts_whodl_vertical.bmp" alt="$vbphrase[blunts_whodl_who_downloaded]" border="1" title="$vbphrase[blunts_whodl_who_downloaded]: $attachment[attachmentid]" /></a>

        </if>

And change it to this to use my button image file:

Code:

        <a href="blunts_whodownloaded_ip.php?$session[sessionurl]fid=$attachment[attachmentid]"<if condition="$show['newwindow']"> target="_blank"</if>><img class="button" src="$stylevar[imgdir_attach]/blunts_whodl_vertical.bmp" alt="$vbphrase[blunts_whodl_who_downloaded]" border="1" title="$vbphrase[blunts_whodl_who_downloaded]: $attachment[attachmentid]" /></a>

Edit this part to use your own image file:
src="$stylevar[imgdir_attach]/blunts_whodl_vertical.bmp"

Another way would be to change the phrase which gets displayed to something shorter, which is in the same area of code, and then it will shrink to fit .... for IE only of course.

P.S. - I was assuming you meant the vertical button next to images. If the horizontal one is too long, it works the same way so find the similar code for each of the 4 templates we edit instead of just the thumbnails.

bashy

12-13-2005 10:11 AM

Hi

Ok thanks Mr Blunt, I will give this ago...

It is the normal Who Downloaded Button (horizontal) that needs shortening..

So let me get this right...all i need to do is shorten the phrase, if so how and where, sorry for sound like a thickett..

Just the word "who" would be great...

Regards

Bashy

Mr Blunt

12-13-2005 10:52 AM

Something like this:

Code:

        <if condition="is_browser('ie', '5.5')">

                <input type="button" class="button" value="who" tabindex="1" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]fid=$attachment[attachmentid]','blunts_whodownloaded_ip','toolbar=no, scrollbars=yes, resizable=yes, width=$show[blunts_whodl_width], height=450, top=50, left=50'); return false;" title="$vbphrase[blunts_whodl_who_downloaded]: $attachment[attachmentid]" style="writing-mode:tb-rl" />

        <else />

                <a href="blunts_whodownloaded_ip.php?$session[sessionurl]fid=$attachment[attachmentid]"<if condition="$show['newwindow']"> target="_blank"</if>><img class="button" src="$stylevar[imgdir_attach]/blunts_whodl_vertical.bmp" alt="$vbphrase[blunts_whodl_who_downloaded]" border="1" title="$vbphrase[blunts_whodl_who_downloaded]: $attachment[attachmentid]" /></a>

        </if>

See where I put the....
value="who"
Where this used to be:
value="$vbphrase[blunts_whodl_who_downloaded]"

bashy

12-13-2005 11:34 AM

Hi again...

Thanks for this, i have just changed it to what you said but its still showing Who Downloaded, I copied all your text and pasted over so there could not have been any mistakes!

Any ideas?

Sorry for the messing about :(

Bashy

mhammed

12-13-2005 01:53 PM

GREAT JOB

thanks

install and work 100%

Mr Blunt

12-13-2005 09:16 PM

Quote:

Originally Posted by bashy

The edit I gave only changes the button for thumbnails in Internet Explorer 5.5+.

Thumbnails in any other browser still use a real picture for the button because other browsers don't have ability to show a vertical html button, so you would have to design your own small button and edit code to insert your image's filename.

For the horizontal buttons, you still have to edit the other 3 templates.
You edit them the same way.
Find the button, change the value parameter.

bashy

12-13-2005 09:51 PM

Hi m8...

I think im gonna have to leave it as it is.... :o the more i look at it the more appealing it becomes lol.....All is working, so i think im gonna leave it this way :)

Thanks again for your time...

Regards

Bashy

Arios

12-14-2005 05:46 AM

All seems to work just fine except for when I go to post

Quote:

The following errors occurred when this message was submitted:

1. You did not specify a username for your post.

Any solution to this?

Bullethead21

12-17-2005 12:02 PM

Awsome!! Works VERY well! The only complaint I would have is having "Blunts Whodl" in my control panel....dont look right. Other than that, AWSOME!!

nanaimobar

02-14-2006 09:26 PM

Everything installed easily except when clicking on Quick Search Engine in Admin panel a 404 error occurs. I checked forum url in options panel, was ok, then changed url to main site to see if that made any difference. Didn't. Still get 404 error with main web site address for "Return to site". Database has no errors, and no errors reported by vbulletin.
Suggestions?

Mr Blunt

02-15-2006 09:50 PM

nanaimobar,

Sounds like you didn't upload all the files that came inside my "upload" folder to your server.

Or that you maybe didn't upload them all to the correct folders.

Or that you did upload them, but maybe your normal "admincp" is not named that, in which case you need to put the contents of that folder (the file named admin_blunts_whodl_ip.php) in whatever that renamed admin folder is.
.

nanaimobar

02-17-2006 10:27 PM

Hi Mr. Blunt,

I had renamed my admincp folder (I've fined myself 5 dollars for making such a simple mistake as not connecting the dots, so to speak) so I moved your file to the correct folder on my server and....
now I get an error code, which doesn't all paste into here for some reason, that begins with "SCU$" and follows with a dozen or more letters and squiggles that make no sense to me.

All other files are in their correct place as everything else appears in the admin section of vbulletin, and seems to work.

I shall spend this weekend fiddling about and see if I can get this too work and report back.

The Realist

03-02-2006 10:55 AM

Installed and working 100% on VB 3.5.4.

Nice hack indeed and glad I found it now.

Well done.

Replicators

03-07-2006 02:44 AM

Everything seems to installed 100% correctly as in no errors at all!!

But nothing works, i get all the options and stuff in the acp, i have it set to on, usergroups are set, but when i go to forum there is no "Who Downloaded" thing anywhere. I looked in the usercp and nothing. The template edits are there, but it seems the forum is ignoring this mod for some reason and i don't know why.

berayiwu5

03-12-2006 03:23 AM

Thanks for coming up with this hack. But for some reason, "Who Downloaded" doesn't appear beside attachments. Nor does it show up in the Attachments section in my User CP under "Date." I have vBulletin 3.5.4.

Your help is greatly appreciated.

Actually, I don't quite understand step 4 of the installation: "MERGE 'style_blunts_whodl_ip.xml' over your styles (ignore version)." I just imported it using Add/Import from the Product Manager. Does it have something to do with it?

Replicators

03-13-2006 06:23 AM

I just figured out my problem.

@berayiwu5
You probably have the plugin accelerator installed right? Well rebuild your plugins and it should work fine >8)

berayiwu5

03-13-2006 01:41 PM

Quote:

Originally Posted by Replicators

I just figured out my problem.

@berayiwu5
You probably have the plugin accelerator installed right? Well rebuild your plugins and it should work fine >8)

Thanks for your suggestion. No, I haven't installed the plugin accelerator. Is it safe? I can't afford to mess up the database. I only know how to follow instructions. I don't know anything about coding.

berayiwu5

03-15-2006 02:12 AM

OK. I finally got it working. It's an omission on my part. Thanks. Great hack.

MaLTRaiN

04-11-2006 02:57 PM

Excuse me... is this retroactive? Thanks..!!!

All times are GMT. The time now is 11:27 PM.

Page 3 of 4

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01441 seconds Memory Usage 1,864KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (12)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: