EQ2Interface.com
Search Downloads

Home Forums Downloads F.A.Q. Portals Register

Go Back   EQ2Interface > General Discussion > Chit-Chat
Reload this Page Cool dynamic sig (my own)

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 03-27-2005, 11:11 AM
Denuve's Avatar
Denuve Denuve is offline
A Grove Wisp
  
Join Date: Jan 2005
Server: Mistmoore
Posts: 27
Default
How do i get rid of it? I know nothing of html

Code:
<?php
/* ------------------------------------------------------------------------ */
/* EverQuest 2 Guild Scripting Engine (global.php) 021420051720 (0ctavius)	*/
/* ------------------------------------------------------------------------ */
$time = date("YmdHis");
if ($usedb == TRUE) {
	$connect = @mysql_connect($dbhost, $dbuser, $dbpass);
	mysql_select_db($dbname, $connect) or die(__LINE__.":".mysql_error());
	$query = "CREATE TABLE IF NOT EXISTS `".$dbpre."player` (`id` VARCHAR(255) NOT NULL,`name` VARCHAR(255) NOT NULL,`server` VARCHAR(255) NOT NULL,`city` VARCHAR(255) NOT NULL,`created` VARCHAR(255) NULL,`race` VARCHAR(255) NOT NULL,`adventurer` VARCHAR(255) NOT NULL,`artisan` VARCHAR(255) NOT NULL,`status` VARCHAR(255) NULL,`hp` VARCHAR(255) NULL,`pow` VARCHAR(255) NULL,`atk` VARCHAR(255) NULL,`def` VARCHAR(255) NULL,`str` VARCHAR(255) NULL,`agi` VARCHAR(255) NULL,`sta` VARCHAR(255) NULL,`int` VARCHAR(255) NULL,`wis` VARCHAR(255) NULL,`cold` VARCHAR(255) NULL,`heat` VARCHAR(255) NULL,`poison` VARCHAR(255) NULL,`disease` VARCHAR(255) NULL,`magic` VARCHAR(255) NULL,`divine` VARCHAR(255) NULL,`mental` VARCHAR(255) NULL,`rank` VARCHAR(255) NULL,`gid` VARCHAR(255) NULL,`guild` VARCHAR(255) NULL,`updated` VARCHAR(255) NOT NULL,PRIMARY KEY(`id`)) ENGINE=MyISAM;"; $result = mysql_query($query, $connect) or die(__LINE__.":".mysql_error());
	$query = "CREATE TABLE IF NOT EXISTS `".$dbpre."guild` (`id` VARCHAR(255) NOT NULL,`name` VARCHAR(255) NOT NULL,`server` VARCHAR(255) NOT NULL,`created` VARCHAR(255) NULL,`rank` VARCHAR(255) NOT NULL,`members` VARCHAR(255) NOT NULL,`average` VARCHAR(255) NULL,`web` VARCHAR(255) NULL,`level` VARCHAR(255) NOT NULL,`status` VARCHAR(255) NOT NULL,`updated` VARCHAR(255) NOT NULL,PRIMARY KEY(`id`)) ENGINE=MyISAM;"; $result = mysql_query($query, $connect) or die(__LINE__.":".mysql_error());}
