If you have phpmyadmin, you can go into the user table and change the row that says 'money'

You will see integer(15,2)

just remove the ,2 part and your good to go :)

I tried that and it still seems to be showing up. :confused: Weird.

if you changed it properly i have no clue o.o

are you using the 'money' row?

I'm not too clear on what you mean by "money row". Could you possibly show me step by step (or as close to possible) as you can about how to go about changing it?

I'm confused as to what the phpmyadmin thing is. Sorry.

So did you change integer(15,2) to integer(15)???

Yes I did. In the admin panel where I go to manage products and also in the install xml file.

yea thats not gunna do anything, your going to need to edit the user table in your database.

sweet mod - any eta on the new release that works with the new vrsion of vb?

Working on debugging and adding requested features.

How do i integrate iCash with IBProArcade?

Updated.

Database error in vBulletin 3.6.7:

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 : Saturday, July 14th 2007 @ 08:11:49 PM
Script : http://www.run3h4x.net/forum/admincp...=productimport
Referrer : http://www.run3h4x.net/forum/admincp...?do=productadd
IP Address :
Username :
Classname : vb_database


I'm getting that error. can someone help me fix it?

Hmm, it seems to not have uninstalled correctly. Do you want to save the points you have in the previous installation of icash?

if thats easy then yeah i just want the easiest way to get it working.

how i update without lose yhe money of the users in my forum???

@ikuro just reimport the XML file and reupload all files..

@whitevans, run the following queries, it will delete everything and start over.

THEN install the XML, (redownload though)

What's the new update?

Please say it sends a PM -_-

Error

SQL query:

ALTER TABLE " . TABLE_PREFIX . "post DROP COLUMN `icash` ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN `icash_prethread` ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN `icash_perreply` ALTER TABLE " . TABLE_PREFIX . "forum DROP COLUMN `icash_perchar` ALTER TABLE " . TABLE_PREFIX . "user DROP COLUMN `money`

MySQL said: Documentation
#1064 - 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 '" . TABLE_PREFIX . "post DROP COLUMN `icash`
ALTER TABLE " . TABLE_PREFIX . "fo' at line 1

No it dosent send a pm.... why would you need that??

@whitevans... run them as seperate queries.
and i forgot to delete table prefixes..
try these

Sorry, again me.

But how can i view the last 10 donations (to me)??

is this possible??

Thank you!!

I currently have vbookie installed and I am trying to integrate the icash system into it. Every time I try to import the icash xml file, I get the databse error listed below. I have read through the posts and have changed 'money' to 'vbookie_cash', but I'm still getting errors. I have spent a couple of hours on this and still nothing. Would anyone be willing to shed some light?

What do i need to do? I just tried importing and I get this error.. I've never had I cash before.. either..

And for giggles I reran it, and now get this error..

OOPs! bad column checking on my part!
Redownload and reimport, should work fine now!

atabase error in vBulletin 3.6.7:

Invalid SQL:

UPDATE user
SET `money` = `money` + 0
WHERE userid = '1';

MySQL Error : Unknown column 'money' in 'field list'
Error Number : 1054
Date : Sunday, July 15th 2007 @ 05:57:26 PM
Script : http://www.run3h4x.net/forum/newrepl...treply&t=13847
Referrer : http://www.run3h4x.net/forum/showthread.php?t=13847
IP Address :
Username :
Classname : vb_database

Now, you must have just overwritten the product

Uninstall ICASH and THEN import the XML and it will work.

when i try to uninstall i get this

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE post DROP COLUMN `icash`;

MySQL Error : Can't DROP 'icash'; check that column/key exists
Error Number : 1091
Date : Sunday, July 15th 2007 @ 06:12:31 PM
Script : http://www.run3h4x.net/forum/admincp...do=productkill
Referrer : http://www.run3h4x.net/forum/admincp...uctid=Icash&s=
IP Address :
Username :
Classname : vb_database

Sorry you had to get caught up in that, That SHOULD be the last error you get, NOW.

Re download the current XML, Import/overwrite your previous one since you cant uninstall, THEN uninstall it, you should not recieve any errors. Now that it is uninstalled install it one last time and I think your good to go.

It won't unistall for some reason... I get the same error and i downloaded the newest one.


Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE forum DROP COLUMN `icash_prethread`;

MySQL Error : Can't DROP 'icash_prethread'; check that column/key exists
Error Number : 1091
Date : Sunday, July 15th 2007 @ 06:36:32 PM
Script : http://www.run3h4x.net/forum/admincp...do=productkill
Referrer : http://www.run3h4x.net/forum/admincp...uctid=Icash&s=
IP Address :
Username :
Classname : vb_database

I have installed this on my forum 3.6.7 but when you make a post , thread no one gets any points?

whitevans, make sure you redownload and overwrite your product with the new xml
THEN you should be able to uninstall.

@ skull, make sure you have it configured correctly in the admincp!

Ok its working now it just took a few mins to work is there a way , to edit it so that to make a thread you get 00.10 insted of 10.00 and on a reply insted of 5.00 you get 00.05

I did redownload overwrite and reinstall.

and i get this when trying to uninstall.
.
Invalid SQL:
ALTER TABLE forum DROP COLUMN `icash_prethread`;

MySQL Error : Can't DROP 'icash_prethread'; check that column/key exists
Error Number : 1091
Date : Sunday, July 15th 2007 @ 06:36:32 PM
Script : http://www.run3h4x.net/forum/admincp...do=productkill
Referrer : http://www.run3h4x.net/forum/admincp...uctid=Icash&s=
IP Address :
Username :
Classname : vb_database

Stupid spelling errors, thanks for being patient..

Redownload, Overwrite, Reinstall!

lol ok thanks :) and its ok its not easy and i feel like im bugging you so not problem, works thanks :)

Ok Blaine0002 scrap my last post , i found how to do it i just have to edit each section and edit the points section.

Nice hack thank you

Glad its finally working :D yay!

Why PMs? How else does someone know who sent the money? Or even items?

And is there at least an extended donation log?

I'm just confused about what you updated?

i made it work with new vbulletins, and i made it so points can be taken away when a point is deleted... There is a donation log built into the donation page if you havent noticed that.

Is there a way for the admin to take ponits away from a user ?
Also how can i add it so it deplys the ponits in the user profile?