Can anyone help me make sql for this

[potpottin 0]

  cause link for sql broken

[Ihurybro 1]

On 4/2/2021 at 11:00 PM, potpottin said:

  causar link para sql quebrado

=====================================

This is the sql GD_PK_TITLE is from GD_PK_TITLE2.
I got the information inside the two script's own txt file. I just created the GD_PK_TITLE and GD_PK_TITLE2 sql table
For both, it seems the same to me.
=========================================

CREATE TABLE GD_PK_TITLE(

     char_id int(11) unsigned NOT NULL,

     var int(11) unsigned NOT NULL)

ENGINE=MyISAM DEFAULT CHARSET=utf8;

=========================================

Please take the test, because I haven't tested it ^ _ ^!
I hope it works.
Whatever and just send a message right here.
I'm sorry, because I don't speak English, I'm Brazilian.

     

 

 

 

 

 

 

I just tested the npc GD_PK_TITLE2.txt
Because GD_PK_TITLE.txt is typo. and in GD_PK_TITLE2.txt
It is with error in the npc, because the emulator hercules, does not use numbers in npc.
Use it that way

prontera,150,180.4    script    Rank    4_GEFFEN_11,{

Edited April 4, 2021 by Ihurybro

[potpottin 0]

3 hours ago, Ihurybro said:

=====================================

This is the sql GD_PK_TITLE is from GD_PK_TITLE2.
I got the information inside the two script's own txt file. I just created the GD_PK_TITLE and GD_PK_TITLE2 sql table
For both, it seems the same to me.
=========================================

CREATE TABLE GD_PK_TITLE(

     char_id int(11) unsigned NOT NULL,

     var int(11) unsigned NOT NULL)

ENGINE=MyISAM DEFAULT CHARSET=utf8;

=========================================

Please take the test, because I haven't tested it ^ _ ^!
I hope it works.
Whatever and just send a message right here.
I'm sorry, because I don't speak English, I'm Brazilian.

     

 

 

 

 

 

 

I just tested the npc GD_PK_TITLE2.txt
Because GD_PK_TITLE.txt is typo. and in GD_PK_TITLE2.txt
It is with error in the npc, because the emulator hercules, does not use numbers in npc.
Use it that way

prontera,150,180.4    script    Rank    4_GEFFEN_11,{

NOT WORKING WHEN I PUT IN PHPADMIN

 

[Ihurybro 1]

8 hours ago, potpottin said:

NÃO FUNCIONA QUANDO COLOCO O PHPADMIN

 

 

Quote

CREATE TABLE IF NOT EXISTS `GD_PK_TITLE` (
  `char_id` int(11) unsigned NOT NULL,
  `var` int(11) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

I added the two forms, one in text that is on top and the other in sql file with the name of the table. downloaded from my own phpmyadmin.
Because the system works perfectly.

remembering that it must be inside your emulator's database.
See how the npc was doing after my test.
I just changed the name Rank to Rank PVP

The only change I made was to change the name, for my taste.

 

SQL file:

GD_PK_TITLE.sql

Edited April 4, 2021 by Ihurybro