vb.org Archive - View Single Post

Bitsys · #**2195** 09-07-2003, 03:48 PM

It looks like some of the edits to member.php did not execute properly. Try the following:

In member.php, find:

PHP Code:


			
$signature=htmlspecialchars($bbuserinfo[signature]);

and ABOVE it, add:

Code:

  // RPG Integration Hack by Bitsys
$user = $DB_site->query_first("SELECT rpgclass, rpggender, rpgrace, alignment, element, inbattle FROM user WHERE userid='$bbuserinfo[userid]'");
$classarrays = "var gd0 = new Array('Unknown','0');\n";

if (!ismoderator()) {
  $specclasses = "WHERE visible=1";
}

If($user[inbattle] == 0) {
If ($user[rpggender] == 1) {
  $unknown = $DB_site->query_first("SELECT * FROM rpg_type WHERE id=0");
  $typearrayname0 = "var typename0 = new Array('$unknown[name]');\n";
  $typearrayid0 = "var typeid0 = new Array('$unknown[id]');\n";
  $typearrays .= "$typearrayname0\n$typearrayid0";
  $rpgtypename = $unknown[name];
  $rpgtypeid = 0;
  $count = 0;
  $row = $DB_site->query("SELECT * FROM rpg_classf $specclasses ORDER BY name");
  while ($class = $DB_site->fetch_array($row)) {
        If ($user[rpgclass] == $class[id]) {
                if ($class[visible] == 0) {
                  $classoptions .= "<option value=\"$class[id]\" SELECTED>*$class[name]</option>";
                } else {
                      $classoptions .= "<option value=\"$class[id]\" SELECTED>$class[name]</option>";
                }
                $unknown = $DB_site->query_first("SELECT * FROM rpg_type WHERE id=$class[type]");
                $rpgtypename = $unknown[name];
                $rpgtypeid = $unknown[id];
        } else {
                if ($class[visible] == 0) {
                  $classoptions .= "<option value=\"$class[id]\">*$class[name]</option>";
                } else {
                      $classoptions .= "<option value=\"$class[id]\">$class[name]</option>";
                }
        }
        If($count > 0) {
                $classarrayvals .= ",'$class[name]','$class[id]'";
                $typearrayname1vals .= ",'$class[typename]'";
                $typearrayid1vals .= ",'$class[type]'";
        } else {
                $classarrayvals .= "'$class[name]','$class[id]'";
                $typearrayname1vals .= "'$class[typename]'";
                $typearrayid1vals .= "'$class[type]'";
        }
        $count++;
  }
  $classarrays .= "var gd1 = new Array($classarrayvals);\n";
  $typearrays .= "var typename1 = new Array($typearrayname1vals);\n var typeid1 = new Array($typearrayid1vals);\n";
  $classarrayvals = "";
  $row = $DB_site->query("SELECT * FROM rpg_classm $specclasses ORDER BY name");
  $count = 0;
  while ($class = $DB_site->fetch_array($row)) {
        If($count > 0) {
                $classarrayvals .= ",'$class[name]','$class[id]'";
                $typearrayname2vals .= ",'$class[typename]'";
                $typearrayid2vals .= ",'$class[type]'";
        } else {
                $classarrayvals .= "'$class[name]','$class[id]'";
                $typearrayname2vals .= "'$class[typename]'";
                $typearrayid2vals .= "'$class[type]'";
        }
        $count++;
  }
  $classarrays .= "var gd2 = new Array($classarrayvals);\n";
  $typearrays .= "var typename2 = new Array($typearrayname2vals);\n var typeid2 = new Array($typearrayid2vals);\n";
} elseif($user[rpggender] == 2) {
  $unknown = $DB_site->query_first("SELECT * FROM rpg_type WHERE id=0");
  $typearrayname0 = "var typename0 = new Array('$unknown[name]');\n";
  $typearrayid0 = "var typeid0 = new Array('$unknown[id]');\n";
  $typearrays .= "$typearrayname0\n$typearrayid0";
  $rpgtypename = $unknown[name];
  $rpgtypeid = 0;
  $row = $DB_site->query("SELECT * FROM rpg_classm $specclasses ORDER BY name");
  $count = 0;
  while ($class = $DB_site->fetch_array($row)) {
        If ($user[rpgclass] == $class[id]) {
                    if ($class[visible] == 0) {
                      $classoptions .= "<option value=\"$class[id]\" SELECTED>*$class[name]</option>";
                    } else {
                          $classoptions .= "<option value=\"$class[id]\" SELECTED>$class[name]</option>";
                    }
                    $unknown = $DB_site->query_first("SELECT * FROM rpg_type WHERE id=$class[type]");
                    $rpgtypename = $unknown[name];
                    $rpgtypeid = $unknown[id];
        } else {
                if ($class[visible] == 0) {
                  $classoptions .= "<option value=\"$class[id]\">*$class[name]</option>";
                } else {
                $classoptions .= "<option value=\"$class[id]\">$class[name]</option>";
                }
        }
        If($count > 0) {
                $classarrayvals .= ",'$class[name]','$class[id]'";
                $typearrayname2vals .= ",'$class[typename]'";
                $typearrayid2vals .= ",'$class[type]'";
        } else {
                $classarrayvals .= "'$class[name]','$class[id]'";
                $typearrayname2vals .= "'$class[typename]'";
                $typearrayid2vals .= "'$class[type]'";
        }
        $count++;
  }
  $classarrays .= "var gd2 = new Array($classarrayvals);\n";
  $typearrays .= "var typename2 = new Array($typearrayname2vals);\n var typeid2 = new Array($typearrayid2vals);\n";
  $classarrayvals = "";
  $row = $DB_site->query("SELECT * FROM rpg_classf $specclasses ORDER BY name");
  $count = 0;
  while ($class = $DB_site->fetch_array($row)) {
        If($count > 0) {
                $classarrayvals .= ",'$class[name]','$class[id]'";
                $typearrayname1vals .= ",'$class[typename]'";
                $typearrayid1vals .= ",'$class[type]'";
        } else {
                $classarrayvals .= "'$class[name]','$class[id]'";
                $typearrayname1vals .= "'$class[typename]'";
                $typearrayid1vals .= "'$class[type]'";
        }
        $count++;
  }
  $classarrays .= "var gd1 = new Array($classarrayvals);\n";
  $typearrays .= "var typename1 = new Array($typearrayname1vals);\n var typeid1 = new Array($typearrayid1vals);\n";
} else {
  $unknown = $DB_site->query_first("SELECT * FROM rpg_type WHERE id=0");
  $typearrayname0 = "var typename0 = new Array('$unknown[name]');\n";
  $typearrayid0 = "var typeid0 = new Array('$unknown[id]');\n";
  $typearrays .= "$typearrayname0\n$typearrayid0";
  $classoptions = "<option value=\"0\">Unknown</option>";
  $classarrayvals = "";
  $row = $DB_site->query("SELECT * FROM rpg_classf $specclasses ORDER BY name");
  $count = 0;
  while ($class = $DB_site->fetch_array($row)) {
        If($count > 0) {
                $classarrayvals .= ",'$class[name]','$class[id]'";
                $typearrayname1vals .= ",'$class[typename]'";
                $typearrayid1vals .= ",'$class[type]'";
        } else {
                $classarrayvals .= "'$class[name]','$class[id]'";
                $typearrayname1vals .= "'$class[typename]'";
                $typearrayid1vals .= "'$class[type]'";
        }

        $count++;
  }
  $classarrays .= "var gd1 = new Array($classarrayvals);\n";
  $typearrays .= "var typename1 = new Array($typearrayname1vals);\n var typeid1 = new Array($typearrayid1vals);\n";
  $classarrayvals = "";
  $row = $DB_site->query("SELECT * FROM rpg_classm $specclasses ORDER BY name");
  $count = 0;
  while ($class = $DB_site->fetch_array($row)) {
        If($count > 0) {
                $classarrayvals .= ",'$class[name]','$class[id]'";
                $typearrayname2vals .= ",'$class[typename]'";
                $typearrayid2vals .= ",'$class[type]'";
        } else {
                $classarrayvals .= "'$class[name]','$class[id]'";
                $typearrayname2vals .= "'$class[typename]'";
                $typearrayid2vals .= "'$class[type]'";
        }
        $count++;
  }
  $classarrays .= "var gd2 = new Array($classarrayvals);\n";
  $typearrays .= "var typename2 = new Array($typearrayname2vals);\n var typeid2 = new Array($typearrayid2vals);\n";
  $rpgtypename = $unknown[name];
  $rpgtypeid = 0;
}

$aligns = $DB_site->query("SELECT * FROM rpg_alignment ORDER BY id");
while($alignrow = $DB_site->fetch_array($aligns)) {
  $racearrayvals = "";
  $races = $DB_site->query("SELECT * FROM rpg_race WHERE alignmentid='$alignrow[id]' ORDER BY raceid");
  $count = 0;
  while ($row = $DB_site->fetch_array($races)) {
        If ($user[rpgrace] == $row[raceid] AND $user[alignment] == $row[alignmentid]) {
        $raceoptions .= "<option value=\"$row[raceid]\" SELECTED>$row[name]</option>\n";
        } elseif ($user[alignment] == $alignrow[id]) {
        $raceoptions .= "<option value=\"$row[raceid]\">$row[name]</option>\n";
        }
        If($count > 0) {
        $racearrayvals .= ",'$row[name]','$row[raceid]'";
        } else {
        $racearrayvals .= "'$row[name]','$row[raceid]'";
        }
        $count++;
  }
  $racearrays .= "var al$alignrow[id] = new Array($racearrayvals);\n";
  If ($user[alignment] == $alignrow[id]) {
        $alignmentoptions .= "<option value=\"al$alignrow[id]\" SELECTED>$alignrow[name]</option>";
  } else {
        $alignmentoptions .= "<option value=\"al$alignrow[id]\">$alignrow[name]</option>";
  }
}
$elements = $DB_site->query("SELECT * FROM rpg_element ORDER BY elementid");
while ($row = $DB_site->fetch_array($elements)) {
        If($user[element] == $row[elementid]) {
        $elementoptions .= "<option value=\"$row[elementid]\" SELECTED>$row[name]</option>";
        } else {
        $elementoptions .= "<option value=\"$row[elementid]\">$row[name]</option>";
        }
}

If($user[rpggender] == 0) {
        $genderoptions = "<option value=\"gd0\" SELECTED>Unknown</option>";
} else {
        $genderoptions = "<option value=\"gd0\">Unknown</option>";
} 
If($user[rpggender] == 1) {
        $genderoptions .= "<option value=\"gd1\" SELECTED>Female</option>";
} else {
        $genderoptions .= "<option value=\"gd1\">Female</option>";
}
If($user[rpggender] == 2) {
        $genderoptions .= "<option value=\"gd2\" SELECTED>Male</option>";
} else {
        $genderoptions .= "<option value=\"gd2\">Male</option>";
}

} else {

$classoptions = "<option value=\"$user[rpgclass]\" DISABLED>You are in battle.</option>";
$raceoptions = "<option value=\"$user[rpgrace]\" DISABLED>You are in battle.</option>";
$alignmentoptions = "<option value=\"al$user[alignment]\" DISABLED>You are in battle.</option>";
$elementoptions = "<option value=\"$user[element]\" DISABLED>You are in battle.</option>";
$genderoptions = "<option value=\"gd$user[rpggender]\" DISABLED>You are in battle.</option>";
$rpgtypename = "In battle.";
$rpgtypeid = $user[rpgtype];
}
// End RPG Integration Hack by Bitsys

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01195 seconds Memory Usage 1,839KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code (1)bbcode_php (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: