Encountered another odd little quark ...

We're running Subdreamer CMS with a fixed-width skin. Our vBulletin forum uses the same skin. The skin has navigation tabs at the top of the page. Mouse-over on some of the tabs exposes sub-categories.

http://www.canyoneering.net/forums

When I am in the main forums page, the mouse-over works fine. When I am in the ICash page, subcategories under the tabs labeled "Programs" and "Resources" overlap. Same behavior in Safari and Firefox.

Assuming this is some kind of table issue. Is it fixable?

It should be fixable, is it only producing that bug on the icash page? is it doing it on any other pages?

I've been checking it on every other page on the site and it is only happening on the ICash page.

I uploaded & overwrote all the files, but can't import the new product, I get a database error. I've tried overwriting and also uninstalling the old product/uploading fresh, but both result in the same database error. I have no idea how/where to access SQL or even exactly what to do once I get there...please help! :)

Okay, I have a previous version of this installed on another message board, but I was wondering what I need to enter to get the following to appear correctly.

It's basically the same thing you enter in your phrase for the postbit edit, but I want to do my own edits and can't find out what to enter.

I'm looking for the phrase for cash in hand. It used to be $post[money], now it appears to be $userinfo[$moneyfield]. However, when I put that in, the decimals do not show.

I'm trying to us it with vBookie by setting the money rows to 'vbookie_cash' as it says in the first post. Could this be causing the decimal problem?

Also, trying to work around that, I entered 0 for the amount of decimals to show and it showed the decimal but no numbers after it. Like, it would say '500.' instead of showing '500' as it should have.

hi i have a problem, when a mod or admin, or user self delete a posting, this error comes!

Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:

UPDATE bbuser AS user
SET user.money = user.money -
(
SELECT SUM(post.icash)
FROM bbpost AS post
WHERE post.postid = 233514 AND post.userid = user.userid
) WHERE user.userid = 3748;

MySQL-Fehler : 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 'SELECT SUM(post.icash)
FROM bbpost AS post
WHERE post
Fehler-Nr. : 1064
Datum : Monday, December 31st 2007 @ 01:28:21 PM
Skript : http://www.***************.net/inlin...postids=233514
Referrer : http://www.***************.net/inlin...eadid=15602&p=
IP-Adresse : ***************
Benutzername : ***************
Klassenname : vb_database

what can i do?

thanks!

First of all go into phpmyadmin and check to make sure an 'icash' row exists in the table post.

Is there a way you can put the ICash-Donate underneith the rep power on the post bit? Thanks.

Btw, this refers to our upgrade to 2.03. vb3.6 (running 3.6.8 forum).

We LOVE our IShop and can't live without it now! :( The donate items function no longer works since I can't import the new ICash product (I've even tried using the older versions). I've tripled checked all file uploads and everything I can think of, but just don't have the knowledge to fix this by myself. TIA for any help!:D

great mod. one question. is there any way to run a report or something like for points per user during a week, or month etc... I ask because my site currently has active posters, but there is no "contest" at the moment. but the current users are building points. if i start a contest a week from now that the most points for the month etc.., i wont be able to tell which points are old and which are new for the contest. hope that makes sense.

my contest would be something like most points in the month of february wins blah blah blah... is there a way i can say show me total points for this time period?

I donate points from the panel of administration and launch this error

Ignore this.

You cant have your money row set as 'money!'
Try 'money'

Sorry ive been gone, was on a week vacation :D

New version coming asap, sorry if you are getting importing errors, vbulletins fault IMO :D

Hope you had a great vacation! My members and I will be eagerly waiting for the new version, yippee! :D We are missing our fun IShop/ICash! Thanks so much, Blaine! :)

does this work on 3.6.4 ?

Can I translate it in the AdminCP?
I tried to translate, and I couldn't find the words and the sentences that I saw..

Forget it , I changed it to the money and It worked XD

Anyway , can I edit to make user get zero point when posting in no-post-count forum ?

Yep, edit that forum and set the icash options to 0

just repeating my previous question, will this work on 3.6.4 ?

yes

Blaine, any ideas how I might be able to get the original version of ICash to work again? I uninstalled everything and started fresh with v.1.12, which worked great for us before. Now we get an error page (page not found) after clicking on "donate" when we try to donate an IShop item to another member. The URL on the "page not found" looks like this:

http://www.mysite.com/icash.php?do=dodonateitem

TIA for any help or suggestions! :)

UPDATE:

