Jump to content
  • 0
potpottin

Can anyone help me make sql for this

Question

2 answers to this question

Recommended Posts

  • 0
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.

     




 

 

SQL.png

 

 

 

tabela.png

 

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 by Ihurybro

Share this post


Link to post
Share on other sites
  • 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.

     




 

 

SQL.png

 

 

 

tabela.png

 

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

 

Share this post


Link to post
Share on other sites
  • 0
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.


teste.png.183a1ac1a3e7b0abfa2b2d324ceb6253.png

 

SQL file:

GD_PK_TITLE.sql

Edited by Ihurybro

Share this post


Link to post
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.   Restore formatting

  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.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.