Jump to content

Jupeto

Members
  • Posts

    225
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by Jupeto

  1. Click mo lang yung green up arrow icon sa baba ng post na to http://rathena.org/board/topic/69754-q-about-woe-status-like-server-status-for-flux-cp/#entry133060
  2. Please prompt us if you already solved this concern. Thanks,
  3. I believe this belongs to Tulong para sa Client Topic moved.
  4. Kindly read, http://rathena.org/wiki/Custom_Items Thanks,
  5. 1. Execute the sql below in your fluxcp database ALTER TABLE `ragsrvinfo` ADD `agit_status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `drop`; 2. Download agit_status.txt. Place the file in rAthena/npc/custom/ and install it or copy below and create a new file named agit_status.txt and install //===== eAthena Script ======================================= //= Agit Status Checker //===== By: ================================================== //= Entwined //===== Current Version: ===================================== //= 1.1 //===== Compatible With: ===================================== //= eAthena SVN (SQL only) //===== Description: ========================================= //= Updates WoE status, so CeresCP can display //= if WoE is on or off in real time. //===== Additional Comments: ================================= //= Run this SQL query: //= ALTER TABLE `ragsrvinfo` ADD `agit_status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `drop`; //============================================================ - script AGIT_STATUS -1,{ OnInit: // check if `agit_status` column exists if (query_sql("SHOW COLUMNS FROM ragsrvinfo LIKE 'agit_status'", .@dummy$,.@dummy$,.@dummy$,.@dummy$,.@dummy$,.@dummy$) == 0) { // Or... if we have the ALTER privilege, try to add the column query_sql "SELECT DATABASE()", .@rag_db$; query_sql "SHOW GRANTS", .@grants$; for (set .@i,0; .@i<getarraysize(.@grants$); set .@i,.@i+1) if (compare(.@grants$[.@i], "`"+.@rag_db$+"`")) { if (compare(.@grants$[.@i], "ALTER,") || compare(.@grants$[.@i], "ALTER ON")) query_sql "ALTER TABLE `ragsrvinfo` ADD `agit_status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `drop`;"; break; } // verify if (query_sql("SHOW COLUMNS FROM ragsrvinfo LIKE 'agit_status'", .@dummy$,.@dummy$,.@dummy$,.@dummy$,.@dummy$,.@dummy$) == 0) { debugmes strnpcinfo(3)+" : unable to modify SQL table (needs ALTER privilege)"; atcommand "@unloadnpc " + strnpcinfo(3); end; } } OnAgitStart: OnAgitStart2: OnAgitEnd: OnAgitEnd2: query_sql "UPDATE ragsrvinfo SET agit_status = " + (agitcheck() || agitcheck2()); end; } 3. Open fluxcp/modules/server/status.php Copy below code and paste before ?> // Name : WoE Status // Email : [email protected] // Author : Jupeto // NOTE : Uncomment all commented lines below if you want to cache the checking of status // and add a line in your fluxcp/config/application.php /* find : ServerStatusTimeout add after : 'WoEStatusCache' => 2, // Store a cached woe status and refresh every X minutes. Default: 2 minutes (value is measured in minutes). 'WoEStatusTimeout' => 2, // For each server, spend X amount of seconds to determine whether it's up or not. */ // if (file_exists($cache_woe_status) && (time() - filemtime($cache_woe_status)) < (Flux::config('WoEStatusCache') * 60)) { // $woeStatus = unserialize(file_get_contents($cache_woe_status)); // } // else { $woeStatus = array(); foreach (Flux::$loginAthenaGroupRegistry as $groupsName => $loginAthenaGroup) { if (!array_key_exists($groupsName, $woeStatus)) { $woeStatus[$groupsName] = array(); } foreach ($loginAthenaGroup->athenaServers as $athenaServer) { $serverName = $athenaServer->serverName; $sql = "SELECT agit_status AS woe_status FROM {$athenaServer->charMapDatabase}.ragsrvinfo WHERE `name` = '" . $serverName . "'"; $sth = $loginAthenaGroup->connection->getStatement($sql); $sth->execute(); $woe_status = $sth->fetch(); $woeStatus[$groupsName][$serverName] = array( 'woe_status' => $woe_status->woe_status ); } } // $fp = fopen($cache_woe_status, 'w'); // if (is_resource($fp)) { // fwrite($fp, serialize($woeStatus)); // fclose($fp); // } // } Save and exit. 4. Open fluxcp/themes/your_theme/server/status.php Copy below code and paste it after the end of file <?php foreach ($woeStatus as $privServerName => $gameServers): ?> <h3>War Of Emperium Status for <?php echo htmlspecialchars($privServerName) ?></h3> <table id="server_status"> <tr> <td class="status"><?php echo htmlspecialchars(Flux::message('ServerStatusServerLabel')) ?></td> <td class="status">Status</td> </tr> <?php foreach ($gameServers as $serverName => $gameServer): ?> <tr> <th class="server"><?php echo htmlspecialchars($serverName) ?></th> <td class="status"><?php echo $this->serverUpDown($gameServer['woe_status']) ?></td> </tr> <?php endforeach ?> </table> <?php endforeach ?> Save and exit.
  6. Hi guys, just a little update in create item and edit item pages. ( Finally I'm almost done with these pages ) Item editor has now the ability to populate item bonuses in dropdown select while you type in script, equip script and unequip script to see it in action please do edit the item you see in this list http://aisnippets.x1...tor/item/list/2 and click the 'Scripts' tab ( upper right coner of the editor ) Also I wanna know your opinion and suggestions for more approaches on how to make adding of item bonuses more friendly user Note: only keywords from doc/item_bonus.txt will be shown, but you can still add conditional statements
  7. yeah sure...at my profile http://rathena.org/board/user/1659-jupeto/
  8. File Name: Glalie File Submitter: Jupeto File Submitted: 17 Aug 2012 File Category: Monster Sprites Content Author: Jupeto This sprite is from my past collection here http://www.eathena.w...owtopic=157606/ No. 362 - The evolved form of No. 361 Snorunt. Glalie has a body made of rock, w/c it hardens with an armorof ice. This Pokemon has the ability to freeze moisture in the atmosphere into any shapeit desires. Formore information please click here Preview : This pack contains; - Artwor'X Custom Enhancement.jpg - Artwor'X Custom Enhancement.URL - Readme.txt - glalie.act - glalie.spr - glalie.bmp Just contact me for any problems you see in this monster. Click here to download this file
  9. http://www.youtube.com/watch?v=msn_ntj87wc&feature=BFa&list=AL94UKMTqg-9BX1WZsl4qyRS6NjrYLs2m0
  10. $item->equip_jobs_dropdown = build_equip_job_dropdown( array( 'id' => 'item-equip_jobs', 'class' => 'combobox dk poshy-tooltip-left', 'bitmask' => $item->equip_jobs, 'multiple' => 'multiple', 'size' => '5', 'others' => ' title="Which jobs this item is available for. Values below can be combined to achieve availability for multiple job classes.<span>Tip:</span> Hold CTRL on your keyboard while selecting/deselecting an option." style="height:80px;"', ) );
×
×
  • Create New...