avs-code / prem-podium-race-e-manager Goto Github PK

Project CARS server

sms_stats_data.json

More info about this file at the project cars forum and UserGuide.pdf.

• Get qualy position automatically.

• Get Vehicle.

• Get tire compound. (acserver.exe > output.txt 2> output.err)

• Get nationality

Keep in mind that most users will not have pay hostings. Must be friendly with free hostings (limitations on bandwith, Inodes Used, database size, etc).

I see two options:

1. Put separate releases for each translated language. The user downloads PREM in the language available that he wants.
2. Make a single multi language web, using strings, definitions, etc.

The module will have disable/enable option.

First design fase:

Thanks for the great Job! I made no problem. Would it be possible in the tool also to take a point penalty weight in the evaluation. For example, in the scoring system maybe build with, so that with place 1 + ?? kg / place 2 + ?? kg / place 3 + ?? kg / from place 4 to place ?? could always enter minus kg kg so that this then also in the overall standings / table behind a driver / team can be seen.
Greeting Armin

A web programmer is necessary to finish the project

Steps to reproduce:
Create a new race
In season option set "No Season"
Go to home page, you can see only listed races with season asociated in next events.

Tables aren't responsive with size <100%

[ENG] So that the user can itself add her name and photo to the database has been backed driver_add_do.php calling driver_add_do_user.php and added this code:

<?php
define('USE_MYSQL', 1);
include 'functions.php';
include 'config.php';

$conn = mysql_connect($config['mysql']['host'], $config['mysql']['user'], $config['mysql']['pass'], $config['mysql']['db'])
or die('issues with the server connection');?>

It seems that the data are added correctly but the following warnings are displayed:

Driver succesfully added
You do not have administrator rights

It may be related to include 'functions.php'; o include 'config.php';

[ESP] Para que el usuario pueda por si mismo añadir su nombre y foto a la base de datos se ha hecho una copia de driver_add_do.php llamándola driver_add_do_user.php y se ha añadido este código:

<?php
define('USE_MYSQL', 1);
include 'functions.php';
include 'config.php';

$conn = mysql_connect($config['mysql']['host'], $config['mysql']['user'], $config['mysql']['pass'], $config['mysql']['db'])
or die('issues with the server connection');?>

Parece que los datos se añaden correctamente pero salen las siguientes advertencias:

Driver succesfully added
You do not have administrator rights

Puede estar relacionado con include 'functions.php'; o include 'config.php';

Login admin -> drivers -> edit a driver -> delete a team.

Page 'team_driver_rem' does not exist or is not readable

Video isn't working
video table:
id video_name video_url
1 Blancpain https://www.youtube.com/embed/NmnkRlDhwtA

PHP file:

<? if (!defined("CONFIG"))
    exit(); ?>
