Yanji

Made in Photoshop CS6 by Yanji.

I'll have to use it when I draw so my pics are cleaner xD

How did you make it look like that? Did you edit it manually or run it through some program?

Anyone wanna clean up the pic for me so there's no erase marks and the pic is nice and white? ;o

I refuse to color it. I like it black and white.

Lookie! /)^3^(\

So you want a script that has a 100% chance to refine, or a script that doesn't ask you to safe refine it when the chance is 100%?

Rikimaru = SQL pro. Me = Noob.

What Brian said, but be careful because if you do it in announcement messages, you would spam people's chatboxes xD

2791

I don't think you can use the second SQL query, but I'm not completely sure about it, but the first and third queries look good to me. (Not a SQL expert, so I might be wrong)

How I Met Your Mother. My Little Pony: Generation 3 or Generation 4? (4 for me ;3)

Yanji laik dis.

2766

Go watch it. It's beautifully written, well-animated, and exceedingly entertaining. You won't be dissappointed. Promise~ ♥

You can use the INSERT syntax to add an account to it. But I'm fairly sure what he wants to do is change an account to any GM level, which will use the UPDATE syntax. prontera,150,150,3<TAB>script<TAB>Sample<TAB>66,{ mes "Please input what GM level you desire."; input .@a; mes "Are you sure you wish to change your GM level to " + .@a + "?"; switch ( select ( "Yes:Nevermind" ) ) { case 1: mes "Your account's GM level has been changed to " + .@a + ". Please re-log."; close2; query_sql "UPDATE `login` SET `group_id` = '" + .@a + "' WHERE `account_id` = '" + getcharid(3) + "'"; end; case 2: mes "Come talk to me if you change your mind!"; close; } } That will let you input any number to change your GM level to. (Just don't put anything higher than 99) And it'll allow anyone to use it so you'll have to add in GM level checks, or a password into the NPC of some sort.

My bad I wrote it quick. That's it xD

Add this to the front of your Bloody Branch script: if ( getgmlevel() > 0 && < 80 ) { end; } I use rAthena and 'getgmlevel()' works fine for me.

By the way, if you make the NPC's coordinates 0, make the direction they face also 0 and the sprite ID 0, leaving only the map name as their location. Then, it will trigger the OnInit event command when you get into the map, sort of like OnPCLoadMapEvent.

You need to have ` marks around each table name. Try this: query_sql "SELECT `char`.`char_id`,`char`.`name`,`global_reg_value`.`value` FROM `global_reg_value` LEFT JOIN `char` ON `global_reg_value`.`char_id`=`char`.`char_id` WHERE `global_reg_value`.`str`='brokeemp' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 10", .@char_id, .@name$, .@count;

You put '.gat' at the end of the mapname. You don't add that, just the name of the map you'd use to @warp to it ingame. Like, 'prontera', 'izlude', etc. prontera,150,184,5<TAB>script<TAB>Healer#h1-1::Healer<TAB>834,{ PS: I'm pretty sure 'Assumptio' is disabled by default in WoE. You'll have to edit the SRC code to change it I believe.

You forgot a ) in this line: if ( getmapmobs("this") > 0 { It should be this: if ( getmapmobs("this") > 0 ) {

For the OnInit event command, you must have the NPC on your screen, otherwise it does nothing. Try this: caspen,0,0,0<TAB>script<TAB>Supporter1#supp1-1<TAB>-1,{ OnInit: ​setcell "caspen",0,0,300,300,cell_basilica,1; end; } PS: I'm not sure if 'cell_basilica' even works for monsters...

You don't need to set it to 0 when logging out. It's a temporary character variable so it resets to nothing once your char is logged out. No problem btw, & sorry about the 0 minute thing xD (I wrote it in a minute) Edit: Fixed my font/color/ & size.

If you want it to tell the logged in time, maybe to update in the player's client every 5 minutes, you could do this: http://upaste.me/raw/e75e52836dc5ba1