[verplaatst] install script

desert spider · Bericht door **desert spider** » 21 mei 2004, 13:23

hallo ik heb een nieuwe mod gedownload
meestal als je hem op je site wil zetten moet je een sql aan maken
hier voor zit er meestal een install script bij maar bij black jack niet en omdat ik niet bij phpmyadmin kan kan ik dit onder staan de script niet erop zetten dus mijn vraag is ,willen jullie zoon instal sript maken voor mij

alvast bedankt
desert spider

Code: Selecteer alles

#
# Table structure for table `phpbb_blackjack_cards`
#

CREATE TABLE `phpbb_blackjack_cards` (
  `number` int(2) NOT NULL default '0',
  `value` text NOT NULL
) TYPE=MyISAM;

#
# Dumping data for table `phpbb_blackjack_cards`
#

INSERT INTO `phpbb_blackjack_cards` VALUES (1, 'Two Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (2, 'Three Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (3, 'Four Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (4, 'Five Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (5, 'Six Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (6, 'Seven Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (7, 'Eight Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (8, 'Nine Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (9, 'Ten Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (10, 'Jack Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (11, 'Queen Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (12, 'King Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (13, 'Ace Of Clubs');
INSERT INTO `phpbb_blackjack_cards` VALUES (14, 'Two Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (15, 'Three Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (16, 'Four Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (17, 'Five Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (18, 'Six Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (19, 'Seven Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (20, 'Eight Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (21, 'Nine Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (22, 'Ten Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (23, 'Jack Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (24, 'Queen Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (25, 'King Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (26, 'Ace Of Diamonds');
INSERT INTO `phpbb_blackjack_cards` VALUES (27, 'Two Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (28, 'Three Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (29, 'Four Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (30, 'Five Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (31, 'Six Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (32, 'Seven Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (33, 'Eight Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (34, 'Nine Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (35, 'Ten Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (36, 'Jack Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (37, 'Queen Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (38, 'King Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (39, 'Ace Of Hearts');
INSERT INTO `phpbb_blackjack_cards` VALUES (40, 'Two Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (41, 'Three Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (42, 'Four Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (43, 'Five Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (44, 'Six Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (45, 'Seven Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (46, 'Eight Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (47, 'Nine Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (48, 'Ten Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (49, 'Jack Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (50, 'Queen Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (51, 'King Of Spades');
INSERT INTO `phpbb_blackjack_cards` VALUES (52, 'Ace Of Spades');

# --------------------------------------------------------

#
# Table structure for table `phpbb_blackjack_info`
#

CREATE TABLE `phpbb_blackjack_info` (
  `given` int(20) NOT NULL default '0',
  `taken` int(20) NOT NULL default '0',
  `wins` int(20) NOT NULL default '0',
  `losses` int(20) NOT NULL default '0',
  `ties` int(20) NOT NULL default '0',
  `re_dealt` int(20) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table `phpbb_blackjack_info`
#

INSERT INTO `phpbb_blackjack_info` VALUES (0, 0, 0, 0, 0, 0);

ik wit niet echt waar dit moest dus ik hoop dat die hier goed staat :thumb:

Verplaatst door podium4

Luuk · Bericht door **Luuk** » 21 mei 2004, 13:41

hopelijk werkt dit: je moet een .php bestand aanmaken in de rootmap met dit erin:

Code: Selecteer alles

<?php 
define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx); 
define('SITE_HISTORY_TABLE', $table_prefix.'site_history'); 

$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 

if ( $userdata['user_level'] != ADMIN ) 
{ 
   message_die(GENERAL_ERROR, "You are not authorised"); 
} 
else 
{ 
   $sql=array( 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (1, 'Two Of Clubs')";
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (2, 'Three Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (3, 'Four Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (4, 'Five Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (5, 'Six Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (6, 'Seven Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (7, 'Eight Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (8, 'Nine Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (9, 'Ten Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (10, 'Jack Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (11, 'Queen Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (12, 'King Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (13, 'Ace Of Clubs')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (14, 'Two Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (15, 'Three Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (16, 'Four Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (17, 'Five Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (18, 'Six Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (19, 'Seven Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (20, 'Eight Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (21, 'Nine Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (22, 'Ten Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (23, 'Jack Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (24, 'Queen Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (25, 'King Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (26, 'Ace Of Diamonds')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (27, 'Two Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (28, 'Three Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (29, 'Four Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (30, 'Five Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (31, 'Six Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (32, 'Seven Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (33, 'Eight Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (34, 'Nine Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (35, 'Ten Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (36, 'Jack Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (37, 'Queen Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (38, 'King Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (39, 'Ace Of Hearts')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (40, 'Two Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (41, 'Three Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (42, 'Four Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (43, 'Five Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (44, 'Six Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (45, 'Seven Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (46, 'Eight Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (47, 'Nine Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (48, 'Ten Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (49, 'Jack Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (50, 'Queen Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (51, 'King Of Spades')"; 
"INSERT INTO ".$table_prefix."blackjack_cards VALUES (52, 'Ace Of Spades')"; 

"INSERT INTO ".$table_prefix."blackjack_info VALUES (0, 0, 0, 0, 0, 0)"; 
   ); 

   $n=0; 
   $message='</span></td><td align="left"><span class="gen"><b>Install results:</b><br/><br/>'; 
   while($sql[$n]) 
   { 
      $message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br/>' : ''; 
      if(!$result = $db->sql_query($sql[$n])) 
         $message .= '<b><font color=#FF0000>[failed]</font></b><font size="1"> line: '.($n+1).' , '.$sql[$n].'</font><br />'; 
      else $message .='<b><font color=#0000fF>[done]</font></b><font size="1"> line: '.($n+1).' , '.$sql[$n].'</font><br />'; 
      $n++; 
   } 

   message_die(GENERAL_MESSAGE, $message); 
} 
?>

desert spider · Bericht door **desert spider** » 21 mei 2004, 14:03

ik krijg dit

Code: Selecteer alles

Install results:

[done] line: 1 , CREATE TABLE phpbb_blackjack_info ( given int(20) NOT NULL default 0, taken int(20) NOT NULL default 0, wins int(20) NOT NULL default 0, losses int(20) NOT NULL default 0, ties int(20) NOT NULL default 0, re_dealt int(20) NOT NULL default 0, )
[done] line: 2 , CREATE TABLE phpbb_blackjack_cards ( number int(2) NOT NULL default 0, value text NOT NULL, )
[failed] line: 3 , INSERT INTO table_prefixblackjack_cards VALUES (1, 'Two Of Clubs')
[failed] line: 4 , INSERT INTO table_prefixblackjack_cards VALUES (2, 'Three Of Clubs')
[failed] line: 5 , INSERT INTO table_prefixblackjack_cards VALUES (3, 'Four Of Clubs')
[failed] line: 6 , INSERT INTO table_prefixblackjack_cards VALUES (4, 'Five Of Clubs')
[failed] line: 7 , INSERT INTO table_prefixblackjack_cards VALUES (5, 'Six Of Clubs')
[failed] line: 8 , INSERT INTO table_prefixblackjack_cards VALUES (6, 'Seven Of Clubs')
[failed] line: 9 , INSERT INTO table_prefixblackjack_cards VALUES (7, 'Eight Of Clubs')
[failed] line: 10 , INSERT INTO table_prefixblackjack_cards VALUES (8, 'Nine Of Clubs')
[failed] line: 11 , INSERT INTO table_prefixblackjack_cards VALUES (9, 'Ten Of Clubs')
[failed] line: 12 , INSERT INTO table_prefixblackjack_cards VALUES (10, 'Jack Of Clubs')
[failed] line: 13 , INSERT INTO table_prefixblackjack_cards VALUES (11, 'Queen Of Clubs')
[failed] line: 14 , INSERT INTO table_prefixblackjack_cards VALUES (12, 'King Of Clubs')
[failed] line: 15 , INSERT INTO table_prefixblackjack_cards VALUES (13, 'Ace Of Clubs')
[failed] line: 16 , INSERT INTO table_prefixblackjack_cards VALUES (14, 'Two Of Diamonds')
[failed] line: 17 , INSERT INTO table_prefixblackjack_cards VALUES (15, 'Three Of Diamonds')
[failed] line: 18 , INSERT INTO table_prefixblackjack_cards VALUES (16, 'Four Of Diamonds')
[failed] line: 19 , INSERT INTO table_prefixblackjack_cards VALUES (17, 'Five Of Diamonds')
[failed] line: 20 , INSERT INTO table_prefixblackjack_cards VALUES (18, 'Six Of Diamonds')
[failed] line: 21 , INSERT INTO table_prefixblackjack_cards VALUES (19, 'Seven Of Diamonds')
[failed] line: 22 , INSERT INTO table_prefixblackjack_cards VALUES (20, 'Eight Of Diamonds')
[failed] line: 23 , INSERT INTO table_prefixblackjack_cards VALUES (21, 'Nine Of Diamonds')
[failed] line: 24 , INSERT INTO table_prefixblackjack_cards VALUES (22, 'Ten Of Diamonds')
[failed] line: 25 , INSERT INTO table_prefixblackjack_cards VALUES (23, 'Jack Of Diamonds')
[failed] line: 26 , INSERT INTO table_prefixblackjack_cards VALUES (24, 'Queen Of Diamonds')
[failed] line: 27 , INSERT INTO table_prefixblackjack_cards VALUES (25, 'King Of Diamonds')
[failed] line: 28 , INSERT INTO table_prefixblackjack_cards VALUES (26, 'Ace Of Diamonds')
[failed] line: 29 , INSERT INTO table_prefixblackjack_cards VALUES (27, 'Two Of Hearts')
[failed] line: 30 , INSERT INTO table_prefixblackjack_cards VALUES (28, 'Three Of Hearts')
[failed] line: 31 , INSERT INTO table_prefixblackjack_cards VALUES (29, 'Four Of Hearts')
[failed] line: 32 , INSERT INTO table_prefixblackjack_cards VALUES (30, 'Five Of Hearts')
[failed] line: 33 , INSERT INTO table_prefixblackjack_cards VALUES (31, 'Six Of Hearts')
[failed] line: 34 , INSERT INTO table_prefixblackjack_cards VALUES (32, 'Seven Of Hearts')
[failed] line: 35 , INSERT INTO table_prefixblackjack_cards VALUES (33, 'Eight Of Hearts')
[failed] line: 36 , INSERT INTO table_prefixblackjack_cards VALUES (34, 'Nine Of Hearts')
[failed] line: 37 , INSERT INTO table_prefixblackjack_cards VALUES (35, 'Ten Of Hearts')
[failed] line: 38 , INSERT INTO table_prefixblackjack_cards VALUES (36, 'Jack Of Hearts')
[failed] line: 39 , INSERT INTO table_prefixblackjack_cards VALUES (37, 'Queen Of Hearts')
[failed] line: 40 , INSERT INTO table_prefixblackjack_cards VALUES (38, 'King Of Hearts')
[failed] line: 41 , INSERT INTO table_prefixblackjack_cards VALUES (39, 'Ace Of Hearts')
[failed] line: 42 , INSERT INTO table_prefixblackjack_cards VALUES (40, 'Two Of Spades')
[failed] line: 43 , INSERT INTO table_prefixblackjack_cards VALUES (41, 'Three Of Spades')
[failed] line: 44 , INSERT INTO table_prefixblackjack_cards VALUES (42, 'Four Of Spades')
[failed] line: 45 , INSERT INTO table_prefixblackjack_cards VALUES (43, 'Five Of Spades')
[failed] line: 46 , INSERT INTO table_prefixblackjack_cards VALUES (44, 'Six Of Spades')
[failed] line: 47 , INSERT INTO table_prefixblackjack_cards VALUES (45, 'Seven Of Spades')
[failed] line: 48 , INSERT INTO table_prefixblackjack_cards VALUES (46, 'Eight Of Spades')
[failed] line: 49 , INSERT INTO table_prefixblackjack_cards VALUES (47, 'Nine Of Spades')
[failed] line: 50 , INSERT INTO table_prefixblackjack_cards VALUES (48, 'Ten Of Spades')
[failed] line: 51 , INSERT INTO table_prefixblackjack_cards VALUES (49, 'Jack Of Spades')
[failed] line: 52 , INSERT INTO table_prefixblackjack_cards VALUES (50, 'Queen Of Spades')
[failed] line: 53 , INSERT INTO table_prefixblackjack_cards VALUES (51, 'King Of Spades')
[failed] line: 54 , INSERT INTO table_prefixblackjack_cards VALUES (52, 'Ace Of Spades')
[failed] line: 55 , INSERT INTO table_prefixblackjack_info VALUES (0, 0, 0, 0, 0, 0)

Luuk · Bericht door **Luuk** » 21 mei 2004, 14:10

heb het bovenstaande veranderd ($ vergeten)

desert spider · Bericht door **desert spider** » 21 mei 2004, 14:14

nu is alles failed het is dus het zelfte gebleefen want de bovenste 2 waren al geupload

desert spider · Bericht door **desert spider** » 21 mei 2004, 15:11

ben je daar
weer niemand het?

Luuk · Bericht door **Luuk** » 21 mei 2004, 16:10

another try ^^

desert spider · Bericht door **desert spider** » 21 mei 2004, 16:18

luuk schreef: another try ^^

hu?
kan je niet volgen

Luuk · Bericht door **Luuk** » 21 mei 2004, 16:19

ik verander me 1e post steeds (waar de code in staat) om de lengte van het topic klein te houden

desert spider · Bericht door **desert spider** » 21 mei 2004, 16:21

Luuk · Bericht door **Luuk** » 21 mei 2004, 16:24

is dat "het is gelukt"

desert spider · Bericht door **desert spider** » 21 mei 2004, 17:04

niet echt

Code: Selecteer alles

Parse error: parse error, unexpected ';', expecting ')' in /home/owns/public_html/hwfactory/forum/install.php on line 19

http://www.owns.nl/hwfactory/forum/install.php

desert spider · Bericht door **desert spider** » 21 mei 2004, 19:52

weet niemand dit

Podium4 · Bericht door **Podium4** » 21 mei 2004, 21:24

Code: Selecteer alles

<?php
/***************************************************************************
 *                               db_update.php
 *                            -------------------
 *
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'Je hebt geen toestemming om deze pagina te bekijken');
}


$page_title = 'Bijwerken van de Dbase';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Bijwerken van de Dbase</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "CREATE TABLE `" . $table_prefix . "blackjack_cards` ( 
  `number` int(2) NOT NULL default '0', 
  `value` text NOT NULL 
) TYPE=MyISAM";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (1, 'Two Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (2, 'Three Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (3, 'Four Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (4, 'Five Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (5, 'Six Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (6, 'Seven Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (7, 'Eight Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (8, 'Nine Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (9, 'Ten Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (10, 'Jack Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (11, 'Queen Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (12, 'King Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (13, 'Ace Of Clubs')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (14, 'Two Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (15, 'Three Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (16, 'Four Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (17, 'Five Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (18, 'Six Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (19, 'Seven Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (20, 'Eight Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (21, 'Nine Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (22, 'Ten Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (23, 'Jack Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (24, 'Queen Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (25, 'King Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (26, 'Ace Of Diamonds')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (27, 'Two Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (28, 'Three Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (29, 'Four Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (30, 'Five Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (31, 'Six Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (32, 'Seven Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (33, 'Eight Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (34, 'Nine Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (35, 'Ten Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (36, 'Jack Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (37, 'Queen Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (38, 'King Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (39, 'Ace Of Hearts')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (40, 'Two Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (41, 'Three Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (42, 'Four Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (43, 'Five Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (44, 'Six Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (45, 'Seven Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (46, 'Eight Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (47, 'Nine Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (48, 'Ten Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (49, 'Jack Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (50, 'Queen Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (51, 'King Of Spades')";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_cards` VALUES (52, 'Ace Of Spades')";
$sql[] = "CREATE TABLE `" . $table_prefix . "blackjack_info` ( 
  `given` int(20) NOT NULL default '0', 
  `taken` int(20) NOT NULL default '0', 
  `wins` int(20) NOT NULL default '0', 
  `losses` int(20) NOT NULL default '0', 
  `ties` int(20) NOT NULL default '0', 
  `re_dealt` int(20) NOT NULL default '0' 
) TYPE=MyISAM";
$sql[] = "INSERT INTO `" . $table_prefix . "blackjack_info` VALUES (0, 0, 0, 0, 0, 0)";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		$error = $db->sql_error();

		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Fout:</b></font> ' . $error['message'] . '</li><br />';
	}
	else
	{
		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Succesvol:</b></font></li><br />';
	}
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';

echo '<tr><th>Einde</th></tr><tr><td><span class="genmed">Installatie is klaar nu. zorg ervoor dat je deze file gelijk verwijderd.<br />Als je fouten hebt gekregen, bezoek dan de site <a href="http://www.phpbb2-users.nl" target="_phpbb2_users">phpBB2 Users support forums</a> en vraag daar voor hulp.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Een prettige dag verder</a></span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>

Bron: http://www.nlwebhebbies.nl/db_generator.php

desert spider · Bericht door **desert spider** » 21 mei 2004, 21:57

bedankt het werkt
en nog wat ik heb vaker van dit soort probleemen waar kan ik deze db_generator.php dowloaden

Podium4 · Bericht door **Podium4** » 21 mei 2004, 22:02

Downloaden: http://sourceforge.net/projects/dbgenerator
Gebruiken: http://www.nlwebhebbies.nl/db_generator.php