Jump to content

espriketic

Members
  • Posts

    54
  • Joined

  • Last visited

Posts posted by espriketic

  1. Hello, Any resolution regarding this issue? I am also experiencing this error.. 

     

    Here's my main.ini

    //Thor Patcher remote config file
    [Main]
    //Allow patching or not?
    allow=true
    
    //Should patcher ignore everything else and finish patch immediately?
    Force_Start=false
    
    //if not, what message should appear?
    policy_msg=Server is taking a nap.
    
    //file_url - patch files should ALL put here.
    // This config entry will override the one in embed config.
    // o HTTP:
    //         http://domain.com/dir/
    // o FTP:
    //         ftp://domain.com/dir/
    //     o With <Username> [Password] [Port]
    //	ftp://username:[email protected]:port/dir/
    //     o Note: username is required if want put password, otherwise everything is optional.
    file_url=https://jamropatch.googlecode.com/svn/trunk/patcher/data/
    
    [Patch]
    //use CheckSum tool, hash for client & patcher
    // used to make sure exe is up to date
    //  (leave empty to disable this feature)
    ClientSum=
    PatcherSum=
    
    
    //This is compressed file for patcher & client update
    // To make these work, ClientSum and/or PatcherSum can't be empty
    // Note: these files should put same place as patch file (file_url in internal config)
    //Relative address, not FULL URL!
    ClientPath=
    PatcherPath=
    
    // Patch list file
    PatchList=plist.txt
    
    [Stars]
    // Shining o.O (Anyways, its for start button clones)
    // Since orignal client has check sum.. why not for clones? XD
    
    
    //How many? (it should same as amount of start button clone, but of course it's your choice)
    clients=0
    
    // _sum - checksum, use CheckSum tool.
    //client1_sum=
    // _Name - Filename of exe
    //client1_Name=
    // _Path - Path for file [Compressed]
    //client1_Path=
    
    [Misc]
    //Set a limit for fragment, when reach this limit, patcher will ask user to defrag
    FragmentLimit=50
    

    Here's my conf.ini

    [Config:Main]
    
    RootURL='https://jamropatch.googlecode.com/svn/trunk/patcher/'
    
    RemoteConfigFile='main.ini'
    
    TimeOut=0
    
    StatusFile='geiro.dat'
    
    DefaultGRF='geiro.grf'
    
    ClientEXE='JamRO.exe'
    ClientParameter='-1sak1'
    
    FinishOnConnectionFailure=false
    
    [Config:Window]
    AutoResize=true
    Style='none'
    
    Width=
    Height=
    
    DragHandling=true
    
    Background='images/bg.bmp'
    
    FadeOnDrag=false
    
    [Config:BGM]
    File=
    
    Loop=true
    
    Volume=20
    
    Directory=
    
    [Config:Misc]
    Title='Game Patch'
    
    HideProgressBarWhenFinish=true
    
    
    [ProgressBar:bar1]
    Width=342
    Height=10
    
    Left=23
    Top=486
    
    BackColorStart=$009DEEEF
    BackColorEnd=$00C2F1F1
    
    FrontColorStart=$006ED5B0
    FrontColorEnd=$0080DDCA
    
    FrontImage=
    BackImage=
    
    Hook='ProgressChange'
    
    
    
    [Label:Status]
    AutoResize = false
    
    Width=369
    Height=
    
    Left=15
    Top=498
    Alignment='center'
    
    FontColor=$000000
    FontName = ''
    FontSize =
    
    Text=''
    
    Hook='StatusChange'
    
    [NoticeBox:Box0]
    Width=347
    Height=250
    Left=21
    Top=217
    URL='notice.html'
    
    
    
    [Button:Start]
    Default='images/start1.png'
    OnHover='images/start2.png'
    OnDown='images/start3.png'
    
    Left=383
    Top=211
    
    Hook='Start'
    
    [Button:Exit]
    Default='images/Exit1.png'
    OnHover='images/Exit2.png'
    OnDown='images/Exit3.png'
    
    Left=383
    Top=244
    
    Hook='Exit'
    
    [Button:Cancel]
    Default='images/Exit1.png'
    OnHover='images/Exit2.png'
    OnDown='images/Exit3.png'
    
    Left=383
    Top=211
    Hook='Cancel'
    
    
  2. /*//----------------------------------------------------------------//
    //----------------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--------------------------------------------------------
    //-----------------------------------------------------------------------------------
    
    
    

  3. 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?

  4. <?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 /no1

  5. 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..

×
×
  • Create New...