Katazui
-
Posts
167 -
Joined
-
Days Won
6
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Posts posted by Katazui
-
-
Hello! Sorry for bringing up a old thread, but I've noticed that players are able to bypass the hourly idle check by attacking a Punching Bag 24/7, is there a way to prevent this?
-
40 minutes ago, glemor123 said:
Yes this is possible. You can just query back from your database table "cp_servicedesk".
Just make sure that the script will check the player account_id before it checks the database
or else you will retrieve all the tickets from the database
Hey! I'm not to familiar with SQL coding do you mind writing one up?
-
Hey guys! I need your guy's expertise on SQL coding.
//===== rAthena Script ======================================= //= @support //===== By: ================================================== //= Akkarin //===== Current Version: ===================================== //= 1.00.01 //===== Description: ========================================= //= Script control over @support //============================================================ - script atcmd_support -1,{ OnInit: bindatcmd("Support","atcmd_support::Onsupport"); end; Onsupport: query_sql "SELECT `cat_id`, `name` FROM `cp_servicedeskcat` WHERE `display` = 1 ORDER BY `name`", @cat_id, @cat_name$; mes "[Mrs. Support]"; mes "Please select one of the following categories"; set @j,0; for(set @i, 0; @i < getarraysize(@cat_id); set @i, @i + 1){ set @menulist$[@j],@cat_name$[@i]; set @menureference[@j],@i; set @j,@j+1; } menu @menulist$[0],-,@menulist$[1],-,@menulist$[2],-,@menulist$[3],-,@menulist$[4],-,@menulist$[5],-,@menulist$[6],-,@menulist$[7],-,@menulist$[8],-,@menulist$[9],-,@menulist$[10],-,@menulist$[11],-,@menulist$[12],-,@menulist$[13],-,@menulist$[14],-,@menulist$[15],-,@menulist$[16],-,@menulist$[17],-,@menulist$[18],-,@menulist$[19],-,@menulist$[20],-,@menulist$[21],-,@menulist$[22],-,@menulist$[23],-,@menulist$[24],-,@menulist$[25],-,@menulist$[26],-,@menulist$[27],-,@menulist$[28],-,@menulist$[29],-,@menulist$[30],-; next; mes "[Mrs. Support]"; mes "Next, please type in a subject line"; input @subject$; next; mes "[Mrs. Support]"; mes "Please tell us what the problem is. You must make sure that you keep this brief so all the text fits into the box!"; input @body$; next; mes "[Mrs. Support]"; mes "This is what we have so far.", "Click 'Next' to view each entry, then submit your ticket."; next; mes "^FF0000Category^000000", "You selected "+@cat_name$[@menureference[@menu-1]]; next; mes "^008000Subject^000000", @subject$; next; mes "^0000FFBody^000000", @body$; next; mes "If this is all correct, your ticket will be created.", "Continue?"; if(select("Yes:No")==1) { query_sql "SELECT `email`, `last_ip` FROM `login` WHERE `account_id` = '"+getcharid(3)+"'", @player_email$, @player_lastip$; query_sql("INSERT INTO `cp_servicedesk` (`account_id`, `category`, `char_id`, `timestamp`, `sslink`, `chatlink`, `videolink`, `subject`, `text`, `ip`, `curemail`) VALUES ('"+getcharid(3)+"', '"+@cat_id[@menureference[@menu-1]]+"', '"+getcharid(0)+"', NOW(), '0', '0', '0', '"+@subject$+"', '"+@body$+"', '"+@player_lastip$+"', '"+@player_email$+"')"); mes "Ticket created."; close; } else { mes "Submission terminated."; close; end; } end; }Using this script from FluxCP's support_cmd, I was wondering if the player can view their own resolved ticket, after a ticket has been completed/resolved. I'm aware that Admins are the only ones able to see all the support tickets. Is it possible for a player to view their own support ticket once completed?
I greatly appreciate this awesome community<3
-
On 4/30/2020 at 3:10 AM, Chaos92 said:
Try to check your log for errors then. when starting server/use skills. Maybe related to skilldb too.
Where could I find the error logs?
It seems that some classes have skills, but resets skill tree after being used. My server is 500/255. Skills also reset after logging out too?
I solved the problem. It turns out it was my job_exp.txt. It wasn't showing errors on the three servers, that's why I couldn't figure it out. It turns out that I didn't have enough tables for all the jobs.
-
3 minutes ago, Chaos92 said:
try to use back your older files that working for skillinfoz folder.
I never seem to have modified any skillinfoz folder, I also updated using zack's re folder. There was a point where I reloaded the server, all the vendors were gone because all the skills were taken away.
The skills from the hotkey are an effect from my weapon, skills work when that happens.
-
1 hour ago, Chaos92 said:
is it working before this ? if not.. maybe your lua fiiles for skill ?
It was working before. It's probably the lua files because I was learning my data folder and adding custom items. What do I have to check for to make sure it's correct? For some reason only the super baby class has access to level up their skill.
Thank you @Chaos92 for your reply! greatly appreciate your fast response.!
-
Hello guys!
I've encounter a weird problem where none of my players, including GMs, cannot level up their skill tree. I haven't messed with a skills or job, besides the job_exp.txt.
Any idea what's happening?
-
Hello! Is it possible to add an npc to view the current reward logs?
-
I finally solved my issue.
I had correctly follow the custom item guides, but the problem seems to lie either between the client or Iteminfo.lub that cause the problem.
First, I was looking around at other server's Iteminfo.lub to compare it to mine to see what I was doing wrong, turns out that all the custom items ViewID are supposed to be 0? On contrary to guides online, I changed my ViewID to 0. That was the first fix. However, the custom item still did not appear. After that, I concluded that I'm going to re-patch my client with NEMO, nothing really different from my original patching and now. Desperately working on the fix, I login and the custom item appears and is working.
I had no idea what was really wrong, but all I did was retrace my steps and tweak a couple things, while learning the process between the client -> gtf -> server more in-depth. I hope this reply will help someone in the future when they get stuck like me.
Thank you to @OwnedGGWP for helping me over discord.
UPDATE:
So, looking into it deeper, it wasn't the client, I totally had my accname.lub / accessoryid.lub in the right folder, but wrong directory. I had it to put my files in data/luafiles514/lua files/datainfo instead of data/luafiles514/datainfo.
-
1
-
-
19 hours ago, kodkodkub said:
are you sure that you edited the top .grf ( I mean no.1 grf in DATA.INI )
because if there's other .grf above your edited grf
and it has accname.lub and accid.lub
it wont read your edited grf but the above one20 hours ago, OwnedGGWP said:you have a error
[ACCESSORY_IDs.ACCESORY_Devil_Wings] = "(here)Devil_Wings"
i think if u add "_" before Devil that item work ok... so this is a corred code:
[ACCESSORY_IDs.ACCESORY_Devil_Wings] = "_Devil_Wings"
"hi by GriimStrike" ^^
So, I was reading the wiki on how to add custom items, and I think I missed a step where you're supposed decompile lub to lua, then back to lub, after adding your custom items. I am totally lost on this part. On some topics, I read that you can just change the extension of the file and that works? So far, doing that hasn't been beneficial.
My question is, how do you decompile lub to lua properly? This is a crucial step? Could this be the reason?
-
bump
EDIT:
If this helps, whenever I @changelook 32500, (item id) my client crashes. Whenever I @changelook 2000 my view id, nothing shows up, but my game still works. I'm not sure if something is missing. I also have my idnum... text files correctly filled out in my data/ folder. I'm also using renewal.
EDIT2:
I changed my viewID to 3000, I have already NEMO patched my client ViewID to 5000 already. I still get the same results.
I also try adding a different custom item to see if the item is faulty, seems like it's happening with every custom item I try to add, I get the same results as above.
-
@Krypt Hey! Could you explain your solution and what you did? I can't seem to have my non-gm characters drop items for some reason. For example, regular players can't drop regular items such as Red Potions or Knifes, or anything for that matter. How can I change this?
-
On 4/16/2020 at 5:22 PM, gidzdlcrz said:
Please check your item_db.txt
whats on accessoryid.lub and accname.lub
For instance
//5134,Pumpkin_Hat,Pumpkin-Head,4,20,,200,,2,,0,0xFFFFFFFF,63,2,256,,0,1,206,{ bonus2 bSubRace,RC_Demon,5; },{},{}the 206 is the view id.
I'm still having the same problem where the items aren't appearing not matter what ViewID I change it too.
Server Side:
db/import/item_db.txt
32500,Black_Elfs_Aura,Black_Elfs_Aura,4,20,,0,,1,,1,0xFFFFFFFF,63,2,512,,1,0,2000,{},{},{}Client Side:
System/itemInfo.lua
tbl = { [32500] = { unidentifiedDisplayName = "Black Aura", unidentifiedResourceName = "Black_Elfs_Aura", unidentifiedDescriptionName = { "" }, identifiedDisplayName = "Black Aura", identifiedResourceName = "Black_Elfs_Aura", identifiedDescriptionName = { "The dark consumes you." }, slotCount = 1, ClassNum = 2000 } }data/luafiles514/datainfo/accessoryid.lub
ACCESSORY_IDs = { ACCESSORY_GOGGLES = 1, ACCESSORY_CATTYHAIRBAND = 2, ... ACCESSORY_C_Luna_On_Shoulder = 1881, ACCESSORY_Black_Elfs_Aura = 2000 }data/luafiles514/datainfo/accname.lub
AccNameTable = { [ACCESSORY_IDs.ACCESSORY_GOGGLES] = "_고글", [ACCESSORY_IDs.ACCESSORY_CATTYHAIRBAND] = "_고양이머리띠", ... [ACCESSORY_IDs.ACCESSORY_C_Luna_On_Shoulder] = "_C_Luna_On_Shoulder", [ACCESSORY_IDs.ACCESSORY_Black_Elfs_Aura] = "_Black_Elfs_Aura" }Here's all my files. I'm not sure I'm missing anything. Could it be a simple syntax error? I would also put the same files into .grf format, still the same result.
-
1 hour ago, gidzdlcrz said:
You have to diff your client. I have mastered this method again after a long time. Anyways, you need to use nemo (thats a client differ) Increase the viewid from there. Then a your grf look for the file accessoryid.lub and accname.lub
From there you will need to add the custom headgear that you added.Hey, thank you for your reply. I was able to diff my client and increase my ViewID to 5000. However, I'm still encountering the same problem where the custom items are wearable, the drop spr/act, works, and so does the desc, but the actual item on my character does not appear? I tried adjusting the viewID to 2000 you, @gidzdlcrz. But, no luck. Any ideas what's happening?
-
Hey @gidzdlcrz, I actually am having a similar problem. Everything checks out to be working, however, whenever I put on the item, it seems to not appear. I was wondering the ViewID, I also happened to have my ViewID at 1882, and changed it to 2000. With the 2000, I had a error and the client crashes.
On a side note, how are you able to change the idview number to increase over 2000?
-
How to prevent account registration flooding from the same IP?
-
What are the required Specs to run a Ragnarok Server?
- CPU Speed: Mhz
- Memory: MB
- Disk Space: MB
- Bandwidth: GB
- Connection: Mb/s
- Dedicated IP's IP's
-
For some reason these castles ( Arunafeltz and Schwarzwald) aren't working, some emperiums aren't showing up. IS there any way to fix this?
-
On 8/9/2013 at 10:28 PM, uDe said:On 8/9/2013 at 1:36 PM, Katazui said:
On line 7. Remove the "//". Load the script. Click the Bunny. @unloadnpc. Then add those "//" again. Now load the NPC. Don't @reloadscript when the event is running, it messes with the variable.
How about adding
OnInit: set $EasterEggEvent, 0;
I mean the event will reset after @reloadscript or server restart right?
On 8/9/2013 at 7:54 PM, mrlongshen said:>why we start the event there are popup ? huhu
Because of this :
QuoteThe exact coordinates of the egg is given to all the GMs
atcommand "@request ["+$@mapee$+", "+$@eex+","+$@eey+"]";
@request command are used.
---------------------------------------------------------------------------------------------------------------
But, Instead of using @request to tell all GM where's the egg is. I would like to suggest using dispbottom function. Like this :
// atcommand "@request ["+$@mapee$+", "+$@eex+","+$@eey+"]"; dispbottom "Egg Coordinate : ["+$@mapee$+", "+$@eex+","+$@eey+"]";
Because maybe sometime you want to give some rare item and it will prevent your GM's to dual client by using their normal ID to easily get the egg.
By the way this is a nice and easy to understand script. Good job.
Nice! I'll add it to the next update.
-
On line 7. Remove the "//". Load the script. Click the Bunny. @unloadnpc. Then add those "//" again. Now load the NPC. Don't @reloadscript when the event is running, it messes with the variable.
Happened, after @reloadscript. I also have tried to @unloadnpcfile, @loadnpc and server restart, but seems like it's still detect that the 'Egg' has being laid.
No error on map-server.
-
1738,Constant@NPC_SELFDESTRUCTION,attack,173,1,10000,1000,0,no,self,always,0,,,,,,,
The red area is where you edit the cast time.
173 is Self Destruct
1 is Skill Level
10000 = 100%
1000 = 1 Second
Thanks!
-
like constants monsters?
db/.../mob_skill_db.txt
// MobID,Dummy value (info only),State,SkillID,SkillLv,Rate,CastTime,Delay,Cancelable,Target,Condition type,Condition value,val1,val2,val3,val4,val5,Emotion,Chat 1738,Constant@NPC_SELFDESTRUCTION,attack,173,1,10000,1000,0,no,self,always,0,,,,,,, 1738,Constant@NPC_SELFDESTRUCTION,chase,173,1,2000,1000,0,no,self,always,0,,,,,,,
Is there a way to lower the time for the bomb to explode? Like One second?
-
What do you guys think of this script? Is it helpful? Is it useful? Comments?
-
Oh, in that case. How do I summon about 100+ of the same npcs o.o. Do I have to duplicate all of them?
Mob One Tap
in Source Support
Posted
Hello guys!
I was wondering if there's a possible way to make a mob kill you instantly after one touch, one attack, or one tap? Sorta like the bombring, but, but with attacking one hit one kill.
Thanks in advance~