Share _ItemName + Item Plus Notice & Website

Page 1 of 2 1 2
02/11/2019 19:56 NorseGodTyr#1
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 )

Quote:
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
02/11/2019 21:24 Dracula Untold#2
well done
02/11/2019 22:10 Leodoom#3
Can you explain to me what this means? Are you going to add it to the game site to show it?
Or what?
02/12/2019 06:34 NorseGodTyr#4
Quote:
Originally Posted by Leodoom View Post
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

[Only registered and activated users can see links. Click Here To Register...]
CodeName128
[Only registered and activated users can see links. Click Here To Register...] 		[Only registered and activated users can see links. Click Here To Register...]
Name
[Only registered and activated users can see links. Click Here To Register...]
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
[Only registered and activated users can see links. Click Here To Register...]
02/12/2019 11:01 Leodoom#5
Very cool and thank you for this but you can show me how to show it on my site
02/12/2019 11:20 NorseGodTyr#6
Quote:
Originally Posted by Leodoom View Post
Very cool and thank you for this but you can show me how to show it on my site
an example from my website
Quote:
//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'];
}
02/12/2019 16:13 m1xawy#7
nice
02/12/2019 16:51 Laag#82#8
link website : [Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
02/12/2019 17:40 Leodoom#9
thanks
02/12/2019 18:15 Devsome#10
Quote:
Originally Posted by NorseGodTyr View Post
an example from my website

Code:
$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
02/12/2019 20:19 !Apple#11
Very Job
02/12/2019 22:07 NorseGodTyr#12
Quote:
Originally Posted by khaleed2010 View Post
link website : [Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
this web have much bugs you have to spend alot of time to fix it ;)
and not all items added to the page

Quote:
Originally Posted by Devsome View Post
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
02/14/2019 23:27 Devsome#13
Quote:
Originally Posted by NorseGodTyr View Post
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.
02/15/2019 14:05 NorseGodTyr#14
Quote:
Originally Posted by Devsome View Post
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 :)
02/15/2019 20:07 Devsome#15
Quote:
Originally Posted by NorseGodTyr View Post
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 [Only registered and activated users can see links. Click Here To Register...] da baut man nicht noch extra sowas ein.
Page 1 of 2 1 2