vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - vBSigHosting v1.0.1 (https://vborg.vbsupport.ru/showthread.php?t=63841)

xug 08-15-2004 09:05 PM

Quote:

Originally Posted by ChuanSE
Your signature script sucks? it displays info we know ^^
kiddo :p

You're One Smart Kid :D

But your right, it sucks, time to place a new one since this one is more than a year old.

xug 08-15-2004 09:10 PM

Quote:

Originally Posted by Live Wire
No, if members want my free hack and my support for a feature that i spent my time on. they can go to my site there selfs. They know where it is and they know how to get it. Clicking on the uninstall button won't hurt my feelings as this thread is pending to me moved to the can.

Live Wire.

My statement was nothing personal (in fact I think your hacks are great), I'm just tired of all these sites that have hacks that let us sign up and a month later they are gone, we have seen enough of that already in the past.

Logikos 10-03-2004 07:38 PM

vBSigHosting is back and has been updated with a small bug fix. New .Zip added and .txt file for upgrade instructions from 1.0.0 to 1.0.1

Next update will be to view the users sigs. The ammount of space it's using in the database, save files a .gif image, and watermark images for images outside of your site.

InsaneContender 10-04-2004 08:25 PM

I get this error message:

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        title = 'Administrators',
        description = '',
        usertitle = 'Administrator',
        opentag = '<i><b>',
        closetag = '</b></i>',
        passwordexpires = '0',
        passwordhistory = '0',
        siguploader = '1',
        siguploadermaxwidth = '500',
        siguploadermaxheight = '150',
        siguploadermaxsize = '524288000',
        arcademinposts = '0',
        arcademintime = '0',
        attachlimit = '0',
        avatarmaxwidth = '100',
        avatarmaxheight = '100',
        avatarmaxsize = '50000',
        profilepicmaxwidth = '100',
        profilepicmaxheight = '100',
        profilepicmaxsize = '65535',
        pmquota = '100',
        pmsendmax = '5',
        forumpermissions = '393215',
        pmpermissions = '3',
        calendarpermissions = '31',
        wolpermissions = '31',
        adminpermissions = '3',
        genericpermissions = '3145663',
        genericoptions = '23',
        arcadepermissions = '31',
        articlepermissions = '4095'
WHERE usergroupid=6
mysql error: Unknown column 'siguploader' in 'field list'

mysql error number: 1054

Date: Monday 04th of October 2004 02:16:55 PM
Script: http://www.communityforums.net/forum.../usergroup.php
Referer:

I followed directions perfectly as well...

Logikos 10-04-2004 08:28 PM

You forgot to run the SQL queries as instructed.

These are the ones you need to run:

[sql]
create table customsiguploader
( userid int unsigned not null default 0
, siguploaderdata mediumtext not null
, dateline int unsigned not null default 0
, filename varchar(100) not null default ''
, visible smallint not null default 1
, filesize int unsigned not null default 0
, primary key (userid)
)
[/sql]

And

[sql]
ALTER TABLE usergroup ADD (
siguploadermaxwidth SMALLINT UNSIGNED NOT NULL DEFAULT '0',
siguploadermaxheight SMALLINT UNSIGNED NOT NULL DEFAULT '0',
siguploadermaxsize INT UNSIGNED NOT NULL DEFAULT '0',
siguploaderpermissions INT(10) UNSIGNED NOT NULL DEFAULT '0'
)
[/sql]

Blam Forumz 10-04-2004 08:45 PM

Installed :p

Erwin 10-05-2004 01:15 AM

Are you able to make it so that the files are not in the database but in the filesystem? :)

Logikos 10-05-2004 02:13 AM

Quote:

Originally Posted by Erwin
Are you able to make it so that the files are not in the database but in the filesystem? :)

I'm trying to figure out an easy way to do that, but the way i was trying still kept the image in the database. I was just going to use $_SERVER['REQUEST_URI'] to get the full request URI including the userid Then in .htaccess you make the no-extention file sigs be a php file:

<Files sigs>
ForceType application/x-httpd-php
</Files>

And everyone sigs will point to, www.yoursite.com/forums/sigs/1

1 being the userid.

I you can figure out how we can do it to upload to a specific directory that would be great, cause i know you have a huge site, and you need to access the database as less as possilbly.

Deimos 10-05-2004 08:25 AM

