[Help Thread] Please post your questions here.

[ThunderNikk]

Did you start the upload server?

(Just FYI you only need the upload server for guild icons, the rest will work without it.)

[Topez]

Originally Posted by thndr

Did you start the upload server?

(Just FYI you only need the upload server for guild icons, the rest will work without it.)

how would i remove it then? because i cannot login without it crashing and telling me what i said. and yes i ran upload.

[ThunderNikk]

Not connecting to the upload would not cause it to crash. You dont even need the upload running to log into the game.

Something else is wrong

Are you sure it does not say cannot connect to the login server?

[Topez]

Originally Posted by thndr

Not connecting to the upload would not cause it to crash. You dont even need the upload running to log into the game.

Something else is wrong

Are you sure it does not say cannot connect to the login server?

Well yes it says that when the game crashes, sorry haha i thought the error in the console was the issue.

[ThunderNikk]

So what are you using for the start .bat or launcher arguments for your client?

Should be something like...

"C:\Rappelz Private Server\Clients\Rappelz 8_1\Rappelz\SFrame.exe" /auth_ip:***.***.***.*** /auth_port:8841 /locale:ASCII /country:US /commercial_shop /cash

[Topez]

Originally Posted by thndr

So what are you using for the start .bat or launcher arguments for your client?

Should be something like...

"C:\Rappelz Private Server\Clients\Rappelz 8_1\Rappelz\SFrame.exe" /auth_ip:***.***.***.*** /auth_port:8841 /locale:ASCII /country:US /commercial_shop /cash

im using pserver connector to try and connect to it.
do you have a skype or something faster than this?
i want to fix this and get to coding. never thought setting up ports etc would be so annoying.

[opie1225]

is it possible to change the port that needs to be used? im trying the game server runs on port 80 and i need it free for something else?

[Makenci]

habe ein prooblem, ich komme in mein server nicht rein zur Serverauswahl.
Es kommt auch keine fehlermeldung nichts.

ich denke an der IP kann es nicht liegen da wenn ich die geändert habe auch der fehler da war das keine verbindung zum zertif........... ist.

Habe alles nach liste gemacht aber irgendwie gehts nicht -.-

kann mir da jemand vielelicht helfen ?

[Xijezu]

Originally Posted by opie1225

is it possible to change the port that needs to be used? im trying the game server runs on port 80 and i need it free for something else?

Port 80? Why? o0
Yep, it is possible, just change the .opt-file: S io.port: 80

Originally Posted by Topez

im using pserver connector to try and connect to it.
do you have a skype or something faster than this?
i want to fix this and get to coding. never thought setting up ports etc would be so annoying.

The PServer-Connector is using the standard-parameter, so it could be that it is trying to connect to a different port. Try using a .bat-File instead.

Originally Posted by Makenci

habe ein prooblem, ich komme in mein server nicht rein zur Serverauswahl.
Es kommt auch keine fehlermeldung nichts.

ich denke an der IP kann es nicht liegen da wenn ich die geändert habe auch der fehler da war das keine verbindung zum zertif........... ist.

Habe alles nach liste gemacht aber irgendwie gehts nicht -.-

kann mir da jemand vielelicht helfen ?

Wie wär's wenn du die .opt-Dateien mal postest? Andernfalls können wir nur raten.

[Makenci]

auth

 Spoiler

S db.auth.server:127.0.0.1
S db.auth.name:auth
S db.auth.account:RappelzHome
S db.auth._password:
S db.auth.port:1433
S app.name:auth

N game.user_limit:3000
N auth.max_client_per_ip:30000

S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000

S db.auth.md5_key:1234
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0

N billing.user_keep_alive_interval:30000

game

 Spoiler

S app.name:game001
S auth.server_idx:1
S auth.server_name:Home

S db.user.work_total:nbr
S db.user.work_pending:nbr
S db.user.work_active:nbr
S db.user.thread_active:nbr
S db.user.thread_total:nbr

S console.port:4502
S console._password:

S db.game.ip:127.0.0.1

