DragonPrime - LoGD Resource Community
Welcome Guest
  • Good evening, Guest.
    Please log in, or register.
  • February 17, 2019, 06:40:52 PM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
Search

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

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

Code:
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.
Logged
Nightborn
Guest
« 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.



Logged
DarQness
Guest
« 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... =/
Logged
Nightborn
Guest
« 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.
Logged
DarQness
Guest
« Reply #4 on: February 26, 2006, 12:46:17 PM »

Ahah! Nightborn, you are a genius!

...Or I'm just extremely stupid.

Thanks! Cheesy
Logged
Pages: [1]   Go Up
  Print  
 
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
18 Guests, 0 Users
Home Forums News Downloads Login Register Advanced Search