Codezwiz >> Forums >> General PHP Nuke Help >> GD2 graph with PHPNuke globals and DB info

I have looked all over the place for info on this for about 4 months now......no luck.

I am running PHPNuke on PHP5 with the GD2 libraries installed and functioning,
I would like to create a graph of more than 50 years worth of info from a while loop from the Nuke db using Nuke globals and variables,
($bgcolor1, "$result = $db->" etc etc)
all I can seem to find is info pertaining to accessing a db using the vanilla PHP/MySQL syntax
(mysql_connect("localhost", "user", "password");
mysql_query("USE database")

etc etc

Anyone have any near forgotten bookmarks or favorite sites that may have info on this subject?

Belay that request, I seem to have found a method that works for me...funny that there isnt more info on PHP/GD2 graphing in Nuke floatin around.......

I don't even remember what I thougt I found that solved my original request.....

I still haven't figured out how to create a gd line graph using info from db with nuke gobals and variable....I do not have the option or desire to use any url based data passing.....

AlI've fouond are scripts that use the non-nuke db access and or require seperate pages, I'd like to have a scriptthat handles the graphing that I can pass variables to and embed the final image into a normal nuke module.

I have been all over the gfx_chk feature of Nuke, but that passes the data thru the <img src="url here" almost as a get.
I'm trying to do almost like an include type thing.. maybe I'm retarded....I can do all of the other stuff. I've even created a few modules of my own(and not just Iframe modules or the module creator) but this whole gd stuff is frustrating me.

does anyone have any idea as to how I can do this? Any sites or scripts anyone know of that I can learn from?

Here's a sample from a project I was working on a while back

First use the global statement, call the DB and DIR. Further down you can see the querry thats using the globals that were called.

function imagemerge(){
global $module_name, $nldateformat, $cookiename, $db, $directory, $leaguename, $rtmail, $prefix, $user_prefix, $user, $cookie, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $maxjoin, $refreshtime;

$result = ($db->sql_query("SELECT * FROM ".$prefix."_ladderpos WHERE active = '1'"));
while(list($block_id, $active) = $db->sql_fetchrow($result)){

You need to call the prefix also.

Another handy tip with GD and Nuke, is to make sure that you do not leave extra line returns after the ?> at the end of the file. If there are any (especially in the functions folder) your GD image will not appear.