Author Topic: pvp error  (Read 3325 times)

Patti

  • Newbie
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
pvp error
« on: October 05, 2012, 05:36:10 pm »
SELECT acctid,level FROM accounts
           
            WHERE location='Wohnviertel'
            AND (pvpflag < '2012-10-05 16:23:57')
            AND (alive=1) AND (locked=0) AND (slaydragon=0)
            AND age>5 OR dragonkills>0 OR pk>0 OR experience>3500)
            AND (alive=1)
            AND (laston<'2012-10-05 16:18:57' OR loggedin=0) AND (acctid<>1)
            AND (lastip != '93.221.15.48')
            AND (uniqueid != '963425e401cddf1a7df478c735602862')
           

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 (alive=1) AND (laston<'2012-10-05 16:18:57' OR loggedin=0) AND (ac' at line 6
Call Stack:
1: db_query("SELECT acctid,level FROM ...") called from /home/domains/lotgd.aszlig.net/modules/dwellings_pvp/dohook/pvpcount.php on line 26
2: require("/home/domains/lotgd.aszli...") called from /home/domains/lotgd.aszlig.net/modules/dwellings_pvp.php on line 53
3: dwellings_pvp_dohook("pvpcount", Array(

    "count"=>"1", "loc"=>"Wohnviertel"

)) called from /home/domains/lotgd.aszlig.net/lib/modules.php on line 517
4: modulehook("pvpcount", Array(

    "count"=>"1", "loc"=>"Wohnviertel"

)) called from /home/domains/lotgd.aszlig.net/lib/pvplist.php on line 133
5: pvplist() called from /home/domains/lotgd.aszlig.net/pvp.php on line 35

sorry my english is bad :-/
in deutsch koennte ich besser schreiben Wink

Patti

  • Newbie
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: pvp error
« Reply #1 on: October 05, 2012, 07:23:17 pm »
Ich glaube ich konnte es fixen :

open /modules/dwellings_pvp/dohook/pvpcount.php

search :

Code: [Select]
AND age>$days OR dragonkills>0 OR pk>0 OR experience>$exp)

replace with

Code: [Select]
AND (age>$days OR dragonkills>0 OR pk>0 OR experience>$exp)

muesste so richtig sein, auf jeden fall bekomme ich keine error mehr.

Nightborn

  • Administrator
  • Sr. Member
  • *****
  • Posts: 320
  • Karma: +20/-0
    • View Profile
    • Shinobilegends
Re: pvp error
« Reply #2 on: October 30, 2012, 07:34:56 am »
Genau, klammer.

Quote
1: db_query("SELECT acctid,level FROM ...") called from /home/domains/lotgd.aszlig.net/modules/dwellings_pvp/dohook/pvpcount.php

Problem war das Dwellings-Modul ;) nicht +nb Core.
It should be fixed, but it won't be easy and it won't be fast. If you want
to help - wonderful. But keep in mind that it will take months of wading
through the ugliest code we have in the tree. If you've got a weak stomach -
stay out. I've been there and it's not a nice place.

   - Al Viro