Quick Note (from Zhinjio, for Jabouty) : "I'm currently offline due to a variety of reasons. I will be back to working on this in early August or thereabouts. Thanks for your patience."
Web based display of your guild's SKG list information.
- This is not an addon for the World of Warcraft, rather it is a PHP/Mysql backend web extension / display of the SKG Addon.
- Your webserver needs to be running PHP5 for this installation to work properly.
- Requires the SKG addon.
- A working "live" version can be found here: http://skg.astralorder.com
In addition to showing your SKG lists on the web for your guild mates, it also backs up your data every time you upload a new SKG.lua file. This enables you to recover from a WoW crash where SKG was not saved if that should ever happen to you.
I will be updating this page with more information soon, however, you will find extensive documentation on how to get this running on your web server in the installation archive within the documentation folder.
I am providing this as a service to the users of the SKG looting system, and as such am looking for insight on how to improve it's design and implementation. Should you run into an issue please post a ticket here with as much detail as you can possibly give into the issue so that I can determine where the cause lies and fix it if possible.
From version 1.9.0-beta on, all upgrades are performed cleanly. Meaning the system will force you to upload your install.php and will force a clean installation to ensure the system is properly updated. Your SKG data will be restored when you upload your SKG.lua after installation.
"Nobody is perfect ... I'm missing a tooth."
-My wife.
Ps. I have enable comments on the curse page, however, any bug reports / enhancements listed in the comments section will be most likely ignored. Please post all bug reports or enhancement requests on the WoW Ace bug tracker.
------------------------------------------------------------------------
r35 | jabouty | 2009-05-17 02:46:17 +0000 (Sun, 17 May 2009) | 1 line
Changed paths:
M /trunk/documentation/adminLogs.html
M /trunk/documentation/adminUpload.html
M /trunk/documentation/adminUsers.html
M /trunk/documentation/configure.html
M /trunk/documentation/install.html
Documentation Update
------------------------------------------------------------------------
r34 | jabouty | 2009-05-16 21:18:50 +0000 (Sat, 16 May 2009) | 3 lines
Changed paths:
M /trunk/ToDo.txt
Test Commit for New computer build...
Nothing to see ... Move along.
------------------------------------------------------------------------
r33 | jabouty | 2009-05-16 21:08:31 +0000 (Sat, 16 May 2009) | 3 lines
Changed paths:
M /trunk/ToDo.txt
Test Commit for New computer build...
Nothing to see ... Move along.
------------------------------------------------------------------------
r32 | jabouty | 2009-05-15 03:54:05 +0000 (Fri, 15 May 2009) | 3 lines
Changed paths:
M /trunk/documentation/adminLogs.html
M /trunk/documentation/adminUpload.html
M /trunk/documentation/adminUsers.html
M /trunk/documentation/configure.html
M /trunk/documentation/index.html
M /trunk/documentation/install.html
M /trunk/documentation/scripts/index.html
A /trunk/download.php
M /trunk/files/index.html
M /trunk/images/backgrounds/index.html
M /trunk/images/buttons/index.html
M /trunk/images/gradients/index.html
M /trunk/images/index.html
M /trunk/images/misc/index.html
M /trunk/includes/index.html
M /trunk/index.php
M /trunk/install/index.html
M /trunk/scripts/index.html
M /trunk/templates/addList.html
M /trunk/templates/admin.html
M /trunk/templates/adminMessage.html
M /trunk/templates/admin_nav.html
M /trunk/templates/bottom_module.html
M /trunk/templates/default.html
A /trunk/templates/download.html
M /trunk/templates/embed.html
M /trunk/templates/footer.html
M /trunk/templates/header.html
M /trunk/templates/header_nav.html
M /trunk/templates/header_nav_admin.html
M /trunk/templates/header_nav_login.html
M /trunk/templates/header_nav_logout.html
M /trunk/templates/header_nav_update.html
M /trunk/templates/home.html
M /trunk/templates/index.html
M /trunk/templates/install.html
M /trunk/templates/left_module.html
M /trunk/templates/login.html
M /trunk/templates/logs.html
M /trunk/templates/loot.html
M /trunk/templates/right_module.html
M /trunk/templates/upgrade.html
M /trunk/templates/upload.html
M /trunk/upgrade/index.html
Added Enhancement 14: http://www.wowace.com/projects/skg_web/tickets/16-enhancement-dowloading-skg-lua-for-uploaders-admins/
Fixed html foul up with commented code for versioning.
------------------------------------------------------------------------
r31 | jabouty | 2009-05-14 21:33:33 +0000 (Thu, 14 May 2009) | 1 line
Changed paths:
M /trunk/index.php
fixed layout bug in index.php
------------------------------------------------------------------------
r30 | jabouty | 2009-05-14 21:30:02 +0000 (Thu, 14 May 2009) | 1 line
Changed paths:
M /trunk/includes/functions.php
M /trunk/index.php
M /trunk/loot.php
Fix for: http://www.wowace.com/projects/skg_web/tickets/15-timezone-issue-is-back/
------------------------------------------------------------------------
r29 | jabouty | 2009-05-14 05:12:40 +0000 (Thu, 14 May 2009) | 1 line
Changed paths:
M /trunk/config.php
M /trunk/embed.php
M /trunk/home.php
M /trunk/index.php
M /trunk/templates/style.css
Added Non-wrapping class display that is XHTML 1.0 compliant.
------------------------------------------------------------------------
r28 | jabouty | 2009-05-14 04:57:05 +0000 (Thu, 14 May 2009) | 1 line
Changed paths:
M /trunk/admin.php
M /trunk/config.php
M /trunk/documentation/adminLogs.html
M /trunk/documentation/adminUpload.html
M /trunk/documentation/adminUsers.html
M /trunk/documentation/configure.html
M /trunk/documentation/index.html
M /trunk/documentation/install.html
M /trunk/documentation/scripts/externalLink.js
M /trunk/documentation/scripts/iehover.js
M /trunk/documentation/scripts/index.html
M /trunk/documentation/scripts/links.js
M /trunk/documentation/style.css
M /trunk/embed.php
M /trunk/files/index.html
M /trunk/home.php
M /trunk/images/backgrounds/index.html
M /trunk/images/buttons/index.html
M /trunk/images/gradients/index.html
M /trunk/images/index.html
M /trunk/images/misc/index.html
M /trunk/includes/class_skgLuaParser.php
M /trunk/includes/functions.php
M /trunk/includes/index.html
M /trunk/index.php
M /trunk/install/index.html
M /trunk/install/install.php
M /trunk/login.php
M /trunk/logs.php
M /trunk/loot.php
M /trunk/scripts/externalLink.js
M /trunk/scripts/iehover.js
M /trunk/scripts/index.html
M /trunk/scripts/links.js
M /trunk/scripts/overlib.js
M /trunk/templates/addList.html
M /trunk/templates/admin.html
M /trunk/templates/adminMessage.html
M /trunk/templates/adminStyle.css
M /trunk/templates/admin_nav.html
M /trunk/templates/bottom_module.html
M /trunk/templates/default.html
M /trunk/templates/embed.html
M /trunk/templates/footer.html
M /trunk/templates/header.html
M /trunk/templates/header_nav.html
M /trunk/templates/header_nav_admin.html
M /trunk/templates/header_nav_login.html
M /trunk/templates/header_nav_logout.html
M /trunk/templates/header_nav_update.html
M /trunk/templates/home.html
M /trunk/templates/index.html
M /trunk/templates/install.html
M /trunk/templates/left_module.html
M /trunk/templates/login.html
M /trunk/templates/logs.html
M /trunk/templates/loot.html
M /trunk/templates/right_module.html
M /trunk/templates/style.css
M /trunk/templates/upgrade.html
M /trunk/templates/upload.html
M /trunk/upgrade/index.html
M /trunk/upgrade/upgrade.php
M /trunk/uploader.php
Fixed Versioning in all files.
------------------------------------------------------------------------
r27 | jabouty | 2009-05-14 04:42:22 +0000 (Thu, 14 May 2009) | 1 line
Changed paths:
M /trunk/SKG_Web.sql
M /trunk/admin.php
M /trunk/config.php
M /trunk/documentation/adminLogs.html
M /trunk/documentation/adminUpload.html
M /trunk/documentation/adminUsers.html
M /trunk/documentation/configure.html
M /trunk/documentation/index.html
M /trunk/documentation/install.html
M /trunk/documentation/scripts/externalLink.js
M /trunk/documentation/scripts/iehover.js
M /trunk/documentation/scripts/index.html
M /trunk/documentation/scripts/links.js
M /trunk/documentation/style.css
M /trunk/embed.php
M /trunk/files/index.html
M /trunk/home.php
M /trunk/images/backgrounds/index.html
M /trunk/images/buttons/index.html
M /trunk/images/gradients/index.html
M /trunk/images/index.html
M /trunk/images/misc/index.html
M /trunk/includes/class_skgLuaParser.php
M /trunk/includes/functions.php
M /trunk/includes/index.html
M /trunk/index.php
A /trunk/install/index.html
M /trunk/install/install.php
M /trunk/login.php
M /trunk/logs.php
M /trunk/loot.php
M /trunk/scripts/externalLink.js
M /trunk/scripts/iehover.js
M /trunk/scripts/index.html
M /trunk/scripts/links.js
M /trunk/scripts/overlib.js
M /trunk/templates/addList.html
M /trunk/templates/admin.html
M /trunk/templates/adminMessage.html
M /trunk/templates/adminStyle.css
M /trunk/templates/admin_nav.html
M /trunk/templates/bottom_module.html
M /trunk/templates/default.html
M /trunk/templates/embed.html
M /trunk/templates/footer.html
M /trunk/templates/header.html
M /trunk/templates/header_nav.html
M /trunk/templates/header_nav_admin.html
M /trunk/templates/header_nav_login.html
M /trunk/templates/header_nav_logout.html
M /trunk/templates/header_nav_update.html
M /trunk/templates/home.html
M /trunk/templates/index.html
M /trunk/templates/install.html
M /trunk/templates/left_module.html
M /trunk/templates/login.html
M /trunk/templates/logs.html
M /trunk/templates/loot.html
M /trunk/templates/right_module.html
M /trunk/templates/style.css
M /trunk/templates/upgrade.html
M /trunk/templates/upload.html
M /trunk/upgrade/index.html
M /trunk/upgrade/upgrade.php
M /trunk/uploader.php
Added SVN revision tracking to all text files.
------------------------------------------------------------------------
r26 | jabouty | 2009-05-13 22:09:07 +0000 (Wed, 13 May 2009) | 1 line
Changed paths:
M /trunk/admin.php
M /trunk/documentation/adminLogs.html
M /trunk/documentation/adminUpload.html
M /trunk/documentation/adminUsers.html
M /trunk/documentation/configure.html
M /trunk/documentation/install.html
A /trunk/documentation/scripts/externalLink.js
M /trunk/embed.php
M /trunk/home.php
M /trunk/loot.php
A /trunk/scripts/externalLink.js
M /trunk/templates/admin_nav.html
M /trunk/templates/bottom_module.html
M /trunk/templates/footer.html
M /trunk/templates/header.html
M /trunk/templates/home.html
M /trunk/templates/left_module.html
M /trunk/templates/right_module.html
Ensured all displayed pages are XHTML 1.0 TRANSITIONAL compliant with the W3C. We can now display the W3C Compliant XHTML 1.0 image in the footer.
------------------------------------------------------------------------
r24 | jabouty | 2009-05-13 16:13:18 +0000 (Wed, 13 May 2009) | 3 lines
Changed paths:
A /trunk/SKG_Web.sql
M /trunk/admin.php
M /trunk/config.php
M /trunk/home.php
M /trunk/includes/class_skgLuaParser.php
M /trunk/includes/functions.php
M /trunk/index.php
M /trunk/install/install.php
M /trunk/login.php
M /trunk/templates/addList.html
M /trunk/templates/embed.html
M /trunk/upgrade/upgrade.php
Fighting back against the Silithids!!!
I think I got all the encoding bugs squished ... we'll see.
------------------------------------------------------------------------
r22 | jabouty | 2009-05-11 18:47:05 +0000 (Mon, 11 May 2009) | 1 line
Changed paths:
M /trunk/index.php
M /trunk/upgrade/upgrade.php
Version Update: 1.8.4-beta
------------------------------------------------------------------------
r21 | jabouty | 2009-05-11 18:42:13 +0000 (Mon, 11 May 2009) | 3 lines
Changed paths:
M /trunk/config.php
M /trunk/embed.php
M /trunk/includes/functions.php
M /trunk/index.php
M /trunk/loot.php
TimeZone Fix: http://www.wowace.com/projects/skg_web/tickets/9-question-about-timezones-and-loot-timestamp/
config.php *HAS* changed. You *MUST* use the current config.php provided and import your settings into it. Be sure to pay attention to the timezone settings for this one. This *should* be the last time I change config.php
------------------------------------------------------------------------
r19 | jabouty | 2009-05-06 17:26:54 +0000 (Wed, 06 May 2009) | 3 lines
Changed paths:
M /trunk/includes/functions.php
M /trunk/index.php
M /trunk/install/install.php
M /trunk/upgrade/upgrade.php
My continued quest to handle cross OS logins ... Now forcing MySQL to default the database table to UTF-8 as well.
Added "Forced Install" option to allow a full re-installation of the system.
------------------------------------------------------------------------
r17 | jabouty | 2009-05-05 22:08:45 +0000 (Tue, 05 May 2009) | 1 line
Changed paths:
M /trunk/includes/functions.php
M /trunk/index.php
M /trunk/install/install.php
M /trunk/upgrade/upgrade.php
Added better versioning / upgrading control.
------------------------------------------------------------------------
r16 | jabouty | 2009-05-05 21:41:48 +0000 (Tue, 05 May 2009) | 3 lines
Changed paths:
M /trunk/admin.php
M /trunk/embed.php
M /trunk/home.php
M /trunk/includes/functions.php
M /trunk/install/install.php
M /trunk/login.php
M /trunk/loot.php
M /trunk/templates/addList.html
M /trunk/templates/admin.html
M /trunk/templates/adminStyle.css
M /trunk/templates/default.html
M /trunk/templates/footer.html
M /trunk/templates/header.html
M /trunk/templates/index.html
M /trunk/templates/install.html
M /trunk/templates/login.html
M /trunk/templates/logs.html
M /trunk/templates/loot.html
M /trunk/templates/style.css
M /trunk/templates/upgrade.html
M /trunk/templates/upload.html
M /trunk/upgrade/upgrade.php
Another attempt to squish the "Cross OS Login Failure" bug: http://www.wowace.com/projects/skg_web/tickets/4-cross-os-login-failure/
* Everything is either defaulted, forced or converted to UTF-8 character encoding.
Minor cosmetic work on the site display.
------------------------------------------------------------------------
r15 | jabouty | 2009-05-04 19:28:50 +0000 (Mon, 04 May 2009) | 1 line
Changed paths:
A /trunk/loot.php
A /trunk/templates/loot.html
Forgot the actual loot pages ... dur
------------------------------------------------------------------------
r14 | jabouty | 2009-05-04 19:11:07 +0000 (Mon, 04 May 2009) | 4 lines
Changed paths:
M /trunk/ToDo.txt
M /trunk/config.php
M /trunk/index.php
M /trunk/templates/header.html
M /trunk/templates/header_nav.html
Added Latest Loot Browser (will paginate later)
Users have a new option in the config.php file for the latest loot browser.
Please make sure to overwrite your config.php file and edit with your settings.
------------------------------------------------------------------------
r12 | jabouty | 2009-05-04 17:39:36 +0000 (Mon, 04 May 2009) | 6 lines
Changed paths:
M /trunk/admin.php
M /trunk/embed.php
M /trunk/includes/functions.php
M /trunk/index.php
M /trunk/install/install.php
M /trunk/login.php
M /trunk/upgrade/upgrade.php
* Removed upgrade system prior to 1.7.0-beta. All users running a version that is less than 1.7.0-beta should delete all SKG files and completely remove all database entries for SKG before reinstalling the system (keeping the backup files in the /files/ directory).
* Added redirect to SKG.lua upload form for those users that are not admin, but are allowed to upload their SKG.lua file per wowace ticket: http://www.wowace.com/projects/skg_web/tickets/3-redirect-non-admin/
* Added Last update time for lists to embed.php per request: http://www.wowace.com/projects/skg_web/tickets/2-date-stamp-on-embed-list/
* The following *should* fix the problems noted in wowace ticket: http://www.wowace.com/projects/skg_web/tickets/4-cross-os-login-failure/
** Converted all character encoding to "UTF-8" encoding for better handling of user input and to better control the password salting process.
** Converted passwords to Sha1 hashing for better control of the salting process. All users will need to be edited and their passwords reset before they will be able to login. The upgrade process will convert the all passwords to 'welcome' and will utilize Sha1 during the process so that the admin of the site can edit all current users. After the upgrade completes you will need to login to your admin account using the password "welcome" (lowercase, without quotes) and redo all user's password to utilize the sha1 hashing.
------------------------------------------------------------------------
r9 | jabouty | 2009-05-04 00:20:27 +0000 (Mon, 04 May 2009) | 2 lines
Changed paths:
M /trunk/embed.php
M /trunk/home.php
M /trunk/install/install.php
M /trunk/logs.php
Fixed improper class display, reported via: http://www.wowace.com/projects/skg_web/tickets/1-classes-improperly-displayed-on-site/
1.7.0-beta Push
------------------------------------------------------------------------
r8 | jabouty | 2009-05-03 23:08:14 +0000 (Sun, 03 May 2009) | 3 lines
Changed paths:
A /trunk/ToDo.txt
D /trunk/changeLog.txt
M /trunk/install/install.php
M /trunk/upgrade/upgrade.php
Added ToDo.txt
Removed changeLog.txt due to SVN doing it for me.
Made minor code adjustment to install/install.php and upgrade/upgrade.php
------------------------------------------------------------------------
r7 | jabouty | 2009-05-03 22:43:55 +0000 (Sun, 03 May 2009) | 1 line
Changed paths:
A /trunk/files/index.html
Added files/index.html to force directory creation.
------------------------------------------------------------------------
r6 | jabouty | 2009-05-03 22:26:17 +0000 (Sun, 03 May 2009) | 3 lines
Changed paths:
A /trunk/changeLog.txt
M /trunk/includes/functions.php
M /trunk/index.php
M /trunk/install/install.php
M /trunk/upgrade/upgrade.php
M /trunk/uploader.php
Added PHP Version Compare lockout. If webserver is not running PHP 5.0.0 or greater (PHP4 is end of life and no longer supported) the system will simply not function.
Optimized Upload system to better utilize SKG's logging.
Changed naming standard.
------------------------------------------------------------------------
Installation Guide
- Exit "World of Warcraft" completely
- Download the mod you want to install
- Make a folder on your desktop called "My Mods"
- Save the .zip/.rar files to this folder.
- If, when you try to download the file, it automatically "opens" it... you need to RIGHT click on the link and "save as..." or "Save Target As".
- Extract the file - commonly known as 'unzipping'
Do this ONE FILE AT A TIME!
- Windows
- Windows XP has a built in ZIP extractor. Double click on the file to open it, inside should be the file or folders needed. Copy these outside to the "My Mods" folder.
- WinRAR: Right click the file, select "Extract Here"
- WinZip: You MUST make sure the option to "Use Folder Names" is CHECKED or it will just extract the files and not make the proper folders how the Authors designed
- Mac Users
- StuffitExpander: Double click the archive to extract it to a folder in the current directory.
- Verify your WoW Installation Path
That is where you are running WoW from and THAT is where you need to install your mods.
- Move to the Addon folder
- Open your World of Warcraft folder. (default is C:\Program Files\World of Warcraft\)
- Go into the "Interface" folder.
- Go into the "AddOns" folder.
- In a new window, open the "My Mods" folder.
- The "My Mods" folder should have the "Addonname" folder in it.
- Move the "Addonname" folder into the "AddOns" folder
- Start World of Warcraft
- Make sure AddOns are installed
- Log in
- At the Character Select screen, look in lower left corner for the "addons" button.
- If button is there: make sure all the mods you installed are listed and make sure "load out of date addons" is checked.
- If the button is NOT there: means you did not install the addons properly. Look at the above screenshots. Try repeating the steps or getting someone who knows more about computers than you do to help.
Translations
When you download a mod, please be sure that the mod is compatible with your translation of wow. Some mods only work on the US versions, while some only work on some of the various European versions. These variations are called "Localizations".
TOC Numbers (Out of Date Mods)
When Blizzard patches WoW, they change the Interface number. This means that all mods will be "out of date" unless or until the author releases a new version for that interface. Some people go into the .toc files and update the numbers themselves, but this is STRONGLY advised against as it will cause problems locating possible incompatibilities addons. When you log into WoW after a patch, you DO NOT have to delete your interface directory. All you have to do is simply tell WoW to ignore the interface numbers and load all the mods anyway. All you have to do is, while at the "character select" screen, look in the lower left corner and click on the "addons" button. A window will pop up listing all your installed mods.
If you look in the upper left corner of that window there should be a box that says "Load Out of Date AddOns". You want to CHECK this box. Now simply go into WoW normally and all your mods should load. As of the 1.9 patch, you will have to do this after EVERY patch/update that Blizzard posts! If you encounter any problems with a mod after a patch, please be sure to let the author of the mod know so they can fix it.
See also: About "Out Of Date AddOns"
Mac Support
WoW addons are not platformed based. As such, they can be used on either Mac or PC. You can extract both .zip and .rar files on a Mac using StuffitExpander.
Directory Structure
World of Warcraft
|_ Interface
|_AddOns
|_*AddonName*
|_ *AddonName*.toc
|_ *AddonName*.xml
|_ *AddonName*.lua
|_ (possibly others as well)...
