THE RPG IS BEING FIXED -- Please Report ALL Bugs Here!!

Talk about anything and everything in this board.

Moderator: Moderator Team

User avatar
Spiritual Me
Hero of the Lufians
Posts: 363
Joined: Wed May 03, 2006 4:13 pm
Location: Right around the corner O.O ... NO RLY!
Contact:

Postby Spiritual Me » Fri Jun 09, 2006 10:30 am

Chris, you should start ending battles for the players, cuz alot of people are being annoyed by this...
I used to be intelligent, education ruined me.

User avatar
SinReVi
High God of the Lufians
Posts: 4638
Joined: Fri Jan 02, 2004 9:57 pm
Location: the Netherlands
Contact:

Postby SinReVi » Fri Jun 23, 2006 3:57 pm

when going to the leaderboard
General Error

Could not query users

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY user_statlevel DESC LIMIT 10' at line 2

select username, user_id, user_class, user_statlevel, user_exp, user_prizelimit, user_hp, user_hpmax, user_mp, user_mpmax, user_att, user_def, user_victories, user_defeats from forum_users WHERE user_id <> -1ORDER BY user_statlevel DESC LIMIT 10

Line : 165
File : userstats.php

Image
Lufia - Curse of the Sinistrals
~ OUT NOW! 2010

User avatar
Guard Daos
High God of the Lufians
Posts: 3235
Joined: Wed Apr 21, 2004 12:06 pm
Location: The Netherlands
Contact:

Postby Guard Daos » Mon Jun 26, 2006 5:44 pm

I was just about to note that as well...
Image

User avatar
Chris
Forum Admin
Posts: 2957
Joined: Fri Aug 22, 2003 2:41 pm
Location: England
Contact:

Postby Chris » Tue Jun 27, 2006 12:05 pm

Gah, this RPG script has broken itself countless times now! Where on earth is that error coming from?!

User avatar
DualBladeAlstadtMilitary
Head Moderator
Posts: 1310
Joined: Tue Aug 26, 2003 3:15 pm
Location: Vancouver
Contact:

Postby DualBladeAlstadtMilitary » Tue Jun 27, 2006 10:02 pm

And now you can focus your energies into LW and GMOZ. :P

User avatar
Chaos
Villager
Posts: 41
Joined: Sat Apr 02, 2005 2:45 am
Location: Australia
Contact:

Postby Chaos » Sat Jul 01, 2006 11:20 pm

(been ages since i've been here.)
the reason why there is an error is because there is no space between the 1 and ORDER making it 1ORDER, which confuses Mysql. you should look around on line 165 of the userstats.php file, if you want i can have a look at it for you. (a lot has changed since i was last here.)
...
What should i put in my sig???
I'm bored.

User avatar
Guard Daos
High God of the Lufians
Posts: 3235
Joined: Wed Apr 21, 2004 12:06 pm
Location: The Netherlands
Contact:

Postby Guard Daos » Mon Jul 03, 2006 1:02 pm

*is impressed* :o
Image

User avatar
Chris
Forum Admin
Posts: 2957
Joined: Fri Aug 22, 2003 2:41 pm
Location: England
Contact:

Postby Chris » Mon Jul 03, 2006 1:38 pm

Chaos wrote:(been ages since i've been here.)
the reason why there is an error is because there is no space between the 1 and ORDER making it 1ORDER, which confuses Mysql. you should look around on line 165 of the userstats.php file, if you want i can have a look at it for you. (a lot has changed since i was last here.)

Nice catch! Consider it fixed. :)

User avatar
Guard Daos
High God of the Lufians
Posts: 3235
Joined: Wed Apr 21, 2004 12:06 pm
Location: The Netherlands
Contact:

Postby Guard Daos » Mon Jul 03, 2006 2:06 pm

Yep, it's working again! Great job!

Now then, perhaps you could create some new spells...?
Image

User avatar
Chaos
Villager
Posts: 41
Joined: Sat Apr 02, 2005 2:45 am
Location: Australia
Contact:

Postby Chaos » Wed Jul 05, 2006 9:33 am

Chris wrote:Nice catch! Consider it fixed. :)

