• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Guide Complete Master Point Skills God

Status
Not open for further replies.
Junior Spellweaver
Joined
Sep 14, 2010
Messages
185
Reaction score
83
Hello again through here greetings to all my friends, and this great community Ragezone compliant already 11 years since he opened.

take me the trouble to make them a complete and well explained guide of master point.
Since many people do not know or do not have or the more remote idea of how to operate the master points.

This guide is for people who already have your sql server completely installed and their 3 created databases,Tantra,billcrux_phil,Userlogin.

well in this case only used to modify table Tantra.

Well pay attention.

Step 1.

Open Home Alls Program Microsoft SQL Server 2005 SQL SERVER MANGAMENT STUDIO XPRESS

View the image




Step 2.

After you open the sql Mangament, placed their personal data from the sql and push Button Connect.

View the image.




Step 3.

Once connected already looking for our Tantra database.

View the image.




Step 4.

We go to the Databases option then the Tantra option and then the Tables option.

View the image.




Step 5.

well now give right click on the table dbo.GameInfo00 and then click on the modify option

View the image.




Step 6.

Once clicked the modify option,It will open a table with all these columns and we will modify only 5 of them.

View the image.




Step 7.

Well as I said in step 6 we have to modify only 5 columns, that would be the column UserID, CharacterName, Name1, Name2, Name3,They only have to change varchar (40) by varchar (20) in the mentioned 5 columns.

would be so.

View the image.




Step 8.

well after Modify the column UserID,CharacterName, Name1, Name2, Name3 save changes Push Button Yes.

View the image.




Step9.

Well now we go to the Databases-Tantra-Tables,And Search Table TantraBackup00
then select the TantraBackup00 table and give you right click and give the option to modify.

View The image.




Step 10.

Well once made right click on TantraBackup00 will open another table with multiple columns.

Here we will only modify 5 columns.

View the image.




Step 11.

Well as I said in step 10 should modify 5 columns only.

which are UserID, CharacterName, Name1, Name2, Name3

Change Varchar(40) for Varchar(20) the 5 mentioned columns.



Change to
UserID Varchar(40) UserID Varchar(20)
CharacterName Varchar (40) CharacterName Varchar (20)
Name1 Varchar (40) Name1 Varchar (20)
Name2 Varchar (40) Name2 Varchar (20)
Name3 Varchar (40) Name3 Varchar (20)

View The Image

before


After


After you modify the 5 above-mentioned columns saves the changes Push Button Yes

View The Image




Step 12 and last.

Copy This Scrip and Paste in DataBase Tantra,This query is to update our Ranking System



delete from GameInfo00
insert into GameInfo00(UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney) select UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney from TantraBackup00

delete from GameInfo01
insert into GameInfo01(UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney) select UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney from TantraBackup01

delete from GameInfo02
insert into GameInfo02(UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney) select UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney from TantraBackup02

delete from GameInfo03
insert into GameInfo03(UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney) select UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney from TantraBackup03

delete from GameInfo04
insert into GameInfo04(UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney) select UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney from TantraBackup04

delete from GameInfo05
insert into GameInfo05(UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney) select UserID,CharacterName,CharacterLevel,BrahmanPoint,Tribe,Trimurity,GuildName,GuildID,GuildRank,curtime,Name1,Name2,Name3,Level1,Level2,Level3,TotalMoney from TantraBackup05


Check This Images.


Paste Query

Execute Query
Analize Query
Save Change Press Button NO.


Each time we want to update our Ranking System paste this query on the database of Tantra.

With this we have our Master Point running at 100 %

Credits Heterojeneo.

Greetings to all.
 
Junior Spellweaver
Joined
Jan 3, 2012
Messages
129
Reaction score
18
i already tried your guide but still....my god points still stuck to waisaya 1.....
 
Newbie Spellweaver
Joined
Jun 23, 2012
Messages
36
Reaction score
1
subst G: C:\Server\DBSRV\guild
subst K: C:\Server\SQLDAEMON\Rank
subst R: C:\Server\DBSRV\current_user
subst Q: C:\Server\Share

is this correct sir?
 
Junior Spellweaver
Joined
Jan 3, 2012
Messages
129
Reaction score
18
are ure server in c drive..yes it is correct...
 
Newbie Spellweaver
Joined
Jan 19, 2011
Messages
26
Reaction score
0
Muchas gracias es lo que necesitaba toda tus guias son excellente amigo heterojeneo
 
Status
Not open for further replies.