TDP Player CP Modded by Acnathon
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.
Re: TDP Player CP Modded by Acnathon
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?
Re: TDP Player CP Modded by Acnathon
Quote:
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';
Re: TDP Player CP Modded by Acnathon
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
Re: TDP Player CP Modded by Acnathon
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.
Re: TDP Player CP Modded by Acnathon
Quote:
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';
Re: TDP Player CP Modded by Acnathon
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
Re: TDP Player CP Modded by Acnathon
Quote:
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.
Re: TDP Player CP Modded by Acnathon
Its working, thank you again, for others future error i`ll tell you, and i think this website really need to be more developed.
Re: TDP Player CP Modded by Acnathon
Quote:
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 :O:)
Re: TDP Player CP Modded by Acnathon
One more error at VIP, i tried to buy vip member and nothing happens, i don`t recive anything, any idea?
Re: TDP Player CP Modded by Acnathon
Quote:
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.
Re: TDP Player CP Modded by Acnathon
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.
Re: TDP Player CP Modded by Acnathon
Quote:
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.
Re: TDP Player CP Modded by Acnathon
