-
Posts
54 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Posts posted by espriketic
-
-
if you have your VPS (i.e. CentOS) you'll need to install it by this code using Putty.
yum install pcre
-
thanks.. i tried google but no DL link found.. Thanks man..
-
-
i hope this will help..
http://www.eathena.ws/board/index.php?showtopic=231477&st=0&p=1263803entry1263803
-
/*//----------------------------------------------------------------// //----------------Scripted by Spera---------------------------------// //------------------FinalStrikeRO-----------------------------------// //--------------------Disguise Event NPC v2-------------------------// /-------------------------------------------------------------------//*/ prontera,164,171,4 script Disguise CP 968,{ if (getgmlevel()<50) { mes "^3399FF[Disguise CP]^000000"; mes "Sorry, you are not a GM!"; close; } mes "^3399FF[Disguise CP]^000000"; mes "Hello GameMaster!"; mes "What do you want to do?"; switch(select("Start Event:Stop Event:Set number of rounds[^E50000"+$guessrounds+"^000000]:Set prize^E50000 ["+getitemname($guessprize)+"]^000000 ^E50000 ["+ $guessprizecount + "]^000000:Nothing")) { case 1: { next; mes "^3399FF[Disguise CP]^000000"; mes "Please confirm by typing START."; input .@confirm$; if (.@confirm$ == "START") { donpcevent "guessAnnouncer::OnGMStart"; close; } mes "Confirmation failed"; close; break; } case 2: { next; mes "^3399FF[Disguise CP]^000000"; mes "Please confirm by typing STOP."; input .@confirm$; if (.@confirm$ == "STOP") { donpcevent "guessAnnouncer::OnGMStop"; close; } mes "Confirmation failed"; close; break; } case 3: { next; mes "^3399FF[Disguise CP]^000000"; mes "Please type in the new number."; input $guessrounds; if ($guessrounds > 30) set $guessrounds, 30; else if ($guessrounds < 1) set $guessrounds, 1; close; } case 4: { next; mes "^3399FF[Disguise CP]^000000"; mes "Please type in the new prize id."; input .@guessprizeid; if (getitemname(.@guessprizeid) == "null" || getitemname(.@guessprizeid) == "") {next; mes "^3399FF[Disguise CP]^000000"; mes "Error"; mes "This item does not exist in the database..."; close;} set $guessprize, .@guessprizeid; next; mes "^3399FF[Disguise CP]^000000"; mes "Please type in the amount."; input .@guessprizeamount; if (!.@guessprizeamount) set .@guessprizeamount,1 ; set $guessprizecount,.@guessprizeamount; next; mes "^3399FF[Disguise CP]^000000"; mes "Prize has been set to ^E50000 "+ getitemname($guessprize)+ "^000000 and the amount to ^E50000 " +$guessprizecount+"^000000"; close; } case 5: { next; mes "^3399FF[Disguise CP]^000000"; mes "Good bye"; close; } } } quiz_02,45,382,4 script Disguise NPC 794,{ if (!$guessbegin) { mes "^3399FF[Disguise NPC]^000000"; mes "The event is going to start soon!"; close; } end; OnStart: set $guessbegin, 1; set .DisguiseWon, 0; if (!$DisguiseRound) { npctalk "Alright. Let's get it over with ~.~ "; sleep 4000; npctalk "But first I will explain to you how to play the game."; sleep 6000; npctalk "I am going to disguise into a random monster."; sleep 5000; npctalk "You have to guess the monster's name and shout it out."; sleep 5000; npctalk "Don't bother about the use of capital and small initial letters."; sleep 8000; npctalk "Now get ready."; sleep 5000; } else if ($DisguiseRound < $guessrounds-1) { npctalk "Get ready for the next round."; setnpctimer 0; sleep 8000; } else { npctalk "Last round now!"; sleep 2000; npctalk "Get ready."; sleep 6000; } do { set .@guessrepeat, 0; set $monster, 1000 + rand(1,950); for (set .@k, 0; .@k <getarraysize($Forbidden); set .@k, .@k+1) { if ($monster == $Forbidden[.@k]) { set .@guessrepeat, 1; break; } } } while (.@guessrepeat); setnpctimer 0; initnpctimer; setnpcdisplay "Disguise NPC",$monster; set $MonsterName$, strmobinfo(1,$monster); defpattern 1, "([^:]+):.*s"+$MonsterName$+"(.*)", "winround"; activatepset 1; npctalk "What's my name?"; sleep 3000; npcwalkto 48,382; sleep 2000; npcwalkto 40,382; sleep 2000; npcwalkto 45,382; end; OnTimer10000: if (!.DisguiseWon) { npctalk "Come on. What monster am I?"; sleep 3000; npcwalkto 48,382; sleep 2000; npcwalkto 40,382; sleep 2000; npcwalkto 45,382; if (!$guessactive) {disablenpc "guesswarp"; disablenpc "guessexit"; disablenpc "Disguise NPC"; end;} } end; OnTimer25000: if (!.DisguiseWon) { npctalk "Nobody knows that monster?"; sleep 3000; npcwalkto 48,382; sleep 2000; npcwalkto 40,382; sleep 2000; npcwalkto 45,382; } end; OnTimer35000: if (!.DisguiseWon) { npctalk "You get 10 more seconds to guess my name."; sleep 3000; npcwalkto 48,382; sleep 2000; npcwalkto 40,382; sleep 2000; npcwalkto 45,382; } end; OnTimer45000: if (!.DisguiseWon) { npctalk "Round is over."; if (!$guessactive) {disablenpc "guesswarp"; disablenpc "guessexit"; disablenpc "Disguise NPC"; end;} set $DisguiseRound, $DisguiseRound + 1; sleep 3000; deletepset 1; npctalk $MonsterName$ + " would have been the correct answer."; sleep 5000; if ($DisguiseRound >= $guessrounds) { set $DisguiseRound, 0; sleep 3000; npctalk "Event is over now!"; sleep 3500; npctalk "See ya guys"; sleep 2000; emotion 12; sleep 1000; set $guessactive, 0; setnpcdisplay "Disguise NPC",794; disablenpc "Disguise NPC"; enablenpc "guessexit"; end; } goto OnStart; } end; winround: setnpctimer 0; deletepset 1; set .DisguiseWon, 1; set $DisguiseRound, $DisguiseRound + 1; npctalk strcharinfo(0) + " got my right name!"; sleep2 3000; npctalk $MonsterName$ + " is the correct answer."; sleep2 3000; npctalk "Take this as a reward."; getitem $guessprize, $guessprizecount; if (!$guessactive) {disablenpc "guesswarp"; disablenpc "guessexit"; disablenpc "Disguise NPC"; end;} if ($DisguiseRound >= $guessrounds) { set $DisguiseRound, 0; set $guessactive, 0; sleep 3000; npctalk "Event is over now!"; sleep 3500; npctalk "See ya guys"; sleep 2000; emotion 12; sleep 1000; setnpcdisplay "Disguise NPC",794; disablenpc "Disguise NPC"; enablenpc "guessexit"; end; } sleep 5000; goto OnStart; end; } //----------------------------------------------------------------------------------- //----------------------------------------------------------------------------------- - script guessAnnouncer -1,{ OnGMStart: if ($guessactive) end; set $guessactive, 1; announce "A Gamemaster has started the Disguise Event",0; set $guessbegin, 0; sleep 3000; if (!$guessactive) end; announce "If you want to join, come to the main town and enter the warp portal.",0; enablenpc "guesswarp"; enablenpc "Disguise NPC"; sleep 3000; announce "Number of Rounds: "+$guessrounds,0; sleep 2000; announce "Prize: "+ getitemname($guessprize) + " x " + $guessprizecount,0; sleep 2000; if (!$guessactive) {disablenpc "guesswarp"; disablenpc "guessexit"; disablenpc "Disguise NPC"; end;} announce "The portal is going to close in one minute.",0; announce "If you want to join, come to the main town and enter the warp portal.",0; sleep 60000; if (!$guessactive) {disablenpc "guesswarp"; disablenpc "guessexit"; disablenpc "Disguise NPC"; end;} announce "The portal has been closed.",0; disablenpc "guesswarp"; set $DisguiseRound, 0; if (!$guessactive) {disablenpc "Disguise NPC"; end;} if(getmapusers("quiz_02") == 0) { disablenpc "Disguise NPC"; set $guessactive, 0; end; } donpcevent "Disguise NPC::OnStart"; end; OnGMStop: if ($guessactive) { set $guessactive, 0; announce "A Gamemaster has stopped the Disguise Event",0; set $DisguiseRound, 0; setnpcdisplay "Disguise NPC",794; disablenpc "Disguise NPC"; disablenpc "guesswarp"; enablenpc "guessexit"; } end; OnClock1000: OnClock1200: OnClock1400: OnClock1800: OnClock2000: if ($guessactive) end; set $guessactive, 1; announce "The server is starting a Disguise Event now.",0; set $guessbegin, 0; sleep 3000; if (!$guessactive) end; announce "If you want to join, come to the main town and enter the warp portal.",0; enablenpc "guesswarp"; enablenpc "Disguise NPC"; disablenpc "guessexit"; sleep 2000; announce "Prize: "+ getitemname($guessprize) + " x " + $guessprizecount,0; sleep 2000; if (!$guessactive) {disablenpc "guesswarp"; disablenpc "guessexit"; disablenpc "Disguise NPC"; end;} announce "The portal is going to close in one minute.",0; sleep 60000; if (!$guessactive) {disablenpc "guesswarp"; disablenpc "guessexit"; disablenpc "Disguise NPC"; end;} announce "The portal has been closed.",0; disablenpc "guesswarp"; if (!$guessactive) {disablenpc "Disguise NPC"; end;} announce "Next Event will start in 2 hours.",0; set $DisguiseRound, 0; if(getmapusers("quiz_02") == 0) { disablenpc "Disguise NPC"; set $guessactive, 0; end; } donpcevent "Disguise NPC::OnStart"; end; OnInit: disablenpc "Disguise NPC"; disablenpc "guesswarp"; disablenpc "guessexit"; set $guessactive, 0; setarray $Forbidden[0],1003,1006,1017,1021,1022,1027,1043,1136,1137,1168,1171,1172,1173,1181,1210,1217,1218,1223,1284,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1407,1411,1414,1496,1501,1900; } //----------------------------------------------------------------------------------- //------------------Warp Portal------------------------------------------------------ prontera,156,172,0 warp guesswarp 2,2,quiz_02,46,375 quiz_02,55,382,0 warp guessexit 2,2,prontera,155,185 //----------------------------------------------------------------------------------- //------------------Map Flags-------------------------------------------------------- //-----------------------------------------------------------------------------------
-
Can someone provide me where can i download this 2011-11-09rdata_j.gpf
-
items sprite from port malaya mobs are unkown item...
-
Hopefully someone could add those feature..
-
sir, can you please enlighten me about matching lubs instead of lus? Do you mean, i should use the lua files that suits my client? and sir, does it affect the lua? coz i have some of customs in my lua files.. or i shall only update the lub only? Thanks sir for reply..
-
Sorry if wrong section to post... I would like to request as the Topic Title says additional feature in control panel. Only available in GM Level 99..
-
nanoray can you share your client?
-
ResetTheHotKey
attempt to call a nil value
queryRegionInfo
attempt to call a nil value
Is there anyone who has a patched 2011-11-16aRagexeRE Client (GRF, Multiple Window, and ViewID 30,000)?
Using Windows7 OS, I can't run the client that I make.
-
open notepad, copy/paste the code and save it as delete.php or something you want but it must be .php
upload the file and when you want to delete accounts, just go to the location of that file.
-
3CeaM -> rAthena
DROP TABLE `skillcooldown`; ALTER TABLE `login` CHANGE `level` `group_id` tinyint(3) NOT NULL default '0'; ALTER TABLE `char` CHANGE `weapon` `weapon` smallint(6) unsigned NOT NULL default '0'; ALTER TABLE `char` ADD COLUMN `robe` smallint(6) UNSIGNED NOT NULL default '0' AFTER `head_bottom`
dunno the rest. might be wrong xD.
is this working? have anyone tested this?
-
Thanks a lot!!
-
I am running the latest rAthena server with my old client (20100730). Is there any client available? (preferably latest and working to upgrade my client) Cause my client is getting an error on Malaya Port Mobs.
-
same prob as cronich
-
<?php // Original Script created by : Wouter2004 // Simple edits to make it fully working by : martin (http://martint.net) // Updated by : Kisuka // Change these variables. $mysqlserver = "127.0.0.1"; // IP of the mySQL server. $db = "ragnarok"; // Your ragnarok database. $user = "ragnarok"; // mySQL username. $pass = "ragnarok"; // mySQL password. $date = "2012-02-20"; // Delete all account of users that haven't logged in since (YYYY-MM-DD). // ---------------------------------------------------------- // Dont edit anything below unless you know what your doing!! // ---------------------------------------------------------- mysql_connect($mysqlserver,$user, $pass) or die(mysql_error()); mysql_select_db($db) or die(mysql_error()); $num = 0; $result = mysql_query("SELECT * FROM `login` WHERE lastlogin < '$date 00:00:00' ") or die(mysql_error()); echo("<h2>This script will now clean up your database!</h><b<b"); while ($row = mysql_fetch_array($result)){ //Fetch all the login accounts in an array. $result2 = mysql_query("SELECT * FROM `char` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); $num++; echo("<b".$num."- Account: ".$row[account_id]."- Name: ".$row[userid].""); while ($row2 = mysql_fetch_array($result2)){ //Fetch all the char id's in an array. mysql_query("DELETE FROM `global_reg_value` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `inventory` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `skill` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `cart_inventory` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `pet` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `friends` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `char` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `auction` WHERE seller_id = ".$row2[char_id]." ") or die(mysql_error()); // Check for a homunculus. $result3 = mysql_query("SELECT * FROM `homunculus` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); $row3 = mysql_fetch_array($result3); $num_results3 = mysql_num_rows($result3); if ($num_results3 > 0){ mysql_query("DELETE FROM `homunculus` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `skill_homunculus` WHERE homun_id = ".$row3[homun_id]." ") or die(mysql_error()); } // Check if guild leader. $result4 = mysql_query("SELECT * FROM `guild` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); $row4 = mysql_fetch_array($result4); $num_results4 = mysql_num_rows($result4); if ($num_results4 > 0){ mysql_query("DELETE FROM `guild` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `guild_alliance` WHERE guild_id = ".$row4[guild_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `guild_castle` WHERE guild_id = ".$row4[guild_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `guild_expulsion` WHERE guild_id = ".$row4[guild_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `guild_member` WHERE guild_id = ".$row4[guild_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `guild_position` WHERE guild_id = ".$row4[guild_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `guild_skill` WHERE guild_id = ".$row4[guild_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `guild_storage` WHERE guild_id = ".$row4[guild_id]." ") or die(mysql_error()); }else{ mysql_query("DELETE FROM `guild_member` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); } mysql_query("DELETE FROM `hotkey` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `mail` WHERE dest_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `memo` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `quest` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `quest_objective` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); } mysql_query("DELETE FROM `storage` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `global_reg_value` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `login` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `party` WHERE leader_id = ".$row[account_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `sc_data` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); } ?>
I don't own this code
-
try to leave the URI blank as is = ""
-
can i have that script too? thanks
-
I want this too...
-
Thanks but I already all the Blue Letters card all I need now is the Numbers
btw, I use your Arsinoe in our server and it's great
-
I would like to request a Complete Blue Cards (Letters and Numbers) e.g. RWC 2011 Cards
I only have these cards...
ID - Letter
7461 A
6011 B
6012 C
7462 E
7463 F
7719 G
7464 H
6013 J
7465 L
6015 M
7466 N
7467 O
7468 P
6016 Q
7714 R
6017 T
7469 U
6018 V
7470 W
7471 Y
6019 Z
6054 6
6236 7
Sorry for wrong section post.
I already have the a-z blue cards, 6 and 7 blue cards, i need the Number 0-5 cards and 8-9..
-
Problem solve!
I change the Mob id into lower, all my mobs sprite is now working
Thor patcher - 'Failed to communicate with server'
in Tulong para sa 3rd Party Application
Posted
Hello, Any resolution regarding this issue? I am also experiencing this error..
Here's my main.ini
Here's my conf.ini