[Dev] Cabatoolz V4 compatible whit Ep8

[allocen]

@soultransit, i still recommand you to use mssql driver, cuz if you'll use sqlserv you'll see that you will have some serious problems .

 

[4pLay]

Hi I would like to participate I just started today.

My project is running on MS SQLEXPRESS 2008 + IIS 7 + PHP 5.3

Progress:
DB connection (used sqlserv driver for PHP)

You must be registered to see links

TO DO LIST:
rewrite db queries to sqlserv

User Login
User Registration
Rankings
Arena
Vote
Web Shop
Backend Administration

Well,.. Good Luck To You Brother!

It's Nice Of You To Step Up And Feed The Hungry Bears Here... :junglejane:

 

[soultransit]

@allocen as much as I wanted to use mssql driver on php ver 5.3 they've removed the php_mssql extension and I am using windows 2008 enterprise server and with IIS 7 that is why i can't just add mssql driver to php ext. instead Microsoft uses sqlsrv.

this is the php documentation

You must be registered to see links

found database class library for sqlsrv adodb mssqlnative

You must be registered to see links

 

[Extornia]

@allocen as much as I wanted to use mssql driver on php ver 5.3 they've removed the php_mssql extension and I am using windows 2008 enterprise server and with IIS 7 that is why i can't just add mssql driver to php ext. instead Microsoft uses sqlsrv.

this is the php documentation

You must be registered to see links

found database class library for sqlsrv adodb mssqlnative

You must be registered to see links

FreeTDS.

 

[allocen]

There is already a dll that provide mssql functions on newest xampp version, its named: php_dball.dll. I'm kinda lazy to upload it now, maybe later, but it can be found on google.

 

[Extornia]

There is already a dll that provide mssql functions on newest xampp version, its named: php_dball.dll. I'm kinda lazy to upload it now, maybe later, but it can be found on google.

Similiar to dblib.dll which uses FreeTDS.

 

[Speranza]

Hy guys,

My Problem this:



Only just Login don't working. I runned the query's and i make new stored procedure: dbo.cabal_user_auth <--- this

Ranking [OK]
Register [OK]

I now tested this ct on ep2 db-s. And can't Login :///

Please Help

My config:

xampp 1.7.7 with VC9 and dblib.dll extension.

 

[soultransit]

Similiar to dblib.dll which uses FreeTDS.

Found it. Documentation and Downloads

You must be registered to see links

 

[4pLay]

Found it. Documentation and Downloads

You must be registered to see links

Make Your Own Dev. Thread So We Can Follow Up On Your Development... :

Good Luck!

 

[soultransit]

created Stored Procedure to check logins this uses PWDCOMPARE to encrypt passwords. tried to execute this on my SQL query and it returns a row with the correct user. My problem now is trying to implement this on Cabal Toolz.

This is the guide on how to create Stored Proc on SQL 2008

You must be registered to see links

This is the Script:

-- =============================================
-- Author:		<Soultransit>
-- Create date: <02/21/2013>
-- Description:	<Cabal Toolz SQL Username | Password Checker>
-- =============================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE cabal_login_checker @username varchar(50),@password varchar (50)
	
AS
BEGIN
	SET NOCOUNT ON;

        SELECT ID, Password FROM Account.dbo.cabal_auth_table 
	WHERE ID = @user and PWDCOMPARE(@password, Password) = 1 
END
GO

You can now execute this on sql query like this:

exec Account.dbo.cabal_login_checker 'yourusername','yourpassword'

If someone has better knowledge on this please pm me. Thanks!

 

[4pLay]

created Stored Procedure to check logins this uses PWDCOMPARE to encrypt passwords. tried to execute this on my SQL query and it returns a row with the correct user. My problem now is trying to implement this on Cabal Toolz.

This is the guide on how to create Stored Proc on SQL 2008

You must be registered to see links

This is the Script:

-- =============================================
-- Author:		<Soultransit>
-- Create date: <02/21/2013>
-- Description:	<Cabal Toolz SQL Username | Password Checker>
-- =============================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE cabal_login_checker @username varchar(50),@password varchar (50)
	
