TDP Player CP Modded by Acnathon

**Acnathon** · 24-09-11

TDP Player CP + Design [RGN] + Translation.

First of all I would like to tell you guys the most important things:

Since I didnt had enough time to do everything (because of my school/job and also my server)...:

1.) The translation its not 100%. (But the main functions are done - if im not wrong)

2.) Some of the functions like upgrading class rank and create character from the panel have some bugs. (Ex.: creating character is abit messed because of the style)

3.) The Webshop has been changed - it uses CabalCash --> WebShop table and also its abit different from the original. (later I could add a script for adding items since theres only user side script atm.)

4.) Some parts of the codes can give you some errors if you have like fresh, empty databases. (Ex.: Guild Ranking and so on...)

About the design:
Its not a big deal... I just took some free stuff and modded.
Note: I lost my PSD's >< so i cant provide them but I think the most parts are easy to change even without them.

I have used 2 servers High & Low thats why u can see 2 status scripts on the top.

Files to modify:
config/configura.php ---> DB Adress, Username and Password.
rankings/status+status2.php ---> Your Server IP + Ports (Channels)
news/.htaccess ---> Here you can allow IP adresses for those who can use your news system.
There is a default (Admin) user for the news sytem. U can change it by logging in and... (u will see there)
Default user infos for news system:
Username: Admin
Password: admin123

Tables to add:

1.) chaves

Code:

USE [ACCOUNT]
GO
/****** Object:  Table [dbo].[chaves]    Script Date: 09/23/2011 18:52:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[chaves](
    [num] [int] IDENTITY(1,1) NOT NULL,
    [chave] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [id] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [dia] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [email] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [dia_gerado] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [ip] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

2.) cadastro_personal

Code:

USE [ACCOUNT]
GO
/****** Object:  Table [dbo].[cadastro_personal]    Script Date: 09/23/2011 18:51:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cadastro_personal](
    [userid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [senhaNoMd5] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [nome] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [sobrenome] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [email] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [cidade] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [estado] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [sexo] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [dia] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [mes] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [ano] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [pergunta] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [resposta] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [dia_cadastro] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [ip] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

3.) ipban

Code:

USE [Account]
GO
/****** Object:  Table [dbo].[ipban]    Script Date: 09/24/2011 16:20:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ipban](
    [ip] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

4.) GuildRanking

Code:

USE [Gamedb]
GO
/****** Object:  Table [dbo].[GuildRanking]    Script Date: 09/24/2011 16:27:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GuildRanking](
    [GuildId] [int] NULL,
    [ReputationTotal] [int] NULL,
    [GuildName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]


USE [Gamedb]
alter table GuildMember add Reputation int null

5.) votes + CashAccount votes column

Code:

USE [CabalCash]
GO
/****** Object:  Table [dbo].[votes]    Script Date: 09/15/2011 01:03:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[votes](
    [accName] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
    [lastVoteDate] [datetime] NOT NULL,
    [voteLink] [int] NULL,
    [ip] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

USE [CabalCash]
alter table CashAccount add votes int not null default 0

6.) WebShop

Code:

USE [CabalCash]
GO
/****** Object:  Table [dbo].[WebShop]    Script Date: 09/24/2011 16:53:30 ******/
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) COLLATE Chinese_PRC_CI_AS NOT NULL,
    [Description] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
    [ItemIdx] [int] NOT NULL,
    [Options] [int] NOT NULL,
    [Image] [varchar](200) COLLATE Chinese_PRC_CI_AS NOT NULL,
    [Cash] [int] NULL,
    [Alz] [int] NULL,
    [Category] [int] NOT NULL,
    [Available] [int] NOT NULL,
    [TimeLimit] [int] NOT NULL,
    [Total] [int] NOT NULL CONSTRAINT [DF_WebShop_Total]  DEFAULT ((0)),
    [VP] [int] NOT NULL DEFAULT ((0))
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

I hope i didnt messed up (im not good when explaining ><).
If theres any problem/bug post it here.

Download: Download TDP Player CP Modded by Acnathon

P.S.: DO BACKUPS BEFORE EDITING ANYTHING!
Also somebody expert in php should check if I messed up with the security things.

