phpBB.sk

Skočiť na obsah

Stiahnutie phpbb+SK

Pomoc pri SQL zadávania príkazu do DB

Podpora pre phpBB 2, nie podpora pre modifikácie, tú nájdete o kúsok nižšie

Moderátor: Moderátori

Písať komentáre

Pomoc pri SQL zadávania príkazu do DB

Poslaťod Momo » Sob Máj 19, 2007 2:09 pm

Potreboval by som z tohoto vytiahnuť to, čo musím zadať do SQL príkazu v PHPMYADMIN

(nejde mi nainštalovať tabuľky so DB cez tento súbor, vypisuje že sa nemôže pripojiť do DB, tak to chcem spraviť ručne)

[php]<?php
/***************************************************************************
* casino_install.php
* -------------------
* Version : 1.0
***************************************************************************/


define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/constants.'.$phpEx);
include($phpbb_root_path . 'includes/db.'.$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=casino_install.$phpEx", true));
exit;
}

if( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

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

$current_time = time();

$sql = array();
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_playprice', '2')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_aceofclubs', '15')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_aceofdiamonds', '20')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_aceofhearts', '25')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_aceofspades', '30')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_onoff', 'on')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_minorprize', '5')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_given', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_taken', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('chance_played', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_playprice', '2')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_apple', '15')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_banana', '20')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_orange', '25')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_starfruit', '30')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_onoff', 'on')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_minorprize', '5')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_given', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_taken', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('slot_played', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_enable', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_maxbet', '')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_windouble', '')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_wintriple', '')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_winperfect', '')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_bonussmall', '')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_bonusbig', '')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_played', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_taken', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) values ('luckydice_given', '0')";

$sql[] = "CREATE TABLE " . $table_prefix . "blackjack_refresh (
player int(10) NOT NULL default '0',
card1 int(3) NOT NULL default '0',
card2 text NOT NULL,
card3 int(3) NOT NULL default '0',
card4 text NOT NULL
) TYPE=MyISAM";

$sql[] = "CREATE TABLE " . $table_prefix . "keno_game (
played int(20) NOT NULL default '0',
points_given int(20) NOT NULL default '0',
points_taken int(20) NOT NULL default '0'
) TYPE=MyISAM";

$sql[] = "INSERT INTO " . $table_prefix . "keno_game (played, points_given, points_taken) VALUES ('0', '0', '0')";