I think it's a great hack, keep up the good work Livewire.

Gemma 10-26-2004 09:49 PM

Great Hack *clicks install*

parajsa 10-31-2004 03:07 PM

Is there a way not to show the link Upload Signature to the Control Panel of the users which are not on the permited usergroup? Mean the ones, that this feature is turned off.

To make it more clear, what <if condition="?"></if> should i use to this template code, that is put on the USER_SHELL template:

Code:

<tr>
      <td class="$navclass[signature]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editsiguploader">$vbphrase[upload_signature]</a></td>
</tr>

Best regards, and it is a very wonderfull hack,

ntloc 10-31-2004 11:52 PM

dont know why, i just updated but i still get this error:

Fatal error: Call to undefined function: remote_filesize() in /home/username/public_html/forums/includes/functions_upload.php on line 110

Any idea, please help. Thanks.

ntloc 10-31-2004 11:56 PM

one more thing is that it's working with the upload sig from comp location, it only gives me that errror if i enter the url to the image instead of uploading from my computer.

Logikos 11-01-2004 05:41 AM

Very strang ntloc, this must be due to another hack you have installed as the only function i mod with this hack is the process_image_upload() function not the remote_filesize().

As in my instructions:
In includes/functions_upload.php find:
PHP Code:

                // profile pic
                
case 'profilepic':
                        
$checkperm CANPROFILEPIC;
                        break; 

Under Add:
PHP Code:

                case 'siguploader':
                        
$checkperm CANSIGUPLOADER;
                        break; 


animeonline 11-01-2004 01:03 PM

Hi :)
First off I would like to thank Livewire for what seems like it will be a great and usefull hack. Your work is very appreciated.

With that said, I am seem to be having a slight issue. After installing the hack properly as well as setting up my permissions, it seems that no signatures (or avatars, for that matter) are showing up once uploaded. I don't get an error or anything, there is simply nothing there.

If I could get some assistance on this matter that would be great. Thank you very much for your time :)

P.S. Running the latest VB as well as the latest version of VBsighost.

ntloc 11-01-2004 02:26 PM

Quote:

Originally Posted by Live Wire
Very strang ntloc, this must be due to another hack you have installed as the only function i mod with this hack is the process_image_upload() function not the remote_filesize().

As in my instructions:
In includes/functions_upload.php find:
PHP Code:

                // profile pic
                
case 'profilepic':
                        
$checkperm CANPROFILEPIC;
                        break; 

Under Add:
PHP Code:

                case 'siguploader':
                        
$checkperm CANSIGUPLOADER;
                        break; 


Well, i hve that in there and i double check it lots of times. It's working fine when i was using vb3 gold but from since i upgrade to vb3.0.3, the url upload sig is not working propertly anymore and it was working fine with other hack on vb3.0.0 gold.

ntloc 11-01-2004 02:26 PM

right now i'm using vb3.0.3 by the way

animeonline 11-01-2004 04:14 PM

Never mind my last post, I got it :D Thanks

parajsa 11-06-2004 01:48 AM

Live Wire, any solution about what i asked?

Thank u for ur help.

csrs 11-07-2004 12:46 AM

I can not get mine to work at all. I have checked all the code and instructions and all is set accordingly. When one tries to add a sig, it just refreshes? I have 3.0.3
Any help would be appreciated

Andrew 11-07-2004 02:28 AM

I have this running perfectly on my majorly hacked 3.0.3 so I don't think it's a problem with the version. Might be a conflict with another hack you are using or could be a file edit somewhere.

Anyways - Great hack Live Wire !! My members love being able to host their sig images now !!

/me clicks install.

Logikos 11-07-2004 03:16 AM

Thanks, i have an update coming soon, and this will be included with an installer. The newest update will have the following.

-View Users Sig in ACP
-Option to upload to database, or web directory
-Edit users sigs in ACP
-And maybe some more ;)

csrs 11-07-2004 03:21 AM

Quote:

Originally Posted by True.Rooster
I have this running perfectly on my majorly hacked 3.0.3 so I don't think it's a problem with the version. Might be a conflict with another hack you are using or could be a file edit somewhere.

Anyways - Great hack Live Wire !! My members love being able to host their sig images now !!

[high]* True.Rooster clicks install.[/high]

