Forums / Cotonti / Support / user profile data

update other database with user info

alphaphoenix
#1 2009-08-20 07:41
Is there a way that I can transfer data in one table to another table with maybe a different feild name?
Kilandor
#2 2009-08-20 13:55
Not with just like a query, it would take php. Or duplicating the table and jsut renaming any rows you need, and deleting the rest
alphaphoenix
#3 2009-08-20 14:08
Well basicly what I have is the usermap plugin which is already geocoding my user adresess and is storing the lat and lon in its respective table "sed_usermap". I am trying to apply the radius search code to data in the "sed_usermap" table but the radius code is setup to use its own table which it instructed me to create "markers". So I guess the real question is should I be changing the radius search code to query the "sed_usermap" table or can I somehow push the "sed_usermap" data to the "markers" table? I am a little shaky on this type of php stuff.
Kilandor
#4 2009-08-20 15:25
Just use the Usermap table you don't have to use the exact table that was in the example
Kilandor
#5 2009-08-22 02:42
There is no PHP code there. So I can't help you. Basicly all you need to do is where it told you to query their table, query your's instead.
alphaphoenix
#6 2009-08-23 15:20
So I am down to the following xml code which is querying the markers table. I need this to query the sed_users table. Any suggestions. Also I wanted to put this on the search tpl but it does not show up when I place the code in straight or through an iframe.