Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 12:10

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

 

[RELEASE] Poultry, yet another GM tool! (Zoidberg reincarnated)

Reply
 
Old   #31
 
elite*gold: 0
Join Date: Aug 2011
Posts: 535
Received Thanks: 232
Poultry 2.0.3.4
  • Code cleanup and optimizations
  • Interface & text fixes
  • Character query context menu fixed
  • Added a bigger map to teleport control
  • Added the world map NPC/character loader feature
  • Added the Horizen map NPC/character loader feature
  • Character list 'Detailed' context menu item fixed
  • Minor adjustments to database connection method (startup only)

Poultry 2.0.3.3
  • Context menu added to saved skills list
  • Code cleanup and optimizations
  • Interface fixes
  • MonsterResource editor feature added
  • Resource editors have epics after the label now, the labels show which epics I've tested and built them on. To have a missing epic supported, please contact me.
Attached Files
File Type: rar Poultry.[RELEASE_V2.0.3.4]-NO ICONS.rar (3.26 MB, 59 views)



marekrndr is offline  
Thanks
1 User
Old   #32
 
elite*gold: 0
Join Date: Jul 2011
Posts: 1
Received Thanks: 0
RE-up the icons please!


calangaoo is offline  
Old   #33
 
elite*gold: 0
Join Date: Apr 2017
Posts: 86
Received Thanks: 6
Trying to connect to gameserver, but after starting connection, its going to eternity, but if i press "Cancel" the program is crit and exit.
Connection to DB - SUCCESS!
I try to put different ports on gameserver like 8841, 4502 etc ( and other, gain from Port Scanner) but take same result.
YuhaBah is offline  
Old   #34
 
elite*gold: 0
Join Date: Mar 2010
Posts: 127
Received Thanks: 17
Tries to connect auth.dbo.accounts but in the db it is listed as auth.dbo.account. refuses to connect because of this.


Azreil is offline  
Old   #35
 
elite*gold: 0
Join Date: Nov 2012
Posts: 8
Received Thanks: 6
Quote:
Originally Posted by Azreil View Post
Tries to connect auth.dbo.accounts but in the db it is listed as auth.dbo.account. refuses to connect because of this.
You can work around this by using a synonym:

Code:
create synonym Accounts for dbo.Account
vweegit is offline  
Thanks
1 User
Old   #36
 
elite*gold: 0
Join Date: Nov 2012
Posts: 644
Received Thanks: 117
Quote:
Originally Posted by vweegit View Post
You can work around this by using a synonym:

Code:
create synonym Accounts for dbo.Account
is this a sql query?
thefear511 is offline  
Old   #37
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,425
Received Thanks: 1,126
Yes and it does work.

For new queries written inside the SQL window with the synonym name it will say that it is an invalid object name and invalid column name but it still does execute the query written under the synonym anyway.
ThunderNikk is offline  
Old   #38
 
elite*gold: 0
Join Date: Nov 2012
Posts: 8
Received Thanks: 6
Quote:
Originally Posted by thefear511 View Post
is this a sql query?
Yes, it is, sorry. I should have made that clear.

Quote:
Originally Posted by ThunderNikk
For new queries written inside the SQL window with the synonym name it will say that it is an invalid object name and invalid column name but it still does execute the query written under the synonym anyway.
Interesting - SSMS does not give me those errors. It added 'Accounts' to the auto-complete context menu, even.
vweegit is offline  
Thanks
2 Users
Old   #39
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,425
Received Thanks: 1,126
Quote:
Originally Posted by vweegit View Post
Interesting - SSMS does not give me those errors. It added 'Accounts' to the auto-complete context menu, even.
I just ran the query and then I wrote and added a query all without restarting server manager.

I will try it again tonight because it will have been closed and reopened and see if I get the same issues.
ThunderNikk is offline  
Old   #40
 
elite*gold: 0
Join Date: Nov 2012
Posts: 644
Received Thanks: 117
Quote:
Originally Posted by vweegit View Post
Yes, it is, sorry. I should have made that clear.



