Testing a herald, in need of a dolcharacter table

[LifeFlight]

Hey guys,

I know this sounds kinda sketchy, but w/e.
I'm working on a herald that, for my specific needs, runs off of a '^' delimited .txt dump of the dolcharacters table, excluding the DOLcharacter id and Accountname field.
Only problem is that I current don't have my server up so the file I've been using to test with is a crudely made up one.

Heres a link to my herald if your interested, it's lame, but we just learned cgi in my class so it was a fun way to learn cgi.
http://z.cs.utexas.edu/users/cs329e/pdr ... herald.cgi
oh! and if you have any suggests that would be great too (I know it looks god awful in IE, what little css I have done is just tailored for FF)

So if your feeling charitable pm me or email me (ritcheypaul@gmail.com), either with suggestions about changes I should make or with a table.
^ delimited
without the AccountName or DOLCharacters_ID field


I totally understand if this is way to inappropriate.

[Centurio]

Why use cgi??
I think that it isn't a good way, or better if you have more request to acces at your herald ,cgi it's a bad way

[LifeFlight]

hehe, its the only way I know how....

would php be significantly better?

[rizla]

well php would allow you to perform queries on the mysql db, hence you won't need the txt-file. You then can also access all tables in the database so you could show more then just the characters on ur herald.

[Etaew]

Well, from a security point of view, nothing is wrong with not querying the database, but there are certainly performance concerns. For security and performance side, the database query is still probably the best bet, either exporting to a new table only the data you want, or just being very careful about the way you program or access data.

PHP is very easy to work with to connect to MySQL, I use it all over this site, granted, I've started to hijack all of phpBB's methods instead of my own lately, there are still times when you do need to just connect and run your own query.

Let's have a look at an example shall we:

Code: Select all

<?php
$host = "localhost";
$username = "";
$password = "";
$database = "";
$connection = mysql_connect($host,$username,$password) or die(mysql_error());
mysql_select_db($database);
$result = mysql_query("SELECT c.Name,c.LastName,c.Level,g.GuildName FROM `dolcharacters` c JOIN `guild` g ON c.GuildID = g.ID WHERE c.Level = '50'") or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
//do your thing access data via $row['Level'] etc
}
mysql_close($connection);
?>

Disclaimer: This is just off the top of my head, method names, or field names from the tables may be wrong

[Merec]

PHP is one of the best ways to connect mysql-servers.

For work, I read a lot about it and found a very nice plugin for PEAR.
Have a look at "DB2", "Propel" and "Creole". It is an object-oriented, Hybernate like way to connect Mysql and handles data very fast, its my favorite.

Greetings

[LifeFlight]

I wrote my code in Ruby, so I can still access the mysql. The only reason that I didn't write it that way to begin with is that We haven't covered that in class yet lol, on monday we start that!!

So switching the code to use the mySQL db shouldn't be a problem.
Unless you guys know something about Ruby that makes it god awful to use that my professor hasn't told us.

[Batlas]

Anyone who feels the urge to knock Ruby.. Lemme know so I can delete your post

[LifeFlight]

so.. any comments on the herald? things I should add/improve?

[Graveen]

hehe good learning. perhaps interface is a bit...well... orange ?

[Dinberg]

Looks nice! Well done with this

[Blues]

I made one with php, was originaly made for ariadolis but carni took his own one, i just didnt change the header grafic yet.

The Main Difference i see is ... well mine just looks better
The Functions are almost the same. What is missing in yours is a search form to find characters.

And a nice Feature i have can be seen if you go on the "Population Statistics" on the general info page, though it would look better with a real database, it is only connected to a test database with most chars filled in by hand.

EDIT:
Well maybe i should also add the link to the site: http://www.naegra.com/pfff/

[LifeFlight]

Yeah, I added guild/player search ability to it recently. Just haven't finished tweaking it the way I want it.
I just haven't taken the time to worry about looks, thats an easy fix any who.


Next thing I am going to do is hook it up to MySQL, that shouldn't be hard.

[LifeFlight]

http://z.cs.utexas.edu/users/cs329e/pdr ... Herald.cgi

updated version.

[bryon]

you can make a script to send only the data that you want to a separate db on certain events like PlayerQuits..

on live when the player quits or logs out.. the updated player info is sent out to a separate web server.. is really the most efficient way so that it doesnt slow down the main game server from web traffic..

i had a sample but i lost it.. its very simple to make tho.