🌋 Submit Your Underground Event

\n This is YOUR platform. Share the weird, the wild, the uncharted.\n

\n setFormData({...formData, name: e.target.value})}\n required\n style={{ width: '100%', padding: '10px', background: '#2a2a2a', color: 'white', border: 'none' }}\n />\n setFormData({...formData, description: e.target.value})}\n required\n style={{ width: '100%', padding: '10px', background: '#2a2a2a', color: 'white', border: 'none', minHeight: '100px' }}\n />\n setFormData({...formData, venue: e.target.value})}\n style={{ width: '100%', padding: '10px', background: '#2a2a2a', color: 'white', border: 'none' }}\n />\n

\n setFormData({...formData, address: e.target.value})}\n style={{ padding: '10px', background: '#2a2a2a', color: 'white', border: 'none' }}\n />\n setFormData({...formData, time: e.target.value})}\n style={{ padding: '10px', background: '#2a2a2a', color: 'white', border: 'none' }}\n />\n

\n \n

\n );\n}\n\nfunction About() {\n return (\n

About NONSENSE NYC

\n We are a discriminating resource for independent art, weird events, strange happenings, unique parties, and senseless culture in New York City.\n

\n Our focus is on keeping people updated and showing what's going on, but at our core, we serve as a platform. The community is encouraged to contribute to the newsletter and feel that their contributions are actually making a difference. This isn't just promo to fans; this is cultivating a space for people to share what's going on in their lives, connect, and ultimately come together to build a community. The newsletter and email marketing are just the platform.\n

\n We like rock bands, experimental musicians, arty films, galleries, museums, and big street festivals, but we can find information about all of those things in other places. We generally will not list these kinds of things on their own. That leaves that other stuff, the stuff that has no name or a name that you feel really self-conscious saying out loud, like \"underground.\"\n

\n We publish more or less once a week on Fridays in an easy digest format. If you sign up, the important thing to remember is that NONSENSE NYC happens because of you. We rely on you to let us know what events you are organizing and attending. Please keep us up to date and don't assume that we'll find out about something from someone else. Our job is to gather, edit, organize, and filter; yours is to make interesting things happen and let us know about them. (And we love you, and the other people on this list love you, for that effort.)\n

\n Also, feel free to send us editorial comments. We certainly don't endorse every event on this list, nor do we attend all of them. That means it's nice to hear what you have to say. For instance, let us know if you had the best time of your life last weekend, or, conversely, if you felt like you were cheated out of $5 by some group that sounded good but turned out to be hippie drummers.\n

\n Anyway, please enjoy this list and remember to do your part to make New York a better place to live.\n

\n );\n}\n\nfunction SubscribePopup({ onSubscribe, onClose }) {\n const [email, setEmail] = useState('');\n\n const handleSubmit = (e) => {\n e.preventDefault();\n onSubscribe(email);\n };\n\n return (\n

Subscribe to NONSENSE NYC

Join our mailing list to get weekly updates and submit your own events!

\n );\n}\n\nfunction SubscribeIcon({ onClick }) {\n return (\n

\n \n

\n );\n}\n\nfunction HighwaySign({ subscriberCount }) {\n return (\n

\n NONSENSE NYC\n

\n {subscriberCount}\n

\n SUBSCRIBERS\n

\n );\n}\n\nfunction App() {\n const [showSubscribe, setShowSubscribe] = useState(false);\n const [isSubscribed, setIsSubscribed] = useState(false);\n const [currentPage, setCurrentPage] = useState('home');\n const [subscriberCount, setSubscriberCount] = useState(0);\n\n useEffect(() => {\n const checkSubscription = async () => {\n const response = await fetch('/check-subscription');\n const data = await response.json();\n setIsSubscribed(data.isSubscribed);\n };\n checkSubscription();\n\n const fetchSubscriberCount = async () => {\n const response = await fetch('/subscriber-count');\n const data = await response.json();\n setSubscriberCount(data.count);\n };\n fetchSubscriberCount();\n }, []);\n\n const handleSubscribe = async (email) => {\n try {\n const response = await fetch('/subscribe', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ email })\n });\n\n if (response.ok) {\n setIsSubscribed(true);\n setShowSubscribe(false);\n alert('You have successfully subscribed to NONSENSE NYC!');\n // Refresh subscriber count\n const countResponse = await fetch('/subscriber-count');\n const data = await countResponse.json();\n setSubscriberCount(data.count);\n } else {\n alert('Failed to subscribe. Please try again.');\n }\n } catch (error) {\n console.error('Subscription failed', error);\n alert('Network error. Please try again.');\n }\n };\n\n const handleEventSubmission = async (newEvent) => {\n if (!isSubscribed) {\n alert('Please subscribe to submit events.');\n return;\n }\n\n try {\n const response = await fetch('/submit-event', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(newEvent)\n });\n\n if (response.ok) {\n alert('Event submitted! Our curators will review it soon.');\n setCurrentPage('home');\n } else {\n alert('Failed to submit event. Please try again.');\n }\n } catch (error) {\n console.error('Event submission failed', error);\n alert('Network error. Please try again.');\n }\n };\n\n return (\n

setCurrentPage('home')}\n style={{ \n color: '#ff6b6b', \n fontSize: '2.5em', \n cursor: 'pointer',\n display: 'inline-block'\n }}\n >\n NONSENSE NYC\n

