nanakiwurtz

prontera,155,184,5 script mmmm 100,{ mes "Atk1 = "+readparam(41); mes "Atk2 = "+readparam(42); close; }

What is BoE?

Looks somewhat useful, but I need more examples

May I suggest a text file on the sql-files/upgrades folder, that gives a hint of what that particular *.sql do. Or a sql table only for server information, that contains which .sql upgrades they have merged (imported) on their database, so the server owner knows there are some .sql files that must be imported.

Where's the content Akkarin

Sorry, but I don't understand...

Well she could use a secondary table, so it will be like: Player -> web registration -> Secondary table -> regex to strip any characters else than ^[a-zA-Z0-9]+$ -> save to primary table...

So this one is solved then?

SELECT * from aaa REGEXP '[[:alnum:]]+';

Yes, you only have to do it once, Fresh Prince.

Why do you want to limit the Chinese characters? Use nvarchar instead of varchar, and you'll be fine. Since nvarchar can store any Unicode data, not like varchar which can only store 7-bit ASCII. You can select whether to use UTF-8 or UTF-16. UTF-8 is Western preferred with some Asian languages support, while UTF-16 is Asian preferred with some Western languages support. Now you'd think about the storage space it would take if you switch to Unicode characters, and yes, the space it takes will be larger than the varchar. By using Unicode, you're preparing for the future because your SQL data has better compatibility. But I don't know if this can be used on rA or not Or why don't you check the strings for latin alphabet, number and some symbols you allow? Other than that, shows a message that the player has to use normal character to register.

Well, if I'm not mistaken his patcher is based on Yommy's xDiffPatcher, but it's more advanced, you should try it sometimes if you have time. Navigation System for 2012?

Wrong thread I think, this belongs to support section?

Well... On his question, there's no clue whether the player enter the castle during WOE or not

You can use this http://rathena.org/board/topic/87212-utility-promotional-code/

- script CastleBlocker -1,{ OnInit: // Add more castle maps here: setarray .map$,"prtg_cas01","prtg_cas02","prtg_cas03","prtg_cas04","prtg_cas05"; set .map_size,getarraysize(.map$); for (.@i = 0; .@i < .map_size; .@i++) setmapflag .map$[.@i],mf_loadevent; end; OnPCLoadMapEvent: for (.@i = 0; .@i < .map_size; .@i++) if (strcharinfo(3) == .map$[.@i]) { if(!getcharid(2)) { mes "Sorry, you are not in a guild!"; close2; warp "prontera",155,180; } break; } end; }

"Rebellion Props"... xD

I think it should be: bonus bMatkRate,5; bonus bMaxSPrate,-50; bonus2 bMagicAddRace,RC_DemiHuman,25; bonus2 bMagicAddRace,RC_Angel,25; if(getrefine()>=15){bonus bMatkRate,3; bonus2 bMagicAddRace,RC_DemiHuman,8; bonus2 bMagicAddRace,RC_Angel,8;} 리벨리온 소품 자핀가 Could be used as "Rebellion Accessories" and "Rebellion Weapons", there's no need to add "Vending Machine" after those words, because the NPC sprite is already a Vending Machine

I'll tell NeoMind, his patcher fully supports the latest ragexe client

Hmm until today, I haven't found that issue again, tested with 2013-08-07 Well if anyone hasn't found this issue again, this thread can be be closed to prevent confusion.

My suggestion is to put 'pushpc' command before enabling the warp points, to clear the spawn point from players. Sometimes I got this issue too, the warp point doesn't work after all monsters are killed, just like what wakoko321 has said

This is interesting

The name of the NPC on the right is "리벨리온 소품 자핀가" Don't know about the left one...

Looks promising, but there's no option to disable the the highlighting, I mean the <None> for simple text file, and also you can put a link to the pastebin on the IRC topic too. But please make the link short