Rafael

No need to explain what the FB Hackercup is. You can read about it here: https://www.facebook.com/hackercup It's already started (2 days ago), and you have less than 22 hours left now (no worries, I haven't even read the problems yet too =P; and it seems like you only need to solve one problem correctly to advance to next round). To participate: https://www.facebook.com/hackercup/problems.php?round=598486203541358 If you are already participating, or intend to, let me know =D.

@removed I'm feeling different now, so this comment doesn't apply anymore =P.

@Will You mean blocking non-VIPs to access a map, or allowing only non-VIPs to access that map? - script block_nonvip -1,{ OnPCLoadMapEvent: if (!getgroupid() && strcharinfo(3) == "map_name") warp "prontera", 150, 150; end; } map_name mapflag loadevent Replace map_name with the name of the map.

@rotest I'm not sure if there is a way to do it. It would be necessary to have an event updating the stats, and there is no event that does it (I guess). So, I can't do it for you =(. What you could do is to create an item that gives different stats for different players, depending on their VIP group. About the categories, if you explain me better where you want me to put it I can do.

Well, just give me the scripts and I'll just insert the restrictions... Make a normal script become a VIP script is easy. Just put this in the beginning: if (!getgroupid()) { mes "You are not VIP."; close; }

Talking to VipAdmin in prontera.

Sample for 15 days: 30000,vip15,Ticket 15 Days VIP,2,1,,1,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc ("vip_add", 86400 * 15); },{},{} The only thing that matters here is the script: callfunc ("vip_add", 86400 * 15); Just replace the "15" with the number of days.

Yeah, it's really wrong, but not in line 8. Line 8 shouldn't cause any error, if you are using rAthena. Line 9 should cause an error, because it shouldn't be set .@i = 0;, but set .@i, 0; or .@i = 0;. The only error in line 8 is that it should be .@Input$, instead of .@input$. Are you sure you just COPIED the script, and didn't change ANYTHING? '-' Copy Annie's script, edit that .@input$ to .@Input$ and it should just work fine. @Annie Good solution, despite JOIN shouldn't be slow matching `account_id`, since it is indexed. @edit Generated a huge "fake" DB here, and executed the queries X times. Both took ~8.5s to run. So I'm still not sure about which is better, or if they are just the same... it should depend just on "lucky", since using a JOIN in a column that is indexed would result in a complexity O(N+M), the same for "select inside select", considering that only 1 result could match the WHERE clause (there are no identical names).

VipAdmin updated. Only change: now, you input username, not account id.

No, it doesn't. The command returns 0 for offline characters. So, better do an escape to the character name and search it first in `name` field. @edit Two possible solutions: Solution 1. Replace the query: SELECT `name`,`online` FROM `char` WHERE `account_id`='"+getcharid( 3,.@Input$ )+"' ORDER BY `char_num` ASC LIMIT 12 With: SELECT `char2`.`name`, `char2`.`online` FROM `char` LEFT JOIN `char` AS `char2` ON (`char`.`account_id`=`char2`.`account_id`) WHERE `char`.`name`='" + escape_sql (.@Input$) + "' ORDER BY `char2`.`char_num` ASC LIMIT 12 Solution 2. Replace the whole script with: prontera,157,178,5 script Sample 757,{ if( getgmlevel() >= 80 ){ mes "Input Player Name"; input .@Input$; query_sql "SELECT `account_id` FROM `char` WHERE `name`='" + escape_sql (.@Input$) + "'", .@aid; if (.@aid) { query_sql "SELECT `name`,`online` FROM `char` WHERE `account_id`='"+.@aid+"' ORDER BY `char_num` ASC LIMIT 12",.@Name$,.@Online; for( set .@i,0; .@i < getarraysize( .@Name$ ); set .@i,.@i + 1 ) mes " > "+.@Name$[.@i]+" "+( ( .@Online )?"Online":"Offline" ); }else{ mes "No Character found."; } } close; } I'm not sure about which is more efficient, so it's your decision....

I don't know how. Probably would need to disassemble the hexed.

No, I guess it isn't possible without editing the client.

@Valiente I understand what you are saying, but I don't agree. This script just let Game Masters move players to a special group for a specific time. How you use these groups, isn't exactly my problem/fault. For example, last week I saw a server (I guess it's top2 in top200, but not sure) that gives VIP to players in exchange for a coin. This coin can be obtained in special events, minigames etc. But how a system where only admins can activate the VIP could be used for something like this? First, you could reward players for bringing their guilds to your server, through this script. You could also organize events in your forums (or ingame events) and reward the winners. If someone contributes to your server (I'm not talking about money), you could also reward them with VIP. Second, VipLib allows anyone to make their own scripts. My topic in Cronus has some different scripts using VipLib (like "points for vip", "vip on first login", "itens that activate vip for a certain time" etc). I intended to translate all these scripts, but I started by VipAdmin (could have been any other of those scripts) and then just lost my will =/, because I really didn't intend to have to make all the scripts. I've developed this library so other people could make their own scripts (and share it). But it isn't what I'm seeing. I ended up having to develop all the scripts we have, nowadays, (shared) for the system. Just saw other people using it for commercial reasons. Like, "I have a client that asks me a VIP system with some features; there's a lib that will make my job easier, so let me use it". Yeah, I know it because, in the first releases, only those guys reported me the bugs of the lib (I released only VipLib first, only released the rest when I saw no one would share scripts based on this lib, so I needed to give it a reason rather then commercial usage). But, sure, people can also use it to thank for donations. That's why these groups are also called "donaters". I know it looks like "selling", but it isn't totally. If a player helps your server, giving you suggestions, good scripts, good source modifications, new items etc, and it's ok to reward them with VIP, why isn't it when they help your server with money? I know Game Masters use the money to other things, instead of the server. It's just one of the huge amount of possibilites you could do with this script. And, even in these cases, I think the GMs deserve the money. Follow me: you get $200 a month; you should use it for the server: maybe BUY some new scripts, or some new systems, buy some good ideas, or what else could make your server better. What if YOU develop the scripts, the systems, and YOU have the new ideas? Why can't you pay yourself with the money the server earned? Maybe this is totally wrong, but maybe it's not; if you are dedicating your time to the server, I think you deserve it. You know I don't know English very well, so sorry for any mistake. If you can also point me the mistakes, so next time I can write it right, thank you =D. @rafoka Thanks =D

@Will Made it now (just adapted v1.2b): http://rafaworks.zzl.org/root/scripts/accountmanager/viplib/v1.2b.eA.txt Use VipAdmin v1.1 instead of v1.2: http://rafaworks.zzl.org/root/scripts/accountmanager/npc/vipadmin/en.v1.1a.txt Didn't test, if you find any bug please report. @Valiente What? O.o

You're welcome I'm going to college right now, bye =P. @edit - Takumirai Released new version. Just update VipLib and download the npc that adds tags: http://codepad.org/3nUfxrbW If you can't access the link above, here is the code: function script VIP_setPlayerTag { set .prefix$, "[VIP] "; if (getcharid (3)) { if (@VIP_UsingTag && !getgroupid()) { atcommand "@fakename"; set @VIP_UsingTag, 0; } else if (!@VIP_UsingTag && getgroupid() && $@AM_Vip_IsValidGroup[getgroupid()]) { atcommand "@fakename " + .prefix$ + strcharinfo (0); set @VIP_UsingTag, 1; } } return; } - script VIP_setPlayerTag#init -1,{ OnInit: set $@AM_Vip_CallOnRefresh$[getarraysize ($@AM_Vip_CallOnRefresh$)], "VIP_setPlayerTag"; end; }