hendra814

December 2, 2019

6 hours ago, rolandiex said:

check if that table exists in your SQL DB, or if it is updated to your emulator.

@hendra814

in your inter_server.yml change Table: "storage_char_9?" <<<<<<<< to Table: "storage_char_9"

- ID: 19
Name: "Storage"
Table: "storage_char_9?" <<<<<<<< to Table: "storage_char_9"
Max: 300

charstore.txt 25.57 kB · 0 downloads import - inter_server.yml 2.16 kB · 0 downloads

@rolandiex

Thanks, the problem already solve

November 22, 2019

19 hours ago, admagnus said:

i have the same trouble!

Are you using lastest rathena, because on mine work well

image.png.b1a15a27daf456cf6a2c0551a59749e4.png

November 22, 2019

Dear,

Today i got error when using this feature,

could you help me to fix it

here the screen shoot of the error on char console

image.png.8ffc66df0032cd30b03dec5fe5769bb7.png

November 18, 2019

Quote

-	script	DoubleEXP	-1,{

OnSat:
OnSun:
	announce "Double Experience Begin!",bc_blue|bc_all;
	set .br,getbattleflag("base_exp_rate")*2;
	set .jr,getbattleflag("job_exp_rate")*2;
   	setbattleflag("base_exp_rate",.br);
	setbattleflag("job_exp_rate",.jr);
	atcommand "@reloadmobdb";
	end;

OnMon:
	announce "Double Experience already finish!",bc_blue|bc_all;
	atcommand "@reloadbattleconf";
	atcommand "@reloadmobdb";  
	end;
}

November 7, 2019

bump

October 28, 2019

10 hours ago, domez86 said:

