uCash & uShop old support and thank you thread

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

[Zachery]

Originally Posted by kall

A few of my members have asked for a way to display their points total in the navbar.

This is probaly very easy, but sticking $points in the Welocme/PM area doesn't seem to work.

you should be able to use $bbuserinfo[points] I THINK

[Zoints]

Originally Posted by Mhaddy

I believe I found a small bug in action.denyforumaccess.php.

Around line 35 there is the line:

PHP Code:

if ($accessable['accessmask'] == '0') { 


This should be:

PHP Code:

if ($accessable[accessmask] == '0') { 


I found this out when I consistently received the "this forum is already un-accessable" error when trying to deny access to a forum for a user through the shop. I noticed another member in the thread (I forget his name) asked the same question, but AFAIK, was never answered. Now I can deny access to forums to all the users I want . Hope this helps someone.

I was so excited as I have been having this same problem. But when I made the changes you specified, I still have the same issue. Did you maybe fix any other issues with it?

[LoOnEyToOnZ]

Is it possible to change the name "points" to "cash" ? make it read as "cash" throughout the site

[SkyCatcher]

Hi Guys,

A couple of my users (not very many at all) are having problems accessing the bank for some reason.

This is the email I get:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET uttpoints=uttpoints-75,70 WHERE userid='186'
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 '70 WHERE userid='186'' at line 1

mysql error number: 1064

Date: Monday 14th of June 2004 07:38:07 AM
Script: http://www.probetreff.com/forum/usho...shortname=bank



It works for 99% of the people but for some reason they get an error...they are using internet explorer and 1 user is betting this error on 4 different computers


Any Ideas?

[SkyCatcher]

Originally Posted by SkyCatcher

Hi Guys,

A couple of my users (not very many at all) are having problems accessing the bank for some reason.

This is the email I get:

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET uttpoints=uttpoints-75,70 WHERE userid='186'
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 '70 WHERE userid='186'' at line 1

mysql error number: 1064

Date: Monday 14th of June 2004 07:38:07 AM
Script: http://www.probetreff.com/forum/usho...shortname=bank



It works for 99% of the people but for some reason they get an error...they are using internet explorer and 1 user is betting this error on 4 different computers


Any Ideas?

Ok I solved the problem, not 100% sure why though.

The users couldn't access the bank so I deleted what was in the bank_query in my phpmyadmin and they got access...

Then I noticed that some users used a , (comma) instead of a . (period) for decimal places and that somehow screwed up they're points.

[Intex]

Originally Posted by Zachery

Make sure you did your file edits to functions.php

Zachery - I've just checked the functions.php and the code is there. Funny thing is in AdminCP | Usergroups, when you can add HTML start and end tags, putting anything in there such as <i> and </i> doesn't do anything either. This is clearly related.

Any further ideas?

[Flow Fusion]

Ok How do I edit the postbit file to show the colors/ italics etc? Cause they are no longer working?

[IIstix]

Did you run the standalone or HTL installer?
Standalone

What is the exact error you recieve?
Warning: Invalid argument supplied for foreach() in /... (vb3 root path) .../global.php on line 701

Unable to add cookies, header already sent.
File: /... (vb3 root path) .../global.php
Line: 701

Where does the supposed error happen?
When trying to run ushop_install.php


What vB version are you running?
3.0.1

I hit the BACK button on my browser, which reloaded the ushop_install.php script and I got the install page!?! I went ahead and installed the script and I got no error messages.

Why would it work upon reloading ushop_install.php, even though I did not make any changes like removing the second global.php edit and running the ushop rebuild script?

[Albus]

I installed it and it seems to be working great. I did get the array error and the no points thing, but I fixed it with the initial instructions. Now, what I was wondering is, if I decide at some point to uninstall this, what tables were altered, and what fields were added to them.

The following are obvious :
Restore all files and style templates that were edited
Delete all files and style templates that were added
Delete all phrases that were added
Delete all tables that were added

Now, what I need to know is, which existing table were altered and what fields were added to them? Is there anything else?

NOTE: I did backup the DB and files prior to this, however, IF I have to do this, I don't want o have to backtrack if possible.

[Albus]

Ok, I was looking through the install script and found this section.

if ($_REQUEST['do'] == 'uninstall')

I assume if I was to do this, I'd still have to revert my basic templates.

Has this uninstall code been tested?