-
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
-
Re: TDP Player CP Modded by Acnathon
Quote:
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.
-
Re: TDP Player CP Modded by Acnathon
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.
-
Re: TDP Player CP Modded by Acnathon
Quote:
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 ><
-
Re: TDP Player CP Modded by Acnathon
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.
-
Re: TDP Player CP Modded by Acnathon
Quote:
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. :thumbup1:
-
Re: TDP Player CP Modded by Acnathon
Yes i got your point but the age 1935? From 2011 to 1935 its impossible :P!
-
Re: TDP Player CP Modded by Acnathon
Quote:
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.
-
Re: TDP Player CP Modded by Acnathon
It loads very slowly ... is it from me ? Because i dont think.
-
Re: TDP Player CP Modded by Acnathon
Its loading because of server status and channel, please configure them before start the site, read THE FIRST POST!
-
Re: TDP Player CP Modded by Acnathon
Quote:
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.
-
Re: TDP Player CP Modded by Acnathon
It is loading very very fast, you did something wrong, please check again.
-
Re: TDP Player CP Modded by Acnathon
I got this message :
Fatal error: Call to undefined function session_is_registered() in C:\AppServ\www\index.php on line 21
Edit: With xampp i get that
Notice: Undefined variable: nome in C:\Xampp\htdocs\config\configura.php on line 94
Notice: Undefined index: sess in C:\Xampp\htdocs\index.php on line 8
Deprecated: Function session_is_registered() is deprecated in C:\Xampp\htdocs\index.php on line 21
Notice: Use of undefined constant PAGE_TITLE - assumed 'PAGE_TITLE' in C:\Xampp\htdocs\rankings\status.php on line 19
Fatal error: Call to undefined function mssql_connect() in C:\Xampp\htdocs\rankings\status.php on line 22
-
Re: TDP Player CP Modded by Acnathon
Quote:
Originally Posted by
S37uP!Update
I got this message :
Fatal error: Call to undefined function session_is_registered() in C:\AppServ\www\index.php on line 21
Edit: With xampp i get that
Notice: Undefined variable: nome in C:\Xampp\htdocs\config\configura.php on line 94
Notice: Undefined index: sess in C:\Xampp\htdocs\index.php on line 8
Deprecated: Function session_is_registered() is deprecated in C:\Xampp\htdocs\index.php on line 21
Notice: Use of undefined constant PAGE_TITLE - assumed 'PAGE_TITLE' in C:\Xampp\htdocs\rankings\status.php on line 19
Fatal error: Call to undefined function mssql_connect() in C:\Xampp\htdocs\rankings\status.php on line 22
Deprecated: wierd i didnt meet this error... can u tell me what version of x-ampp u use? (also mssql_connect is not enabled on ur server thats why the mssql udnefined)
Undefined variable: check ur configura.php and delete at line 94 this: $nome see if it works.
PAGE_TITLE: add this to ur configura.php_
Code:
define('PAGE_TITLE','Your Cabal Webpage Title');
-
Re: TDP Player CP Modded by Acnathon
About the shop , how can i add items in it?
-
Re: TDP Player CP Modded by Acnathon
I have an error when register "there was a problem sending email" when sending the key
-
Re: TDP Player CP Modded by Acnathon
Quote:
Originally Posted by
Warrior15
I have an error when register "there was a problem sending email" when sending the key
Set up correct smtp server for sending mail.
-
Re: TDP Player CP Modded by Acnathon
where can i find the smtp setup? sorry for my noob question
btw: tnx for your reps..
-
Re: TDP Player CP Modded by Acnathon
Quote:
Originally Posted by
Warrior15
where can i find the smtp setup? sorry for my noob question
btw: tnx for your reps..
Depends...
What webserver you use?
-
Re: TDP Player CP Modded by Acnathon
i use xammp..where can i config it?
-
Re: TDP Player CP Modded by Acnathon
Quote:
Originally Posted by
Warrior15
i use xammp..where can i config it?
Check your php.ini and ur sendmail.ini (in xampp\sendmail folder)
Also check this post.
-
Re: TDP Player CP Modded by Acnathon
http://img100.imageshack.us/img100/1592/ipbany.jpg
Any Impulsive Reaction About This Problem?!...
I Have Run All The Queries And Edited What There Is To Be Edited On...
-
Re: TDP Player CP Modded by Acnathon
can we see some screenshots please?