vb.org Archive - Signatures Gallery Hack

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Signatures Gallery Hack (https://vborg.vbsupport.ru/showthread.php?t=66086)

Signatures Gallery Hack

hello everyone :rolleyes:

hack name: Signatures Gallery Hack
vB version: 3.0.1

How the hack works:
It works like a signatures gallery

Features:
1) You can see all signatures instead of going through every member profile to see his signature. So without this hack, if you want to see all signatures then you need to spend hundreds of years, while with this hack you can see them in one page.

2) Members can vote for any signature they like, and number of votes will be beside every signature.

3) You can specify number of signatures that'll be displayed in the page.

4) You have the choice to display the image in the signature, or to be as an address only.

5) You can allow/disallow visitors to vote.

6)You can allow visitors to vote as many as you specify.

7) Detect other features ;)

Note!: all vbcode codes will be enabled automatically.
Except php: code: qute:
since it may distort the page.

if you use this hack don't forgot click https://vborg.vbsupport.ru/

screen on admin >>
Signatures Gallery setting

Cool idea.... Although would not be used on my site, still nice.

Nice Hack, but it doesnt work on my test german board.
I doesnt see any signatures an I get

PHP Code:


		
			
Warning: Division by zero in d:\apache group1\apache\htdocs\upload\includes\functions.php on line 1707

In my functions.php on line 1707 is this:

PHP Code:


		
			
$totalpages = ceil($results / $perpage);

There are some problems with this hack...

First, the page navigation is screwy. Also, why is eregi_replace being used instead of the (faster) preg functions? In fact, why not just use vB's bbcode parser... much easier that way.

There are some security and performance issues, too. Like, this:

PHP Code:


		
			
$query =$DB_site->query("SELECT * FROM " . TABLE_PREFIX . "user");
  if($DB_site->num_rows($query) > 0)
  {
   $do = '1';
  }

Doing this loads up the enite userbase into memory... not nice. Try this instead:

PHP Code:


		
			
$query    = $DB_site->query_first('SELECT count(*) AS count FROM ' . TABLE_PREFIX . 'user');
  
  if($query['count'] > 0) {
      $do = '1';
  }

Of course this doesn't address why this is necessary in the first place, since this query will ALWAYS set $do to 1, since there is always at least one user in the database. Best to just remove that altogether, imo.

There is also this:

PHP Code:


		
			
 $query =$DB_site->query("SELECT sigrate FROM " . TABLE_PREFIX . "user");
   while($r =$DB_site->fetch_array($query))
   {
    $sign = $r[sigrate];
   }
   $nvote = $sign.' '.Addslashes($v);

Which is just as inefficient as the above query and I can't for the life of me figure out what it is trying to do, maybe I'm just missing it....

Finally,

PHP Code:


		
			
$query =$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET sigrate=sigrate+1 where userid='$v'");

Really needs to be

PHP Code:


		
			
 $query =$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET sigrate=sigrate+1 where userid='" . intval($v) . "'");

for obvious reasons. I just spent the last half hour fixing this stuff so I thought you might want to incorporate the changes. ;)

Cool idea, though. :)

Cool idea, I'll definatley use this on my site.

insanctus & RasMasta
thank you

shelaby
use this link:
sig.php?&page=1&pp=2

cirisme
thank you for tell me
thank you for tell me
and you tell alright.

you can see i use query_first
but in the code i take this in other my program and i do that in fast.
AND
$nvote = $sign.' '.Addslashes($v);
because i got idea to show how
rate this user.

to reply in english i want 1 hour :ermm: ,sorry for my english

Thank you for you help.
But now a have others problems. If I click vote the php load "sig.php" and not "sig.php?&page=1&pp=2".
I doesnt see the navbar, but in the template sigrate is the navbar loading, but i didnt see her.
And how I could all votings set of siro, that the users can vote new.

Sorry for my terrible engisch :nervous:
VLG Shelaby

having a few problems with the template it's well see for yourself here.

I have been messing but not sure why it's doing that. Also i'm getting the following error when I go to mysite.com/forum/sig.php
Division by zero in /home/forums/includes/functions.php on line 1707

B

X vBulletin 3.8.12 by vBS Debug 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_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01107 seconds Memory Usage 1,755KB 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_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (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
Messages: