[Guild Package Script]

this with guild level

prontera,154,95,4	script	test	50,{
query_sql "SELECT `guild_lv` FROM `guild` WHERE `guild_id`="+getcharid(2)+"",@glvl;
	if(@glvl == 50 ){
		if( !#GuildPackage3 ){
			set #GuildPackage3,1;
			getitem 512,10;
			}else{
			mes "You can't get it twice!";
			}
		close;
	}else{
	mes"your guild level too low";
	close;
	}
}

getitem item,amount;

getitem item,amount;

getitem item,amount;

getitem item,amount;

 

 

you can do this script with any and more then one from the guild sql

name
char_id
master
guild_lv
connect_member
max_member
average_lv
exp
next_exp
skill_point
mes1
mes2
emblem_len
emblem_id
emblem_data

just edit this like the Example on connect_member

 

query_sql "SELECT `guild_lv`,`connect_member` FROM `guild` WHERE `guild_id`="+getcharid(2)+"",@glvl,@cmember;

and edit the if 

if(@glvl == 50 || @cmember == 10 )

i hope i helped you 

[possible to encrpyt .INI files?]

i don't think so

but i think but (i never test it)

i think on diff you can check this

 

Enable Multiple GRF - Embedded

instead of

Enable Multiple GRF (Recommended)

 

i think it's make the exe read the GRFs you want without DATA.ini

 

########  Enable Multiple GRF v2  ########

//$inpMultGRF, XTYPE_FILE, /path/to/INI/file

[s aid=1 has an incorrect version of clientinfo]

conf/battle/client.conf

packet_ver_flag: 0x7FFFFFFF

packet_ver_flag2: 0x7FFFFFFF

conf/login_athena.conf

check_client_version: no

db/packet_db.txt

packet_db_ver: default
packet_keys_use: default

packet_ver: 38
packet_keys: 0x646E08D9,0x5F153AB5,0x61B509B5 // or your packet keys

on diff

do not load your packet keys !!

write them Manual !!

............................

first playable account the id must be 2000000 or more!

M or F not S

the account id 1 is S for 

conf/char_athena.conf

// Server Communication username and password.
userid: username
passwd: password

and

conf/map_athena.conf

// Interserver communication passwords, set in account.txt (or equiv.)
userid: username
passwd: password 

and it's not playable

........................

 

src/common/mmo.h

#define PACKETVER 20130605

use 2013-06-05Ragexe.exe for the 38!

