sparrowsloan

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 15 total)
  • Forum: Fixing WordPress
    In reply to: [Multisite/Domain Mapping] posts get 404 error, permalink issue
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 1 month ago

    No fix for my issue available??

    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 1 month ago

    I’ve sent you my login details. My email is [email protected]. Have you been able to take a look at it yet? 🙂

    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 1 month ago

    I changed the name Platz to Rang because I used to have a field in the form that was called Platz. Now it shows a row without content and the racer are still in a random order…

    [cfdb-datatable style="width:100%;" class="myclass" form="Ergebnisliste" show="Rang,Name,Geschlecht,Alter,Bundesland,Etappe,Disziplin,Datum,Dauer" hide="diff" trans="diff=cfdb_date_diff(Startzeit,Zielzeit)&&Dauer=cfdb_duration(Startzeit,Zielzeit,%h Std. %i Min.)&&SortByField(diff)" unbuffered="true"]

    I’d be happy to give you access to my wpadmin via email if you want to take a closer look, since I have no idea why it isn’t working.

    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 1 month ago

    I hate to say this, but it is still not working. I think this is cursed… I removed the orderby clause. Now I have Platz 1 in the first row, but it is NOT the fastest racer. The racer who did in two hours is listed as number 2, the one who did 7 hours is still first place.

    [cfdb-datatable width="100%" class="myclass" form="Ergebnisliste" show="Platz,Name,Alter,Bundesland,Disziplin,Datum,Dauer" hide="diff" trans="diff=cfdb_date_diff(Startzeit,Zielzeit)&&Dauer=cfdb_duration(Startzeit,Zielzeit,%h Std. %i Min.)&&SortByField(diff)&&AddRowNumberField(Platz)" tfilter="Etappe=Etappe 2 „Loipenhaus-Etappe“ (Frauen)" unbuffered="true"]

    http://brockensprint.de/etappe-2-loipenhaus-etappe-frauen/

    It appears to be completely random. 5 hours is first place, 7 hours second and 2 hours 5th place 😀

    • This reply was modified 9 years, 1 month ago by sparrowsloan.
    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    This is frustrating…. you still can’t see the column? I can see it even when I am logged out.

    [cfdb-datatable style="width:100%;" class="myclass" form="Ergebnisliste" show="Reihenfolge,Name,Geschlecht,Alter,Bundesland,Etappe,Disziplin,Datum,Dauer" hide="diff" trans="diff=cfdb_date_diff(Startzeit,Zielzeit)&&Dauer=cfdb_duration(Startzeit,Zielzeit,%h Std. %i Min.)&&SortByField(diff)&&AddRowNumberField(Reihenfolge)" orderby="diff ASC" unbuffered="true"]

    This issue is also on a list with less entries displayed. It correctly shows the fastest racer in the first row, but displays it as #2.

    http://brockensprint.de/etappe-2-loipenhaus-etappe-frauen/

    Is there anything else we can try?

    Forum: Plugins
    In reply to: [Landing Page Builder - Free Landing Page Templates] How to remove landing page “post” from menu
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    Also another problem:

    The landing page is on http://abenteuerwald-thale.de
    But the title of the website is “fff” which is the name of my last post. Why is the title of the last post displayed as a title on the landing page?

    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    NOOO I think I cheered too soon. Tried it again with a new test user… now the user who should be the fastest with 2 hours is shown as “5th place” and someone who took 5 hours is first place. So the AddRowNumberField doesn’t work even though the first place should be shown in row #1 since the fastest duration should be in the first row. What do I need to change?

    http://brockensprint.de/ergebnisliste/

    [cfdb-datatable width="100%" class="myclass" form="Ergebnisliste" show="Rang,Name,Geschlecht,Alter,Bundesland,Etappe,Disziplin,Datum,Dauer" hide="diff" trans="diff=cfdb_date_diff(Startzeit,Zielzeit)&&Dauer=cfdb_duration(Startzeit,Zielzeit,%h Std. %i Min.)&&SortByField(diff)&&AddRowNumberField(Rang)" unbuffered="true" orderby="diff ASC"]

    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    Oh dear, I just solved it myself by renaming Platz to Rang and adding it to show=””
    It works perfectly now! So beautiful. Even though I can’t offer much, please don’t hestitate to let me know where I can donate a few euros to show my appreciation for the perfect support!

    Edit: NOOO I think I cheered too soon. Tried it again with a new test user… now the user who should be the fastest with 2 hours is shown as “5th place” and someone who took 5 hours is first place. What do I need to change?

    http://brockensprint.de/ergebnisliste/
    [cfdb-datatable width="100%" class="myclass" form="Ergebnisliste" show="Rang,Name,Geschlecht,Alter,Bundesland,Etappe,Disziplin,Datum,Dauer" hide="diff" trans="diff=cfdb_date_diff(Startzeit,Zielzeit)&&Dauer=cfdb_duration(Startzeit,Zielzeit,%h Std. %i Min.)&&SortByField(diff)&&AddRowNumberField(Rang)" unbuffered="true" orderby="diff ASC"]

    • This reply was modified 9 years, 2 months ago by sparrowsloan.
    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    Thanks again for helping me find a solution 🙂

    It was about the security settings. Even people who aren’t logged in can view the ranking now.

    I removed the “Platz” field in the database. Unfortunately adding &&SortByField(diff)&&AddRowNumberField(Platz) didn’t do anything.
    [cfdb-datatable class="myclass" form="Ergebnisliste" show="Name,Geschlecht,Alter,Bundesland,Etappe,Datum,Dauer" hide="diff" trans="diff=cfdb_date_diff(Startzeit,Zielzeit)&&Dauer=cfdb_duration(Startzeit,Zielzeit,%h Std. %i Min.)&&SortByField(diff)&&AddRowNumberField(Platz)" unbuffered="true" orderby="diff ASC"]
    as you can see here: http://brockensprint.de/ergebnisliste/

    I hope there is another way to display the ranking numbers? If I knew how to change the shortcode myself I wouldn’t be bothering you…

    The filter however is EXACTLY what I need! So simple, yet so effective. Thanks a lot!

    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    Michael, you are a hero! I just found the time to update the plugin and use your version- It works like a charm! Thank you, really, I appreciate the support and the effort you continue to put into this in order to make us user happy! However, I still have two ideas to make it work for my purpose even more 😀

    Now it looks like this:
    [cfdb-datatable class="myclass" form="Ergebnisliste" show="Platz,Name,Geschlecht,Alter,Bundesland,Etappe,Datum,Dauer" hide="diff" trans="diff=cfdb_date_diff(Startzeit,Zielzeit)&&Dauer=cfdb_duration(Startzeit,Zielzeit,%h Std. %i Min.)" unbuffered="true" orderby="diff ASC"]

    http://brockensprint.de/ergebnisliste/ (no clue why people who arent logged into the WP admin cant access it)

    It displays the Dauer (difference between start and end time). Is it possible to have the field Platz (“Ranking”) that the shortest duration (e.g the facest racer) is rank1, then rank2 and so on? Or do I always have to edit this ranking manually?

    And to my other question:
    This list I have right now is perfect to display all the participants of ALL races together and who was the fastest of all the categories. But since I have different categories like walking, mountain biking and so on I want to display a ranking list for each category seperately.
    For example “ranking walking” that only shows all entries that contain “walking” in the field “Etappe” (race) or “female” in the field “Geschlecht” (gender). Is this possible with this plugin?

    • This reply was modified 9 years, 2 months ago by sparrowsloan.
    • This reply was modified 9 years, 2 months ago by sparrowsloan.
    • This reply was modified 9 years, 2 months ago by sparrowsloan.
    Forum: Fixing WordPress
    In reply to: complicated SITE URL / wp-admin login redirect problem
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    Because it is my hosting 🙂 What exactly is cPanel and what does it do? Do I really need that? Because I work with Parallels Confixx

    I thought I only need to find a solution/fix for the login problem other than using the subdirectory url…

    • This reply was modified 9 years, 2 months ago by sparrowsloan.
    • This reply was modified 9 years, 2 months ago by sparrowsloan.
    Forum: Fixing WordPress
    In reply to: Multiple wordpress sites, site in subdirectory not working
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    Omg, what an easy fix. I just googled “recreating permalinks” and it worked.
    http://colibri-interactive.com/how-to-recreate-permalinks/

    You saved my day thanks sinip!

    Forum: Fixing WordPress
    In reply to: Multiple wordpress sites, site in subdirectory not working
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    What do you mean by recreating permalinks? I can fully accesss the SPOTLIGHT dashboard wp-admin and create new posts/pages and so on. It always shows the permalink that should work, but it just shows the error that the url doesnt exist.

    A friend suggested that this problem is due to the fact that all the pages in the SPOTLIGHT directory are redirected wrongly, but why is my wp-admin working regardless, even though it’s also in the SPOTLIGHT directory?

    The issue is the wordpress of my friend thats in the root directory I think. I will wait until my domain julia-fuge.de is available again and if the error still occurs if I am using the domain to access the other wordpress instead of through the directory.

    As you can tell, I am not an expert at all

    Forum: Fixing WordPress
    In reply to: Multiple wordpress sites, site in subdirectory not working
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 2 months ago

    The root directory contains a .htaccess :

    RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]