Figured it out and we're up and running again, yay! In case it helps anyone else, I basically changed the name of the ishop.php file to icash.php and uploaded it to the public_html directory. It was obvious from the URL on the error page that there needed to be an icash.php file but there was none in the original version. Unless I'm going crazy, which is quite likely a possibility, too. :D Anyway, LOVE LOVE LOVE this hack, my members are going to throw a party to have our IShop back again!

So what was wrong with 2.0.1 again?

just an installation error?

Yes, I got this database error message whenever I tried adding the product either via Admincp or FTP upload:

Just want to say again how much my members and I LOVE our IShop and ICash systems! Thanks for such a fun forum diversion! :D

Btw, my users cash and mine keeps disappearing and going back to 0 even though we haven't bought anything or donated anything? Do you know how to solve this? thanks.

Lol diversion

as for the 0 bug, it happens when people delete posts, its being addressed.

which attachment should be downloaded for 3.6.4 ?

2.0.3

I get this error msg when I try to upload this plugin
Database error in vBulletin 3.6.4:

Invalid SQL:
ALTER TABLE user ADD COLUMN money decimal(15,2) DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'money'
Error Number : 1060
Date : Monday, January 21st 2008 @ 12:37:34 PM
Script : http://www.site.com/forum/admincp/pl...=productimport
Referrer : http://www.site.com/forum/admincp/pl...?do=productadd


Classname : vb_database

what should be done, I have downloaded 2.0.3 as you have mentioned

bump for error !!!

Blain I encountered a weird problem.
I upgrade from version 2.01 if I'm correct to version 2.0.3-vb3.6 because I'm running vbulletin 3.6.8.

The upgrade went fine. First I enabled the automatic template adjustment, but then disabled it again, because I already had done it before manually and the money-amount appeared a bit higher when using the automatic one. And I like the money amount and bank amount coupled. No problem there either.

But I did not pay attention very well after upgrading because we use this for fun. However a user of mine now noticed that every user lost his amount of money after they upgrade!
Only the money stored in the Ibank was kept, but the normal amount of money was gone.

I myself had for example over 300 money, and now I got 40 again due to reply's I made.
How could it be that the amount of money was reset during the update?

Did you uninstall before you upgraded?

No I just did what I always do. Upload the files, then go to the ACP, select the product, set overwrite to "yes" and then import the product.

But no one has deleted any posts, everyones cash just keeps going back to zero.

Hello

Im running VB 3.6.8 PL2

I was running iCash 1.1.2

Ive upgraded to ICash2.0.3-vb3.6 by doing the following:
- removed template edits entered for iCash 1.1.2
- Uploaded files
- Import ICash2.0.3-vb3.6 and set to overwrite (Ive done this twice)

All seems to be ok but iCash isnt displayed in Postbit (Ive tried enabling/disabling iCash and the auto template options)

Any ideas?

Thanks :up:

VinylJunky

PS I added the Postbit stuff back in, it displays text but no amounts

All my members' money were deleted. Thousands of them.

What is going on?! I am using the latest version, 2.0.3. This can't happen, developer please investigate and let us know when it is fixed.

Also, I have another question. What is the difference between 1.1.2 and 2.0.3? Is it just feature adds, or a huge security fix? I'd like to 'downgrade' until the whole cash being deleted bug is fixed.

Okay, I figured out what causes the loss of money.

If a mod or admin deletes a thread, EVERYONE's money will be completely deleted.

Oowzzz.... so that's what caused the problem. It should only take little bit of the money the users earned by writing in the thread.
Hopefully Blain can fix this fast, because this is a real pain.
Great job finding it Ipxxfaintxx!

Found another bug and also something I don't know sure if it's a bug or not.
Bug:
In the ACP when enabeling the "apply postbit edit" in the users postbit also a "donate" link appears. But when setting the "Can send money" to "no", all users still see the donate link and are able to donate money.
Same problem with the "apply navbar edit" feature.
Can this be made so when the setting "can send money" is set to "no", there is no donate link visible for this usergroup?
If that's too difficult, it would be nice to make the "donate" link a seperate on/off switch in Icash.

The second thing I see is the "Apply MemberInfo Edit?". I've set this to "yes" but does it do anything? I checked the memberinfo, but I'm not seeing anything about Icash or I'm not looking very well (yeah it's late over here). Could you point me to what is changed if this setting is set to yes?

It works on my setup. In the members public profile under User Notes, it displays how much cash they have and there is a "Donate to this member" link.

My problem is that iCash isnt displayed in Postbit (Ive tried enabling/disabling iCash and the auto template options). My members are complaining :confused:

Does it display for you?

Cheers

VinylJunky