CabalWeb Ep8 by pafa7a

[4pLay]

Use this for stored procedure

USE [Account]
GO
/****** Object:  StoredProcedure [dbo].[cabal_tool_registerAccount]    Script Date: 10/03/2013 16:47:31 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  PROCEDURE [dbo].[cabal_tool_registerAccount]   (@id varchar(32),  @password  varchar(32))
AS
begin tran
	declare @UserNum as int

	insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo ) 
	values(@id, pwdencrypt(@password), '0', 1, '7700000000000' )

	set @UserNum = @@identity


	insert into cabal_charge_auth(usernum, type, expiredate, payminutes)
	values(@UserNum, 0, DATEADD(day, 1000, getdate()), 0)
	


	select @UserNum as usernum
commit

sorry man! still the problem persists.

and one more thing about ranking.

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Resets'. (severity 16) in C:\xampp\htdocs\modules\rankings.php on line 45

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Resets'. (severity 16) in C:\xampp\htdocs\modules\rankings.php on line 45

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\modules\rankings.php on line 45

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in

 

[S37uP!Update]

Just create Resets column in cabal_character_table

 

[4pLay]

Just create Resets column in cabal_character_table

thanks! gonna try that!

p.s. whats the data type? sorry forgot to ask i was about to try it just now.

 

[pafa7a]

thanks! gonna try that!

p.s. whats the data type? sorry forgot to ask i was about to try it just now.

'int' and dont allow NULLS

 

[4pLay]

'int' and dont allow NULLS

Thanks!

will you be having any updates anytime soon? or its just as it is for now?

 

[pafa7a]

Thanks!

will you be having any updates anytime soon? or its just as it is for now?

After 2-3 days I will release my new project on cabal web including votereward,ajax pages,new security and more

 

[4pLay]

After 2-3 days I will release my new project on cabal web including votereward,ajax pages,new security and more

looking forward to it! well, just for your information i just dev. here for fun not for my pocket. when i say fun, i just set up a server and just play with it with my loved ones.

i saw toasts post, i can see that alot have used your files and gained just for themselves and thats not a good thing.

well, good luck with the succeeding projects & you got my respect!

 

[Lordii]

hi i got this error on the rankings page and cant fix it because i dont see the mistake in the code

[B]
[B]Notice[/B]:  Undefined variable: firstpage in [B]C:\xampp\htdocs\modules\rankings.php[/B] on line [B]100[/B]

[B]Notice[/B]:  Undefined variable: prevpage in [B]C:\xampp\htdocs\modules\rankings.php[/B] on line [B]101[/B]
    
[B]Notice[/B]:  Undefined variable: nextpage in [B]C:\xampp\htdocs\modules\rankings.php[/B] on line [B]113[/B]

[B]Notice[/B]:  Undefined variable: lastpage in [B]C:\xampp\htdocs\modules\rankings.php[/B] on line [B]118[/B]

[/B] maybe someone of u can help me with this xD

 

[benng]

Just create Resets column in cabal_character_table

i also encounter same issue like @4play
this cabal_character_table have to be in Account or in Server01?
I found it in Server01. not residing in Account.

 

[blade99]

i also encounter same issue like @4play
this cabal_character_table have to be in Account or in Server01?
I found it in Server01. not residing in Account.

Ofc cabal_character_table should be on server01... ACCOUNT db = ALL ACCOUNTS,etc

 

[benng]

Ofc cabal_character_table should be on server01... ACCOUNT db = ALL ACCOUNTS,etc

i can login on web only when i create an account using bega Admin Tool.
But if i create an account from the web, the account could not login & show me
the error

 

[blade99]

View attachment 140951

i can login on web only when i create an account using bega Admin Tool.
But if i create an account from the web, the account could not login & show me
the error

check the error line in functions.php as you can see its a cabal_tool_Register_account issue, line 50 is
mssql_query("Execute Account.dbo.cabal_tool_registerAccount '$username','$password','$email','$question','$answer'");

check your dbo.cabal_tool_registerAccount in programmability>stored procedures check if you have all these lines '$username','$password','$email','$question','$answer'" if something is missing add it

 

[benng]

check the error line in functions.php as you can see its a cabal_tool_Register_account issue check the line in functions.php and paste it here

u mean this?

if($error != 'Yes'){
mssql_query("Execute Account.dbo.cabal_tool_registerAccount '$username','$password','$email','$question','$answer'");
echo "<font color='green'><b><center>Account $username is registered successfuly.</b></center></font><br>";

 

[blade99]

u mean this?

if($error != 'Yes'){
mssql_query("Execute Account.dbo.cabal_tool_registerAccount '$username','$password','$email','$question','$answer'");
echo "<font color='green'><b><center>Account $username is registered successfuly.</b></center></font><br>";

cabal_tool_Register_account check your stored procedure

 

[benng]

cabal_tool_Register_account check your stored procedure

Ok is missing question & answer. So what data type should i put is as?

Tried! it does not work still having the same error

 

[b0byx]

Error is Self-Explanatory, Google is your friend.

 

[benng]

Error is Self-Explanatory, Google is your friend.

thanks for that comment. If i would post here means i already google search & try diff methods
but still in vain. Else i wouldnt even waste my effort to put a post.

 

[pafa7a]

Try with this one :

USE [Account]
GO
/****** Object:  StoredProcedure [dbo].[cabal_tool_registerAccount]    Script Date: 11/24/2013 05:35:23 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  PROCEDURE [dbo].[cabal_tool_registerAccount]   (@id varchar(32),  @password  varchar(32), @email varchar(32), @question  varchar(32), @answer  varchar(32))
AS
begin tran
	declare @UserNum as int


	INSERT INTO cabal_auth_table( ID, Password, Login, AuthType, IdentityNo, Email, Question, Answer ) 
	values(@id, pwdencrypt(@password), '0', 1, '7700000000000', @email, @question, @answer)

        set @UserNum = @@identity

	INSERT INTO cabal_charge_auth(usernum, type, expiredate, payminutes)
	values(@UserNum, 0, DATEADD(day, 1000, getdate()), 0)
	
	INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus]) 
	VALUES (@id, @UserNum, '0', '0')

	select @UserNum as usernum
commit

 

[benng]

Try with this one :

USE [Account]
GO
/****** Object:  StoredProcedure [dbo].[cabal_tool_registerAccount]    Script Date: 11/24/2013 05:35:23 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  PROCEDURE [dbo].[cabal_tool_registerAccount]   (@id varchar(32),  @password  varchar(32), @email varchar(32), @question  varchar(32), @answer  varchar(32))
AS
begin tran
	declare @UserNum as int


	INSERT INTO cabal_auth_table( ID, Password, Login, AuthType, IdentityNo, Email, Question, Answer ) 
	values(@id, pwdencrypt(@password), '0', 1, '7700000000000', @email, @question, @answer)

        set @UserNum = @@identity

	INSERT INTO cabal_charge_auth(usernum, type, expiredate, payminutes)
	values(@UserNum, 0, DATEADD(day, 1000, getdate()), 0)
	
	INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus]) 
	VALUES (@id, @UserNum, '0', '0')

	select @UserNum as usernum
commit

yes it works!! thanks alot.

 

[xircx]

Very nice site. Short and simple.
Thanks

Found an error in your functions.php:

function register(){
$username=clean_var($_POST[username]);
$password=clean_var($_POST[password]);
$email=$_POST; //Works good
$question=$_POST[question]; //Works good
$answer=$_POST[answer]; //Works good

Old vars: $email=clean_var($_POST[email]); - removed spaces and special characters, exp @ sign
Old vars: $question=clean_var($_POST[question]); - did not display the question. Could have been from my sql settings
Old vars: $answer=clean_var($_POST[answer]); - removed spaces