[RessourceError can't find file À¯ÀúÀÎÅÍÆäÀ̽º\item\.bmp]

try the bmp in here

 

http://www.mediafire.com/download/ffcxs7r86iexyx5/data_v4.0.rar

 

or the item info from here

 

https://raw.githubusercontent.com/ROClientSide/Translation/master/System/itemInfo.lua

[How to edit script of item_db]

edit it in 

rathena\db\pre-re\item_db.txt

or

rathena\db\re\item_db.txt

 

or do what ^she said

[adoption]

up

["Rejected from server (3)" Error]

try this

9 Disable 1rag1 type parameters (Recommended)

10 Disable 4 Letter Character Name Limit

11 Disable 4 Letter User Name Limit

12 Disable 4 Letter Password Limit

13 Disable Ragexe Filename Check (Recommended)

15 Disable HShield (Recommended)

24 Fix Camera Angles (Recommended)

28 Increase Headgear ViewID

30 Increase Zoom Out 50%

34 Enable /showname (Recommended)

36 Read msgstringtable.txt (Recommended)

37 Read questid2display.txt (Recommended)

38 Remove Gravity Ads (Recommended)

39 Remove Gravity Logo (Recommended)

40 Restore Login Window (Recommended)

41 Disable Nagle Algorithm (Recommended)

44 Translate Client (Recommended)

47 Use Ragnarok Icon

48 Use Plain Text Descriptions (Recommended)

49 Enable Multiple GRFs (Recommended)

50 Skip License Screen

53 Use Ascii on All LangTypes (Recommended)

64 @ Bug Fix (Recommended)

71 Ignore Resource Errors

72 Ignore Missing Palette Error

73 Remove Hourly Announce (Recommended)

88 Allow space in guild name

90 Enable DNS Support (Recommended)

92 Packet First Key Encryption

93 Packet Second Key Encryption

94 Packet Third Key Encryption

96 Remove GM Sprites

 

 

try it like it's 

and if it work edit it

 

 

["Rejected from server (3)" Error]

do not Disable it !!!

diff to

 

first key 0x7E241DE0

Second key 0x5E805580

3rd key 0x3D807D80

 

 

[status]: Packet Obfuscation: Enabled. Keys: 0x7E241DE0, 0x5E805580, 0x3D807D80

 

 

 

+ no error ??

[info]: Attempt to connect to login-server...
[status]: Connecting to <WAN_IP>:6900
[status]: Connected to login-server (connection #5).
[status]: Awaiting maps from map-server.

 

 

must be like this after those^

 

[status]: Map-Server 0 connected: 1215 maps, from IP ***.***.***.*** port 5121.

[status]: Map-server 0 loading complete.

 

and

char_athena.conf

login_ip: localhost or 127.0.0.1
//bind_ip: <WAN_IP>XXX
char_ip: <WAN_IP> or your server ip etc your Internet ip

 

map_athena.conf

char_ip: localhost or 127.0.0.1
//bind_ip: <WAN_IP>XXX
map_ip: <WAN_IP> or your server ip etc your Internet ip

 

and check the port

and copy the console after your login try!!

[adoption]

adoption not work (there is no adopt option in the right click menu)

i use 2014-02-05bRagexe

is there and fixes? or something else i can do like npc etc .. ?

[vending script]

hello

cant i do this?

vend_zone mapflag novending

- script Vending_allow -1,{
end;
OnInit:
setcell "vend_zone",104,86,104,86,cell_novending,0;
end;
}

i do like that and it not work~

i want to chose the blocks that i want to allow the vending on it

not that i don't want to allow on it

cuz the map is big i cant type every block i don't want to allow on it~

Fixed

//vend_zone mapflag novending

- script Vending_allow -1,{
end;
OnInit:
setcell "vend_zone",54,54,145,145,cell_novending,1;
setcell "vend_zone",104,86,104,86,cell_novending,0;
end;
}

i set all the map useing (cell_novending 1) and remove (vend_zone mapflag novending)

Fixed

[sql script]

 

Hmm maybe

-	script	update points	-1,{
OnPCLoginEvent:
	query_sql "INSERT INTO `acc_reg_num` (`account_id`, `key`, `index`, `value`) select account_id, '#CASHPOINTS', 0, `value` from `global_reg_value` where `account_id` "+
		"= '"+ getcharid(3) +"' on duplicate key update `acc_reg_num`.`value` = `acc_reg_num`.`value` + `global_reg_value`.`value`";
	query_sql "delete from `global_reg_value` where account_id = "+ getcharid(3) +" and `str` = '#CASHPOINTS'";
	end;
}

 

Thank you

it's work Perfect

 

Solved

[Job Changer but only Expanded Classes?]

get the Official Job Master

and in the Menu delete the job IDs you don't want in it

 from here

case 0: Job_Menu(1,2,3,4,5,6,23,4046,24,25);
case 4001: Job_Menu(4002,4003,4004,4005,4006,4007);
case 4023: Job_Menu(4024,4025,4026,4027,4028,4029,4045);

[sql script]

like this

-	script	update points	-,{
OnPCLoginEvent:
query_sql( "SELECT `account_id`,`value` FROM `global_reg_value` ",.@iduser,.@valueuser );
.idus = .@iduser;
.valueus = .@valueuser;
query_sql("UPDATE `acc_reg_num` SET account_id = '"+.idus+"', key = #CASHPOINTS,  value = (value + '"+.valueus+"')");
query_sql("UPDATE `global_reg_value` SET account_id = 0, key = 0,  value = 0");
end;
}

but there is error~

anyone?

[sql script]

hello

i want to make script copy from table to table

 

OnTimer10000:

copy the account_id + str + value

from global_reg_value

and delete them

and make chg in  acc_reg_num

 

edit on the account_id

 

str = key

 

value = {value(global_reg_value)+value(acc_reg_num)}

 

 

or

 

 

set (global_reg_value)account_id = playeracc

 

set (global_reg_value)value = pointsupdate

 

atcommand"#CASHPOINTS "+playeracc" "+pointsupdate;

 

and delete the line in the table or set value(global_reg_value) = 0

 

 

 

 

Is this possible?

[need old files]

hello

 

i need old morroc NPCs and Warps and moc_castle

 

old izlude and payon NPCs

 

someone have it >.>?

[databases script]

try it too many 

 

is there other program?

[databases script]

for php-my-admin www.you-website/phpmyadmin/  

 

 

for npc scripts, confs etc. 

 

http://www.chip.de/downloads/WinSCP_13007380.html   <= Download and Login. and make duble klick of the script / Edit and Save , Close

 

 

http://www.chip.de/downloads/Notepad_12996935.html <= Noteped++ is a Editor

 

 

Thank you very much, I did not know that this program can work with phpmyadmin

 

i am try to connect

but i get this

 

 

the Password is not a mistake, and I've tried a lot

[databases script]

thank you Conflicts i have edit my post 

he wants me to upload/edit same script to the server database

and he know nothing in database

 

 

 

any one can help me?

[databases script]

I do not know a lot about databases

But I know how to make/edit/repair script

My friend has a server

and he wants me to upload/edit same script to the server database

and he know nothing in database

And is he no longer trust the experts because of an incident that occurred in the last period

And I really want to help him

Is it one tell me where can i find ,how upload ,how can i edit script in the database

I would be very thankful to that

my friend server in php my admin

Please. any one can guide me?