SYNK Componet + Extrn DB Site
-
-
- Aurora
- Elite Rocketeer
- Posts: 903
- Thanks: 0
-
System:Joomla 1.5.9
Template : Hyperion
Issue: i have the synk component from www.dioscouri.com which they say supposely you can synk joomla users with extrnal site and vice versa, As for developing an custom plugin to work with my external site that uses plaintext passwords: to design, build, and test it would take 10-12 man-hours. At $50 USD / hr, this is $500-$600 USD. 10-12 man-hours is roughly 5 business days. now after going back and forth with them i decided to take the coding up on myself to design the custom plugin which later am goin to show you what i hav so far, anyways i got the code to synk and insert my users from joomla to external db when visitor logins lin joomla site, but all the fields in the external db comes up null, it shows there (ID) fine but usernm,pass and so forth comes up null. now they also say that i would have to convert the md5 hashes that joomla stored the password as to put in my extrndb, which i believe would take years to convert if you don't have an supercomputer, now what i get is this if i was suppose to spend $600 dollars or more for this custom plugin and they would reach the point where am at that this can't convert the md5 hashes to plaintext, its outrageous to pay that much on something that may not work, dn't get me wrong i get the custom plugin to synk the user when they login its just that info comes up null in extrnal db and it looks like now i hve to convert md5 hash to plain text. is ther away around this guys where i can either change my extrndb to md5 hash system or delete the plaintext psswd field and create a new field to and update the user records from joomla over to extrndb to accept md5 hash, i am stuck and you guys here i know i can count on on something that may work, heres the code by the way i have setup
$database = & JFactory::getDBO();
$query = "SELECT * FROM jos_users "
. " WHERE 1 "
. " AND `id` = '".$id."' "
;
$database->setQuery( $query );
$data = $database->loadObject();
$data = "INSERT IGNORE INTO `users` (id, username, password, email, name, status, registerDate) VALUES ";
$query .= "(";
$query .= "'".$data."',";
$query .= "'".$data."',";
$query .= "'".$data."',";
$query .= "'".$data."',";
$query .= "'".$data."',";
$query .= "'1',";
$query .= "'".$data."',";
$query .= ")";
}
-
Time to create page: 0.054 seconds