Share _ItemName + Item Plus Notice & Website

[NorseGodTyr]

Hey epvp
Share my _ItemName Table from my website and PlusNotice
12533 items Added with Name

Execute query and add all line from text file (Added in attachment )

USE [SRO_VT_SHARDLOG]
GO

-- =============================================
-- Author: Valtyr
-- =============================================

/****** Object: Table [dbo].[_ItemName] Script Date: 11.02.2019 19:46:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_ItemName](
[CodeName128] [varchar](50) NOT NULL,
[Name] [varchar](500) NOT NULL
) ON [PRIMARY]
GO

[Dracula Untold]

well done

[Leodoom]

Can you explain to me what this means? Are you going to add it to the game site to show it?
Or what?

[NorseGodTyr]

Originally Posted by Leodoom

Can you explain to me what this means? Are you going to add it to the game site to show it?
Or what?

you can use this for Plus Notice & Website
i Have added every CodeName128 with linked name example

CodeName128	Name
ITEM_CH_SWORD_01_C_RARE	Copper Sword
ITEM_ETC_HP_POTION_03	HP Recovery Potion (Medium)
ITEM_ETC_HP_POTION_05	HP Recovery Potion (X-Large)
ITEM_ETC_MP_POTION_03	MP Recovery Potion (Medium)
ITEM_ETC_MP_POTION_05	MP Recovery Potion (X-Large)
ITEM_ETC_ALL_POTION_03	Vigor Recovery Potion (Medium)
ITEM_ETC_ALL_POTION_05	Vigor Recovery Potion (X-Large)
ITEM_ETC_GUILD_CREST_USER	Guild emblem registration [B]ITEM
ITEM_ETC_GUILD_CREST_DELETE	Guild emblem deletion [B]ITEM
ITEM_ETC_UNION_CREST_USER	Union emblem registration [B]ITEM
ITEM_ETC_UNION_CREST_DELETE	Union emblem deletion [B]ITEM
ITEM_ETC_GUILD_CH_SOLDIER2_SCROLL	Heuksal mercenary scroll
ITEM_ETC_GUILD_CH_SOLDIER3_SCROLL	Pacheon mercenary scroll
ITEM_ETC_GUILD_CH_SOLDIER4_SCROLL	Cold mercenary scroll
ITEM_ETC_GUILD_CH_SOLDIER5_SCROLL	Lightning mercenary scroll
ITEM_ETC_GUILD_CH_SOLDIER6_SCROLL	Fire mercenary scroll
ITEM_ETC_GUILD_EU_SOLDIER1_SCROLL	One-hand Sword Mercenary Scroll
ITEM_ETC_GUILD_EU_SOLDIER2_SCROLL	Two-hand Sword Mercenary Scroll
ITEM_ETC_GUILD_EU_SOLDIER3_SCROLL	Dual Axe Mercenary Scroll
ITEM_ETC_GUILD_EU_SOLDIER4_SCROLL	Dagger Mercenary Scroll
ITEM_ETC_GUILD_EU_SOLDIER5_SCROLL	Crossbow Mercenary Scroll
ITEM_ETC_GUILD_EU_SOLDIER6_SCROLL	Earth Mercenary Scroll
ITEM_ETC_GUILD_EU_SOLDIER7_SCROLL	Cold Mercenary Scroll
ITEM_ETC_GUILD_EU_SOLDIER8_SCROLL	Fire Mercenary Scroll
ITEM_ETC_GUILD_EU_SOLDIER9_SCROLL	Lightning Mercenary Scroll
ITEM_ETC_GUILD_RECALL	Guild Member Summon Scroll
ITEM_ETC_WARENETWORK_EVENT	Merchant's Blessing
ITEM_MALL_PREMIUM_GLOBAL_SILVERTIME	Premium Silver Time (4 weeks)
ITEM_MALL_PREMIUM_GLOBAL_GOLDTIME_BEGINNER	Beginner Premium GoldTime
ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS	Premium GoldTime PLUS
ITEM_MALL_AVATAR_M_GHOST_CAPTAIN_HAT	Ghost Captain Hat 2013M
ITEM_MALL_AVATAR_W_GHOST_CAPTAIN_HAT	Ghost Captain Hat 2013 F
ITEM_MALL_AVATAR_M_GHOST_CAPTAIN	Ghost Captain Dress 2013 M
ITEM_MALL_AVATAR_W_GHOST_CAPTAIN	Ghost Captain Dress 2013 F
ITEM_MALL_AVATAR_M_GHOST_CAPTAIN_ATTACH	Ghost Captain Accessory 2013 M
ITEM_MALL_AVATAR_W_GHOST_CAPTAIN_ATTACH	Ghost Captain Accessory 2013 F
ITEM_MALL_AVATAR_M_MONSTER_2013_HAT	Pressure shard Shogun Helmet M
ITEM_MALL_AVATAR_W_MONSTER_2013_HAT	Pressure shard Shogun Helmet F
ITEM_MALL_AVATAR_M_MONSTER_2013	Warlord armor shard pressure M
ITEM_MALL_AVATAR_W_MONSTER_2013	Warlord armor shard pressure F
ITEM_MALL_AVATAR_M_MONSTER_2013_ATTACH	Warlord shard pressure fittings M
ITEM_MALL_AVATAR_W_MONSTER_2013_ATTACH	Warlord shard pressure fittings F
ITEM_MALL_AVATAR_M_WATERSPIRIT_2013_HAT	Water Spirit M
ITEM_MALL_AVATAR_W_WATERSPIRIT_2013_HAT	Water Spirit Helm F
ITEM_MALL_AVATAR_M_WATERSPIRIT_2013	Water Spirit Armor M
ITEM_MALL_AVATAR_W_WATERSPIRIT_2013	Water Spirit Armor F
ITEM_MALL_AVATAR_M_WATERSPIRIT_2013_ATTACH	Water Spirit Accessory M
ITEM_MALL_AVATAR_W_WATERSPIRIT_2013_ATTACH	Water Spirit Accessory F
ITEM_MALL_AVATAR_M_ARABIA_2013_HAT	Jade Shadow Raider Helm (M
ITEM_MALL_AVATAR_W_ARABIA_2013_HAT	Jade Shadow Raider Helm F
ITEM_MALL_AVATAR_M_ARABIA_2013	Jade Shadow Raider Armor M
ITEM_MALL_AVATAR_W_ARABIA_2013	Jade Shadow Raider Armor F
ITEM_MALL_AVATAR_M_ARABIA_2013_ATTACH	Jade Shadow Raider Accessory M
ITEM_MALL_AVATAR_W_ARABIA_2013_ATTACH	Jade Shadow Raider Accessory F
ITEM_MALL_AVATAR_M_AKATSUKI_ATTACH	Hidan Oz M
ITEM_MALL_AVATAR_W_AKATSUKI_ATTACH	Hidan Oz F
ITEM_MALL_AVATAR_M_SULTAN_WHITE_HAT	White Sultan Hat M
ITEM_MALL_AVATAR_W_SULTAN_WHITE_HAT	White Sultan Hat F
ITEM_MALL_AVATAR_M_GUARDIANNGAKPG_HAT	Guardian Spirit Hat M
ITEM_MALL_AVATAR_W_GUARDIANNGAKPG_HAT	Guardian Spirit Hat F
ITEM_MALL_AVATAR_M_GUARDIANNGAKPG	Guardian Spirit Dress M
ITEM_MALL_AVATAR_W_GUARDIANNGAKPG	Guardian Spirit Dress F
ITEM_MALL_AVATAR_M_NGAKPG_NEW_DEVIL	Blue Scourge Armor M
ITEM_MALL_AVATAR_W_NGAKPG_NEW_DEVIL	Blue Scourge Armor F

and on website looks like so

[Leodoom]

Very cool and thank you for this but you can show me how to show it on my site

[NorseGodTyr]

Originally Posted by Leodoom

Very cool and thank you for this but you can show me how to show it on my site

an example from my website

//Get info from RefObjCommon
$getItemRef = $sql->query("SELECT * FROM $dbs[SHARD].._RefObjCommon WHERE ID = '$fetchGetItem[RefItemID]'");
$fetchGetItemRef = $sql->QueryFetchArray($getItemRef);

//Row from Refobjitem
$getInfo = $sql->query("SELECT * FROM $dbs[SHARD].._RefObjItem WHERE ID = '$fetchGetItemRef[Link]'");
$fetchGetInfo = $sql->QueryFetchArray($getInfo);

//Default
$names = "Unkkown";

//ReqLevel
$ReqLevel = $fetchGetItemRef['ReqLevel1'];

//MaxMagicOption
$MaxMagic = $fetchGetInfo['MaxMagicOptCount'];

//MaxStack
$MaxStack = $fetchGetInfo['MaxStack'];

//Amount of the item
$Amount = $fetchGetItem['Data'];

//Codename
$Code = $fetchGetItemRef['CodeName128'];
//fetch real names
$name = $sql->query("SELECT TOP 1 * FROM $dbs[WEB]..[_RefNames] WHERE Item_Code ='$fetchGetItemRef[NameStrID128]'");

if($Data = $sql->QueryFetchArray($name)) {
//Name
$names = $Data['Item_Name'];
} else {
//Codename
$names = $fetchGetItemRef['NameStrID128'];
}

[m1xawy]

nice

[Laag#82]

link website :

[Leodoom]

thanks

[Devsome]

Originally Posted by NorseGodTyr

an example from my website

$name = $sql->query("SELECT TOP 1 * FROM $dbs[WEB]..[_RefNames] WHERE Item_Code ='$fetchGetItemRef[NameStrID128]'");

why not creating a array instead of a second query for getting the item name.
Or at least create a join to get it

[!Apple]

Very Job

[NorseGodTyr]

Originally Posted by khaleed2010

link website :

this web have much bugs you have to spend alot of time to fix it
and not all items added to the page

Originally Posted by Devsome

why not creating a array instead of a second query for getting the item name.
Or at least create a join to get it

hab die webseite nicht geschrieben gehabt hab nur
vieles gefixt und neu hinzugefügt

[Devsome]

Originally Posted by NorseGodTyr

this web have much bugs you have to spend alot of time to fix it
and not all items added to the page



hab die webseite nicht geschrieben gehabt hab nur
vieles gefixt und neu hinzugefügt

Anstatt alles zu fixen, schreib eine eigene von null auf.

[NorseGodTyr]

Originally Posted by Devsome

Anstatt alles zu fixen, schreib eine eigene von null auf.

wozu ?
ich fand das style allgemein gut und die funktionen zu fixen war jetzt auch nicht allzu schwer und das ranking hab ich auch schnell hinbekommen genauso wie den phpmailer zu fixen etc und mit der webseite bin ich jetzt ca 2 jahre Online ohne Probleme

[Devsome]

Originally Posted by NorseGodTyr

wozu ?
ich fand das style allgemein gut und die funktionen zu fixen war jetzt auch nicht allzu schwer und das ranking hab ich auch schnell hinbekommen genauso wie den phpmailer zu fixen etc und mit der webseite bin ich jetzt ca 2 jahre Online ohne Probleme

Was ich nicht ganz verstehe, warum du dann auf jeder Seite ein Loading eingebaut hast.
Die Seite lädt an sich schon mega lange da baut man nicht noch extra sowas ein.