I would think you would just change the existing field names to the vbPlaza ones. I'm not sure of the names. Regardless, if the fields are still there with values in them, so...
after i upgraded from 3.0 to 3.5, those tables/column of uCash 0.95 are still in the database.
Is there any convert from uCash 0.95 to vBPlaza ?
You can only convert the "pocket" points. Once installed there is a section in the AdminCp where you can copy ucash points or something like that. Any data stored in the bank at this point can't be transferred. I don't have my tables anymore, but I think the data is serialized in the bank section....I am not sure though what other info is stored with the bank data for them to serialize it. CMX could probably add the functionality fairly easily if he had some some serialized data to look at.
If I remember right there was a bank and a bank queue, not sure what the difference between the two was. Just thought I would throw that in.
You can only convert the "pocket" points. Once installed there is a section in the AdminCp where you can copy ucash points or something like that. Any data stored in the bank at this point can't be transferred. I don't have my tables anymore, but I think the data is serialized in the bank section....I am not sure though what other info is stored with the bank data for them to serialize it. CMX could probably add the functionality fairly easily if he had some some serialized data to look at.
If I remember right there was a bank and a bank queue, not sure what the difference between the two was. Just thought I would throw that in.
i've just look through eBux, it will let me state the table/column of the uCash point, so the non-bank point is fairly straight forward.
Regarding points in the uCash bank, it is serialize into text from an array.
Not sure how to convert that and add it to normal non-bank point.
As for the bank queue, most likely it is queueing transaction ready to add into or subtract from the bank.
U'd have to write ur own script to do it, because it has to basically query the information from EVERY user in ur database (on my site its over 200,000 and would take a while).
Then it has to unserialize the data, then it has to send a query to update the vbbank field for the current user, and then go onto the next user.
So, if u have 200,000 users, it would require 200,001 queries... 1 per user and 1 to grab the entire list of users from the database, so it would make more sense to run this script like vbulletin does and process 1000 users at a time, then u only have 1001 queries executed per time running, but as u can see its still a very costly script.
It could be done as a 1000 users at a time script, I'll try to look into it when I get time, in the mean time, could u paste to this thread a value of what the serialized data looks like so I know the "names" of the points it uses when its in there?
uCash 0.95c -> vbPlaza ? Details »»
About Developer
Visit Web Site
No support by the author.
03-09-2006, 06:03 AM
