Mu Online Sql Scripts

View previous topic View next topic Go down

Mu Online Sql Scripts

Post by bugme on Wed Nov 04, 2015 4:26 am

OPEN sql query paste Code

alter table Character add BanPost int not null default 0
alter table Character add GrandResets int not null default 0
alter table Character add SkyEventWins int not null default 0

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

Reset VOTE ranking

use MuOnline
Update memb_info set votes='0'

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

Reset VOTE BC Ranking

use MuOnline
Update EVENT_INFO_BC set Point='0'

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

Create VOTE TABLE ranking


CREATE TABLE [dbo].[Votes] (
[id] [int] NULL ,
[link] [varchar] (255) NULL ,
[banner] [varchar] (255) NULL ,
[credits] [int] NULL ,
[vote_time] [int] NULL ,
[show] [int] NULL ,
) ON [PRIMARY]
;

CREATE TABLE [dbo].[Vote_Log] (
[id] [int] NULL ,
[uid] [int] NULL ,
[ip] [varchar] (100) NULL ,
[username] [varchar] (100) NULL ,
[voteend] [int] NULL ,
) ON [PRIMARY]
;

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

new character + stats


UPDATE Character
SET Strength='Points'
WHERE Strength<28

UPDATE Character
SET Dexterity='Points'
WHERE Dexterity<20

UPDATE Character
SET Vitality='Points'
WHERE Vitality<25

UPDATE Character
SET Energy='Points'
WHERE Energy<10

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

total time basa

----

reset total time



use MuOnline
update Character
Set TotalTime ='0'

use MuOnline
update MEMB_STAT
Set TotalTime ='0'

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

TotalTime

Βλθηΰςε β query analyzer Δξαΰβςε ςεηθ 2 κξδΰ β MuOnline:

---------

alter table Character add TotalTime int not null default 0  
alter table MEMB_STAT add TotalTime int not null default 0

--------

Ρλεδ ςξβΰ βλθηΰςε β MuOnline Οπξφεδσπθςε ςϊπρθςε WZ_DISCONNECT_MEMB θ ηΰμερςβΰςε ρ ςΰηθ οπξφεδσπΰ

-------

CREATE PROCEDURE WZ_DISCONNECT_MEMB
@memb___id varchar(10)
AS
Begin    
set nocount on
   Declare  @find_id varchar(10)    
  Declare  @con_tm DATETIME
   Declare @ConnectStat tinyint
   Set @ConnectStat = 0    
   Set @find_id = 'NOT'
   select @find_id = S.memb___id, @con_tm = S.ConnectTM from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id COLLATE DATABASE_DEFAULT
          where I.memb___id = @memb___id
   if( @find_id <> 'NOT' )    
   begin        
       update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate(), TotalTime = TotalTime+(DATEDIFF(mi,ConnectTM,getdate()))
        where memb___id = @memb___id
           -- TIMEONLINE MOD by john_d
        update character set TotalTime = TotalTime+(DATEDIFF(mi,@con_tm,getdate()))
        from character as c INNER join AccountCharacter as ac ON
        c.Name = ac.GameIDC where c.accountid = @memb___id
   end
end


GO

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

Your web shop no install? OPEN sql query paste Code:



drop table WebShop
Go
drop table WebShop_LOG
Go
drop table WebShop_UI
Go
drop table MEMB_CREDITS
go
drop procedure XCredits
go
Drop table WebShop_Groups
Go
Drop table WebShop_Feedback
Go
drop table WebShop_IpBlock
Go


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



Add GrReset table

alter table character add GrResets int not null default 0




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


sms log


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SMS_LOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SMS_LOG]
GO

CREATE TABLE [dbo].[SMS_LOG] (
[acc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[SMS_nomer] [int] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SMS_LOG] WITH NOCHECK ADD
CONSTRAINT [DF_SMS_LOG_SMS_nomer] DEFAULT (0) FOR [SMS_nomer]
GO


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




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

Rena and Stone Ranking


Use MuOnline
CREATE TABLE StoneRena ([acc] [varchar] (10)  NOT NULL ,[Stone] [bigint] NOT NULL default (0),[Rena] [bigint] NOT NULL default (0)) ON [PRIMARY];


------------------------------------------------------------------------------------------------------------------------------------
avatar
bugme
V.I.P
V.I.P

Брой мнения : 21
Points : 70
Reputation : 13
Join date : 2014-12-11
Age : 28
Местожителство : Bulgaria - Burgas

View user profile http://wartune.bulgarianforum.net

Back to top Go down

Re: Mu Online Sql Scripts

Post by VIRUS on Wed Nov 04, 2015 5:59 pm

good post thx poster
avatar
VIRUS
Member
Member

Брой мнения : 9
Points : 13
Reputation : 0
Join date : 2014-12-10
Age : 32

View user profile

Back to top Go down

Re: Mu Online Sql Scripts

Post by Asgard on Wed Nov 04, 2015 7:04 pm

---
Guild Score BUG -
---
UPDATE Guild
SET G_Score=('0')
WHERE G_Score<-1

---
Give Credits For Game Play Time
---
UPDATE MEMB_CREDITS
SET Credits = Credits + 50
FROM MEMB_CREDITS JOIN MEMB_STAT ON MEMB_CREDITS.memb___id = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE OnlineHours = 1 And ConnectStat = 1


---
DELETE ALL RESETS
---
UPDATE Character
SET Resets=('0')
WHERE Resets>0


---
DELETE ALL INVENTORIES
---
UPDATE Character
SET Inventory=('')

---
DELETE ALL WAREHOUSES
---
UPDATE warehouse
SET Items=('')

---
DELETE One Character INVENTORY
---
UPDATE Character
SET Inventory=('')
WHERE Name='Omaru'

---
DELETE One WAREHOUSE
---
UPDATE warehouse
SET Items=('')
WHERE AccountID='Omaru'

---
UNBAN ALL Players
---
UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('1')


---
AUTO RESTART
---
UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349

!!! Download links are open only to registered users !!!


!!! Линковете за сваляне са отворени единствено за регистрирани потребители !!!

[You must be registered and logged in to see this image.] You don't make the rules! [You must be registered and logged in to see this image.]
avatar
Asgard
Admin
Admin

Брой мнения : 37
Points : 119
Reputation : 14
Join date : 2014-12-10
Age : 29
Местожителство : Germany

View user profile http://WARTUNEMU.COM

Back to top Go down

Re: Mu Online Sql Scripts

Post by Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum