Jump to content
  • 0

[help] Web ERROR PHP


Question

Posted

i just made my website and i have few php scripts..... for top pvp/pk/ clan.... and ACM

 

so problem is this...  when i try looking  at TOP pvp/pk/clan or ACM i got error as my browser cannot connect..  in my database design for table Characters/Accounts for acces level is   "acceslevel" and in php script is "acces_Level"

 

so i got error to connect to site when i change in PHP script "acces_Level" into "acceslevel"

 

i try design my table - so i design my table in acces_level but i got error too

 

so when in php script acces_level is same as in database i get error  " cannot connect to website "  is the error as when you try to connect to a webpage and u dont have internet.....

 

anyone can help me ?   i really dont know what to do :<

 

i host the site on my computer i using WAMPSERVER

9 answers to this question

Recommended Posts

  • 0
Posted

this is page for TOP 10 PLAYERS

 

 

scripts for TOP players/pvp/pk and account manager i took from this forum

 

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="eng" xml:lang="eng">
<head>

<title>Lineage ][ World</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<meta name="description" content="L2 World" />

<meta name="keywords" content="L2, Lineage, Epilogue, World, PvP" />
<meta name="generator" content="DataLife Engine (http://l2world.no-ip.info/)" />
<meta name="robots" content="all" />
<meta name="revisit-after" content="1 days" />
<link rel="search" type="application/opensearchdescription+xml" href="engine/opensearch.php" title=".:L2 World:. - Private Lineage 2 Epilogue Server" />
<link rel="alternate" type="application/rss+xml" title=".:L2 World:. - Private Lineage 2 Epilogue Server" href="rss.xml" />
<script type="text/javascript" src="templates/l2/js/thickbox.html"></script>
<script type="text/javascript" src="templates/l2/js/jquery.html"></script>
<script type="text/javascript" src="templates/l2/js/jquery.scrollTo-min.html"></script>
<script type="text/javascript" src="templates/l2/js/init.html"></script>
<script language="javascript" type="text/javascript" src="templates/l2/js/dtrotator.html"></script>
<script type="text/javascript">
		$(document).ready(function() {
			VerticalDoWidthElevator();
			MoreLessElevator();
			}
		);
</script>
<link rel="shortcut icon" href="templates/l2/images/favicon.png"/>
<link rel="stylesheet" type="text/css" href="templates/l2/css/aionic_css.css" />
<style type="text/css">
</style>
</head>
<script type="text/javascript" src="engine/ajax/menu.js"></script>
<script type="text/javascript" src="engine/ajax/dle_ajax.js"></script>
<div id="loading-layer" style="display:none;font-family: Verdana;font-size: 11px;width:200px;height:50px;background:#FFF;padding:10px;text-align:center;border:1px solid #000">
<div style="font-weight:bold" id="loading-layer-text">Loading: Please Wait...</div><br />
<img src="engine/ajax/loading.gif"  border="0" alt="" /></div>
<div id="busy_layer" style="visibility: hidden; display: block; position: absolute; left: 0px; top: 0px; width: 100%; height: 100%; background-color: gray; opacity: 0.1; -ms-filter: 'progid:DXImageTransform.Microsoft.Alpha(Opacity=10)'; filter:progid:DXImageTransform.Microsoft.Alpha(opacity=10); "></div>
<script type="text/javascript" src="engine/ajax/js_edit.js"></script>
<div id="container-wrapper" align="center">

	<div id="container" align="left">
		<div id="header">

			<div id="logo"><h1><a href="index.php" title="L2 World - Where you always are welcome"><span>L2 World - Where you always are welcome</span></a></h1></div>

		</div>
<div id="VerticalStage2DownDockicon2" class="transitionVerticalStage3"></div>
<div id="VerticalStage2DownDockicon3" class="transitionVerticalStage3"></div>
		<div id="menu">
					<div class="module">
		<div>
			<div>
				<div>
					<ul id="mainlevel-nav"><li>
<?php include "templates/l2/bars/menu.php" ?>
</ul>					</div>
			</div>
		</div>
	</div>
				</div>
		<div class="cornice-top">
		</div>
		<div class="colmask threecol">
			<div class="colmid">
				<div class="colleft">
					<div class="col1">
						<!-- Column 1 start -->
<!-- Column 1 start -->
				<div class="green_module">
							<div>
								<div>
									<div>
												<table cellpadding="0" cellspacing="0" class="moduletable">
			<tr>
		<td>
<div id='dle-info'></div>
<div id='dle-content'><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr>
<center>
<h2>Top 10 Active Players</h2><br>
<?php 

function connect() 
{ 
include "config/stats.php";
}

$sexes = array('Male', 'Famale'); 
$online = array('0' => "<font color=#FF0000><b>OFFLINE</b></font>", '1' => "<font color=#035922><b>ONLINE</b></font>");
$klan = array('0' => "No Clan"); 

$FORM = "" ; 
$query_chars = "select char_name,level,sex,classid,onlinetime from characters WHERE access_level=0 AND onlinetime >= 1 order by onlinetime desc limit 10;"; 
connect(); 
$link = mysql_query($query_chars); 
$i=1; 
$r=255; 
while ( $row=mysql_fetch_row($link) ) 
{ 
   $timer2=$row[4]/1000;
   $datetime2  = gmstrftime("%d.%m.%Y v %H:%M:%S", $timer2);
   $query = "select classname from char_templates where classid=$row[3]"; 
   $link2 = mysql_query($query); 
   $class = mysql_fetch_row($link2); 

   $FORM .= "<table><tr> 
   <td align=center><font color=#808080><b>  $i.</b></span></td>
   <td align=center><font color=#AE5C08>  $row[0]</td>
   <td align=center><font color=#808080><b>  Sex:</b></td>
   <td align=center><font color=#AE5C08>  ".$sexes[$row[2]]."</font></td>
   <td align=center><font color=#808080><b>  Class:</b></td>
   <td align=center><font color=#AE5C08>  ".$class[0]."</font></td><br>
   </tr></table>"; 
   $i++; 
   $r -= 0; 
}  

mysql_close(); 

echo $FORM; 

?>
<table>
<br>
<img src="templates/l2/images/line.png"><br>
</center>
</div>
</div></div></div></div>
					<div class="clearing"></div>
					<div class="post-rating"><div class="rating" style="float:left;">
	<ul class="unit-rating">
	<li class="current-rating" style="width:51px;">51</li>
	</ul>
</div></div>
<br>
<br>
		</div>
</table>
</div>
</td>
	</tr>
	</table>
											</div>
								</div>
							</div>
						</div>
						<!-- Column 1 end -->
					</div>					
					<div class="col2">
						<!-- Column 2 start -->
								<div class="module" id="module">
		<div>
			<div>
				<div>
					<h3>Statistics</h3>
<?php include "templates/l2/bars/statistic.php" ?>
</div>
			</div>
		</div>
	</div>
			<div class="module" id="module">
		<div>
			<div>
				<div>
					<h3>Server Status</h3>
                           <tr>
<td colspan="3">
<?php include "templates/l2/bars/status.php" ?>
</td>
                           </tr>

</p>
				</div>
			</div>
		</div>
			</div>
					</div>
					<div class="col3">
						<!-- Column 3 start -->
								<div class="module">
		<div>
			<div>
				<div align="left">
					<h3>Server Statistic</h3>
<?php include "templates/l2/bars/server_statistic.php" ?>
				</div>
			</div>
		</div>
	</div>					
			<div class="module">
		<div>
			<div>
				<div>
					<h3>Vote For Us</h3>
<?php include "templates/l2/bars/vote.php" ?>
					</div>
			</div>
		</div>
	</div>
								<!-- Column 3 end -->
					 </div>
				</div>
			</div>
		</div>
		<div class="cornice-bottom">
		</center>
<br><br><br>
		<div id="footer" align="center"><br/>
<script  type="text/javascript">
<br>
<img src="templates/l2/images/copyright.png">
		</div>
	</div>
</div>
</body>
</html>

 

 

  • 0
Posted
This is not a php error

 

if it was php error it would look like this

 

Parse error: syntax error, unexpected T_STRING in C:\AppServ\www\xampp\test\redrosid\index.php  on line 112

  • 0
Posted

yes but how i told u, if i fix error php i cannot connect to site....   and i use wampserver not xampp :P

 

if i leave the site with error i can view the site but phpshowme error  "cannot find access_level column"  cause my colum in DB is "acceslevel" so i do these changes and i got error how u sw on printscreen....   cannot connect.... do you know why?

  • 0
Posted

that can be because my Wampserver doesent start MySQL service ??? but i have install manualy MySQL service for l2j server

  • 0
Posted

Problem solved .... i uninstall wampserver and i installed xampp and now it works well

thank you very much to all who tried help me ! :)

Guest
This topic is now closed to further replies.
×
×
  • Create New...