VWar Nuke dont show WarCalender to public

Nuke Cadet Joined: Jul 16, 2004 Posts: 2

Hi there!

I have installed the VWar-Nuke Module for my Clansite.

All work fine, only problem is, when you not logged in into the vwar-module as clanmember and you try to watch the "clan calender" you get a SQL-Error like this:

Code:

-> Database Error: Invalid SQL:
SELECT warid, gamename, gameicon, oppnameshort, status, dateline, vwar15.gameid, repeat_number, repeat_mod
FROM vwar15
LEFT JOIN vwar15_opponents ON (vwar15.oppid = vwar15_opponents.oppid)
LEFT JOIN vwar15_games ON (vwar15_games.gameid = vwar15.gameid)
WHERE
ORDER BY dateline ASC
-> MySQL Error: You have an error in your SQL syntax near 'ORDER BY dateline ASC' at line 7
-> MySQL Error Number: 1064
-> Date: 16.07.2004 @ 08:57
-> Script: /planetvietcongclan/modules.php?name=vwar&file=calendar
-> Referer: http://www.imtim.de/planetvietcongclan/modules.php?name=vwar

So, i want to make the war-calender public accessable! Any ideas why i got this error-message? All other work fine!...

please Help!

Posted: Fri Jul 16, 2004 1:22 am

FROM vwar15 <--- Thats the issue, I have never been able to get 1.5 to work though many have.
I run 1.4 on my site no issues as far as install and all things working, just an't get the dam drop down menu to change font colors so that people can read them.

Try 1.4 Nuke. Holla!!!