vb.org Archive - [Re-release v2.2.0] Combined threads started + percent of total posts, plus more

Page 2 of 3

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

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - [Re-release v2.2.0] Combined threads started + percent of total posts, plus more (https://vborg.vbsupport.ru/showthread.php?t=32147)

JJR512

11-18-2001 12:07 PM

Thank you, I've updated the instruction file.

over	11-18-2001 12:49 PM

nice hack :) very easy to install what else could we ask for :D

Brian Cruz

11-18-2001 07:43 PM

I had a problem when I installed this hack. Whenever I tried to look at the profile of a member with an apostrophe in thier name, I would get an e-mail similar to this:

Quote:

vBulletin (forum) Database error!

Database error in vBulletin 2.2.1:

Invalid SQL: SELECT COUNT(title) AS starts FROM thread WHERE postusername='Batman's bride' AND open!='10'
mysql error: You have an error in your SQL syntax near 's bride' AND open!='10'' at line 1

mysql error number: 1064

Date: Sunday 18th of November 2001 11:43:33 AM
Script: http://forums.toonzone.net/member.ph...nfo&userid=669
Referer:

In this case I tried to view the profile of a member named Batman's bride. I had to take the hack out for now. Can this be fixed?

SgtSling

11-19-2001 02:43 AM

i am having the same problem with users with ' in ther name

JJR512

11-19-2001 05:38 AM

As I said earlier, you'd have to ask the person that wrote that part of the hack. I believe that part of the code is from the hack by Tubedogg that counts how many threads a person has started. I would suggest finding that thread and asking in there.

Joshua Clinard

03-08-2002 09:31 PM

I get a parse error on line 1155 in member.php when I click on a profile.

JJR512

03-08-2002 10:20 PM

What is line 1155 in your member.php?

Wayne Luke

03-09-2002 02:45 AM

Find the part where in that query where it says:

Code:

postusername='$userinfo[username]'

and change it to:

Code:

postusername='". addslashes($userinfo[username]) ."'

JJR512

03-09-2002 02:57 AM

Thanks, I've updated the attachment. BTW, YGPM.

TheLink

07-31-2003 11:01 PM

Does Wayne's change fix the errors everyone was receiving?

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

Page 2 of 3

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01521 seconds Memory Usage 1,728KB 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 (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)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: