Jump to content

Elijah23

Members
 View Profile  See their activity

  • Posts

    292

  • Joined

  • Last visited

  • Days Won

    5

 Content Type 

Posts posted by Elijah23

    PHP Script Help

    in Tulong para sa 3rd Party Application

    Posted

    Hello, anyone who might know how to fix this, could you please help me?.. :)

    I have this PHP script used for my flux cp which is coded by gerome,

    <?php if($_GET['module'] == 'main' OR empty($_GET['module'])): ?>

    But I'm getting error and showing this logs:

    Undefined index: module in /home/user/public_html/themes/designno3/header.php on line 217

    I'm really confused cause I don't get error using the CP in my computer but putting this in a live

    site gives me this error..

    Thanks!.. :)

    Flux PVP Ranking

    in Web Support

    Posted · Edited by wakoko321

    Hello everyone, I'm seeking help regarding this pvp ranking script that I have..

    I have searched google but still failed..

    I'm using Gerome's free flux cp design which has this PvP Ranking script which uses AnnieRuru's pvp script..

    Here is the sql part of annie's script:

    create table pvpladder (

    char_id int(11) not null default '0' primary key,

    name varchar(30) not null default '',

    streaks smallint(6) unsigned not null default '0',

    kills smallint(6) unsigned not null default '0',

    deaths smallint(6) unsigned not null default '0',

    streaktime datetime

    ) engine = myisam;

    create table ownladder (

    guild_id int(11) not null default '0' primary key,

    name varchar(24) not null default '',

    currentown smallint(6) unsigned not null default '0',

    highestown smallint(6) unsigned not null default '0',

    owntime datetime

    ) engine = myisam;

    The php script part where I fail is this:

    <?php if (!defined('FLUX_ROOT')) exit; ?>
<?php
/**
* ======================================
*  TOP pvp Ranking Base on Kills
*  Ranks are base on Player Kills ratio
* --------------------------------------
*  Author: "Gerome" John Gerome Baldonado
*  Email: [email protected]
*  http://rathena.org/board/user/715-gerome/
*  Requirements: Pvpladder Script by Annie.. or any Pvpladder Script
*/

$pvpladder	= Flux::config('FluxTables.pvpladder');
$minimumkills = 10;	   // Minimum Kills..
$player = array();
$minimumRank = 3;		 // Minimim Player(s) that will Display. if the value is 3 it will display 1st - 3rd

$sql = "SELECT  `char`.`name` , `kills`, `deaths` FROM {$server->charMapDatabase}.`char` JOIN $pvpladder ON $pvpladder.char_id = `char`.char_id WHERE `kills` > $minimumkills  ORDER BY `kills` DESC LIMIT 5 ";
$sth = $server->connection->getStatement($sql);
$sth->execute();

$rankings= $sth->fetchAll();

$x = 0;
foreach($rankings as $rank):
$player['name'][$x] = $rank->name;
$player['kills'][$x] = $rank->kills;
$player['deaths'][$x] = $rank->deaths;
$x+=1;
endforeach;
?>

<div id="PvpRankTop">
Ranks are based on <br/>Player kill death ratio<br/> (minimum of <?php echo $minimumkills; ?> kills)
</div>
<table id="Rankings" class="cleanMP">
	<tr>
		<th> </th>
		<th> </th>
		<th id="Kills">Kills</th>
		<th id="Deaths">Deaths</th>
	</tr>
<?php for( $x=0; $x < $minimumRank ;$x++ ): ?>
<?php $y = $x+1; ?>
	<tr>
		<td id="pvprank" class="cleanMP"><?php if($x == 0) {echo $y.'st';}elseif($x == 1) {echo $y.'nd';}elseif($x == 2) {echo $y.'rd';}elseif($x == 3) {echo $y.'th';} else { echo $y.'th'; }  ?></td>
		<td id="pvpname" class="cleanMP"><?php echo $player['name'][$x]; ?></td>
		<td id="pvpkills" class="cleanMP"><?php echo $player['kills'][$x]; ?></td>
		<td id="pvpdeaths"><?php echo $player['deaths'][$x]; ?></td>
	</tr>
<?php endfor; ?>
</table>
<a href="<?php echo $this->url('ranking','pvpranking'); ?>" id="seemore">See More..</a>

    I'm using ghost's PVP script which uses this table:

    //SQL Table for Ghost's PvP System
CREATE TABLE IF NOT EXISTS `pvp_rank` (
 `char_id` int(11) NOT NULL,
 `account_id` int(11) NOT NULL,
 `char` varchar(30) NOT NULL,
 `kill` int(11) NOT NULL,
 `death` int(11) NOT NULL,
 `kdr` varchar(30) NOT NULL,
 `killingstreak` int(11) NOT NULL,
 `multikill` int(11) NOT NULL,
 `killingspree` int(11) NOT NULL,
 `dominating` int(11) NOT NULL,
 `megakill` int(11) NOT NULL,
 `unstoppable` int(11) NOT NULL,
 `wickedsick` int(11) NOT NULL,
 `monsterkill` int(11) NOT NULL,
 `godlike` int(11) NOT NULL,
 `beyondgodlike` int(11) NOT NULL,
 `doublekill` int(11) NOT NULL,
 `triplekill` int(11) NOT NULL,
 `ultrakill` int(11) NOT NULL,
 `rampage` int(11) NOT NULL,
 `ownage` int(11) NOT NULL,
 `nemesiskill` int(11) NOT NULL,
 `feedcount` int(11) NOT NULL,
 PRIMARY KEY (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

    Addon's config:

    'FluxTables' => array(

    'pvpladder' => 'pvp_rank',

    )

    I have changed the column names in the query but still failed and I really can't understand how sql works in PHP unlike sql in scripts.. :)

    If anyone knows what should I change, please tell me.. :)

    Thanks.. :)

    Monster Aura

    in Source Support

    Posted

    Just want to ask on how to disable the auras for monsters..

    // Maximum allowed 'level' value that can be sent in unit packets.

    // Use together with the aura_lv setting to tell when exactly to show the aura.

    // NOTE: You also need to adjust the client if you want this to work.

    // NOTE: Default is 99. Values above 127 will probably behave incorrectly.

    // NOTE: If you don't know what this does, don't change it!!!

    max_lv: 255

    // Level required to display an aura.

    // NOTE: This assumes that sending max_lv to the client will display the aura.

    // NOTE: aura_lv must not be less than max_lv.

    // Example: If max_lv is 99 and aura_lv is 150, characters with level 99~149

    // will be sent as being all level 98, and only characters with level

    // 150 or more will be reported as having level 99 and show an aura.

    aura_lv: 255

    This works correctly for players... but the custom aura that I used shows too for monsters..

    Just want the aura to be used by players...

    Thanks!.. :)

    Pre-Renewal Items Clientsides

    in Client-side Support

    Posted

    lol ? i though PRE-RE items should be completed as it is part of RE Items...

    What do you mean Emistry? :)

    For example, armors in pre-renewal has lower defense:

    2357#

    A set of shining white armor worn by Valkyries, the battle maidens that serve the god Odin.

    All Stats + 1

    Indestructible (except in upgrade attempts).

    [^008800Mage, Archer, Acolyte Class^000000]

    Increase resistance to ^880000Silence^000000 status by 50%.

    [^008800Swordman, Merchant, Thief Class^000000]

    Increase resistance to ^880000Stun^000000 status by 50%.

    [^000088Valkyrie Helm & Valkyrja's Armor & Valkyrja's Manteau & Valkyrja's Shoes Equip Set^000000]

    Class :^777777 Armor^000000

    Defense :^777777 6^000000

    Weight :^777777 280^000000

    Applicable Job :^777777 All Classes^000000

    #

    In renewal, higher defense:

    2357#

    A set of shining white

    armor worn by Valkyries,^FFFFFF ^000000 the battle maidens that

    serve the god Odin.

    Increases resistance

    to Mute status when

    worn by Mage, Archer,

    and Acolyte Classes.

    Increases resistance

    to Stun status when

    worn by Swordman,

    Merchant, and Thief

    Classes. Cannot be

    destroyed in battle.

    All Stats +1.

    ^6A5ACDValkyrian Armor Set^000000

    ^3CB371Valkyrie Helm^000000

    ^3CB371Valkyrie Armor^000000

    ^3CB371Valkyrie Manteau^000000

    ^3CB371Valkyrie Shoes^000000

    All Stats +1

    Class : ^777777Armor^000000

    Defense : ^77777755^000000

    Weight : ^777777280^000000

    Jobs:^777777All Transcendent

    Classes except Novice^000000

    #

    I have checked the translation project svn, and found out that pre-renewal items support was in revision 67 and still can't support all the items in rathena's database of pre-renewal item_db

    Pre-Renewal Items Clientsides

    in Client-side Support

    Posted

    Hello everyone, I just want to request for updated pre-renewal items clientside..

    I noticed that everything that is updated supports renewal items but how about the pre-renewal side.. :)

    So if someone might have pre-renewal clientside that can support the item_db of pre-renewal branch of rathena, could you please share it?.. :)

    Thanks in advance!.. :)

    Increasing View ID for Clients that can't be diffed with WeeDiff

    in Client-side Support

    Posted

    Hello guys, I just found out in eathena old forums that there is a way to increase the view ID of clients like 2010 clients that still can't be diffed with WeeDiff.. :)

    http://www.eathena.w...hp/t263843.html

    So I just want to know on how to increase it to 30,000.. :) I'm not good with hex.. :)

    Here is Shinryo's way:

    Yes, there is a way.