The only other hacks I have installed is the arcade mod. As for the file edit somewhere , I have went over everything many many times and everything is where it should be. I would really love to get this hack installed as our users would love it :D

csrs 11-07-2004 03:35 AM

I have noticed that in the instructions where it says
PHP Code:

Still in: /admincp/usergroup.php Find (around line 221): 

it says find
PHP Code:

print_input_row($vbphrase['profile_picture_max_filesize'] . '<br /><span class="smallfont">1KB = 1024 bytes</span>''usergroup[profilepicmaxsize]'$usergroup['profilepicmaxsize']); 

However, mine says
PHP Code:

 print_input_row($vbphrase['profile_picture_max_filesize'] . '<br /><span class="smallfont">1KB = 1024 bytes</span>''usergroup[profilepicmaxsize]'$usergroup['profilepicmaxsize'], 120); 

Not sure if this would make any difference?

csrs 11-07-2004 04:15 AM

OK ,It's working now , however, only if its a new member. None of the existing members can upload ? Sorry if I have over looked a fix for this?

Andrew 11-07-2004 04:52 PM

Quote:

Originally Posted by csrs
I have noticed that in the instructions where it says
PHP Code:

Still in: /admincp/usergroup.php Find (around line 221): 

it says find
PHP Code:

print_input_row($vbphrase['profile_picture_max_filesize'] . '<br /><span class="smallfont">1KB = 1024 bytes</span>''usergroup[profilepicmaxsize]'$usergroup['profilepicmaxsize']); 

However, mine says
PHP Code:

 print_input_row($vbphrase['profile_picture_max_filesize'] . '<br /><span class="smallfont">1KB = 1024 bytes</span>''usergroup[profilepicmaxsize]'$usergroup['profilepicmaxsize'], 120); 

Not sure if this would make any difference?

Yeah - That's where his notation of the approximate line number came in handy. When I installed it some of the lines of code were different - Odds are they were just changes in the versions. I don't remember any of them being too different from what was written to find - It just took a little extra work to find the lines.

csrs 11-07-2004 11:18 PM

Quote:

Originally Posted by csrs
OK ,It's working now , however, only if its a new member. None of the existing members can upload ? Sorry if I have over looked a fix for this?

So is there a fix for this?

M1th 11-08-2004 03:50 PM

Quote:

Originally Posted by Live Wire
Thanks, i have an update coming soon, and this will be included with an installer. The newest update will have the following.

-View Users Sig in ACP
-Option to upload to database, or web directory
-Edit users sigs in ACP
-And maybe some more ;)

That'd rock! I really dont have the time to implement those myself so I was waiting for someone else to come up with it. :P Thanks

csrs 11-08-2004 10:34 PM

Does anyone know if there is a fix for this ?

Logikos 11-09-2004 05:03 AM

csrs, what other hacks do you have installed at the moment? I have just added my hack to a clean vb install and all old members and new members are able to use this.

csrs 11-09-2004 04:03 PM

Quote:

csrs, what other hacks do you have installed at the moment?
The only other hack I have installed is the arcade mod.

Logikos 11-10-2004 04:03 AM

I'm not to sure then, i personaly would try to reinstall the hack, or at least take your time and go over every bit of code that you need to install from my install.html file. And make sure you save the usergroups. Go to the register usergroup and just set the settings and click save.

Tru Smiles 11-12-2004 06:09 PM

I tried installing this program, but couldn't get it working. So I uninstalled it, and everything was fine. Till I tried to edit a usergroup, and I got this error message:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Guest',
description = '',
usertitle = 'Guest',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '0',
forumpermissions = '4103',
pmpermissions = '0',
calendarpermissions = '0',
wolpermissions = '1',
adminpermissions = '0',
genericpermissions = '1',
genericoptions = '8',
journalpermissions = '0',
siguploaderpermissions = '0',
arcadepermissions = '0'
WHERE usergroupid=1
mysql error: Unknown column 'siguploaderpermissions' in 'field list'

mysql error number: 1054

^ Now, I have tried re-installing my forum without the hack ever touching it, but I still get that error. I'm posting it here because of the 'siguploader' thing that I uninstalled. Any idea what could be causing it, so I can go fix the problem? >_>

Thankie!

Logikos 11-12-2004 06:29 PM