If you need help with anything else just ask, i've been learning php and mysql and i also use phpbb and a rpg (adr, not moggie's) and programing for it, so i've learnt lots during the lst few months.

anyway, glad to see you got it working.
...

What should i put in my sig???

I'm bored.

User avatar
Spiritual Me
Hero of the Lufians
Posts: 363
Joined: Wed May 03, 2006 4:13 pm
Location: Right around the corner O.O ... NO RLY!
Contact:

Postby Spiritual Me » Thu Aug 10, 2006 11:28 pm

Seriously Chris, you should start ending battles or at least make a button to end battles with, since im still stuck with this damned Lost Hero.

I'll just keep hammering I guess.. :roll:
I used to be intelligent, education ruined me.

User avatar
malaksephiroth
Red Jelly
Posts: 4
Joined: Thu Jan 08, 2009 1:22 am

Postby malaksephiroth » Sun Jan 18, 2009 1:52 pm

is there a way to get brave apples and other items like that to work or have they not been given a function yet?

User avatar
Kronoan
Soldier
Posts: 92
Joined: Sat Feb 28, 2009 4:20 am

Postby Kronoan » Sat Mar 07, 2009 12:43 pm

Someone wants me dead & I just started the RPG ... I've camped out about 10 times (I'm trying to save money to heal because the Inn's too expensive & I have to have 50 Gold to Save my Stats, why do we have to pay for these Chris?

This must be the first RPG where it costs money to save & I honestly don't like that!); & out of those 10 times I found some gold twice, I slept uncomfortably on rocks, I got attacked by someone who'd stabbed me apparently, took pretty much all my gold (71 it said & I don't remember how much I'd had but I know that was probably all of it or close to); & the rest of the times, 5 times in a row now, I've had an attempted murder.

1. What is wrong with this world? We can't even sleep safe at night outside a city? Are there no safe outdoor spots close to town?

2. What is wrong with my char.? How stupid must he be to not be able to protect himself better, especially after having this happen to him not only once but as many times as he has? Can't he figure out he needs to find a much safer area when he Camps Out?

3. Is there any one specific person/NPC trying to actively kill me or anyone he/she/it's attackes? It's like once he's blooded me he won't ever leave me alone again, creepy stalker to the max or something.

There's more but I'll be lucky if I'm not over a space limit ... So more later!

What's LW & GMOZ DBAM? (Man it feels weird using that many acronyms in those few words ...)
I Like Swords!

Never Give Up, Never Surrender!

Time Can Be Your Ally, Use It Well!

User avatar
Guard Daos
High God of the Lufians
Posts: 3235
Joined: Wed Apr 21, 2004 12:06 pm
Location: The Netherlands
Contact:

Postby Guard Daos » Sat Mar 07, 2009 1:11 pm

Kronoan wrote:Someone wants me dead & I just started the RPG ... I've camped out about 10 times (I'm trying to save money to heal because the Inn's too expensive & I have to have 50 Gold to Save my Stats, why do we have to pay for these Chris?


Erm... You do know that you don't have to save each time you play, right?
The save option is just in case you do something you don't like and want to load to undo it. Other than that... the start of the RPG isn't an easy one, we all have to go through it. Think of it as a kind of hazing. ;)
Image

User avatar
Brown-Acid
Sinistral Slayer
Posts: 501
Joined: Tue Aug 07, 2007 1:05 pm
Location: Somewhere in Australia
Contact:

Postby Brown-Acid » Sun Mar 08, 2009 6:39 am

What is wrong with this world? We can't even sleep safe at night outside a city? Are there no safe outdoor spots close to town?


Its like an R rated fantasy world......the inns are probably expensive cos they think people are willing to pay that amount to live
give me a moment so i can think up a good idea


Return to “Off-Topic Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest