ALL Items 1.5 Sahar Database Query

[Developer]

Why Hello :) This is my FIRST Ever Release, and i'v been around here a long time, although i dont post often.
Since This is my Very First Release Ever, i figured i'd treat all the people that have been asking for a "Fast" Way of Putting all of the Items into the Database, Well...after about 3.5 Hours of Work, i have Finished These Two SQL Queries.

There are Two Seperate Files, Because i Seperated the AVATARS From the Rest of the Items, Idk why, its just how it ended up happening Lol

Here is a Little Guide for the people who dont know how to do this :D

So First Off, Download The Files
Second, Open up your SQL Studio Management Express.
Third, Connect and open your GunZ Database.
Drag and Drop Whichever of the Queries You want to Execute into your SQL Management Studio Express.
Fourth, After The Query Window Opens, Go to the TOP of the Query, to where it says

USE [GunzDB1.5]

Change "GunzDB1.5" to whatever your Gunz Database name is but you must KEEP the Brackets.

Most People Use "GunzDB". if so, put [GunzDB] ect

Last, Click Execute, wait for it to Finish, and your Done! Only Do 1 at a time :D

Even if Items are in your Database already and u just want to add new ones, you can still do this, because it will recognize the Duplicate and move on to the next.

Hope i Helped :D

PS: Oh and i Added Another one for you guys that have been having issues with the Sword Icon next to your name in game. :) Thank me if i helped ^^

Oh and BTW i also Used Virus Total and Posted the Info. Just Incase someone would think i'd upload something Malicious just because i have Low Post count lol.

Virus Total

SHA256: 155a84481b1e8f6a1decc0679d6b72dfc1dcec548784e3376e7f9549a712519d
SHA1: 6df486e3a6d39b16d3d665a3a8bcac0f7e4c2b0d
MD5: c7eda1a7748d40d7054a4f36b0e73699
File size: 8.5 KB ( 8671 bytes )
File name: ItemDB Query by Developer.zip
File type: ZIP
Detection ratio: 0 / 46
Analysis date: 2013-02-02 13:21:49 UTC ( 0 minutes ago )
0
0
Less details

Analysis
Comments
Votes
Additional information

Antivirus Result Update
Agnitum - 20130201
AhnLab-V3 - 20130202
AntiVir - 20130202
Antiy-AVL - 20130202
Avast - 20130202
AVG - 20130202
BitDefender - 20130202
ByteHero - 20130130
CAT-QuickHeal - 20130202
ClamAV - 20130202
Commtouch - 20130202
Comodo - 20130202
DrWeb - 20130202
Emsisoft - 20130202
eSafe - 20130131
ESET-NOD32 - 20130202
F-Prot - 20130201
F-Secure - 20130202
Fortinet - 20130202
GData - 20130202
Ikarus - 20130202
Jiangmin - 20121221
K7AntiVirus - 20130201
Kaspersky - 20130202
Kingsoft - 20130131
Malwarebytes - 20130202
McAfee - 20130202
McAfee-GW-Edition - 20130202
Microsoft - 20130202
MicroWorld-eScan - 20130202
NANO-Antivirus - 20130202
Norman - 20130202
nProtect - 20130201
Panda - 20130202
PCTools - 20130202
Rising - 20130201
Sophos - 20130202
SUPERAntiSpyware - 20130202
Symantec - 20130202
TheHacker - 20130131
TotalDefense - 20130201
TrendMicro - 20130202
TrendMicro-HouseCall - 20130202
VBA32 - 20130201
VIPRE - 20130202
ViRobot - 20130202

[MentaL]

[Chrisss]

Err, thanks I guess. Quick question tho, don't know if u can answer this but is there any way I can change the sword icon next to name to something else?

[Developer]

Err, thanks I guess. Quick question tho, don't know if u can answer this but is there any way I can change the sword icon next to name to something else?

Yes u can, if you Decompile your Interface.mrs Go into the Folder the folder the Decompiler makes Interface> Default, Find the Picture named "Interface"

its the VERY First Tiny Blue Dagger on the Left side of the pic :D i suggest u keep w/e u want to put there that size, otherwise it might not show :(

[Chrisss]

Yes u can, if you Decompile your Interface.mrs Go into the Folder the folder the Decompiler makes Interface> Default, Find the Picture named "Interface"

its the VERY First Tiny Blue Dagger on the Left side of the pic :D i suggest u keep w/e u want to put there that size, otherwise it might not show :(

Ahh right, thank you.

[I Am NoLimiT]

i also use sahar source and emisands db.but when i remove serial key on mssql2k5 all items work dont need to add any queries for dbo.items

just try to remove serial key on dbo.account / modify and then right click and all items from sahar source will automatically added on your database,.

[Chrisss]

i also use sahar source and emisands db.but when i remove serial key on mssql2k5 all items work dont need to add any queries for dbo.items

just try to remove serial key on dbo.account / modify and then right click and all items from sahar source will automatically added on your database,.

No it don't.