# add a trailing slash to /wp-admin
RewriteRule ^wp-admin$ wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^(wp-(content|admin|includes).*) $1 [L]
RewriteRule ^(.*\.php)$ $1 [L]
RewriteRule . index.php [L]

    if I rename it, it still doesnt work, simply shows “not found” but without the template of the other wordpress

    Forum: Plugins
    In reply to: [Contact Form DB] DB ranking by calculating difference of 2 number columns
    Thread Starter sparrowsloan

    (@sparrowsloan)

    9 years, 5 months ago

    I cant thank you enough, this already helps a lot!

    Now it looks like this:

    Unfortunately it only says how much hours are between those two times, but not how many minutes. How can I change that “human time diff” demand so it shows “2 hours and 2 minutes” for example?

    User 6666 took 5 hours and 40 minutes, the list shows 6 hours though.
    The problem is, if I have two users who both took 5 hours and user2 was two minutes faster, they are both listed with “5 hours” which doesn’t help because they would both be sharing the same ranking even if user1 was 2 minutes faster.

    The code is [cfdb-datatable form="Ergebnisliste" hide="Submitted,Email,Geschlecht,Geburtsdatum,Anschrift,PLZ,Land,Bundesland,Etappe,Disziplin,Startzeit,Platz,Zielzeit,Submitted Login,Submitted From" trans="Startzeit=strtotime(Startzeit)&&Zielzeit=strtotime(Zielzeit)&&Dauer=human_time_diff(Startzeit,Zielzeit)&&NaturalSortByField(Dauer)"]

    Also I’d like to know whether its possible to split the ranking into single rankings for the different disciplins.
    For example I have a race. People can contest via bike and by walking. I submit all the people contesting in one database but want different tables for biking and walking. How can I only show the data that contains “bike” in the database entry “Disziplin” so the table won’t show the user who contested with “walking” or “skateboard” for example?

    I am so grateful that you take the time to answer “stupid” questions like mine. 😀 I’d happy to donate a few euros. or if I can figure this out by myself I’d be happy if you can link me some websites where I can learn more about it.

    Happy holidays, by the way! 🙂

    • This reply was modified 9 years, 5 months ago by sparrowsloan.
    • This reply was modified 9 years, 5 months ago by sparrowsloan.
    • This reply was modified 9 years, 5 months ago by sparrowsloan. Reason: forgot my manners *lol* - happy holidays!
    • This reply was modified 9 years, 5 months ago by sparrowsloan.
Viewing 15 replies - 1 through 15 (of 15 total)