Brian

The favicon should still be there. http://rathena.org/board/favicon.ico

car --> cat http://xkcd.com/1288/

In forums where we enabled the "Best Answer" feature, if you are the topic starter, then you can click [Mark Solved] next to the reply that answered your question.

http://sensenbrenner.house.gov/uploadedfiles/usa_freedom_act_letter_10-31-13.pdf

Are you using GitHub on Windows, TortoiseGit, or another git client?

Try increasing the Git postBuffer size. git config --global http.postBuffer 524288000 http://stackoverflow.com/questions/6842687/the-remote-end-hung-up-unexpectedly-while-git-cloning

Yes, multiple servers can use the same port (6900), as long as they have different IP addresses. (Or they could use the same IP, but different ports.)

Wikipedia page: Mobile donating --> US Mobile Giving Providers

The default behavior is start point AND save point are set to this config: // Starting point for new characters // Format: <map_name>,<x>,<y> start_point: new_1-1,53,111 Just to clarify: you want new chars to start in one place (poring map), but save point to be prontera,151,179 ?Using savepoint like Emistry suggested, this is what you would do: 1. set the start_point config in conf/char_athena.conf#L99 to the Poring map start_point: prt_fild00,150,1502. create a script that triggers when they login for the first time(the script will set their save point to prontera,151,179 Here is an example: prt_fild00,150,150,0 script Change_Save 139,1,1,{ OnTouch: if (Class==Job_Novice && BaseExp==0 && BaseLevel==1) { savepoint "prontera",151,179; set BaseExp,1; // (no need to create a new variable) } end; }

You need a 2011-04-02 Harmony client so you can diff it? If you are the server owner who purchased Harmony, you should have received all necessary client-side files from Sirius White, including compatible Harmony client(s) that you can apply diff patches to. Or do you play on that server? (VanRO)

Did you connect to your server and check the map-server console for errors?

What format are your `start_date` and `end_date` columns? If they are YYYY-MM-DD HH:MM:SS then you should us FROM_UNIXTIME() to convert from UNIX timestamp to Date-Time format.

You could use query_sql and MySQL's functions: FROM_UNIXTIME() UNIX_TIMESTAMP()

Here's the guide by Euphy: Transitioning from SVN to GIT You can download a compressed zip from GitHub: https://github.com/rathena/rathena (on the right sidebar, click Download ZIP)

Maybe there's a more efficient way than 100s of SQL queries per second. XD Could you describe what you want the script to do?

Looking at src/map/mapreg_sql.c#L36, it automatically removes/deletes the variable if you are setting it to 0 or "".

For examples, look at script commands that set global arrays. getpartymember() - src/map/script.c#L7142 for(i=0;i<MAX_PARTY;i++){ if(p->party.member[i].account_id){ switch (type) { case 2: mapreg_setreg(reference_uid(add_str("$@partymemberaid"), j),p->party.member[i].account_id); break; case 1: mapreg_setreg(reference_uid(add_str("$@partymembercid"), j),p->party.member[i].char_id); break; default: mapreg_setregstr(reference_uid(add_str("$@partymembername$"), j),p->party.member[i].name); } j++; } }

1. make query_sql put the variable(s) you don't need in .@dummy2. if your script really does NOT need those variables, then rewrite the script to use query_sql() return values if (query_sql("SELECT 1, 1 FROM table WHERE `column1`='value1' AND `column2`='value2'", .@dummy, .@dummy)) { // do this }(you can make query_sql save more than 1 column in the same variable name; it will overwrite previous values)

We decided to change "Recent Revisions" to display the GitHub RSS feed instead of SVN because now GitHub is the primary repository (that all developers are committing to). SVN is a now a mirror. If you're looking for a timeline to follow that includes revision numbers, use the urls Euphy mentioned: Trac timeline (revision log, grouped by date) http://trac.rathena.org/timeline Trac log (revision log with full log messages) http://trac.rathena.org/log/rathena/?verbose=on SourceForge's SVN log http://sourceforge.net/p/rathena/svn/HEAD/log/ PS: you can also use a RSS feed reader, and import the RSS Feed links from the bottom of either Trac page.

Are you talking about the vending_tax that is automatically deducted when players buy from vendors ? --> sorry, that is not saved anywhere. The 2% zeny just "disappears" after the transaction. But you could modify the source code any maybe store it in a global permanent variable like $tax_collected Or are you talking about when someone buys something from a NPC or script, you want to deduct and store the 2% tax?

Also to add: if you're looking for an up-to-date ZIP download, GitHub has that. On the right sidebar, click Download ZIP.

getbattleflag("vending_tax") A value of 200 means 2% tax. Since scripts can only do integer math, you'd have to do something like: multiple price by 100 // this converts dollars to cents subtract (price * vending_tax) // subtract 2% tax divide price by 100 // converts cents back to dollars

Is your script based on the example in post #13? There is already a line that updates the SQL table when a code is redeemed. query_sql "UPDATE `reward_codes` SET `redeem_time`=NOW(), `char_id`="+getcharid(0)+" WHERE `code`='"+escape_sql(.@pc$)+"'";

Server saves it in RAM. (No need to save in SQL because when the server is stopped, all Guild Storages are closed.) The only way to check open/close status is with guildopenstorage - returns 0 if Guild Storage successfully opens - returns 1 on fail - returns 2 if player is not in a guild