Welcome to Gaia! ::

Gaia Forums » GAIA Online » Site Questions & Assistance » Gaia Guides and Resources
<3 </3

GQL - Using it?

Yup. 0.11801242236025 11.8% [ 76 ]
Not Yet. 0.40217391304348 40.2% [ 259 ]
Nope. Not into questing. 0.12888198757764 12.9% [ 83 ]
Poll whoring because I (the poll whore) suck. 0.35093167701863 35.1% [ 226 ]
Total Votes:[ 644 ]
Reply
1 2 3 4 5 6 7 >

Interesting Noob

Offline
User Image - Blocked by "Display Image" Settings. Click to show.



You're probably wondering what I'm talking about with the GQL. I've started learning about PHP and MySQL, and this project is to help me learn more easily. I already know a few computer programming languages, and decided to move on to web programming, such as thus.

About 6 months ago, I made the Gaia Quest Poster program in Visual Basic, and I knew not many people could make it work because it was for Windows, required downloading that, as well as new framework, and took a while to load. It's posted on my site still, on this page.

Ok, now back to what I've newly created - the GQL. I had loads of help with this, so I can't take all of the credit. I had to look through several sites looking for solutions, and ask many people for help. The two biggest helps to this project are Galphenos, hion2000, and Myspoonistoobig (users on this site.)

I do have one set up for myself: My GQL.

Features of the GQL(Instructions.html):

- Quick easy installation.
- 6 different easy to apply styles.
- 10 included header images.
- Automatic frame breaking for those that link their GQL in their sig.
- Password protection using sessions.
- The date of your entries is automatically posted.
- Optional comments module so people can leave you comments, adjustable on the control page.
- Control panel to change quest/viewing settings.
- Past posts and comments can be easily deleted.
- Good for high priced quests.
- Does the math for you, so you don't have to.
- Allows you to easily display an image of your item, or other header image.
- Uploading a new header image replaces the old one, so lots of space is not taken up.
- Hardly any PHP/MySQL knowlege needed to use.
- Detection of install files.
- Each new entry is added above the older one.
- 5 entries shown at one time by default. You may modify this in the control panel.
- Keeps track of your more common information, so you don't need to keep inputting it in.
- Gives you the link to the page to give to other people.
- Easy uninstall.

For a full layout of feature updates, to signup to be notified when there are GQL updates, or to just upload the updated/new files, go here.

Okay, so now I bet you're atleast a little bit interested in wanting your own? wink

The folder comes zipped, so you need something like WinZip free trial to open it. Most newer Windows computers have that type of feature built in.

The download link for the GQL ( Last updated November 24 ):



=============================
GaiaOnline.Com Quest Log
=============================



I've set up a GQL for anyone that wishes to fiddle around with it before trying to upload it themselves. It's fully operational, excluding the ability to uninstall the thing and not show the comment box. The password is: elephant.

http://www.yellow-ducky.com/Gaia/quest/index.php


If you have any questions, I'll try my best to answer them. smile


------- Give Comments/Suggestions -------

Interesting Noob

Offline
User Image - Blocked by "Display Image" Settings. Click to show.


To all you questers out there, here are some very helpful links that I've personally checked out with (and am affiliating with) to help you get to your goal even faster. smile But, please don't be rude or demanding to these generous people.

If you own a charity or lotto, and would like to affiliate, PM me and ask me first; include your link to your charity/lotto so I can check it out first for validitity.


:: Affiliated Charities ::

The Wishing Well Charity

:: Affiliated Lotteries ::

User Image - Blocked by "Display Image" Settings. Click to show.

Offline
I hope I'm not alone when I say I'm very confused by this. It just keeps track of an item or something? Wouldn't this be better for one central location so people can just "host" their item on a database without needing php+mysql access? sweatdrop

Interesting Noob

Offline
Chema
I hope I'm not alone when I say I'm very confused by this. It just keeps track of an item or something? Wouldn't this be better for one central location so people can just "host" their item on a database without needing php+mysql access? sweatdrop


It keeps track of the information you put in such as:

Item price
Item name
Image of your choice
Starting price
Date of entry
How much you need to gain
How much gained in the past day
How much gained since you started questing

It does the math for you as well, so it takes half the time and looks alot prettier.

Right now, my quest thread: http://www.gaiaonline.com/forum/viewtopic.php?t=9051087

My log file on that was created using the Visual Basic program I created, but now I will just be linking the my GQL instead, since it does pretty much the same thing.

I didn't want to create a general user registration system, because since I just started learning PHP, I don't want to go that far into the process of doing something like that. I thought about it, but I decided not to. So this just is ending up like most other things on here, like the shoutbox, gaiabar, sigmaps, etc. that need to be hosted on a separate web host with MySQL abilities.

