PHP Legends code

[stormgod]

php script to begin a Legend system

code is in zip

[stormgod]

Hmm here is the zip


use new zip see below

[Malevolent]

- Cleaned up the ui some
- Refactored some code

[Malevolent]

Oops. :-)

--MV

[Shortlived]

umm what is this?

[stormgod]

watch here (if I'm up)

http://stormgod.dyndns.org

[Trumpcard]

Very cool !

I had gotten about 60% of the way through my php database editor, very similar to this, cept it was geared at changing the database, not just displaying, but got sucked into other projects so I never did finish.. Glad to see someone's deciding to pick up and work on some web database integration tools, great work! (Those blobs are a pain to work with!)

I havent seen the legend code on EqLive, but I think the next cool thing would be to generate pop up windows with item stats when you right click on their items. Now that you are the master of the blob, shouldn't be too hard! LOL.. Really cool would be using php's built in image functions to produce a gif with a 'fill-in-the-blanks' format so you could display something that looked like when you examined an item on live (with the little scroll background)

If you dont mind Storm, I wouldnt mind playing with and adding on to your code some later.. It would give me the chance to start playing with some of the new 4.2.0 functions, and play with image functions a bit...

[stormgod]

hee just do Trumpcard , The better it is .. you know . I want peeps to play with else I wouldnt have put it here ;o)

[Shortlived]

Can't connect to Mysql databse :( I get the idea of it though, and I think it would rock to have a stats site for your server! Also a web bassed...or at least php based database front end would rock!

[Trumpcard]

Ok, here's my quick addition..

Items are now hyperlinks to an item.php page that will yank the basic item data and display it for you..

Yes, its ugly, but it works.. I'll beautify it later if I get the desire, Im not much on the flash side of stuff though..

Storm, I based it on your format , (which I like btw), just pulled all the different stats out into seperate fields to make additons/changes easier, and to make the sql update field a bit easier to manage..


Noticed a bug in yours though, no biggie, EAR1 is getting deciphered as WRIST item, think you have the item field for WRIST2 in display.php being set as EAR1 in the sql query.

Actually, it looks like the id is coming back correctly, its just showing the wrong name on the display page.. I'll see if I can fix it..

Update: Found the error, where you were creating the wrist2name, you must have copy and pasted and forgot to change 1 field, it was setting ear1name=substr($data2['wrist2name']

Putting a new att. in with this minor fix...

[Arcalyn]

Link to DL php?

And/Or what is php?

Please & Tanks

[Trumpcard]

PHP stands for PHP Hypertext Preprocessor

PHP use to stand for Personal Home Page, it was a library a guy wrote to be able to build his homepage with better embedded functionality and it expanded from there..

If you dont know what it is, I wouldnt recommend you try to figure it out unless you are a programming/web enthusiast.

You can get it from

http://www.php.net

You need a webserver (Apache) to go along with it to use this stuff we're posting..

[stormgod]

hehe nice trumpcards I will reuse your additions and release a new one with some changes ( possibility for visitors to leave some comments and a server info page ) will post it in a matter of minutes

[stormgod]

here it is , please read the readme because a new table is used , you can use a new database to use it , its for the comments , this script part is using the db2.php to configure connect to the database .

CREATE TABLE `comments` (`id` SMALLINT (3) DEFAULT '0' NOT NULL, `title` VARCHAR (12 DEFAULT '0', `text` TEXT, PRIMARY KEY(`id`), UNIQUE(`id`), INDEX(`id`))

this is the query to create the table
dont forget to change the database name from legends to eq in db2.php if you want to use the comment in the same db

[stormgod]

corrected a little bug in your correction , you where poiting to the right item for ear1 and wrist2 but names were inverted its corrected too (its in the zip )