[Help] How to change Anvil Rates & Clan arm auto updates

[pkerkid]

I saw some guide but i couldn't find how to do certain stuff since i just started using sql so when i tried to make the anvil rates 100% in intem_upgrade column ngenrate to all 10000 is there an easier way to change all the ngenrate for each item or you have to do it one by one?

For Clan Arm auto updates on logout. People told me to go in account_logout procedure and do stuff but i can't find account_logout procedure.

 

[OMEGAbuffer]

1) Toss this into your query analyzer.

update item_upgrade set ngenrate='10000'

2) If you're using MsSQL2005, go to ComputerName\SQLEXPRESS\Databases\KN_online\Programability\Stored Procedures\Account_Logout. Right-click, and press Modify.

Add this at the bottom:

exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights

Hit execute.

 

[pkerkid]

I can't find query analyzer in mssql 2005. Can anyone help me?

 

[pkerkid]

1) Toss this into your query analyzer.

update item_upgrade set ngenrate='10000'

2) If you're using MsSQL2005, go to ComputerName\SQLEXPRESS\Databases\KN_online\Programability\Stored Procedures\Account_Logout. Right-click, and press Modify.

Add this at the bottom:

exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights

Hit execute.

K thxs for you help omega.

 

[OMEGAbuffer]

Right-click KN_online, and press New Query. When you're done putting your query there, press Execute near the top.

 

[Bukowa]

1) Toss this into your query analyzer.

update item_upgrade set ngenrate='10000'

2) If you're using MsSQL2005, go to ComputerName\SQLEXPRESS\Databases\KN_online\Programability\Stored Procedures\Account_Logout. Right-click, and press Modify.

Add this at the bottom:

exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights

Hit execute.

What you mean "at the bottom" can u show me how it all its looking? I got error:

(4 row(s) affected)

(5 row(s) affected)
Caution: Changing any part of an object name could break scripts and stored procedures.
Msg 15151, Level 16, State 1, Procedure KNIGHTS_RATING_UPDATE, Line 26
Cannot find the user 'web', because it does not exist or you do not have permission.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(5 row(s) affected)
Caution: Changing any part of an object name could break scripts and stored procedures.
Msg 15151, Level 16, State 1, Procedure KNIGHTS_RATING_UPDATE, Line 26
Cannot find the user 'web', because it does not exist or you do not have permission.

(1 row(s) affected)

(0 row(s) affected)
Msg 468, Level 16, State 9, Procedure UPDATE_MANNERPOINT_RANK, Line 51
Cannot resolve the collation conflict between "Polish_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

(1 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

And when i start ebenezer it gives me error...

 

[OMEGAbuffer]

What you mean "at the bottom" can u show me how it all its looking? I got error:



And when i start ebenezer it gives me error...

I dunno what the hell that Polish and Latin error is.

I can tell you that web one is when you deleted the web user and the web schema. If you want it back, just get it from another database. Go to that other database, right-click Web and press properties. Follow it to create a mirror schema/user for your database, and it should fix that web problem.

And you may have added it to your account_logout procedure wrong...

Or you're missing the tables it executes