hello, what does the value "3" mean?
in ---> if (strcharinfo (3)

Here the explanation

Quote

0 - Character's name.
1 - The name of the party they're in if any.
2 - The name of the guild they're in if any.
3 - The name of the map the character is in.

October 23, 2019

3 hours ago, Xenduria said:

Looking for a shadow equipment refiner.

A few specifications if possible:

Have 2-3 different refining services - normal refine // Enhanced % chance // downgrade when failed attempt.

each of the services uses different item similar to: Oridecon > Enriched Oridecon > HD Oridecon.

Should have a zeny cost.

If there is something already created out there that is similar i may be able to settle with that! Post them up

Thanks in advanced guys and gals

rathena already have that feature try look at npc\re\merchants\shadow refiner.txt

October 2, 2019

On 9/27/2019 at 4:55 PM, mathlister said:

please Help me!

script is ok!

but when i click on ( BUY ITEM )

its Show error...

Please check your database, are the item already have in your database

universal catalog gold item ID 12571

Unlimited fly wing item ID 17229

HP Pill item ID 12274

SP PIll item ID 12275

Authoritative Badge item ID 622

Unlimited concentration item ID 17226

Unlimited Awakening Item ID 17227

Unlimited Berserk item ID 17228

Unlimited Giant Fly Wing item ID 17314

July 22, 2019

On 7/20/2019 at 1:03 AM, Hazo- said:

Nope still same , no warp at all or dont give Quest either also the questions pops up everytime

Are you already answer all the question with right answerr?

July 19, 2019

7 hours ago, Hazo- said:

Followed everything but it doesnt give me Quest or either it doesnt warp me to the maps, Also GM Notice pops up every single time is.

Can someone share his working script maybe? or help me to Solve this Problems.

Try this

Gramps_Weekly_TurnIn_rev.txt

June 18, 2019

On 6/11/2019 at 1:05 PM, ittiphol said:

How to set account user to vip

thank you.

please read at first post, and then apply the script in your server

Then register using your char into the NPC

May 14, 2019

Check your inter_athena.conf at conf folder

May 8, 2019

1 hour ago, caspa said:

is there anyway to make this sequence? like case 1 first then case 2 then case 3?

not sure, but try with

switch(1,3)

May 8, 2019

17 minutes ago, caspa said:

is there anyway to make this sequence? like case 1 first then case 2 then case 3?

Sequence for getmapuser in pub room?

i think it's already sequence

May 8, 2019

3 hours ago, Gladius said:
use < "+strcharinfo(0)+" > in command
		atcommand "@repairall "+strcharinfo(0)+"'";
		atcommand "@identifyall "+strcharinfo(0)+"'";
if you do not use, you can from the error in some situations.

nope, my script not use < "+strcharinfo(0)+" >

and it's working

identification.txt

But this only for identification, to get free identification must doing quest.

May 8, 2019

45 minutes ago, caspa said:

it doesnt rotate

the waitingroom dont rotate.. you need to click the npc first before the waitingroom change...

quiz_02,287,265,4	script	Ultimate PvP Warper	417,{
	if (.pvp_square$=="") donpcevent "Ultimate PVP warper::OnClock0000";
 
	mes "[PvP Warper]";
	mes "Which arena do you want to join?";
	switch(select("All Job                 ["+getmapusers(.pvp_square$)+"/128]:Max lvl 99            ["+getmapusers("pvp_y_2-2")+"/128]:3rd Baby Class ["+getmapusers("pvp_y_1-2")+"/128]")) {
	case 1:	// PVP Square
		if (getmapusers(.pvp_square$) > 127) callsub S_full;
		warp .pvp_square$,0,0;
		announce "Player "+strcharinfo(0)+" join arena PVP All Job !!",bc_all;
		end;
  
	case 2:	// PVP Low Level
		if (getmapusers("pvp_y_2-2") > 127) callsub S_full;
		if (BaseLevel > 99) { // Edit 150 to any maximum Lvl of a player can enter this room
			mes "Only for level 1 - 99";
			close;
		}
		warp "pvp_y_2-2",0,0;
		announce "Player "+strcharinfo(0)+" join arena PVP Max lvl 99 !!",bc_all;
		end;
 
	Case 3: // Baby Class
		if (getmapusers("pvp_y_1-2") > 127) callsub S_full;
		if (class < 4096 || class > 4112) goto L_NotBaby;
		warp "pvp_y_1-2",0,0;
		announce "Player "+strcharinfo(0)+" join arena PVP 3rd Baby Class !!",bc_all;
		end;
L_NotBaby:
		mes "This room only for 3rd baby class";
		close;
}

S_full:
		mes "Sorry, The arena already full. Please wait...";
		close;
 
OnInit:
	OnTimer5000:
	delwaitingroom;
	switch(rand(1,3)) {
Case 1:
	waitingroom getmapusers(.pvp_square$)+" player"+( getmapusers(.pvp_square$) > 1 ? "s":"") +" in arena All Job", 0;
	goto Timer;
	end;
	break;

Case 2:
	waitingroom getmapusers("pvp_y_2-2")+" player"+( getmapusers("pvp_y_2-2") > 1 ? "s":"") +" in arena Max lvl 99", 0;	
	goto Timer;
	end;
	break;

Case 3:
	waitingroom getmapusers("pvp_y_1-2")+" player"+( getmapusers("pvp_y_1-2") > 1 ? "s":"") +" in arena 3rd Baby Class", 0;	
	goto Timer;
	end;
	break;
Timer:
	initnpctimer;
}

OnClock0000:
	// set the "PVP Square" map, based on day of the weeek
	switch(gettime(4)) {
	case 0:	// Sunday
	case 1:	// Monday
		set .pvp_square$, "pvp_y_7-2";
		break;
	case 2:	// Tuesday
	case 3:	// Wednesday
		set .pvp_square$, "guild_vs3";
		break;
	case 4:	// Thursday
	case 5:	// Friday
		set .pvp_square$, "pvp_y_7-2";
		break;
	case 6:	// Saturday
		set .pvp_square$, "guild_vs3";
		break;
	}
}

April 23, 2019

13 minutes ago, rolandiex said:

@hendra814 this script

prontera,159,193,4	script	Mellina Kafra	894,{
	callfunc("F_CheckKafCode");
	query_sql("SELECT `char_num` FROM `char` WHERE char_id = '"+getcharid(0)+"'", .@char_num);
	openstorage2(.@char_num,STOR_MODE_GET|STOR_MODE_PUT);
end;
}

requiere

Body:  
    - ID: 1
      Name: "Storage"
      Table: "storage_char_0"
   
    - ID: 2
      Name: "Storage"
      Table: "storage_char_1"
    
    - ID: 3
      Name: "Storage"
      Table: "storage_char_2"
      
    - ID: 4
      Name: "Storage"
      Table: "storage_char_3"
     
    - ID: 5
      Name: "Storage"
      Table: "storage_char_4"
      
    - ID: 6
      Name: "Storage"
      Table: "storage_char_5"
    
    - ID: 7
      Name: "Storage"
      Table: "storage_char_6"
    
    - ID: 8
      Name: "Storage"
      Table: "storage_char_7"
 
    - ID: 9
      Name: "Storage"
      Table: "storage_char_8"
 
    - ID: 10
      Name: "Storage"
      Table: "storage_char_9"

    - ID: 11
      Name: "Storage"
      Table: "storage_char_10"

    - ID: 12
      Name: "Storage"
      Table: "storage_char_11"
 
    - ID: 13
      Name: "Storage"
      Table: "storage_char_12"
   
    - ID: 14
      Name: "Storage"
      Table: "storage_char_13"
 
    - ID: 15
      Name: "Storage"
      Table: "storage_char_14"

only change

- ID: 10 to - ID: 1

- ID: 11 to - ID: 2 ...etc.

Sorry, late update, I already fix the problem on sql part.

for sql script, i'm use in first page and it's working now.

April 22, 2019

On 4/19/2019 at 12:33 AM, sader1992 said:

please put all your code here , sql/yml/script/rathena hash

here my scipt, yml and sql

Personal_storage.txt

inter_server.yml

personal_storage.sql

I'm using lastest rathena.

April 18, 2019

i've got error on my char server

Quote

: DB error - Can't find file: '.\ragnarok\?"storage_char_0".frm' (errno: 22)

			[Debug]: at g:\ro files\rathena 2017-06-14\trunk\src\char\int_storage.cpp:164 - SELECT  `id`,`account_id`,`nameid`,`amount`,`equip`,`identify`,`refine`,`attribute`,`card0`,`card1`,`card2`,`card3`,`option_id0`,`option_val0`,`option_parm0`,`option_id1`,`option_val1`,`option_parm1`,`option_id2`,`option_val2`,`option_parm2`,`option_id3`,`option_val3`,`option_parm3`,`option_id4`,`option_val4`,`option_parm4`,`expire_time`,`bound`,`unique_id` FROM `?"storage_char_0"` LIMIT 1;

			[SQL]: DB error - Can't find file: '.\ragnarok\storage_char_9?.frm' (errno: 22)

			[Debug]: at g:\ro files\rathena 2017-06-14\trunk\src\char\int_storage.cpp:164 - SELECT  `id`,`account_id`,`nameid`,`amount`,`equip`,`identify`,`refine`,`attribute`,`card0`,`card1`,`card2`,`card3`,`option_id0`,`option_val0`,`option_parm0`,`option_id1`,`option_val1`,`option_parm1`,`option_id2`,`option_val2`,`option_parm2`,`option_id3`,`option_val3`,`option_parm3`,`option_id4`,`option_val4`,`option_parm4`,`expire_time`,`bound`,`unique_id` FROM `storage_char_9?` LIMIT 1;

what is this?

i already execute the sql part into my sql

April 18, 2019

7 hours ago, rolandiex said:

@hendra814

NPC:

prontera,159,193,4	script	Personal storage#prt	113,{
	mes "[Personal storage]";
	mes "Here, let me open";
	mes "your Storage for you.";
	mes "Thank you for using";
	mes "the Kafra Service.";
	.@nb = query_sql("SELECT char_num FROM `char` WHERE char_id = '"+getcharid(0)+"' AND account_id = '"+getcharid(3)+"'", .@char_num$);
	close2;
	if (.@char_num$ == "0")	openstorage2 (10,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "1")	openstorage2(11,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "2")	openstorage2(12,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "3")	openstorage2(13,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "4")	openstorage2(14,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "5")	openstorage2(15,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "6")	openstorage2(16,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "7")	openstorage2(17,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "8")	openstorage2(18,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "9")	openstorage2(19,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "10")	openstorage2(20,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "11")	openstorage2(21,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "12")	openstorage2(22,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "13")	openstorage2(23,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "14")	openstorage2(24,STOR_MODE_GET|STOR_MODE_PUT);
	else mes "Can`t open storage. Unknown char_id.";
	end;
}

interserver.yml

Body:  
    - ID: 10
      Name: "Storage"
      Table: "storage_char_0"
      Max: 300
      
    - ID: 11
      Name: "Storage"
      Table: "storage_char_1"
      Max: 300
      
    - ID: 12
      Name: "Storage"
      Table: "storage_char_2"
      Max: 300
      
    - ID: 13
      Name: "Storage"
      Table: "storage_char_3"
      Max: 300
      
    - ID: 14
      Name: "Storage"
      Table: "storage_char_4"
      Max: 300
      
    - ID: 15
      Name: "Storage"
      Table: "storage_char_5"
      Max: 300
      
    - ID: 16
      Name: "Storage"
      Table: "storage_char_6"
      Max: 300
      
    - ID: 17
      Name: "Storage"
      Table: "storage_char_7"
      Max: 300
      
    - ID: 18
      Name: "Storage"
      Table: "storage_char_8"
      Max: 300
      
    - ID: 19
      Name: "Storage"
      Table: "storage_char_9"
      Max: 300
      
    - ID: 20
      Name: "Storage"
      Table: "storage_char_10"
      Max: 300
      
    - ID: 21
      Name: "Storage"
      Table: "storage_char_11"
      Max: 300
      
    - ID: 22
      Name: "Storage"
      Table: "storage_char_12"
      Max: 300
      
    - ID: 23
      Name: "Storage"
      Table: "storage_char_13"
      Max: 300
      
    - ID: 24
      Name: "Storage"
      Table: "storage_char_14"
      Max: 300

