Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > 4Story
You last visited: Today at 16:03

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

Advertisement



[Procedure] TCharCount by Glossy

Discussion on [Procedure] TCharCount by Glossy within the 4Story forum part of the MMORPGs category.

Reply
 
Old   #1
 
glossypvp's Avatar
 
elite*gold: 0
Join Date: Aug 2011
Posts: 659
Received Thanks: 658
[Procedure] TCharCount by Glossy

Hi,
I have just created a little MSSQL procedure with counts the characters on your server and display the value.

Code:
Code:
/*
TCharCount procedure by GlossyPvP / Holy
*/

ALTER PROCEDURE [dbo].[TCharcount]
AS
BEGIN
Declare @Cou varchar(10)
Declare @Num nvarchar(100)
SET @COU = (SELECT COUNT(*)AS TCharCount FROM TChartable);
SET @Num = 'Number of characters: ';
Print @Num + @Cou
END
Instructions:
Go to TGAME_GSP => dbo = > Functions.
Then right click, New Function . Then give a name, and select 'Procedure'.

Peace!
glossypvp is offline  
Thanks
2 Users
Old 02/10/2013, 18:26   #2
 
--N0N€--'s Avatar
 
elite*gold: 1
Join Date: Aug 2011
Posts: 160
Received Thanks: 87
Nice job ^^
--N0N€-- is offline  
Old 02/10/2013, 18:40   #3
 
elite*gold: 0
Join Date: Nov 2010
Posts: 33
Received Thanks: 2
goode job
Cris9400 is offline  
Old 04/21/2013, 19:28   #4
 
elite*gold: 0
The Black Market: 300/0/0
Join Date: Nov 2012
Posts: 9,182
Received Thanks: 485
Was bringt das?
What does it do?
.WshbR' is offline  
Old 04/21/2013, 19:54   #5
 
glossypvp's Avatar
 
elite*gold: 0
Join Date: Aug 2011
Posts: 659
Received Thanks: 658
It will count how many chars do you have on your server.
glossypvp is offline  
Old 04/21/2013, 21:31   #6
 
elite*gold: 0
The Black Market: 300/0/0
Join Date: Nov 2012
Posts: 9,182
Received Thanks: 485
And how many chars do you have in this code?
.WshbR' is offline  
Reply


Similar Threads Similar Threads
Glossy Orb PSD
12/30/2011 - General Art - 0 Replies
Hallo Leute, ich werde ab jetzt immer mal PSD´s für euch zur Verfügung stellen, damit ihr sie euch angucken könnt. Eventuell nützlich für Lernzwecke - oder einfach benutzen. Heute ist ein Glossy Orb dran: http://img6.imagebanana.com/img/rf33fxq5/GlossyOr bkleineVorschau.jpg Ebenen in der PSD sollten alle gescheit benannt sein, Texturen etc. nur als Schnittmaske gesetzt sein. Die Grafik dürft ihr für alle Sachen benutzen - inkl. kommerzielle Zwecke.
Get a Glossy Userbar!
05/27/2010 - Grand Chase - 25 Replies
Get your own Glossy userbars ^.^ there are free get one +thank xD Lass! http://img94.imageshack.us/img94/8086/lassuserv.p ng Jin! http://img714.imageshack.us/img714/5589/jinuser.p ng Elesis! http://img196.imageshack.us/img196/535/elesisuser bar.png Seighart! http://img269.imageshack.us/img269/2047/seighartu ser.png
Dshop SQL procedure?
07/25/2009 - Dekaron Private Server - 6 Replies
Ok i want to use the Dshop but it asks for a password and then gives an error because i need to make a procedure in the DB. I have some knowledge of SQL but i need a help in hand if anyone could help?



All times are GMT +2. The time now is 16:03.


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.