| @@ 268-284 (lines=17) @@ | ||
| 265 | $img->createAlbum($uid); |
|
| 266 | } |
|
| 267 | ||
| 268 | if ('save' === $_POST['function']) { |
|
| 269 | $sql = 'INSERT INTO ' |
|
| 270 | . $xoopsDB->prefix('smallworld_user') |
|
| 271 | . ' (userid, regdate, username, userimage, realname, gender, intingender, relationship, partner, searchrelat, birthday, birthplace, birthplace_lat, birthplace_lng, birthplace_country, politic, religion, emailtype, screenname_type, screenname, mobile, phone, adress, present_city, present_lat, present_lng, present_country, website, interests, music, tvshow, movie, books, aboutme, school_type, school, schoolstart, schoolstop, employer, position, jobstart, jobstop, description, friends, followers, admin_flag) '; |
|
| 272 | $sql .= "VALUES ('" . (int)$uid . "', '" . $regdate . "', '" . $username . "', '" . $avatar . "', '" . $realname . "', '" . $gender . "', '" . $intingender . "', '" . $relationship . "', '" . $partner . "', '" . $searchrelat . "','"; |
|
| 273 | $sql .= $birthday . "', '" . $birthplace . "', '" . (float)$birthplace_lat . "', '" . (float)$birthplace_lng . "', '" . $birthplace_country . "', '" . $politic . "', '" . $religion . "','"; |
|
| 274 | $sql .= $emailtype . "', '" . $screenname_type . "', '" . $screenname . "', '" . (float)$mobile . "', '" . (float)$phone . "', '" . $adress . "', '" . $present_city . "', '" . (float)$present_lat . "','"; |
|
| 275 | $sql .= (float)$present_lng . "', '" . $present_country . "', '" . $website . "', '" . $interests . "', '" . $music . "', '" . $tvshow . "', '" . $movie . "', '" . $books . "', '" . $aboutme . "', '"; |
|
| 276 | $sql .= $school_type . "', '" . $school . "', '" . $schoolstart . "', '" . $schoolstop . "', '" . $jobemployer . "', '" . $jobposition . "', '" . $jobstart . "', '" . $jobstop . "', '" . $jobdescription . "', "; |
|
| 277 | $sql .= "'0', '0', '0')"; |
|
| 278 | $result = $xoopsDB->queryF($sql); |
|
| 279 | if (false === $result) { |
|
| 280 | die('SQL error:' . $sql . ''); |
|
| 281 | } |
|
| 282 | $this->SetAdmins($uid, $username, $realname, $avatar); |
|
| 283 | $img->createAlbum($uid); |
|
| 284 | } |
|
| 285 | } |
|
| 286 | ||
| 287 | /** |
|
| @@ 365-381 (lines=17) @@ | ||
| 362 | $img->createAlbum($uid); |
|
| 363 | } |
|
| 364 | ||
| 365 | if ('save' === $_POST['function']) { |
|
| 366 | $sql = 'INSERT INTO ' |
|
| 367 | . $GLOBALS['xoopsDB']->prefix('smallworld_user') |
|
| 368 | . ' (userid, regdate, username, userimage, realname, gender, intingender, relationship, partner, searchrelat, birthday, birthplace, birthplace_lat, birthplace_lng, birthplace_country, politic, religion, emailtype, screenname_type, screenname, mobile, phone, adress, present_city, present_lat, present_lng, present_country, website, interests, music, tvshow, movie, books, aboutme, school_type, school, schoolstart, schoolstop, employer, position, jobstart, jobstop, description, friends, followers, admin_flag) '; |
|
| 369 | $sql .= "VALUES ('" . (int)$uid . "', '" . $regdate . "', '" . $username . "', '" . $avatar . "', '" . $realname . "', '" . $gender . "', '" . $intingender . "', '" . $relationship . "', '" . $partner . "', '" . $searchrelat . "','"; |
|
| 370 | $sql .= $birthday . "', '" . $birthplace . "', '" . (float)$birthplace_lat . "', '" . (float)$birthplace_lng . "', '" . $birthplace_country . "', '" . $politic . "', '" . $religion . "','"; |
|
| 371 | $sql .= $emailtype . "', '" . $screenname_type . "', '" . $screenname . "', '" . (float)$mobile . "', '" . (float)$phone . "', '" . $adress . "', '" . $present_city . "', '" . (float)$present_lat . "','"; |
|
| 372 | $sql .= (float)$present_lng . "', '" . $present_country . "', '" . $website . "', '" . $interests . "', '" . $music . "', '" . $tvshow . "', '" . $movie . "', '" . $books . "', '" . $aboutme . "', '"; |
|
| 373 | $sql .= $school_type . "', '" . $school . "', '" . $schoolstart . "', '" . $schoolstop . "', '" . $jobemployer . "', '" . $jobposition . "', '" . $jobstart . "', '" . $jobstop . "', '" . $jobdescription . "', "; |
|
| 374 | $sql .= "'0', '0', '0')"; |
|
| 375 | $result = $GLOBALS['xoopsDB']->queryF($sql); |
|
| 376 | if (false === $result) { |
|
| 377 | die('SQL error:' . $sql . ''); |
|
| 378 | } |
|
| 379 | $this->setAdmins($uid, $username, $realname, $avatar); |
|
| 380 | $img->createAlbum($uid); |
|
| 381 | } |
|
| 382 | } |
|
| 383 | /** |
|
| 384 | * SetAdmins function |
|