function db_process($array, $type, $method) {global $time, $dbpre, $connect;
	if ($method=="update" && $type=="player") {
		$query = "UPDATE ".$dbpre."player SET `name`='".$array['name']."',`server`='".$array['server']."',`city`='".$array['city']."',`created`='".$array['created']."',`race`='".$array['race']."',`adventurer`='".$array['adventurer']."',`artisan`='".$array['artisan']."',`status`='".$array['status']."',`hp`='".$array['hp']."',`pow`='".$array['pow']."',`atk`='".$array['atk']."',`def`='".$array['def']."',`str`='".$array['str']."',`agi`='".$array['agi']."',`sta`='".$array['sta']."',`int`='".$array['int']."',`wis`='".$array['wis']."',`cold`='".$array['cold']."',`heat`='".$array['heat']."',`poison`='".$array['poison']."',`disease`='".$array['disease']."',`magic`='".$array['magic']."',`divine`='".$array['divine']."',`mental`='".$array['mental']."',`rank`='".$array['rank']."',`gid`='".$array['gid']."',`guild`='".$array['guild']."',`updated`='".$time."' WHERE `id`='".$array['id']."'";
		$result = mysql_query($query, $connect) or die(__LINE__.":".mysql_error());}
	if ($method=="insert" && $type=="player") {
		$query = "INSERT INTO ".$dbpre."player (`id`,`name`,`server`,`city`,`created`,`race`,`adventurer`,`artisan`,`status`,`hp`,`pow`,`atk`,`def`,`str`,`agi`,`sta`,`int`,`wis`,`cold`,`heat`,`poison`,`disease`,`magic`,`divine`,`mental`,`rank`,`gid`,`guild`,`updated`) VALUES ('".$array['id']."','".$array['name']."','".$array['server']."','".$array['city']."','".$array['created']."','".$array['race']."','".$array['adventurer']."','".$array['artisan']."','".$array['status']."','".$array['hp']."','".$array['pow']."','".$array['atk']."','".$array['def']."','".$array['str']."','".$array['agi']."','".$array['sta']."','".$array['int']."','".$array['wis']."','".$array['cold']."','".$array['heat']."','".$array['poison']."','".$array['disease']."','".$array['magic']."','".$array['divine']."','".$array['mental']."','".$array['rank']."','".$array['gid']."','".$array['guild']."','".$time."')";
		$result = mysql_query($query, $connect) or die(__LINE__.":".mysql_error());}
	if ($method=="update" && $type=="guild") {
		$query = "UPDATE ".$dbpre."guild SET `name`='".$array['name']."',`server`='".$array['server']."',`created`='".$array['created']."',`rank`='".$array['rank']."',`members`='".$array['members']."',`average`='".$array['average']."',`web`='".$array['web']."',`level`='".$array['level']."',`status`='".$array['status']."' WHERE `id`='".$array['id']."'";
		$result = mysql_query($query, $connect) or die(__LINE__.":".mysql_error());}
	if ($method=="insert" && $type=="guild") {
		$query = "INSERT INTO ".$dbpre."guild (`id`,`name`,`server`,`created`,`rank`,`members`,`average`,`web`,`level`,`status`,`updated`) VALUES ('".$array['id']."','".$array['name']."','".$array['server']."','".$array['created']."','".$array['rank']."','".$array['members']."','".$array['average']."','".$array['web']."','".$array['level']."','".$array['status']."','".$time."')";
		$result = mysql_query($query, $connect) or die(__LINE__.":".mysql_error());}}
function get_data($id, $type) {global $connect, $dbpre;
	$query = "SELECT * FROM ".$dbpre.$type." WHERE id='$id'";
	$result = mysql_query($query, $connect) or die(__LINE__.":".mysql_error());
	return $result;}
function get_var($var, $type) {global $secure, $secid, $dtheme;
	if ($type == "pid") {if ($secure['player'] == TRUE AND $secid['player'] != $var) {exit;} if ($var != "") {$out = $var;} else {exit;}}
	if ($type == "gid") {if ($secure['guild'] == TRUE AND $secure['gid'] != $var) {exit;} else {$out = "valid";}}
	if ($type == "mode") {if ($var != "") {$out = $var;} else {$out = "normal";}}
	if ($type == "surname") {if ($var != "") {$out = " ".$var;} else {$out = "";}}
	return $out;}
