Register for your free account! | Forgot your password?

You last visited: Today at 15:09

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Backend Panel

Discussion on Backend Panel within the Flyff PServer Guides & Releases forum part of the Flyff Private Server category.

Reply
Page 5 of 6 « First 34 5 6
 
Old 04/01/2013, 21:43   #61
 
Langstra's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2010
Posts: 20
Received Thanks: 3
I downloaded it, but it does not work directly out of the box. (not for me atleast) First there is the database, there are a few things that have to be fixed before it worked.
So then I could try it, looks pretty good. I fixed a few things, like the images in the inventory, the CItemList.php include instead of ItemList.php and the login.
I also started translating it. Thumbs up for sedrika.
I hope you don't mind if I make some modifications, like adding a ban function.

Edit: forgot to say, but the table 'web_staff' seems to be missing. Just as the page 'server_management.php'
Langstra is offline  
Old 04/01/2013, 23:01   #62



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,475
The server_management.php contains my ingame api. I removed it.
Feel free to edit all you want :>
Sedrika is offline  
Old 04/02/2013, 02:32   #63
 
sakalasmpk's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2012
Posts: 12
Received Thanks: 0
I appreciate all the work of sadrika.
sakalasmpk is offline  
Old 04/02/2013, 13:53   #64
 
elite*gold: 0
The Black Market: 5/0/0
Join Date: Oct 2012
Posts: 577
Received Thanks: 139
Es ist gut aber du hast es nicht von grundauf aufgebaut oder ?
ArakiLP is offline  
Old 04/02/2013, 14:07   #65



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,475
Das Design des Panel ist nicht von mir.
Funktionen, Datenbank, Geschaltung der Seite ist von mir.
Mit Gestaltung ist gemeint, wo die einzelnen Elemente im Content sein werden.
Sedrika is offline  
Old 04/02/2013, 14:45   #66
 
elite*gold: 0
The Black Market: 5/0/0
Join Date: Oct 2012
Posts: 577
Received Thanks: 139
Quote:
Originally Posted by Sedrika View Post
Das Design des Panel ist nicht von mir.
Funktionen, Datenbank, Geschaltung der Seite ist von mir.
Mit Gestaltung ist gemeint, wo die einzelnen Elemente im Content sein werden.
okay der rest von steffan =?
ArakiLP is offline  
Old 04/02/2013, 14:49   #67



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,475
0% von Stefan. Alles selbst geschrieben.
Sedrika is offline  
Old 07/01/2013, 23:11   #68
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2010
Posts: 12
Received Thanks: 0
i have this error can you help me
fiderumg is offline  
Old 07/07/2013, 18:56   #69
 
m22xl141's Avatar
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Mar 2012
Posts: 46
Received Thanks: 14
make a tutorial
m22xl141 is offline  
Old 08/07/2013, 11:19   #70
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 948
Received Thanks: 157
I am sorry for bumping this topic up.

But i have the following issue.
When i use Ruby - ACP Item List Creator
Its all working however the Images are not included inside the Sql.
So there fore i need to add all the images manually.

This is the SQL after running Ruby - ACP Item List Creator

So my question is how could i solve this. Or do i need to change 7193 Rows manually?

With kind regards.

Edit.

I already fixed it my Spec_Item has an couple of more rows then the original. I am also using the v19 Parameters. So i removed them from the spec_item and now i have also those icons.
raventh1984 is offline  
Old 08/24/2014, 20:04   #71
 
Grening's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2013
Posts: 228
Received Thanks: 99
Beim Ausführen des Scriptes bekomme ich folgende Errors.
Code:
 Meldung 102, Ebene 15, Status 1, Zeile 6
Falsche Syntax in der Nähe von '0'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '1'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '2'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '3'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '4'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '6'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '7'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '8'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '9'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '10'.
Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von '11'.
Kann mir da jemand weiterhelfen?
Grening is offline  
Old 10/06/2014, 16:08   #72
 
elite*gold: 0
The Black Market: 7/0/0
Join Date: Apr 2014
Posts: 153
Received Thanks: 13
C:\wamp\www\panel\inc\functions.php on line 23 Warning: odbc_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\panel\inc\functions.php on line 23
iii123 is offline  
Old 10/18/2014, 09:43   #73
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2009
Posts: 28
Received Thanks: 4
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Die gespeicherte Prozedur 'dbo.AdminPanel' wurde nicht gefunden., SQL state 37000 in SQLExecDirect in C:\xampp\xampp\htdocs\flyff\sedrika\Panel\Sedrika - Backend Panel\BackendPanel\inc\functions.php on line 22

