vb.org Archive - uCash & uShop old support and thank you thread

thanks.

i wish i could figure out why i can't use the ' character. it gives me a 1064 sql error whenever an action is executed that has a ' in the post or thread or username...

Quote:

Originally Posted by Link14716

EDIT: Didn't read the first part of your post.

The first one is correct. It needs the comma.

Link14716

11-03-2004 10:50 PM

Quote:

Originally Posted by bi11i

thanks.

i wish i could figure out why i can't use the ' character. it gives me a 1064 sql error whenever an action is executed that has a ' in the post or thread or username...

Post the MySQL errors and where you got them. They should have been fixed a long time ago (before the official 0.93 release, actually).

bi11i

11-03-2004 11:36 PM

Quote:

Originally Posted by Link14716

Post the MySQL errors and where you got them. They should have been fixed a long time ago (before the official 0.93 release, actually).

Code:

Database error in vBulletin 3.0.3:



Invalid SQL: INSERT INTO utt_store_history

                                         (historyid, userid, timestamp, actionid, action, normalcost, discount, tax, totalcost, touserid, touser, points, newtitle)

                                         VALUES

                                         (NULL, '10', '1099519682', '17', 'Deny&nbsp;Forum&nbsp;Access', '5000', '2', '15', '5635', '4', 'Wolfman', '0', 'Al Gore's Top 10 Links')

                                         

mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Top 10 Links')' at line 4



mysql error number: 1064

it's because of the ' character in the name of one of my forums. a user tried to deny another user access to a forum that had a ' in the name....

Link14716

11-03-2004 11:41 PM

Is that the only place a ' error occurs?

Either way, fix it by changing this (in uttstore/action.denyforumaccess.php):

PHP Code:


		
			
    uttstore_add_history($action['actionid'], $action['cost'], $userdiscount, $action['tax'], $totalcost, $_REQUEST['userid'], '0', $forum['title']);

To this:

PHP Code:


		
			
    uttstore_add_history($action['actionid'], $action['cost'], $userdiscount, $action['tax'], $totalcost, $_REQUEST['userid'], '0', addslashes($forum['title']));

EDIT: Fixed all instances of this locally. The fixes will be in the next release.

bigM	11-03-2004 11:44 PM

I have successfully installed your hack. But there is one problem. If somebody wants to do any action, he will get this error:

Quote:

User does not exist.

What should I do? Can somebody tell me, what's wrong?

vB: 3.0.3

bi11i

11-03-2004 11:46 PM

yes, the only place, actually.

thanks, i'll check out the fix!

Quote:

Originally Posted by Link14716

Is that the only place a ' error occurs?

Either way, fix it by changing this (in uttstore/action.denyforumaccess.php):

PHP Code:


		
			
    uttstore_add_history($action['actionid'], $action['cost'], $userdiscount, $action['tax'], $totalcost, $_REQUEST['userid'], '0', $forum['title']);

To this:

PHP Code:


		
			
    uttstore_add_history($action['actionid'], $action['cost'], $userdiscount, $action['tax'], $totalcost, $_REQUEST['userid'], '0', addslashes($forum['title']));

EDIT: Fixed all instances of this locally. The fixes will be in the next release.

Link14716

11-03-2004 11:47 PM

Quote:

Originally Posted by bigM

I have successfully installed your hack. But there is one problem. If somebody wants to do any action, he will get this error:

What should I do? Can somebody tell me, what's wrong?

vB: 3.0.3

That error can only occur in places where you are doing something relating to another user (donate, change other user's title) and means exactly what it says: the username specified does not exist.

bigM	11-04-2004 12:05 AM

Yes, that's right. I get this error everytime, when I want to use the action "Donate". The username(s) are correct. So what's wrong?

Link14716

11-04-2004 12:32 AM

If the usernames are correct, it should work fine.

bigM	11-04-2004 12:51 AM

No, it doesn't. I can give you a test account to my forum and then you can test it by yourself, okay?

All times are GMT. The time now is 05:21 AM.

Page 206 of 232

206

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

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