For example:
CODE
byte_[Add]_Increase_Headgear_ViewID_to_2000:XXXXXX:xxx:208
byte_[Add]_Increase_Headgear_ViewID_to_2000:XXXXXX:x:7
byte_[Add]_Increase_Headgear_ViewID_to_2000:XXXXXX:xxx:208
byte_[Add]_Increase_Headgear_ViewID_to_2000:XXXXXX:x:7
byte_[Add]_Increase_Headgear_ViewID_to_2000:XXXXXX:xxx:208
byte_[Add]_Increase_Headgear_ViewID_to_2000:XXXXXX:x:7

Those are decimal values. Converted to hex they would be:
208: 0xD0
7: 0x07
Switch and combine them together. You'll get 0x7D0. This is in decimal 2000. You can increase this value if you revert this calculation and change those values.

    Increase ViewID to 5000:

    byte_[Add]_Increase_Headgear_ViewID_to_5000:XXXXXX:xxx:136
byte_[Add]_Increase_Headgear_ViewID_to_5000:XXXXXX:x:19
byte_[Add]_Increase_Headgear_ViewID_to_5000:XXXXXX:xxx:136
byte_[Add]_Increase_Headgear_ViewID_to_5000:XXXXXX:x:19
byte_[Add]_Increase_Headgear_ViewID_to_5000:XXXXXX:xxx:136
byte_[Add]_Increase_Headgear_ViewID_to_5000:XXXXXX:x:19

    So what would be the right number to make it 30,000 value?.. :)

    Thanks.. :)

    ✰ Euphy's Scripts ✰

    in Script Collections

    Posted

    Hey Euphy, regarding your WOE Controller script, :)

    Is there a chance to add something like in ToastofDoom's woe script the ability to start the next woe session?.. :)

    For example, the server will held a special WOE event or if they have missed the WOE due to some incident and then want to do the WOE after the server is online again, :)

    Thanks.. :)

    3ceam mounts

    in Client-side Support

    Posted

    That's really a hard thing about doing a lot of customized source codes wherein you need to do a lot of manual patching.. :)

    The idea of making your own patch files is nice but if ever the main source changed something that has conflict with the revision you have done your patch, you need to readjust again the patch you have made in order to fit for that revision.. :)

    This is the thing I really want to suggest to make a place in the source wherein we can put all the customized source we all wanted to put without losing the ability to use automatic updates of svn but I know that it's complicated and a lof of things in the emulator will be changed, :)

    ✰ Euphy's Scripts ✰

    in Script Collections

    Posted · Edited by wakoko321

    LMAO, rainbow colored text.. :)

    Suggestion for the MVP Ladder: (if you're planning on updating this script)

    1. Hope there's an on and off switch for the Display of MVP's name that has been killed.. :)

    2. Ability to reset the ladder

    3. Server's under pre-renewal mode will not be able to view the setnpcdisplay in the script, :)

    Thanks.. :)

×
×
  • Create New...