Signature Creator (build on DB data)

[DeathArt]

Hey

Update:
PDO version released: http://forum.ragezone.com/f315/signature-creator-build-db-data-242456/#post2152829

I wish to ask about a script we created for HOAX would have a public interest.
The script is a PHP script that auto generates a signature from the database data.

Example:

Archer

Knight

Mage

("Gamemasters" and "Seishin" is guild names.)

The script is currently build in our framework (Zend Framework), but I would be happy to spend 5 minutes making a php version (using odbc_* functions, as mssql_* denies to connect here).

So tell me if it have any interest. Or if you have other background / images suggestions for it.

 

[HandsOfGod]

thats nice idea

 

[blacktwin]

its a great idea.. mabye each guild have same background or somthning..

 

[DeathArt]

its a great idea.. mabye each guild have same background or somthning..

Was thinking on some more armour pictures based on the players level too.

 

[pacd]

Looks pretty good mate. Keep on your good work

 

[DeathArt]

I posted a version in the release forum.

http://forum.ragezone.com/f315/signature-creator-build-db-data-242456/#post2152829

 

[Drey]

You're doing a great job with Hoax DeathArt, all your work looks very good!

Yak still plays there huh... Thought he'd get tired of remaking his mage after all those resets.

 

[DeathArt]

You're doing a great job with Hoax DeathArt, all your work looks very good!

Yak still plays there huh... Thought he'd get tired of remaking his mage after all those resets.

Thanks

And yeah, resetting because of corrupt players is really annoying for us :/

 

[Jake]

Well, it's a nice idea - but the fact if someone views that image - sets an auto viewer for about 50000000 times - your server will be screwed - the load will go sky high. Unless, it's been cached and is not reading directly from the DB.

 

[DeathArt]

Well, it's a nice idea - but the fact if someone views that image - sets an auto viewer for about 50000000 times - your server will be screwed - the load will go sky high. Unless, it's been cached and is not reading directly from the DB.

It's not cached yet (sssh, don't tell anyone).

But I'm planning on a 12 hour cache or similiar. We simply have to cache EVERYTHING at HOAX, as we're under constant hacker attacks
Stil, it's normaly it's not a problem, since the browser cache the image (atleast if I fix a fake .png extension).

But thanks for reminding me.

P.S. Zend Cache is awsome!

<?php
...
        $sql = "SELECT TOP 1 [Name] FROM [Player] WHERE [Class] = ? AND [Admin] = 0 AND [Level] > 0 AND [Level] < 100 ORDER BY [Level] DESC,[EXP]";
        $cache  = Zend_Registry::get('cache');
        if(!($knight = $cache->load('ranking_top_knight'))) { // knight
            $stmt = $db->prepare($sql);
            $stmt->execute(array(0));
            $knight = $stmt->fetch(PDO::FETCH_OBJ);
            $cache->save($knight);
        }
...
?>

 

[Jake]

It's not cached yet (sssh, don't tell anyone).

But I'm planning on a 12 hour cache or similiar. We simply have to cache EVERYTHING at HOAX, as we're under constant hacker attacks
Stil, it's normaly it's not a problem, since the browser cache the image (atleast if I fix a fake .png extension).

But thanks for reminding me.

P.S. Zend Cache is awsome!

<?php
...
        $sql = "SELECT TOP 1 [Name] FROM [Player] WHERE [Class] = ? AND [admin] = 0 AND [Level] > 0 AND [Level] < 100 ORDER BY [Level] DESC,[EXP]";
        $cache  = Zend_Registry::get('cache');
        if(!($knight = $cache->load('ranking_top_knight'))) { // knight
            $stmt = $db->prepare($sql);
            $stmt->execute(array(0));
            $knight = $stmt->fetch(PDO::FETCH_OBJ);
            $cache->save($knight);
        }
...
?>

Indeed you are correct about Zend Caching owning

The point is - attack scripts don't cache