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)

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 10: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.01387 seconds
  • Memory Usage 1,760KB
  • 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
  • (5)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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