[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

NIce XD 1st Post XD

Thanks!

cool o.o nice

How simple is this clan emblem?

u need to upload clan emblem and a enter this link in the url in 'URL = URL to emblem.'

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.

Good Job Legacy. Thanx

Ty but, now all the clans have the same emblem.
does anyon have a link of a clem emblem uploader"?

Why do noobs keep bumping threads from longer then 2 weeks.