Hello, i have a problem, i change the time of the next sieges in the DB (mysql), in the console and in the npc to register for the siege both have the same data that i put in the db so it's ok, but in in the website in the castle section it have a different time for the sieges, what i should change to it have the same data like in the DB and in the console and npc?...
here is a image:
and the website castle section code:
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php include("config.php");?>
<title>Untitled Document</title>
<link href="css/css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="content">
<div id="textbox">
<div id="pagetitle">Castle Siege of L2<?php print ("$servername");?></div>
<p> </p>
<center>
<table width="500px" border="0" align="center">
<tr class="rowt" align="center" height="25">
<td>Castle:</td>
<td>Clan:</td>
<td>Lord Castle:</td>
<td>Alliance:</td>
<td>Next Siege:</td>
</tr>
<?php
//Script de Top Pk.
//Script Desenvolvido por: Jonatha ferreira.
//Email: jonathaferreira@live.com.
$db['servidor'] = "localhost";//Nome do servidor
$db['usuario_mysql'] = "root";// Usuario do mysql
$db['senha_mysql'] = "root";//Senha do mysql
$db['banco_de_dados'] = "l2jdb";//Nome d banco de dados
$open = mysql_connect($db['servidor'], $db['usuario_mysql'], $db['senha_mysql']) or die("Não foi possível conectar-se à database.");
$select_db = mysql_select_db($db['banco_de_dados'], $open) or die("Database não encontrada ou inexistente.");
$sql = mysql_query("SELECT * FROM castle ORDER BY name") or die(mysql_error());
$cor = 0;
while($c = mysql_fetch_array($sql)) {
$cor = $cor + 1;
$bg = $cor % 2 == 0 ? '#F1F1F1' : '#FFFFFF';
$cl = mysql_query("SELECT * FROM clan_data WHERE hasCastle = '".$c['id']."'") or die(mysql_error());
$clan = mysql_fetch_array($cl);
$l = mysql_query("SELECT * FROM characters WHERE obj_id = '".$clan['leader_id']."'") or die(mysql_error());
$lord = mysql_fetch_array($l);
?>
<tr bgcolor="<?php echo $bg; ?>" class="style8" align="center" height="23">
<td><a style="color:#000;text-decoration:none;" href="#" class="tooltip" ><span><font color="#FF9900"><?php echo $c['name'];?></font><br />
</span> </a></td>
<td><?php echo !empty($clan['clan_name']) ? $clan['clan_name'] : "No Clan"; ?></td>
<td><?php echo !empty($lord['char_name']) ? $lord['char_name'] : "No Lord"; ?></td>
<td><?php echo !empty($clan['ally_name']) ? $clan['ally_name'] : "No Ally"; ?></td>
<td><?php echo @date('D\, j M Y H\:i',$c['siegeDate']/1000); ?></td>
</tr>
<?php
}
?>
</table>
<p> </p>
</center>
</div>
</div>
</body>
</html>
Selling interface source for newest client update rose vain p520 + wolf p509 (LAST UPDATE)
SYSTEM SERVER TEST
600$ (P520)
400$ (P509)
includes:
- NWindow
- L2 Editor
- DAT Editor
- Client+System clean
- Interface sources
- XDat Editor
ALL FEATURES ARE ONLY AVAILABLE IN THE P520 INTERFACE SOURCE
The P509 interface is retail.
ALL FEATURES ON P520
AUTOHUNT IMPROVED
GUARANTEED SYSTEM
AUTO-COMPOUND
MASS ENCHANT IMPROVED
ALL AVAILABLE SKILL LEARN
AUTO RANDOM CRAFT
SHORTCUT IMPROVED
It is, kind of. Only invited participants have the links. Sorry but not sorry, this forum is dead for ages, so blame whoever you wish to blame. Cheers.
have played many years ago excited to play again on launch. i have seen wonderful things about the server it looks how it should be theres hard work and it shows. it lives up to the glory days of l2 elixir.
I wish the best of luck for the project i will be playing actively!
Question
charliedvm
Hello, i have a problem, i change the time of the next sieges in the DB (mysql), in the console and in the npc to register for the siege both have the same data that i put in the db so it's ok, but in in the website in the castle section it have a different time for the sieges, what i should change to it have the same data like in the DB and in the console and npc?...
here is a image:
and the website castle section code:
<!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <?php include("config.php");?> <title>Untitled Document</title> <link href="css/css.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="content"> <div id="textbox"> <div id="pagetitle">Castle Siege of L2<?php print ("$servername");?></div> <p> </p> <center> <table width="500px" border="0" align="center"> <tr class="rowt" align="center" height="25"> <td>Castle:</td> <td>Clan:</td> <td>Lord Castle:</td> <td>Alliance:</td> <td>Next Siege:</td> </tr> <?php //Script de Top Pk. //Script Desenvolvido por: Jonatha ferreira. //Email: jonathaferreira@live.com. $db['servidor'] = "localhost";//Nome do servidor $db['usuario_mysql'] = "root";// Usuario do mysql $db['senha_mysql'] = "root";//Senha do mysql $db['banco_de_dados'] = "l2jdb";//Nome d banco de dados $open = mysql_connect($db['servidor'], $db['usuario_mysql'], $db['senha_mysql']) or die("Não foi possível conectar-se à database."); $select_db = mysql_select_db($db['banco_de_dados'], $open) or die("Database não encontrada ou inexistente."); $sql = mysql_query("SELECT * FROM castle ORDER BY name") or die(mysql_error()); $cor = 0; while($c = mysql_fetch_array($sql)) { $cor = $cor + 1; $bg = $cor % 2 == 0 ? '#F1F1F1' : '#FFFFFF'; $cl = mysql_query("SELECT * FROM clan_data WHERE hasCastle = '".$c['id']."'") or die(mysql_error()); $clan = mysql_fetch_array($cl); $l = mysql_query("SELECT * FROM characters WHERE obj_id = '".$clan['leader_id']."'") or die(mysql_error()); $lord = mysql_fetch_array($l); ?> <tr bgcolor="<?php echo $bg; ?>" class="style8" align="center" height="23"> <td><a style="color:#000;text-decoration:none;" href="#" class="tooltip" ><span><font color="#FF9900"><?php echo $c['name'];?></font><br /> </span> </a></td> <td><?php echo !empty($clan['clan_name']) ? $clan['clan_name'] : "No Clan"; ?></td> <td><?php echo !empty($lord['char_name']) ? $lord['char_name'] : "No Lord"; ?></td> <td><?php echo !empty($clan['ally_name']) ? $clan['ally_name'] : "No Ally"; ?></td> <td><?php echo @date('D\, j M Y H\:i',$c['siegeDate']/1000); ?></td> </tr> <?php } ?> </table> <p> </p> </center> </div> </div> </body> </html>3 answers to this question
Recommended Posts