uCash & uShop old support and thank you thread

/me Installs. I'm the first for the most aniticipated hack!!1

[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...

Originally Posted by Link14716

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

The first one is correct. It needs the comma.

[Link14716]

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]

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).

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 Forum 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]

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]

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

User does not exist.

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

vB: 3.0.3

[bi11i]

yes, the only place, actually.

thanks, i'll check out the fix!

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]

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]

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]

If the usernames are correct, it should work fine.

[bigM]

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