function get_html($id, $type) {
		if ($type == "guild") {$data = get_page("http://eq2players.station.sony.com/en/guild.vm?guildId=$id", "Server:</span>", "<img src=\"images/en/guilds/guild_roster.gif\" width=\"190\" height=\"42\" border=\"0\">"); $data = str_replace("class=\"field_data_small\">", ">*", $data); $data = str_replace("class=\"field_name_small\">", ">*", $data); $data = (strip_tags($data)); $data = ereg_replace("[ \t\r\n]+", " ", $data); $data = str_replace(" *", "*", $data);}
		if ($type == "roster") {$data = get_page("http://eq2players.station.sony.com/en/guild_roster.vm?guildId=$id", "Join Date</td>", "<td width=\"12\"  background=\"/images/en/boxes/dark/tile_right.gif\">"); $data = str_replace("<td", "*<td", $data); $data = str_replace("*<td>&nbsp;</td>", "", $data); $data = (strip_tags($data)); $data = ereg_replace("[ \t\r\n]+", " ", $data); $data = str_replace(" *", "*", $data); $data = str_replace(" (", "*", $data); $data = str_replace(")", "", $data); $data = str_replace("Initiate", "Guild Initiate", $data); $data = str_replace("Officer", "Guild Officer", $data); $data = str_replace("Member", "Guild Member", $data);}
		if ($type == "player") {$data = get_page("http://eq2players.station.sony.com/en/pplayer.vm?characterId=$id", "<span class=\"field_name_small\">Name</span>", "images/en/guilds/bottom_scrollwork.jpg"); $data = str_replace("class=\"field_data_small\">", ">*", $data); $data = str_replace("class=\"field_name_small\">", ">*", $data); $data = str_replace("Upgrade", "*----", $data); $data = str_replace("<a href=\"guild.vm?guildId=", "<a href=\"guild.vm?guildId=\">*", $data); $data = (strip_tags($data)); $data = str_replace("\" >*", "*",$data); $data = ereg_replace("[ \t\r\n]+"," ",$data); $data = str_replace(" &nbsp;","",$data); $data = str_replace("* ","*",$data); $data = str_replace(" *","*",$data); $data = str_replace(" var characterID = '","*",$data); $data = str_replace(" Unguilded","**Unguilded",$data);}
		$data = explode("*",$data); return $data;}
function get_page($url, $start, $end) {
	while (!$handle) {$handle = fopen($url, "rb");}
	$contents = ""; while (!feof($handle)) {$contents .= fread($handle, 1024);}
	fclose ($handle); if (!$contents) {exit;}
	$a = strpos($contents, $start) + strlen($start); $b = strpos($contents, $end, $a);
	if($a != FALSE && $b != FALSE) {
		$length = $b - $a; $code = Substr($contents, $a, $length); return $code;}}
function get_array($array) {echo '<pre>'.str_replace(array("\n" , " "), array('<br>', '&nbsp;'), print_r($array, true)).'</pre>';}
function build_array($array, $type) {
	if ($type == "player") {$out = array("id" => $array[0],"name" => $array[1],"race" => $array[9],"server" => $array[3],"city" => $array[5],"created" => $array[7],"adventurer" => "Level ".$array[13]." ".$array[11],"artisan" => "Level ".$array[17]." ".$array[15],"death" => "by ".$array[21]." on ".$array[19]." in ".$array[23],"gid" => $array[25],"guild" => $array[26],"status" => $array[32],"hp" => $array[36],"pow" => $array[38],"atk" => $array[40],"def" => $array[42],"str" => $array[44],"agi" => $array[46],"sta" => $array[48],"int" => $array[50],"wis" => $array[52],"cold" => $array[54],"heat" => $array[56],"poison" => $array[58],"disease" => $array[60],"magic" => $array[62],"divine" => $array[64],"mental" => $array[66],"rank" => $array[67]);}
	if ($type == "guild") {$out = array("id" => $array[0],"name" => $array[1],"server" => $array[2],"created" => $array[3],"rank" => $array[5],"members" => $array[7],"average" => $array[9],"level" => $array[21],"status" => $array[23],"web" => $array[11]);}
	return $out;}
?>
Last edited by Denuve : 03-27-2005 at 11:17 AM.
Reply With Quote
 

« Previous Thread | Next Thread »


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 03:46 AM.

Contact Us - EQ2Interface - Terms of Service - Privacy Statement - Advertise - Top
© MMOUI
vBulletin® - Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.

Our Network
EQInterface | EQ2Interface | WoWInterface | LoTROInterface | ESOUI | MMOUI