#3623 - 01/13/70 04:22 AM
Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
Offline
|
|
I have a Unknown column '0_exp' in 'field list' error in the Extended Stats and without changing anything in the monster and player levels, my char gets extra lvl with each next kill...
|
|
Top
|
|
|
|
#3624 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
|
Offline
|
|
Additionally, there is no $app_path in lib.php as stated in the readme...
|
|
Top
|
|
|
|
#3625 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
yop
Malt-o-Meal
Registered: 02/24/04
Posts: 6
|
|
Offline
|
|
I thing to have read somwhere, that the lastest version of dk don't need editing $app_path for be launched correctly.
|
|
Top
|
|
|
|
#3626 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
|
Offline
|
|
I have figured that out, but it's still in the latest readme. Meanwhile, the Unknown column 0_exp in field list in expanded stats still persists.
|
|
Top
|
|
|
|
#3627 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
yop
Malt-o-Meal
Registered: 02/24/04
Posts: 6
|
|
Offline
|
|
For the Unknown column 0_exp I have no idea... Sorry.
Can you take a look upon my own problem ;-), maybe you'll have the answer!^^
|
|
Top
|
|
|
|
#3628 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
|
Offline
|
|
I have. The installation goes fine, cookies work fine, and the game works. The whole of it but this 0_exp column and getting levels after each kill... waiting for admins 
|
|
Top
|
|
|
|
#3629 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Jamin
Cookie Crisp
Registered: 02/25/05
Posts: 2649
Loc: Texas
|
|
Offline
|
|
Gotta go to class right now, I'll look at it when I get home.
---Jamin
|
|
Top
|
|
|
|
#3630 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
|
Offline
|
|
Thanks. Here's a link where I installed it (just in case): http://www.supremestarcraft.com/sscrpg/
|
|
Top
|
|
|
|
#3631 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
|
Offline
|
|
I think I figured it out: users.php has a line:
$usernamequery = mysql_query("SELECT username FROM dk_users WHERE username='$username' LIMIT 1");
dk_users doesn't exist, because I changed the prefix to sscrpg... might be other files with the same problem...
Edit: that didn't fix the main problem 
Edit2: I think now I got it. The admin char had this problem. The new char I registered works fine...
|
|
Top
|
|
|
|
#3632 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
|
Offline
|
|
Yup, confirm: Admin char created with install.php isn't working right. Other chars are.
|
|
Top
|
|
|
|
#3633 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Jamin
Cookie Crisp
Registered: 02/25/05
Posts: 2649
Loc: Texas
|
|
Offline
|
|
Thanks for the info. I'm gonna try to finish up v1.1 tonight or tomorrow, I'll have this fixed in that version.
---Jamin
|
|
Top
|
|
|
|
#3634 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
|
Offline
|
|
Sweet! Thanks! Say, any plans for making players able to fight each other? 
|
|
Top
|
|
|
|
#3635 - 01/13/70 04:22 AM
Re: Unknown column '0_exp' in 'field list'
|
Jamin
Cookie Crisp
Registered: 02/25/05
Posts: 2649
Loc: Texas
|
|
Offline
|
|
Not at this time... I got an email from someone who said he was working on a way to make that work, but I'm not sure how he's accomplishing it.
I thought about doing someting like that - the problem with it, though, is there are only a few player variables that control how strong you are. In games like Diablo II, there are all kinds of different little things that work to give a player certain advantages. In this game, it really only comes down to who's got more Attack Power, so it kind of defeats the purpose.
I like the idea of making something PVP, but this particular game just isn't really set up for it. If I get around to ever making a second game, it is something I want to do, though.
---Jamin
|
|
Top
|
|
|
|
#3636 - 01/13/70 04:24 AM
Re: Unknown column '0_exp' in 'field list'
|
Jamin
Cookie Crisp
Registered: 02/25/05
Posts: 2649
Loc: Texas
|
|
Offline
|
|
1.1 isn't gonna be coming until AT LEAST Saturday now. I had a big paper to write for one of my classes and that's been taking up all my time for today, and it will probably take up all of my time tomorrow too. So it's looking like Saturday or Sunday for the new version. Its still coming, though, and it will be cool.
---Jamin
|
|
Top
|
|
|
|
#3637 - 01/13/70 04:25 AM
Re: Unknown column '0_exp' in 'field list'
|
Miker
Malt-o-Meal
Registered: 02/25/04
Posts: 10
|
|
Offline
|
|
I'd like you to look at the combat system I've done, maybe you'll like it
http://www.supremestarcraft.com/sscrpg/index.php
Also, if possible, I'd like to talk to you on icq/aim/msn...
|
|
Top
|
|
|
Moderator: Jamin
|
|