<?
$video = "SELECT `video`.`video_name` FROM video ORDER BY `video`.`id` DESC LIMIT 0 , 30";
$result = mysql_query($video);
if (!$result) {
    show_error("MySQL Error: " . mysql_error() . "\n");
    return;
}
?>
<?
while ($sitem = mysql_fetch_array($result)) { ?>
<?php
$url = 'video_url';
?>

<iframe id="ytplayer" type="text/html" width="420" height="345"
    src="<?php echo $url; ?>" frameborder="0" allowfullscreen></iframe>;

Add a straming block with video inserted from live streaming youtube or twich channel

6b04f5f

http://sparkadsl.0lx.net/PREM/?page=show_rules

<? if(!defined("CONFIG")) exit(); ?>

<?php

$handle = fopen("rules.txt", "r");
if ($handle) {
    while (($line = fgets($handle)) !== false) {
        // process the line read.
    }

    fclose($handle);
} else {
    // error opening the file.
}
?>

How and where can I change the base color of the font [black] for the tool?

show_drivers.php http://prem.hol.es/prem/?page=show_drivers
It is showing drivers as many times as teams have or had.
If a pilot have 2 teams the pilot is showed two times.
Ideal solution will show the pilot only one time GROUP BY driver.id, with the COUNT of all podiums from all their teams (including historical teams in his career).

Sim_results.php show entries from deleted entries, clone the existing race_name results if its empty in data base. Example: http://sparkadsl.0lx.net/pruebas/?page=sim_results

Issue is fixed if season is deleted.

Steps to reproduce:

1. Add a new season in admin menu--> add season (?page=season_add)
2. Go to ?page=sim_results

Avoid this step for web admins without knowledge:

What is the admin password?

You need to add a record to the user table. The password should be SHA1 hashed. This SQL statement will add the user admin with the password admin:

INSERT INTO user (name, passwd, active)

VALUES ('admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 1);

Set a default user password in database: admin/admin and encourage to web admin to change the password on url/PREM/?page=users

DONE:

• Add content blocks in front page, below of images carrousel (slider image).
  Left or right content column (size 1/3) with various blocks of content, for example positions of championship, sanctions, next events. The content blocks are selectable by admin.
  Other content column (size 2/3) with news order by date.
  File asociated: main.php updated in main branch
  sql table: main_news, columns: id, title, news, day.

• Get data from next two events/races

• Get data from seasons teams, drivers and points to standings block home page.

• Get data from last race to last race block.

• Make backend (administration side) to activate/deactivate blocks

• Comms viewer block (to show team speak viewer, mumble, etc.)

When you stay in show_rules.php and open admin nav bar if you go down with mouse menu its closed without reason.

Actually the number of 1st, 2nd, 3rd positions of show_drivers is inserted manually in database via "modify driver" page in admin menu.
http://sparkadsl.0lx.net/PREM/?page=show_drivers

Actually points range go from 1st at 15th, expand this range up 40th.

Add a GDPR Compliance to cookies.

https://cookieconsent.insites.com/documentation/javascript-api/

https://cookieconsent.insites.com/documentation/disabling-cookies/

Describe the bug
#1142 - CREATE VIEW command denied to user 'b17_xxxxxxxx'@'192.xxx.x.x' for table 'team_driver_top3'
No drivers page working:
MySQL Error: Table 'b17_xxxxxxxx_prem1.team_driver_top3' doesn't exist

To Reproduce
Create DB

Expected behavior
No errors

Screenshots

Cause
The error is due to the lack of hosting permissions, to create a view in mysql you need advanced administration permissions and normally these permissions are not accessible in free hostings.

Resolution
Find an alternative to create a table view
Issue #28
Fixes: #44
Commit: 4946582

Check tinymce files in master branch

1. function to check if file exists not is working:

if (file_exists($target_file))
{
echo "Sorry, file already exists.";
} 

1. Add code to delete (unlink) uploaded files and delete that database record asociated to file.
   Example here:
   http://sparkadsl.0lx.net/pruebas/?page=upload
   file upload.php

Code similar to:
$res=mysql_query("SELECT file FROM tbl_uploads WHERE id=".$_GET['remove_id']);
$row=mysql_fetch_array($res);
mysql_query("DELETE FROM tbl_uploads WHERE id=".$_GET['remove_id']);
unlink("uploads/".$row['file']);

Hello, I have another question and how can I center the Nav Bar on the Prem Tools page.

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/u275158832/public_html/main.php on line 5

When can't found blocks in the DB it'll throw that uncontrolled error.

Legend:

• = Currently present in PREM
  //////////////////////////////////////////////////////////////
  NetracingEurope.org Wrote in Assetto Corsa forum:

• 1. Every single driver should be linked to all his results to get a driver history. I think this isn't possible in PREM atm.

• 2. Same for Team achievements.

• 3. Flexible team members for every team allowing drivers to join and leave a team mid-season. ATM a big minus at PREM.

• 4. Flexible points system, actually i like how this is done in PREM.

• 5. A mask that allows to enter the results by hand if needed. Possible already in PREM.

• 6. Info about the Carmakes that have been used by the drivers at the races and at the Championship Table.

• 7. Info about the nationality of the drivers. If someone want to stay anonymous, give him the Albanian flag ;)

• 8. Schedule planning. Can be done by entering the races at the season without results.

• 9. A small area where the drivers can talk about the races pre- and afterwards, something like a miniblog for every race. This way a separate forum would be obsolete and PREM can be installed as a complete site.

• 10. An iframe where a teamspeak or mumble (prefered) channelviewer could find place.

• 11. A place where the possibility for donations can be placed.

• 12. The videos and img should be in a media listing beside the race result. Can be additionally to the way PREM do it atm.

• 13. Possibility for rulesets chained to Divisions. ATM there's only one ruleset possible at PREM.

• 14. Displaying qualify results as well.

• 15. Displaying fastest lap times per driver. Overall best lap can be colored (like sTracker do it).

• 16. Very important, sorry for the late listing: Possibility for Penalties (point-wise). This can be used for actual race penalties as well as for invalidating 1 or 2 races for every driver to remain a particular drivers chance for the championship in case of missing a race. Has to be done in combination with a comment field.

• 17. Allowing a free configureable amount of team members. From 1 up. Possibility to allowing only best 2 (or whatever count) drivers to score fore the team.

As minimum Prem must be support php 5.6 following this guide:

http://php.net/supported-versions.php

In the future, when project have all features finished will made a new branch with php 7 version.

Test this option.

Add a admin page to change points in DB, for example to

"enter a penalty for a driver (missed tracklimits, accidents or similar). If this would be possible, a text field to enter the reason for the modification is needed too".
http://manager.rackservice.org:50732/sessiondetails?sessionid=2539

This file apparently not have any function.
So that could have served?

Hello again, there is still a question.
Where can I change the font color for Username and Password when I click on Login admin? Is currently black on our tool and would like to know.
Tool Link: http://www.vvsr.de/auswertungen
Greeting armin

Add a simresult link next race result, same that replay link is showed in result page.

Import data from Stracker database sqlite file to PREM database.

?page=result_race&race=number is the result of specific race.

Add vertical menu to mobile

Allow the option to change team drivers during a season

All pilots must be in a team to work.

Hello. Maybe it is also possible to add the column season in the race calendar right in front of the race which automatically shows the season that will be driven on the track.
Greeting armin

Describe the bug
When loading a fresh copy of the database with no entries, this produces an error in the standings block. It is a PHP Notice but should not be there.

Notice: Undefined variable: standing_pages in /var/www/html/PREM-Podium-race-E-manager/blocks/standings.php on line 69

To Reproduce
Steps to reproduce the behavior:

1. Load fresh database
2. Enable PHP Errors
3. Navigate to main index.php page.
4. See error

Expected behavior
You should just see an empty block or a message stating no standings found.

Screenshots
https://www.screencast.com/t/xBTZz5dEUULB

Desktop (please complete the following information):

• OS: Linux
• Browser Firefox
• Version 60.3.0esr (64-bit)

Hello, where can I possibly for all sides the background [collor] or maybe even a picture change / insert?
Thank you in advance for your help!
greeting

Make a importer to .json file client, this is generated in documents/assettocorsa/out to get practice, qualify and race sesion.

Hello have found something else with us which is not to be seen in a background picture. If I want to delete a championship yes this is there:
"Division can not be deleted because it is related to the following season (s):"
• Seat Leon TRC
How do I get that in white instead of black as it is now.
In division_rem.php this says:
if (mysqli_num_rows ($ sresult)> 0) {
$ seasons = "";
while ($ s = mysqli_fetch_array ($ sresult)) {
$ seasons. = ".". $ s ['name']. "\ N";
}
show_error ("Division can not be deleted because it is related to the following season (s): \ n". $ seasons);
return;
Greeting Armin

Create a custom json result file to get tyre/tire type, pit entry, fast lap time, etc.

I saw that server log get data such as pilot entry pits, and other interesting info missed in json result file.

It's possible get divers data of interest during race to export to a custom json result race?
May be making a python app? Or already exists?

Serverside: You can write a Server-Plugin, where make your own JSON-File. You will find a c# example in your AC-Directory "..\sdk\dev\acRemoteServerUDP_Example".

or how you said: You can write a own python-App

http://www.assettocorsa.net/forum/index.php?threads/create-custom-json-results-its-possible.42527/#post-827896

Manuals:

ACPythonDocumentation(1).pdf
ACSharedMemoryDocumentation(1).pdf

This involve a php code to get & show this data in race results.