and sql

CREATE TABLE IF NOT EXISTS `storage_char_0` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_1` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_2` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_3` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_4` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_5` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_6` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_7` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_8` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_9` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_10` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_11` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_12` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_13` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `storage_char_14` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` smallint(5) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` int(11) unsigned NOT NULL default '0',
  `identify` smallint(6) unsigned NOT NULL default '0',
  `refine` tinyint(3) unsigned NOT NULL default '0',
  `attribute` tinyint(4) unsigned NOT NULL default '0',
  `card0` smallint(5) unsigned NOT NULL default '0',
  `card1` smallint(5) unsigned NOT NULL default '0',
  `card2` smallint(5) unsigned NOT NULL default '0',
  `card3` smallint(5) unsigned NOT NULL default '0',
  `option_id0` smallint(5) NOT NULL default '0',
  `option_val0` smallint(5) NOT NULL default '0',
  `option_parm0` tinyint(3) NOT NULL default '0',
  `option_id1` smallint(5) NOT NULL default '0',
  `option_val1` smallint(5) NOT NULL default '0',
  `option_parm1` tinyint(3) NOT NULL default '0',
  `option_id2` smallint(5) NOT NULL default '0',
  `option_val2` smallint(5) NOT NULL default '0',
  `option_parm2` tinyint(3) NOT NULL default '0',
  `option_id3` smallint(5) NOT NULL default '0',
  `option_val3` smallint(5) NOT NULL default '0',
  `option_parm3` tinyint(3) NOT NULL default '0',
  `option_id4` smallint(5) NOT NULL default '0',
  `option_val4` smallint(5) NOT NULL default '0',
  `option_parm4` tinyint(3) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  `bound` tinyint(3) unsigned NOT NULL default '0',
  `unique_id` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

I use this in the last rathena and use this for command @charstore

-	script	charstorage	-1,{

	OnInit: //The script starts when loaded
		bindatcmd "charstore",strnpcinfo(3)+"::OnAtcommand",0,99;
		end;
		
OnAtcommand:
	.@nb = query_sql("SELECT char_num FROM `char` WHERE char_id = '"+getcharid(0)+"' AND account_id = '"+getcharid(3)+"'", .@char_num$);
	if (.@char_num$ == "0")	openstorage2 (10,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "1")	openstorage2(11,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "2")	openstorage2(12,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "3")	openstorage2(13,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "4")	openstorage2(14,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "5")	openstorage2(15,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "6")	openstorage2(16,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "7")	openstorage2(17,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "8")	openstorage2(18,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "9")	openstorage2(19,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "10")	openstorage2(20,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "11")	openstorage2(21,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "12")	openstorage2(22,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "13")	openstorage2(23,STOR_MODE_GET|STOR_MODE_PUT);
	else if (.@char_num$  == "14")	openstorage2(24,STOR_MODE_GET|STOR_MODE_PUT);
	else mes "Can`t open storage. Unknown char_id.";
	end;
}

