Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 14:52

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

Advertisement



how can I create a database

Discussion on how can I create a database within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2013
Posts: 6
Received Thanks: 0
how can I create a database

how can I create database with the dark wizard characters etc begi half.

Either way for me to have the characters

thanks
ReplayD is offline  
Old 01/20/2013, 14:02   #2
 
elite*gold: 0
Join Date: Apr 2008
Posts: 371
Received Thanks: 28
Quote:
Originally Posted by zeusbigz
try use this
Code:
DEKARON0000001  	[DEV]KNIGHT	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    336     363     336     366     7       7       0       4000    200     0       10      0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON10000001 	[DEV]CONCERRA	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    354     146     354     146     7       7       0       4000    200     10      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON1000001  	[DEV]HUNTER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    336     215     336     216     7       7       0       4000    200     1       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON11000001 	[DEV]SEGURIPER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     11      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON12000001 	[DEV]HALFBAGI	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     12      0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON2000001  	[DEV]MAGICIAN	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     2       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON3000001  	[DEV]SUMMONER	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     232     158     7       7       0       4000    200     3       117     0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON4000001  	[DEV]SEGNALLE	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     4       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON5000001  	[DEV]WARRIOR	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     5       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.060 NULL    2008-05-31 01:13:15.060 NULL    <Binary data>   0       0       0       0       0
DEKARON6000001  	[DEV]ALLOKEN	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     6       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
DEKARON9000001  	[DEV]DARKWIZARD	19999999999991  0       0       0       999750040       0       0       1000    1000    6000    6000    6000    6000    378     146     354     146     7       7       0       4000    200     9       0       0       0       0       0       0       0       0       0       20050325        2008-05-31 01:13:15.000 NULL    2008-05-31 01:13:15.000 NULL    NULL    0       0       0       0       0
Code:
	SELECT @char_gubun = CASE @v_byPCClass
							WHEN 0 THEN 'A'
							WHEN 1 THEN 'B'
							WHEN 2 THEN 'C'
							WHEN 3 THEN 'D'
							WHEN 4 THEN 'E'
							WHEN 5 THEN 'F'
							WHEN 6 THEN 'G'
							WHEN 9 THEN 'J'
							WHEN 10 THEN 'K'
							WHEN 11 THEN 'L'
							WHEN 12 THEN 'M'
							ELSE 'Z'
						 END
	
	-- ???? ????? ?? (????_?????)
	SET @tab_nm = 'USER_CHARACTER'+'_'+@char_gubun
	SET @regdate = SUBSTRING(CONVERT(varchar(10),@ipt_time,112),1,6)+'01'
	
	-- ??? ???? ??
	EXEC sp_com_seqno @tab_nm, @regdate, @seq_no OUTPUT
	
	IF @seq_no < 1 			-- ???? ????
		BEGIN
			SET @sp_rtn = @seq_no
			RETURN
		END	
	
	-- character_no ??
	SET @m_date = SUBSTRING(CONVERT(varchar(10),@ipt_time,112),3,4)
	SET @character_no = @char_gubun + @m_date + @spid + dbo.FN_GetAutoNo(@seq_no,10)
	
	-- ????? ???? ???? ??
	SET @rand_no = CAST(3*Rand()+1 as INT)
	SET @wh_char_no = 'DEKARON'+CAST(@v_byPCClass as varchar(2))+'000001'
Thats what i fount in search
molige is offline  
Reply


Similar Threads Similar Threads
How to create Database acces accounts
08/18/2012 - Shaiya Private Server - 7 Replies
Hi guys. I couldn't see anywhere saying what is the procedure for creating a database acces accounts.. Couldnt find it anywhere and would be really nice if you can help me. I'm sorry if there is already such topic but i couldnt find it. Cheers
Cannont create DATABASE :///// HELP!
01/09/2012 - SRO Private Server - 6 Replies
Help me:///// http://img405.imageshack.us/img405/2856/65134345. png
how I can create a guild through the database?
04/29/2011 - Shaiya Private Server - 7 Replies
how I can create a guild through the database? :rtfm::rtfm: :D:D
How to create a database ?
02/17/2011 - Flyff Private Server - 1 Replies
Hello, I want to know how to create a database flyff (I don't want to download it, I want to create it) Thanks for answers :mofo:
Help to Create Database (CoEmuV2)
07/03/2009 - CO2 Private Server - 0 Replies
Hello... i need help to create database coemu v2... when i execute bath file on Navicat it say: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 10 i get this error on any sources not only coemu.... i'm studying to be a coder and if someone can help i will be gratz.



All times are GMT +1. The time now is 14:52.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.