Go Back   Naruto - Collectible Card Game > Naruto Collectible Card Game > Organized Play Software and Website
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 11-01-2010, 12:34 PM
Animewolf17 Animewolf17 is offline
Jonin
 
Join Date: Jun 2006
Posts: 1,748
OP site error

Upcoming tournaments on the OP site is messed up I tried to lookup my locals schedule for this month and this is what came up

Query failed SELECT locationwebsite, locationphone, gametypeid, tournamentname, locationname, locationadd1, locationadd2, locationcity, locationstate, locationzip, tournamentlevel, date_format(tournamentdate , '%m/%d/%Y %l:%i %p') as tournamentdate, meijin, userfirst, userlast, notes FROM `tournaments` inner join locations ON tournaments.locationid = locations.locationid left outer join users ON users.userid = tournaments.meijinid WHERE (locationcountry='USA') AND (locationstate LIKE '%TX%') AND (tournamentdate >= '2010-11-01') AND (tournaments.approved ='1') AND (tournaments.gametypeid ='2') AND (locationname LIKE '%The Castle%') AND (tournaments.tournamentlevel LIKE '%%') ORDER BY tournamentdate
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -7. The time now is 12:13 PM.


Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.