Credits:
SheenBR
chumpywumpy
Alphakilo23
john_d
Acnathon - m4kK3r

Edit: Live demo removed. Soon will be up again.

**MentaL**

**allocen** · 24-09-11

You are really good, good job, for feature changes on this release i`ll put them here.

EDIT:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in X:\xampp\htdocs\site\config\classe.php on line 25

Fatal error: Falha ao conectar com SQL! Verifique os dados e tente novamente. in X:\xampp\htdocs\site\config\classe.php on line 28

What could be?

**Acnathon** · 24-09-11

Originally Posted by allocen

You are really good, good job, for feature changes on this release i`ll put them here.

EDIT:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in X:\xampp\htdocs\site\config\classe.php on line 25

Fatal error: Falha ao conectar com SQL! Verifique os dados e tente novamente. in X:\xampp\htdocs\site\config\classe.php on line 28

What could be?

In classe.php change this line:

Code:

$connection_string = 'DRIVER={SQL Native Client};SERVER='.$this->host.';DATABASE=ACCOUNT';

to this:

Code:

$connection_string = 'DRIVER={SQL Server};SERVER='.$this->host.';DATABASE=ACCOUNT';

**allocen** · 24-09-11

One more problem at User cp at Edit Account, i can`t press on Password to edit it , but on First name Last name i can, any idea?

And one more thing at Guild Rank:

Warning: mssql_free_result(): supplied argument is not a valid MS SQL-result resource in x:\xampp\htdocs\site\rankings\gd.php on line 52

Warning: mssql_free_result(): supplied argument is not a valid MS SQL-result resource in x:\xampp\htdocs\site\rankings\gd.php on line 54

**Acnathon** · 24-09-11

Well let me explain:
1st when u log in u need to finish registration. after you can go again on Edit account then it will allow you to click on password field too. (So first just fill out the rest and update it)
With the guild ranking page mmm You have any guilds made ingame? if not there is the problem.
make at least 1 guild and the error will disappear.

**Yag4mi2k** · 24-09-11

Originally Posted by allocen

One more problem at User cp at Edit Account, i can`t press on Password to edit it , but on First name Last name i can, any idea?

And one more thing at Guild Rank:

Warning: mssql_free_result(): supplied argument is not a valid MS SQL-result resource in x:\xampp\htdocs\site\rankings\gd.php on line 52

Warning: mssql_free_result(): supplied argument is not a valid MS SQL-result resource in x:\xampp\htdocs\site\rankings\gd.php on line 54

your error solution , view more post

In classe.php change this line:
Code:
$connection_string = 'DRIVER={SQL Native Client};SERVER='.$this->host.';DATABASE=ACCOUNT';
to this:
Code:
$connection_string = 'DRIVER={SQL Server};SERVER='.$this->host.';DATABASE=ACCOUNT';

**allocen** · 25-09-11

One more error:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value., SQL state 22008 in SQLExecDirect in X:\xampp\htdocs\cabal\register2.php on line 794

**Acnathon** · 25-09-11

Originally Posted by allocen

One more error:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value., SQL state 22008 in SQLExecDirect in X:\xampp\htdocs\cabal\register2.php on line 794

mmm
on register2.php line 780 change this:

Code:

$expira = "30/12/2015 00:00:00";

to this (idk if it works 100% cos i dont have a working smtp so i cant try registering ><)

Code:

$expira = "2015.01.01 00:00:00";

If its not working tell me and later ill setup an smtp so i could try out.

**allocen** · 25-09-11

Its working, thank you again, for others future error i`ll tell you, and i think this website really need to be more developed.

**Acnathon** · 25-09-11

Originally Posted by allocen

Its working, thank you again, for others future error i`ll tell you, and i think this website really need to be more developed.

Yes tell me here any error and also yes id love to learn more so ill try to add some more functions also i hope other RZ members will do the same :)
btw sry about leaving so much rgn stuff inside the codes i was really lazy to take em out (all

)

**allocen** · 25-09-11

