Jump to content
  • Sign Up

FearlesS

Members
 View Profile  See their activity

  • Content Count

    38

  • Joined

  • Last visited

Posts posted by FearlesS

  1. Posted

    Using AnniRuru Weekly_MVP_Reward_1.0r script,

    its working fine on mysql server (windows) but not working on CentOs mysql server.

     

    below  error showing while creating tables

    "rank" is not valid at this position, expecting an identifier.

      

    /*
create table mvp_rank (
char_id int(11) primary key,
name varchar(23) default '',
mvp_kills int(11) default 0,
key (mvp_kills)
) engine = innodb;

create table mvp_rank_archive (
weekindex int(11),
rank tinyint(4) unsigned,
char_id int(11) unsigned default 0,
name varchar(23) default '',
points int(11) unsigned not null,
key (weekindex)
) engine = myisam;

create table mvp_rank_reward (
char_id int(11),
weekindex int(11),
rank tinyint(4) unsigned,
key (char_id)
) engine = innodb;
*/

     

  21. Posted

    On 4/17/2020 at 5:53 PM, Patskie said:

    /* Run below script to create table * CREATE TABLE IF NOT EXISTS `freebies_ip` AS * SELECT `LAST_IP` `IP` FROM `LOGIN` LIMIT 0; */ prontera,150,150,6 script Test 4W_SAILOR,{ if (!#FREEBIES && !query_sql("SELECT `IP` FROM `FREEBIES_IP` WHERE `IP` = '" + getcharip() + "'", .@ip$)) { .@i = 0; while (.@i < .size) { getitem .freebies[.@i], .freebies[.@i+1]; .@i += 2; } #FREEBIES = 1; query_sql("INSERT INTO `FREEBIES_IP` VALUES ('" + getcharip() + "')"); end; } mes "Already claimed freebies"; close; OnInit: // <item id>,<amount> setarray .freebies[0], Speed_Up_Potion_Box10, 5, Yggdrasilberry_Box_, 10; .size = getarraysize(.freebies); end; }

    
/* Run below script to create table
 * CREATE TABLE IF NOT EXISTS `freebies_ip` AS
 * SELECT `LAST_IP` `IP` FROM `LOGIN` LIMIT 0;
 */

prontera,150,150,6	script	Test	4W_SAILOR,{
	if (!#FREEBIES && !query_sql("SELECT `IP` FROM `FREEBIES_IP` WHERE `IP` = '" + getcharip() + "'", .@ip$)) {
		.@i = 0;
		while (.@i < .size) {
			getitem .freebies[.@i], .freebies[.@i+1];
			.@i += 2;
		}
		#FREEBIES = 1;
		query_sql("INSERT INTO `FREEBIES_IP` VALUES ('" + getcharip() + "')");
		end;
	}
	mes "Already claimed freebies";
	close;
	
	OnInit:
		// <item id>,<amount>
		setarray .freebies[0],
			Speed_Up_Potion_Box10, 5,
			Yggdrasilberry_Box_, 10;
		.size = getarraysize(.freebies);
		end;
}

    Run the sql script first on the comment header

    Thanks, its working.

×
×
  • Create New...

Important Information

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

  I accept