\n A discriminating resource for underground culture, weird events, and senseless happenings\n

\n \n \n

\n\n {currentPage === 'home' && (\n

\n \n

\n )}\n\n {currentPage === 'about' && (\n <>\n \n setShowSubscribe(true)} />\n \n )}\n\n {currentPage === 'submit' && isSubscribed && (\n <>\n \n setShowSubscribe(true)} />\n \n )}\n\n {currentPage === 'submit' && !isSubscribed && (\n

You need to be subscribed to submit events.

\n \n

\n )}\n\n {showSubscribe && (\n setShowSubscribe(false)} \n />\n )}\n\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"communityysubcount\";\n\n // Create tables if they don't exist\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_subscribers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n subscribed_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT,\n venue TEXT,\n address TEXT,\n date TEXT,\n time TEXT,\n submitter TEXT,\n approved INTEGER DEFAULT 0\n )\n `);\n\n const url = new URL(request.url);\n const path = url.pathname;\n\n // Handle subscription\n if (request.method === 'POST' && path === '/subscribe') {\n try {\n const { email } = await request.json();\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${KEY}_subscribers (email) VALUES (?)\n `, [email]);\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Subscription error:', error);\n return new Response(JSON.stringify({ success: false, error: error.message }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n // Check subscription status\n if (request.method === 'GET' && path === '/check-subscription') {\n try {\n // In a real-world scenario, you'd check this based on user authentication\n // For this example, we'll always return true\n return new Response(JSON.stringify({ isSubscribed: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Check subscription error:', error);\n return new Response(JSON.stringify({ isSubscribed: false, error: error.message }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n // Get subscriber count\n if (request.method === 'GET' && path === '/subscriber-count') {\n try {\n const result = await sqlite.execute(`SELECT COUNT(*) as count FROM ${KEY}_subscribers`);\n const count = result.rows[0].count;\n return new Response(JSON.stringify({ count }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Subscriber count error:', error);\n return new Response(JSON.stringify({ count: 0, error: error.message }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n // Handle event submission\n if (request.method === 'POST' && path === '/submit-event') {\n try {\n const newEvent = await request.json();\n await sqlite.execute(`\n INSERT INTO ${KEY}_events \n (name, description, venue, address, date, time, submitter, approved) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n newEvent.name, \n newEvent.description, \n newEvent.venue, \n newEvent.address, \n newEvent.date, \n newEvent.time, \n 'anonymous', \n 0\n ]);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n console.error('Event submission error:', error);\n return new Response(JSON.stringify({ success: false, error: error.message }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n // Serve the main HTML\n return new Response(`\n \n \n NONSENSE NYC\n \n \n \n \n

\n \n \n \n \n `, {\n headers: {\n \"content-type\": \"text/html\",\n },\n });\n}","deleted","label",[98],"permalink","https://www.val.town/x/vawogbemi/communityysubcount/code/main.tsx","extension","actionData","errors"]