Got this:

Replace line 37 with this:

It's Success. But it's look like it doesn't get thanked amount from database1. The thanked amount is from "write" db and being rewrite again with userid+1.

hum, well it should oO

did you re-check the database credentials?

[S]If you still have the old table in another database, you could try adding the database to the table names of the first query, like[/S]

Edit: never mind, I hadn't looked at the php file linked above where Disasterpiece had already handled the second database.

BTW, I think this could be done via query something like:

(But I haven't tested that exact query). That of course assumes that you've already created a "thanked" column in the new db....and that the dbs are on the same server.

Yes, i've recheck the column after each run.

Could you rewrite the query with those extractly db name, table name and column name as i listed above?

I think this is it:


This sets the vb3forum database from the vb4forum database. I think what I posted above assumed that you were going from vb3 to vb4 (at least as far as the table prefixes were concerned). Speaking of which, if you have table prefixes you need to add them.

I've down from vb4 to vb3, and there is no table prefix on 2 databases, i have full rights to modify them both.

I've just ran the query and there is an error:

Hmm...well, both lines together are supposed to be all one query and it looks like you just have the first line there.

yes, i've ran both of them together, but it shows up just 1 line for error.