-
Posts
356 -
Joined
-
Last visited
-
Days Won
4
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Posts posted by Jayz
-
-
21 hours ago, Collapse said:
sorry if this sounds stupid, but how to do that in windows server 2012 VPS?
bind your login / char / map / sql port = https://www.parallels.com/blogs/ras/configuring-windows-server-firewall-for-parallels-ras/
On 4/30/2022 at 9:56 AM, Collapse said:hello i just started to create my own server, but i got this error. is anyone know how to fix this? alr open all my port and turn off my firewall
here's screenshot of the error and my map_conf, char_conf
Since you use your wan ip,, your wanip add in your firewall
-
1
-
-
On 2/28/2020 at 2:50 PM, AHMADSHIDQI said:
I want to remove the animation of peco-peco of paladin / knight, as well as the gryphon and ferus of RK and RG
but i want the effect of riding and cavalry mastery still
is it possible?Just replace the job sprite without mount with the sprite with mount, example without mount the sprite is sprite_nomount.spr/act then the wiht mount is sprite_mount.spr/act. The sprite without mount will be replaced with withmount so that when use mount the client's readable sprite is the one you placed withoutmount but the effect of riding and cavalry mastery is still there
-
Is it possible for the mercenary to have his drop rate next to his master droprate, suppose the server is x5 drop rate then the master becomes VIP the master droprate will be x10 then the mercenary will also have the droprate x10, when the vip is expired the mercenary will also return to the normal droprate x5
-
12 hours ago, Redao said:
Does anyone know how to make a Script or a change so that I can block the drop of a certain card on a certain map?
For example:
The ghostring monster from pay_fild04, is there any way I can block the DROP of his card "only on this MAP?"
Other:
Is there a way to block the Drop of a certain card in the Endless Tower?
For example: Blocking the Boss Scene Card drop on the Endless Tower map.
Can anyone help me in this matter?
I thank!
Duplicate ghostring monster and remove the card drop and re-assign the monster id in npc\( pre-re or re )\mobs\fields\payon.txt
-
9 minutes ago, Emistry said:
query_sql("UPDATE `login` SET `deposit` = (`deposit` + "[email protected]+" - "+(([email protected] / 100) * 2)+"), `tax` = (`tax` + "+(([email protected] / 100) * 2)+") WHERE `account_id` = "+getcharid(3)+" LIMIT 1");thanks it work perfect now
-
3 hours ago, Emistry said:
prontera,155,181,5 script Simple Bank 757,{ query_sql("SELECT `deposit`, `tax` FROM `login` WHERE `account_id` = "+getcharid(3)+" LIMIT 1", [email protected]_zeny, [email protected]_tax); mes "You have "+F_InsertComma([email protected]_zeny)+" Zeny."; mes "You contributed "+F_InsertComma([email protected]_tax)+" Zeny of Tax."; mes " "; switch(select( "Deposit Zeny", "Withdraw Zeny" )) { case 1: input [email protected], 0, Zeny; if ([email protected] < 100) { mes "You cant deposit less than 100 Zeny."; } else if ((MAX_ZENY - [email protected]_zeny) < [email protected]) { mes "Your bank can't hold that much of Zeny."; } else { mes "You have deposited "+F_InsertComma([email protected])+" Zeny."; Zeny -= [email protected]; query_sql("UPDATE `login` SET `deposit` = (`deposit` + "[email protected]+"), `tax` = (`tax` + "+(([email protected] / 100) * 2)+") WHERE `account_id` = "+getcharid(3)+" LIMIT 1"); } break; case 2: input [email protected], 0, min([email protected]_zeny, 1000000000); if ([email protected] <= 0) { mes "You cant deposit 0 Zeny."; } else if ((MAX_ZENY - Zeny) < [email protected]) { mes "You can't hold that much of Zeny."; } else { mes "You have withdraw "+F_InsertComma([email protected])+" Zeny."; Zeny += [email protected]; query_sql("UPDATE `login` SET `deposit` = (`deposit` - "[email protected]+") WHERE `account_id` = "+getcharid(3)+" LIMIT 1"); } break; } close; }since tax value doesn't have limit, you probably should create the column with bigger datatype to support more than 2.1b value.
work perfect!
I'll just open it again, because I noticed that the tax percentage works but the tax didn't reduce the zeny deposit
-
9 minutes ago, Mihael said:
I think this npc can help you
Thank you i already check this before making post, but i want more simplier like on my description
-
can i request a simple bank sql base deposit and withdrawal only
Menu:
Deposit -> Can deposit any amount ( 2% tax ) if possible the 2% tax will go to the "tax" field under the "login table" just to find out how much the player's tax contribution is when using this bank
Withdraw -> Can withdraw upto 1b only
Balance -> Can check their balance
The database I will use is the login table, I created a new field whose name is deposit, thank you very much

-
10 hours ago, Froost said:
IT_CHARM.diff
New Update 2021
The source is no error but when i try to use it, Type: Armor / Usable / Etc / Charm its not working
edit.. its working
Earlier he Type: ETC and there i switched to Type: Charm but I didn't re @item again
-
1
-
-
On 1/6/2021 at 10:38 AM, Froost said:
Charm item (New Code Source)
I took a modified version of the original and fixed it for the current version of rathena 2020+, I saw that there were a lot of people asking for it, so I decided to post my diff, the project is not mine nor the code, I just fixed it for the new emulator.
-
Submitter
-
Submitted01/06/2021
-
Category
-
Video
-
Content Authorhamsterdigital
itemdb.cpp not match
-
-
-
17 hours ago, kalabasa said:
i Want to have my usable item to have progress bar when using it. can someone know how to do it on item script. ex. assumptio scroll
maybe?
12218,,,,,,,,,,,,,,,,,,,,,,,,,,,,{ progressbar "ffffff",1; sc_start SC_ASSUMPTIO,100000,5; skilleffect "HP_ASSUMPTIO",0; },{},{} -
10 hours ago, powkda said:
Good night, I'm having trouble logging in, when I select the server to go to the chars it doesn't connect, what can it be?
it was the folders that I had just removed the comment and had not changed the ip 127.0.0.1
show your login/char/map server when trying to connect,, or maybe check your system ports to allow it
-
1) if your question how to link your ip to your domain you need to edit your DNS in your domain manager and point your ip address,
2) if you are referring to the ip you will make domain with name, you need to register a domain first.. then do the #1
-
1 minute ago, budek said:
Hi @Zack-,
I checked my itemdb's i don't have column for name_japanese.
Yes because you are using old rathena,, thats why no name_japanese try reexecute the latest rathena sql here https://github.com/rathena/rathena/tree/master/sql-files
-
On 7/20/2021 at 7:22 AM, budek said:
i think you are not using latest rathena version ok lets open your mysql/phpmyadmin and go to item_db's table and click the structure and drop the name_japanese
-
execute your item_db_re.sql to your sql you may found your rathena sql at rathena/sql-files
-
4 hours ago, myimmortal said:
I try to login wrong password is have massage please check ID/Pass
but i try to use correct ID/PASS can login but can't pass to select character.
I want to know how to setting up ip on Windows VPS
I'm config ip on
conf/import/char_conf
userid: username
passwd: password
char_ip: 203.159.94.xxx
login_ip: 127.0.0.1conf/import/inter_conf
login_server_db: rathena
ipban_db_db: rathena
char_server_db: rathena
map_server_db: rathena
log_db_db: rathena_logsconf/import/map_conf
userid: username
passwd: password
char_ip: 127.0.0.1
map_ip: 203.159.94.xxxconf/char_athena
login_ip: 127.0.0.1
char_ip: 203.159.94.xxxconf/map_athena
char_ip: 127.0.0.1
map_ip: 203.159.94.xxxYour rAthena files is clean? or already have gepard patch in your rathena but your client.exe is not? check your conf /gepard_shield.conf disable your gepard gepard_shield_enabled: no
-
-
6 hours ago, Diana said:
Hi, I'm trying to add Thor web files in my Web hosting, it's not connecting, I tried to use http instead of https, tried using port 80 or 443, adding or removing www., and at the last I searched in the forum about this problem and I removed all .htaccess files and still not connecting, Any help?
Note: I checked the capital and small chars and was the same**
Note: I installed in VPS and it works perfect, but I wanna make it in webhosting**
What error failed to communicate? or failed to get etc..
-
good for gaming
-
-
I think your client cant read your GRF because the Ok button is korean,, double check your data.ini or your hardcoded data.ini if your main grf is priority
-
1 hour ago, Patskie said:
OnNPCKillEvent is for monster.
Yah thanks for correction, everything is working fine and im using it now, i try to edit your code
4 hours ago, Zack- said:OnNPCKillEvent: if( killedrid == 1002 ){ set #PoringKill,#PoringKill + 1; end;
i want to make similar this i tried to modified your code and change the Class to JobID 4010 and class_arr[[email protected]] = [email protected]; to class_arr[[email protected]] = [email protected], set #HWPoints,#HWPoints +1; but not working
- script test123 -1,{ OnPCKillEvent: [email protected] = getcharid(3); if (killedrid == [email protected]) end; attachrid killedrid; [email protected] = 4010; attachrid [email protected]; [email protected] = inarray(class_arr, [email protected]); if ([email protected] == -1) { [email protected] = getarraysize(class_arr); class_arr[[email protected]] = [email protected], set #HWPoints,#HWPoints + 1; count_arr[[email protected]] = 1; } else cleararray count_arr[[email protected]], count_arr[[email protected]] + 1, 1; end; }




Access Denied for user
in Installation Support
Posted
Since you remove // on 127.0.0.1 localhost,, you need to add your sqlport 3306 on your firewall,, or just remain // in your login_ip: char_ip: map_ip: etc..