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*


All times are GMT. The time now is 09:57 AM.

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.01226 seconds
  • Memory Usage 1,745KB
  • 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
  • (1)bbcode_code_printable
  • (3)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