EQ2Interface - Cool dynamic sig (my own)

EQ2Interface (https://www.eq2interface.com/forums/index.php)

- Chit-Chat (https://www.eq2interface.com/forums/forumdisplay.php?f=2)

- - Cool dynamic sig (my own) (https://www.eq2interface.com/forums/showthread.php?t=1116)

Would be polite even if not necessary.

Welp back to coding mines some more, got my GD library back up and I've seen that they've implemented playing time and last on in the achievements page ;)

Drum, I got the colors.

Quick thanks to Drum. I got the colors issue worked out by using PNG files like you said. Also, the .ataccess idea to make GIFs work as PhP gets my vote for: Kicks more ass than Jackie Chan. Good job.

Only issue now is that the code only pulls from the first page of the Player section: Stats, attributes, guild info and resists. I'm trying to figure out how to add accomplishments to the data being parsed.
I checked out Oct's code and it apparently doesn't parse this info either.

I have a question!

Ive got it up and running etc. My guild name is too long so I just edited the PHP and image files. However Id like to add some things to my sig (kills etc). I realize someone asked for this before but Im a bit unsure if its been answered.
1. Do I edit the config.php?
2 .Is this where I need to enable the database settings?
3. If so what name and PW do I use? Station name or my server name and PW?

Then Im concerned that if I put that info in the config file that someone can grab it..

Thanks

Ok to answer my own stupid question - I forgot I cant view the source of PHP if its set up correctly so just ignore my worries about someone sneaking my user/pw etc heh.

Nightlord: Cool. Yeah gotta do edits for the other stuff. For me I did a lot of editing to mold the code easier to add different things (at least for me).

Kale27: Kinda the same thing here, it was kind of a pain to parse in the attributes page and all the odds and ends. Plus, if you want to cache it you have to add the SQL lines or modify them (most of them with which order counts). It's kind of a painfully long process, but the result pays off.

Ok im a bit lost.. (sorry for that). I still am unsure where the starting point is to add dynamic information to the sig.

Which PHP file am I to be editing?

Do I set database to TRUE?

Ok helps to have the right database name../bonk self

My DB is set up ready to rock. Just need to figure out how to add the additional stats.

the code is broken? i see error in the signatures.

Just change it :D

That ;nsbps thingy on the bottom left is what you referring to? Its been doing that since the update to eq2players.

hehe... and I thought it was just me. :)

I've installed PHP on my windows 2003 server and set up the EverQuest 2 Scripting Engine Generator (version 0.07) as outlined in the readme file, but it isnt working for me. :(

Here is the link for the sig image: My Sig

When I load it I see the following errors:

 
Notice: Undefined index: sn in D:\WebSites\Paragon\eq2sig\image.php on line 6 
 
Notice: Undefined index: m in D:\WebSites\Paragon\eq2sig\image.php on line 7 
 
Notice: Undefined variable: handle in D:\WebSites\Paragon\eq2sig\includes\global.php on line 40 
 
Notice: Undefined variable: handle in D:\WebSites\Paragon\eq2sig\includes\global.php on line 40 
 
Notice: Undefined variable: handle in D:\WebSites\Paragon\eq2sig\includes\global.php on line 40 
‰PNG

Any idea what I did wrong?

Nevermind... Removed PHP and manualy installed and it works perfectly. PHP windows installer is evil :p

Next question: Can I use MSSQL for the DB?

Ok, Im a php newb. Quoting code and such doesnt work for me. I installed Octavius' files on my server, but i get this message:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /"removed my servername for privacy"/eq2sig/includes/global.php on line 8
8:Access denied for user: ' removed servername for privacy '(Using password: YES)
(note, i removed my servername on these boards, but it is correct in my address)

I wish there was a "How to install your sig generator, For Dummys" post.

Anyone able to help?

Den

what is the &nbsp thing?

i havent look at the code, but   is a no breaking space (in html if there is more than 1 space they are ignored and treated as just one, so if you want to have more than one space between letters you have to use   )

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;}

?>

Alright I think I figured it out. I am not a hardcore programmer but I like to play around. So instead of that error we got I replaced it with Player status. Here is what I got for you:

Go into the Dir: /themes/default open the file themes.php in notepad
change the following lines in NORMAL SIGNATURE MODE
from

Code:

imagestring($image_out, 2, 15, 56, $player['rank'], $color);

Code:

imagestring($image_out, 2, 15, 56, "Player Status: ".$player['status'], $color);

Its seems there must have been a eq2players.com update and wiped out the rank area. Make sure you do not change the numbers as I think that is where the text gets displayed.
You can also change this for the other file in the panel folder if you want to use the other backround. view below to see my Sig

