Jump to content
  • 0

How to put DOTA PVP SQL TABLE?


fireicesurfer

Question


  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.02
  • Content Count:  101
  • Reputation:   3
  • Joined:  04/15/20
  • Last Seen:  

Hello guys.  Im confused where to put this code.

I dont have ANY IDEA where and what is SQL Table. Help me please

//SQL Table for Ghost's PvP System
CREATE TABLE IF NOT EXISTS `pvp_rank` (
 `char_id` int(11) NOT NULL,
 `account_id` int(11) NOT NULL,
 `char` varchar(30) NOT NULL,
 `kill` int(11) NOT NULL,
 `death` int(11) NOT NULL,
 `kdr` varchar(30) NOT NULL,
 `killingstreak` int(11) NOT NULL,
 `multikill` int(11) NOT NULL,
 `killingspree` int(11) NOT NULL,
 `dominating` int(11) NOT NULL,
 `megakill` int(11) NOT NULL,
 `unstoppable` int(11) NOT NULL,
 `wickedsick` int(11) NOT NULL,
 `monsterkill` int(11) NOT NULL,
 `godlike` int(11) NOT NULL,
 `beyondgodlike` int(11) NOT NULL,
 `doublekill` int(11) NOT NULL,
 `triplekill` int(11) NOT NULL,
 `ultrakill` int(11) NOT NULL,
 `rampage` int(11) NOT NULL,
 `ownage` int(11) NOT NULL,
 `nemesiskill` int(11) NOT NULL,
 `feedcount` int(11) NOT NULL,
 PRIMARY KEY (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1511
  • Reputation:   227
  • Joined:  08/03/12
  • Last Seen:  

if you have phpmyadmin.. it has query tab so paste it in 'ragnarok' database and execute.

Edited by Chaos92
change terms
  • MVP 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.01
  • Content Count:  398
  • Reputation:   246
  • Joined:  07/04/19
  • Last Seen:  

all you have to do is paste it in SQL queries.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.02
  • Content Count:  101
  • Reputation:   3
  • Joined:  04/15/20
  • Last Seen:  

1 minute ago, BeWan said:

all you have to do is paste it in SQL queries.

i dont even know what is SQL queries.  huhu

Can you have a screen shot please. where can I find that SQL queries? is it PHPMYADMIN?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  26
  • Reputation:   21
  • Joined:  07/05/18
  • Last Seen:  

actually u can manage your sql by phpmyadmin, so, technically yes, u can do that by phpmyadmin

  • MVP 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.02
  • Content Count:  101
  • Reputation:   3
  • Joined:  04/15/20
  • Last Seen:  

On 4/21/2020 at 6:48 AM, OptimusM said:

actually u can manage your sql by phpmyadmin, so, technically yes, u can do that by phpmyadmin

whats the easiest way please. How to paste it in sql queries? where can i find that?

On 4/21/2020 at 8:20 AM, Chaos92 said:

if you have phpmyadmin.. it has query tab so paste it in 'ragnarok' database and execute.

 Am I doing it right? and where do I put the wav files? on what path? 

Hello master scripters. I would like your professional advice on how to put SQL TABLE for DOTA PVP

Am I doing the right thing?

image.png.48eed61c41a06a5ca1f106c1acab05aa.png

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  136
  • Reputation:   48
  • Joined:  06/18/12
  • Last Seen:  

Execute this one.

  

Spoiler

        create table pvpladder (
                char_id int(11) not null default '0' primary key,
                name varchar(30) not null default '',
                streaks smallint(6) unsigned not null default '0',
                kills smallint(6) unsigned not null default '0',
                deaths smallint(6) unsigned not null default '0',
                streaktime datetime
        ) engine = myisam;
       
        create table ownladder (
                guild_id int(11) not null default '0' primary key,
                name varchar(24) not null default '',
                currentown smallint(6) unsigned not null default '0',
                highestown smallint(6) unsigned not null default '0',
                owntime datetime
        ) engine = myisam;

 

  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.02
  • Content Count:  101
  • Reputation:   3
  • Joined:  04/15/20
  • Last Seen:  

On 4/21/2020 at 1:40 PM, Gerzzie said:

Execute this one.

  Hide contents

        create table pvpladder (
                char_id int(11) not null default '0' primary key,
                name varchar(30) not null default '',
                streaks smallint(6) unsigned not null default '0',
                kills smallint(6) unsigned not null default '0',
                deaths smallint(6) unsigned not null default '0',
                streaktime datetime
        ) engine = myisam;
       
        create table ownladder (
                guild_id int(11) not null default '0' primary key,
                name varchar(24) not null default '',
                currentown smallint(6) unsigned not null default '0',
                highestown smallint(6) unsigned not null default '0',
                owntime datetime
        ) engine = myisam;

 

where do I find the execute button?

is this the right directory? rathena pre renewal?

image.thumb.png.46b116fa0f0c6c40d0c52847e9de858d.png

 

It worked! thanks bro. bless you.. now where do I put the wave files? what folder or path? 

image.png.b53637d9e12d8d16f17e212b5c49ffd6.png

 

Hi guys. I need expert advice. 

Im new to this DOTA PVP system. I was able to make it work thanks for this forum. 

The only thing that confuses me is how pvp ladder works.

Where do I see the pvp rankings?

 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  49
  • Topics Per Day:  0.01
  • Content Count:  1511
  • Reputation:   227
  • Joined:  08/03/12
  • Last Seen:  

10 hours ago, fireicesurfer said:

 Am I doing it right? and where do I put the wav files? on what path? 

image.png

All I see = commented query.. just run the first post SQL query

  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.02
  • Content Count:  101
  • Reputation:   3
  • Joined:  04/15/20
  • Last Seen:  

1 hour ago, Chaos92 said:

All I see = commented query.. just run the first post SQL query

SOLVED thanks!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...