[Brianna]

mei, you are right it is the same thing in both lines: replace it with this instead

$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='".addslashes($signature)."',customtitle='".intval($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))."',element='".addslashes(htmlspecialchars($element))."',usergroupid='$bbuserinfo[usergroupid]' WHERE userid='$bbuserinfo[userid]'");

Also, I added something small, but it makes the hack look better to users:

Instead of "None" being selected for the Element everytime a user goes to update their profile, I added some simple javascript to determine which Element the user currently has in their profile

first off add this into the head tag of the modifyprofile template:

<script language="Javascript" type="text/javascript">
function isselected(elemental, elementsinprofile)
{
  if (elementsinprofile == elemental )
 {
   document.write("<option value='"+elemental+"' selected>")
 }else{
   document.write("<option value='"+elemental+"'>")
 }
}
</script>

then replace this code (at the bottom of the same template):

		<select name="element">
                              
		<option value="0" selected>None</option>
		<option value="1" >Light</option>
		<option value="2" >Water</option>
		<option value="3" >Wind</option>
		<option value="4" >Lightning</option>
		<option value="5" >Earth</option>
		<option value="6" >Fire</option>
		<option value="7" >Dark</option>
	
          

		</select>

with:

		<select name="element">
                              
		<script>isselected("0", $bbuserinfo[element])</script>None</option>
		<script>isselected("1", $bbuserinfo[element])</script>Light</option>
		<script>isselected("2", $bbuserinfo[element])</script>Water</option>
		<script>isselected("3", $bbuserinfo[element])</script>Wind</option>
		<script>isselected("4", $bbuserinfo[element])</script>Lightning</option>
		<script>isselected("5", $bbuserinfo[element])</script>Earth</option>
		<script>isselected("6", $bbuserinfo[element])</script>Fire</option>
		<script>isselected("7", $bbuserinfo[element])</script>Dark</option>
	
          

		</select>

Feel free to add that into the original guys ^_^ Sweet hack! Better than the last HP/MP/Exp hack I had before I had to redo everything and import hackless tables I like the idea of mods/admins being able to adjust the stats to use them better in leiu of the Battle Square forum XD This is gonna be great! Thanks guys ^_^