Skorm

Right there are actually quite a few different tables to clear relating to characters. http://rathena.org/board/topic/84590-how-to-delete-account-using-sql-if-they-are-not-active/?hl=%2Bdelete+%2Baccount If you just delete the character from `char` you'd be leaving a whole mess of stuff behind.

If you want the sprite number this is a good site. You can search by name http://nn.nachtwolke.com/dev/npclist/

I think we broke it. More like they did at 21 hours ago. (raising themselves to 70%) We did it at 12 hours ago. (Raising ours to 40%) Then they counter attacks at 9 hours ago. (RO still increases to 49%) When RO reaches 49%, they triples the vote rates to 33 votes / minute. Then we went to 40%. Good thing MMOBOMB reset the votes, I see that they uses "Premium" polls now, There will no longer be any cheating whatsoever. Time to turn this around. That's good to hear although now I have to ask over 600 people to vote all over again. T_T

Wait... I think we broke it.

Yeah they're probably using macros...

We're closing in O_O If you have a server maybe you can ask your players to vote as well.

Vote link is here http://www.easypolls.net/poll.html?p=5329f056e4b07c9e253b0f08 Vote ragnarok and spread it around. Edit: I just contacted everyone on my Skype asking them to vote please if you have a little time to spare spread this link.

By creating this topic i feel I've done my bit.. atleast until the vote opens Yeah I plan on spreading this more the day of and before it opens.

This games got charm and she's going to give it her all. Also I would've sown tears had Ragnarok lost to Pirate101. Edit: I was reading through some of the comments and found this: Perhaps we should spread the word?

Cydh has a free mod on his site that I believe will help you do this. http://pservero.com/bonus2-bnoreflectskillnx-makes-skill-cannot-be-reflected/

Please try using code tags when posting scripts! It'll preserve tabs and add pretty colors both of which help us to complete your request. [code]Like this![/code]

NPC:fi all#<itemid>#<amount> NPC:fi map#<itemid>#<amount>#<map> Old school style wahahaha...

Looks good keep it up. Welcome back.

//Version : (2011/5/27-22:46) - script fi -1,{ OnWhisperGlobal: if(!getgmlevel()) end; if(@whispervar0$=="all") callfunc "itemforall",strcharinfo(0),atoi(@whispervar1$),atoi(@whispervar2$); if(@whispervar0$=="map") callfunc "itemforallmap",strcharinfo(0),atoi(@whispervar1$),atoi(@whispervar2$),@whispervar3$; end; } function script itemforallmap { getmapxy(.@N$,.@B,.@C,0); if( getitemname(getarg(1)) == "null" ){ announce "error id 1-1",bc_self,0x00FFFF; end; } if( getarg(1) <= 0 ){ announce "error id 2-1",bc_self,0x00FFFF; end; } while( .@V < $PlayerNumber ){ set .@V,.@V+1; getmapxy(.@N123$,.@B,.@C,0,rid2name(getd("$RecordAID"+.@V))); if( .@N$ == .@N123$ && getarg(3) == "" )||( getarg(3) != "" && getarg(3) == .@N123$ ){ message rid2name(getd("$RecordAID"+.@V)),getarg(0)+" give you "+getitemname(getarg(1))+"x"+getarg(2)+". Now hurry and pick it up!"; //getitem getarg(1),getarg(2),getd("$RecordAID"+.@V); //makeitem getarg(1),getarg(2),.@N123$,.@B,.@C; for(set .@a,0;.@a<getarg(2);set .@a,.@a+1) makeitem getarg(1),1,.@N123$,.@B,.@C; } } return; } function script itemforall { if( getitemname(getarg(1)) == "null" ){ announce "error id 1-2",bc_self,0x00FFFF; end; } if( getarg(1) <= 0 ){ announce "error id 2-2",bc_self,0x00FFFF; end; } while( .@V < $PlayerNumber ){ set .@V,.@V+1; if( isloggedin(getd("$RecordAID"+.@V)) ){ message rid2name(getd("$RecordAID"+.@V)),getarg(0)+" give you "+getitemname(getarg(1))+"x"+getarg(2)+". Now hurry and pick it up!"; getmapxy(.@N123$,.@B,.@C,0,rid2name(getd("$RecordAID"+.@V))); //makeitem getarg(1),getarg(2),.@N123$,.@B,.@C; for(set .@a,0;.@a<getarg(2);set .@a,.@a+1) makeitem getarg(1),1,.@N123$,.@B,.@C; //getitem getarg(1),getarg(2),getd("$RecordAID"+.@V); } } return; } - script BlackHoleEvent -1,{ OnPCLoginEvent: setd "$RecordAID"+set($PlayerNumber,$PlayerNumber+1),getcharid(3); end; OnInit: OnTimer5000: initnpctimer; for(set .@i,1;.@i<=$PlayerNumber;set .@i,.@i+1) { if(!isloggedin(getd("$RecordAID"+.@i))) { if(!getd("$RecordAID"+.@i)) { set $PlayerNumber,0; break; } setd "$RecordAID"+.@i,getd("$RecordAID"+(.@i+1)); setd "$RecordAID"+(.@i+1),0; set .@i,.@i-1; } } end; }

