Guide Complete Master Point Skills God

[heterojeneo]

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.

 

[gundulapek]

thanks for share

 

[Shichibukai]

@heterojeneo can you post other offset guides?

 

[shivangod]

i already tried your guide but still....my god points still stuck to waisaya 1.....

 

[tagbalay]

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?

 

[shivangod]

are ure server in c drive..yes it is correct...

 

[KyleMarvin]

is this correct sir?

yes it is ^_^

@heterojeneo

Thanks again... muchas gracias por todo!

 

[Shichibukai]

@heterojeneo can you update your offset tutorials?

gracias! ...

 

[heterojeneo]

yes it is ^_^

@heterojeneo

Thanks again... muchas gracias por todo!

of nothing Sorry for my bad English.

@heterojeneo can you update your offset tutorials?

gracias! ...

will be in the next release

 

[RaphuTantra]

Muchas gracias es lo que necesitaba toda tus guias son excellente amigo heterojeneo

 

[10dakongyi]

of nothing Sorry for my bad English.
will be in the next release

hi,sir this is my problem,char name and others information are not right

my char use english name

 

[jbeitz107]

you need to change the rows in your php code to show the correct rows of your sql databse. count them then fix in the php code

 

[10dakongyi]

you need to change the rows in your php code to show the correct rows of your sql databse. count them then fix in the php code

the same phpweb in k3 server is ok

k5.......is Garbled