Brian
-
Posts
2223 -
Joined
-
Last visited
-
Days Won
24
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Everything posted by Brian
-
29
-
27
-
Yesterday, we had some more email issues. Sorry about that, everything is fixed now! If you did not receive a Validation Email, click here: Resend Validation Email. If that doesn't work or you are having any other forum account issues, contact a staff member on IRC.
-
There is a "Collapse" link so if people want, they can hide that section (and your setting is saved in a cookie). Both Maki and I are Forum Managers, but Maki's group is changed right now to the unicorn logo
-
This has been added in r15039. Thanks @ToastOfDoom !
-
Questions can be posted in the correct support section. More info in this announcement.
-
This is complete.
-
yay! I made it on the Members Online Today list
-
In IPB 3, they moved this info into the popup when you mouse-over someone's name.
-
I left the "Hosted by" logo because we are still using SourceForge to host our SVN. Plus I wanted to show some support! (and link people to the RAthena SF project page)
-
We have moved some stuff around, and reCAPTCHA is now enabled !
-
We will leave nested quotes enabled because sometimes seeing the quoted quote helps clarify.
-
I'm fine with either block comment style. Doxygen can probably parse both =] @Z3R0: but not comments for every single line, right? Only for really complex lines that, at a glance, it's not immediately obvious what the code is doing.
-
If you move your log tables to a 2nd database (like "logs"), they will still be accessible, but the advantage is when you backup your "ragnarok" database, it won't take up extra space because you are not backing up the log tables.
-
If your SQL databases are very big, the backup could take a long time. During this time, the tables are locked, so the server can't run any queries and its MySQL connection times-out. Do you have log tables in your SQL database (atcommandlog, loginlog, picklog, etc.) ? If you move those to a separate database, that would make backups smaller and faster.
-
In case you don't have enough examples Here is another version: backup_ragnarok.sh - stores SQL backups in the same directory the script is located (or you can specify a directory) - creates sub-folders named YYYY-MM (ex: 2011-12/) - SQL backup filenames are DBNAME_DATE.sql (ex: ragnarok_2011-12-06_0809.sql) Example cron to create a backup every night at 1:07 am 7 1 * * * /home/rathena/backups-sql/backup_ragnarok.sh
-
We'll keep your suggestion in mind for if/when we switch to GIT.
-
Brian is my fake name =]
-
There are 2 steps to "reset look": (12345 = their char_id) UPDATE INVENTORY SET equip = 0 WHERE char_id = 12345; UPDATE `char` SET hair = 0, hair_color = 0, clothes_color = 0, weapon = 0, shield = 0, head_top = 0, head_mid = 0, head_bottom = 0 WHERE char_id = 12345;
-
It looks like your Sprite Detail and/or Texture Detail settings are turned all the way down. Run Setup.exe and move the sliders to the right.
-
That will delete ALL non-zero variables from your `global_reg_value` table! @Hatake: here's how to delete the "brokeemp" variables stop your server run this SQL query: DELETE FROM global_reg_value WHERE `str`='brokeemp'; start your server
-
I don't think that line will work because you passed the value of the variable to the function. Other than that, Emistry's script looks good! In case it doesn't work, here's another way:
-
I looked in the ACP and could not find the setting for this. Can anyone familiar with IP.Tracker point me in the right direction? Edit: sorry, it doesn't seem like there is a setting for this. I guess just use Reply if you have new info to add, and since you can't edit, use Preview before you post!
-
1. it's a phpMyAdmin bug, more info here 2. ohhh That's in this file /themes/default/main/balance.php <?php if (!defined('FLUX_ROOT')) exit; ?> <div class="credit-balance"> <span class="balance-text">Donation Credits</span> <span class="balance-amount"><?php echo number_format((int)$session->account->balance) ?></span> </div>