Quote:

Originally Posted by Drumstix42

meaning:
instructions for the tinyurl.com....
but if you know how to do HTACCESS, you can do that.

Anyhow, I was the the one that mentioned I use HTACCESS.

-I put my pid inside the file, and save the file as just .php
-Rename the extension to .gif
-create .HTACCESS file in the same directory as file
-then I paste thie code into the HTACCESS file:

Code:

<FilesMatch eq2sig.gif>

SetHandler application/x-httpd-php

</FilesMatch>

replacing eq2sig.gif with the name/location of your image file.

Then I call on my .gif file (which was once a php file) and there ya go...

Ok I understand the .htaccess file it is easy enough. However, you said you put your pid in the .php file, I assume you mean Player Id, now you just put that alone or is there code I: am not thinking about that should be in there.

If I follow what you say to the T, when I link to the "fake" image, I end up with it just showing my player id, what am I missing if you do not mind sharing. Thanks.

in the image.php change:

Code:

$pid = get_var($HTTP_GET_VARS['cid'], "pid");

to:

Code:

$pid = "000000000";

replacing the zero's with your player's EQ2Player Site ID.

this way you won't have to have any extra stuff on the URL of your signature, allowing it to function on all sites that allow images.

got it thanks a lot! :)

One last question. I been searching everywhere but can't find the answer. I have this code in my theme.php:

Code:

imagestring($image_out, 2, 135, 4, "Player Status: ".$player['status'], $color);

I would like it to say how many quests completed. I have had no luck finding the parse code for this. I searched here and at the SOE site and of course on google. I have no idea how you guys find what to parse but I salute you for it.
:nana:

The code w/ database caching your using is not setup to parse the Achievments page. However, mine is. Mine is also much more "readable" in coding standards of my own at least. There's no theme files, or anything like that. 2 files, config, and image. Difference in mine is that I use a different php command to do the text, so I don't get that crappy default GD font.

So... if you wanted Quests Completed, you would have to add code parse the achievements page, and then add the SQL to cache it if wanted. Or maybe I'll just post the code later :rolleyes:

Quote:

Originally Posted by Drumstix42

Mine is also much more "readable" in coding standards of my own at least.

I agree yours is pretty nice judging by your sig. Is yours pretty much payed out the same as this one I am using? It looks like you enabled the db caching, does it support themes too? I am not looking to use it on a public forum only on my guild forum. I liked the theming and the fact that anyone in my guild would be able to genrate one. As for the fonts I am sure they could be changed if I were to dive into the code but I am not currently looking to spend that much time on this project. This one is functional even if the font blows. That kind of thing can be fixed.

All I need is the quest completed equivalent of "$player['status']". I figured I would have to add the proper tables etc but without knowing this key piece of info it makes it a little hard. While I can do a lot with PHP I have never really done HTML parsing before. So while the answer may be obvious to you it is not to everyone. ;)

Anyways, if yours supports the same thing as his and has the generation capabilities and themes etc then I would not complain about receiving an IM with it attached :D Thanks for your time.

Well I am working on a remake of this mod by octavius. As Drum said it is some very messy code. I will be commenting it all, at least the parts I understand enough too lol. I am also changing where he has Rank to Quests completed. I would also like to add lastkilled, lastkilledby and where.

That will not be until a later version. I so far have it using TTF instead of the crap default stuff. So if your server doesn't have support for TTF in your GD install you are going to be out of luck.

Now I will be IM'ing Octavius soon to make sure he is ok with me releasing my remake of his system. So as long as he doesn't deny it I will try to get something put together in a week or two.

In my plan is to also add a UI for users to navigate to to generate the link. It is easy enough to do but again it will not be for a week or two at the soonest. Have too much going on and not enough time to do it lol.

If anyone can offer up the parse information for the last killed stuff I would appreciate it. I know some people don't like to share and if not that is fine I am sure it can be found if I keep trying lol.

Thanks!

P.S. If released I will start my own thread so to have a fresh start :)

Examples:

Yeah, my code is based off his.

Mine isn't set up in theme-friendly-format. But... all the things you need to edit are in one place so, it doesn't matter.

As for the parsing of pages. I have a format that makes it, if I might say, hella easy to figure out what number matches which stat, ect. Indeed this thread is quite long for someone looking at it the first time, so anything new, I would say it's best to start a new thread. Plus, this topic was just started as me showing my sig, and not really "how" to make one... but like I said, I may as well give it out... but I'm not including the text lines to my whole sig because I know someone will just change the player id, and have some identical sig... which makes it very boring :)