The PHP script bash did is wrong no offense bro.
i took the liberty to edit it and make it better and more accurate here is the result:
.php
PHP:
<body bgcolor="#161616">
<font color=white>
<?
$DBHost = "local-host"; // ip
$DBUser = "my-username"; //user
$DBPassword = "my-pass"; //pass
$DBName = "dbo"; //database
$Link = MySQL_Connect($DBHost, $DBUser, $DBPassword) or die ("Can't connect to MySQL");
MySQL_Select_Db($DBName, $Link) or die ("Database ".$DBName." do not exists.");
$query="SELECT killerid, COUNT(killerid) AS ckills FROM kills GROUP BY killerid HAVING ( COUNT(killerid) > 0 )";
$result=mysql_query($query);
$querydeaths="SELECT corpseid, COUNT(corpseid) AS cdeaths FROM kills GROUP BY corpseid HAVING ( COUNT(corpseid) > 0 )";
$resultdeaths=mysql_query($querydeaths);
$num=mysql_num_rows($result);
$i=0;
while ($i < $num) {
// get killer-id
$PlayerName=mysql_result($result,$i,"killerid");
//get kills result
$ckills=mysql_result($result,$i,"ckills");
//get deaths result
$cdeaths=mysql_result($resultdeaths,$i,"cdeaths");
$SearchifexistQuery = Mysql_Query("SELECT kills,deaths FROM pkrank WHERE userid = '$PlayerName'");
$SearchifexistNum = Mysql_Num_Rows($SearchifexistQuery);
IF ($SearchifexistNum == 1 OR $SearchifexistNum > 1) {
$SearchifexistFetch = Mysql_Fetch_Array($SearchifexistQuery);
$CharacterKills = $SearchifexistFetch['kills'];
$Characterdeaths = $SearchifexistFetch['deaths'];
$NewCharacterKills = $CharacterKills + $ckills;
$NewCharacterdeaths = $Characterdeaths + $cdeaths;
Mysql_Query("UPDATE pkrank SET kills = '$NewCharacterKills' WHERE userid = '$PlayerName'");
Mysql_Query("UPDATE pkrank SET deaths = '$NewCharacterdeaths' WHERE userid = '$PlayerName'");
}
ELSE {
Mysql_Query("INSERT INTO pkrank (userid, name, clasa, level, kills, reputation, deaths, gender) VALUES ('$PlayerName', 'Upcoming...', 'Upcoming...', '1', '1' , '1', '1', 'Upcoming...')");
}
$i++;
}
echo "Successfully Updated Tables!<br>";
//delete table
Mysql_Query("DELETE FROM kills");
//close connection
mysql_close($Link);
?>
.jsp
PHP:
<%@page import="java.sql.*"%>
<%@page import="protocol.*"%>
<%@page import="java.io.*"%>
<%@page import="java.text.*"%>
<%@page import="org.apache.commons.logging.LogFactory"%>
<%@page import="java.util.Iterator"%>
<%@page import="com.goldhuman.Common.Octets"%>
<%@page import="com.goldhuman.IO.Protocol.Rpc.Data.DataVector"%>
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@ page language="java" import="java.sql.*" errorPage="" %>
<%
Connection connection = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost/dbo","root", "password");
ResultSet rst = null;
RoleBean role = null;
String tempplayername = null;
int count = 0;
int level = 0;
int rep = 0;
String cls = null;
String gender = null;
PreparedStatement UpdateInfo = null;
try {
Statement statement = connection.createStatement();
rst = statement.executeQuery("SELECT userid FROM pkrank ORDER BY kills DESC");
int index = 0;
while (rst.next())
{
//Prepare Statement
UpdateInfo = connection.prepareStatement("UPDATE pkrank SET name=?, clasa=?, level=?, reputation=?, gender=? WHERE userid=?");
int roleid = rst.getInt("userid");
role = GameDB.get( roleid );
if (null == role)
{
}
else
{
try{
tempplayername = null;
tempplayername = StringEscapeUtils.escapeHtml(role.base.name.getString());
index = 0;
index = tempplayername.indexOf("'");
StringBuffer playername = new StringBuffer(tempplayername);
if(index > 0)
{
playername.replace(index, index + 1, "?");
}
switch(role.base.cls)
{
case 0: cls = "Warrior"; break;
case 1: cls = "Mage"; break;
case 2: cls = "Monk"; break;
case 3: cls = "WereFox"; break;
case 4: cls = "WereBeast"; break;
case 5: cls = "Genie"; break;
case 6: cls = "Archer"; break;
case 7: cls = "Priest"; break;
default: cls = "Unknown";
}
level = role.status.level;
rep = role.status.reputation;
gender = (role.base.gender == 0) ? "Male" : "Female";
}
catch (Exception e)
{
continue;
}
}
UpdateInfo.setString(1, tempplayername);
UpdateInfo.setString(2, cls);
UpdateInfo.setInt(3, level);
UpdateInfo.setInt(4, rep);
UpdateInfo.setString(5, gender);
UpdateInfo.setInt(6, roleid);
UpdateInfo.executeUpdate();
count++;
}
}
catch (Exception e)
{
out.println("<font color=red>Error Occured But System Added <b>" + count + "</b> Characters.<br>");
out.println(e);
}
if (count > 0) {
out.println("<font color=green><br>Complete Updated: <b>" + count + "</b> Characters.<br><br>");
}
else
{
out.println("<br><font color=red>No Characters available to add!");
}
try{
if(connection!=null){
connection.close();
}
if(rst!=null){
rst.close();
}
if(UpdateInfo!=null){
UpdateInfo.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>
tables;
CREATE TABLE IF NOT EXISTS `kills` (
`date` varchar(255) NOT NULL,
`hour` varchar(255) NOT NULL,
`minute` varchar(255) NOT NULL,
`corpseid` int(22) NOT NULL,
`killerid` int(22) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `pkrank` (
`userid` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`clasa` varchar(45) NOT NULL,
`level` int(11) NOT NULL,
`kills` int(22) unsigned NOT NULL,
`reputation` bigint(11) NOT NULL,
`deaths` int(10) unsigned NOT NULL,
`gender` varchar(255) NOT NULL,
UNIQUE KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
enjoy
tt1: