Website - Hero status

[TheLioner]

oh my bad !

Unfortunately does not work. : (

Mayby not for freya l2j..

[Moon2PL]

structure for heroes l2j.

-- ----------------------------
-- Table structure for `heroes`
-- ----------------------------
DROP TABLE IF EXISTS `heroes`;
CREATE TABLE `heroes` (
  `charId` decimal(11,0) NOT NULL DEFAULT '0',
  `class_id` decimal(3,0) NOT NULL DEFAULT '0',
  `count` decimal(3,0) NOT NULL DEFAULT '0',
  `played` decimal(1,0) NOT NULL DEFAULT '0',
  `message` varchar(300) NOT NULL DEFAULT '',
  PRIMARY KEY (`charId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of heroes
-- ----------------------------

 

I check now olymp.php

[MadΜax]

olymp.php File

   1. <?php
   2. $L2JBS_config["mysql_host"]="Server IP Here";    // MySQL Host     ["localhost"]
   3. $L2JBS_config["mysql_port"]="3306";        // MySQL Port            ["3306"]
   4. $L2JBS_config["mysql_db"]="DB Name Here";        // MySQL Database    ["l2jdb"]
   5. $L2JBS_config["mysql_login"]="User Here";        // MySQL User            ["root"]    
   6. $L2JBS_config["mysql_password"]="Pass Here";    // MySQL Password            ["root"]
   7. $LIMIT="60";                    // TOP PAGE LIMIT
   8. $OBJ_ID="obj_Id";                // Characters Table object id field name
   9. $ACCS_LVL="accesslevel";            // Characters Table access level field name
  10. $minenchant="5";                // Safe Enchant of Server
  11. $maxenchant="20";                // Max Enchant of Server
  12. $ETCITEMS="4037,57";                // Top Items Ids
  13. $MAX_ACCESS="1";                // Full Access level
  14. $EGM_ACCESS="5";                // Event GM Access level
  15. $NORMAL_ACCESS="2";                // Normal GM Access level
  16. include("config/_config_procs.php");
  17. error_reporting(0);
  18. ?>

 

 

Heroes.php File

// db config
$db_user = "User Here"; //your sql username goes here
$db_pass = "Pass Here"; //your sql password goes here
$db_name = "DB Name Here";    //your database name goes here
$db_serv = "Server IP Here"; //the address of the database goes here

[TheLioner]

say us if it works

structure for heroes l2j.

-- ----------------------------
-- Table structure for `heroes`
-- ----------------------------
DROP TABLE IF EXISTS `heroes`;
CREATE TABLE `heroes` (
  `charId` decimal(11,0) NOT NULL DEFAULT '0',
  `class_id` decimal(3,0) NOT NULL DEFAULT '0',
  `count` decimal(3,0) NOT NULL DEFAULT '0',
  `played` decimal(1,0) NOT NULL DEFAULT '0',
  `message` varchar(300) NOT NULL DEFAULT '',
  PRIMARY KEY (`charId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of heroes
-- ----------------------------

 

I check now olymp.php

[Moon2PL]

My l2j characters table.

CREATE TABLE IF NOT EXISTS `characters` (
  `account_name` VARCHAR(45) DEFAULT NULL,
  `charId` INT UNSIGNED NOT NULL DEFAULT 0,
  `char_name` VARCHAR(35) NOT NULL,
  `level` TINYINT UNSIGNED DEFAULT NULL,
  `maxHp` MEDIUMINT UNSIGNED DEFAULT NULL,
  `curHp` MEDIUMINT UNSIGNED DEFAULT NULL,
  `maxCp` MEDIUMINT UNSIGNED DEFAULT NULL,
  `curCp` MEDIUMINT UNSIGNED DEFAULT NULL,
  `maxMp` MEDIUMINT UNSIGNED DEFAULT NULL,
  `curMp` MEDIUMINT UNSIGNED DEFAULT NULL,
  `face` TINYINT UNSIGNED DEFAULT NULL,
  `hairStyle` TINYINT UNSIGNED DEFAULT NULL,
  `hairColor` TINYINT UNSIGNED DEFAULT NULL,
  `sex` TINYINT UNSIGNED DEFAULT NULL,
  `heading` MEDIUMINT DEFAULT NULL,
  `x` MEDIUMINT DEFAULT NULL,
  `y` MEDIUMINT DEFAULT NULL,
  `z` MEDIUMINT DEFAULT NULL,
  `exp` BIGINT UNSIGNED DEFAULT 0,
  `expBeforeDeath` BIGINT UNSIGNED DEFAULT 0,
  `sp` INT UNSIGNED NOT NULL DEFAULT 0,
  `karma` INT UNSIGNED DEFAULT NULL,
  `fame` MEDIUMINT UNSIGNED NOT NULL default 0,
  `pvpkills` SMALLINT UNSIGNED DEFAULT NULL,
  `pkkills` SMALLINT UNSIGNED DEFAULT NULL,
  `clanid` INT UNSIGNED DEFAULT NULL,
  `race` TINYINT UNSIGNED DEFAULT NULL,
  `classid` TINYINT UNSIGNED DEFAULT NULL,
  `base_class` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `transform_id` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  `deletetime` bigint(13) unsigned NOT NULL DEFAULT '0',
  `cancraft` TINYINT UNSIGNED DEFAULT NULL,
  `title` VARCHAR(16) DEFAULT NULL,
  `title_color` MEDIUMINT UNSIGNED NOT NULL DEFAULT '16777079',
  `accesslevel` MEDIUMINT DEFAULT 0,
  `online` TINYINT UNSIGNED DEFAULT NULL,
  `onlinetime` INT DEFAULT NULL,
  `char_slot` TINYINT UNSIGNED DEFAULT NULL,
  `newbie` MEDIUMINT UNSIGNED DEFAULT 1,
  `lastAccess` bigint(13) unsigned NOT NULL DEFAULT '0',
  `clan_privs` MEDIUMINT UNSIGNED DEFAULT 0,
  `wantspeace` TINYINT UNSIGNED DEFAULT 0,
  `isin7sdungeon` TINYINT UNSIGNED NOT NULL default 0,
  `punish_level` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `punish_timer` INT UNSIGNED NOT NULL DEFAULT 0,
  `power_grade` TINYINT UNSIGNED DEFAULT NULL,
  `nobless` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `subpledge` SMALLINT NOT NULL DEFAULT 0,
  `lvl_joined_academy` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  `apprentice` INT UNSIGNED NOT NULL DEFAULT 0,
  `sponsor` INT UNSIGNED NOT NULL DEFAULT 0,
  `varka_ketra_ally` TINYINT NOT NULL DEFAULT 0,
  `clan_join_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
  `clan_create_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
  `death_penalty_level` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  `bookmarkslot` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  `vitality_points` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
  `createTime` bigint(13) unsigned NOT NULL DEFAULT '0',
  `language` VARCHAR(2) DEFAULT NULL,
  PRIMARY KEY (`charId`),
  KEY `clanid` (`clanid`)
);

 

 

I make that and still no heroes:

 

$LIMIT="60";                    // TOP PAGE LIMIT

$OBJ_ID="charId";                // Characters Table object id field name

$ACCS_LVL="accesslevel";            // Characters Table access level field name

$minenchant="3";                // Safe Enchant of Server

$maxenchant="16";                // Max Enchant of Server

$ETCITEMS="4037,57";                // Top Items Ids

$MAX_ACCESS="120";                // Full Access level

$EGM_ACCESS="120";                // Event GM Access level

$NORMAL_ACCESS="2";                // Normal GM Access level

include("config/_config_procs.php");

error_reporting(0);

?>

[MadΜax]

you don't need to change enything on the table.

i tell you where you need changes

you will need only the

 

Server IP

Database Name

Database Password

Database port

blablabla etc.

 

here you have an example

 

$db_user = "User Here"; //your sql username goes here
$db_pass = "Pass Here"; //your sql password goes here
$db_name = "DB Name Here";    //your database name goes here
$db_serv = "Server IP Here"; //the address of the database goes here

 

[TheLioner]

MadMax is right! even if you delete a / or " all script will fail

you don't need to change enything on the table.

i tell you where you need changes

you will need only the

 

Server IP

Database Name

Database Password

Database port

blablabla etc.

 

here you have an example

 

$db_user = "User Here"; //your sql username goes here
$db_pass = "Pass Here"; //your sql password goes here
$db_name = "DB Name Here";    //your database name goes here
$db_serv = "Server IP Here"; //the address of the database goes here

 

[MadΜax]

pm me i will fix it for ya! in a moment

[Moon2PL]

ehh at was ftp problem. now all work fine! big thx for help all ! :-)

[TheLioner]

pheww.. im glad to hear that ;)

ehh at was ftp problem. now all work fine! big thx for help all ! :-)

[Moon2PL]

Here you are my friend ------------> http://www.mediafire.com/?ybfruf1qbqyw2l1

<?PHP
$class_list=array(
    0=>"Fighter",1=>"Warrior",2=>"Gladiator",3=>"Warlord",4=>"Knight",5=>"Paladin",6=>"Dark Avenger",7=>"Rogue",
    8=>"Treasure Hunter",9=>"Hawkeye",10=>"Mage",11=>"Wizard",12=>"Sorcerer",13=>"Necromancer",14=>"Warlock",15=>"Cleric",
    16=>"Bishop",17=>"Prophet",18=>"Elven Fighter",19=>"Elven Knight",20=>"Temple Knight",21=>"Swordsinger",22=>"Elven Scout",23=>"Plains Walker",
    24=>"Silver Ranger",25=>"Elven Mage",26=>" Elven Wizard",27=>" Spellsinger",28=>"Elemental Summoner ",29=>"Oracle",
    30=>"Elder",31=>"Dark Fighter",32=>"Palus Knightr",33=>"Shillien Knight",34=>"Bladedancer",35=>"Assasin",36=>"Abyss Walker",
    37=>"Phantom Ranger",38=>"Dark Mage",39=>"Dark Wizard",40=>"Spellhowler",41=>"Phantom Summoner",42=>"Shillien Oracle",43=>"Shilien Elder",
    44=>"Orc Fighter",45=>"Orc Raider",46=>"Destroyer",47=>"Orc Monk",48=>"Tyrant",49=>"Orc Mage",50=>"Orc Shaman",51=>"Overlord",
    52=>"Warcryer",53=>"Dwarven Fighter",54=>"Scavenger",55=>"Bounty Hunter",56=>"Artisan", 57=> "Warsmith",
    88=>"Duelist",89=>"Dreadnought",90=>"Phoenix Knight",91=>"Hell Knight",92=>"Sagittarius",93=>"Adventurer",94=>"Archmage",95=>"Soultaker",
    96=>"Arcana Lord",97=>"Cardinal",98=>"Hierophant",99=>"Evas Templar",100=>"Sword Muse",101=>"Wind Rider",102=>"Moonlight Sentinel",
    103=>"Mystic Muse",104=>"Elemental Master",105=>"Evas Saint",106=>"Shillien Templar",107=>"Spectral Dancer",108=>"Ghost Hunter",
    109=>"Ghost Sentinel",110=>"Storm Screamer",111=>"Spectral Master",112=>"Shillien Saint",113=>"Titan",114=>"Grand Khavatari",
    115=>"Dominator",116=>"Doomcryer",117=>"Fortune Seeker",118=>"Maestro",
    123=>"Male Soldier",124=>"Female Soldier",125=>"Trooper",126=>"Warder",127=>"Berserker",
    128=>"Male Soulbreaker",129=>"Female Soulbreaker",130=>"Arbalester",131=>"Doombringer",
    132=>"Male Soulhound",133=>"Female Soulhound",134=>"Trickster",135=>"Inspector",136=>"Judicator"
);
// db config
$db_user = ""; //your sql username goes here
$db_pass = ""; //your sql password goes here
$db_name = "";    //your database name goes here
$db_serv = ""; //the address of the database goes here
// db connection!
$db = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]");
mysql_select_db ( $db_name );
function do_query($query) {
  $arr = array();
  $result = mssql_query($query) or die("Error SQL: ".mssql_get_last_message());
  for ($x=0; $arr[$x] = mssql_fetch_assoc($result); $x++);
  unset($arr[count($arr)-1]);
  return $arr;
}
$query = mysql_query("SELECT char_name,olympiad_nobles.class_id as 'class_id'
FROM characters
LEFT JOIN clan_data ON clan_data.clan_Id = characters.clanId
INNER JOIN olympiad_nobles ON olympiad_nobles.charId = characters.charId
WHERE competitions_won > 0
ORDER BY class_id
");
$heroes_actuales = mysql_query;
if (sizeof($heroes_actuales) == 0) echo "No heroes found.";
else {
  echo "
  <table class='info'>\n

  <td width='60%' align='left'><font color='CC3300'><b>Name</b></font></td>
  <td align='left'><font color='CC3300'><b>Class</b></font></td>

  </tr>
  ";
  $i=0;
  
  while ($hero = mysql_fetch_assoc($query))
   {
    if (!($i%2)) echo "<tr align='center'>";
    else echo "<tr align='center'>";
    echo "
    <td align='left'>".$hero['char_name']."</td>
    <td align='left'>".$class_list[$hero['class_id']]."</td>
    <td align='left'>
    ";
   
    echo $hero['pname']."</td><td align='left'>";
    
    echo $hero['aname']."</td><td align='left'>".$hero['win_count']."</td></tr>";
    $i++;
  }
  echo "</table>";
}
?>

 

ajjj this is not hero status, but top hero points - Before choosing a hero.

 

Someone have script hero current list?

[lkh720]

for sure  good luck then ^^