[resolved] vs.hive issues with apostrophes Options

[morbid romantic]

I just started to use vs.hive for a webring because ringsurf is terrible.

I've noticed, though, that when anyone tries to add a site that has an apostrophe in their name, the site title, or the description... well, anywhere, they get an error:

Could not add your data to the database! This is a fairly major error..

Does anyone know how I can make it so that this doesn't happen?

[Amelie]

In vs.hive/functions.inc.php, find this code (line 788-800):

CODE

function addnewmember( $d ){
  global $_HIVEID;
  
  // default this value to no
  $d['memberEmailVis'] = empty( $d['memberEmailVis'] ) ? 'no' : $d['memberEmailVis'];
  
  // if we have no password, made up a random one
  $d['memberPass'] = empty( $d['memberPass'] ) ? substr( md5( rand() ), 0, 6 ) : $d['memberPass'];
  
  $str = "INSERT INTO `$_HIVEID[table]` ".
         "( siteKey, memberPass, memberName, memberEmail, memberURL, memberCodeURL, memberCountry, memberTxt2, memberEmailVis, memberTxt1 ) ".
         "VALUES ( '$_HIVEID[id]', MD5( '$d[memberPass]' ), '$d[memberName]', '$d[memberEmail]', '$d[memberURL]', '$d[memberCodeURL]', '$d[memberCountry]', ".
         "'$d[memberTxt2]', '$d[memberEmailVis]', '$d[memberTxt1]' );";

Change it to:

CODE

function addnewmember( $d ){
  global $_HIVEID;
  
  // default this value to no
  $d['memberEmailVis'] = empty( $d['memberEmailVis'] ) ? 'no' : $d['memberEmailVis'];
  
  // if we have no password, made up a random one
  $d['memberPass'] = empty( $d['memberPass'] ) ? substr( md5( rand() ), 0, 6 ) : $d['memberPass'];

  $e = array();
  foreach($d as $k => $v) {
    if (get_magic_quotes_gpc()) $v = stripslashes($v);
    $e[$k] = mysql_real_escape_string($v, $_HIVEID['dblink']);
  }

  $str = "INSERT INTO `$_HIVEID[table]` ".
         "( siteKey, memberPass, memberName, memberEmail, memberURL, memberCodeURL, memberCountry, memberTxt2, memberEmailVis, memberTxt1 ) ".
         "VALUES ( '$_HIVEID[id]', MD5( '$e[memberPass]' ), '$e[memberName]', '$e[memberEmail]', '$e[memberURL]', '$e[memberCodeURL]', '$e[memberCountry]', ".
         "'$e[memberTxt2]', '$e[memberEmailVis]', '$e[memberTxt1]' );";

That will work for members joining, but might not if you are editing them via the admin panel. This is for vs.hive 1.2 single by the way - the code may differ if you are using an older version or the multi version.

[morbid romantic]

That worked wonderfully! Thank you so, so much.

[corinne1261]

It's resolved, but is there a way to do it for the multiple version? This way doesn't work.