vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database Query / Creating Tables (https://vborg.vbsupport.ru/showthread.php?t=280653)

Fluke667 03-26-2012 02:06 AM
Database Query / Creating Tables
 
i just made this:

https://vborg.vbsupport.ru/showthread.php?t=117724


Can any1 Help me with the Table & Colums needs to be created?

BirdOPrey5 03-26-2012 10:08 AM
That code doesn't even look like it works... I don't even know what it's supposed to do... :confused:

That said all we know about the table is from here:
Code:
INSERT INTO vb_linklist 
                      (name,link,kategorie)
So you need to create a table called "linklist" with at least the fields name, link, and kategorie (which I now realize was supposed to be "category.")

I assume it should have some type of unique index as well even though it is not used in the code.

If you're going to create the queury in PHP (such as mod install code) you need to account for the table prefix, if you're just creating it yourself in phpmyadmin just fill it in yourself.

In PHP use this query:

PHP Code:
$db->query_write("CREATE  TABLE IF NOT EXISTS `". TABLE_PREFIX ."linklist`  (  `id` int( 11  )  NOT  NULL  auto_increment ,
 `name` varchar( 255  )  NOT  NULL ,
 `link` varchar( 2000  )  NOT  NULL ,
 `kategorie` text NOT  NULL ,
 PRIMARY  KEY (  `id`  )  )  "); 

If doing your own direct query-

Code:
CREATE  TABLE  `linklist` (  `id` int( 11  )  NOT  NULL  auto_increment ,
 `name` varchar( 255  )  NOT  NULL ,
 `link` varchar( 2000  )  NOT  NULL ,
 `kategorie` text NOT  NULL ,
 PRIMARY  KEY (  `id`  )  ) ;
change "linklist" to accommodate any table prefix you use.


All times are GMT. The time now is 12:30 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02995 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete