Assorted LOTRO notes

Horizontal Bar
A random conllection of stuff
First check to see if the lorebook tooltips are still working: Rune of Winged Dominance
(this should generate a pop-up of the Rune.)

Player Council

lotroster - no longer functional

LOTROster test scripts

LOTROster source

Luas

Use of Data.lotro.com

If you are registered with the Turbine Devs, you can get access to "data.lotro.com" which allows you to grab the actual info for characters... in more-or-less real-time... same update cycle as "my.lotro.com" data

Docs: (ignore the broken "Documentation" link on the page: data.lotro.com) Data.lotro.com Usage Guide.

"Recent" forum postings indicate Duwis is "the man in charge" now. http://forums.lotro.com/showthread.php?386946-data.lotro.com-updated-with-Update-2-data/page3

The basic call formats are:

Character Sheet
      Format: /{DEVELOPER_NAME}/{API_KEY}/charactersheet/w/{WORLDNAME}/c/{CHARACTERNAME}/
Guild Roster
      Format: /{DEVELOPER_NAME}/{API_KEY}/guildroster/w/{WORLDNAME}/g/{GUILDNAME}/
Item
      Format: /{DEVELOPER_NAME}/{API_KEY}/item/id/{ITEMID}/

Data.lotro.com is different from the Lorebook. "Data" is actually a directly provided Turbine resource. It is not a "top priority" for updates, but it is still an official source, so it tends to lag behind until major updates are done. It is also an official source for specific data such as character stats and configurations and the like. That information tends to get used by a couple of guild (kindships) who make roster pages on a periodic basis.

Lotroster is one tool which I use. http://www.lostrealm.ca/tower/node/24

A site which purports to "sweep" all of the available data from data.lotro.com and mash it onto a spreasheet. (Author Digital Utopia is a "well-known" LUA and Skin writer for LOTRO.)

http://www.lotrodata.com/

It has a massive, searchable list of Items and Quests. The Items data evidently comes from the data.lotro.com interface, but the source of the Quest information is not clear.

These pull from data.lotro.com - Individual toons:
These yield Xml pages which need to be parsed.

irmagill Gilrain Landroaval
  • Vallie
  • A pull from an infrequently used toon seems to yield a blank page -- no error returned, just no data.
Bullroarer Guilds

Assorted scripts to verify status of PHP/MySql5/Apache

sql stuff



Mysql Lotroster:
shianbrae>mysql5 -u root -p


mysql>show databases:
+--------------------+
| Database           |
+--------------------+
| information_schema |
| brat               |
| lotroster          |
| mysql              |
| otcroster          |
| test               |
+--------------------+

To display all users
mysql5>select * from mysql.user;