S db.c.name:arcadia
S db.c.server:127.0.0.1
S db.c.account:RappelzHome
S db.c._password:

S db.user.name:telecaster
S db.user.server:127.0.0.1
S db.user.account:RappelzHome
S db.user._password:

S io.auth.ip:127.0.0.1
S io.ip_address:25.102.98.147
S io.port:7888

S game.server_screenshot_url:url_of_your_screen_sele ction_html

S io.upload.port:4617
S io.upload.ip:127.0.0.1
S game.guild_icon_base_url:
S game.url_list:guild_icon_upload.ip|your_website/external_ip|guild_icon_upload.port|4615

S game.use_auto_jail:0
S game.pvp_damage_rate_for_summon:.03
S game.pvp_damage_rate_for_player:.03
S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0
S game.mem_usage_info_save_interval:6000
S game.base_ethereal_durability_consumption:.35
S game.play_point_accumulate_term:6000
S game.play_point_accumulate_amount:10
S game.premium_pcbang_play_point_bonus_rate:2.5
S game.exp_rate:10
S game.item_drop_rate:12
S game.gold_drop_rate:12
S game.chaos_drop_rate:12
S game.party_drop_rate:2.5
S game.party_exp_rate:1.25
S game.apply_stamina_bonus_in_premium_pcb:.50
S game.premium_pcbang_bonus_rate:1.25
S game.premium_pcbang_chaos_bonus_rate:2
S game.premium_pcbang_gold_bonus_drop_rate:2.5
S game.premium_pcbang_item_bonus_drop_rate:2.5
S game.premium_pcbang_chaos_bonus_drop_rate:2.5
S game.ally_pcbang_bonus_rate:1.75
S game.ally_pcbang_chaos_bonus_rate:1.75

T game.pcbang_bonus_server:1
T game.use_play_point:0
T game.use_guild_donation_point:1
T game.use_login_logout_debug:1
T game.max_level:180
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:0
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
S game.disable_huntaholic_timer:0
S game.huntaholic_timer:1
T game.disable_dungeon_raid_siege:0
N game.UseHackShield:0
N game.UseGameGuard:0
N game.skip_loading_attribute:1
N game.logout_timer:1
S log.disable:1
S log.working:0
S game.AdultServer:0
S game.PKServer:0
S game.disable_pk_on:0
S game.auction_process_request_min_interval:100
S game.auction_search_request_min_interval:100
S game.force_unregister_account_on_kick_fail:1
S game.min_global_chat_usable_level:20
S game.item_hold_time:11000


S memory.player_heap_size:1000
T game.max_storage_item_count:1000
T set_user_limit:50

[Xijezu]

Originally Posted by Makenci

auth

 Spoiler

S db.auth.server:127.0.0.1
S db.auth.name:auth
S db.auth.account:RappelzHome
S db.auth._password:
S db.auth.port:1433
S app.name:auth

N game.user_limit:3000
N auth.max_client_per_ip:30000

S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000

S db.auth.md5_key:1234
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0

N billing.user_keep_alive_interval:30000

game

 Spoiler

S app.name:game001
S auth.server_idx:1
S auth.server_name:Home

S db.user.work_total:nbr
S db.user.work_pending:nbr
S db.user.work_active:nbr
S db.user.thread_active:nbr
S db.user.thread_total:nbr

S console.port:4502
S console._password:

S db.game.ip:127.0.0.1

S db.c.name:arcadia
S db.c.server:127.0.0.1
S db.c.account:RappelzHome
S db.c._password:

S db.user.name:telecaster
S db.user.server:127.0.0.1
S db.user.account:RappelzHome
S db.user._password:

S io.auth.ip:127.0.0.1
S io.ip_address:25.102.98.147
S io.port:7888

S game.server_screenshot_url:url_of_your_screen_sele ction_html

S io.upload.port:4617
S io.upload.ip:127.0.0.1
S game.guild_icon_base_url:
S game.url_list:guild_icon_upload.ip|your_website/external_ip|guild_icon_upload.port|4615

