Clan Emblem

[::.kakashi.::]

Hey, clan emblem wont show ingame how fixe?

[MentaL]

[Phoenix]

Where are your emblems located? Give the complete directory of it and show me your system.xml.

[::.kakashi.::]

<?xml version="1.0" ?>
<XML>
<XMLHEADER>version="1.0"</XMLHEADER>

<SKIN>Default</SKIN>

<DEFFONT>Arial</DEFFONT>

<IME>false</IME>

<BAREPORT>
<ADDR>www.battlearena.com</ADDR>
<DIR>incoming/gunz_US</DIR>
</BAREPORT>

<EMBLEM_URL>http://75.**.***.***/killergunz/Emblems/</EMBLEM_URL>
<TEMBLEM_URL>http://75.**.***.***/killergunz/Emblems</TEMBLEM_URL>

<CASHSHOP_URL>http://75.**.***.***/</CASHSHOP_URL>

<HOMEPAGE>
<URL>http://75.**.***.***</URL>
<TITLE>GunZ the Duel</TITLE>
</HOMEPAGE>

<LOCATORLIST>
<LOCATOR id="1" IP="75.**.***.***" />

</LOCATORLIST>

<TLOCATORLIST>
<LOCATOR id="1" IP="75.**.***.***" />

</TLOCATORLIST>
</XML>

Emblem located here : Web Site Currently Not Available

[Phoenix]

Tell me how exactly the EmblemURL is, in the database. Also, change the TEMBLEM part in the system.mrs to this:

<TEMBLEM_URL>http://75.**.***.***/killergunz/Emblems/</TEMBLEM_URL>

[::.kakashi.::]

Euh in DB the URL is "Emblem/hd-wallpaper-glow1.jpg"

[Phoenix]

Wait, is the folder named 'Emblem' or 'Emblems'? Also, does your database URL look like "Emblem/hd-wallpaper-glow1.jpg" or "/Emblem/hd-wallpaper-glow1.jpg"? Is there a / before Emblem?

[::.kakashi.::]

Wait, is the folder named 'Emblem' or 'Emblems'? Also, does your database URL look like "Emblem/hd-wallpaper-glow1.jpg" or "/Emblem/hd-wallpaper-glow1.jpg"? Is there a / before Emblem?

The folder name is 'emblems'
The database name is 'Emblem/hd-wallpaper' i copy past so they are not / befor emblem

[Phoenix]

Please change your folder's name to 'Emblem' and use this system.xml:

<?xml version="1.0" ?>
<XML>
<XMLHEADER>version="1.0"</XMLHEADER>

<SKIN>Default</SKIN>

<DEFFONT>Arial</DEFFONT>

<IME>false</IME>

<BAREPORT>
<ADDR>www.battlearena.com</ADDR>
<DIR>incoming/gunz_US</DIR>
</BAREPORT>

<EMBLEM_URL>http://75.**.***.***/killergunz/Emblem/</EMBLEM_URL>
<TEMBLEM_URL>http://75.**.***.***/killergunz/Emblem/</TEMBLEM_URL>

<CASHSHOP_URL>http://75.**.***.***/</CASHSHOP_URL>

<HOMEPAGE>
<URL>http://75.**.***.***</URL>
<TITLE>GunZ the Duel</TITLE>
</HOMEPAGE>

<LOCATORLIST>
<LOCATOR id="1" IP="75.**.***.***" />

</LOCATORLIST>

<TLOCATORLIST>
<LOCATOR id="1" IP="75.**.***.***" />

</TLOCATORLIST>
</XML>

And also, execute this on your database:

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

If it already exists, no problem.

[::.kakashi.::]

Edit : Oups wait the first Emblem was Old :/
so in db its say direct name of Emblem exmple : '75.jpg' :(

sorry :/

[Phoenix]

Then use this system.xml

<?xml version="1.0" ?>
<XML>
<XMLHEADER>version="1.0"</XMLHEADER>

<SKIN>Default</SKIN>

<DEFFONT>Arial</DEFFONT>

<IME>false</IME>

<BAREPORT>
<ADDR>www.battlearena.com</ADDR>
<DIR>incoming/gunz_US</DIR>
</BAREPORT>

<EMBLEM_URL>http://75.**.***.***/killergunz/Emblems/</EMBLEM_URL>
<TEMBLEM_URL>http://75.**.***.***/killergunz/Emblems/</TEMBLEM_URL>

<CASHSHOP_URL>http://75.**.***.***/</CASHSHOP_URL>

<HOMEPAGE>
<URL>http://75.**.***.***</URL>
<TITLE>GunZ the Duel</TITLE>
</HOMEPAGE>

<LOCATORLIST>
<LOCATOR id="1" IP="75.**.***.***" />

</LOCATORLIST>

<TLOCATORLIST>
<LOCATOR id="1" IP="75.**.***.***" />

</TLOCATORLIST>
</XML>

and let your folder's name be 'Emblems' (like how it is currently).

[::.kakashi.::]

Thanks but i need to do ur query also? "And also, execute this on your database"

[Phoenix]

Yeah, just execute it. If you get any error, don't bother about it.
So finally, your emblems' folder name is supposed to be 'Emblems' and your system.xml is supposed to be what I posted above. Upload a fresh emblem and wait for a while for it to show. Or else, check your DB's URL and post it here.