Interesting - SSMS does not give me those errors. It added 'Accounts' to the auto-complete context menu, even.
wow! this makes so many stuff work xd many tools i had were compiled using the table name Account while other version of the game people like had the tablen mae Accounts making old tools not working xd thanks tho.
thefear511 is offline  
Old   #41
 
elite*gold: 0
Join Date: Nov 2012
Posts: 8
Received Thanks: 6
Quote:
Originally Posted by thefear511 View Post
wow! this makes so many stuff work xd many tools i had were compiled using the table name Account while other version of the game people like had the tablen mae Accounts making old tools not working xd thanks tho.
No problem. I'm surprised it hasn't been shared before: SQL server has allowed synonyms since SQL 2005. I've used it practically since my first day with PServer software when - it was either Poultry or Glandu's auth tool, I forget which - threw an error for that particular table.

Quote:
Originally Posted by ThunderNikk View Post
I just ran the query and then I wrote and added a query all without restarting server manager.

I will try it again tonight because it will have been closed and reopened and see if I get the same issues.
Hmm. Shouldn't require a restart, the synonym should immediately affect the project. I suppose there could be some goofy version dependency, but I can't recall ever seeing this issue with any version of SQL server, though I'm sure I probably missed a version or two somewhere along the years.
vweegit is offline  
Thanks
1 User
Old   #42
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,425
Received Thanks: 1,126
Figured it out...

In the top left window where it has a selection of available databases if auth is selected or you start the query with...

Use auth

then it works fine but if you try to direct to the auth database in the query it does not recognize the synonym in the written query or give you context menus but it executes it fine.

example

select * from auth.dbo.accounts where account like '%name%'

only works if auth is selected in the available databases drop down

but

Use auth

select * from dbo.accounts

works with context and no errors on invalid dbo
ThunderNikk is offline  
Old   #43
 
elite*gold: 0
Join Date: Nov 2012
Posts: 8
Received Thanks: 6
Quote:
Originally Posted by ThunderNikk View Post
Figured it out...

In the top left window where it has a selection of available databases if auth is selected or you start the query with...

Use auth

then it works fine but if you try to direct to the auth database in the query it does not recognize the synonym in the written query or give you context menus but it executes it fine.

example

select * from auth.dbo.accounts where account like '%name%'

only works if auth is selected in the available databases drop down

but

Use auth

select * from dbo.accounts

works with context and no errors on invalid dbo
Glad you got it. I was going to have you query the auth DB sys.synonyms to make sure the synonym was applied there. SSMS defaults to applying the query against whichever DB you have selected, which tends to make me lazy.

You are correct:

Code:
use auth
create synonym Accounts for auth.dbo.Account
or

Code:
use auth
create synonym Account for auth.dbo.Accounts
Would be the proper syntax, depending on your circumstance.

Another handy snippet, you can check against a DB to see what synonyms you have created.

Code:
use auth
select * from sys.synonyms
This will show you varied information on the synonyms you have created.


vweegit is offline  
Thanks
2 Users
Reply

Tags
gm, rappelz, telnet, tool, zoidberg



« Previous Thread | Next Thread »

Similar Threads
[ GM TOOL ] Zoidberg - Edacious [ PREVIOUS ZOIDBERG REINCARNATED ]
This is a preview of 2.0.2.0 http://i.epvpimg.com/f3RTe.jpg http://i.epvpimg.com/FnC2h.jpg Zoidberg - Edacious v1.2.0.0 What's new in...
29 Replies - Rappelz Private Server
Help to ZoidBerg Tool
Hi friends, i have a server for me playing alone, 7.4 files and 7.4 client, i downloaded Zoidberg tool, but i donk know he work.... ( i am noob...
2 Replies - Rappelz Private Server
Help to ZoidBerg Tool
Hi friends, i have a server for me playing alone, 7.4 files and 7.4 client, i downloaded Zoidberg tool, but i donk know he work.... ( i am noob...
0 Replies - Rappelz
[Public release] Zoidberg, the new GM tool
http://www.elitepvpers.com/forum/rappelz-private-server/2200547-gm-tool-zoidberg-edacious-previous-zoidberg-reincarnated.html
51 Replies - Rappelz Private Server



All times are GMT +2. The time now is 12:10.


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.