Jump to content

Poring King

Donators
  • Posts

    842
  • Joined

  • Last visited

  • Days Won

    13

Posts posted by Poring King

  1. On 4/7/2022 at 5:43 AM, WillJocker said:
    DROP TABLE IF EXISTS `reward_codes`;
    DROP TABLE IF EXISTS `reward_logs`;
    CREATE TABLE IF NOT EXISTS `reward_codes` (
    	`promo` VARCHAR(26) NOT NULL DEFAULT '',
    	`nameid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
    	`item_name` VARCHAR(50) NOT NULL DEFAULT '',
    	`amount` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
    	`time_created` DATETIME NOT NULL DEFAULT '00-00-0000 00:00:00',
    	`limit` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    	`pool` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    	PRIMARY KEY (`promo`)
    ) ENGINE = MYISAM;
    CREATE TABLE IF NOT EXISTS `reward_logs` (
    	`account_id` int(11) unsigned NOT NULL default '0',
    	`last_ip` BINARY( 9 ) NOT NULL,
    	`code` VARCHAR( 26 ) NOT NULL,
    	`redeem_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    	`claim` INT( 10 ) NOT NULL,
    	PRIMARY KEY (`code`)
    ) ENGINE = MYISAM;

    error in database, #1067 - Valor padrão (default) inválido para 'time_created'

    invalid format     `time_created` DATETIME NOT NULL DEFAULT '00-00-0000 00:00:00',
    . Help plis?

     image.thumb.png.b2e98fa2aa56058b69fb21b903b834b4.png

    At the top of the script . There is a guide that you will need to install manually and automatically ...

  2. On 2/8/2022 at 11:48 AM, ryukazuna said:

    https://github.com/rathena/rathena/blob/master/npc/custom/barters.yml you need to understand this barter shop system workflow. 

    this is an example to the first item on your picture , NPC located on prontera,156,183 and selling holy water and cursed water for 1 bloody coins :

    Body:
      - Name: Barter Shop
        Map: prontera
        X: 156
        Y: 183
        Direction: South
        Sprite: 2_F_SIGN1
        Items:
          - Index: 0
            Item: Holy_Water
            RequiredItems:
              - Index: 0
                Item: Bloody_Coin
                Amount: 1
          - Index: 1
            Item: Water_Of_Darkness
            RequiredItems:
              - Index: 0
                Item: Bloody_Coin
                Amount: 1

    Result Picture :

      Hide contents

    956395740_Screenshot(25).thumb.png.9c1c19c02cd5e20b5dcac7dead7d1c92.png

     

    This is new to me LOL . Its been a while since i play rAthena

  3. 30 minutes ago, dolphincute said:

    as title i need help if anyone know any tools for it, i need it to be convert to file (data) not GRF most the tools i been using extract to grf

    Open the data that has been extracted to your GRF .. you will find the data that has been made or split into a lot of piece for login and loading-screen.bg

  4. I would love to see this too


    Auto-Attack System : Summon 3 different clone each level lvl 1 Sniper , lvl 2 Whitesmith and lvl 3 is High priest
    Job: Priest

    Create Nugget : Jump to enemy inside cell 1x1
    Job: Stalker

    Fire Ivy: Swap enemy with your location
    Job: High Wizard


     

    • Love 1
    • Like 1
  5. 1 hour ago, piches48 said:

    start and used his service smoothly but after 2days ago, when i had ordering pokemon pets ,and pay him.  i got scammed , he did close his facebook and  ucking gone.  my bad, that i trust someone easily, i got lesson big times. don't trust anyone that you have never known personally espcially with the money. 

     

    his facebook is jerome mapaqchuckie.

     

     

    It is sad to read this thread . I really dont know why you all want a different service instead browsing on rathena trusted 3rd Party Service .

  6. 2 hours ago, kenetitsss said:

    Hello,

    Can i request for a Time based WOE KOE reward system?

    Functions:
    Reward will be triggered for WOE / KOE time only.
    If you stayed for total of 20mins in WOE / KOE you will receive 10points

    Then after that every succeeding 5mins you will receive 2points

    Check idling every 2mins if player is idle the timer will pause and when move again the timer will resume the counting.

    Willing to pay if you have a working script. Thanks!

    I sent you PM for this i have this kind of script ... 

     

    MY NPC Contain this

    • WOE GUILD POINTS
    • WOE PLAYER KILLING POINTS
    • WOE PLAYER KILLING POINTS SHOP
    • WOE TIME BASE PERFORMANCE
  7. On 6/24/2021 at 2:37 PM, simplexjay2 said:

    I want to change this zeny to cash and kafra to zeny to pods and other ticket

    Remove all "Set Points" and change it to getitem pods

    prontera,x,y,3	script	Test	99{
    
    mes "Hello"
    Switch(select("Option 1","Option 2")){
    	case 1:
    			mes "This is Option 1";
    			end;
    	case 2:
    			mes "This is Option 2";
    			getitem 503,1; // This is the code for getting item
    			end;
    	}
    	end;
    }

     

  8. On 6/12/2021 at 9:38 PM, myimmortal said:

    this problem is fixed.

    I got a new problem.

    I want to use 2021-01-07aRagexeRE.exe to support to kRO_FullClient_20210406.

    How to config enable /disable on Nemo?

    I dont support early version what rAthena offer you should stay on in . Having latest Client meaning do it on your own less support & lots of bug . Thats why rAthena only offer the most stable client ...

    • Upvote 1
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.