Hi Guys, Does anyone know if this plugin will work with "1and1" as my host? If yes, then I have these questions... Ive created my data base and now need to import, what file? I tried importing the "setup.php" from ...vmlive/apache/htdocs/vmliveview/setup.php" however, I get this error " MySQL said: Documentation #1064 - 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 'max_connections=200 query_cache_size=32M ### away from defaults ### query_c' at line 2 " Can someone post up a more detailed installation process as I have a "self taught" approach to databases etc... Cheers in advance...
Hi Test, for a manual setup of the database u need to run/import a file called vmliveview.db.manual.setup.sql from the mysql directory of the package ... Cheers Frank
Hi rafalgt, I thought it would be a good idea that not every remote user is able to access and/or use some pages: Code: // -- as a precaution only allow localhost to request this page $illegalRemoteAddr = false; if($_SERVER["REMOTE_ADDR"] != "127.0.0.1" && $_SERVER["REMOTE_ADDR"] != "::1"){ $illegalRemoteAddr = true; } You can either comment out the line $illegalRemoteAddr = true; or you could add your IP to the if phrase like: if($_SERVER["REMOTE_ADDR"] != "127.0.0.1" && $_SERVER["REMOTE_ADDR"] != "::1" && $_SERVER["REMOTE_ADDR"] != "YOUR.IP.ADD.RESS"){ Hope this helps ... Cheers Frank
Hello Frank, I have this as an error: "10.09.2012 21:44:06.015";"SQL Error";"sqlSlotsInsert() Msg: (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 '06','0 ','0','0','3659.7','-1','-1','-1','-1','0','0','0','0','-1','-1','0','0',' at line 1) Query: (INSERT INTO `slots` (`SlotID`,`DriverName`,`Vehicle`,`Laps`,`Sector`,`FinishStatus`,`LapDist`,`BestS1`,`BestS2`,`BestS3`,`BestLap`,`LastS1`,`LastS2`,`LastS3`,`LastLap`,`CurS1`,`CurS2`,`Pitstops`,`Penalties`,`IsPlayer`,`Control`,`InPits`,`LapStartET`,`Place`,`VehicleClass`,`TimeBehindLeader`,`LapsBehindLeader`,`TimeBehindNext`,`LapsBehindNext`,`VehicleSpeed`,`PosX`,`PosY`) VALUES ('1','Rogerio BR','R. Pilve, Baltic GT '06','0 ','0','0','3659.7','-1','-1','-1','-1','0','0','0','0','-1','-1','0','0','0','2','0','0','11','Endurance','1.63','0','0.218','0','0','-2.503','824.576'))" I use the mod "Megane Trophy v2.0", and the vehicles have an apostrophe in their name eg: Artman Racing '06 I did not know anything regarding the scripts, would it be possible to do something because I'd really like to put this plugin on my server. Excuse me for my English, but I use a translator. Thank you in advance.
Hi Marc, yes, u are right. The apostrophe in the vehicle's name is what's causing the break of the sql statement and thus causing it to fail. Which version of the LV are u using currently? Cheers Frank PS: Do you have a link to this mod for me pls?
Hi there, due to some encouragement by MaXyM and the fact that the single quote "'" always has been an issue in the live timing, I switched the whole character sets and encodings over to UTF-8. Here is an example of the current build: http://vxracing.de/vmliveview/monitor.php @Marc: I checked it against the rFactor1 Megane Trophy V2 mod. So far it looks all good. I leave it running for a couple of days to be sure that everything is doing ok and get back to you when I release the next build ... Cheers Frank
Hi, I had already spoken to you but I come back if you find a solution I have to run a pilot with a bmw mercedes but also. There is not a way to avoid a duplicate? even if he changes his car because as you can see the list is long: http://217.16.1.170/live2/hotlaps.php?TrackName=Autodromo+di+Vallelunga Thank you!
Hi Val, this has been fixed already in the latest inofficial Release. See first post for a download link. Cheers Frank
Hi Frank, wir haben in unserer neuen Liga nun auch erfolgreich Dein System installiert. Leider gibt es doch ein aber. Wenn "add_default_charset" ausgestellt ist, funktioniert die Anzeige im IE nicht, im FF aber ok. Hast Du dafür evtl. eine Erklärung? Vielen Dank schon Mal Gruß ennimann
... meinst du das: http://httpd.apache.org/docs/2.0/mod/core.html#adddefaultcharset und wenn ja, welchen Charset habt ihr angegeben und wie sieht die config des liveview diesbezüglich aus? Gruß Frank
Hallo Frank, ja, geht um die Providereinstellung. Default ist da "add_default_charset = ON". Für das SLS System brauchen wir aber "OFF", dann klappt das mit den Umlauten besser. Aber dann sehen wir im IE beim liveview nur noch die Überschrift. Wir verwenden das letzte inoffizielle System von Dir. Standard config mit: "$siteCharSet = "windows-1252";" Reicht das als Angabe? Gruß und schon Mal lieben Danke ennimann
In welcher IE-Version ist das so? In allen? Ist euer Provider Alfahosting? Probiert mal zu Testzwecken: add_default_charset = uft-8 (oder: utf8) Ansonsten alles im liveview auf UTF-8 umstellen (mysql db, charsets in der liveview config) ... Oder warten bis zum nächsten Release. Das kommt komplett umgestellt auf UTF-8 (Plugin, Loader, DB, PHP, Scripts)! Gruß Frank
Du bist der Beste, ja Alfahosting und ja alle IE. Wir testen das mal so. Vielen lieben Dank Frank Gruß ennimann
Hallo Frank, wir haben uns entschieden, das System erstmal so laufen zu lassen, wie es ist. Es funktioniert und viele arbeiten eh mit FF, da geht ja alles. Wir warten dann lieber auf Dein Update und machen dann klar Schiff. Vielen Dank noch Mal für die Klasse Sache hier. ennimann