S game.use_auto_jail:0
S game.pvp_damage_rate_for_summon:.03
S game.pvp_damage_rate_for_player:.03
S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0
S game.mem_usage_info_save_interval:6000
S game.base_ethereal_durability_consumption:.35
S game.play_point_accumulate_term:6000
S game.play_point_accumulate_amount:10
S game.premium_pcbang_play_point_bonus_rate:2.5
S game.exp_rate:10
S game.item_drop_rate:12
S game.gold_drop_rate:12
S game.chaos_drop_rate:12
S game.party_drop_rate:2.5
S game.party_exp_rate:1.25
S game.apply_stamina_bonus_in_premium_pcb:.50
S game.premium_pcbang_bonus_rate:1.25
S game.premium_pcbang_chaos_bonus_rate:2
S game.premium_pcbang_gold_bonus_drop_rate:2.5
S game.premium_pcbang_item_bonus_drop_rate:2.5
S game.premium_pcbang_chaos_bonus_drop_rate:2.5
S game.ally_pcbang_bonus_rate:1.75
S game.ally_pcbang_chaos_bonus_rate:1.75

T game.pcbang_bonus_server:1
T game.use_play_point:0
T game.use_guild_donation_point:1
T game.use_login_logout_debug:1
T game.max_level:180
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:0
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
S game.disable_huntaholic_timer:0
S game.huntaholic_timer:1
T game.disable_dungeon_raid_siege:0
N game.UseHackShield:0
N game.UseGameGuard:0
N game.skip_loading_attribute:1
N game.logout_timer:1
S log.disable:1
S log.working:0
S game.AdultServer:0
S game.PKServer:0
S game.disable_pk_on:0
S game.auction_process_request_min_interval:100
S game.auction_search_request_min_interval:100
S game.force_unregister_account_on_kick_fail:1
S game.min_global_chat_usable_level:20
S game.item_hold_time:11000


S memory.player_heap_size:1000
T game.max_storage_item_count:1000
T set_user_limit:50

 Spoiler

S app.name:game001
S auth.server_idx:1
S auth.server_name:Home

S db.user.work_total:nbr
S db.user.work_pending:nbr
S db.user.work_active:nbr
S db.user.thread_active:nbr
S db.user.thread_total:nbr

S console.port:4502
S console._password:

S db.game.ip:127.0.0.1

S db.c.name:arcadia
S db.c.server:127.0.0.1
S db.c.account:RappelzHome
S db.c._password:

S db.user.name:telecaster
S db.user.server:127.0.0.1
S db.user.account:RappelzHome
S db.user._password:

S io.auth.ip:127.0.0.1
S io.ip_address:127.0.0.1
S io.port:7888

S io.upload.port:4617
S io.upload.ip:127.0.0.1

S game.use_auto_jail:0
S game.pvp_damage_rate_for_summon:.03
S game.pvp_damage_rate_for_player:.03
S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0
S game.mem_usage_info_save_interval:6000
S game.base_ethereal_durability_consumption:.35
S game.play_point_accumulate_term:6000
S game.play_point_accumulate_amount:10
S game.premium_pcbang_play_point_bonus_rate:2.5
S game.exp_rate:10
S game.item_drop_rate:12
S game.gold_drop_rate:12
S game.chaos_drop_rate:12
S game.party_drop_rate:2.5
S game.party_exp_rate:1.25
S game.apply_stamina_bonus_in_premium_pcb:.50
S game.premium_pcbang_bonus_rate:1.25
S game.premium_pcbang_chaos_bonus_rate:2
S game.premium_pcbang_gold_bonus_drop_rate:2.5
S game.premium_pcbang_item_bonus_drop_rate:2.5
S game.premium_pcbang_chaos_bonus_drop_rate:2.5
S game.ally_pcbang_bonus_rate:1.75
S game.ally_pcbang_chaos_bonus_rate:1.75