AS
BEGIN
	SET NOCOUNT ON;

        SELECT ID, Password FROM Account.dbo.cabal_auth_table 
	WHERE ID = @user and PWDCOMPARE(@password, Password) = 1 
END
GO

You can now execute this on sql query like this:

[COLOR="#FF0000"]exec Account.dbo.cabal_login_checker 'yourusername','yourpassword'[/COLOR]

If someone has better knowledge on this please pm me. Thanks!

View attachment 124178

The Red One Which You Can Create An Account Is Already Out In The Market... :

But Your A Good Kid And Share's His Knowledge,...

If You Want You Could Just Re-Make Chumpy's Simple Reg Page + Webshop...

 

[jaguar666]

If You Want You Could Just Re-Make Chumpy's Simple Reg Page + Webshop...

Instead of modifying/re-making chumpy's webpage, why not doing it on CT4 which has a better look and easy to modify the frontpage. Besides that even your PC server is offline/down but you can still post announcement/notice at the web host.

 

[soultransit]

The Red One Which You Can Create An Account Is Already Out In The Market... :

But Your A Good Kid And Share's His Knowledge,...

If You Want You Could Just Re-Make Chumpy's Simple Reg Page + Webshop...

I know that one for registering accounts, but this one is different from registering it checks username and the password that is not encrypted.

exec Account.dbo.cabal_tools_registerAccount 'newUsername','newPassword'

What I've created search for "registered" accounts and return row if login is correct

 

[4pLay]

Instead of modifying/re-making chumpy's webpage, why not doing it on CT4 which has a better look and easy to modify the frontpage. Besides that even your PC server is offline/down but you can still post announcement/notice at the web host.

Hmmm... Good Point!...

Well It's Still Up To Him! :

I know that one for registering accounts, but this one is different from registering it checks username and the password that is not encrypted.

exec Account.dbo.cabal_tools_registerAccount 'newUsername','newPassword'

What I've created search for "registered" accounts and return row if login is correct

So, What's The Development Stage Are You Now In?!...

Are You Taking It Step By Step Starting On Registering?!..

 

[soultransit]

register is already working, the problem I have now is the login part.

 

[juleki]

Your code for me not working, i have syntax error. It works only if i declare ID account, i mean ID account coz in database also is ID not Username.

-- =============================================
-- Author:		<Soultransit>
-- Create date: <02/21/2013>
-- Description:	<Cabal Toolz SQL Username | Password Checker>
-- =============================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE cabal_login_checker [COLOR="#FF0000"]@ID[/COLOR] varchar(50),@password varchar (50)
	
AS
BEGIN
[COLOR="#FF0000"]DECLARE @ID varchar (50)[/COLOR]
	SET NOCOUNT ON;

        SELECT ID, Password FROM Account.dbo.cabal_auth_table 
	WHERE ID = [COLOR="#FF0000"]@ID[/COLOR] and PWDCOMPARE(@password, Password) = 1 
END
GO

 

[racing]

user login error
admin panel error
gm panel error
edit cabal cash error

Login admin panel, Why is the screen white

which is a solution, please share files

 

[haolongo]

Read

[QUOTE=Lazy;7443463]i'd like to start editing the current nice Cabaltoolz from john_d to be compatible whit the ep8 DB
since i find it pointless creating new web etc, if there is a nice one.

Plans:

Edit the upgrade limit from +7 to +15 /later
Add ep8 item list /later
Adjust db connect names /busy
Fix minor issues /in the mean while
Usercp/gmcp/admincp compatible whit ep8 db

Succeeded:

Top15 Chars work

 

[R0N]

rankings will work even you did not touch the ct4, the only problem is the logins, since the passwords are encrypted

 

[pap0t]

I don't if this still alive. But i found this thread cause i was researching about cabal and cabaltoolz. Since my friend asked me update this cabaltoolz website he has. I guess this version of the site he has was a paid version since it has some features that the free ones available here don't have.

Ps. i have no problem sharing the website after i am done updating. ( it is my first share on rz anyway. )

I would be needing some help though. Not coding wise but more on the differences between CT4 cabal, that this website used to work and the latest cabal server releases.