DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • August 18, 2019, 10:55:16 AM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Resource Pages

Pages: [1]   Go Down
Author Topic: Stupid Question Perhaps...  (Read 3443 times)
0 Members and 1 Guest are viewing this topic.
« on: February 26, 2006, 09:55:35 AM »

...But nevertheless, kinda have to ask it anyway eh? =P

SELECT acctid, name, alive, location, sex, level, laston, loggedin, login, pvpflag, clanshort, clanrank, dragonkills, accounts.clanid FROM accounts LEFT JOIN clans ON clans.clanid=accounts.clanid WHERE (locked=0) AND (slaydragon=0) AND (age>5 OR dragonkills>0 OR pk>0 OR experience>) AND (level>=0 AND level<=3) AND (alive=1) AND (laston<'2006-02-26 11:36:12' OR loggedin=0) AND (acctid<>1) ORDER BY location='Degolburg' DESC, location, level DESC, experience DESC, dragonkills DESC

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 ') AND (level>=0 AND level<=3) AND (alive=1) AND (laston<'2006-0
Call Stack:
1: db_query("SELECT acctid, name, aliv...") called from /home/sthought/public_html/lotgd/lib/pvplist.php on line 49
2: pvplist() called from /home/sthought/public_html/lotgd/pvp.php on line 35

That's what it says when I click Slay Other Players. The only thing I can think of that's wrong with this is that my pvp.php is not in the main city, Degolburg, it's on a street/subvillage (see Dhampir's Arcadia Village). All my players are experiencing this, and no one is at level 0 or over level 15.
« Reply #1 on: February 26, 2006, 10:05:47 AM »

experience>) AND <---this piece is the cause.

there should be a number ...but it isn't

look at the given line in the lib/pvplist.php (this file is mentioned in the stack list)

you will see that there is a variable called $exp in the line 42 that should hold a number but obviously holds not even 0 as a value ...

ok, where is this variable coming from? -> line 24
   $exp = getsetting("pvpminexp", 1500);

there lies the error...
check what value you have in there.

« Reply #2 on: February 26, 2006, 12:19:56 PM »

Ehh, I don't really understand what you mean.. but it's happening with all the players. I have 0 exp on my Admin account... =/
« Reply #3 on: February 26, 2006, 12:23:29 PM »

Grotto -> Game Settings -> PvP -> Experience below which player is safe from PvP

what is in there?

if there is no entry, just a blank, then replace it with a "0"

and this should fix it.
« Reply #4 on: February 26, 2006, 12:46:17 PM »

Ahah! Nightborn, you are a genius!

...Or I'm just extremely stupid.

Thanks! Cheesy
Pages: [1]   Go Up
Jump to:  

DragonPrime Notices
Welcome to DragonPrime - The LoGD Resource Community!

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
100 Guests, 0 Users
Home Forums News Downloads Login Register Advanced Search