One more error at VIP, i tried to buy vip member and nothing happens, i don`t recive anything, any idea?

**Acnathon** · 25-09-11

Originally Posted by allocen

One more error at VIP, i tried to buy vip member and nothing happens, i don`t recive anything, any idea?

Well the VIP system its like more a premium system (u get ingame premium for it)
It wasnt done even in the original (if im not wrong) code but i think ill take a look on it to make it work.

**allocen** · 25-09-11

i see now its workin look at this:

Welcome allocen!
Your VIP membership will expire at .

But i can`t see the date when.. And one more thing what its CR upgrade cuz nothing happens and there is any admin panel to put items in item shop?

And

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'RESETS'., SQL state S0022 in SQLExecDirect in X:\xampp\htdocs\cabal\stats.php on line 288

When i try to reset the status.

**Acnathon** · 25-09-11

Originally Posted by allocen

i see now its workin look at this:

Welcome allocen!
Your VIP membership will expire at .

But i can`t see the date when.. And one more thing what its CR upgrade cuz nothing happens and there is any admin panel to put items in item shop?

And

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'RESETS'., SQL state S0022 in SQLExecDirect in X:\xampp\htdocs\cabal\stats.php on line 288

When i try to reset the status.

1. Ok today ill make an easy script for adding items.
2. CR Upgrade means Class Rank upgrade. I tryed to fix but still has some bugs.
3. About the warning please post a screenshot about ur account in cabal_charge.auth (cos maybe the ExpireDate is worng)

*I will add all these fixes on the first post just i want to get more fixes first.

**allocen** · 25-09-11

**Acnathon** · 25-09-11

Originally Posted by allocen

Ok the problem for the VIP expire date is because the register2.php put the wrong date format.
Try this:
change line 780 on register2.php like this:

Code:

$expira = time()+(60*60*60*24*365);

and register a new account and tell me if its working.

Edit: Maybe its not like that >< but post me the result of the modification above.

**allocen** · 25-09-11

Now i have the same error after your modification

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string., SQL state 22008 in SQLExecDirect in X:\xampp\htdocs\cabal\register2.php on line 794

as i had before.

**Acnathon** · 25-09-11

Originally Posted by allocen

Now i have the same error after your modification

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string., SQL state 22008 in SQLExecDirect in X:\xampp\htdocs\cabal\register2.php on line 794

as i had before.

On 780 line register2.php change this:

Code:

$expira = time()+(60*60*60*24*365);

to this:

Code:

$expiredate = time()+(60*60*60*24*365);
$expira = date('Y-m-d H:i:s', $expiredate);

I hope now it works ><

**allocen** · 25-09-11

I see its working now but we have a funny problem look after i created a new account:

Welcome works!
Your VIP membership will expire at 05/08/1935.

And i don`t even bought one.

PS: send me a pm with your yahoo or skype id cuz i want work with you at this website,i have too some new features and ideas for you.

**Acnathon** · 25-09-11

Originally Posted by allocen

I see its working now but we have a funny problem look after i created a new account:

Welcome works!
Your VIP membership will expire at 05/08/1935.

And i don`t even bought one.

Well i know u didnt bought one but since all servers have auto premium (ingame) the script also gives you auto premium when u register.
Thats why its like automated.

**allocen** · 25-09-11

Yes i got your point but the age 1935? From 2011 to 1935 its impossible :P!

**Acnathon** · 25-09-11

Originally Posted by allocen

Yes i got your point but the age 1935? From 2011 to 1935 its impossible :P!

Ahh sry about that i didnt noticed the year for first time :D ill configure later my smtp and ill test all these, fix them and update the first post with them.

**11223344556677** · 26-09-11

It loads very slowly ... is it from me ? Because i dont think.

**allocen** · 26-09-11

Its loading because of server status and channel, please configure them before start the site, read THE FIRST POST!

**11223344556677** · 28-09-11

Originally Posted by allocen

Its loading because of server status and channel, please configure them before start the site, read THE FIRST POST!

They are config. but it's still loading slowly.

TDP Player CP Modded by Acnathon

Thread Tools

Search Thread

TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Re: TDP Player CP Modded by Acnathon

Advertisement