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> </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(" ","",$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>', ' '), 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;}
?>