Thanks,

I Will try it.

April 4, 2019

already add the files and execute sql file, but get same error

image.png.cbfaf1fed256febef23cb39c4e6980d0.png

what did i miss?

March 28, 2019

11 minutes ago, CyberDevil said:

I don't know this software because I use phpMyAdmin directly on a web server, but if you have an area where you can paste any queries, you can copy a few hundred lines at a time and run the query, thus dividing the data into more trances... for example I started the queries by copying 500 items at a time, but remember to insert the first line "INSERT INTO `cp_itemdesc` (`itemid`, `itemdesc`) VALUES" to each query.
Otherwise another method is to rename (for backup) or delete your "cp_itemdesc" table and recreate it by query, importing this other file which I attached below (it is the same sql file but with the addition of table creation and alteration queries).

cp_itemdesc_with_table.zip 782.29 kB · 0 downloads

Thanks a alot, i will try import this file

March 28, 2019

how to upload it into sql?

use import or how?

Because i'm using MySQL query browser and open it as script and then execute, have error like this

image.png.74167cc556a08f8d3316f3fd80c91573.png

March 6, 2019

On 3/5/2019 at 8:52 PM, squall91x said:

i explain my problem : when a player buy vip can you help me to set a message like : "You already get a vip service, come back when your're service has expired".?

i seen you already make some change, that's why the script not work normally.

here the script like you want.

Spoiler

