shop mod problem
Verfasst: 05.11.2005 09:25
hallo, ich bin schon verzweifelt und hab mich jetzt extra hier registriert
die shopmod wurde ja gesperrt bei phpbbhacks
ich hab aber noch eine shop mod abgekriegt
aber da stimmt was nicht -- im adminbereich steht zwar shop settings aber bei klick auf absenden ird nichts gespeichert
ich nehme an, dass das mit der installation zu tun hat
könnte sich die mal jemand ansehen? plz
Hier der code der shop_install.php:
Danke für Hilfe
die shopmod wurde ja gesperrt bei phpbbhacks
ich hab aber noch eine shop mod abgekriegt
aber da stimmt was nicht -- im adminbereich steht zwar shop settings aber bei klick auf absenden ird nichts gespeichert
ich nehme an, dass das mit der installation zu tun hat
könnte sich die mal jemand ansehen? plz
Hier der code der shop_install.php:
Code: Alles auswählen
<?php
/***************************************************************************
* shop_install.php
* -------------------
* Version : 1.0.0
* begin : Friday, December 6th, 2002
* released : being built
* email : ice_rain_@hotmail.com
* aim : zarath42
* msn messanger : ice_rain_@hotmail.com
*
***************************************************************************/
/***************************************************************************
*
* copyright (C) 2002/2003 IcE-RaiN/Zarath
*
* 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.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* http://www.gnu.org/copyleft/gpl.html
*
***************************************************************************/
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: ' . append_sid("login.$phpEx?redirect=shop_install.$phpEx", true));
}
if( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_MESSAGE, $lang['Not_Authorised']);
}
if( !strstr($dbms, "mysql") )
{
if( !isset($bypass) )
{
$message = 'This mod has only been tested on MySQL and may only work on MySQL.<br />';
$message .= 'Click <a href="mod_install.php?bypass=true">here</a> to install anyways.';
message_die(GENERAL_MESSAGE, $message);
}
}
$sql = array();
$sql[] = "alter table " . USERS_TABLE . " add `user_items` TEXT";
$sql[] = "create table `phpbb_shopitems` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` CHAR (32) NOT NULL, `shop` CHAR (32) NOT NULL, `sdesc` CHAR (80) NOT NULL, `ldesc` TEXT NOT NULL, `cost` INT (20) UNSIGNED DEFAULT '100', `startprice` INT (20) UNSIGNED DEFAULT '100', `raise` INT (20) UNSIGNED DEFAULT '100', `stock` TINYINT (3) UNSIGNED DEFAULT '10', `startstock` TINYINT (3) UNSIGNED DEFAULT '100', `maxstock` TINYINT (3) UNSIGNED DEFAULT '100', `sold` INT (5) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY(`id`), INDEX(`name`))";
$sql[] = "create table `phpbb_shops` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `shopname` CHAR (32) NOT NULL, `shoptype` CHAR (32) NOT NULL, PRIMARY KEY(`id`), `type` char (32) NOT NULL, `restocktime` INT (20) UNSIGNED DEFAULT '86400', `restockedtime` INT (20) UNSIGNED DEFAULT '0', `restockamount` INT (4) UNSIGNED DEFAULT '5', `amountearnt` INT (20) UNSIGNED DEFAULT '0', INDEX(`shopname`))";
$sql[] = "insert into " . CONFIG_TABLE . " values ('multibuys', 'on')";
$sql[] = "insert into " . CONFIG_TABLE . " values ('restocks', 'off')";
$sql[] = "insert into " . CONFIG_TABLE . " values ('sellrate', '75')";
$sql[] = "insert into " . CONFIG_TABLE . " values ('viewtopic', 'images')";
$sql[] = "alter table " . USERS_TABLE . " add `user_effects` CHAR (255)";
$sql[] = "alter table " . USERS_TABLE . " add `user_privs` CHAR (255)";
$sql[] = "alter table " . USERS_TABLE . " add `user_custitle` TEXT";
$sql[] = "alter table " . USERS_TABLE . " add `user_specmsg` TEXT";
$sql[] = "alter table " . USERS_TABLE . " add `user_items` TEXT";
$sql[] = "alter table " . USERS_TABLE . " add `user_trade` TEXT";
$sql_count = count($sql);
echo "<html>\n";
echo "<body>\n";
for($i = 0; $i < $sql_count; $i++)
{
echo "Running :: " . $sql[$i];
flush();
if ( !$db->sql_query($sql[$i]) )
{
$errored = true;
$error = $db->sql_error();
echo " -> <b>FAILED</b> ---> <u>" . $error['message'] . "</u><br /><br />\n\n";
}
else
{
echo " -> <b>COMPLETED</b><br /><br />\n\n";
}
}
if( $errored )
{
$message = "Some of the querys have failed, contact me so I can fix the errors.";
}
else
{
$message = "The table have been edited successfully. You can now delete this file.";
}
echo "\n<br />\n<b>Finished!</b><br />\n";
echo $message . "<br />\n";
echo "</body>\n";
echo "</html>\n";
exit();
?>