Thank you this was actually really helpful

O_O That exists? Damn! Well my GVG/PVP scripts just got a ton better. ty Annie. I was using loops to check the existence of the party... So unoptimized...

We don't have a French support section. That's why I asked him to contact Capuche. x_x

- script eq_remover -1,{ OnPCLogoutEvent: setarray .@item, 1201, 1202; set .@len, getarraysize(.@item); while( .@a<.@len ) { if(isequipped(.@item[.@a])) unequip(getiteminfo(.@item[.@a],10)); .@a++; } }

You're not alone on this one... I... I'm not even sure what's happening here... should I move this to DB requests???

You should use .@ vars instead of @ vars which persist through execution. I've re-uploaded and approved the script.

You're using cloak right? Check to see if you're const.txt has these values. If it doesn't add them. https://github.com/rathena/rathena/blob/master/db/const.txt#L311

What emulator are you running? I don't seem to have this problem.

Here is an example for the skill cloaking... Script_Event: autobonus3 "{ undisguise; while(checkoption(Option_Hide|Option_Cloak|Option_Invisible|Option_Chasewalk)) sleep2(1000); if(playerattached()) disguise(1147); }",10000,1,135; Equip_Event: disguise 1147; UnEquip_Event: undisguise;

Alright here's some notes I recorded for myself when installing a server... GL installing Ragnarok Server on Ubuntu: Installing Mysql: sudo apt-get install mysql-server sudo netstat -tap | grep mysql sudo /etc/init.d/mysql restart mysql -u root -p (mysql -u root if you didn't make a password) create database ragnarok; create database log; grant usage on *.* to root@localhost identified by ‘passwordhere’; grant all privileges on ragnarok.* to root@localhost ; grant all privileges on log.* to root@localhost ; use ragnarok; source path/to/sql-files/main.sql; use log; source path/to/sql-files/log.sql; Installing C Compiler: sudo apt-get update sudo apt-get -yqq install libc6-dev g++ gcc sudo apt-get install zlib1g-dev apt-get install libmysqlclient-dev chmod 775 for promissions chmod -R 755 *.sh if files aren't meant for Unix sudo apt-get dos2unix dose2unix filename ./filename 1. cd Path/RO/trunk 2. chmod +x configure 3. ./configure 4. make clean 5. make sql 6. ./athena-start restart install Webserver for flux: sudo apt-get update sudo apt-get aptitude sudo aptitude install apache2 sudo aptitiude install php5 libapache2-mod-php5 sudo apt-get php5-mysql sudo a2enmod php5 sudo apache2ctl restart You might also need to add the following to /etc/php5/apache2/php.ini extension=pdo.so extension=pdo_mysql.so if /usr/lib/php5/20060613+lfs/pdo.so or pdo_mysql.so are missing from the file directory add them. if you're still having problems try: sudo apt-get install libmysqlclient15-dev sudo apt-get install pdo_mysql sudo apache2ctl restart Installing and configuring SSH: sudo apt-get update sudo apt-get install openssh-server sudo groupadd groupnamehere cat /etc/group (group id is at the bottom) sudo useradd [user name] -d / -g [groupnamehere group id] -M -N -o -u [groupnamehere group id] sudo passwd [user name] (will display command to enterpassword) sudo apt-get update sudo apt-get nano sudo cp /etc/ssh/sshd_config /etc/ssh/sshd_config.bak sudo nano +76 /etc/ssh/sshd_config The line Subsystem sftp /usr/lib/openssh/sftp-server Needs to be replaced with Subsystem sftp internal-sftp CTRL+O to save CTRL+X to exit sudo mkdir /var/www cd /var/www sudo mkdir flux sudo chown root:sftponly flux ( Alternativly sudo chown -R owned directory ) sudo chmod -R 775 flux sudo /etc/init.d/ssh restart ip -o -f inet addr (if you need the IP address) Then download WinSCP or FileZilla and input your info.