prontera,140,226,6	script	VIP System	109,{

set .@Timer, vip_status(VIP_STATUS_EXPIRE);

mes "[ VIP NPC ]";
mes "Welcome "+strcharinfo(0)+",";
mes "Please choose the menu.";
mes "^FF0000Your VIP Status will Expire at:^000000";
mes gettimestr("%Y-%m/%d %H:%M:%S",21,vip_status(VIP_STATUS_EXPIRE));
mes "^FF0000Time Left: ^000000" + callfunc("Time2Str",.@Timer);
next;
switch(select("Buy VIP Service:Buy items:Get buffs:No, thanks.")) {
	case 1:
		if (vip_status(VIP_STATUS_ACTIVE)){
		mes "You already get a vip service, come back when your're service has expired";
		close;
		}
		goto Prem;
		
	case 2:
		item_list:
		menu "Universal Catalog Gold 20000 Zeny","Unlimited Flywing Box 20000",unli,Catalog,"HP Pil 10000 Zeny",HP_PILL,"SP Pil 10000 Zeny",SP_PILL,"Authoritative Badge 10000 Zeny",Authoritative;

		Catalog:
		set .@amount, countitem(12580);
		if (zeny < 20000) mes "Sorry,Your zeny not enough,";
		else if (.@amount >= 1) mes "You still have the item.";
		else{
		getitem 12581,10;
		set zeny,zeny-20000;
		}
		close;
		
		unli:
		set .@amount, countitem(17229);
		if (zeny < 20000) mes "Sorry,Your zeny not enough,";
		else if (.@amount >= 1) mes "You still have the item.";
		else{
		getitem 17229,1;
		set zeny,zeny-20000;
		}
		close;

		HP_PILL:
		set .@amount, countitem(12274);
		if (zeny < 10000) mes "Sorry,Your zeny not enough,";
		else if (.@amount >= 1) mes "You still have the item.";
		else{
		getitem 12274,10;
		set zeny,zeny-10000;
		}
		close;

		SP_PILL:
		set .@amount, countitem(12275);
		if (zeny < 10000) mes "Sorry,Your zeny not enough,";
		else if (.@amount >= 1) mes "You still have the item.";
		else{
		getitem 12275,10;
		set zeny,zeny-10000;
		}
		close;

		Authoritative:
		set .@amount, countitem(662);
		if (zeny < 10000) mes "Sorry,Your zeny not enough,";
		else if (.@amount >= 1) mes "You still have the item.";
		else{
		getitem 662,10;
		set zeny,zeny-10000;
		}
		close;

	case 3:
		mes "Choose which one do you wants.";
		mes "1) ^FF0000STR +8, AGI +6, DEX +4, ATK +32^000000";
		mes "2) ^FF0000INT +8, DEX +6, VIT +4, MATK +40^000000";
		next;
		mes "3) ^FF0000Dex +8, AGI +6, LUK +4, ATK +24, MATK +24^000000";
		mes "4) ^FF0000All Stat +6, ATK +24, MATK +24^000000";
		goto buff;

		buff:
		menu "^FF0000STR +8, AGI +6, DEX +4, ATK +32^000000",First,"^FF0000INT +8, DEX +6, VIT +4, MATK +40^000000",Second,"^FF0000Dex +8, AGI +6, LUK +4, ATK +24, MATK +24^000000",Third,"^FF0000All Stat +6, ATK +24, MATK +24^000000",Fourth;

First:
sc_start SC_STRFOOD,3600000,8;
sc_start SC_AGIFOOD,3600000,6;
sc_start SC_DEXFOOD,3600000,4;
sc_start SC_ATKPOTION,3600000,32;
percentheal 100,100;
close;

Second:
sc_start SC_INTFOOD,3600000,8;
sc_start SC_DEXFOOD,3600000,6;
sc_start SC_VITFOOD,3600000,4;
sc_start SC_MATKPOTION,3600000,40;
percentheal 100,100;
close;

Third:
sc_start SC_DEXFOOD,3600000,8;
sc_start SC_AGIFOOD,3600000,6;
sc_start SC_LUKFOOD,3600000,4;
sc_start SC_ATKPOTION,3600000,24;
sc_start SC_MATKPOTION,3600000,24;
percentheal 100,100;
close;

Fourth:
sc_start SC_STRFOOD,3600000,6;
sc_start SC_AGIFOOD,3600000,6;
sc_start SC_VITFOOD,3600000,6;
sc_start SC_INTFOOD,3600000,6;
sc_start SC_DEXFOOD,3600000,6;
sc_start SC_LUKFOOD,3600000,6;
sc_start SC_ATKPOTION,3600000,24;
sc_start SC_MATKPOTION,3600000,24;
percentheal 100,100;
close;

	case 4:
	mes "See you next time.";
	close;
	}

Prem:
set .@day,1000;
set .@week,5000;
set .@month,20000;
if (getgroupid()>60) {
mes "[ VIP NPC ]";
mes "Sorry,GM staff not allowed to use this service.";
close;
}

mes "[ VIP NPC ]";
mes "VIP Status.";
mes "^0000ff24 hours^000000 ^FF0000"+.@day+"^000000 cash point";
mes "^0000ff1 week^000000 ^FF0000"+.@week+"^000000 cash point";
mes "^0000ff1 month^000000 ^FF0000"+.@month+"^000000 cash point";
mes "your current Point  ^FF0000"+#CASHPOINTS+"^000000.";
next;
switch(select("Buy VIP 24 hour:Buy VIP 1 week:Buy VIP 1 month:No, Thanks.")) {
case 1:
if (#CASHPOINTS < .@day) {
mes "[ VIP NPC ]";
mes "Your cash points not enough,";
mes "^FF0000"+.@day+"^000000 cash point to use this service.";
close;
}
set #CASHPOINTS, #CASHPOINTS - [email protected];
atcommand "@vip +24h "+strcharinfo(0)+"";
mes "[ VIP NPC ]";
mes "Enjoy your service.";
atcommand "@cash -1000 "+strcharinfo(0)+"";
dispbottom "your current cashpoint "+#CASHPOINTS+".";
close;

case 2:
if (#CASHPOINTS < .@week) {
mes "[ VIP NPC ]";
mes "Your cash points not enough,";
mes "^FF0000"+.@week+"^000000 cash point to use this service.";
close;
}
set #CASHPOINTS, #CASHPOINTS - [email protected];
atcommand "@vip +7d "+strcharinfo(0)+"";
mes "[ VIP NPC ]";
mes "Enjoy your service.";
atcommand "@cash -5000 "+strcharinfo(0)+"";
dispbottom "your current cashpoint "+#CASHPOINTS+".";
close;

case 3:
if (#CASHPOINTS < .@month) {
mes "[ VIP NPC ]";
mes "Your cash points not enough,";
mes "^FF0000"+.@month+"^000000 cash point to use this service.";
close;
}
set #CASHPOINTS, #CASHPOINTS - [email protected];
atcommand "@vip +1m "+strcharinfo(0)+"";
mes "[ VIP NPC ]";
mes "Enjoy your service.";
atcommand "@cash -20000 "+strcharinfo(0)+"";
dispbottom "your current cashpoint "+#CASHPOINTS+".";
close;

case 4:
mes "[ VIP NPC ]";
mes "See You next time.";
close;
}

}

