Val Town Code Search

vtProjectSearch2 import.ts2 matches

@charmaine•Updated 2 weeks ago

35          username: user.username,
36          bio: user.bio,
37          profile_image_url: user.profileImageUrl,
38          url: user.url,
39          updated_at: new Date().toISOString(), // Using current time as the API doesn't provide updated_at
53      name: project.name,
54      description: project.description,
55      image_url: project.imageUrl,
56      username: project.author.username || "",
57      updated_at: mainBranch?.updatedAt || new Date().toISOString(),

vtProjectSearch2 db.ts24 matches

@charmaine•Updated 2 weeks ago

101  fileCount: number;
102  url: string;
103  profile_image_url: string | null;
104  updated_at: string;
105}[]> {
110      COUNT(DISTINCT f.id) as file_count,
111      'https://val.town/u/' || p.username as url,
112      u.profile_image_url,
113      MAX(p.updated_at) as updated_at
114     FROM ${tablePrefix}_projects p
126    fileCount: Number(row.file_count),
127    url: String(row.url),
128    profile_image_url: row.profile_image_url ? String(row.profile_image_url) : null,
129    updated_at: String(row.updated_at)
130  }));
140  description: string | null;
141  url: string;
142  image_url: string | null;
143  updated_at: string;
144}[]> {
150      p.description,
151      p.url,
152      p.image_url,
153      p.updated_at
154     FROM ${tablePrefix}_projects p
166    description: row.description ? String(row.description) : null,
167    url: String(row.url),
168    image_url: row.image_url ? String(row.image_url) : null,
169    updated_at: String(row.updated_at)
170  }));
186    fileCount: number;
187    url: string;
188    profile_image_url: string | null;
189    updated_at: string;
190  }[];
195    description: string | null;
196    url: string;
197    image_url: string | null;
198    updated_at: string;
199  }[];
275      username TEXT,
276      bio TEXT,
277      profile_image_url TEXT,
278      url TEXT NOT NULL,
279      updated_at TIMESTAMP NOT NULL
289      forked_branch_id TEXT,
290      description TEXT,
291      image_url TEXT,
292      user_id TEXT,
293      FOREIGN KEY (user_id) REFERENCES ${tablePrefix}_users(id)
320  username: z.string().nullable(),
321  bio: z.string().nullable(),
322  profile_image_url: z.string().nullable(),
323  url: z.string(),
324  updated_at: z.string().datetime(),
331  username: z.string(),
332  description: z.string().nullable(),
333  image_url: z.string().nullable(),
334  forked_branch_id: z.string().nullable(),
335  updated_at: z.string().datetime(),
394    // Insert new user
395    await sqlite.execute(
396      `INSERT INTO ${tablePrefix}_users (id, username, bio, profile_image_url, url, updated_at)
397       VALUES (?, ?, ?, ?, ?, ?)`,
398      [
400        user.username,
401        user.bio,
402        user.profile_image_url,
403        user.url,
404        user.updated_at,
410    await sqlite.execute(
411      `UPDATE ${tablePrefix}_users
412       SET username = ?, bio = ?, profile_image_url = ?, url = ?, updated_at = ?
413       WHERE id = ?`,
414      [
415        user.username,
416        user.bio,
417        user.profile_image_url,
418        user.url,
419        user.updated_at,
461    // Insert new project
462    await sqlite.execute(
463      `INSERT INTO ${tablePrefix}_projects (id, url, name, username, updated_at, forked_branch_id, description, image_url, user_id)
464       VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,
465      [
471        project.forked_branch_id,
472        project.description,
473        project.image_url,
474        project.user_id
475      ],
480    await sqlite.execute(
481      `UPDATE ${tablePrefix}_projects
482       SET url = ?, name = ?, username = ?, updated_at = ?, forked_branch_id = ?, description = ?, image_url = ?, user_id = ?
483       WHERE id = ?`,
484      [
489        project.forked_branch_id,
490        project.description,
491        project.image_url,
492        project.user_id,
493        project.id
775
776  const result = await sqlite.execute(
777    `SELECT u.id, u.username, u.bio, u.profile_image_url, u.url, u.updated_at,
778      (SELECT COUNT(*) FROM ${tablePrefix}_projects p
779       WHERE p.user_id = u.id) as matchCount
790    username: z.string().nullable(),
791    bio: z.string().nullable(),
792    profile_image_url: z.string().nullable(),
793    url: z.string(),
794    updated_at: z.string().datetime(),
853    // Always launch the files query for the active type or for samples
854    const result = await sqlite.execute(
855      `SELECT f.*, p.name as project_name, p.url as project_url, p.username, p.description, p.image_url
856        FROM ${tablePrefix}_files f
857        JOIN ${tablePrefix}_projects p ON f.project_id = p.id
868      username: z.string(),
869      description: z.string().nullable(),
870      image_url: z.string().nullable(),
871    });
872

vtProjectSearch2 components.tsx15 matches

@charmaine•Updated 2 weeks ago

210      <div className="result-header">
211        <div className="result-header-content">
212          {result.image_url && (
213            <div className="project-image">
214              <img src={result.image_url} alt={result.project_name} />
215            </div>
216          )}
291      <div className="result-header">
292        <div className="result-header-content">
293          {result.image_url && (
294            <div className="project-image">
295              <img src={result.image_url} alt={result.name} />
296            </div>
297          )}
367      <div className="result-header">
368        <div className="user-header">
369          {result.profile_image_url && (
370            <div className="user-avatar">
371              <img src={result.profile_image_url} alt={result.username || 'User'} />
372            </div>
373          )}
1212                          <a href="?q=api" className="example-link">api</a>
1213                          <a href="?q=database" className="example-link">database</a>
1214                          <a href="?q=image" className="example-link">image</a>
1215                          <a href="?q=function" className="example-link">function</a>
1216                          <a href="?q=discord" className="example-link">discord</a>
1276                                <div className="contributor-header">
1277                                  <div className="contributor-avatar">
1278                                    {contributor.profile_image_url ? (
1279                                      <img src={contributor.profile_image_url} alt={contributor.username} />
1280                                    ) : (
1281                                      <div style={{
1318                                rel="noopener noreferrer"
1319                              >
1320                                <div className="project-image">
1321                                  {project.image_url ? (
1322                                    <img src={project.image_url} alt={project.name} />
1323                                  ) : (
1324                                    <div style={{
1357                      <a href="?q=api" className="example-link">api</a>
1358                      <a href="?q=database" className="example-link">database</a>
1359                      <a href="?q=image" className="example-link">image</a>
1360                      <a href="?q=function" className="example-link">function</a>
1361                      <a href="?q=discord" className="example-link">discord</a>

vtProjectSearch types.tsx5 matches

@charmaine•Updated 2 weeks ago

8  username: z.string(),
9  description: z.string().nullable(),
10  image_url: z.string().nullable(),
11  forked_branch_id: z.string().nullable(),
12  updated_at: z.string().datetime(),
36  username: string;
37  project_url: string;
38  image_url?: string | null;
39};
40
47  username: string | null;
48  bio: string | null;
49  profile_image_url: string | null;
50  url: string;
51  updated_at: string;
131  username: string;
132  url: string;
133  profile_image_url: string | null;
134  projectCount: number;
135};
139  username: string;
140  url: string;
141  image_url: string | null;
142  updated_at: string;
143};

vtProjectSearch styles.tsx4 matches

@charmaine•Updated 2 weeks ago

401}
402
403.project-card .project-image {
404  width: 24px;
405  height: 24px;
410}
411
412.project-image img {
413  width: 100%;
414  height: 100%;
511}
512
513.search-result .project-image {
514  width: 60px;
515  height: 60px;
520}
521
522.project-image img {
523  width: 100%;
524  height: 100%;

vtProjectSearch import.ts2 matches

@charmaine•Updated 2 weeks ago

35          username: user.username,
36          bio: user.bio,
37          profile_image_url: user.profileImageUrl,
38          url: user.url,
39          updated_at: new Date().toISOString(), // Using current time as the API doesn't provide updated_at
53      name: project.name,
54      description: project.description,
55      image_url: project.imageUrl,
56      username: project.author.username || "",
57      updated_at: mainBranch?.updatedAt || new Date().toISOString(),

vtProjectSearch db.ts24 matches

@charmaine•Updated 2 weeks ago

101  fileCount: number;
102  url: string;
103  profile_image_url: string | null;
104  updated_at: string;
105}[]> {
110      COUNT(DISTINCT f.id) as file_count,
111      'https://val.town/u/' || p.username as url,
112      u.profile_image_url,
113      MAX(p.updated_at) as updated_at
114     FROM ${tablePrefix}_projects p
126    fileCount: Number(row.file_count),
127    url: String(row.url),
128    profile_image_url: row.profile_image_url ? String(row.profile_image_url) : null,
129    updated_at: String(row.updated_at)
130  }));
140  description: string | null;
141  url: string;
142  image_url: string | null;
143  updated_at: string;
144}[]> {
150      p.description,
151      p.url,
152      p.image_url,
153      p.updated_at
154     FROM ${tablePrefix}_projects p
166    description: row.description ? String(row.description) : null,
167    url: String(row.url),
168    image_url: row.image_url ? String(row.image_url) : null,
169    updated_at: String(row.updated_at)
170  }));
186    fileCount: number;
187    url: string;
188    profile_image_url: string | null;
189    updated_at: string;
190  }[];
195    description: string | null;
196    url: string;
197    image_url: string | null;
198    updated_at: string;
199  }[];
275      username TEXT,
276      bio TEXT,
277      profile_image_url TEXT,
278      url TEXT NOT NULL,
279      updated_at TIMESTAMP NOT NULL
289      forked_branch_id TEXT,
290      description TEXT,
291      image_url TEXT,
292      user_id TEXT,
293      FOREIGN KEY (user_id) REFERENCES ${tablePrefix}_users(id)
320  username: z.string().nullable(),
321  bio: z.string().nullable(),
322  profile_image_url: z.string().nullable(),
323  url: z.string(),
324  updated_at: z.string().datetime(),
331  username: z.string(),
332  description: z.string().nullable(),
333  image_url: z.string().nullable(),
334  forked_branch_id: z.string().nullable(),
335  updated_at: z.string().datetime(),
394    // Insert new user
395    await sqlite.execute(
396      `INSERT INTO ${tablePrefix}_users (id, username, bio, profile_image_url, url, updated_at)
397       VALUES (?, ?, ?, ?, ?, ?)`,
398      [
400        user.username,
401        user.bio,
402        user.profile_image_url,
403        user.url,
404        user.updated_at,
410    await sqlite.execute(
411      `UPDATE ${tablePrefix}_users
412       SET username = ?, bio = ?, profile_image_url = ?, url = ?, updated_at = ?
413       WHERE id = ?`,
414      [
415        user.username,
416        user.bio,
417        user.profile_image_url,
418        user.url,
419        user.updated_at,
461    // Insert new project
462    await sqlite.execute(
463      `INSERT INTO ${tablePrefix}_projects (id, url, name, username, updated_at, forked_branch_id, description, image_url, user_id)
464       VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,
465      [
471        project.forked_branch_id,
472        project.description,
473        project.image_url,
474        project.user_id
475      ],
480    await sqlite.execute(
481      `UPDATE ${tablePrefix}_projects
482       SET url = ?, name = ?, username = ?, updated_at = ?, forked_branch_id = ?, description = ?, image_url = ?, user_id = ?
483       WHERE id = ?`,
484      [
489        project.forked_branch_id,
490        project.description,
491        project.image_url,
492        project.user_id,
493        project.id
775
776  const result = await sqlite.execute(
777    `SELECT u.id, u.username, u.bio, u.profile_image_url, u.url, u.updated_at,
778      (SELECT COUNT(*) FROM ${tablePrefix}_projects p
779       WHERE p.user_id = u.id) as matchCount
790    username: z.string().nullable(),
791    bio: z.string().nullable(),
792    profile_image_url: z.string().nullable(),
793    url: z.string(),
794    updated_at: z.string().datetime(),
853    // Always launch the files query for the active type or for samples
854    const result = await sqlite.execute(
855      `SELECT f.*, p.name as project_name, p.url as project_url, p.username, p.description, p.image_url
856        FROM ${tablePrefix}_files f
857        JOIN ${tablePrefix}_projects p ON f.project_id = p.id
868      username: z.string(),
869      description: z.string().nullable(),
870      image_url: z.string().nullable(),
871    });
872

vtProjectSearch components.tsx15 matches

@charmaine•Updated 2 weeks ago

210      <div className="result-header">
211        <div className="result-header-content">
212          {result.image_url && (
213            <div className="project-image">
214              <img src={result.image_url} alt={result.project_name} />
215            </div>
216          )}
291      <div className="result-header">
292        <div className="result-header-content">
293          {result.image_url && (
294            <div className="project-image">
295              <img src={result.image_url} alt={result.name} />
296            </div>
297          )}
367      <div className="result-header">
368        <div className="user-header">
369          {result.profile_image_url && (
370            <div className="user-avatar">
371              <img src={result.profile_image_url} alt={result.username || 'User'} />
372            </div>
373          )}
1212                          <a href="?q=api" className="example-link">api</a>
1213                          <a href="?q=database" className="example-link">database</a>
1214                          <a href="?q=image" className="example-link">image</a>
1215                          <a href="?q=function" className="example-link">function</a>
1216                          <a href="?q=discord" className="example-link">discord</a>
1276                                <div className="contributor-header">
1277                                  <div className="contributor-avatar">
1278                                    {contributor.profile_image_url ? (
1279                                      <img src={contributor.profile_image_url} alt={contributor.username} />
1280                                    ) : (
1281                                      <div style={{
1318                                rel="noopener noreferrer"
1319                              >
1320                                <div className="project-image">
1321                                  {project.image_url ? (
1322                                    <img src={project.image_url} alt={project.name} />
1323                                  ) : (
1324                                    <div style={{
1357                      <a href="?q=api" className="example-link">api</a>
1358                      <a href="?q=database" className="example-link">database</a>
1359                      <a href="?q=image" className="example-link">image</a>
1360                      <a href="?q=function" className="example-link">function</a>
1361                      <a href="?q=discord" className="example-link">discord</a>

vtProjectSearch types.tsx5 matches

@stevekrouse•Updated 2 weeks ago

8  username: z.string(),
9  description: z.string().nullable(),
10  image_url: z.string().nullable(),
11  forked_branch_id: z.string().nullable(),
12  updated_at: z.string().datetime(),
36  username: string;
37  project_url: string;
38  image_url?: string | null;
39};
40
47  username: string | null;
48  bio: string | null;
49  profile_image_url: string | null;
50  url: string;
51  updated_at: string;
131  username: string;
132  url: string;
133  profile_image_url: string | null;
134  projectCount: number;
135};
139  username: string;
140  url: string;
141  image_url: string | null;
142  updated_at: string;
143};

vtProjectSearch styles.tsx4 matches

@stevekrouse•Updated 2 weeks ago

401}
402
403.project-card .project-image {
404  width: 24px;
405  height: 24px;
410}
411
412.project-image img {
413  width: 100%;
414  height: 100%;
511}
512
513.search-result .project-image {
514  width: 60px;
515  height: 60px;
520}
521
522.project-image img {
523  width: 100%;
524  height: 100%;

« Previous

1...204 205 206 207 208 209 210...354

Projects

View all 33 projects

brainrot_image_gen1 file match

@dcm31•Updated 4 days ago

Generate images for Italian Brainrot characters using FAL AI

modifyImage2 file matches

@stevekrouse•Updated 4 days ago

Users

View all 1 users

@Atiq1 project

Updated 12 mins ago

"Focal Lens with Atig Wazir" "Welcome to my photography journey! I'm Atiq Wazir, a passionate photographer capturing life's beauty one frame at a time. Explore my gallery for stunning images, behind-the-scenes stories, and tips & tricks to enhance your own

Documentation

View all 7 documentation results

Val Town Code SearchReturn to Val Town

vtProjectSearch2import.ts2 matches

vtProjectSearch2db.ts24 matches

vtProjectSearch2components.tsx15 matches

vtProjectSearchtypes.tsx5 matches

vtProjectSearchstyles.tsx4 matches

vtProjectSearchimport.ts2 matches

vtProjectSearchdb.ts24 matches

vtProjectSearchcomponents.tsx15 matches

vtProjectSearchtypes.tsx5 matches

vtProjectSearchstyles.tsx4 matches

Projects

brainrot_image_gen1 file match

modifyImage2 file matches

Users

@Atiq1 project

Documentation

Val Town Code Search Return to Val Town

vtProjectSearch2 import.ts2 matches

vtProjectSearch2 db.ts24 matches

vtProjectSearch2 components.tsx15 matches

vtProjectSearch types.tsx5 matches

vtProjectSearch styles.tsx4 matches

vtProjectSearch import.ts2 matches

vtProjectSearch db.ts24 matches

vtProjectSearch components.tsx15 matches

vtProjectSearch types.tsx5 matches

vtProjectSearch styles.tsx4 matches