The Arcive of vBulletin Modifications Site. |
|
Details »»
|
|||||||||||||||||||||||||
$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='". addslashes($signature)."',cust omtitle='$customtitle',usertitle='".addslashes($cu stomtext)."',email='".addslash es(htmlspecialchars($email))."',parentemail='".add slashes(htmlspecialchars($pare ntemail))."',coppauser='$coppauser',homepage='".ad dslashes(htmlspecialchars($hom epage))."',icq='".addslashes(htmlspecialchars($icq ))."',aim='".addslashes(htmlsp ecialchars($aim))."',yahoo='".addslashes(htmlspeci alchars($yahoo))."',usergroupi d='$bbuserinfo[usergroupid]' $awaysql WHERE userid='$bbuserinfo[userid]',country='".addslashes($country)."' WHERE userid='$bbuserinfo[userid]'");
As you can see I'm repeating WHERE... usergroupid='$bbuserinfo[usergroupid]' $awaysql WHERE userid='$bbuserinfo[userid]',country='".addslashes($country)."' WHERE userid='$bbuserinfo[userid]'"); Can someone tell me how I need to arrange that end of the line so both functions work? Cus they don't right now. Ta very much. Tim Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
||||
|
||||
|
Code:
$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='".addslashes($signature)."',customtitle='$customtitle',usertitle='".addslashes($customtext)."',email='".addslashes(htmlspecialchars($email))."',parentemail='".addslashes(htmlspecialchars($parentemail))."',coppauser='$coppauser',homepage='".addslashes(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',usergroupid='$bbuserinfo[usergroupid]' $awaysql ,country='".addslashes($country)."' WHERE userid='$bbuserinfo[userid]'");
|
|
#3
|
||||
|
||||
|
Tried it and it works -- Thank you very much!
![]() (I love this place, you know that?)
|
![]() |
|
|