[Release]Item Code Finder By Hawasman

08/01/2012 15:14 M>M#1
Hi every body,

I know that MuStA has released his program but it's very slow and lagy

so i made my own 1000% faster than MuStA's program

i hope he don't Get MAD form me :p

INFO :

1.the program is faster this time

2.it can save your search result in a text file

3.you can search ID or Value in it

4.you can copy the item ID from the Datagridview
by clicking Right mouse click

Screen Shoot :

[Only registered and activated users can see links. Click Here To Register...]

Download :

[Only registered and activated users can see links. Click Here To Register...]

that is all and i hope you like it

and for Xijezu : yes it's coded in VB.NET
and for MuStA : hope you are not mad from me man :D

Edit:
updated link and fixed my fail :D

Greets,
HawasMan
08/01/2012 15:18 Musta²#2
lol, why the hell would i get mad,

nice program^^.

Regards,

MuStA.
08/01/2012 15:24 Tofrum#3
why no For Tofrum: You Can Share

and please change "made" to "mad"
08/01/2012 15:27 M>M#4
Quote:
Originally Posted by [Co-Admin]Tofrum View Post
why no For Tofrum: You Can Share

and please change "made" to "mad"
Tofrum: You Can Share
08/01/2012 15:27 c1ph3r#5
Extraction of your code:
Code:
USE Arcadia SELECT id, StringResource.value FROM Arcadia.dbo.ItemResource LEFT JOIN Arcadia.dbo.StringResource ON name_id = StringResource.code WHERE Value like N'%" + this.TextBox1.Text + "%'
Why there is an option to select the database if it's hardcoded öÖ


Don't want to offend you but i don't see the sense for writing one tool for a simple SQL Statement. But it's good for those who can't work with SQL Statements till now.
08/01/2012 15:32 haxti#6
the codee: alright this is.awesome..i'll just create a new tool for every fucking query you could ever need.

the leecher: this is awesome. i'm the best dev cause i have AWL TEH TOOLZ. and i dont need to learn the fucking basics of sql...
08/01/2012 15:36 Tofrum#7
added
08/01/2012 15:58 Musta²#8
Quote:
Originally Posted by c1ph3r View Post
Extraction of your code:
Code:
USE Arcadia SELECT id, StringResource.value FROM Arcadia.dbo.ItemResource LEFT JOIN Arcadia.dbo.StringResource ON name_id = StringResource.code WHERE Value like N'%" + this.TextBox1.Text + "%'
Why there is an option to select the database if it's hardcoded öÖ


Don't want to offend you but i don't see the sense for writing one tool for a simple SQL Statement. But it's good for those who can't work with SQL Statements till now.
It should be like this ..

Code:
"USE " + class1.database + "  SELECT id, StringResource.value FROM Arcadia.dbo.ItemResource LEFT JOIN Arcadia.dbo.StringResource ON name_id = StringResource.code WHERE Value like N'%" + this.TextBox1.Text + "%'"
Or if you don't use classes, and use settings :

Code:
"USE " + Settings1.database + "  SELECT id, StringResource.value FROM Arcadia.dbo.ItemResource LEFT JOIN Arcadia.dbo.StringResource ON name_id = StringResource.code WHERE Value like N'%" + this.TextBox1.Text + "%'"
Just an example, you should know what to change^^
08/01/2012 16:15 c1ph3r#9
Quote:
Originally Posted by MuStA2222 View Post
It should be like this ..

Code:
"USE " + class1.database + "  SELECT id, StringResource.value FROM Arcadia.dbo.ItemResource LEFT JOIN Arcadia.dbo.StringResource ON name_id = StringResource.code WHERE Value like N'%" + this.TextBox1.Text + "%'"
Or if you don't use classes, and use settings :

Code:
"USE " + Settings1.database + "  SELECT id, StringResource.value FROM Arcadia.dbo.ItemResource LEFT JOIN Arcadia.dbo.StringResource ON name_id = StringResource.code WHERE Value like N'%" + this.TextBox1.Text + "%'"
Just an example, you should know what to change^^
Simply remove the use Arcadia...it's enough because he declares the DataSource in the SQL Connection.
08/01/2012 16:34 gruce#10
Nice
08/01/2012 16:48 M>M#11
Quote:
Originally Posted by c1ph3r View Post
Extraction of your code:
Code:
USE Arcadia SELECT id, StringResource.value FROM Arcadia.dbo.ItemResource LEFT JOIN Arcadia.dbo.StringResource ON name_id = StringResource.code WHERE Value like N'%" + this.TextBox1.Text + "%'
Why there is an option to select the database if it's hardcoded öÖ


Don't want to offend you but i don't see the sense for writing one tool for a simple SQL Statement. But it's good for those who can't work with SQL Statements till now.
oh sorry i forget to change it

i just took it form an old program i made :p

Quote:
Originally Posted by [Co-Admin]Tofrum View Post
added
re add it with the new link :P

and next time i release some thin add it if you want to your RDC ;)
08/01/2012 18:41 Modamer9#12
nice job my freinds
07/07/2018 10:01 WOLF2009#13
Invalid or Deleted File.

The key you provided for file access was invalid. This is usually caused because the file is no longer stored on MediaFire. This occurs when the file is removed by the originating user or MediaFire.

Still have questions, or think we've made a mistake? Please contact support for further assistance.
07/07/2018 14:11 ThunderNikk#14
@[Only registered and activated users can see links. Click Here To Register...] Please check post dates.