Credits for Rep

[Dan 184]

Does anyone know why I can't exchange Repuation Points for Credits?

Scenario: My character has 9k Reputation, 1k Rep = 1 Credit, but when I click Exchange on website, it says "Unable to exchange!"

Note: Character is offline and when I go on the website it displays Exchange 9999 Reputation for 9 credits.

[Tera 26]

Is for your AccountServer need this in action:

 

NOTE! If you wish to use the points/credits functions as a payment method, please run this to add the tables in your database

To do this, if you have SQL 2000, go to query analyzer and paste this in the query window and press F5

If you have any other version go to your management studio ,login and paste this in the query window and press F5

ALTER TABLE [GameDB].[dbo].[account]
ADD [mall_points] [int] DEFAULT (0), [credits] [int] DEFAULT (0)
GO

You should then see a message similar to "The command(s) completed successfully."

You will then need the auction database. I included a txt file which you can use to create the auction database.

----------------------------------------ACTION TXT-------------------------------------------------------------------------------------------

 

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Auction')
DROP DATABASE [Auction]
GO
CREATE DATABASE [Auction]  ON (NAME = N'Auction_Data', FILENAME = N'C:\Auction_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Auction_Log', FILENAME = N'C:\Auction_Log.LDF' , SIZE = 5, MAXSIZE = 2097152, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
exec sp_dboption N'Auction', N'autoclose', N'false'
GO
exec sp_dboption N'Auction', N'bulkcopy', N'false'
GO
exec sp_dboption N'Auction', N'trunc. log', N'false'
GO
exec sp_dboption N'Auction', N'torn page detection', N'true'
GO
exec sp_dboption N'Auction', N'read only', N'false'
GO
exec sp_dboption N'Auction', N'dbo use', N'false'
GO
exec sp_dboption N'Auction', N'single', N'false'
GO
exec sp_dboption N'Auction', N'autoshrink', N'false'
GO
exec sp_dboption N'Auction', N'ANSI null default', N'false'
GO
exec sp_dboption N'Auction', N'recursive triggers', N'false'
GO
exec sp_dboption N'Auction', N'ANSI nulls', N'false'
GO
exec sp_dboption N'Auction', N'concat null yields null', N'false'
GO
exec sp_dboption N'Auction', N'cursor close on commit', N'false'
GO
exec sp_dboption N'Auction', N'default to local cursor', N'false'
GO
exec sp_dboption N'Auction', N'quoted identifier', N'false'
GO
exec sp_dboption N'Auction', N'ANSI warnings', N'false'
GO
exec sp_dboption N'Auction', N'auto create statistics', N'true'
GO
exec sp_dboption N'Auction', N'auto update statistics', N'true'
GO
use [Auction]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ItemMall]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ItemMall]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StorageBox]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StorageBox]
GO
CREATE TABLE [dbo].[ItemMall] (
[ItemName] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ItemPrice] [int] NOT NULL ,
[ItemDesc] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Quota] [int] NOT NULL ,
[Icon] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[cType] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ItemID] [int] NOT NULL ,
[quantity] [int] NOT NULL ,
[category] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MallID] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[StorageBox] (
[storage_id] [int] IDENTITY (1, 1) NOT NULL ,
[act_id] [int] NOT NULL ,
[item_id] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[assigned] [int] NOT NULL ,
[assigned_char] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[assigned_date] [datetime] NULL ,
[Icon] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[itemName] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[quantity] [int] NOT NULL
) ON [PRIMARY]
GO

 

 

 

---------------------------------------------------------------------------------------------------

[Tera 26]

Or change you website 

[Dan 184]

Got tons of error, and said Auction does not exist, also it screwed up my GameServer says please something log character memory

[Tera 26]

Testing the main cities if you get into a single game server will collapse unless you use the dimension files or epo files there if you enter them into a single game server
if the auction does not exist then it is not configured the game server test with current database of preference use sql 2014 with files 2014

[Dan 184]

34 minutes ago, Tera said:

Testing the main cities if you get into a single game server will collapse unless you use the dimension files or epo files there if you enter them into a single game server
if the auction does not exist then it is not configured the game server test with current database of preference use sql 2014 with files 2014

I'm using SQL 2014 but where to get Auction 2014?

[V3ct0r 2,117]

Error on line 12