$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 (number, value) VALUES ('1', 'Two Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('2', 'Three Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('3', 'Four Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('4', 'Five Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('5', 'Six Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('6', 'Seven Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('7', 'Eight Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('8', 'Nine Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('9', 'Ten Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('10', 'Jack Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('11', 'Queen Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('12', 'King Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('13', 'Ace Of Clubs')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('14', 'Two Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('15', 'Three Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('16', 'Four Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('17', 'Five Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('18', 'Six Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('19', 'Seven Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('20', 'Eight Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('21', 'Nine Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('22', 'Ten Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('23', 'Jack Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('24', 'Queen Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('25', 'King Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('26', 'Ace Of Diamonds')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('27', 'Two Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('28', 'Three Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('29', 'Four Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('30', 'Five Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('31', 'Six Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('32', 'Seven Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('33', 'Eight Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('34', 'Nine Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('35', 'Ten Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('36', 'Jack Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('37', 'Queen Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('38', 'King Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('39', 'Ace Of Hearts')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('40', 'Two Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('41', 'Three Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('42', 'Four Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('43', 'Five Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('44', 'Six Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('45', 'Seven Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('46', 'Eight Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('47', 'Nine Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('48', 'Ten Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('49', 'Jack Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('50', 'Queen Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('51', 'King Of Spades')";
$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) 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 (given, taken, wins, losses, ties, re_dealt) 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>Error:</b></font> ' . $error['message'] . '</li><br />';
}
else
{
echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfully updated database</b></font></li><br />';
}
}


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

echo '<tr><th>End</th></tr><tr><td><span class="genmed">The upgrade has completed. Please be sure to delete this file.<br />If you have run into any errors, please visit the <a href="http://www.truthofwar.com/community" target="_phpbbsupport">ToW</a> and ask someone for help.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Enjoy!</a></span></td></table>';

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

?>[/php]

Dúfam že ste ma pochopili :?
Obrázok
Obrázok
Obrázok užívateľa
Momo
Profesionál
Profesionál
 
Príspevky: 303
Registrovaný: Uto Mar 06, 2007 1:46 am
Hore

Poslaťod masterdead » Sob Máj 19, 2007 4:19 pm

CREATE TABLE prefix_blackjack_refresh (
player int(10) NOT NULL default '0',
card1 int(3) NOT NULL default '0',
card2 text NOT NULL,
card3 int(3) NOT NULL default '0',
card4 text NOT NULL
) TYPE=MyISAM

CREATE TABLE prefix_keno_game (
played int(20) NOT NULL default '0',
points_given int(20) NOT NULL default '0',
points_taken int(20) NOT NULL default '0'
) TYPE=MyISAM

INSERT INTO prefix_config (config_name, config_value) values ('chance_playprice', '2')
INSERT INTO prefix_config (config_name, config_value) values ('chance_aceofclubs', '15')
INSERT INTO prefix_config (config_name, config_value) values ('chance_aceofdiamonds', '20')
INSERT INTO prefix_config (config_name, config_value) values ('chance_aceofhearts', '25')
INSERT INTO prefix_config (config_name, config_value) values ('chance_aceofspades', '30')
INSERT INTO prefix_config (config_name, config_value) values ('chance_onoff', 'on')
INSERT INTO prefix_config (config_name, config_value) values ('chance_minorprize', '5')
INSERT INTO prefix_config (config_name, config_value) values ('chance_given', '0')
INSERT INTO prefix_config (config_name, config_value) values ('chance_taken', '0')
INSERT INTO prefix_config (config_name, config_value) values ('chance_played', '0')
INSERT INTO prefix_config (config_name, config_value) values ('slot_playprice', '2')
INSERT INTO prefix_config (config_name, config_value) values ('slot_apple', '15')
INSERT INTO prefix_config (config_name, config_value) values ('slot_banana', '20')
INSERT INTO prefix_config (config_name, config_value) values ('slot_orange', '25')
INSERT INTO prefix_config (config_name, config_value) values ('slot_starfruit', '30')
INSERT INTO prefix_config (config_name, config_value) values ('slot_onoff', 'on')
INSERT INTO prefix_config (config_name, config_value) values ('slot_minorprize', '5')
INSERT INTO prefix_config (config_name, config_value) values ('slot_given', '0')
INSERT INTO prefix_config (config_name, config_value) values ('slot_taken', '0')
INSERT INTO prefix_config (config_name, config_value) values ('slot_played', '0')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_enable', '1')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_maxbet', '')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_windouble', '')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_wintriple', '')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_winperfect', '')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_bonussmall', '')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_bonusbig', '')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_played', '0')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_taken', '0')
INSERT INTO prefix_config (config_name, config_value) values ('luckydice_given', '0')

INSERT INTO prefix_keno_game (played, points_given, points_taken) VALUES ('0', '0', '0')

CREATE TABLE prefix_blackjack_cards (
number int(2) NOT NULL default '0',
value text NOT NULL
) TYPE=MyISAM
napriklad takto, neni to vsetko, ale uz by si mal vediet ako na to, pozor treba vsade zmenit prefix tvojich tabuliek
Obrázok užívateľa
masterdead
Administrátor
Administrátor
 
Príspevky: 960
Registrovaný: Ned Jan 28, 2007 1:02 pm
Hore

Poslaťod Momo » Sob Máj 19, 2007 4:56 pm

ešte mi povedz čo to je... nemohol by si mi to rposím ťa spraviť celé? .... Ďakujeeeeeeeeeem :)

jakým postupom si to robil? :lol: :lol: v tom sa nedá vyznať
Obrázok
Obrázok
Obrázok užívateľa
Momo
Profesionál
Profesionál
 
Príspevky: 303
Registrovaný: Uto Mar 06, 2007 1:46 am
Hore

Poslaťod masterdead » Sob Máj 19, 2007 5:07 pm

Momo píše:ešte mi povedz čo to je... nemohol by si mi to rposím ťa spraviť celé? .... Ďakujeeeeeeeeeem :)

jakým postupom si to robil? :lol: :lol: v tom sa nedá vyznať
to je vytiahnuta cast toho co tam mas dat, bohuzial nemam na to cas :? ti to dorobit cele. je to v celku jednoduche:
[php]$sql[] = "INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('1', 'Two Of Clubs')"; [/php]tu je priklad ako je to tam vlozene, je to pole, z ktoreho vyberies len
Kód: Vybrať všetko
INSERT INTO " . $table_prefix . "blackjack_cards (number, value) VALUES ('1', 'Two Of Clubs')
odstranis" . $table_prefix . "a nahradis to tvojou predponou tabuliek :wink: GL
Obrázok užívateľa
masterdead
Administrátor
Administrátor
 
Príspevky: 960
Registrovaný: Ned Jan 28, 2007 1:02 pm
Hore

Poslaťod Momo » Sob Máj 19, 2007 5:11 pm

no ale aj tak lepšie by bolo (poradil mi kamoš :wink: ) že sem mám dať tu chybu.

Ked otvorím www.mojeforum.sk/casino_install.php vypíše mi toto:
Kód: Vybrať všetko
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'w.lfsaction.net'@'localhost' (using password: NO) in /home/www/lfsaction.net/subdomains/warez/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/www/lfsaction.net/subdomains/warez/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/www/lfsaction.net/subdomains/warez/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database


Možno bude lahšie spraviť toto, lebo hento je nadlho to upravovanie :!:
Obrázok
Obrázok
Obrázok užívateľa
Momo
Profesionál
Profesionál
 
Príspevky: 303
Registrovaný: Uto Mar 06, 2007 1:46 am
Hore

Poslaťod M1k3 » Ned Máj 20, 2007 9:02 am

nechápeme, proč se nemohl připojit do databáze.. buď je to špatně naprogramované nebo nevím
Obrázok
M1k3
Začiatočník
Začiatočník
 
Príspevky: 93
Registrovaný: Pia Apr 20, 2007 12:20 pm
Bydlisko: Česká Republika, Praha
Hore

Poslaťod Leachim » Ned Máj 20, 2007 1:13 pm

Otvor cassino_install.php

Nájdi:
[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/constants.'.$phpEx);
include($phpbb_root_path . 'includes/db.'.$phpEx);[/php]

Prepíš na:
[php]define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);[/php]
Michael Watzke - Osobný blog, Bazár PC, notebookov, Tvorba WWW stránok
Nepíšte mi ohľadom phpBB, neodpovedám...
Obrázok užívateľa
Leachim
Expert
Expert
 
Príspevky: 1123
Registrovaný: Sob Jan 27, 2007 2:34 pm
Hore
Písať komentáre

Späť na Podpora (phpBB 2)

Kto je on-line

Užívatelia prezerajúci fórum: Žiadny registrovaný užívateľ nie je prítomný a 0 hostia

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

phpBB SEO

vladstudio
TOPlist TOPlist
cron

Valid XHTML 1.0 Strict [Valid Atom 1.0]


* Štúrovo ubytovanie *