MasterACE14 Posted June 29, 2007 Share Posted June 29, 2007 I have a function that checks a users Auth Level from a database and if it is equal to 3 it gives them some links and if it isn't it tells them they should upgrade their account. But I am recieving an error. here is the code: <?php // towns.php :: Handles all actions you can do in town. function supporters() { // Supporter Status Player Functions global $userrow, $numqueries $authlevelquery = "mysql_query("SELECT authlevel FROM person");"; if($authlevelquery == 3){ display("<b>Supporter Options:</b><br /> <ul> <li /><a href="index.php?do=sendgold">Send Gold</a> <li /><a href="index.php?do=exchange">Exchange</a> </ul>", "Supporter Options"); } else { display("<br><br><b>Purchase Supporter Status to Unlock Bonus Features.<b>", "Purchase Supporter Status to Unlock Bonus Features!"); } } Here is the error: Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in /home/ace/public_html/shadowlords/towns.php on line 6 Here is line 6: $authlevelquery = "mysql_query("SELECT authlevel FROM person");"; I know line six is screwed up, but I need to know how to do the mysql query within a variable. and then check with the if statement if it is equal to 3. any help is much appreciated. Regards ACE Quote Link to comment Share on other sites More sharing options...
Foser Posted June 29, 2007 Share Posted June 29, 2007 <? // no "" for mysql_query $authlevelquery = mysql_query("SELECT authlevel FROM person"); ?> also how is knowing which person it is if there are3 multiple? try this to be more accurate but depends what your doing. <? $authlevelquery = mysql_query("SELECT authlevel FROM tablename WHERE person = '$personvariable' "); ?> Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 29, 2007 Author Share Posted June 29, 2007 its for allowing people with the authlevel 3 to access certain features. Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 29, 2007 Author Share Posted June 29, 2007 Tried chopping and changing the script and still have no success, this is what I got in the moment. <?php $authlevelquery = mysql_query("SELECT authlevel FROM sl_users WHERE id = ' . $userrow["id"] . ' "); ?> I am still recieving the same error. Regards ACE Quote Link to comment Share on other sites More sharing options...
teng84 Posted June 29, 2007 Share Posted June 29, 2007 $authlevelquery = mysql_query("SELECT authlevel FROM sl_users WHERE id =".$userrow['id']." "); try that Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted June 29, 2007 Share Posted June 29, 2007 global $userrow, $numqueries don't u need some semi colon action??? Generally a T_variable error suggest you didn't close somethign above Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 29, 2007 Author Share Posted June 29, 2007 ok, I got the authlevel query working now. Thanks guys. But now I am recieving an error on another line. heres the error: Parse error: syntax error, unexpected T_STRING in /home/ace/public_html/shadowlords/towns.php on line 11 Line 11: display("<b>Supporter Options:</b><br /> <ul> <li /><a href="index.php?do=sendgold">Send Gold</a> <li /><a href="index.php?do=exchange">Exchange</a> </ul>", "Supporter Options"); display function: function display($content, $title, $topnav=true, $leftnav=true, $rightnav=true, $badstart=false) { // Finalize page and output to browser. global $numqueries, $userrow, $controlrow, $version, $build; if (!isset($controlrow)) { $controlquery = doquery("SELECT * FROM {{table}} WHERE id='1' LIMIT 1", "control"); $controlrow = mysql_fetch_array($controlquery); } if ($badstart == false) { global $starttime; } else { $starttime = $badstart; } // Make page tags for XHTML validation. $xml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n" . "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"DTD/xhtml1-transitional.dtd\">\n" . "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\n"; $template = gettemplate("primary"); if ($rightnav == true) { $rightnav = gettemplate("rightnav"); } else { $rightnav = ""; } if ($leftnav == true) { $leftnav = gettemplate("leftnav"); } else { $leftnav = ""; } if ($topnav == true) { $topnav = "<a href=\"login.php?do=logout\"><img src=\"images/button_logout.gif\" alt=\"Log Out\" title=\"Log Out\" border=\"0\" /></a> <a href=\"help.php\"><img src=\"images/button_help.gif\" alt=\"Help\" title=\"Help\" border=\"0\" /></a>"; } else { $topnav = "<a href=\"login.php?do=login\"><img src=\"images/button_login.gif\" alt=\"Log In\" title=\"Log In\" border=\"0\" /></a> <a href=\"users.php?do=register\"><img src=\"images/button_register.gif\" alt=\"Register\" title=\"Register\" border=\"0\" /></a> <a href=\"help.php\"><img src=\"images/button_help.gif\" alt=\"Help\" title=\"Help\" border=\"0\" /></a>"; } if (isset($userrow)) { // Get userrow again, in case something has been updated. $userquery = doquery("SELECT * FROM {{table}} WHERE id='".$userrow["id"]."' LIMIT 1", "users"); unset($userrow); $userrow = mysql_fetch_array($userquery); // Current town name. if ($userrow["currentaction"] == "In Town") { $townquery = doquery("SELECT * FROM {{table}} WHERE latitude='".$userrow["latitude"]."' AND longitude='".$userrow["longitude"]."' LIMIT 1", "towns"); $townrow = mysql_fetch_array($townquery); $userrow["currenttown"] = "Welcome to <b>".$townrow["name"]."</b>.<br /><br />"; } else { $userrow["currenttown"] = ""; } if ($controlrow["forumtype"] == 0) { $userrow["forumslink"] = ""; } elseif ($controlrow["forumtype"] == 1) { $userrow["forumslink"] = "<a href=\"forum.php\">Forum</a><br />"; } elseif ($controlrow["forumtype"] == 2) { $userrow["forumslink"] = "<a href=\"".$controlrow["forumaddress"]."\">Forum</a><br />"; } // Format various userrow stuffs... if ($userrow["latitude"] < 0) { $userrow["latitude"] = $userrow["latitude"] * -1 . "S"; } else { $userrow["latitude"] .= "N"; } if ($userrow["longitude"] < 0) { $userrow["longitude"] = $userrow["longitude"] * -1 . "W"; } else { $userrow["longitude"] .= "E"; } $userrow["experience"] = number_format($userrow["experience"]); $userrow["gold"] = number_format($userrow["gold"]); if ($userrow["authlevel"] == 1) { $userrow["adminlink"] = "<a href=\"admin.php\">Admin</a><br />"; } else { $userrow["adminlink"] = ""; } //simple exp needed mod.. poorly coded by Anman $levelquery = doquery("SELECT ". $userrow["charclass"]."_exp FROM {{table}} WHERE id='".($userrow["level"]+1)."' LIMIT 1", "levels"); $levelrow = mysql_fetch_array($levelquery); $userrow["nextlevel"] = $levelrow[$userrow["charclass"]."_exp"]; $need = ($userrow["nextlevel"] - $userrow["experience"]); $userrow["expneed"] = $need; // HP/MP/TP bars. $stathp = ceil($userrow["currenthp"] / $userrow["maxhp"] * 100); if ($userrow["maxmp"] != 0) { $statmp = ceil($userrow["currentmp"] / $userrow["maxmp"] * 100); } else { $statmp = 0; } $stattp = ceil($userrow["currenttp"] / $userrow["maxtp"] * 100); $stattable = "<table width=\"100\"><tr><td width=\"33%\">\n"; $stattable .= "<table cellspacing=\"0\" cellpadding=\"0\"><tr><td style=\"padding:0px; width:15px; height:100px; border:solid 1px black; vertical-align:bottom;\">\n"; if ($stathp >= 66) { $stattable .= "<div style=\"padding:0px; height:".$stathp."px; border-top:solid 1px black; background-image:url(images/bars_green.gif);\"><img src=\"images/bars_green.gif\" alt=\"\" /></div>"; } if ($stathp < 66 && $stathp >= 33) { $stattable .= "<div style=\"padding:0px; height:".$stathp."px; border-top:solid 1px black; background-image:url(images/bars_yellow.gif);\"><img src=\"images/bars_yellow.gif\" alt=\"\" /></div>"; } if ($stathp < 33) { $stattable .= "<div style=\"padding:0px; height:".$stathp."px; border-top:solid 1px black; background-image:url(images/bars_red.gif);\"><img src=\"images/bars_red.gif\" alt=\"\" /></div>"; } $stattable .= "</td></tr></table></td><td width=\"33%\">\n"; $stattable .= "<table cellspacing=\"0\" cellpadding=\"0\"><tr><td style=\"padding:0px; width:15px; height:100px; border:solid 1px black; vertical-align:bottom;\">\n"; if ($statmp >= 66) { $stattable .= "<div style=\"padding:0px; height:".$statmp."px; border-top:solid 1px black; background-image:url(images/bars_green.gif);\"><img src=\"images/bars_green.gif\" alt=\"\" /></div>"; } if ($statmp < 66 && $statmp >= 33) { $stattable .= "<div style=\"padding:0px; height:".$statmp."px; border-top:solid 1px black; background-image:url(images/bars_yellow.gif);\"><img src=\"images/bars_yellow.gif\" alt=\"\" /></div>"; } if ($statmp < 33) { $stattable .= "<div style=\"padding:0px; height:".$statmp."px; border-top:solid 1px black; background-image:url(images/bars_red.gif);\"><img src=\"images/bars_red.gif\" alt=\"\" /></div>"; } $stattable .= "</td></tr></table></td><td width=\"33%\">\n"; $stattable .= "<table cellspacing=\"0\" cellpadding=\"0\"><tr><td style=\"padding:0px; width:15px; height:100px; border:solid 1px black; vertical-align:bottom;\">\n"; if ($stattp >= 66) { $stattable .= "<div style=\"padding:0px; height:".$stattp."px; border-top:solid 1px black; background-image:url(images/bars_green.gif);\"><img src=\"images/bars_green.gif\" alt=\"\" /></div>"; } if ($stattp < 66 && $stattp >= 33) { $stattable .= "<div style=\"padding:0px; height:".$stattp."px; border-top:solid 1px black; background-image:url(images/bars_yellow.gif);\"><img src=\"images/bars_yellow.gif\" alt=\"\" /></div>"; } if ($stattp < 33) { $stattable .= "<div style=\"padding:0px; height:".$stattp."px; border-top:solid 1px black; background-image:url(images/bars_red.gif);\"><img src=\"images/bars_red.gif\" alt=\"\" /></div>"; } $stattable .= "</td></tr></table></td>\n"; $stattable .= "</tr><tr><td>HP</td><td>MP</td><td>TP</td></tr></table>\n"; $userrow["statbars"] = $stattable; // Now make numbers stand out if they're low. if ($userrow["currenthp"] <= ($userrow["maxhp"]/5)) { $userrow["currenthp"] = "<blink><span class=\"highlight\"><b>*".$userrow["currenthp"]."*</b></span></blink>"; } if ($userrow["currentmp"] <= ($userrow["maxmp"]/5)) { $userrow["currentmp"] = "<blink><span class=\"highlight\"><b>*".$userrow["currentmp"]."*</b></span></blink>"; } $spellquery = doquery("SELECT id,name,type FROM {{table}}","spells"); $userspells = explode(",",$userrow["spells"]); $userrow["magiclist"] = ""; while ($spellrow = mysql_fetch_array($spellquery)) { $spell = false; foreach($userspells as $a => $b) { if ($b == $spellrow["id"] && $spellrow["type"] == 1) { $spell = true; } } if ($spell == true) { $userrow["magiclist"] .= "<a href=\"index.php?do=spell:".$spellrow["id"]."\">".$spellrow["name"]."</a><br />"; } } if ($userrow["magiclist"] == "") { $userrow["magiclist"] = "None"; } // Travel To list. $townslist = explode(",",$userrow["towns"]); $townquery2 = doquery("SELECT * FROM {{table}} ORDER BY id", "towns"); $userrow["townslist"] = ""; while ($townrow2 = mysql_fetch_array($townquery2)) { $town = false; foreach($townslist as $a => $b) { if ($b == $townrow2["id"]) { $town = true; } } if ($town == true) { if ($townrow2["latitude"] < 0) { $townrow2["latitude"] = $townrow2["latitude"] * -1 . "S"; } else { $townrow2["latitude"] .= "N"; } if ($townrow2["longitude"] < 0) { $townrow2["longitude"] = $townrow2["longitude"] * -1 . "W"; } else { $townrow2["longitude"] .= "E"; } $userrow["townslist"] .= "<a href=\"index.php?do=gotown:".$townrow2["id"]."\">".$townrow2["name"]."</a> [".$townrow2["latitude"].", ".$townrow2["longitude"]."] ".$townrow2["travelpoints"]."<br />\n"; } } } else { $userrow = array(); } $finalarray = array( "dkgamename"=>$controlrow["gamename"], "title"=>$title, "content"=>$content, "rightnav"=>parsetemplate($rightnav,$userrow), "leftnav"=>parsetemplate($leftnav,$userrow), "topnav"=>$topnav, "totaltime"=>round(getmicrotime() - $starttime, 4), "numqueries"=>$numqueries, "version"=>$version, "build"=>$build); $page = parsetemplate($template, $finalarray); $page = $xml . $page; if ($controlrow["compression"] == 1) { ob_start("ob_gzhandler"); } echo $page; die(); } Regards ACE Quote Link to comment Share on other sites More sharing options...
teng84 Posted June 29, 2007 Share Posted June 29, 2007 $xml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n" . "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"DTD/xhtml1-transitional.dtd\">\n" . "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\n"; remove the two dots what was that for??? Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 30, 2007 Author Share Posted June 30, 2007 I dunno.... My game is running on Dragon Knight open source game, so I didn't make it all. just added stuff to it and modded stuff... Quote Link to comment Share on other sites More sharing options...
teng84 Posted June 30, 2007 Share Posted June 30, 2007 $xml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?><!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"DTD/xhtml1-transitional.dtd\"> <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">"; use that and use the long tag <?php ?> instead of <? ?> because you have the xml Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 30, 2007 Author Share Posted June 30, 2007 still no good.... Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 30, 2007 Author Share Posted June 30, 2007 anyone have any other ideas? ??? Regards ACE Quote Link to comment Share on other sites More sharing options...
teng84 Posted June 30, 2007 Share Posted June 30, 2007 give as the error and the complete code that has error Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 30, 2007 Author Share Posted June 30, 2007 heres the error: Parse error: syntax error, unexpected T_STRING in /home/ace/public_html/shadowlords/towns.php on line 11 Line 11: Code: display("<b>Supporter Options:</b><br /> <ul> <li /><a href="index.php?do=sendgold">Send Gold</a> <li /><a href="index.php?do=exchange">Exchange</a> </ul>", "Supporter Options"); display function: Code: function display($content, $title, $topnav=true, $leftnav=true, $rightnav=true, $badstart=false) { // Finalize page and output to browser. global $numqueries, $userrow, $controlrow, $version, $build; if (!isset($controlrow)) { $controlquery = doquery("SELECT * FROM {{table}} WHERE id='1' LIMIT 1", "control"); $controlrow = mysql_fetch_array($controlquery); } if ($badstart == false) { global $starttime; } else { $starttime = $badstart; } // Make page tags for XHTML validation. $xml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n" . "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"DTD/xhtml1-transitional.dtd\">\n" . "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\n"; $template = gettemplate("primary"); if ($rightnav == true) { $rightnav = gettemplate("rightnav"); } else { $rightnav = ""; } if ($leftnav == true) { $leftnav = gettemplate("leftnav"); } else { $leftnav = ""; } if ($topnav == true) { $topnav = "<a href=\"login.php?do=logout\"><img src=\"images/button_logout.gif\" alt=\"Log Out\" title=\"Log Out\" border=\"0\" /></a> <a href=\"help.php\"><img src=\"images/button_help.gif\" alt=\"Help\" title=\"Help\" border=\"0\" /></a>"; } else { $topnav = "<a href=\"login.php?do=login\"><img src=\"images/button_login.gif\" alt=\"Log In\" title=\"Log In\" border=\"0\" /></a> <a href=\"users.php?do=register\"><img src=\"images/button_register.gif\" alt=\"Register\" title=\"Register\" border=\"0\" /></a> <a href=\"help.php\"><img src=\"images/button_help.gif\" alt=\"Help\" title=\"Help\" border=\"0\" /></a>"; } if (isset($userrow)) { // Get userrow again, in case something has been updated. $userquery = doquery("SELECT * FROM {{table}} WHERE id='".$userrow["id"]."' LIMIT 1", "users"); unset($userrow); $userrow = mysql_fetch_array($userquery); // Current town name. if ($userrow["currentaction"] == "In Town") { $townquery = doquery("SELECT * FROM {{table}} WHERE latitude='".$userrow["latitude"]."' AND longitude='".$userrow["longitude"]."' LIMIT 1", "towns"); $townrow = mysql_fetch_array($townquery); $userrow["currenttown"] = "Welcome to <b>".$townrow["name"]."</b>.<br /><br />"; } else { $userrow["currenttown"] = ""; } if ($controlrow["forumtype"] == 0) { $userrow["forumslink"] = ""; } elseif ($controlrow["forumtype"] == 1) { $userrow["forumslink"] = "<a href=\"forum.php\">Forum</a><br />"; } elseif ($controlrow["forumtype"] == 2) { $userrow["forumslink"] = "<a href=\"".$controlrow["forumaddress"]."\">Forum</a><br />"; } // Format various userrow stuffs... if ($userrow["latitude"] < 0) { $userrow["latitude"] = $userrow["latitude"] * -1 . "S"; } else { $userrow["latitude"] .= "N"; } if ($userrow["longitude"] < 0) { $userrow["longitude"] = $userrow["longitude"] * -1 . "W"; } else { $userrow["longitude"] .= "E"; } $userrow["experience"] = number_format($userrow["experience"]); $userrow["gold"] = number_format($userrow["gold"]); if ($userrow["authlevel"] == 1) { $userrow["adminlink"] = "<a href=\"admin.php\">Admin</a><br />"; } else { $userrow["adminlink"] = ""; } //simple exp needed mod.. poorly coded by Anman $levelquery = doquery("SELECT ". $userrow["charclass"]."_exp FROM {{table}} WHERE id='".($userrow["level"]+1)."' LIMIT 1", "levels"); $levelrow = mysql_fetch_array($levelquery); $userrow["nextlevel"] = $levelrow[$userrow["charclass"]."_exp"]; $need = ($userrow["nextlevel"] - $userrow["experience"]); $userrow["expneed"] = $need; // HP/MP/TP bars. $stathp = ceil($userrow["currenthp"] / $userrow["maxhp"] * 100); if ($userrow["maxmp"] != 0) { $statmp = ceil($userrow["currentmp"] / $userrow["maxmp"] * 100); } else { $statmp = 0; } $stattp = ceil($userrow["currenttp"] / $userrow["maxtp"] * 100); $stattable = "<table width=\"100\"><tr><td width=\"33%\">\n"; $stattable .= "<table cellspacing=\"0\" cellpadding=\"0\"><tr><td style=\"padding:0px; width:15px; height:100px; border:solid 1px black; vertical-align:bottom;\">\n"; if ($stathp >= 66) { $stattable .= "<div style=\"padding:0px; height:".$stathp."px; border-top:solid 1px black; background-image:url(images/bars_green.gif);\"><img src=\"images/bars_green.gif\" alt=\"\" /></div>"; } if ($stathp < 66 && $stathp >= 33) { $stattable .= "<div style=\"padding:0px; height:".$stathp."px; border-top:solid 1px black; background-image:url(images/bars_yellow.gif);\"><img src=\"images/bars_yellow.gif\" alt=\"\" /></div>"; } if ($stathp < 33) { $stattable .= "<div style=\"padding:0px; height:".$stathp."px; border-top:solid 1px black; background-image:url(images/bars_red.gif);\"><img src=\"images/bars_red.gif\" alt=\"\" /></div>"; } $stattable .= "</td></tr></table></td><td width=\"33%\">\n"; $stattable .= "<table cellspacing=\"0\" cellpadding=\"0\"><tr><td style=\"padding:0px; width:15px; height:100px; border:solid 1px black; vertical-align:bottom;\">\n"; if ($statmp >= 66) { $stattable .= "<div style=\"padding:0px; height:".$statmp."px; border-top:solid 1px black; background-image:url(images/bars_green.gif);\"><img src=\"images/bars_green.gif\" alt=\"\" /></div>"; } if ($statmp < 66 && $statmp >= 33) { $stattable .= "<div style=\"padding:0px; height:".$statmp."px; border-top:solid 1px black; background-image:url(images/bars_yellow.gif);\"><img src=\"images/bars_yellow.gif\" alt=\"\" /></div>"; } if ($statmp < 33) { $stattable .= "<div style=\"padding:0px; height:".$statmp."px; border-top:solid 1px black; background-image:url(images/bars_red.gif);\"><img src=\"images/bars_red.gif\" alt=\"\" /></div>"; } $stattable .= "</td></tr></table></td><td width=\"33%\">\n"; $stattable .= "<table cellspacing=\"0\" cellpadding=\"0\"><tr><td style=\"padding:0px; width:15px; height:100px; border:solid 1px black; vertical-align:bottom;\">\n"; if ($stattp >= 66) { $stattable .= "<div style=\"padding:0px; height:".$stattp."px; border-top:solid 1px black; background-image:url(images/bars_green.gif);\"><img src=\"images/bars_green.gif\" alt=\"\" /></div>"; } if ($stattp < 66 && $stattp >= 33) { $stattable .= "<div style=\"padding:0px; height:".$stattp."px; border-top:solid 1px black; background-image:url(images/bars_yellow.gif);\"><img src=\"images/bars_yellow.gif\" alt=\"\" /></div>"; } if ($stattp < 33) { $stattable .= "<div style=\"padding:0px; height:".$stattp."px; border-top:solid 1px black; background-image:url(images/bars_red.gif);\"><img src=\"images/bars_red.gif\" alt=\"\" /></div>"; } $stattable .= "</td></tr></table></td>\n"; $stattable .= "</tr><tr><td>HP</td><td>MP</td><td>TP</td></tr></table>\n"; $userrow["statbars"] = $stattable; // Now make numbers stand out if they're low. if ($userrow["currenthp"] <= ($userrow["maxhp"]/5)) { $userrow["currenthp"] = "<blink><span class=\"highlight\"><b>*".$userrow["currenthp"]."*</b></span></blink>"; } if ($userrow["currentmp"] <= ($userrow["maxmp"]/5)) { $userrow["currentmp"] = "<blink><span class=\"highlight\"><b>*".$userrow["currentmp"]."*</b></span></blink>"; } $spellquery = doquery("SELECT id,name,type FROM {{table}}","spells"); $userspells = explode(",",$userrow["spells"]); $userrow["magiclist"] = ""; while ($spellrow = mysql_fetch_array($spellquery)) { $spell = false; foreach($userspells as $a => $b) { if ($b == $spellrow["id"] && $spellrow["type"] == 1) { $spell = true; } } if ($spell == true) { $userrow["magiclist"] .= "<a href=\"index.php?do=spell:".$spellrow["id"]."\">".$spellrow["name"]."</a><br />"; } } if ($userrow["magiclist"] == "") { $userrow["magiclist"] = "None"; } // Travel To list. $townslist = explode(",",$userrow["towns"]); $townquery2 = doquery("SELECT * FROM {{table}} ORDER BY id", "towns"); $userrow["townslist"] = ""; while ($townrow2 = mysql_fetch_array($townquery2)) { $town = false; foreach($townslist as $a => $b) { if ($b == $townrow2["id"]) { $town = true; } } if ($town == true) { if ($townrow2["latitude"] < 0) { $townrow2["latitude"] = $townrow2["latitude"] * -1 . "S"; } else { $townrow2["latitude"] .= "N"; } if ($townrow2["longitude"] < 0) { $townrow2["longitude"] = $townrow2["longitude"] * -1 . "W"; } else { $townrow2["longitude"] .= "E"; } $userrow["townslist"] .= "<a href=\"index.php?do=gotown:".$townrow2["id"]."\">".$townrow2["name"]."</a> [".$townrow2["latitude"].", ".$townrow2["longitude"]."] ".$townrow2["travelpoints"]."<br />\n"; } } } else { $userrow = array(); } $finalarray = array( "dkgamename"=>$controlrow["gamename"], "title"=>$title, "content"=>$content, "rightnav"=>parsetemplate($rightnav,$userrow), "leftnav"=>parsetemplate($leftnav,$userrow), "topnav"=>$topnav, "totaltime"=>round(getmicrotime() - $starttime, 4), "numqueries"=>$numqueries, "version"=>$version, "build"=>$build); $page = parsetemplate($template, $finalarray); $page = $xml . $page; if ($controlrow["compression"] == 1) { ob_start("ob_gzhandler"); } echo $page; die(); } Regards ACE Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 30, 2007 Author Share Posted June 30, 2007 I've tried this: <?php // href links $sendgoldd = "index.php?do=sendgold"; $exchangee = "index.php?do=exchange"; if($authlevelquery == 3){ $page = "<b>Supporter Options:</b><br />" . "<ul>" . "<li /><a href=".<?=$sendgoldd?>.">Send Gold</a>" . "<li /><a href=".<?=$exchangee?>.">Exchange</a>" . "</ul>"; } ?> and that gives me an error on this line: . "<li /><a href=".<?=$sendgoldd?>.">Send Gold</a>" Regards ACE Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted June 30, 2007 Share Posted June 30, 2007 Change the code to this: <?php // href links $sendgoldd = "index.php?do=sendgold"; $exchangee = "index.php?do=exchange"; if($authlevelquery == 3){ $page = "<b>Supporter Options:</b><br />" . "<ul>" . "<li /><a href=".$sendgoldd.">Send Gold</a>" . "<li /><a href=".$exchangee.">Exchange</a>" . "</ul>"; } ?> Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted June 30, 2007 Author Share Posted June 30, 2007 Excellant!!! That did it! Thanks pocobueno1388 and thankyou to everyone else that helped!!! Much appreciated Regards ACE Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.