Warning: odbc_result() expects parameter 1 to be resource, boolean given in C:\xampp\xampp\htdocs\flyff\sedrika\Panel\Sedrika - Backend Panel\BackendPanel\inc\functions.php on line 23

help me 。3Q
sushe534 is offline  
Old 10/22/2014, 07:32   #74
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2014
Posts: 2
Received Thanks: 0
Here, try that.

Code:
CREATE PROCEDURE [dbo].[AdminPanel]
	@user varchar(16) = '',
	@pass varchar(32) = '',
	@action varchar(64) = '',
	@id int = 0,
	@cat int = 0,
	@title varchar(128) = '',
	@image varchar(128) = '',
	@content text = '',
	@maintenance_newpass varchar(32) = '',
	@maintenance_newpass_blank varchar(6) = '',
	@maintenance_seq int = 0,
	@worth varchar(6) = ''
AS
BEGIN
	SET NOCOUNT ON;

	if @action = 'Login'
		begin
			if exists (select * from [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL] where [account] = @user and [password] = @pass )
				begin
					select 'RetVal' = 1
				end
			else
				begin
					select 'RetVal' = 0
				end
		end
	else if @action = 'GetLord'
		begin
			SELECT TOP 1 m_szName FROM CHARACTER_01_DBF.dbo.[tblLord] a LEFT JOIN CHARACTER_01_DBF.dbo.CHARACTER_TBL b ON RIGHT('0000000' + CONVERT(VARCHAR(7),a.idLord),7)= b.m_idPlayer ORDER BY s_date DESC
		end
	else if @action = 'GetMVP'
		begin
			SELECT TOP 1 m_szName FROM CHARACTER_01_DBF.dbo.[tblCombatJoinPlayer] JP LEFT JOIN CHARACTER_01_DBF.dbo.tblCombatInfo CI ON JP.CombatID = CI.CombatID LEFT JOIN CHARACTER_01_DBF.dbo.CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = '30' ORDER BY JP.CombatID DESC, Point DESC
		end
	else if @action = 'GetGSWinner'
		begin
			SELECT TOP 1 m_szGuild FROM CHARACTER_01_DBF.dbo.[tblCombatJoinGuild] JG LEFT JOIN CHARACTER_01_DBF.dbo.tblCombatInfo CI ON JG.CombatID = CI.CombatID LEFT JOIN CHARACTER_01_DBF.dbo.GUILD_TBL G ON JG.GuildID = G.m_idGuild WHERE CI.[Status] = '30' ORDER BY JG.CombatID DESC, Point DESC
		end
	else if @action = 'GetCountAccount'
		begin
			select COUNT(*) as RetVal from ACCOUNT_DBF.dbo.ACCOUNT_TBL
		end
	else if @action = 'GetCountCharacter'
		begin
			select COUNT(*) as RetVal from CHARACTER_01_DBF.dbo.CHARACTER_TBL
		end
	else if @action = 'GetCountGuild'
		begin
			select COUNT(*) as RetVal from CHARACTER_01_DBF.dbo.GUILD_TBL
		end
	else if @action = 'GetCountOnlineUser'
		begin
			select COUNT(*) as RetVal from CHARACTER_01_DBF.dbo.CHARACTER_TBL where MultiServer != 0
		end
	else if @action = 'UpdateNewsCat'
		begin
			UPDATE [WEBSITE_DBF].[dbo].web_newscategories set title = @title, icon = @image where ncatid = @id
		end
	else if @action = 'AddNewsCat'
		begin
			insert into WEBSITE_DBF.dbo.web_newscategories( title, icon )
			values( @title, @image )
		end
	else if @action = 'UpdateNews'
		begin
			UPDATE [WEBSITE_DBF].[dbo].web_news set title = @title, [text] = @content, category = @cat where nid = @id
		end
	else if @action = 'AddNews'
		begin
			insert into WEBSITE_DBF.dbo.web_news( title, [text], category, author, [datetime], [views] )
			values( @title, @content, @cat, @user, GETDATE(), 0 )
		end
	else if @action = 'IsAdmin'
		begin
			if exists( select * from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where [account] = @user and m_chLoginAuthority = 'P' or [account] = @user and m_chLoginAuthority = 'Z' )
				begin
					select 'RetVal' = 1
				end
			else
				begin
					select 'RetVal' = 0
				end
		end
	else if @action = 'GetAccountInfo'
		begin
			if exists( select * from ACCOUNT_DBF.dbo.ACCOUNT_TBL where [account] = @user)
				begin
					declare @ret_cash varchar(32)
					declare @ret_auth1 varchar(1)
					declare @ret_regdate varchar(32)
					declare @ret_btime varchar(32)
					declare @ret_etime varchar(32)
					declare @ret_email varchar(128)
					declare @ret_lastip varchar(15)
					
					set @ret_cash = (select cash from ACCOUNT_DBF.dbo.ACCOUNT_TBL where [account] = @user)
					set @ret_auth1 = (select m_chLoginAuthority from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where [account] = @user)
					set @ret_regdate = (select regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where [account] = @user)
					set @ret_email = (select email from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where [account] = @user)
					
					if exists( select * from LOGGING_01_DBF.dbo.LOG_LOGIN_TBL where [account] = @user)
						begin
							set @ret_lastip = (select top 1 remoteIP from LOGGING_01_DBF.dbo.LOG_LOGIN_TBL where [account] = @user order by SEQ desc)
						end
					else
						begin
							set @ret_lastip = '-'
						end
					
					select 'RetVal' = @user + '|' + @ret_cash + '|' + @ret_auth1 + '|' + @ret_regdate + '|' + 
					@ret_email + '|' + @ret_lastip
				end
			else
				begin
					select 'RetVal' = 0
				end
		end
	else if @action = 'GetCharacterFromAccount'
		begin
			if exists( select * from ACCOUNT_DBF.dbo.ACCOUNT_TBL where [account] = @user)
				begin
					select m_szName, isblock, MultiServer, m_nLevel from CHARACTER_01_DBF.dbo.CHARACTER_TBL where account = @user
				end
			else
				begin
					select 0
				end
		end
	else if @action = 'GetCharacterInfo'
		begin
			if exists (select * from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user )
				begin
					declare @ret_idPlayer varchar(7)
					declare @ret_status_onoff varchar(1)
					declare @ret_level varchar(3)
					declare @ret_job varchar(2)
					declare @ret_world varchar(4)
					declare @ret_pos_x varchar(20)
					declare @ret_pos_y varchar(20)
					declare @ret_pos_z varchar(20)
					declare @ret_isblock varchar(1)
					declare @ret_playerslot varchar(1)
					declare @ret_sex2 varchar(1)
					declare @ret_hp varchar(15)
					declare @ret_mp varchar(15)
					declare @ret_fp varchar(15)
					declare @ret_penya varchar(10)
					declare @ret_str varchar(7)
					declare @ret_sta varchar(7)
					declare @ret_dex varchar(7)
					declare @ret_int varchar(7)
					declare @ret_gp varchar(7)
					declare @ret_auth2 varchar(1)
					declare @ret_bankpw varchar(4)
					declare @ret_guild varchar(32)
					declare @ret_couple varchar(32)
					declare @ret_messenger varchar(5)
					declare @ret_account varchar(16)
					
					set @ret_idPlayer = (select m_idPlayer from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_status_onoff = (select MultiServer from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_level = (select m_nLevel from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_job = (select m_nJob from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_world = (select dwWorldID from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_pos_x = (select m_vPos_x from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_pos_y = (select m_vPos_y from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_pos_z = (select m_vPos_z from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_isblock = (select isblock from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_playerslot = (select playerslot from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_sex2 = (select m_dwSex from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_hp = (select m_nHitPoint from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_mp = (select m_nManaPoint from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_fp = (select m_nFatiguePoint from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_penya = (select m_dwGold from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_str = (select m_nStr from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_sta = (select m_nSta from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_dex = (select m_nDex from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_int = (select m_nInt from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_gp = (select m_nRemainGP from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_auth2 = (select m_chAuthority from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					set @ret_bankpw = (select m_BankPw from CHARACTER_01_DBF.dbo.BANK_TBL where m_idPlayer = @ret_idPlayer)
					set @ret_account = (select account from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_idPlayer = @ret_idPlayer)
					
					if exists (select * from CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL where m_idPlayer = @ret_idPlayer)
						begin
							set @ret_guild = (select m_szGuild from CHARACTER_01_DBF.dbo.GUILD_TBL where m_idGuild = (select m_idGuild from CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL where m_idPlayer = @ret_idPlayer))
						end
					else
						begin
							set @ret_guild = '-'
						end
					
					if exists (select * from CHARACTER_01_DBF.dbo.tblCouplePlayer where idPlayer = CONVERT(integer, @ret_idplayer))
						begin
							declare @ret_couple_partner varchar(7)
							set @ret_couple_partner = (select idPlayer from CHARACTER_01_DBF.dbo.tblCouplePlayer where cid = (select cid from CHARACTER_01_DBF.dbo.tblCouplePlayer where idPlayer = CONVERT( integer, @ret_idPlayer )) and idPlayer != CONVERT( integer, @ret_idPlayer ) )
							set @ret_couple = (select m_szName from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_idPlayer = RIGHT( '0000000'+ @ret_couple_partner, 7))
						end
					else
						begin
							set @ret_couple = '-'
						end
						
					set @ret_messenger = (select COUNT(*) from CHARACTER_01_DBF.dbo.tblMessenger where idPlayer = @ret_idplayer)
					
					select 'RetVal' = @user + ' (' + @ret_idPlayer + ')|' + @ret_status_onoff + '|' + @ret_level + '|' + @ret_job + '|' + @ret_world + '|' + 
					@ret_pos_x + '|' + @ret_pos_y + '|' + @ret_pos_z + '|' + @ret_isblock + '|' + @ret_playerslot + '|' + @ret_sex2 + '|' + @ret_hp + '|' + 
					@ret_mp + '|' + @ret_fp + '|' + @ret_penya + '|' + @ret_str + '|' + @ret_sta + '|' + @ret_dex + '|' + @ret_int + '|' + @ret_gp + '|' + 
					@ret_auth2 + '|' + @ret_bankpw + '|' + @ret_guild + '|' + @ret_couple + '|' + @ret_messenger + '|' + @ret_account + '|' + @ret_idPlayer
				end
			else
				begin
					select 'RetVal' = 0
				end
		end
	else if @action = 'GetCharacterMessenger'
		begin
			if exists( select * from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user )
				begin
					declare @ret_idPlayer2 varchar(7)
					set @ret_idPlayer2 = (select m_idPlayer from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
					select idFriend from CHARACTER_01_DBF.dbo.tblMessenger where idPlayer = @ret_idPlayer2
				end
			else
				begin
					select 0
				end
		end
	else if @action = 'GetCharacterNameViaID'
		begin
			if exists(select * from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_idPlayer = @user)
				begin
					select 'RetVal' = (select m_szName from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_idPlayer = @user )
				end
			else
				begin
					select 'RetVal' = '-';
				end
		end
	else if @action = 'GetCharacterIDViaName'
		begin
			if exists(select * from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user)
				begin
					select 'RetVal' = (select m_idPlayer from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user )
				end
			else
				begin
					select 'RetVal' = '-';
				end
		end
	else if @action = 'BackupDatabase'
		begin
			declare @path varchar(512)
			declare @path1 varchar(512)
			declare @path2 varchar(512)
			declare @path3 varchar(512)
			declare @path4 varchar(512)
			--declare @path5 text
			set @path = (select Val from [Config_Panel] where Col = 'BackupPath')
			set @path1 = @path + 'ACCOUNT_DBF.bak'
			set @path2 = @path + 'CHARACTER_01_DBF.bak'
			set @path3 = @path + 'WEBSITE_DBF.bak'
			set @path4 = @path + 'ADMINPANEL_DBF.bak'
			--set @path5 = @path + 'LOGGING_01_DBF.bak'
			BACKUP DATABASE [ACCOUNT_DBF] TO DISK = @path1 WITH NOFORMAT, NOINIT, NAME = N'ACCOUNT_DBF-Vollständig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD, STATS = 10
			BACKUP DATABASE [CHARACTER_01_DBF] TO DISK = @path2 WITH NOFORMAT, NOINIT, NAME = N'CHARACTER_01_DBF-Vollständig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD, STATS = 10
			BACKUP DATABASE [WEBSITE_DBF] TO DISK = @path3 WITH NOFORMAT, NOINIT, NAME = N'WEBSITE_DBF-Vollständig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD, STATS = 10
			BACKUP DATABASE [ADMINPANEL_DBF] TO DISK = @path4 WITH NOFORMAT, NOINIT, NAME = N'ADMINPANEL_DBF-Vollständig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD, STATS = 10
			--BACKUP DATABASE [LOGGING_01_DBF] TO DISK = @path5 WITH NOFORMAT, NOINIT, NAME = N'LOGGING_01_DBF-Vollständig Datenbank Sichern', SKIP, NOREWIND, NOUNLOAD, STATS = 10
			select 'RetVal' = '<div class="success">Datenbank Backup wurde erstellt!</div>'
		end
	else if @action = 'ClearLoggingDatabase'
		begin
			TRUNCATE TABLE LOGGING_01_DBF.dbo.CHARACTER_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_BILLING_ITEM_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_CHARACTER_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_DEATH_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_GUILD_BANK_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_GUILD_DISPERSION_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_GUILD_SERVICE_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_GUILD_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_GUILD_WAR_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_HONOR_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_INS_DUNGEON_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_ITEM_EVENT_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_ITEM_REMOVE_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_ITEM_SEND_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_ITEM_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_LEVELUP_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_PK_PVP_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_LOGIN_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_QUEST_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_RESPAWN_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_SKILL_FREQUENCY_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_SVRDOWN_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.LOG_UNIQUE_TBL
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblCampus_PointLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblCampusLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblChangeNameHistoryLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblChangeNameLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblGuildHouse_FurnitureLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblGuildHouseLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblLogExpBox
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblPetLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblQuestLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblQuizAnswerLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblQuizLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblQuizUserLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblSkillPointLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblSystemErrorLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblTradeDetailLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblTradeItemLog
			TRUNCATE TABLE LOGGING_01_DBF.dbo.tblTradeLog
			DBCC SHRINKDATABASE (LOGGING_01_DBF)
			select 'RetVal' = '<div class="success">Logging Datenbank wurde bereinigt!</div>'
		end
	else if @action = 'GetCharacterList'
		begin
			select * from CHARACTER_01_DBF.dbo.CHARACTER_TBL order by m_szName asc
		end
	else if @action = 'DeleteCharacter'
		begin
			update CHARACTER_01_DBF.dbo.CHARACTER_TBL set isblock = 'D' where m_szName = @user
			select 'RetVal' = '<div class="success">' + @user + ' wurde gelöscht.</div>'
		end
	else if @action = 'RestoreCharacter'
		begin
			update CHARACTER_01_DBF.dbo.CHARACTER_TBL set isblock = 'F' where m_szName = @user 
			select 'RetVal' = '<div class="success">' + @user + ' wurde wiederhergestellt.</div>'
		end
	else if @action = 'GetMaintenanceId'
		begin
			select COUNT(*) as RetVal from Maintenance where Account = @user
		end
	else if @action = 'SetMaintenance'
		begin
			if exists (select * from ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @user )
				begin
					if exists (select * from Maintenance where [Account] = @user and [IsMaintenance] = 1)
						begin
							Select 'RetVal' = '<div class="fail"><b>' + @user + '</b> ist bereits in der Wartung!</div>' 
						end
					else
						begin
							declare @maintenance_oldpass varchar(32)
							set @maintenance_oldpass = (select [password] from ACCOUNT_DBF.dbo.ACCOUNT_TBL where [account] = @user)
							insert into Maintenance( [Account], [OldPassword], [NewPassword], [NewPassword_Blank], [IsMaintenance], [Date] )
							values ( @user, @maintenance_oldpass, @maintenance_newpass, @maintenance_newpass_blank, 1, GETDATE() )
							update ACCOUNT_DBF.dbo.ACCOUNT_TBL set [password] = @maintenance_newpass, [id_no1] = @maintenance_newpass, [id_no2] = @maintenance_newpass where [account] = @user
							Select 'RetVal' = '<div class="success">Wartung von <b>' + @user + '</b> hat begonnen. Passwort lautet <b>' + @maintenance_newpass_blank + '</b></div>'
						end
				end
			else
				begin
					select 'RetVal' = '<div class="fail"><b>' + @user + '</b> existiert nicht!</div>'
				end
		end
	else if @action = 'RemMaintenance'
		begin
			if exists ( select * from Maintenance where [SEQ] = @maintenance_seq and [IsMaintenance] = 0)
				begin
					Select 'RetVal' = '<div class="fail">Diese SEQ Id ist nicht mehr in der Wartung!</div>' 
				end
			else
				begin
					declare @maintenance_oldpass2 varchar(32) 
					declare @maintenance_name varchar(16) 
					set @maintenance_oldpass2 = (select [OldPassword] from Maintenance where [SEQ] = @maintenance_seq)
					set @maintenance_name = (select [ACCOUNT] from Maintenance where [SEQ] = @maintenance_seq)
					update Maintenance set [IsMaintenance] = 0 where [SEQ] = @maintenance_seq
					update ACCOUNT_DBF.dbo.ACCOUNT_TBL set [password] = @maintenance_oldpass2, [id_no1] = @maintenance_oldpass2, [id_no2] = @maintenance_oldpass2 where [account] = @maintenance_name
					Select 'RetVal' = '<div class="success">Wartung von <b>' + @maintenance_name + '</b> beendet!</div>'
				end
		end
	else if @action = 'AddPSCCash'
		begin
			if exists (select * from WEBSITE_DBF.dbo.web_psclogs where pscid = @id and done = 0 )
				begin
					declare @cashworth int
					set @cashworth = (select val from config_psc where Col = (select worth from WEBSITE_DBF.dbo.web_psclogs where pscid = @id)) 
					update ACCOUNT_DBF.dbo.ACCOUNT_TBL set cash = ( cash + @cashworth )
					update WEBSITE_DBF.dbo.web_psclogs set done = 1 where pscid= @id
					select 'RetVal' = '1'
				end
			else
				begin
					select 'RetVal' = '0'
				end
		end
	else if @action = 'IsUserOnline'
		begin
			if exists (select * from CHARACTER_01_DBF.dbo.CHARACTER_TBL where m_szName = @user and MultiServer > 0)
				begin
					select 'RetVal' = '1';
				end
			else
				begin
					select 'RetVal' = '0';
				end
		end
END
Renndett-Violence is offline  
Old 11/02/2014, 16:45   #75
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2010
Posts: 5
Received Thanks: 0
Can help please?, ty

Quote:
Originally Posted by Renndett-Violence View Post
Here, try that.
Msg 468, Level 16, State 9, Procedure AdminPanel, Line 382
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Why? :/
Gabriel1943 is offline  
Reply
Page 5 of 6 « First 34 5 6

Tags
admin, backend, flyff, panel, sedrika

« [Release] Item Preise via character.inc | Flyff Monster ID´s,World,Set ID´s »

Similar Threads Similar Threads
[RELEASE] DAMNED FLYFF WEBSITE + BACKEND + DB
04/06/2012 - Flyff PServer Guides & Releases - 11 Replies
#fuckya
BF3 Backend Error
10/27/2011 - Battlefield - 0 Replies
Hallo, wenn ich auf einen server über den "battlelog" joinen will kommt bei mir der Backend Error beim Login... Da steht: "Game could not login to EA Online backend" Der fehler scheint bei kaum jemanden aufzutreten, da ich sonst nichts über Google finde, wie ich das Problem lösen könnte. Deswegen wollte ich hier einfach mal um hilfe bitte Danke schonmal im vorraus :)
HP-Script / Backend-Funktionen
10/18/2010 - Metin2 Private Server - 123 Replies
Huhu, ich bin momentan dabei ein HP-Script zu schreiben. Dabei möchte ich besonders auf das Admin-Backend eingehen, da grade dort viele Sachen, die momentan von vielen noch durch Navicat oder andere tools bearbeitet werden, ganz leicht über ein Webinterface bedienbar sein könnten. Deshalb möchte ich mal von erfahrenen Serveradmins hier wissen, was so für Funktionen fehlen, die im Kopf herumschwirren, aber bisher aufgrund mangelnder Kenntnisse oder vielleicht auch Zeit fehlen? Hab z.B....



All times are GMT +1. The time now is 15:10.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.