T game.pcbang_bonus_server:1
T game.use_play_point:0
T game.use_guild_donation_point:1
T game.use_login_logout_debug:1
T game.max_level:180
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:0
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
S game.disable_huntaholic_timer:0
S game.huntaholic_timer:1
T game.disable_dungeon_raid_siege:0
N game.UseHackShield:0
N game.UseGameGuard:0
N game.skip_loading_attribute:1
N game.logout_timer:1
S log.disable:1
S log.working:0
S game.AdultServer:0
S game.PKServer:0
S game.disable_pk_on:0
S game.auction_process_request_min_interval:100
S game.auction_search_request_min_interval:100
S game.force_unregister_account_on_kick_fail:1
S game.min_global_chat_usable_level:20
S game.item_hold_time:11000


S memory.player_heap_size:1000
T game.max_storage_item_count:1000
T set_user_limit:50

Oder ganz simpel: S io.ip_address: 127.0.0.1

[Makenci]

gleiches problem geht nach dem login nicht weiter ohne fehlermeldung nichts

vielleicht liegt es ja an der bat datei ??

 Spoiler

@ECHO OFF
START SFRAME /auth_ip:127.0.0.1 /auth_port:7888 /locale:Windows-1252 /country: DE /commercial_shop /help_url_w:620 /help_url_h:633 /ghelp_url:"http://game.gpotato.eu/rappelz/help/ /guild.url:"http://%guildLink%" /web_download:"DownloadLink" /guild_download.url:"upload/client/guild/" /shop.url:"http://%shop_url%" /rend

[Xijezu]

Originally Posted by Makenci

 Spoiler

@ECHO OFF
START SFRAME /auth_ip:127.0.0.1 /auth_port:7888 /locale:Windows-1252 /country: DE /commercial_shop /help_url_w:620 /help_url_h:633 /ghelp_url:"http://game.gpotato.eu/rappelz/help/ /guild.url:"http://%guildLink%" /web_download:"DownloadLink" /guild_download.url:"upload/client/guild/" /shop.url:"http://%shop_url%" /rend

Ah, sorry, nächstes mal sollte ich erst nach dem Kaffee antworten..
Nimm' einfach das /auth_port:7888 raus, und es dürfte gehen. Der Standard-Port ist 4500, und da du keinen in der opt angegeben hast, wird auch der verwendet.

[Makenci]

ok hat geklappt viellen viellen dank

next problem

im gs steht nun

