Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 16:53

  • Please register to post and access all features, it's quick, easy and FREE!


How to make a query on character.dbo.user_character SQL server.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2008
Posts: 1,221
Received Thanks: 561
How to make a query on character.dbo.user_character SQL server.

Hello,

I found that GM fix. but doesnt work for me i make a character with a error.
can any ppl help me?



conquer93 is offline  
Old 04/19/2009, 23:35   #2
 
elite*gold: 0
Join Date: Feb 2009
Posts: 14
Received Thanks: 0
He wants to make a query on character.dbo.user_character to find all characters names with theis criteria <']'
Help ^^


florida18 is offline  
Old 04/19/2009, 23:44   #3
 
elite*gold: 0
Join Date: May 2008
Posts: 215
Received Thanks: 38
Create a new Job in SQL Server Agent ( Open Enterprise Manager --> Your SQL Server --> Managment --> SQL Server Agent --> Jobs )
right click --> New Job...

Name : Set Coins
Go to Steps --> New -->
Step name : Set Coins 1
Type : TSQL
Database : cash
Command :
Code:
DELETE FROM character.dbo.user_character
WHERE character_name < ']'
AND character_name <> '[GM]Your Character Name'
AND character_name <> '[GM]Your Character Name'
If you need more GMs , you can add more lines with
Code:
AND character_name <> '[GM]Your Character Name'
Go to Advanced -->
On success / failure flow : "Goto the step next step
On failure action : "Goto the next step"

Press Apply ---> OK

Press again to New...
Step name : Set Coins 2
Type : TSQL
Database : cash
Command :
Code:
Must be the self code who you have used in Step 1
Go to Advanced -->
On success / failure flow : "Goto step : [1]Set Coins 1"
On failure action : "Goto step : [1] Set Coins 1"
Press Apply --> OK


Go to Schedules --> New Schedule... -->
Name : Start set Coins
Set -> Start automatically when SQL Server Agent starts
Press OK
Press OK again
Press Yes

Right click to the Job in the list and start Job.


Dont forget to add the automatically start service SQL Server Agent in SQL Status Menu in your Taskbar.
PapaHarni is offline  
Old 04/19/2009, 23:46   #4
 
elite*gold: 0
Join Date: Oct 2008
Posts: 1,221
Received Thanks: 561
Quote:
Originally Posted by PapaHarni View Post
Create a new Job in SQL Server Agent ( Open Enterprise Manager --> Your SQL Server --> Managment --> SQL Server Agent --> Jobs )
right click --> New Job...

Name : Set Coins
Go to Steps --> New -->
Step name : Set Coins 1
Type : TSQL
Database : cash
Command :
Code:
DELETE FROM character.dbo.user_character
WHERE character_name < ']'
AND character_name <> '[GM]Your Character Name'
AND character_name <> '[GM]Your Character Name'
If you need more GMs , you can add more lines with
Code:
AND character_name <> '[GM]Your Character Name'
Go to Advanced -->
On success / failure flow : "Goto the step next step
On failure action : "Goto the next step"

Press Apply ---> OK

Press again to New...
Step name : Set Coins 2
Type : TSQL
Database : cash
Command :
Code:
Must be the self code who you have used in Step 1
Go to Advanced -->
On success / failure flow : "Goto step : [1]Set Coins 1"
On failure action : "Goto step : [1] Set Coins 1"
Press Apply --> OK


Go to Schedules --> New Schedule... -->
Name : Start set Coins
Set -> Start automatically when SQL Server Agent starts
Press OK
Press OK again
Press Yes

Right click to the Job in the list and start Job.


Dont forget to add the automatically start service SQL Server Agent in SQL Status Menu in your Taskbar.
Hi

I have no account i cant make a account. i cant run job's


conquer93 is offline  
Old 04/19/2009, 23:52   #5
 
elite*gold: 0
Join Date: Feb 2009
Posts: 14
Received Thanks: 0
He ran a command to delete all <']'
without changing the data first, so now he has no account. so everything lost? lol
florida18 is offline  
Old 04/19/2009, 23:55   #6
 
elite*gold: 0
Join Date: Oct 2008
Posts: 1,221
Received Thanks: 561
Quote:
Originally Posted by florida18 View Post
He ran a command to delete all <']'
without changing the data first, so now he has no account. so everything lost? lol
No i make a new server. and now i have no GM char. I cant make a another. its give a error with no message and my server says : error hack or somthings
conquer93 is offline  
Old 04/20/2009, 06:31   #7
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
Quote:
Originally Posted by conquer93 View Post
No i make a new server. and now i have no GM char. I cant make a another. its give a error with no message and my server says : error hack or somthings
Dude I said you to restore database again, and do everything from the beginning, cause you can't restore deleted chars.
gedimazs is offline  
Old 04/20/2009, 08:21   #8
 
elite*gold: 0
Join Date: Oct 2008
Posts: 1,221
Received Thanks: 561
i run that script and it says this

conquer93 is offline  
Old 04/20/2009, 12:47   #9
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
Quote:
Originally Posted by conquer93 View Post
i run that script and it says this

This is because you ran the script without changing names who could not allowed to delete. First you need to change all names with criteria "<]" And only then run the script. Now you can restore your DB and start over again. Good luck


gedimazs is offline  
Reply



« [Help] CastServer | Clients? »

Similar Threads
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY!
08/18/2010 - Metin2 PServer - Discussions / Questions - 1 Replies
Ich weiß ich werd nervig aber ich suche die Query's für Alteklinge, Reichsklinge &' Strichdolche Why? Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab ... not more -.- Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur...
[HELP]How to make a query
05/14/2010 - EO PServer Hosting - 3 Replies
................ no need now
Problem at user_character
02/13/2010 - Dekaron Private Server - 9 Replies
I created my own server but I cant be "GM" me because there are more than 8000 players info in user_character and I can find my own character for be GM.How i can delete other chars.Too hard to find more than 8000 players:(.Please help me.Thanks...
[Tut]How to make a Shop w/ mySQL query browser
10/18/2009 - Maple Story - 0 Replies
Okay so, this is how to make a shop using mySQL query browser Step one: Choose an NPC and find it's id. Then, find a shop ID that isn't being used, by going to a resultset and clicking on "Shops" Choose a shop id. then, create a new...
[Request] Default character data user_character table
10/08/2009 - Dekaron Private Server - 5 Replies
hehehe, i was cleaning abit too much data today :mofo: Can someone post a tsql-txt dump of the default chars in user_char ? thanks alot! :handsdown:



All times are GMT +2. The time now is 16:53.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.