mysql5>exit;
Install new version of lotroster
1- unzip
Make file readable and directories executable 
Top level needs to be writeable.
2- chmod oug+rwx lotroster
3- chmod -R oug+r lotroster/*
4- cd lotroster
5- chmod oug+x auth css db dkpplugins docs images includes languages
6- cd images
7- chmod og+rx *
8- cd ../languages
7- chmod og+rx *
===

php stuff

(button)
php-info - I don't know why this works. (This syntax resolves to the next one)
(button)
php-info - script in LOTRO. this file is a one-liner to call phpinfo.php
(button)
php info - script in ~magill. this file does not exist.
(button)
phpMyAdmin.
(button)
MacPorts MAMP.

Horizontal Bar

Toons

whmagill - LOTRO - Gladden

Old Timers Guild (OTG)

Val - Man Minstrel (75)
Valalin - Dwarf Minstrel (62)
Valamar - Dwarf Hunter (75)
Valdicta - Dwarf Rune Keeper (75)
Valhad - Elf Lore Master (62)
Valhohun - Hobbit Hunter (44)
Valkeeper - Elf Rune Keeper (75)
Valwood - Dwarf Rune Keeper (75)


irmagill - LOTRO - Gladden

Ninth - Man Warden (64)
Valhunt - Dwarf Hunter (65)

magill - DDO - Ghallanda
Valamar Centuran - Human Cleric (9)
Catshmir Centurian - Human Rogue/Ranger (3/3)
Aerk Centurian - Dwarf Barbarian (5)
Silverfox Centurian - Human Rogue (6)
Azurelife Centurian - Drow Cleric (6)

Server: Gladden


Old Timers Guild

"Laid back, not so serious, no drama.
All about the fun!"

[Kinship page on My LOTRO]
Founded 03/30/2007 2:05 PM

LOTRO went live on 03/30/2007
Mines of Moria went live November 18 2008

Old Time Crafters (OTC) page on My LOTRO.

OTG Events Calendar


Name Account Forum Server Race Nationality Class Level Start Date
Val whmagill Valamar Gladden Race of Man Dale-lands Minstrel 75 [lvl 2 - 04/06/2007]
Valalin whmagill Valamar Gladden Dwarf Blue Mountains Minstrel 63 [lvl 2 - 04/07/2007]
Valamar whmagill Valamar Gladden Dwarf Blue Mountains Hunter 75 [lvl 2 - 03/30/2007]
Valdicta whmagill Valamar Gladden Dwarf White Mountains Rune-Keeper 75 [lvl 2 - 11/20/2008]
Valhad whmagill Valamar Gladden Elf Lindon Lore-master 62 [lvl 2 - 03/31/2007]
Valkeeper whmagill Valamar Gladden Elf Mirkwood Rune-Keeper 75 [lvl 2 - 05/21/2009]
Valhohun whmagill Valamar Gladden Hobbit Stoor Hunter 44 [lvl 2 - 09/02/2011]
Valwood whmagill Valamar Gladden Dwarf Stoor Rune Keeper 75 [lvl 2 - 05/21/2009]
Vallie whmagill Valamar Landroval Dwarf Blue Mountains Minstrel 12 [lvl 2 - 06/20/2008]
Valhunt irmagill Aerk Gladden Dwarf White Mountains Hunter 62 [lvl 2 - 09/02/2009]
Ninth irmagill Aerk Gladden Man Gondor Hunter 53 [lvl 2 - 08/26/2009]
Valtar whmagill Valamar Gilrain ELf Lindon Lore Master 24 [lvl 2 - 03/30/2012]

Val Valalin
Valamar Valdicta
Valhad Valkeeper
Valwood Valhohun
Ninth Valhunter
Vallie Valtar
Shianbrae: 98.140.106.68
Macports: update 20 January 2012

-sudo port upgrade installed

sqlite3
Attempting to fetch sqlite3-3.7.10_0.darwin_10.i386.tgz from http://packages.macports.org/sqlite3
Attempting to fetch openssl-1.0.0g_0.darwin_10.i386.tgz from http://packages.macports.org/openssl
Attempting to fetch gdbm-1.10_1.darwin_10.i386.tgz from http://packages.macports.org/gdbm
Attempting to fetch perl5.12-5.12.3_3.darwin_10.i386.tgz from http://packages.macports.org/perl5.12
Attempting to fetch automake-1.11.2_0.darwin_10.noarch.tgz from http://packages.macports.org/automake
Attempting to fetch curl-ca-bundle-7.23.1_1.darwin_10.noarch.tgz from http://packages.macports.org/curl-ca-bundle
Attempting to fetch mysql5-5.1.61_0.darwin_10.i386.tgz from http://packages.macports.org/mysql5
Attempting to fetch mysql5-server-5.1.61_0.darwin_10.noarch.tgz from http://packages.macports.org/mysql5-server
###########################################################
# A startup item has been generated that will aid in
# starting mysql5-server with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo port load mysql5-server
###########################################################

Attempting to fetch perl5.8-5.8.9_6.darwin_10.i386.tgz from http://packages.macports.org/perl5.8
Attempting to fetch php5-5.3.9_1+apache2.darwin_10.i386.tgz from http://packages.macports.org/php5

You may need to update your php.ini for any changes that have been made
in this version of php. Compare /opt/local/etc/php5/php.ini with
/opt/local/etc/php5/php.ini-development (if this is a development server) or
/opt/local/etc/php5/php.ini-production (if this is a production server).

If this is your first install, you need to activate PHP in your web server.

To enable PHP in Apache, run
  cd /opt/local/apache2/modules
  /opt/local/apache2/bin/apxs -a -e -n "php5" libphp5.so

Attempting to fetch php5-curl-5.3.9_0.darwin_10.i386.tgz from http://packages.macports.org/php5-curl
Attempting to fetch php5-gd-5.3.9_0.darwin_10.i386.tgz from http://packages.macports.org/php5-gd
Attempting to fetch php5-mbstring-5.3.9_0.darwin_10.i386.tgz from http://packages.macports.org/php5-mbstring
Attempting to fetch php5-mcrypt-5.3.9_0.darwin_10.i386.tgz from http://packages.macports.org/php5-mcrypt
Attempting to fetch php5-mysql-5.3.9_0+mysqlnd.darwin_10.i386.tgz from http://packages.macports.org/php5-mysql

To use mysqlnd with a local MySQL server, edit /opt/local/etc/php5/php.ini and set
mysql.default_socket, mysqli.default_socket and pdo_mysql.default_socket
to /opt/local/var/run/mysql5/mysqld.sock

Attempting to fetch php5-zip-5.3.9_0.darwin_10.i386.tgz from http://packages.macports.org/php5-zip
Attempting to fetch phpmyadmin-3.4.9_0.darwin_10.noarch.tgz from http://packages.macports.org/phpmyadmin


phpMyAdmin must be configured before it can be used. Consult the documentation at
file:///opt/local/www/phpmyadmin/Documentation.html#config

A sample configuration file is installed at /opt/local/www/phpmyadmin/config.sample.inc.php, but you
t edit this file. The file to edit is the real configuration file at
/opt/local/www/phpmyadmin/config.inc.php.

...[insert password]

Your existing config file has not been modified. You should manually compare the new sample config
file with your existing config file.

Attempting to fetch zsh-devel-4.3.15_0.darwin_10.i386.tgz from http://packages.macports.org/zsh-devel


=====
sudo port unload mysql5-server
sudo port load mysql5-server
mysql5 -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.61 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>  exit;

sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart
Shutting down MySQL
.... SUCCESS! 
Starting MySQL
. SUCCESS! 

shianbrae> sudo /opt/local/lib/mysql5/bin/mysql_upgrade -u root -p
Enter password: 
Looking for 'mysql' as: /opt/local/lib/mysql5/bin/mysql
Looking for 'mysqlcheck' as: /opt/local/lib/mysql5/bin/mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
brat.lotroster                                     OK
brat.lotroster_guild                               OK
brat.lotroster_log                                 OK
brat.lotroster_users                               OK
brat.test_lotroster                                OK
brat.test_lotroster_guild                          OK
brat.test_lotroster_log                            OK
brat.test_lotroster_users                          OK
lotroster.lotroster                                OK
lotroster.lotroster_guild                          OK
lotroster.lotroster_log                            OK
lotroster.lotroster_users                          OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
otcroster.lotroster                                OK
otcroster.lotroster_guild                          OK
otcroster.lotroster_log                            OK
otcroster.lotroster_users                          OK
Running 'mysql_fix_privilege_tables'...
OK

sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart
Shutting down MySQL
..... SUCCESS! 
Starting MySQL
. SUCCESS! 


=======
 * All directives are explained in Documentation.html and on phpMyAdmin
 * wiki .

 /opt/local/etc/php5/php.ini