[Request] Help with ExpDefs table

Hey guys. I was wondering if I could get a solution to an issue I'm having with my ExpDefs table.

I've been wanting to increase the amount of Exp required to level mainly for the fact the Ep5 version of the table has the values way too low.

However, when I go to change them, I can't put above a certain amount, when it's set to Int32 settings. So, I changed it to Int64 and BigInt, which allowed me to put in larger values.

However, these larger values prevent my server from fully connecting, namely my Game.

The log says something about failure to connect to the ExpDefs table.

So, I was wondering if anyone had a solution that would allow me to be able to place in higher Exp values outside of the Int32 range without completely crashing it. (I hope I'm making sense).

i think see PS_GameDefs -> usp_Read_ExpDefs_R (stored procedure)
use sql profiler for debug

Thank you for the response, Twilight!

I took a peek at that procedure, and this is what it says:

Quote:

---

Originally Posted by dbo.usp_Read_ExpDefs_R

USE [PS_GameDefs]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_ExpDefs_R] Script Date: 09/21/2010 09:44:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER Proc [dbo].[usp_Read_ExpDefs_R]
/* Created by frsunny@hotmail.com, 2004-08-11
경험치 테이블 읽어오기 */
AS
SELECT [Level], Grow, [Exp] FROM ExpDefs
ORDER BY Grow ASC, Level ASC

---

Would I change the "SET QUOTED_IDENTIFIER" to "ON", then?

Quote:

---

Originally Posted by demonicdragon17

Thank you for the response, Twilight!

I took a peek at that procedure, and this is what it says:



Would I change the "SET QUOTED_IDENTIFIER" to "ON", then?

---

If you learn to use the tool SQL Server SQL Profiler, you will see all queries to the database in real time.
In the setting of this tool should include all the events and values.
You'll see what kind of data requests the game server and what gets a response from the base.
Can I suggest you watch video course
Microsoft SQL Server 2008 Administration Tutorials (2010)


Introduction
Welcome (01:46)
Course Overview (03:25)
SQL Server Basics (07:06)
Getting Hands On (04:23)
Microsoft SQL Certifications (05:40)
SQL Server Editions (06:07)
Installing SQL Server 2008
Hardware Requirements (04:05)
SQL Server Instances (04:46)
SQL Server Components (04:21)
Collation Choices (03:38)
Service Accounts (05:41)
Creating Service Accounts (02:39)
Installing SQL Server 2008 pt. 1 (06:13)
Installing SQL Server 2008 pt. 2 (05:00)
Installing SQL Server 2008 pt. 3 (04:59)
Upgrading SQL Server 2008 (03:16)
SQL Server Configuration Manager (04:00)
SQL Server Authentication Modes (05:00)
Changing Authentication Modes (04:02)
SQL Server Management Studio (06:04)
SQL Server 2008 Databases
File Types (03:40)
Transaction Log (05:55)
System Databases (06:18)
File Placement (04:39)
Creating a Database (06:16)
Autogrowth (05:53)
Database Options (05:25)
Sizing the Transaction Log (03:53)
Schemas (06:21)
Default Schema (05:46)
Creating a Schema (06:11)
Moving Data Files (05:50)
Installing Sample Databases pt. 1 (06:17)
Installing Sample Databases pt. 2 (03:48)
Maintaining SQL Server
Hiding System Objects (04:20)
SQL Server Agent (05:50)
Creating a Maintenance Plan (06:35)
Understanding Operators (02:10)
Understanding Jobs (05:33)
Understanding Alerts (05:57)
Server Management
SQL Server Options (06:26)
Registering Servers (03:59)
Server Configuration (05:04)
Activity Monitor (03:31)
Database Mail pt. 1 (03:53)
Database Mail pt. 2 (06:39)
Database Mail pt. 3 (05:08)
Maintaining The Database
Maintaining the Database (04:13)
Database Backup pt. 1 (05:34)
Database Backup pt. 2 (06:02)
Backup Compression (05:52)
Backup Devices (05:58)
Managing the Transaction Log (06:32)
Restoring the Database (06:42)
Monitoring & Troubleshooting
Dedicated Administrator Connection (04:59)
SQL Profiler pt. 1 (05:04)
SQL Profiler pt. 2 (05:38)
Log File Viewer (04:13)
Event Forwarding (02:29)
Optimizing Performance
Using Filegroups (04:36)
Partitions (06:19)
Partition Planning (05:01)
Database Tuning Advisor pt. 1 (06:03)
Database Tuning Advisor pt. 2 (04:23)
High Availability
High Availability Options (06:20)
Failover Clustering (02:38)
Database Mirroring (05:30)
Log Shipping (04:57)
Conclusion
Course Wrap Up (04:40)
Credits
About the Author (02:50)




Microsoft SQL Server 2008 Administration Tutorials (2010)
RapidShare: 1-CLICK Web hosting - Easy Filehosting
RapidShare: 1-CLICK Web hosting - Easy Filehosting
RapidShare: 1-CLICK Web hosting - Easy Filehosting
RapidShare: 1-CLICK Web hosting - Easy Filehosting

and example disasm ps_game

Again, thank you Twilight for your help!

I'll take a look and see what I can find, and let you know how it goes!