Hello.
To start off with i know very little about php and mysql some but not enough to know enough to resolve problems of any kind.
Ok at the house here we have some individuals playing Lineage 2.
We wanted to set up our own fansite for the game as some of the data out on the web is a bit out dated with all the updates going on. That being said we have located one of the original database suppliers for the web for this game his name is duncan. He is sharing his data to anyone who wants to use it. Most of the web sites out on the web are useing his platform in one form or another. Though they have there own professional coders that are modifying the db or php pages to suit there own needs. That is all fine and good. I can understand why they will not share there codeing.
My problem is it seems that his php pages that he has supplied are for a different database other then mysql.
So how do i convert his php pages to use mysql instead of pg.
If i can get one page working i can get the others to do so. Also so can someone give me a hand in changing the php pages to use mysql there are two pages invloved one is the template page to connect to the db
the other is a page to view the data you want.
Below are the two pages first will be the page to connect to the db the will follow the other page
Page 1
<?php
function l2dp_header()
{
global $l2dp_lang;
if ( isset( $_GET['language'] ) )
{
setcookie( 'language', '', time()-3600, '/' );
setcookie( 'language', $_GET['language'], time()+3600*24*30, '/' );
$l2dp_lang = $_GET['language'];
}
else
{
if ( ( isset( $_COOKIE['language'] ) )
&& ( strlen( $_COOKIE['language'] ) == 2 ) )
{
$l2dp_lang = $_COOKIE['language'];
}
else
{
setcookie( 'language', '', time()-3600, '/' );
setcookie( 'language', 'en', time()+3600*24*30, '/' );
$l2dp_lang = 'en';
}
}
echo <<<EOD
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-US">
<head>
<META http-equiv=Content-Type content="text/html; charset=UTF-8">
<LINK href="l2dp.css" rel="stylesheet" type="text/css"/>
EOD;
}
function l2dp_body()
{
echo "</head>\n";
echo "<body bgcolor=\"#FFFFFF\" text=\"#000000\" link=\"#0000FF\"";
echo " vlink=\"#FF00FF\" alink=\"#FF0000\">\n";
if ( strstr( $_SERVER['REQUEST_URI'], '?' ) )
{
$base = $_SERVER['REQUEST_URI'] . '&';
}
else
{
$base = $_SERVER['REQUEST_URI'] . '?';
}
echo "<table border=0 width=100%><tr><td>";
echo "<a href=\"index.php\">[home]</a>";
echo "<td align=right><a href=\"" . $base . "language=en\">English</a> - ";
echo "<a href=\"" . $base . "language=kr\">Korean</a> - ";
echo "<a href=\"" . $base . "language=jp\">Japanese</a> - ";
echo "<a href=\"" . $base . "language=tw\">Taiwan</a> - ";
echo "<a href=\"" . $base . "language=cn\">China</a></td></tr><table><br>\n";
echo "<table width=740 border=0 cellpadding=0 cellspacing=0>";
echo "<tr><td width=\"100%\">\n\n";
}
function l2dp_footer()
{
echo "</td></tr></table><p>"
. "<a href=\"http://www.mithral.com/~beberg/L2DP/\">L2DP</a> data from "
. gmdate('Y-M-d H:i:s \U\T\C', time() ) . "</p>\n";
echo "</body></html>";
}
function l2dp_connect( $database )
{
// PostgreSQL version
return pg_connect( "host=localhost user=username dbname=$database" );
// MySQL version
//$c = mysql_connect( "localhost", "user", "password" );
//mysql_select_db( $database );
//return $c;
}
function l2dp_disconnect( $db_conn )
{
pg_close( $db_conn );
}
?>
Page 2
<?php
require 'L2DP.php';
l2dp_header();
echo "<title>L2DP - Monsters</title>";
l2dp_body();
$dbc = l2dp_connect( "l2" );
if ( isset( $_REQUEST['id'] ) )
{ $id = $_REQUEST['id']; }
if ( isset( $_REQUEST['lo'] ) )
{ $lo = $_REQUEST['lo']; }
if ( isset( $_REQUEST['hi'] ) )
{ $hi = $_REQUEST['hi']; }
if ( isset( $_REQUEST['type'] ) )
{ $type = $_REQUEST['type']; }
// Abilities:
// s_floating_target - Flying (extra damage from arrows)
// s_burning_wood - Plant (extra damage from fire/arrows?)
// s_unholy - Unholy/Undead (extra damage from holy)
// s_golem_body - Golem skin (reduced damage from arrows/daggers)
// s_soft_bones - Skeletal (extra damage from blunts)
// s_insect_skin - Insect property
// s_wind_feature - Wind property
// s_water_feature - Water property
// s_fire_feature - Fire property
// s_rg_ant_body - Royal Guard only body (not sure what it does)
// s_queen_ant_body - Queen ant only body (not sure what it does)
// s_full_magic_defence - Guessing NPC only, immune to magic
if ( !isset( $id ) )
{
if ( isset( $type ) && $type == 'unknown' )
{
$sql = "SELECT DISTINCT M.id, M.name, M.level, M.aggro, M.hp, M.mp,
M.exp, M.sp, M.npc, M.attack_range, N.title, N.name as name_lang
FROM Monsters as M
LEFT JOIN NpcNames as N
ON ( M.id = N.id AND N.language = '$l2dp_lang' )
WHERE ( M.npc IS NULL OR ( M.npc = 0 AND ( M.level IS NULL ) ) )
ORDER BY N.name;";
echo "<h3>Monsters - Unknown Level or NPC status</b></h3>";
}
elseif ( isset( $type ) && $type == 'undead' )
{
$sql = "SELECT DISTINCT M.id, M.name, M.level, M.aggro, M.hp, M.mp,
M.exp, M.sp, M.npc, M.attack_range, N.title, N.name as name_lang
FROM Monsters as M
LEFT JOIN NpcNames as N
ON ( M.id = N.id AND N.language = '$l2dp_lang' )
WHERE abilities LIKE '%s_unholy%'
ORDER BY level, N.name;";
echo "<h3>Monsters - Undead</b></h3>";
}
else
{
if ( !isset($hi) && !isset($lo) )
{
$lo = 1; $hi = 10;
}
$sql = "SELECT DISTINCT M.id, M.name, M.level, M.aggro, M.hp, M.mp,
M.exp, M.sp, M.npc, M.attack_range, N.title, N.name as name_lang
FROM Monsters as M
LEFT JOIN NpcNames as N
ON ( M.id = N.id AND N.language = '$l2dp_lang' )
WHERE M.level >= $lo AND M.level <= $hi AND M.npc = 0
ORDER BY level, N.name;";
echo "<h3>Monsters - Level: ".$lo." - ".$hi."</h3>";
}
echo '<table border="1" cellpadding="3" cellspacing="0" width="100%">
<tr><th>Name<th>Lvl<th>Attitude<th>HP<th>MP<th>Exp <th>SP<th>Attack Range</tr>';
//echo "<pre>", $sql, "</pre>";
$result = mysql_query( $sql );
while ( $mob = mysql_fetch_array( $result ) )
{
{ $name = $mob['name_lang'];
}
if ( strlen( $mob['title'] ) > 0 )
{
$name = $mob['title'] . " " . $name;
}
if ( ( preg_match( "/_hold$/", $mob['name'] ) )
|| ( preg_match( "/^h_/", $mob['name'] ) )
|| ( preg_match( "/^b02_/", $mob['name'] ) ) )
{
$name = $name . " B";
}
$id = $mob['id'];
if ( $mob['level'] > 0 )
{ $lvl = $mob['level']; }
else
{ $lvl = '?'; }
if ($mob['hp'] > 0)
{ $hp = number_format($mob['hp']); }
else
{ $hp = '?'; }
if ($mob['mp'] > 0)
{ $mp = number_format($mob['mp']); }
else
{ $mp = '?'; }
if ($mob['exp'] > 0)
{ $exp = number_format($mob['exp']); }
else
{ $exp = '?'; }
if ($mob['sp'] > 0)
{ $sp = number_format($mob['sp']); }
else
{ $sp = '?'; }
if ( $mob['aggro'] == '1' )
{ $atype = "Aggressive"; }
elseif ( $mob['aggro'] == '0' )
{ $atype = "Passive"; }
else
{ $atype = '?'; }
if ( $mob['attack_range'] > 0 )
{ $arange = $mob['attack_range']; }
else
{ $arange = '?'; }
echo "<tr><td align=left><a href=monsters.php?id=$id>$name</a>"
. "<td align=center>$lvl<td align=center>$atype<td align=center>$hp"
. "<td align=center>$mp<td align=center>$exp<td align=center>$sp"
. "<td align=center>$arange</tr>\n";
}
echo "</table>";
}
else
{
// have an id
$sql = "SELECT DISTINCT M.id, M.name, M.level, M.aggro, M.hp, M.mp,
M.exp, M.sp, M.phys_attack, M.phys_def, M.magic_attack, M.magic_def,
M.align, M.attack_range, N.name as name_lang
FROM Monsters AS M
LEFT JOIN NpcNames as N
ON ( M.id = N.id AND N.language = '$l2dp_lang' )
WHERE M.id = $id;";
//echo "<pre>", $sql, "</pre>";
$result = mysql_query( $dbc, $sql );
$mob = mysql_fetch_array( $result );
$name = $mob['name_lang'];
$id = $mob['id'];
if ( $mob['level'] > 0 )
{ $lvl = $mob['level']; }
else
{ $lvl = '?'; }
if ($mob['hp'] > 0)
{ $hp = number_format($mob['hp']); }
else
{ $hp = '?'; }
if ($mob['mp'] > 0)
{ $mp = number_format($mob['mp']); }
else
{ $mp = '?'; }
if ($mob['exp'] > 0)
{ $exp = number_format($mob['exp']); }
else
{ $exp = '?'; }
if ($mob['sp'] > 0)
{ $sp = number_format($mob['sp']); }
else
{ $sp = '?'; }
if ( $mob['aggro'] == '1' )
{ $atype = "Aggressive"; }
elseif ( $mob['aggro'] == '0' )
{ $atype = "Passive"; }
else
{ $atype = '?'; }
if ($mob['phys_attack'] > 0)
{ $patk = $mob['phys_attack']; }
else
{ $patk = '?'; }
if ($mob['phys_def'] > 0)
{ $pdef = $mob['phys_def']; }
else
{ $pdef = '?'; }
if ($mob['magic_attack'] > 0)
{ $matk = $mob['magic_attack']; }
else
{ $matk = '?'; }
if ($mob['magic_def'] > 0)
{ $mdef = $mob['magic_def']; }
else
{ $mdef = '?'; }
if ($mob['align'] != 0)
{ $align = $mob['align']; }
else
{ $align = '?'; }
if ( $mob['attack_range'] > 0 )
{ $arange = $mob['attack_range']; }
else
{ $arange = '?'; }
echo '<table border="1" cellpadding="3" cellspacing="0" width="100%">
<tr>
<td colspan=4 align=center><b>Monster</b>
<td align=center><b>Lvl</b>
<td align=center><b>Attitude</b>
<td align=center><b>HP</b>
<td align=center><b>MP</b>
</tr>';
echo "<tr>
<td colspan=4 align=center>$name
<td align=center>$lvl
<td align=center>$atype
<td align=center>$hp
<td align=center>$mp
</tr>";
echo '<tr>
<td align=center><b>P.Atk</b>
<td align=center><b>P.Def</b>
<td align=center><b>M.Atk</b>
<td align=center><b>M.Def</b>
<td align=center><b>Exp</b>
<td align=center><b>SP</b>
<td align=center><b>Align</b>
<td align=center><b>Atk Range</b>
</tr>';
echo "<tr><td align=center>$patk
<td align=center>$pdef
<td align=center>$matk
<td align=center>$mdef
<td align=center>$exp
<td align=center>$sp
<td align=center>$align
<td align=center>$arange</tr>";
echo "<tr><td colspan=8><b>Drops:</b><br>";
$sql = "SELECT D.min, D.max, D.sweep, D.percentage, I.id, N.name
FROM Drops as D
JOIN Items as I
ON ( D.npc_id = $id AND I.id = D.item_id )
LEFT JOIN ItemNames as N
ON ( N.language = '$l2dp_lang' AND I.id = N.id )
ORDER BY D.sweep, D.percentage DESC;";
//echo "<pre>" . $sql . "</pre>";
$result = mysql_query( $dbc, $sql );
$swept = 0;
while ( $drop = mysql_fetch_array( $result ) )
{
if ( $drop['sweep'] == 1 )
{
if ( $swept == 0 )
{
echo '<br><br><b>Sweep:</b><br>';
$swept = 1;
}
echo '<a href="item.php?id=' . $drop['id'] . '">'
. $drop['name'] . '</a>'
. ' (' . $drop['percentage'] . '%) ';
}
else
{
if ( $drop['min'] != $drop['max'] )
{
echo '<a href="item.php?id=' . $drop['id'] . '">'
. $drop['name'] . '</a>'
. ' [' . $drop['min'] . '-' . $drop['max'] . ']'
. ' (' . $drop['percentage'] . '%), ';
}
else
{
echo '<a href="item.php?id=' . $drop['id'] . '">'
. $drop['name'] . '</a>'
. ' (' . $drop['percentage'] . '%), ';
}
}
}
echo "</tr></table>";
}
l2dp_disconnect( $dbc );
l2dp_footer();
?>
Thx for the help by the way.
Linear Mode
