header

Collapse

Custom SQL to create events

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Go to Thank You vB-Info
    Senior Member

    ❤️
    • 12.2020
    • 211
    • 10
    • 1

    Font Size
    #1

    Custom SQL to create events

    Go to Thank You
    Generally, I have a lot of calendar entries of events and their location. Location is actually a set of GPS coordinates and all events are shown on a Google map.

    While, from year to year, the event dates change, the actual title of each event changes not too much.

    For instance:

    Year 2020: 18th annual event

    Year 2021: 19th annual event

    To maintail all events and their GPS coordinates, I have written a custom php page that shows all events in a table view with an active map on top. With this page, changing event data is fast and easy and much less effort than doing this via vBulletin calendar (I would have to click on each event, etc.)

    CRUD operations in vb4 were very simple. Now, with vb5 everything became more complex.



    Long story short:

    I know you do not support 3rd party plugins but how are events stored?

    Right now, I enter data into tables node, text, event, and closure.

    The respective events show up but have 1 minor flaw:

    On the frontend of my forum in column "Statistics", each newly created event shows: -1 responses

    Creating a reply to this event represents the post correctly and increases the responses counter by 1 to: 0 responses



    I have spent hours on this already but I cannot figue out what's wrong.

    Comparing the data of events created by vBulletin with events created by my scripts does NOT show any difference at all.



    Can you give me a hint please?

    Devami...Go to Top of Post
    Similar Threads
X

Thread Information

Collapse

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

    Those who read this thread

    Collapse

    Members who have read this thread: 0

      Related Topics

      Collapse

      Topics Statistics Last Post
      Started by vB-Info, 3 weeks ago
      0 responses
      5 views
      0 reactions
      Last Post vB-Info
      by vB-Info
      Started by vB-Info, 3 weeks ago
      0 responses
      6 views
      0 reactions
      Last Post vB-Info
      by vB-Info
      Started by vB-Info, 13.03.24, 20:42
      0 responses
      22 views
      0 reactions
      Last Post vB-Info
      by vB-Info
      Working...
      😀
      😂
      🥰
      😘
      🤢
      😎
      😞
      😡
      👍
      👎

      AdBlock Detected

      Please Disable Adblock

      Please consider supporting us by disabling the ad blocker.

      I've Disabled AdBlock
      Home