Author: karamba, Posted: Thu Jul 15, 2004 10:56 pm Post subject: VWar Nuke dont show WarCalender to public
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:
-> Database Error: Invalid SQL:
SELECT warid, gamename, gameicon, oppnameshort, status, dateline, vwar15.gameid, repeat_number, repeat_mod
LEFT JOIN vwar15_opponents ON (vwar15.oppid = vwar15_opponents.oppid)
LEFT JOIN vwar15_games ON (vwar15_games.gameid = vwar15.gameid)
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!...
Author: Raptor1, Location: Conway SCPosted: Fri Jul 16, 2004 1:22 am Post subject: Re: VWar Nuke dont show WarCalender to public
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.