Did you manage to connect to database ? ....
i help you but first post the progress where you're problem is...
if you dont know how to connect to database find this folder :
i want you to familiarize 1st the backend folder.
CabalToolz_v4\backend\includes\adodb5\adodb.inc.php <-- open this with notepad++or any php editor then find this line at count 575:
PHP Code:
function PConnect($argHostname = "", $argUsername = "", $argPassword = "", $argDatabaseName = "", $forceNew = false) ;
This line is the connection that gest the
function PConnect .
PHP Code:
$rs = $db->PConnect($_config['db_host'], $_config['db_user'], $_config['db_pass'], $_config['DB1']) or die("Unable to connect!");
Here is the Config File
THEN YOU CAN GO TO THIS Backend/Config.php at line 7 to 10 : EDIT THIS
PHP Code:
$_config['db_type'] = 'MSSQL';
$_config['db_host'] = "127.0.0.1";
$_config['db_user'] = 'sa';
$_config['db_pass'] = 'yoursqlpassword';
$_config['DB1'] = "ACCOUNT";
$_config['DB2'] = "GAMEDB"; <-ep2 "SERVER01" <-- ep8
$_config['DB3'] = "CABALCASH";
This line you have to edit LINUX CONFIGS
PHP Code:
$_config['ssh_user'] = 'root';
$_config['ssh_ip'] = '1';
$_config['ssh_pass'] = '';
$_config['service_id'] = '09';
$_config['service'] = array(
'10'=>array('Tierra Gloriosa(NW)',100),
'01'=>array('Channel 1(Normal) ',100),
'02'=>array('Channel 2(Hardcore) ',100),
'04'=>array('Channel 3(Special)',100),
);
AND THE QUERY OPEN MSSQL THEN EXECUTE THIS or press "F5"
PHP Code:
USE [SERVER01]
GO
ALTER TABLE [dbo].[cabal_character_table] ADD Resets int NOT NULL DEFAULT((0))
GO
USE [CabalCash]
GO
/****** Object: Table [dbo].[WebShop] Script Date: 11/11/2012 12:50:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WebShop](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NOT NULL,
[Description] [varchar](200) NOT NULL,
[ItemIdx] [int] NOT NULL,
[Options] [int] NOT NULL,
[Image] [varchar](200) NOT NULL,
[Category] [int] NOT NULL,
[Available] [int] NOT NULL,
[TimeLimit] [int] NOT NULL,
[Total] [int] NOT NULL,
[VALUE] [int] NOT NULL,
[Cash] [int] NULL,
[Alz] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[WebShop] ADD CONSTRAINT [DF_WebShop_Total] DEFAULT ((0)) FOR [Total]
GO
ALTER TABLE [dbo].[WebShop] ADD CONSTRAINT [DF_WebShop_VALUE] DEFAULT ((0)) FOR [VALUE]
GO
USE [CabalCash]
GO
/****** Object: Table [dbo].[WebShop_Category] Script Date: 11/11/2012 12:50:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WebShop_Category](
[ID] [smallint] IDENTITY(1,1) NOT NULL,
[Category] [nvarchar](50) NOT NULL,
[Access] [smallint] NOT NULL
) ON [PRIMARY]
GO
USE [CabalCash]
GO
/****** Object: Table [dbo].[toolz_vote] Script Date: 11/11/2012 12:51:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[toolz_vote](
[id] [int] IDENTITY(1,1) NOT NULL,
[userid] [nchar](10) NOT NULL,
[votedata] [text] NULL,
CONSTRAINT [PK_mutoolz] PRIMARY KEY CLUSTERED
(
[userid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
go to Backend/Login.php
find this line 90 :
PHP Code:
$db->Execute('update '.$_config['DB1'].'.dbo.cabal_auth_table set EventTag = 1 where upper(ID) = ?',$user_auth->username);
execute this query.
PHP Code:
USE [SERVER01]
GO
ALTER TABLE [dbo].[cabal_character_table] ADD EventTag int NOT NULL DEFAULT((0))
GO
AS far as i read the functionality ... i think that is a good way to start... :)
if you have errors just post it here... :)
Reply With Quote
Originally Posted by orphen99
