Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Cluster Flyff Website

Initiate Mage
Joined
Apr 3, 2013
Messages
32
Reaction score
1
REASON FOR RELEASING:
MY DEV STOLE THE FILES I BOUGHT

webfiles
database

ENJOY!
 
Last edited:
Junior Spellweaver
Joined
Nov 3, 2008
Messages
130
Reaction score
6
this site is nice but has a crap ton of errors. lol it says no database connections even tho my server can connect and the other website im messing with connects idk i like it tho :3
 
Experienced Elementalist
Joined
Feb 18, 2009
Messages
225
Reaction score
13
why i can't enter Admin panel even trough my Account is Admin? i can only enter GM panel..
 
Experienced Elementalist
Joined
Feb 18, 2009
Messages
225
Reaction score
13
yeh already got it haha thanks anyway ;P stopid question from me
 
Developer
Member
Joined
Jul 28, 2009
Messages
983
Reaction score
133
Some screenshots or a live demo would be nice.
 
Initiate Mage
Joined
Feb 11, 2015
Messages
51
Reaction score
8
how to Fix this :There is currently no database connection.


Check the database settings file to see if matches perfectly with your database settings, username, password, port, etc..

Also remember to check if the firewall is not blocking your connection in case you're not hosting the website in the same computer as the database.
 
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
Uses sapphire base so:
Code:
USE [ACCOUNT_DBF]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_createAccount]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_createAccount]
GO

USE [ACCOUNT_DBF]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE proc [dbo].[usp_createAccount] [USER=162874]account[/USER] varchar(32),
@pw varchar(32), [USER=315880]cas[/USER]h int = 0, [USER=213273]email[/USER] varchar(100) = '',
@gefra smallint = 0,
@geant varchar(50), [USER=848971]Birth[/USER]day varchar(10),
@ip varchar(39), [USER=1333467003]Lang[/USER] varchar(3)
as
set nocount on
set xact_abort on

if not exists (select * from ACCOUNT_TBL where account = [USER=162874]account[/USER])
begin


	begin tran
	INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,id_no2,realname,OldPassword,cash)
	VALUES [USER=162874]account[/USER], @pw, 'T', 'A', @pw, @pw, 'P',@pw, [USER=315880]cas[/USER]h)
	INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email,secretquestion,secretanswer,birthday,regIP)
	VALUES [USER=162874]account[/USER],'A000','2','F',GETDATE(),CONVERT(CHAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()),112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, [USER=213273]email[/USER], @gefra, @geant, [USER=848971]Birth[/USER]day,@ip)

	if @@error <> 0
	begin
		rollback tran
		select -1
	end
	else
	begin
		commit tran
		select 1
	end
end
else
begin
	select 0
end

GO
 
Custom Title Activated
Member
Joined
Mar 26, 2012
Messages
1,465
Reaction score
130
Thank you Ketchup.
Just one error. could not store procedure regIP. I have added the missing columns but, am unsure of this error.
Nevermind. I found the error and fixed it. Again. Thank you.
 
Last edited:
Custom Title Activated
Member
Joined
Mar 26, 2012
Messages
1,465
Reaction score
130
Another question about this template please. I have all working but, when I enable the email validation it gives me the error
The script could not be executed:

The registration failed, the account could not be written to the database.
.
This is using the default coding that came with the website. Without enabling this option, it inputs the information correctly into the databases as expected. Any idea why this code would not work?
@odbc_exec($odbc_connect, '
INSERT INTO [' . $_CONFIG['db_databases']['web'] . '].[dbo].[VALIDATE] (
[key],
[type],
[account],
[timestamp],
[fieldAlfa],
[fieldBravo],
[fieldCharlie],
[fieldDelta],
[fieldEcho],
[fieldFoxtrot]
) VALUES (
\'' . $key . '\',
0,
\''.$account.'\',
\''.time().'\',
\''.$email.'\',
\''.$md5pw.'\',
\''.md5($_CONFIG['security_secretAnswerSalt'].$geant).'\',
\''.date($_CONFIG['web_date_format']['date'], strtotime($birthday)).'\',
'.$gefra.',
\''.$_SERVER['REMOTE_ADDR'].'\'
)
 
Custom Title Activated
Member
Joined
Mar 26, 2012
Messages
1,465
Reaction score
130
Fixed!
@odbc_exec($odbc_connect, "
INSERT INTO [" . $_CONFIG['db_databases']['web'] . "].[dbo].[VALIDATE] (
[key],
[type],
[account],
[timestamp],
[fieldAlfa],
[fieldBravo],
[fieldCharlie],
[fieldDelta],
[fieldEcho],
[fieldFoxtrot]
) VALUES (
'".$key."',
'0',
'".$account."',
'".time()."',
'".$email."',
'".$md5pw."',
'".md5($_CONFIG['security_secretAnswerSalt'].$geant)."',
'". date($_CONFIG['web_date_format']['date'], strtotime($birthday))."',
'".$gefra."',
'". $_SERVER['REMOTE_ADDR'] . "'
)
");
 
Back
Top