// --------------------------------------------------
//	Duplicates:
// --------------------------------------------------
alberta,33,240,4	duplicate(VIP System)	VIP System#alb	109
aldebaran,146,116,4	duplicate(VIP System)	VIP System#alde	109
amatsu,205,87,4	duplicate(VIP System)	VIP System#ama	109
ayothaya,212,172,6	duplicate(VIP System)	VIP System#ayo	109
comodo,191,161,4	duplicate(VIP System)	VIP System#com	109
einbech,55,36,6	duplicate(VIP System)	VIP System#einbe	109
einbroch,72,206,4	duplicate(VIP System)	VIP System#einbr	109
geffen,127,66,4	duplicate(VIP System)	VIP System#gef	109
gonryun,162,126,4	duplicate(VIP System)	VIP System#gon	109
hugel,102,148,4	duplicate(VIP System)	VIP System#hug	109
izlude,128,152,4	duplicate(VIP System)	VIP System#izl	109	//Pre-RE: (132,120)
jawaii,248,134,4	duplicate(VIP System)	VIP System#jaw	109
lighthalzen,154,104,4	duplicate(VIP System)	VIP System#lhz	109
louyang,205,105,6	duplicate(VIP System)	VIP System#lou	109
manuk,272,150,6	duplicate(VIP System)	VIP System#man	109
mid_camp,216,286,4	duplicate(VIP System)	VIP System#mid	109
morocc,146,89,4	duplicate(VIP System)	VIP System#mor	109
moscovia,226,195,4	duplicate(VIP System)	VIP System#mos	109
niflheim,199,180,4	duplicate(VIP System)	VIP System#nif	109
payon,178,109,4	duplicate(VIP System)	VIP System#pay	109
rachel,138,122,4	duplicate(VIP System)	VIP System#rac	109
splendide,198,153,4	duplicate(VIP System)	VIP System#spl	109
umbala,97,148,3	duplicate(VIP System)	VIP System#umb	109
veins,211,120,4	duplicate(VIP System)	VIP System#ve	109
xmas,142,139,6	duplicate(VIP System)	VIP System#xmas	109
yuno,164,50,4	duplicate(VIP System)	VIP System#yuno	109

// --------------------------------------------------
//	Duplicates (Renewal):
// --------------------------------------------------
brasilis,199,225,4	duplicate(VIP System)	VIP System#bra	109
dewata,202,190,6	duplicate(VIP System)	VIP System#dew	109
dicastes01,196,197,6	duplicate(VIP System)	VIP System#dic	109
malangdo,137,116,6	duplicate(VIP System)	VIP System#mal	109
malaya,228,195,4	duplicate(VIP System)	VIP System#ma	109

March 5, 2019

Hi, i make this script and i already test for normal player it can't buy service until remaining service is over.

after player buy vip service she/he will redirect to shop menu, not into buying premium service menu

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by hendra814

Important Information