You haven't fully uninstalled then, you need to unedit anything in the admincp/usergroup.php that i have had you add. Thats why i tell everyone to backup. Backup the files your going to edit, then install the hack, if the hack don't work, then upload the old files that you backed up and your finished.

Don't know why this isn't working for you, i've installed this hack countless amount of times on friends, and customers websites, and never once had a problem, and i've followed my own instructions.

Sweet Evil 11-14-2004 07:19 AM

In the users CP the upload link is not using my forums style.. and its ugly.. Where is this code so I can fix it? Thanks!

Tru Smiles 11-14-2004 09:04 AM

Quote:

Originally Posted by Live Wire
You haven't fully uninstalled then, you need to unedit anything in the admincp/usergroup.php that i have had you add. Thats why i tell everyone to backup. Backup the files your going to edit, then install the hack, if the hack don't work, then upload the old files that you backed up and your finished.

Don't know why this isn't working for you, i've installed this hack countless amount of times on friends, and customers websites, and never once had a problem, and i've followed my own instructions.


Thats the thing, I ALWAYS make back ups, and even when uploading them again, I still get this strange My SQL error. I even reinstalled a fresh forum and wiped the database, yet I still got this error. It's mighty strange o_O

Andrew 11-14-2004 02:33 PM

Quote:

Originally Posted by Tru Smiles
Quote:

siguploaderpermissions = '0',
arcadepermissions = '0'
WHERE usergroupid=1
mysql error: Unknown column 'siguploaderpermissions' in 'field list'
Thats the thing, I ALWAYS make back ups, and even when uploading them again, I still get this strange My SQL error. I even reinstalled a fresh forum and wiped the database, yet I still got this error. It's mighty strange o_O

If thats what you get after installing on a clean database then the database isn't really empty. If you look at what I bolded it still shows the column 'siguploaderpermissions' in the database. Might want to use phpMyAdmin and drop the tables manually to be sure they are completely gone.

Logikos 11-14-2004 03:29 PM

True.Rooster is almost correct. The reason why your getting that error is because you still have code in the usergroup.php file. When you try to save any usergroup, its trying to save the siguploader permissions cause there still code in the usergroup.php file. If you go into phpmyadmin, your not going to find that feild cause it don't exisit.

In usergroup.php Find and Remove:
PHP Code:

'siguploader' => 

Then Find and remove:
PHP Code:

'siguploadermaxwidth' => 500'siguploadermaxheight' => 125'siguploadermaxsize' => 25000 

Then find and remove:
PHP Code:

                print_table_header($vbphrase['signature_uploading_permissions']);
                
print_yes_no_row($vbphrase['can_upload_signature'], 'usergroup[siguploader]'$ug_bitfield['siguploader']);
                
print_input_row($vbphrase['upload_signature_max_width'], 'usergroup[siguploadermaxwidth]'$usergroup['siguploadermaxwidth']);
                
print_input_row($vbphrase['upload_signature_max_height'], 'usergroup[siguploadermaxheight]'$usergroup['siguploadermaxheight']);
                
print_input_row($vbphrase['upload_signature_max_filesize'] . '<br /><span class="smallfont">1KB = 1024 bytes</span>''usergroup[siguploadermaxsize]'$usergroup['siguploadermaxsize']);
                
print_table_break(); 

Thats all the code that belongs in usergroup.php to make my hack work. So get rid of it all and it will be fine.

Sweet Evil 11-14-2004 05:16 PM

Quote:

Originally Posted by Sweet Evil
In the users CP the upload link is not using my forums style.. and its ugly.. Where is this code so I can fix it? Thanks!

Well I changed
PHP Code:

<td class="$navclass[uploadsig]

to
PHP Code:

<td class="$navclass[signature]

and seems ok now, hopefully this does no effect anything else. :)

indie 11-16-2004 08:26 PM

Hi:
this looks great!
This thread is huge so please excuse my questions if redundant...

1) Can I pick a certain usergroup that can use this?
2) If i have IMG tags disabled for members in signatures, will it affect this mod? because I'd like to keep that setting off, so only usergroups with this mod can use images (banners)...
3) When is the update mentioned coming

thanks!


All times are GMT. The time now is 08:14 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02708 seconds
  • Memory Usage 1,880KB
  • 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
  • (2)bbcode_code_printable
  • (15)bbcode_php_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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