Interesting Noob

Offline
Free PHP/MySQL Hosts

I have checked each of these out for a few minutes to make sure there were no banner ads/popups and are free. Please PM me if one of them goes down or has a problem so I can remove the link. smile

Host Rave

Fun Pic

Bobos

Free Web Host (Upgrading at the moment, signups are down for now.)

Interesting Noob

Offline
sweatdrop There were lots of validation errors with the HTML and the CSS.

Fixed those, hopefully I got them all. >.< I checked them with the jigsaw and w3 validators, so ya...

Wealthy Capitalist

5,750 Points
  • Millionaire 200
  • Entrepreneur 150
  • Money Never Sleeps 200
Offline
Though you have a good idea, and it seems that you've put a great deal of effort into this, I'm afraid that this just won't take off. People try to avoid hosting things that they don't need to accomplish the same thing a little work could manage just as well. Then again, who knows?

Interesting Noob

Offline
Lord-of-the-flies
Though you have a good idea, and it seems that you've put a great deal of effort into this, I'm afraid that this just won't take off. People try to avoid hosting things that they don't need to accomplish the same thing a little work could manage just as well. Then again, who knows?


It took me 4 days to learn how to do that s**t...Not many people have quest logs, which I've noticed if a quest thread has a log in it, then the donator list is longer, just because it seems more legitimate, I guess.

I've checked for those free hosting sites with no ads, and signup isn't a pain in the a**, plus it's a self-install/uninstall type of thing, so I see no real issue with it.

Offline
I need a little help. What exactly do I put in the "localhost" "user name" "password" "data base" spaces?

Interesting Noob

Offline
SpongeBob SquarePant
I need a little help. What exactly do I put in the "localhost" "user name" "password" "data base" spaces?


This is explained next to where you need to enter that information in login.php and in Instructions.html.

localhost sometimes can stay the same, but if that doesn't work, you need to contact your host for what your mysql database is; for me it's mydatabase.mydomain.com, but for you it could be different.

user name is the username you have for the database you want the script to work on.

password is the password for the username for the database you want the script to work on.

database is the name of the database that you want the script to work on.

Interesting Noob

Offline
sweatdrop It took a long time, but I finally took apart most of the script to make it easier to use and not a pain in the a** by using sessions to store the passwords.

Next step is to find out how to post submit time into the entries.

Interesting Noob

Offline
stressed Why didn't anyone mention that the login file didn't include needed variables?

Fixed it. Now I'm working on putting an automatic date stamp. I'm almost done, I just need to stop it from looping uncontrollably.

[Aug 31 edit]: sweatdrop I still havn't found how to sucessfully display the date in words AND have it be included in my entries properly. I've tried experts-exchange.com, and the C&T forum. It seems that I either have to keep making people input the date on their own, or they have to be happy with the date as numbers. neutral

Offline
i think that would be a very good idea 3nodding 3nodding

Wealthy Capitalist

5,750 Points
  • Millionaire 200
  • Entrepreneur 150
  • Money Never Sleeps 200
Offline
FallenForesakenAngel
[Aug 31 edit]: sweatdrop I still havn't found how to sucessfully display the date in words AND have it be included in my entries properly. I've tried experts-exchange.com, and the C&T forum. It seems that I either have to keep making people input the date on their own, or they have to be happy with the date as numbers. neutral


The best way to do this is a database input with the time() function, then convert during display. I've been developing a complex forum system, so I've had to deal with this a lot, but it's payed off.

When adding the time/date to the database, use time(). This information will be something like "1125513652", but it has the information that PHP needs to covert out.

The below function is the function that the Beta Forums program uses to convert to any format.
function converttime($time = "{time()}",$format = "H:i a"){
return @gmdate($format,($time+date('I')))
}


It acts simularly to a variable in that you can echo it. Without any variable inputed, it will display the current time in the "H:i a" format, but for this case, you'll need those variables.

Mini Documentation
int coverttime ( string time, string format );

String time - The time that you input into your database. Simply call that information from the database, and plug it into the function.

String format - See date() function for information.

Offline
Her host won't allow her to do time() apparently (which would be an instant switch for me, but meh)
Gaia Forums » GAIA Online » Site Questions & Assistance » Gaia Guides and Resources

Quick Reply

Submit
Manage Your Items
Other Stuff
More
Get GCash
Offers
More
Get Items
More Items
More
Where Everyone Hangs Out
Other Community Areas
  • Guilds
    fan clubs for the stuff you love
  • Chat
    chat in real time with other Gaians
  • Art Arenas
    browse & rate gaian art galleries
  • Clans
    play zOMG with others
More
Virtual Spaces
Fun Stuff
More
Gaia's Games
Mini-Games
More
Play with GCash
Play with Platinum
More