DB COM ERROR(thread 1, HRESULT:80040E37, GUID 0c733a63-2a1c usw....
DB_GetCommerciaStorageinfo(dbo.smp_check_purchase_ item : ungültiger objektname . billing.dob.paidtem

[c1ph3r]

Einfacher Weg:

Füge die Billing Datenbank hinzu (Iwo im 7.4 Release)

Etwas komplizierterer Weg:

Schreibe die Billing SMPs in der Telecaster um.

smp_check_purchased_item:

 Spoiler

USE [telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_check_purchased_item]    Script Date: 15.04.2013 11:38:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[smp_check_purchased_item]

@IN_ACCOUNT_ID INT,
@IN_SID INT,
@OUT_TOTAL_ITEM_COUNT INT OUTPUT,	
@OUT_NEW_ITEM_COUNT INT OUTPUT,		
@OUT_PREMIUM_TICKET INT OUTPUT,		
@OUT_PREMIUM_REST_TIME INT OUTPUT,	
@OUT_STAMINA_REGEN_TIME INT OUTPUT	

AS
SET NOCOUNT ON

SET @OUT_NEW_ITEM_COUNT = 10 
SET @OUT_STAMINA_REGEN_TIME = 20 

SET @OUT_PREMIUM_TICKET = 0
SET @OUT_PREMIUM_REST_TIME = 0

SELECT @OUT_PREMIUM_TICKET = COUNT(*) from PaidItem WITH (NOLOCK) where taken_account_id = @IN_ACCOUNT_ID and item_code = 910000 and valid_time > GETDATE()

IF @OUT_PREMIUM_TICKET > 0
BEGIN

UPDATE PaidItem set valid_time = DATEADD(s, DATEDIFF(s, bought_time, GETDATE()), valid_time), taken_time = GETDATE() where taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND taken_time IS NULL

DECLARE @VALID_PASS_COUNT INT
SET @VALID_PASS_COUNT = 0

DECLARE @COMBINED_TIME INT
SET @COMBINED_TIME = 0

DECLARE @NEWEST_PASS INT
SET @NEWEST_PASS = -1

SELECT @VALID_PASS_COUNT = COUNT(*) FROM PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE()

IF @VALID_PASS_COUNT > 1
	BEGIN
		SELECT @COMBINED_TIME = SUM(DATEDIFF(s, GETDATE(), valid_time)) from PaidItem where taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE()
		
		SELECT TOP (1) @NEWEST_PASS = sid from PaidItem where taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() ORDER BY bought_time DESC
		
		SET ROWCOUNT 1
		WHILE 1=1
		BEGIN
			UPDATE PaidItem set valid_time = GETDATE(), rest_item_count=0 WHERE sid IN ( SELECT TOP 1 sid FROM PaidItem WITH (NOLOCK) WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() AND sid <> @NEWEST_PASS )
			IF @@ROWCOUNT = 0 BREAK
		END
		SET ROWCOUNT 0

		UPDATE PaidItem set valid_time = DATEADD(s, @COMBINED_TIME, GETDATE()), rest_item_count=0 WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE()AND sid = @NEWEST_PASS
	END

	
SELECT @OUT_PREMIUM_REST_TIME = MAX(DATEDIFF(s, GETDATE(), valid_time)) from PaidItem WITH (NOLOCK) where taken_account_id = @IN_ACCOUNT_ID and item_code = 910000 and valid_time > GETDATE()

SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from PaidItem WITH (NOLOCK) where taken_account_id = @IN_ACCOUNT_ID and rest_item_count > 0;
SELECT @OUT_NEW_ITEM_COUNT = COUNT(*) from PaidItem WITH (NOLOCK) where taken_account_id = @IN_ACCOUNT_ID and rest_item_count > 0 and confirmed = 0;

END

RETURN @@ERROR

smp_read_purchased_item_list:

 Spoiler

USE [telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_read_purchased_item_list]    Script Date: 15.04.2013 11:41:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[smp_read_purchased_item_list]

@IN_ACCOUNT_ID          INT
 
AS
SET NOCOUNT ON

UPDATE dbo.PaidItem set confirmed = 1, confirmed_time = GETDATE() WHERE taken_account_id = @IN_ACCOUNT_ID and confirmed = 0;

SELECT  sid,                       
        account_id,            
        avatar_id,            
        avatar_name,         
        server_name,                  
        item_code,            
        item_count,            
        rest_item_count,                
        bought_time,           
        valid_time            
               
        FROM dbo.PaidItem WITH (NOLOCK) WHERE taken_account_id = @IN_ACCOUNT_ID and rest_item_count > 0     


RETURN @@ERROR

smp_takeout_commercial_item:

 Spoiler

USE [telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_takeout_commercial_item]    Script Date: 15.04.2013 11:42:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[smp_takeout_commercial_item]

@OUT_ITEM_CODE          INT OUTPUT,
@IN_SID                 INT,
@IN_COUNT               INT,
@IN_ACCOUNT_ID          INT,
@IN_AVATAR_ID           INT,
@IN_AVATAR_NAME         VARCHAR(61),
@IN_SERVER_NAME         VARCHAR(30),
@IN_TRANSACTION_CODE	INT,
@IN_IDX					INT
 
AS
SET NOCOUNT ON

SET @OUT_ITEM_CODE = 0

DECLARE @RET INT
SET @RET = -1

DECLARE @REST_ITEM_COUNT INT
SET @REST_ITEM_COUNT = -1


IF @IN_COUNT < 1
BEGIN
    GOTO ON_END
END

BEGIN TRANSACTION

	SELECT @REST_ITEM_COUNT = rest_item_count FROM dbo.PaidItem WHERE sid = @IN_SID;

	IF @REST_ITEM_COUNT < @IN_COUNT
	BEGIN
		ROLLBACK TRANSACTION
        GOTO ON_END
	END


	UPDATE dbo.PaidItem SET

        rest_item_count = ( @REST_ITEM_COUNT - @IN_COUNT ),
        taken_avatar_id = @IN_AVATAR_ID,
        taken_avatar_name = @IN_AVATAR_NAME,
        taken_server_name = @IN_SERVER_NAME,
        taken_time = GETDATE()
        
    WHERE sid = @IN_SID and taken_account_id = @IN_ACCOUNT_ID;
    SET @RET = 0

	DECLARE @ACCOUNT_ID INT
	SET @ACCOUNT_ID = -1

	SELECT @OUT_ITEM_CODE = item_code, @ACCOUNT_ID = taken_account_id from dbo.PaidItem where sid = @IN_SID;

	IF @ACCOUNT_ID <> @IN_ACCOUNT_ID
		BEGIN
			SET @OUT_ITEM_CODE = 0
			ROLLBACK TRANSACTION
			GOTO ON_END
		END

	-- Add the item(s) to the character
	INSERT INTO dbo.Item (

		sid,							-- 0
		owner_id,						-- 1
		account_id,						-- 2
		summon_id,						-- 3
		auction_id,						-- 4
		keeping_id,						-- 5
		idx,							-- 6
		code,							-- 7
		flag,							-- 8
		cnt,							-- 9
		[level],						-- 10
		enhance,
		ethereal_durability,						-- 11
		endurance,						-- 12
		gcode,							-- 13
		create_time,						-- 14
		wear_info,						-- 15
		socket_0,						-- 16
		socket_1,						-- 17
		socket_2,						-- 18
		socket_3,						-- 19
		remain_time,						-- 20
		elemental_effect_type,					-- 21
		elemental_effect_expire_time,				-- 22
		elemental_effect_attack_point,				-- 23
		elemental_effect_magic_point,				-- 24
		update_time						-- 25

	)
	VALUES (
	
		@IN_TRANSACTION_CODE,					-- 0
		@IN_AVATAR_ID,						-- 1
		@IN_ACCOUNT_ID,						-- 2
		0,							-- 3
		0,							-- 4
		0,							-- 5
		@IN_IDX,						-- 6
		@OUT_ITEM_CODE,						-- 7
		0,							-- 8
		@IN_COUNT,						-- 9
		0,							-- 10
		0,
		0,							-- 11
		0,							-- 12
		0,							-- 13
		GETDATE(),						-- 14	
		-1,							-- 15
		0,							-- 16
		0,							-- 17
		0,							-- 18
		0,							-- 19
		0,							-- 20
		0,							-- 21
		0,							-- 22
		0,							-- 23
		0,							-- 24
		GETDATE()						-- 25
	);

	SET @RET = @@ERROR

	IF @RET <> 0
	BEGIN
		ROLLBACK TRANSACTION
        GOTO ON_END
	END

COMMIT TRANSACTION

ON_END:
RETURN @RET

Da ist immer der Verweis auf die Billing Datenbank. Hier einfach auf die Telecaster verweisen und die dbo.PaidItem mit dem folgenden Skript anlegen:

PaidItem:

 Spoiler

USE [telecaster]
GO

/****** Object:  Table [dbo].[PaidItem]    Script Date: 15.04.2013 11:36:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PaidItem](
	[sid] [int] IDENTITY(1,1) NOT NULL,
	[account_id] [int] NULL,
	[avatar_id] [int] NULL,
	[avatar_name] [varchar](61) NULL,
	[item_code] [int] NULL,
	[item_count] [int] NULL,
	[rest_item_count] [int] NULL,
	[bought_time] [datetime] NULL,
	[valid_time] [datetime] NULL,
	[server_name] [varchar](30) NULL,
	[taken_avatar_id] [int] NULL,
	[taken_avatar_name] [varchar](61) NULL,
	[taken_server_name] [varchar](30) NULL,
	[taken_time] [datetime] NULL,
	[taken_account_id] [int] NULL,
	[confirmed] [int] NULL,
	[confirmed_time] [date] NULL,
	[isCancel] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO