Brian

rAthena needs the MySQL client files (you don't need to install MySQL Server). yum -y install mysql-client Then try compiling.

I was confused by the topic title. Do you want it to announce to GMs when another GM logs in/out? or announce to GMs when any player logs in/out? If you have trunk/conf/groups.conf, permissions: { receive_requests: true } then you can use @request to send the message to all online GMs: - script a_gm_is_online -1,{ OnPCLoginEvent: if (getgmlevel() > 0) atcommand "@request "+strcharinfo(0)+" is ONLINE."; end; OnPCLogoutEvent: if (getgmlevel() > 0) atcommand "@request "+strcharinfo(0)+" has logged out."; end; }

I had left this topic in my open tabs (todo)! I'll post the version I was working on soon. 1. make sure your settings in trunk/conf/battle/misc.conf are like this: night_at_start: no day_duration: 0 night_duration: 0 2. then add this script (see adding a Script) - script night_mobs -1,{ OnInit: // Spawn nightmare mobs on which maps? setarray .maps[0], "prontera","morocc","payon"; OnMinute00: if (gettime(3)%2 == 0) { // hours: 00, 02, 04, ... (even hours) if (isnight()) { day; announce "The sun is rising.", bc_all; for (set .@i,0; .@i<getarraysize(.maps); set .@i,.@i+1) killmonster .maps[.@i], strnpcinfo(3)+"::OnZombieDead"; } } else if (gettime(3)%2 == 1) { // hours: 01, 03, 05, ... (odd hours) if (isday()) { night; announce "Night has fallen... beware of the undead!", bc_all|bc_blue; for (set .@i,0; .@i<getarraysize(.maps); set .@i,.@i+1) monster .maps[.@i],0,0, "Nightmare",1427,30, strnpcinfo(3)+"::OnZombieDead"; } } end; OnZombieDead: // open 1 Old Purple Box getrandgroupitem IG_VioletBox,1; // 2% chance to get Ygg Berry if (rand(100) < 2) getitem 607,1; // Yggdrasil Berry // spawn a new mob each time one is killed? // Delete the next line to have mobs stay dead until the next night cycle. monster "this",0,0, "Nightmare",1427,1, strnpcinfo(3)+"::OnZombieDead"; end; }

also, if the map has mapflag#nosave then last_map in SQL will be set to their SaveMap or whatever map the 'nosave' mapflag is setup to.

"`delete_date`='%lu',`robe`='%d',`faction_id`='%d'," ^ change that line to: "`delete_date`='%lu',`robe`='%d',`faction_id`='%d'"

`faction_id`='0', There should not be a comma after the last column to update. If you're not sure what to edit, post the few lines before || SQL_ERROR == SqlStmt_BindColumn(stmt, 52, SQLDT_INT, &p->faction_id, 0, NULL, NULL) and I'll tell you what to change it to. because this is a runtime error in your SQL statement, not a compile error.

You can set an OnTouch area in the NPC header. 5,5, in this example (line 1): prontera,155,188,0 script walk_near_me 910,5,5,{ // do nothing when clicked end; OnTouch: cutin "kafra_7",2; sleep2 3000; cutin "",255; end; }

There is no existing script command to break an item, but you could use delitem2+getitem2. getitem2 <item id>,<amount>,<identify>,<refine>,<attribute>,<card1>,<card2>,<card3>,<card4>; Set <attribute> to 1 to make a broken item.

I forgot, can you also check if anything is in the import file? cat conf/import/char_conf.txt

In your SSH window (PuTTY), can you type: cat conf/char_athena.conf | grep start_point so we can see what the value of 'start_point' is in the file on your server.

It worked for me. start_point: dicastes01,198,179 1. If you are editing trunk/conf/char_athena.conf, make sure that start_point is NOT also in /conf/import/char_conf.txt or else the import one will overwrite what's in /conf/char_athena.conf 2. Did you test if you can @warp dicastes01 198 179 Also, try logging out there and log back in and see if your char is still there.

Come on I would want something between Gravity's minimum specs and "Processor: i7, Video Card: Sapphire HD".

You're welcome! It's a restriction (working as intended) I am guessing that function names can only contain alphanumeric characters (a-ZA-Z0-9) and underscore. The dash is causing errors because "evt-prize()" could be interpreted as "the value of the permanent char variable evt, MINUS the return value of the prize() function".

Did your functions work when the names did not have dash ? evt_prize() 04gate()

That's the weird part. I'm not sure how you are able to compile without doing ./configure first. The ./configure command is what creates the makefiles. If you don't do ./configure and try to compile, you should get this error: brian@bender:~/trunk# make clean make: *** No rule to make target `clean'. Stop. brian@bender:~/trunk# make sql make: *** No rule to make target `sql'. Stop. Oh! one more question: 32-bit or 64-bit? If you're using a 32-bit linux OS, then you need to do: ./configure --disable-64bit

Maybe they haven't figured out the diff for that one yet? The diff option [Data](7) GRF Adata/Bdata Support was there up until 2010-08-04bRagexeRE.

The changelog says JPG and PNG should work: http://rathena.org/board/files/file/2259-thor-patcher/ I'm guessing in config.ini it would be something like this? FrontImage='images/progress.jpg'

If you diff your client with "GRF Adata/Bdata Support" ... I think you can use a Hex Editor to find [adata.grf] and [bdata.grf] and rename them to words 9 characters or less (including the dot and extension). Then rename your GRF filenames too.

Several questions: 1. what SVN version of rAthena are you using? and did you checkout from the SVN or download a precompiled one (if so, link please) 2. Where did you do ./configure before? Was this folder on another computer that you compiled on before and then you moved the files to a new computer? 3. it sounds like there were errors when you did ./configure Can you post those errors?

Here you go: - script anti_KOS -1,{ OnPCKillEvent: if (strcharinfo(3) == "galaxy") { // if they kill themself, or if they kill the same player again if (killedrid == getcharid(3) || killedrid == last_kill) { set @kos_count, @kos_count +1; if (@kos_count >= 3) { atcommand "@die"; atcommand "@storeall"; announce strcharinfo(0)+" KOS'd the same player "+@kos_count+" times in a row!",bc_blue|bc_all; } else { announce strcharinfo(0)+" tried to Kill On Sight the same player!",bc_blue|bc_all; announce "Please do not kill the same player again after this. ALL your items will be in storage.",bc_blue|bc_self; dispbottom "Do not kill the same player after this one. ALL your items will be in storage."; dispbottom "Do not kill the same player after this one. ALL your items will be in storage."; dispbottom "Do not kill the same player after this one. ALL your items will be in storage."; dispbottom "Do not kill the same player after this one. ALL your items will be in storage."; } } else { // they killed a different player, so reset KOS count to 0 set @kos_count, 0; } set last_kill, killedrid; } end; }

Depends which program you are using. In SQLyog, this is how I add a new user: click the User Manager icon to open the User Manager window click Add New user on the next screen, enter the Username, Host, Password and click Create then select a database on the left, check the privileges you want to give the new user, then click Save Changes

What is the MySQL error message (or error number) ? If it's the "access denied" message, it means you're able to connect to the MySQL Server, but the user/password you are connecting with do not have privileges from the IP they are connecting from. A default MySQL install only sets up 'root'@'localhost' so that's why you are only able to connect from localhost. I forget if you use MySQL Query Browser or MySQL Workbench to add/edit MySQL users.. (I use different program, SQLyog and sometimes Navicat). Use one of those programs to add a new MySQL users like: 'pick_an_username'@'your_Mac's_LAN_IP' 'another_username'@'your_cp's_WAN_IP' and give the users permissions on your ragnarok database(s).

Glad you figured it out! Yes, SQL column, table, and database names go in `backticks` (which are optional; only required if the column/table/database name is a MySQL keyword). Strings and values go in 'single quotes'.

I counted about 87 in the /npc folder, but yea you're right not toooo many to edit. Users would have to be notified to edit their custom scripts that use Upper too.

Distracts ScriptingPhailure by telling him "hey look a distraction?!". As ScriptingPhailure looks, I push him down the hill. Hehe works every time. ... and now I have the hill.