How to seach for characters.

roflmaopmp · 11/15/2009, 06:41

Ya, well I'm a COMPLETE SQL newb, so someone is gonna have to teach me how to search for characters, in user_character if that is even the one I use to change name/level/whatever else. :x

Thanks you.

janvier123 · 11/15/2009, 07:27

install OsDs Cp, you have everything you need for your server
Link is in my signature

roflmaopmp · 11/15/2009, 07:29

Uh huh, I'll give it a shot I guess. :x

... But can I just attach it to my already existing MSSQL? :x Like, I just did silkbotters 1 click server, and then how do I get this to work with it?

Or can I search without the OsDs control panel?

janvier123 · 11/15/2009, 07:43

yes, osds cp has his own database, no edits needed
and you can use it with silkbotters 1 click server
or you can use MSSQL's editor

roflmaopmp · 11/15/2009, 07:53

Hey, can you give me a quick run down on how to attach your OsDs Control Panel to my MSSQL. I'm lost haha.

Thanks in advance.

Ironica · 11/15/2009, 07:59

right click/query rows

then click name and in criteria type in the name u want to find then click run.

roflmaopmp · 11/15/2009, 08:10

EDIT: Nevermind! My ***, I took my time! But I found it.

Zombe · 11/15/2009, 09:19

SELECT * FROM character.dbo.user_character WHERE character_name = 'Your_Name;

or you could always use the Enterprise Manager...

slikbotter · 11/15/2009, 10:02

Quote:

Originally Posted by BiqD

wtf is this lol
report

Bigshow107 · 11/15/2009, 12:03

#9 reported for multitime spamming same link :

he posted it 93 time lol