Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[RELEASE] Grand Chase Website Scripts

Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
Since I am so very lazy, I'm just going to post things needed for a Grand Chase website.

I will include my copyrights on every single thing. If you are going to use them, DO NOT REMOVE THE COPYRIGHT. I despise ingrates, especially those who come here just to steal.

As a word of thought I would like to mind you that we, the developers, spend our precious time teaching you and releasing things so that everyone would enjoy... not for you guys to steal and gain credit for.
If you still persist on stealing I might be forced to perform drastic and destructive measures.

Please say thanks by following the steps and taking me as your referrer. :D I'd very much appreciate it.

The following uses this setup:
host: localhost
user: root
password: pass
default schema: gc
:
Changing them is up to you, but I won't bother telling you how to if you don't know how. If you don't know how to do those, then you shouldn't be here.


Things Needed:
Users Script:
Code:
/*
Users MySQL script by ShiningRiver
Copyrights included.
DO NOT REMOVE THIS HEADER COMMENT
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `Login` varchar(20) NOT NULL,
  `passwd` varchar(32) NOT NULL,
  `sex` char(1) NOT NULL,
  `LoginUID` int(11) NOT NULL AUTO_INCREMENT,
  `firstLogin` datetime NOT NULL,
  `lastConnect` datetime NOT NULL,
  `lastLogin` datetime NOT NULL,
  `playTime` int(11) NOT NULL,
  `gamePoint` int(11) NOT NULL,
  `IPAddress` varchar(15) NOT NULL,
  `Connecting` bit(1) NOT NULL,
  `ModeLevel` longblob NOT NULL,
  `Cash` char(10) DEFAULT NULL,
  PRIMARY KEY (`Login`),
  UNIQUE KEY `IXU_Users_LoginUID` (`LoginUID`),
  KEY `IDX_users_01` (`firstLogin`),
  KEY `IDX_users_02` (`lastLogin`)
) ENGINE=InnoDB AUTO_INCREMENT=1525 DEFAULT CHARSET=latin1;

Characters script:
Code:
/*
Characters MySQL script by ShiningRiver
Copyrights included.
DO NOT REMOVE THIS HEADER COMMENT
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
  `Login` varchar(20) NOT NULL,
  `CharType` tinyint(3) unsigned NOT NULL,
  `CharName` varchar(20) DEFAULT NULL,
  `Promotion` tinyint(3) unsigned NOT NULL,
  `Exp` int(11) NOT NULL,
  `Level` int(11) NOT NULL,
  `Win` int(11) NOT NULL,
  `Lose` int(11) NOT NULL,
  `EquipItems` longblob,
  `EquipSize` int(11) NOT NULL,
  PRIMARY KEY (`Login`,`CharType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Those above are but bare necessities.


Please say thanks by following the steps and taking me as your referrer. :D I'd very much appreciate it.
 
Last edited:
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
Now,we need a ranking page:

Ranking Page:
Rankings by Level:
Code:
<h1>Rankings by Player by Level</h1>
<?php
  $dbcnx = @mysql_connect('localhost', 'root', 'pass');
  $counter = 0;
  if (!$dbcnx) {
    echo( '<p>Unable to connect to the ' .
    'database server at this time.</p>' );
    exit();
  }

  $database = @mysql_select_db('gc', $dbcnx);
  if (! $database) {
    die( '<p>Unable to locate the' .
    'database at this time.</p>' );
  }

  $result = mysql_query("SELECT * FROM characters ORDER BY Level",$dbcnx);
  echo "<TABLE>";
  echo"<TR>
        <TD><B><font color=white>Character Name</font></B>
        <TD><B><font color=white>Character Type</font></B>
        <TD><B><font color=white>Promotion</font></B>
        <TD><B><font color=white>Level</font></B>
        <TD><B><font color=white>Win</font></B>
        <TD><B><font color=white>Loss</font></B>
        <TD><B><font color=white>Ratio(%)</font></B>
       </TR>";
  while ($myrow = mysql_fetch_array($result))
  {
  echo "<TR>";
  echo "<TD>";
  echo $myrow["CharName"];
  echo "<TD>";
  if ($myrow["CharType"] == "0"){
     echo "Elesis";
  }
  else if ($myrow["CharType"] == "1"){
     echo "Amy";
  }
  else if ($myrow["CharType"] == "2"){
     echo "Lire";
  }
  else if ($myrow["CharType"] == "3"){
     echo "Ronan";
  }
  else if ($myrow["CharType"] == "4"){
     echo "Lass";
  }
  else if ($myrow["CharType"] == "5"){
     echo "Ryan";
  }
  else
     echo "Record Unknown";
  }
  echo "<TD>";
  echo $myrow["Promotion"];
  echo "<TD>";
  echo $myrow["Level"];
  echo "<TD>";
  echo $myrow["Win"];
  echo "<TD>";
  echo $myrow["Loss"];
  echo "<TD>";
  echo ($myrow["Win"]/$myrow["Loss"])*100;
  $counter++;
  }
  echo "</TABLE><BR/>";
  echo "<B>$counter</B> Characters in Database.";
?>

Registration Page:
(Note that it does not have any email confirmation... You can just make your own.) :D
Part 1 (Main form page):
Code:
<form action="insert.php" method="post">
<p><h1>New User</h1><br />
<table style="width: 35%;">
  <tr>
    <td>
        Username:
    </td>
    <td>
        <input name="user" size="20" maxlength="20" />
    </td>
  </tr>
  <tr>
    <td>
        Password:
    </td>
    <td>
        <input type="pass" name="pass" size="20" maxlength="20" />
    </td>
  </tr>
  <tr>
    <td>
        Gender:
    </td>
    <td>
        <select name="gender" size="1">
        <option value="M">Male</option>
        <option value="F">Female</option>
        </select>
    </td>
  </tr>
</table>
<br />
<input type="submit" name="newstud" value="SUBMIT" />
</p>
</form>
Part 2 (insert.php):
Code:
<?php

    $dbcnx = @mysql_connect("localhost","root","pass");
    if (!$dbcnx)
    {
        die('Could not connect: ' . mysql_error());
    }

    @mysql_select_db("gc", $dbcnx);

    $sql = "INSERT INTO user (Login, passwd, sex)
    VALUES ('$_POST[user]', '$_POST[pass]', '$_POST[gender]')";
    if (@mysql_query($sql)) {
        echo('<p>User has been successfully added.</p>');
    }
    else {
      echo('<p>Error adding user: ' .
      mysql_error() . '</p>');
    }

    @mysql_close($dbcnx);
?>

<More to come>

Please say thanks by following the steps and taking me as your referrer. :D I'd very much appreciate it.
 
-sama
Loyal Member
Joined
May 3, 2008
Messages
1,392
Reaction score
7
Any features to mention?
Before I test it.

Anyways, what CMS / CP should we use?
since this is an add-on script for CPs or CMSs for what I think, yeah, so me not sure.

Kindly remove these lines:
Code:
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('aquagod', 'd46d53769bce3886348593e3874617b1', '0', '1524', '2009-05-06 22:50:00', '2009-05-06 22:50:00', '2009-05-06 22:50:00', '0', '200', '192.168.1.10', '', 0x30783030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030, '0');
INSERT INTO `users` VALUES ('cKaquagod01', 'b3cc90af659f7ef673581008d938a391', '0', '1523', '2009-05-04 19:38:00', '2009-05-04 19:38:00', '2009-05-04 19:38:00', '0', '200', '0.0.0.0', '\0', 0x30783030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030, '0');
INSERT INTO `users` VALUES ('FatalPain', '47e58436474b433d655ff32b7ceb65a5', '0', '1519', '2009-04-16 21:48:00', '2009-04-16 21:48:00', '2009-04-17 14:10:00', '0', '97579999', '192.168.1.7', '\0', 0x30783030303030303045303730303030303030303041303030303030303030423030303030303030304330303030303030303044303030303030303030453030303030303030304630303030303030303141303030303030303130313142303030303030303031443030303030303031303131453030303030303030314630303030303030303233303030303030303032343030303030303030, '9999');
INSERT INTO `users` VALUES ('Kero', 'a27f6e192cd1a64da673790129e07cc4', '0', '1518', '2009-04-16 21:47:00', '2009-04-16 21:47:00', '2009-05-09 23:26:00', '0', '89973761', '192.168.1.7', '', 0x307830303030303030453037303030303030303030413030303030303031303130423030303030303031303130433030303030303030304430303030303030303045303030303030303030463030303030303030314130303030303030313031314230303030303030303144303030303030303130313145303030303030303031463030303030303031303132333030303030303031303132343030303030303030, '9999');
INSERT INTO `users` VALUES ('Lectrix', '245c103dc7bbdc9a0cce33261dd2d6b1', '0', '1517', '2009-04-16 21:45:00', '2009-04-16 21:45:00', '2009-05-10 22:13:00', '0', '86836070', '192.168.1.14', '\0', 0x3078303030303030304530373030303030303031303130413030303030303030304230303030303030303043303030303030303030443030303030303030304530303030303030303046303030303030303031413030303030303031303131423030303030303030314430303030303030313031314530303030303030303146303030303030303032333030303030303031303132343030303030303030, '9999');
Code:
-- ----------------------------
-- Records of characters
-- ----------------------------
INSERT INTO `characters` VALUES ('aquagod', '0', '', '0', '100', '0', '0', '0', 0x30783030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030, '0');
INSERT INTO `characters` VALUES ('aquagod', '1', '', '0', '100', '0', '0', '0', 0x30783030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030, '0');
INSERT INTO `characters` VALUES ('aquagod', '2', '', '0', '100', '0', '0', '0', 0x30783030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030, '0');
INSERT INTO `characters` VALUES ('cKaquagod01', '0', '', '0', '100', '0', '0', '0', 0x30783030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030, '0');
INSERT INTO `characters` VALUES ('cKaquagod01', '1', '', '0', '100', '0', '0', '0', 0x30783030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030303030, '0');
If can, please kindly,
since they are my users.

If there are many things that I didn't read..
please remind.

and this isn't dev anymore right?

//.SeraphiPod.
 
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
:D Removed.

It's a dev. I coded those things except the sql scripts (they were precoded by some program) :D

These are only scripts to be added to your website... so it's not a CMS per se. It's more of an add on. :D

Well, the only feature I can say that it only talks of the website... Unless you integrate your server to connect to your database (that is also connected to the website), then you can register users via the website... viola.
Of course, that would mean that all of the tables in your MS SQL be migrated to MySQL. :D
 
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
Rankings by Character

Elesis

Code:
<h1>Rankings (Elesis)</h1>
<?php
  $dbcnx = @mysql_connect('localhost', 'root', 'pass');
  $counter = 0;
  if (!$dbcnx) {
    echo( '<p>Unable to connect to the ' .
    'database server at this time.</p>' );
    exit();
  }

  $database = @mysql_select_db('gc', $dbcnx);
  if (! $database) {
    die( '<p>Unable to locate the' .
    'database at this time.</p>' );
  }

  $result = mysql_query("SELECT * FROM characters WHERE CharType = 0 ORDER BY Level",$dbcnx);
  echo "<TABLE>";
  echo"<TR>
        <TD><B><font color=white>Character Name</font></B>
        <TD><B><font color=white>Character Type</font></B>
        <TD><B><font color=white>Promotion</font></B>
        <TD><B><font color=white>Level</font></B>
        <TD><B><font color=white>Win</font></B>
        <TD><B><font color=white>Loss</font></B>
        <TD><B><font color=white>Ratio(%)</font></B>
       </TR>";
  while ($myrow = mysql_fetch_array($result))
  {
  echo "<TR>";
  echo "<TD>";
  echo $myrow["CharName"];
  echo "<TD>";
  if ($myrow["CharType"] == "0"){
     echo "Elesis";
  }
  else if ($myrow["CharType"] == "1"){
     echo "Amy";
  }
  else if ($myrow["CharType"] == "2"){
     echo "Lire";
  }
  else if ($myrow["CharType"] == "3"){
     echo "Ronan";
  }
  else if ($myrow["CharType"] == "4"){
     echo "Lass";
  }
  else if ($myrow["CharType"] == "5"){
     echo "Ryan";
  }
  else
     echo "Record Unknown";
  }
  echo "<TD>";
  echo $myrow["Promotion"];
  echo "<TD>";
  echo $myrow["Level"];
  echo "<TD>";
  echo $myrow["Win"];
  echo "<TD>";
  echo $myrow["Loss"];
  echo "<TD>";
  echo ($myrow["Win"]/$myrow["Loss"])*100;
  $counter++;
  }
  echo "</TABLE><BR/>";
  echo "<B>$counter</B> Characters in Database.";
?>

Arme

Code:
<h1>Rankings (Arme)</h1>
<?php
  $dbcnx = @mysql_connect('localhost', 'root', 'pass');
  $counter = 0;
  if (!$dbcnx) {
    echo( '<p>Unable to connect to the ' .
    'database server at this time.</p>' );
    exit();
  }

  $database = @mysql_select_db('gc', $dbcnx);
  if (! $database) {
    die( '<p>Unable to locate the' .
    'database at this time.</p>' );
  }

  $result = mysql_query("SELECT * FROM characters WHERE CharType = 1 ORDER BY Level",$dbcnx);
  echo "<TABLE>";
  echo"<TR>
        <TD><B><font color=white>Character Name</font></B>
        <TD><B><font color=white>Character Type</font></B>
        <TD><B><font color=white>Promotion</font></B>
        <TD><B><font color=white>Level</font></B>
        <TD><B><font color=white>Win</font></B>
        <TD><B><font color=white>Loss</font></B>
        <TD><B><font color=white>Ratio(%)</font></B>
       </TR>";
  while ($myrow = mysql_fetch_array($result))
  {
  echo "<TR>";
  echo "<TD>";
  echo $myrow["CharName"];
  echo "<TD>";
  if ($myrow["CharType"] == "0"){
     echo "Elesis";
  }
  else if ($myrow["CharType"] == "1"){
     echo "Amy";
  }
  else if ($myrow["CharType"] == "2"){
     echo "Lire";
  }
  else if ($myrow["CharType"] == "3"){
     echo "Ronan";
  }
  else if ($myrow["CharType"] == "4"){
     echo "Lass";
  }
  else if ($myrow["CharType"] == "5"){
     echo "Ryan";
  }
  else
     echo "Record Unknown";
  }
  echo "<TD>";
  echo $myrow["Promotion"];
  echo "<TD>";
  echo $myrow["Level"];
  echo "<TD>";
  echo $myrow["Win"];
  echo "<TD>";
  echo $myrow["Loss"];
  echo "<TD>";
  echo ($myrow["Win"]/$myrow["Loss"])*100;
  $counter++;
  }
  echo "</TABLE><BR/>";
  echo "<B>$counter</B> Characters in Database.";
?>

Lire

Code:
<h1>Rankings (Lire)</h1>
<?php
  $dbcnx = @mysql_connect('localhost', 'root', 'pass');
  $counter = 0;
  if (!$dbcnx) {
    echo( '<p>Unable to connect to the ' .
    'database server at this time.</p>' );
    exit();
  }

  $database = @mysql_select_db('gc', $dbcnx);
  if (! $database) {
    die( '<p>Unable to locate the' .
    'database at this time.</p>' );
  }

  $result = mysql_query("SELECT * FROM characters WHERE CharType = 2 ORDER BY Level",$dbcnx);
  echo "<TABLE>";
  echo"<TR>
        <TD><B><font color=white>Character Name</font></B>
        <TD><B><font color=white>Character Type</font></B>
        <TD><B><font color=white>Promotion</font></B>
        <TD><B><font color=white>Level</font></B>
        <TD><B><font color=white>Win</font></B>
        <TD><B><font color=white>Loss</font></B>
        <TD><B><font color=white>Ratio(%)</font></B>
       </TR>";
  while ($myrow = mysql_fetch_array($result))
  {
  echo "<TR>";
  echo "<TD>";
  echo $myrow["CharName"];
  echo "<TD>";
  if ($myrow["CharType"] == "0"){
     echo "Elesis";
  }
  else if ($myrow["CharType"] == "1"){
     echo "Amy";
  }
  else if ($myrow["CharType"] == "2"){
     echo "Lire";
  }
  else if ($myrow["CharType"] == "3"){
     echo "Ronan";
  }
  else if ($myrow["CharType"] == "4"){
     echo "Lass";
  }
  else if ($myrow["CharType"] == "5"){
     echo "Ryan";
  }
  else
     echo "Record Unknown";
  }
  echo "<TD>";
  echo $myrow["Promotion"];
  echo "<TD>";
  echo $myrow["Level"];
  echo "<TD>";
  echo $myrow["Win"];
  echo "<TD>";
  echo $myrow["Loss"];
  echo "<TD>";
  echo ($myrow["Win"]/$myrow["Loss"])*100;
  $counter++;
  }
  echo "</TABLE><BR/>";
  echo "<B>$counter</B> Characters in Database.";
?>



Ronan

Code:
<h1>Rankings (Ronan)</h1>
<?php
  $dbcnx = @mysql_connect('localhost', 'root', 'pass');
  $counter = 0;
  if (!$dbcnx) {
    echo( '<p>Unable to connect to the ' .
    'database server at this time.</p>' );
    exit();
  }

  $database = @mysql_select_db('gc', $dbcnx);
  if (! $database) {
    die( '<p>Unable to locate the' .
    'database at this time.</p>' );
  }

  $result = mysql_query("SELECT * FROM characters WHERE CharType = 3 ORDER BY Level",$dbcnx);
  echo "<TABLE>";
  echo"<TR>
        <TD><B><font color=white>Character Name</font></B>
        <TD><B><font color=white>Character Type</font></B>
        <TD><B><font color=white>Promotion</font></B>
        <TD><B><font color=white>Level</font></B>
        <TD><B><font color=white>Win</font></B>
        <TD><B><font color=white>Loss</font></B>
        <TD><B><font color=white>Ratio(%)</font></B>
       </TR>";
  while ($myrow = mysql_fetch_array($result))
  {
  echo "<TR>";
  echo "<TD>";
  echo $myrow["CharName"];
  echo "<TD>";
  if ($myrow["CharType"] == "0"){
     echo "Elesis";
  }
  else if ($myrow["CharType"] == "1"){
     echo "Amy";
  }
  else if ($myrow["CharType"] == "2"){
     echo "Lire";
  }
  else if ($myrow["CharType"] == "3"){
     echo "Ronan";
  }
  else if ($myrow["CharType"] == "4"){
     echo "Lass";
  }
  else if ($myrow["CharType"] == "5"){
     echo "Ryan";
  }
  else
     echo "Record Unknown";
  }
  echo "<TD>";
  echo $myrow["Promotion"];
  echo "<TD>";
  echo $myrow["Level"];
  echo "<TD>";
  echo $myrow["Win"];
  echo "<TD>";
  echo $myrow["Loss"];
  echo "<TD>";
  echo ($myrow["Win"]/$myrow["Loss"])*100;
  $counter++;
  }
  echo "</TABLE><BR/>";
  echo "<B>$counter</B> Characters in Database.";
?>


Ryan

Code:
<h1>Rankings (Ryan)</h1>
<?php
  $dbcnx = @mysql_connect('localhost', 'root', 'pass');
  $counter = 0;
  if (!$dbcnx) {
    echo( '<p>Unable to connect to the ' .
    'database server at this time.</p>' );
    exit();
  }

  $database = @mysql_select_db('gc', $dbcnx);
  if (! $database) {
    die( '<p>Unable to locate the' .
    'database at this time.</p>' );
  }

  $result = mysql_query("SELECT * FROM characters WHERE CharType = 4 ORDER BY Level",$dbcnx);
  echo "<TABLE>";
  echo"<TR>
        <TD><B><font color=white>Character Name</font></B>
        <TD><B><font color=white>Character Type</font></B>
        <TD><B><font color=white>Promotion</font></B>
        <TD><B><font color=white>Level</font></B>
        <TD><B><font color=white>Win</font></B>
        <TD><B><font color=white>Loss</font></B>
        <TD><B><font color=white>Ratio(%)</font></B>
       </TR>";
  while ($myrow = mysql_fetch_array($result))
  {
  echo "<TR>";
  echo "<TD>";
  echo $myrow["CharName"];
  echo "<TD>";
  if ($myrow["CharType"] == "0"){
     echo "Elesis";
  }
  else if ($myrow["CharType"] == "1"){
     echo "Amy";
  }
  else if ($myrow["CharType"] == "2"){
     echo "Lire";
  }
  else if ($myrow["CharType"] == "3"){
     echo "Ronan";
  }
  else if ($myrow["CharType"] == "4"){
     echo "Lass";
  }
  else if ($myrow["CharType"] == "5"){
     echo "Ryan";
  }
  else
     echo "Record Unknown";
  }
  echo "<TD>";
  echo $myrow["Promotion"];
  echo "<TD>";
  echo $myrow["Level"];
  echo "<TD>";
  echo $myrow["Win"];
  echo "<TD>";
  echo $myrow["Loss"];
  echo "<TD>";
  echo ($myrow["Win"]/$myrow["Loss"])*100;
  $counter++;
  }
  echo "</TABLE><BR/>";
  echo "<B>$counter</B> Characters in Database.";
?>


Lass

Code:
<h1>Rankings (Lass)</h1>
<?php
  $dbcnx = @mysql_connect('localhost', 'root', 'pass');
  $counter = 0;
  if (!$dbcnx) {
    echo( '<p>Unable to connect to the ' .
    'database server at this time.</p>' );
    exit();
  }

  $database = @mysql_select_db('gc', $dbcnx);
  if (! $database) {
    die( '<p>Unable to locate the' .
    'database at this time.</p>' );
  }

  $result = mysql_query("SELECT * FROM characters WHERE CharType = 5 ORDER BY Level",$dbcnx);
  echo "<TABLE>";
  echo"<TR>
        <TD><B><font color=white>Character Name</font></B>
        <TD><B><font color=white>Character Type</font></B>
        <TD><B><font color=white>Promotion</font></B>
        <TD><B><font color=white>Level</font></B>
        <TD><B><font color=white>Win</font></B>
        <TD><B><font color=white>Loss</font></B>
        <TD><B><font color=white>Ratio(%)</font></B>
       </TR>";
  while ($myrow = mysql_fetch_array($result))
  {
  echo "<TR>";
  echo "<TD>";
  echo $myrow["CharName"];
  echo "<TD>";
  if ($myrow["CharType"] == "0"){
     echo "Elesis";
  }
  else if ($myrow["CharType"] == "1"){
     echo "Amy";
  }
  else if ($myrow["CharType"] == "2"){
     echo "Lire";
  }
  else if ($myrow["CharType"] == "3"){
     echo "Ronan";
  }
  else if ($myrow["CharType"] == "4"){
     echo "Lass";
  }
  else if ($myrow["CharType"] == "5"){
     echo "Ryan";
  }
  else
     echo "Record Unknown";
  }
  echo "<TD>";
  echo $myrow["Promotion"];
  echo "<TD>";
  echo $myrow["Level"];
  echo "<TD>";
  echo $myrow["Win"];
  echo "<TD>";
  echo $myrow["Loss"];
  echo "<TD>";
  echo ($myrow["Win"]/$myrow["Loss"])*100;
  $counter++;
  }
  echo "</TABLE><BR/>";
  echo "<B>$counter</B> Characters in Database.";
?>


Please say thanks by following the steps and taking me as your referrer. :D I'd very much appreciate it.
 
Newbie Spellweaver
Joined
Jun 19, 2008
Messages
28
Reaction score
0
hey shining when i executed that query for microsoft server it said

Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '='.
 
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
Which one there? Are you using the same settings as I?
Installed MySQL, then installed WAMP, then finally PHP.
 
Newbie Spellweaver
Joined
Jun 19, 2008
Messages
28
Reaction score
0
wait what we have to use mysql server query browser for grandchase pserver? o_O

u just got me confused ?_?
 
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
If you are reading this thread properly, this is to make a website for grand chase. This has no relation whatsoever with your game development. This is an optional field you can do if you plan to put your server to public.
 
Newbie Spellweaver
Joined
Jun 19, 2008
Messages
28
Reaction score
0
i know that. here is what im confused about if the server is going to have a registration page then why is the sql browsers seperate? o_O
 
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
<.<
Because, dear pall, majority of the registration sites follow PHP and MySQL as it is always provided by majority of the hosters. Unless you have your own server (by server I mean a large-scale computer base), you're going to have problems.

Another note: you can try doing this in ASP. I think they connect to MS SQL instead of MySQL. I'm unsure.
 
Newbie Spellweaver
Joined
Jun 19, 2008
Messages
28
Reaction score
0
yeah i have my own server do i just execute the user and character sql script into the same database as my server?
 
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
At the server setup part of my guide, you are told to use MS SQL. However, I would not be experimenting on connecting it to MySQL (I have a 4PM to 12 midnight shift at work... the rest of the hours I am asleep).

You can execute the two scripts at MySQL. I'm not sure in MS SQL.
 
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
At the server setup part of my guide, you are told to use MS SQL. However, I would not be experimenting on connecting it to MySQL (I have a 4PM to 12 midnight shift at work... the rest of the hours I am asleep).

You can execute the two scripts at MySQL. I'm not sure in MS SQL.
 
Skilled Illusionist
Joined
Jan 9, 2009
Messages
359
Reaction score
43
When I'm not experiencing headaches and not working (or definitely resting), I might put a real-time implementation of that.

For now, it's just those scripts.
 
Experienced Elementalist
Joined
Aug 10, 2008
Messages
291
Reaction score
10
hmmm ok.. as far as i understand this.. its for MySql not MMSQL? am i right then?

hmm ok ok.. so i still have to use MySQL... this is going to be a long one..
 
Back
Top