Brian

The file is in the same directory you ran the command from. To specify a different directory, you can use the full file path like: mysqldump -u USERNAME --password=PASSWORD DATABASE_NAME > /home/rathena411/backups-sql/FILE_NAME.sql Here is one example: backup_ragnarok.sh

Changing the permanent character variable "Upper" would require editing a lot of scripts that use this =/

(If we decide to add this,) should the sit script command do unit_stop_walking first?

hmm, in the codebox you posted it's missing 1 right-curly (not sure if your script is missing it too, or maybe you didn't copy-paste the last line?) Here's another way, without needing to create a permanent char variable: // put this NPC on the same cell new chars spawn on // see /conf/char_athena.conf --> start_point new_1-1,53,111,0 script #JoinER 139,1,1,{ OnTouch: if (Class==Job_Novice && BaseExp==0 && BaseLevel==1) { announce "Unser neuester Spieler heißt "+ strcharinfo(0) +"! Willkommen bei Storm of Ragnarok!",bc_all; set BaseExp,1; // (no need to create a new variable) } end; }

How are you testing it? Did you open a 2nd client and put that player in the PVP room first? I tested and it works for me: prontera,155,188,0 script test 910,{ select "Warp me"; mapannounce "poring_w01", strcharinfo(0) + " ist in die PvP Arena eingetreten!",0; warp "poring_w01",0,0; end; } (click to enlarge) Since you added the mapannounce before warp, you will never see it on your own screen. Here are 2 options to fix this: 1) switch the 2 lines and add a sleep2 between warp and mapannounce (maybe 1 second is enough time for the loading screen) 2) OR trigger the mapannounce with OnPCLoadMapEvent, which always executes after a player enters a map. prontera,155,188,0 script test 910,{ select "Warp me"; warp "poring_w01",0,0; end; OnPCLoadMapEvent: if (strcharinfo(3) == "poring_w01") mapannounce "poring_w01", strcharinfo(0) + " ist in die PvP Arena eingetreten!",0; end; } poring_w01 mapflag loadevent

Actually no + and that 2nd line is just the wrong syntax for announce. XD

oops I forgot since your npc is not on the same map, bc_map won't work. Change the flag to 0 (bc_all): mapannounce "pvp_y_8-2", strcharinfo(0)+" ist in die PvP Arena eingetreten!", 0;

When you use programs on your computer, use 127.0.0.1 or localhost to connect. When you are on any other computer on your LAN, use your computer's LAN IP to connect. Only for computers on the "outside" internet (this includes your webhost where FluxCP is): then use your WAN IP to connect.

Which topic is causing the board error? After you get the error, use your browser's Back button, then right-click the link --> Copy link address. Then paste the link here.

Edit your script that warps them into the PVP room and add something like: mapannounce "your_pvp_map", strcharinfo(0)+" has entered the PVP room!", 0;

You can also add &userMode=title to a "Find Content" search url. http://rathena.org/board/index.php?app=core&module=search&do=user_activity&mid=5816&userMode=title

setup your router to forward port 3306 (the MySQL port) to your computer's LAN IP then open your FluxCP file /config/servers.php and in the 2 MySQL database config sections, change 'Hostname' to your WAN IP (click here to see what your WAN IP is)

Here are 2 ways you could write the NPC: 1. store the coupon codes & prizes in permanent global variables 2. store the coupon codes & prizes in a SQL table

This has to be altered in the client-side files. If your client reads data folder first, you can edit /data/viewpointtable.txt If your client reads GRFs only, you must edit viewpointtable.txt in the first GRF your client reads.

Also make sure to include a <registrationweb> url in your clientinfo.xml

Instead of editing the values, I just delete the lines to remove the view/angle restrictions for that map.

Please post the script in [/b][/font] tags so we can look at it. Then we can find the error.

/fluxcp/config/application.php // These are the main menu items that should be displayed by themes. // They route to modules and actions. Whether they are displayed or // not at any given time depends on the user's account level and/or // their login status. 'MenuItems' => array( 'Main Menu' => array( 'Home' => array('module' => 'main'), //'Forums' => array('exturl' => 'http://www.fluxro.com/community'), ), Add them like the 'Forums' example: 'Forums' => array('exturl' => 'http://www.fluxro.com/community'),

hmm I thought in the Athena Scripting Language, variable names are not case-sensitive (#test is the same as #TEST and #teST) So #cashpoints should be the same as #CASHPOINTS. In your script, can you try changing #cashpoints to #CASHPOINTS (all uppercase), then see if you still get those errors.

Looks like you have a custom script that inserted #cashpoints rows in your global_reg_value table? If you have any custom scripts that use query_sql to INSERT or UPDATE sql tables while the server is running and characters are logged in, they need to have proper checks for online/offline chars. It looks like what happened is: your script inserts a variable (#cashpoints) that did not exist yet for that player, then the player logs out and the map-server tried to save that variable too--thus the duplicate entry error. To fix these inconsistencies in your `global_reg_value` table, you could delete the #cashpoints rows your script inserted: DELETE FROM global_reg_value WHERE CAST(`str` AS BINARY) = '#cashpoints';

I think all that does is remove their cart (like clicking the Off button).

Is it KeyWorld's script you're looking for? [script] Bomberman

As 1 monster is killed, 1 monster is spawned? poring_w01,0,0,0 script unlimited_deadbranch -1,{ end; OnInit: monster strnpcinfo(4),0,0, "--ja--",-1, 5, strnpcinfo(3)+"::OnMyMobDead"; end; OnMyMobDead: monster strnpcinfo(4),0,0, "--ja--",-1, 1, strnpcinfo(3)+"::OnMyMobDead"; end; } Or they kill all 5 monsters, then 5 spawn all at once? poring_w01,0,0,0 script unlimited_deadbranch -1,{ end; OnInit: OnMyMobDead: if (mobcount(strnpcinfo(4), strnpcinfo(3)+"::OnMyMobDead") == 0) monster strnpcinfo(4),0,0, "--ja--",-1, 5, strnpcinfo(3)+"::OnMyMobDead"; end; }

Something like this: prontera,150,83,4 script Event Names 814,{ query_sql "SELECT `name` FROM `event` ORDER BY `name` ASC", .@name$; mes "[Event Names]"; for (set .@i,0; .@i<getarraysize(.@name$); set .@i,.@i+1) mes "Name : " + .@name$[.@i]; close; } I fixed the syntax of query_sql, added ORDER BY to sort the names, and added a missing semi-colon.

That sketch reminds me of these: http://www.google.com/search?q=Frank+Gehry+sketches