#1
Эксперт
OFFLINE
Регистрация: 05.12.2011
Возраст: 31
Сообщений: 863
Благодарностей: 449 всего
SQL запросы в BD
Добрый Вечер.
Создание простого аккаунта 1/5/6 ап серверов.
Код:
INSERT INTO rf_user.dbo.tbl_LUAccount (Id,Password,BCodeTU) VALUES ((CONVERT(binary, 'ЛОГИН')), (CONVERT(binary, 'ПАРОЛЬ')),1)
Создание простого аккаунта на 2.2.3+
Код:
INSERT INTO RF_User.dbo.tbl_rfaccount (id,password,accounttype,birthdate,email) VALUES ((CONVERT(binary, 'ЛОГИН')), (CONVERT(binary, 'ПАРОЛЬ')),'0', '1/01/1950', 'МЫЛО');
Создание GM accaunt
Код:
DECLARE @RC int
DECLARE @id varchar(13)
DECLARE @pw varchar(13)
DECLARE @depart varchar(32)
DECLARE @class varchar(12)
DECLARE @name varchar(12)
DECLARE @birthday varchar(10)
DECLARE @grade int
DECLARE @subgrade int
SELECT @id = 'ВАШ ЛОГИН'
SELECT @pw = 'ВАШ ПАРОЛЬ'
SELECT @depart = 'none'
SELECT @class = 'GM'
SELECT @name = 'name'
SELECT @birthday = 'None'
SELECT @grade = 2
SELECT @subgrade = 4
EXEC @RC = [rf_user].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: rf_user.dbo.pInsert_Staff'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
Смена пароля GM акка
Код:
UPDATE tbl_StaffAccount SET PW = (CONVERT(binary, 'ПАРОЛЬ')) WHERE Id = 'ЛОГИН'
Смена пароля простого аккаунта:
Код:
UPDATE tbl_LUAccount SET Password = (CONVERT(binary, 'ПАРОЛЬ')) WHERE Id = 'ЛОГИН'
логины и пароли GMов
Код:
select serial,(convert(varchar, id)), (convert(varchar, PW)),realname from rf_user.dbo.tbl_staffaccount
Логины и пароли простых аккаунтов
5/6 апа
Код:
select (convert(varchar, id)), (convert(varchar, password)) from rf_user.dbo.tbl_LUAccount
223+
Код:
select (convert(varchar, id)), (convert(varchar, password)) from rf_user.dbo.tbl_rfaccount
Снятие GM прав
Код:
declare @acc varchar(13)
select @acc='!ЛОГИН'
update RF_User.dbo.tbl_staffaccount
set Grade = '0' // Это Грейд аккаунта
where ID=convert(binary, @acc)
Код:
set Grade = '0' - Простой аккаунт
set Grade = '2 - Гм аккаунт
set Grade = '3' - Аккаунт Администратора
Бан аккаунта
Код:
USE [RF_User]
DECLARE @RC int
DECLARE @nSerial int
DECLARE @nPeriod int
DECLARE @nKind int
DECLARE @szReason varchar(32)
SELECT @nSerial = 912487 //Серийный номер персонажа которого баним
SELECT @nPeriod = 99999 //Длительность бана в минутах
SELECT @nKind = 0 //не менять (кажется, 1 = бан чата)
SELECT @szReason = 'Причина, бана'
EXEC @RC = [RF_User].[dbo].[pInsert_UserBan] @nSerial, @nPeriod, @nKind, @szReason
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: RF_User.dbo.pInsert_UserBan'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine
Узнаем пароль от аккаунта ( 1 )
1/5/6 апа
Код:
SELECT convert(varchar,password) FROM tbl_LUAccount where id=convert(binary,'ЛОГИН АККАУНТА')
[COLOR="rgb(46, 139, 87)"]223+[/COLOR]
Код:
SELECT convert(varchar,password) FROM tbl_rfaccount where id=convert(binary,'ЛОГИН АККАУНТА')
Пополнение Далант/Дизен/СР/Платины
Код:
RF_World - tbl_AccountTrunk
Беллато Dalant0, Gold0
Кора Dalant1, Gold1
Аккретия Dalant2, Gold2
UPDATE RF_World.dbo.tbl_AccountTrunk SET Dalant0='777', Gold0='555' WHERE AccountSerial='123'
Полная информация об аккаунте ( логин/пароль/cash )
USE [BillCruxRF]
Удаление из базы удалённых персонажей, используя встроенные процедуры:
Код:
use [rf_world_novus]
declare @a int
select top 1 @a=serial from tbl_base where deletename<>'*'
while(not (@a is null)) begin
exec [dbo].[pDelete_AvatorData_NoSelect] @a
select top 1 @a=serial from tbl_base where deletename<>'*'
end
Вывод всех логинов и паролей из базы
223+ Простых аккаунтов
Код:
use rf_user
select convert(varchar,tbl_rfaccount.ID) as Логин,
convert(varchar,tbl_rfaccount.password) as Пароль,
convert(varchar,uilock_pw) as ФГ_Пароль,
convert(varchar,createip) as Создан_ip,
convert(varchar, lastconnectip) as ПоследнийВход_ip,
convert(varchar, createtime) as Дата_создания,
convert(varchar,email) as Email,
convert(varchar, serial) as serial
from tbl_rfaccount inner join tbl_UserAccount on tbl_rfaccount.id=tbl_useraccount.id
Для GM аккаунтов
Код:
use rf_user
select convert(varchar,tbl_StaffAccount.ID) as Логин,
convert(varchar,tbl_StaffAccount.PW) as Пароль,
convert(varchar,Grade) as Grade,
convert(varchar,SubGrade) as SubGrade,
convert(varchar,serial) as serial
from tbl_StaffAccount
Запрос на добавление ОС
Код:
use rf_world
update tbl_general set PvpPoint=кол-во ОС where serial = ( select serial from tbl_base where name='ник персонажа' )
delete from tbl_npcdata where serial = ( select serial from tbl_base where name='ник персонажа' )
Информация о полученных и потраченных кэш монетах
Код:
SELECT [Serial]
,[UserID]
,[Cash]
,[AddCashSum]
,[SpendCashSum]
FROM [BILLING].[dbo].[tbl_rfcash] WHERE UserID='логин аккаунта'
Пароль аккаунта
Код:
SELECT convert(varchar, Password) FROM [RF_User].[dbo].[tbl_rfaccount] where ID = convert(binary, 'логин')
Изменение количества пвп поинтов
Код:
UPDATE [RF_World].[dbo].[tbl_pvporderview] SET [PvpPoint]='колличество погинтов' WHERE [Serial]='ид персонажа';
Use RF_World;
UPDATE tbl_general Set PvpPoint = 0 WHERE Serial = 'ид персонажа'
Пароль ГМа
SELECT convert(varchar, PW) FROM [RF_User].[dbo].[tbl_StaffAccount] where ID = convert(binary, '!логин гма')
Пароль ФГ
Код:
SELECT convert(varchar, uilock_pw) FROM [RF_User].[dbo].[tbl_UserAccount]WHERE id=convert(binary, 'логин')
Изменение пароля
Код:
use RF_User
update tbl_rfaccount set Password=convert(binary,'нрвый пароль') where ID=convert(binary,'логин')
Изменение количества кэш монет
Код:
UPDATE tbl_rfcash set Cash='какое количество вы хотите чтобы было'
FROM [BILLING].[dbo].[tbl_rfcash] where UserID='логин'
Изменение класса игрока
Код:
use RF_World UPDATE tbl_base set Class='желаемый класс' WHERE Name='ник перса'
Изменение е-мэйла
Код:
use BILLING
UPDATE tbl_rfuser set mail='новый е-мэйл' WHERE UserID='логин'
Код:
UPDATE tbl_rfaccount set password=convert(binary(13), 'новый пароль') FROM [RF_User].[dbo].[tbl_rfaccount] where ID = convert(binary, 'логин')
Изменение пароля ФГ
Код:
UPDATE tbl_UserAccount set uilock_pw=convert(binary(13),'новый пароль') FROM [RF_User].[dbo].[tbl_UserAccount] WHERE id=convert(binary, 'логин')
Изменение секретного слова
Код:
use BILLING
UPDATE tbl_rfuser set SecretAnswer='новое секретное слово' WHERE UserID='логин'
Удаление голоса
Код:
use RF_World
update tbl_general set tmRaceBossVote='1990-01-01' where Serial='ид перса';
update tbl_supplement set IsVoted=0, VoteEnable=0, AccumPlayTime=100 where Serial='ид перса'
Смена лидера гильдии
Код:
use RF_World
UPDATE tbl_general set GuildStatus='0' WHERE Serial='ид текущего лидера ги';
use RF_World
UPDATE tbl_general set GuildStatus='2' WHERE Serial='ид нового лидера ги';
use RF_World
UPDATE tbl_Guild set MasterSerial='ид нового лидера ги' WHERE Serial='ид гильдии';
Перемещаем персонажа с акк на акк :
Код:
UPDATE RF_World_Novus.dbo.tbl_base SET AccountSerial='сериал аккаунта куда перем.', Account='логин аккаунта куда перем.' WHERE Name='ник кого перемещаем'
Последний раз редактировалось Вульф88; 28.12.2012 в 05:37 .
#2
Эксперт
OFFLINE
Регистрация: 05.12.2011
Возраст: 31
Сообщений: 863
Благодарностей: 449 всего
ГМ ПТ и Скилы 2.2.3
Код:
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_general](
[Serial] [int] NOT NULL CONSTRAINT [DF_tbl_general_Serial] DEFAULT ((-1)),
[DCK] [bit] NOT NULL CONSTRAINT [DF_tbl_general_DCK] DEFAULT ((0)),
[TotalPlayMin] [int] NOT NULL CONSTRAINT [DF_tbl_general_TotalPlayMin] DEFAULT ((0)),
[Exp] [float] NOT NULL CONSTRAINT [DF_tbl_general_Exp] DEFAULT ((0)),
[LossExp] [float] NOT NULL CONSTRAINT [DF_tbl_general_LossExp] DEFAULT ((0)),
[HP] [int] NOT NULL CONSTRAINT [DF_tbl_general_HP] DEFAULT ((1000)),
[FP] [int] NOT NULL CONSTRAINT [DF_tbl_general_FP] DEFAULT ((1000)),
[SP] [int] NOT NULL CONSTRAINT [DF_tbl_general_SP] DEFAULT ((1000)),
[DP] [int] NOT NULL CONSTRAINT [DF_tbl_general_DP] DEFAULT ((0)),
[Map] [int] NOT NULL CONSTRAINT [DF_tbl_general_Map] DEFAULT ((0)),
[X] [float] NOT NULL CONSTRAINT [DF_tbl_general_X] DEFAULT ((0)),
[Y] [float] NOT NULL CONSTRAINT [DF_tbl_general_Y] DEFAULT ((65535)),
[Z] [float] NOT NULL CONSTRAINT [DF_tbl_general_Z] DEFAULT ((0)),
[BagNum] [int] NOT NULL CONSTRAINT [DF_tbl_general_BagNum] DEFAULT ((5)),
[EK0] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK0] DEFAULT (0xFFFFFFFF),
[ED0] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED0] DEFAULT ((0)),
[EK1] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK1] DEFAULT (0xFFFFFFFF),
[ED1] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED1] DEFAULT ((0)),
[EK2] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK2] DEFAULT (0xFFFFFFFF),
[ED2] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED2] DEFAULT ((0)),
[EK3] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK3] DEFAULT (0xFFFFFFFF),
[ED3] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED3] DEFAULT ((0)),
[EK4] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK4] DEFAULT (0xFFFFFFFF),
[ED4] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED4] DEFAULT ((0)),
[EK5] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK5] DEFAULT (0xFFFFFFFF),
[ED5] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED5] DEFAULT ((0)),
[F0] [int] NOT NULL CONSTRAINT [DF_tbl_general_F0] DEFAULT (16777215),
[F1] [int] NOT NULL CONSTRAINT [DF_tbl_general_F1] DEFAULT (33554431),
[F2] [int] NOT NULL CONSTRAINT [DF_tbl_general_F2] DEFAULT (83886079),
[F3] [int] NOT NULL CONSTRAINT [DF_tbl_general_F3] DEFAULT (100663295),
[F4] [int] NOT NULL CONSTRAINT [DF_tbl_general_F4] DEFAULT (117440511),
[F5] [int] NOT NULL CONSTRAINT [DF_tbl_general_F5] DEFAULT (134217727),
[F6] [int] NOT NULL CONSTRAINT [DF_tbl_general_F6] DEFAULT (150994943),
[F7] [int] NOT NULL CONSTRAINT [DF_tbl_general_F7] DEFAULT (167772159),
[F8] [int] NOT NULL CONSTRAINT [DF_tbl_general_F8] DEFAULT (50331647),
[F9] [int] NOT NULL CONSTRAINT [DF_tbl_general_F9] DEFAULT (67108863),
[F10] [int] NOT NULL CONSTRAINT [DF_tbl_general_F10] DEFAULT (184549375),
[F11] [int] NOT NULL CONSTRAINT [DF_tbl_general_F11] DEFAULT (201326591),
[F12] [int] NOT NULL CONSTRAINT [DF_tbl_general_F12] DEFAULT (218103807),
[F13] [int] NOT NULL CONSTRAINT [DF_tbl_general_F13] DEFAULT (234881023),
[F14] [int] NOT NULL CONSTRAINT [DF_tbl_general_F14] DEFAULT (251658239),
[F15] [int] NOT NULL CONSTRAINT [DF_tbl_general_F15] DEFAULT (268435455),
[F16] [int] NOT NULL CONSTRAINT [DF_tbl_general_F16] DEFAULT (285212671),
[F17] [int] NOT NULL CONSTRAINT [DF_tbl_general_F17] DEFAULT (301989887),
[F18] [int] NOT NULL CONSTRAINT [DF_tbl_general_F18] DEFAULT (318767103),
[F19] [int] NOT NULL CONSTRAINT [DF_tbl_general_F19] DEFAULT (335544319),
[F20] [int] NOT NULL CONSTRAINT [DF_tbl_general_F20] DEFAULT (352321535),
[F21] [int] NOT NULL CONSTRAINT [DF_tbl_general_F21] DEFAULT (369098751),
[F22] [int] NOT NULL CONSTRAINT [DF_tbl_general_F22] DEFAULT (385875967),
[F23] [int] NOT NULL CONSTRAINT [DF_tbl_general_F23] DEFAULT (402653183),
[F24] [int] NOT NULL CONSTRAINT [DF_tbl_general_F24] DEFAULT (419430399),
[F25] [int] NOT NULL CONSTRAINT [DF_tbl_general_F25] DEFAULT (436207615),
[F26] [int] NOT NULL CONSTRAINT [DF_tbl_general_F26] DEFAULT (452984831),
[F27] [int] NOT NULL CONSTRAINT [DF_tbl_general_F27] DEFAULT (469762047),
[F28] [int] NOT NULL CONSTRAINT [DF_tbl_general_F28] DEFAULT (503316479),
[F29] [int] NOT NULL CONSTRAINT [DF_tbl_general_F29] DEFAULT (520093695),
[F30] [int] NOT NULL CONSTRAINT [DF_tbl_general_F30] DEFAULT (536870911),
[F31] [int] NOT NULL CONSTRAINT [DF_tbl_general_F31] DEFAULT (553648127),
[F32] [int] NOT NULL CONSTRAINT [DF_tbl_general_F32] DEFAULT (570425343),
[F33] [int] NOT NULL CONSTRAINT [DF_tbl_general_F33] DEFAULT (587202559),
[F34] [int] NOT NULL CONSTRAINT [DF_tbl_general_F34] DEFAULT (603979775),
[F35] [int] NOT NULL CONSTRAINT [DF_tbl_general_F35] DEFAULT (620756991),
[F36] [int] NOT NULL CONSTRAINT [DF_tbl_general_F36] DEFAULT (637534207),
[F37] [int] NOT NULL CONSTRAINT [DF_tbl_general_F37] DEFAULT (654311423),
[F38] [int] NOT NULL CONSTRAINT [DF_tbl_general_F38] DEFAULT (671088639),
[F39] [int] NOT NULL CONSTRAINT [DF_tbl_general_F39] DEFAULT (687865855),
[F40] [int] NOT NULL CONSTRAINT [DF_tbl_general_F40] DEFAULT (704643071),
[F41] [int] NOT NULL CONSTRAINT [DF_tbl_general_F41] DEFAULT (721420287),
[F42] [int] NOT NULL CONSTRAINT [DF_tbl_general_F42] DEFAULT (738197503),
[F43] [int] NOT NULL CONSTRAINT [DF_tbl_general_F43] DEFAULT (771751935),
[F44] [int] NOT NULL CONSTRAINT [DF_tbl_general_F44] DEFAULT (788529151),
[F45] [int] NOT NULL CONSTRAINT [DF_tbl_general_F45] DEFAULT (805306367),
[F46] [int] NOT NULL CONSTRAINT [DF_tbl_general_F46] DEFAULT (822083583),
[F47] [int] NOT NULL CONSTRAINT [DF_tbl_general_F47] DEFAULT (838860799),
[F48] [int] NOT NULL CONSTRAINT [DF_tbl_general_F48] DEFAULT (855638015),
[F49] [int] NOT NULL CONSTRAINT [DF_tbl_general_F49] DEFAULT (872415231),
[F50] [int] NOT NULL CONSTRAINT [DF_tbl_general_F50] DEFAULT (889192447),
[F51] [int] NOT NULL CONSTRAINT [DF_tbl_general_F51] DEFAULT (905969663),
[F52] [int] NOT NULL CONSTRAINT [DF_tbl_general_F52] DEFAULT (922746879),
[F53] [int] NOT NULL CONSTRAINT [DF_tbl_general_F53] DEFAULT (939524095),
[F54] [int] NOT NULL CONSTRAINT [DF_tbl_general_F54] DEFAULT (956301311),
[F55] [int] NOT NULL CONSTRAINT [DF_tbl_general_F55] DEFAULT (973078527),
[F56] [int] NOT NULL CONSTRAINT [DF_tbl_general_F56] DEFAULT (989855743),
[F57] [int] NOT NULL CONSTRAINT [DF_tbl_general_F57] DEFAULT (1006632959),
[F58] [int] NOT NULL CONSTRAINT [DF_tbl_general_F58] DEFAULT (1040187391),
[F59] [int] NOT NULL CONSTRAINT [DF_tbl_general_F59] DEFAULT (1056964607),
[F60] [int] NOT NULL CONSTRAINT [DF_tbl_general_F60] DEFAULT (1073741823),
[F61] [int] NOT NULL CONSTRAINT [DF_tbl_general_F61] DEFAULT (1090519039),
[F62] [int] NOT NULL CONSTRAINT [DF_tbl_general_F62] DEFAULT (1107296255),
[F63] [int] NOT NULL CONSTRAINT [DF_tbl_general_F63] DEFAULT (1124073471),
[F64] [int] NOT NULL CONSTRAINT [DF_tbl_general_F64] DEFAULT (1140850687),
[F65] [int] NOT NULL CONSTRAINT [DF_tbl_general_F65] DEFAULT (1157627903),
[F66] [int] NOT NULL CONSTRAINT [DF_tbl_general_F66] DEFAULT (1174405119),
[F67] [int] NOT NULL CONSTRAINT [DF_tbl_general_F67] DEFAULT (1191182335),
[F68] [int] NOT NULL CONSTRAINT [DF_tbl_general_F68] DEFAULT (1207959551),
[F69] [int] NOT NULL CONSTRAINT [DF_tbl_general_F69] DEFAULT (1224736767),
[F70] [int] NOT NULL CONSTRAINT [DF_tbl_general_F70] DEFAULT (1241513983),
[F71] [int] NOT NULL CONSTRAINT [DF_tbl_general_F71] DEFAULT (1258291199),
[F72] [int] NOT NULL CONSTRAINT [DF_tbl_general_F72] DEFAULT (1275068415),
[F73] [int] NOT NULL CONSTRAINT [DF_tbl_general_F73] DEFAULT (1308622847),
[F74] [int] NOT NULL CONSTRAINT [DF_tbl_general_F74] DEFAULT (1325400063),
[F75] [int] NOT NULL CONSTRAINT [DF_tbl_general_F75] DEFAULT (1342177279),
[F76] [int] NOT NULL CONSTRAINT [DF_tbl_general_F76] DEFAULT (1358954495),
[F77] [int] NOT NULL CONSTRAINT [DF_tbl_general_F77] DEFAULT (1375731711),
[F78] [int] NOT NULL CONSTRAINT [DF_tbl_general_F78] DEFAULT (1392508927),
[F79] [int] NOT NULL CONSTRAINT [DF_tbl_general_F79] DEFAULT (1409286143),
[F80] [int] NOT NULL CONSTRAINT [DF_tbl_general_F80] DEFAULT (1426063359),
[F81] [int] NOT NULL CONSTRAINT [DF_tbl_general_F81] DEFAULT (1442840575),
[F82] [int] NOT NULL CONSTRAINT [DF_tbl_general_F82] DEFAULT (1459617791),
[F83] [int] NOT NULL CONSTRAINT [DF_tbl_general_F83] DEFAULT (1476395007),
[F84] [int] NOT NULL CONSTRAINT [DF_tbl_general_F84] DEFAULT (1493172223),
[F85] [int] NOT NULL CONSTRAINT [DF_tbl_general_F85] DEFAULT (1509949439),
[F86] [int] NOT NULL CONSTRAINT [DF_tbl_general_F86] DEFAULT (1526726655),
[F87] [int] NOT NULL CONSTRAINT [DF_tbl_general_F87] DEFAULT (1543503871),
[F88] [int] NOT NULL CONSTRAINT [DF_tbl_general_F88] DEFAULT (0xFFFFFFFF),
[F89] [int] NOT NULL CONSTRAINT [DF_tbl_general_F89] DEFAULT (0xFFFFFFFF),
[F90] [int] NOT NULL CONSTRAINT [DF_tbl_general_F90] DEFAULT (0xFFFFFFFF),
[F91] [int] NOT NULL CONSTRAINT [DF_tbl_general_F91] DEFAULT (0xFFFFFFFF),
[F92] [int] NOT NULL CONSTRAINT [DF_tbl_general_F92] DEFAULT (0xFFFFFFFF),
[F93] [int] NOT NULL CONSTRAINT [DF_tbl_general_F93] DEFAULT (0xFFFFFFFF),
[F94] [int] NOT NULL CONSTRAINT [DF_tbl_general_F94] DEFAULT (0xFFFFFFFF),
[F95] [int] NOT NULL CONSTRAINT [DF_tbl_general_F95] DEFAULT (0xFFFFFFFF),
[F96] [int] NOT NULL CONSTRAINT [DF_tbl_general_F96] DEFAULT (0xFFFFFFFF),
[F97] [int] NOT NULL CONSTRAINT [DF_tbl_general_F97] DEFAULT (0xFFFFFFFF),
[F98] [int] NOT NULL CONSTRAINT [DF_tbl_general_F98] DEFAULT (0xFFFFFFFF),
[F99] [int] NOT NULL CONSTRAINT [DF_tbl_general_F99] DEFAULT (0xFFFFFFFF),
[AK0] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_AK0] DEFAULT (0xFF),
[AD0] [bigint] NOT NULL CONSTRAINT [DF_tbl_general_AD0] DEFAULT ((0)),
[AP0] [int] NOT NULL CONSTRAINT [DF_tbl_general_AP] DEFAULT ((0)),
[AK1] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_AK01] DEFAULT (0xFF),
[AD1] [bigint] NOT NULL CONSTRAINT [DF_tbl_general_AD1] DEFAULT ((0)),
[AP1] [int] NOT NULL CONSTRAINT [DF_tbl_general_AP1] DEFAULT ((0)),
[AK2] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_AK01_1] DEFAULT (0xFF),
[AD2] [bigint] NOT NULL CONSTRAINT [DF_tbl_general_AD2] DEFAULT ((0)),
[AP2] [int] NOT NULL CONSTRAINT [DF_tbl_general_AP2] DEFAULT ((0)),
[AK3] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_AK01_2] DEFAULT (0xFF),
[AD3] [bigint] NOT NULL CONSTRAINT [DF_tbl_general_AD3] DEFAULT ((0)),
[AP3] [int] NOT NULL CONSTRAINT [DF_tbl_general_AP3] DEFAULT ((0)),
[WM0] [int] NOT NULL CONSTRAINT [DF_tbl_general_WM0] DEFAULT ((999999999)),
[WM1] [int] NOT NULL CONSTRAINT [DF_tbl_general_WM1] DEFAULT ((999999999)),
[DM] [int] NOT NULL CONSTRAINT [DF_tbl_general_DM] DEFAULT ((999999999)),
[PM] [int] NOT NULL CONSTRAINT [DF_tbl_general_PM] DEFAULT ((999999999)),
[MI0] [int] NOT NULL CONSTRAINT [DF_tbl_general_MI] DEFAULT ((999999999)),
[MI1] [int] NOT NULL CONSTRAINT [DF_tbl_general_MI1] DEFAULT ((999999999)),
[MI2] [int] NOT NULL CONSTRAINT [DF_tbl_general_MI2] DEFAULT ((999999999)),
[SR] [int] NOT NULL CONSTRAINT [DF_tbl_general_SR] DEFAULT ((999999999)),
[FM0] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM0] DEFAULT ((999999999)),
[FM1] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM1] DEFAULT ((999999999)),
[FM2] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM2] DEFAULT ((999999999)),
[FM3] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM3] DEFAULT ((999999999)),
[FM4] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM4] DEFAULT ((999999999)),
[FM5] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM5] DEFAULT ((999999999)),
[FM6] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM6] DEFAULT ((999999999)),
[FM7] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM7] DEFAULT ((999999999)),
[FM8] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM8] DEFAULT ((999999999)),
[FM9] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM9] DEFAULT ((999999999)),
[FM10] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM10] DEFAULT ((999999999)),
[FM11] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM11] DEFAULT ((999999999)),
[FM12] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM12] DEFAULT ((999999999)),
[FM13] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM13] DEFAULT ((999999999)),
[FM14] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM14] DEFAULT ((999999999)),
[FM15] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM15] DEFAULT ((999999999)),
[FM16] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM16] DEFAULT ((999999999)),
[FM17] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM17] DEFAULT ((999999999)),
[FM18] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM18] DEFAULT ((999999999)),
[FM19] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM19] DEFAULT ((999999999)),
[FM20] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM20] DEFAULT ((999999999)),
[FM21] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM21] DEFAULT ((999999999)),
[FM22] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM22] DEFAULT ((999999999)),
[FM23] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM23] DEFAULT ((999999999)),
[SM0] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM0] DEFAULT ((999999999)),
[SM1] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM1] DEFAULT ((999999999)),
[SM2] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM2] DEFAULT ((999999999)),
[SM3] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM3] DEFAULT ((999999999)),
[SM4] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM4] DEFAULT ((999999999)),
[SM5] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM5] DEFAULT ((999999999)),
[SM6] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM6] DEFAULT ((999999999)),
[SM7] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM7] DEFAULT ((999999999)),
[SM8] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM8] DEFAULT ((999999999)),
[SM9] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM9] DEFAULT ((999999999)),
[SM10] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM10] DEFAULT ((999999999)),
[SM11] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM11] DEFAULT ((999999999)),
[SM12] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM12] DEFAULT ((999999999)),
[SM13] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM13] DEFAULT ((999999999)),
[SM14] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM14] DEFAULT ((999999999)),
[SM15] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM15] DEFAULT ((999999999)),
[SM16] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM16] DEFAULT ((999999999)),
[SM17] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM17] DEFAULT ((999999999)),
[SM18] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM18] DEFAULT ((999999999)),
[SM19] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM19] DEFAULT ((999999999)),
[SM20] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM20] DEFAULT ((999999999)),
[SM21] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM21] DEFAULT ((999999999)),
[SM22] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM22] DEFAULT ((999999999)),
[SM23] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM23] DEFAULT ((999999999)),
[SM24] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM01] DEFAULT ((999999999)),
[SM25] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM02] DEFAULT ((999999999)),
[SM26] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM03] DEFAULT ((999999999)),
[SM27] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM04] DEFAULT ((999999999)),
[SM28] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM05] DEFAULT ((999999999)),
[SM29] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM06] DEFAULT ((999999999)),
[SM30] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM01_1] DEFAULT ((999999999)),
[SM31] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM211] DEFAULT ((999999999)),
[SM32] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM221] DEFAULT ((999999999)),
[SM33] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM231] DEFAULT ((999999999)),
[SM34] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM241] DEFAULT ((999999999)),
[SM35] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM251] DEFAULT ((999999999)),
[SM36] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM261] DEFAULT ((999999999)),
[SM37] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM271] DEFAULT ((999999999)),
[SM38] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM281] DEFAULT ((999999999)),
[SM39] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM291] DEFAULT ((999999999)),
[SM40] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM40] DEFAULT ((999999999)),
[SM41] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM401] DEFAULT ((999999999)),
[SM42] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM402] DEFAULT ((999999999)),
[SM43] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM403] DEFAULT ((999999999)),
[SM44] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM404] DEFAULT ((999999999)),
[SM45] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM405] DEFAULT ((999999999)),
[SM46] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM406] DEFAULT ((999999999)),
[SM47] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM407] DEFAULT ((999999999)),
[SM48] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM408] DEFAULT ((999999999)),
[SM49] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM409] DEFAULT ((999999999)),
[LeftResList] [varchar](160) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [DF_tbl_general_LeftResList] DEFAULT ('*'),
[Class0] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_Class0] DEFAULT ((-1)),
[Class1] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_Class1] DEFAULT ((-1)),
[Class2] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_Class2] DEFAULT ((-1)),
[ClassInitCnt] [int] NOT NULL CONSTRAINT [DF_tbl_general_ClassInitCnt] DEFAULT ((0)),
[LastClassGrade] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_LastClassGrade] DEFAULT ((0)),
[PvpPoint] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvPPoint] DEFAULT ((0)),
[PvpCashBag] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvPCashBag] DEFAULT ((0)),
[BindMapCode] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [DF_tbl_general_BindMapCode] DEFAULT ('0'),
[BindDummy] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [DF_tbl_general_BindDummy] DEFAULT ('0'),
[GuildSerial] [int] NULL CONSTRAINT [DF_tbl_General_GuildSerial] DEFAULT (0xFFFFFFFF),
[GuildGrade] [tinyint] NULL CONSTRAINT [DF_tbl_General_GuildGrade] DEFAULT (0xFF),
[GuildRank] [smallint] NULL CONSTRAINT [DF_tbl_general_GuildRank] DEFAULT (0xFFFF),
[tmRaceBossVote] [datetime] NOT NULL CONSTRAINT [DF_tbl_general_tmracebossvote] DEFAULT ('1990-01-01'),
[RDDelay] [int] NOT NULL CONSTRAINT [DF_tbl_general_RDDelay] DEFAULT ((0)),
[TakeLastMentalTicket] [int] NOT NULL CONSTRAINT [DF_tbl_general_TakeLastMentalTicket] DEFAULT ((0)),
[TakeLastCriTicket] [int] NOT NULL CONSTRAINT [DF_tbl_general_TakeLastCriTicket] DEFAULT ((0)),
[ES0] [bigint] NOT NULL DEFAULT ((0)),
[ET0] [int] NOT NULL DEFAULT (0xFFFFFFFF),
[ES1] [bigint] NOT NULL DEFAULT ((0)),
[ET1] [int] NOT NULL DEFAULT (0xFFFFFFFF),
[ES2] [bigint] NOT NULL DEFAULT ((0)),
[ET2] [int] NOT NULL DEFAULT (0xFFFFFFFF),
[ES3] [bigint] NOT NULL DEFAULT ((0)),
[ET3] [int] NOT NULL DEFAULT (0xFFFFFFFF),
[ES4] [bigint] NOT NULL DEFAULT ((0)),
[ET4] [int] NOT NULL DEFAULT (0xFFFFFFFF),
[ES5] [bigint] NOT NULL DEFAULT ((0)),
[ET5] [int] NOT NULL DEFAULT (0xFFFFFFFF),
[AS0] [bigint] NOT NULL DEFAULT ((0)),
[AS1] [bigint] NOT NULL DEFAULT ((0)),
[AS2] [bigint] NOT NULL DEFAULT ((0)),
[AS3] [bigint] NOT NULL DEFAULT ((0)),
[FS0] [bigint] NOT NULL DEFAULT ((79761210802176)),
[FS1] [bigint] NOT NULL DEFAULT ((79761210802177)),
[FS2] [bigint] NOT NULL DEFAULT ((79761210802178)),
[FS3] [bigint] NOT NULL DEFAULT ((79761210802179)),
[FS4] [bigint] NOT NULL DEFAULT ((79761210802180)),
[FS5] [bigint] NOT NULL DEFAULT ((79761210802181)),
[FS6] [bigint] NOT NULL DEFAULT ((79761210802182)),
[FS7] [bigint] NOT NULL DEFAULT ((79761210802183)),
[FS8] [bigint] NOT NULL DEFAULT ((79761204051968)),
[FS9] [bigint] NOT NULL DEFAULT ((79761204051969)),
[FS10] [bigint] NOT NULL DEFAULT ((79761204051970)),
[FS11] [bigint] NOT NULL DEFAULT ((79761204051971)),
[FS12] [bigint] NOT NULL DEFAULT ((79761204051972)),
[FS13] [bigint] NOT NULL DEFAULT ((79761204051973)),
[FS14] [bigint] NOT NULL DEFAULT ((79761204051974)),
[FS15] [bigint] NOT NULL DEFAULT ((79761204051975)),
[FS16] [bigint] NOT NULL DEFAULT ((79761204051976)),
[FS17] [bigint] NOT NULL DEFAULT ((79761204051977)),
[FS18] [bigint] NOT NULL DEFAULT ((79761204051978)),
[FS19] [bigint] NOT NULL DEFAULT ((79761204051979)),
[FS20] [bigint] NOT NULL DEFAULT ((79761204051980)),
[FS21] [bigint] NOT NULL DEFAULT ((79761204051981)),
[FS22] [bigint] NOT NULL DEFAULT ((79761204051982)),
[FS23] [bigint] NOT NULL DEFAULT ((79761204051983)),
[FS24] [bigint] NOT NULL DEFAULT ((79761204051984)),
[FS25] [bigint] NOT NULL DEFAULT ((79761204051985)),
[FS26] [bigint] NOT NULL DEFAULT ((79761204051986)),
[FS27] [bigint] NOT NULL DEFAULT ((79761204051987)),
[FS28] [bigint] NOT NULL DEFAULT ((79761204051988)),
[FS29] [bigint] NOT NULL DEFAULT ((79761204051989)),
[FS30] [bigint] NOT NULL DEFAULT ((79761204051990)),
[FS31] [bigint] NOT NULL DEFAULT ((79761204051991)),
[FS32] [bigint] NOT NULL DEFAULT ((79761204051992)),
[FS33] [bigint] NOT NULL DEFAULT ((79761204051993)),
[FS34] [bigint] NOT NULL DEFAULT ((79761204051994)),
[FS35] [bigint] NOT NULL DEFAULT ((79761204051995)),
[FS36] [bigint] NOT NULL DEFAULT ((79761204051996)),
[FS37] [bigint] NOT NULL DEFAULT ((79761204051997)),
[FS38] [bigint] NOT NULL DEFAULT ((79761204051998)),
[FS39] [bigint] NOT NULL DEFAULT ((79761204051999)),
[FS40] [bigint] NOT NULL DEFAULT ((79761204052000)),
[FS41] [bigint] NOT NULL DEFAULT ((79761204052001)),
[FS42] [bigint] NOT NULL DEFAULT ((79761204052002)),
[FS43] [bigint] NOT NULL DEFAULT ((79761204052003)),
[FS44] [bigint] NOT NULL DEFAULT ((79761204052004)),
[FS45] [bigint] NOT NULL DEFAULT ((79761204052005)),
[FS46] [bigint] NOT NULL DEFAULT ((79761204052006)),
[FS47] [bigint] NOT NULL DEFAULT ((79761204052007)),
[FS48] [bigint] NOT NULL DEFAULT ((79761204052008)),
[FS49] [bigint] NOT NULL DEFAULT ((79761204052009)),
[FS50] [bigint] NOT NULL DEFAULT ((79761204052010)),
[FS51] [bigint] NOT NULL DEFAULT ((79761204052011)),
[FS52] [bigint] NOT NULL DEFAULT ((79761204052012)),
[FS53] [bigint] NOT NULL DEFAULT ((79761204052013)),
[FS54] [bigint] NOT NULL DEFAULT ((79761204052014)),
[FS55] [bigint] NOT NULL DEFAULT ((79761204052015)),
[FS56] [bigint] NOT NULL DEFAULT ((79761204052016)),
[FS57] [bigint] NOT NULL DEFAULT ((79761204052017)),
[FS58] [bigint] NOT NULL DEFAULT ((79761204052018)),
[FS59] [bigint] NOT NULL DEFAULT ((79761204052019)),
[FS60] [bigint] NOT NULL DEFAULT ((79761204052020)),
[FS61] [bigint] NOT NULL DEFAULT ((79761204052021)),
[FS62] [bigint] NOT NULL DEFAULT ((79761204052022)),
[FS63] [bigint] NOT NULL DEFAULT ((79761204052023)),
[FS64] [bigint] NOT NULL DEFAULT ((79761204052024)),
[FS65] [bigint] NOT NULL DEFAULT ((79761204052025)),
[FS66] [bigint] NOT NULL DEFAULT ((79761204052026)),
[FS67] [bigint] NOT NULL DEFAULT ((79761204052027)),
[FS68] [bigint] NOT NULL DEFAULT ((79761204052028)),
[FS69] [bigint] NOT NULL DEFAULT ((79761204052029)),
[FS70] [bigint] NOT NULL DEFAULT ((79761204052030)),
[FS71] [bigint] NOT NULL DEFAULT ((79761204052031)),
[FS72] [bigint] NOT NULL DEFAULT ((79761204052032)),
[FS73] [bigint] NOT NULL DEFAULT ((79761204052033)),
[FS74] [bigint] NOT NULL DEFAULT ((79761204052034)),
[FS75] [bigint] NOT NULL DEFAULT ((79761204052035)),
[FS76] [bigint] NOT NULL DEFAULT ((79761204052036)),
[FS77] [bigint] NOT NULL DEFAULT ((79761204052037)),
[FS78] [bigint] NOT NULL DEFAULT ((79761204052038)),
[FS79] [bigint] NOT NULL DEFAULT ((79761204052039)),
[FS80] [bigint] NOT NULL DEFAULT ((79761204052040)),
[FS81] [bigint] NOT NULL DEFAULT ((79761204052041)),
[FS82] [bigint] NOT NULL DEFAULT ((79761204052042)),
[FS83] [bigint] NOT NULL DEFAULT ((79761204052043)),
[FS84] [bigint] NOT NULL DEFAULT ((79761204052044)),
[FS85] [bigint] NOT NULL DEFAULT ((79761204052045)),
[FS86] [bigint] NOT NULL DEFAULT ((79761204052046)),
[FS87] [bigint] NOT NULL DEFAULT ((79761204052047)),
[FS88] [bigint] NOT NULL DEFAULT ((0)),
[FS89] [bigint] NOT NULL DEFAULT ((0)),
[FS90] [bigint] NOT NULL DEFAULT ((0)),
[FS91] [bigint] NOT NULL DEFAULT ((0)),
[FS92] [bigint] NOT NULL DEFAULT ((0)),
[FS93] [bigint] NOT NULL DEFAULT ((0)),
[FS94] [bigint] NOT NULL DEFAULT ((0)),
[FS95] [bigint] NOT NULL DEFAULT ((0)),
[FS96] [bigint] NOT NULL DEFAULT ((0)),
[FS97] [bigint] NOT NULL DEFAULT ((0)),
[FS98] [bigint] NOT NULL DEFAULT ((0)),
[FS99] [bigint] NOT NULL DEFAULT ((0)),
[MaxLevel] [int] NOT NULL DEFAULT ((0)),
[PvP_0] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvP_0] DEFAULT ((0)),
[PK_0] [int] NOT NULL CONSTRAINT [DF_tbl_general_PK_0] DEFAULT ((0)),
[PvP_1] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvP_1] DEFAULT ((0)),
[PK_1] [int] NOT NULL CONSTRAINT [DF_tbl_general_PK_1] DEFAULT ((0)),
[PvP_2] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvP_2] DEFAULT ((0)),
[PK_2] [int] NOT NULL CONSTRAINT [DF_tbl_general_PK_2] DEFAULT ((0)),
[CharacterGrade] [int] NULL CONSTRAINT [DF_tbl_general__CharacterGrade] DEFAULT ((0)),
[Die_0] [int] NOT NULL CONSTRAINT [DF_tbl_general_Die_0] DEFAULT ((0)),
[Die_1] [int] NOT NULL CONSTRAINT [DF_tbl_general_Die_1] DEFAULT ((0)),
[Die_2] [int] NOT NULL CONSTRAINT [DF_tbl_general_Die_2] DEFAULT ((0)),
[GuildStatus] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_GuildStatus] DEFAULT ((0)),
CONSTRAINT [PK_tbl_general] PRIMARY KEY CLUSTERED
(
[Serial] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Собрано по форуму rfc
Последний раз редактировалось Вульф88; 28.12.2012 в 05:30 .
#3
Эксперт
OFFLINE
Регистрация: 05.12.2011
Возраст: 31
Сообщений: 863
Благодарностей: 449 всего
Цитата:
Сообщение от
Вульф88
Не вставляй SQL запросы в php
Так же указываем копирайты.
Взято и найдено все на rfchetse и взято пару запросов с мд
Копипаст указан во втором сообщение !
Добавлено через 19 часов 53 минуты
Вульф прошу изменить теги на "коде" - а то редактировать не могу.// + почти темку.
Последний раз редактировалось ЕНЫ; 27.12.2012 в 19:42 .
Причина: Добавлено сообщение
#4
Скриптер RF Online
OFFLINE
Регистрация: 29.03.2010
Возраст: 36
Сообщений: 281
Благодарностей: 1,074 всего
Цитата:
Сообщение от
ЕНЫ
Вульф прошу изменить теги на "коде" - а то редактировать не могу.// + почти темку.
Поправил.
#5
Эксперт
OFFLINE
Регистрация: 05.12.2011
Возраст: 31
Сообщений: 863
Благодарностей: 449 всего
Выдача предмета в инвентарь
Код:
INSERT INTO tbl_ItemCharge (nAvatorSerial, nItemCode_K, nItemCode_U, nItemCode_D, T) VALUES (%d, %s, %s, %d, %d)
nAvatorSerial - серийный номер персонажа
nItemCode_K - номер предмета (SQL type)
nItemCode_U - заточка предмета (HEX)
nItemCode_D - количесство предмета
T - время жизни предмета (вроде unix timestamp)
для SQL кода предмета
http://rfdb.info/item/
//NettSoul
#6
Эксперт
OFFLINE
Регистрация: 05.12.2011
Возраст: 31
Сообщений: 863
Благодарностей: 449 всего
Полезный запрос на обновление tbl_user for BILLING'a
Код:
insert into BILLING.dbo.tbl_personal_billing (id, BillingType, EndDate, RemainTime)
select id, 1, GETDATE(), 0 from RF_USER.dbo.tbl_rfaccount
insert into BILLING.dbo.tbl_user (UserID, Cash)
select id, 0 from RF_USER.dbo.tbl_rfaccount
update RF_User.dbo.tbl_rfaccount
set accounttype = 1
where accounttype = 0
Запрос делаем
Databases
#7
Эксперт
OFFLINE
Регистрация: 05.12.2011
Возраст: 31
Сообщений: 863
Благодарностей: 449 всего
Данный запрос на обновление строки в BILLINGE,на выдачу премиум аккаунта.
Код:
UPDATE tbl_personal_billing SET BillingType = '1'
BillingType = '1' - 1 выкл. / 2 вкл.
Очки Охоты:
Код:
UPDATE [RF_WORLD_NOVUS].[dbo].[tbl_supplement] SET [ActionPoint_0]='Кол-во' WHERE [Serial]='ид персонажа'
Очки Обработки:
Код:
UPDATE [RF_WORLD_NOVUS].[dbo].[tbl_supplement] SET [ActionPoint_1]='Кол-во' WHERE [Serial]='ид персонажа'
Золотые Очки:
Код:
UPDATE [RF_WORLD_NOVUS].[dbo].[tbl_supplement] SET [ActionPoint_2]='Кол-во' WHERE [Serial]='ид персонажа'
#8
Msg 102, Level 15, State 1, Line 10
#9
Постоялец
OFFLINE
Регистрация: 31.01.2012
Сообщений: 100
пишет что этот акк уже зареган
За + в мнения,отвечу тем же)
За ап спасибо!)
Хочешь кинуть?
#10
Эксперт
OFFLINE
Регистрация: 05.12.2011
Возраст: 31
Сообщений: 863
Благодарностей: 449 всего
нет, он ругается на воск. знак.
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения
HTML код Выкл.
