Error / Fehler with Skype Intregration

[b.o.fan]

hello @ all...

i allways get this

DB Error: Bad SQL Query: UPDATE 4images_users SET user_email = 'b.o.fan@freenet.de', user_showemail = 1, user_allowemails = 1, user_invisible = 0, user_homepage = 'http://www.wartenaufden15.de', user_icq = '217052007', = '', user_sex = 'm' WHERE user_id = 127
You have an error in your SQL syntax near '= '', user_sex = 'm' WHERE user_id = 127' at line 2

Error.

i have done this in my member.php

Code: [Select]

$user_skype = (isset($user_row['user_skype'])) ? $user_row['user_skype'] : REPLACE_EMPTY;
    if (!empty($user_skype) && $user_skype != REPLACE_EMPTY) {
      $user_skype_button = "<A HREF=\"CALLTO://".$user_skype."\"><IMG SRC=\"http://goodies.skype.com/graphics/skypeme_btn_small_white.gif\" BORDER=0></a>";
    }
    else {
      $user_skype_button = REPLACE_EMPTY;
    }

add this after

Code: [Select]

    $user_icq = (isset($user_row['user_icq'])) ? $user_row['user_icq'] : REPLACE_EMPTY;
    if (!empty($user_icq) && $user_icq != REPLACE_EMPTY) {
      $user_icq_button = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=".$user_icq."\" target=\"_blank\"><img src=\"http://web.icq.com/whitepages/online?icq=".$user_icq."&img=5\" width=\"18\" height=\"18\" border=\"0\" alt=\"".$user_icq."\" /></a>";
    }
   
    else {
      $user_icq_button = REPLACE_EMPTY;
    }
and this

Code: [Select]

      "user_skype" => $user_skype,
      "user_skype_button" => $user_skype_button,
after:

Code: [Select]

      "user_icq" => $user_icq,
      "user_icq_button" => $user_icq_button,
this:

Code: [Select]

      "lang_skype" => $lang['skype'],after

Code: [Select]

      "lang_icq" => $lang['icq'],
this:

Code: [Select]

  $user_skype = (isset($HTTP_POST_VARS['user_skype'])) ? ((intval(trim($HTTP_POST_VARS['user_skype']))) ? intval(trim($HTTP_POST_VARS['user_skype'])) : "") : "";

Code: [Select]

$user_icq = (isset($HTTP_POST_VARS['user_icq'])) ? ((intval(trim($HTTP_POST_VARS['user_icq']))) ? intval(trim($HTTP_POST_VARS['user_icq'])) : "") : "";
and replace this

Code: [Select]

           SET ".get_user_table_field("", "user_email")." = '$user_email', ".get_user_table_field("", "user_showemail")." = $user_showemail, ".get_user_table_field("", "user_allowemails")." = $user_allowemails, ".get_user_table_field("", "user_invisible")." = $user_invisible, ".get_user_table_field("", "user_homepage")." = '$user_homepage', ".get_user_table_field("", "user_icq")." = '$user_icq', user_sex = '$user_gender'
with this:

Code: [Select]

SET ".get_user_table_field("", "user_email")." = '$user_email', ".get_user_table_field("", "user_showemail")." = $user_showemail, ".get_user_table_field("", "user_allowemails")." = $user_allowemails, ".get_user_table_field("", "user_invisible")." = $user_invisible, ".get_user_table_field("", "user_homepage")." = '$user_homepage', ".get_user_table_field("", "user_icq")." = '$user_icq', ".get_user_table_field("", "user_skype")." = '$user_skype', user_sex = '$user_gender'
and i updated my database in 4images_users with a new field user_skype VARCHAR 20.

and in the templates all is right. when i go to my database an give the in my datas hey shows my the entry. but when i will save it in the contoll panel i get the error.


can help somebody?


thx b.o.fan

[b.o.fan]

no idea's???


oky...

thx for nothing....

[V@no]

u can not use get_user_table_field() function for new user fields added through db_field_definitions.php

[b.o.fan]

oky. but what must i change i my member.php for the above changes...?

what must i add in the db_field....php?

b.o.fan

[V@no]

oky. but what must i change i my member.php for the above changes...?

what must i add in the db_field....php?

b.o.fan

just dont use that function in the database query (or anywhere else), use the same way as its for your "user_sex" field.