[Release] Simple Clan Emblem Changer in DB
Go to your database and create a new query
Code:
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[ClanEmblemUpload] Script Date: 05/16/2008 14:53:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- 캐릭터 이름 변경
CREATE PROC [dbo].[ClanEmblemUpload]
@Checksum int,
@CLID int,
@URL varchar(24)
AS
SET NOCOUNT ON
IF (LEN(@URL) <= 0) OR (LEN(@URL) > 12)
BEGIN
SELECT 0 AS Ret
END
IF EXISTS (SELECT TOP 1 CLID FROM Clan where (EmblemURL=@URL) AND (DeleteFlag=0))
BEGIN
SELECT 0 AS Ret
return (-1)
END
UPDATE Clan SET EmblemURL=@URL WHERE CLID=@CLID
IF 0 = @@ROWCOUNT BEGIN
SELECT 0 AS Ret
RETURN (-1)
END
UPDATE Clan SET EmblemChecksum=@Checksum WHERE CLID=@CLID
IF 0 = @@ROWCOUNT BEGIN
SELECT 0 AS Ret
RETURN (-1)
END
SELECT 1 AS Ret
Checksum: 1 = show emblem, 0 = don't show emblem.
URL = URL to emblem.
CLID = Clan ID.
http://forum.ragezone.com/showthread...ht=clan+emblem
Re: [Release] Simple Clan Emblem Changer in DB
Re: [Release] Simple Clan Emblem Changer in DB
Re: [Release] Simple Clan Emblem Changer in DB
Re: [Release] Simple Clan Emblem Changer in DB
How simple is this clan emblem?
Re: [Release] Simple Clan Emblem Changer in DB
u need to upload clan emblem and a enter this link in the url in 'URL = URL to emblem.'
Re: [Release] Simple Clan Emblem Changer in DB
Yeah.
I made this because I hated going through 200 clans to find the clan I wanted to add emblems too.
Rotana's clan uploader didn't work for me.
Re: [Release] Simple Clan Emblem Changer in DB
Re: [Release] Simple Clan Emblem Changer in DB
Ty but, now all the clans have the same emblem.
does anyon have a link of a clem emblem uploader"?
Re: [Release] Simple Clan Emblem Changer in DB
Why do noobs keep bumping threads from longer then 2 weeks.