Sign Up! Login: Password: New User? Forgot? Support
Top Mods!
Wowhead Search
by sonofsamedi
Digital Clock
by Wolfar15
Admin Forums
Welcome to the GuildPortal Help Community! These forums are for admin-to-admin help.
Available Forums
Forums : Pimp My Site! > Mortis Gladius (EQ)
Prev 1 2 3 4 5 6 7
536885761_Inactive (New Admin) 7/1/2004 2:34 PM EST : RE: Mortis Gladius (EQ)"
536885761_Inactive
Posts: 3977
Zomgawsh Poster

name="2911915">

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 14
Needs Query failedXML Parsing Error: no element found
Location: http://users.adelphia.net/~jbshawn/needs/needsxml.php
Line Number 16, Column 19:Needs Query failed
------------------^

TopBottom

537013185_Inactive (New Admin) 7/3/2004 1:06 AM EST : RE: Mortis Gladius (EQ)"
537013185_Inactive
Posts: 617
Zomgawsh Poster

I generated the exact same error by a simple mistake , user i set to use to loginto the sql was dba [ database admin]  i created another standard user , set read write permissions and volia , another wilton needs page is up on guildportal.
TopBottom

536885761_Inactive (New Admin) 7/3/2004 2:33 AM EST : RE: Mortis Gladius (EQ)"
536885761_Inactive
Posts: 3977
Zomgawsh Poster

I generated the exact same error by a simple mistake , user i set to use to loginto the sql was dba [ database admin]  i created another standard user , set read write permissions and volia , another wilton needs page is up on guildportal.


Grats!

btw: Wilton is a quest NPC in Ocean of Tears.

-- Wiltan

/smirk
TopBottom

537013185_Inactive (New Admin) 7/3/2004 3:34 AM EST : RE: Mortis Gladius (EQ)"
537013185_Inactive
Posts: 617
Zomgawsh Poster

Sorry about the typo , fat fingers hehe , and by the way , thank you for the super nice content item , [ Needs ], and the insane hours of mind bending I KNOW that java took you to do .


P.S. only took me like 30 hours to figure out my mistake on user name for sql hehe , we ain't all as good as you at this hehehe!
TopBottom

536885761_Inactive (New Admin) 7/3/2004 3:59 AM EST : RE: Mortis Gladius (EQ)"
536885761_Inactive
Posts: 3977
Zomgawsh Poster

Heh, that WAS a lot of work, but since so many folks are getting a lot out of it, it was worth the time, headaches, and forehead-shaped dents in my wall. It was a learning experience that helped a lot; the DKP app I made took only a few hours to be fully functional, because I already knew of most of the problems I'd run into.

Maybe at some point I'll set up a post with instructions for setting up the three XML things I've built for GP sites (Needs, DKP, and EQ Server Status) since a lot of folks have shown interest in them.
TopBottom

537013185_Inactive (New Admin) 7/3/2004 9:44 AM EST : RE: Mortis Gladius (EQ)"
537013185_Inactive
Posts: 617
Zomgawsh Poster

dkp ?? OK NOW YA DONE IT WHAT dkp ?? COME ON SPILL IT
TopBottom

536885761_Inactive (New Admin) 7/3/2004 10:30 AM EST : RE: Mortis Gladius (EQ)"
536885761_Inactive
Posts: 3977
Zomgawsh Poster

Doh... did I never mention the DKP thing I made? (I don't use it on the MG site so I know I didn't mention it in this thread at least.)

Go to the “Search Guilds” thing and find Legendary Bloodlines, and view their DKP page. That's all generated by PHP/mySQL and presented using XML/XSL. On the back end there are external pages for the data entry; I didn't want to deal with security so only the officers know the URL.
TopBottom

537013185_Inactive (New Admin) 7/3/2004 7:17 PM EST : RE: Mortis Gladius (EQ)"
537013185_Inactive
Posts: 617
Zomgawsh Poster

No....... you kinda never mentioned it ! ok so like I got 3 gold plated gummy bears and a bag of 37 year old peanuts from the circus , you can have em for sharing your dkp xml hehe , PURTY please???????? heh much rather feed my dkp server than embed it
TopBottom

536885761_Inactive (New Admin) 7/4/2004 5:34 AM EST : RE: Mortis Gladius (EQ)"
536885761_Inactive
Posts: 3977
Zomgawsh Poster

name="2926319">

All right, all right... here it is:

http://lenpal.3rdoffense.com/eq/dkp/dkp.zip

Here'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 collection
of modules for their own websites and may alter the
code to meet their own needs. It is requested that
the user credit "Wiltan Ryouki of Mortis Gladius on
Xev" where possible on displayed pages. A freeform
HTML box below the XML output on a Guildportal page
would 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's
Guildportal site.

 


2. Configuration
____________________________________________________

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.
 


5. Disclaimer
____________________________________________________

  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.

TopBottom

537013185_Inactive (New Admin) 7/4/2004 10:39 AM EST : RE: Mortis Gladius (EQ)"
537013185_Inactive
Posts: 617
Zomgawsh Poster

1: You are lobable - ly insane
2: You are awesome in your kindness and helpfullness to others
3: I am prob. your slave like friend for life
 4: Ok,  I am sending you 3 gold plated Gummy Bears and 2x 37 year old bags of peanuts via brazilian express , [ they promise deleivery within 100 years]

5 , Thank you very deeply Wiltan , I owe you greatly for this favor and help
TopBottom

Prev 1 2 3 4 5 6 7
Admins Online
There are   members online.
So-and-so has logged on!
%title%
%message%