The problem is in the PHP code connecting to your mySQL database. Here is more detailed information from trying to access that page. (I used Netscape because sometimes it's to our advantage that Netscape doesn't handle XML errors as gracefully as IE.) The first error is the important one, so I'll bold it. Everything else is just a snowball effect.Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /www/j/b/jbshawn/public_html/needs/needsxml.php on line 8
Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /www/j/b/jbshawn/public_html/needs/needsxml.php on line 8
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /www/j/b/jbshawn/public_html/needs/needsxml.php on line 9
Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /www/j/b/jbshawn/public_html/needs/needsxml.php on line 14
Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /www/j/b/jbshawn/public_html/needs/needsxml.php on line 14
Warning: MySQL: A link to the server could not be established in /www/j/b/jbshawn/public_html/needs/needsxml.php on line 14Needs Query failedXML Parsing Error: no element foundLocation: http://users.adelphia.net/~jbshawn/needs/needsxml.phpLine Number 16, Column 19:Needs Query failed------------------^
All right, all right... here it is:http://lenpal.3rdoffense.com/eq/dkp/dkp.zipHere's the readme file with instructions, although you can open this from the zip file as well:==================================================== WILTAN RYOUKI'S DKP SYSTEM README.TXT====================================================
1. License and Use____________________________________________________
The user is given permission to use this collectionof modules for their own websites and may alter thecode to meet their own needs. It is requested thatthe user credit "Wiltan Ryouki of Mortis Gladius onXev" where possible on displayed pages. A freeformHTML box below the XML output on a Guildportal pagewould be more than sufficient. Recommended text is:
"This DKP system was developed by Wiltan Ryouki of Mortis Gladius on the Xev server (EQ) using PHP, mySQL, XML, and XSL, and CSS." Bonus points for linking "Mortis Gladius" to MG'sGuildportal site.
A. Basic Installation:
Create a folder on your personal webspace (which must support PHP and mySQL) and put all of the files in this package in that folder. B. Cascading Style Sheet (CSS)
If you have a CSS file you wish to use in place of the existing stylesheet, make sure it has all of the same classes and tags specified in this package's stylesheet (sunset.css), and delete sunset.css and replace it with your own. You could choose to open each .php page and edit the reference to point to your stylesheet (bah) or you could rename your stylesheet in the DKP folder to sunset.css (easier). The stylesheet is only used on the administrative pages and will not affect the display in the XML/XSL transforms.
C. mySQL Setup
In your mySQL database, create the following tables: tblDKP_Events nID int(11) Primary auto_increment sEvent text sZone text nValue int(11) sNotes text dDate text tblDKP_Members nID int(11) Primary auto_increment sName text nBalance int(11) tblDKP_Transactions nID int(11) Primary auto_increment nType int(11) dDate text nMemberID int(11) nEventID int(11) sDescription text nValue int(11)
D. Required File Changes
Throughout every page with the .php file extension, there will be at least one instance (and sometimes three or four) of the following code block: $db = mysql_connect("localhost", "INSERT-YOUR-DB-LOGIN-HERE", "INSERT-YOUR-DB-PASSWORD-HERE"); mysql_select_db("INSERT-YOUR-DB-NAME-HERE",$db);
This should be pretty self-explanatory. Change the "INSERT-YOUR" items to the appropriate text so the code can access your mySQL database.
3. Getting Started____________________________________________________
A. Adding Members
Open the addmember.php page in your browser to begin adding your guild members to the system. B. Setting up your DKP page in Guildportal
In your guild site's control panel, add a page called DKP. Add an XML/XSL content box to the page entitled "DKP Standings" and point it to your copy of attxml.php and attxsl.xsl.
Add an XML/XSL content box to the page entitled "Raid/Event History" and point it to your copy of raidxml.php and raidxsl.xsl.
Add an XML/XSL content box to the page entitled "Item History" and point it to your copy of itemxml.php and itemxsl.xsl.
4. Using the System____________________________________________________
A. Have your raid. B. Your designated "DKP Officer" (which may be the guild leader or anyone else you trust with this system) goes to the addevent.php page after the raid and fills in the appropriate fields, and then marks off the checkbox for each member that attended the raid. (If someone attended only part of the raid and will receive partial credit, mark their checkbox and go back to partial.php later to adjust the amount.) Click "Add" on the addevent page to submit that raid. It's now part of the system. C. Items get into the system when someone "buys" them with DKP. Go to the buyitem.php page to record item purchases. There, you'll select the member and the raid on which the item had dropped. Enter the item name exactly as it appears in-game, the date the item was awarded to the member, and the number of DKP spent, and click "Add". This will populate your item history report as items are purchased. D. Some guilds choose to award non-raid DKP for various services to the guild. You can do this using the adjust.php page. It should be pretty self-explanatory. E. If you wish to have printed copies at any time, you may do so from print_attxml.php, print_itemxml.php, and print_raidxml.php. They are especially formatted to be printer-friendly.
This software is presented "as is". If you find a bug, you're welcome to let me know, but I can't guarantee I'll have the time to fix it, and I can't be held responsible for any problems you might encounter, etc. You're also welcome to make feature requests. The most effective way to do so is to stand outside the front door to your home and shout as clearly as possible, "Wiltan, please add the following feature: <insert request here>." If the front door method is inconvenient, a large window in your home or office may be substituted. Due to the number of feature requests I get in this manner, I can't respond personally to each one, so you'll just have to assume I got the request and will try to work it into a future revision.