you can just follow the guide given, it's pretty much all of it that you required to do in order to setup the server.
P/s : Don't alway expect for spoonfeeding when there are already guide given to you.
you need to grant access for the user 'ragnarok' that connected using 'localhost'.
Example
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON `<schema>`.* TO 'ragnarok'@'localhost';
you didnt attach the script to an online players.
the best way to deal with variable value would be
shut down server run SQL script
( UPDATE `table` SET `value` = 1 WHERE `variable` LIKE '#variable' )
done.
I suggest you change to other file hosting website.
TinyUpload doesn't hold the file for permanent uses.
I believe nobody want to keep it alive by help you download the files every < 100 days to keep it alive.
So it's better you go for other alternative files hosting sites.
on a side note, most of the popular text editor out there are built-in with text searching feature too
Please elaborate the problem you currently facing. Provide us with the following or more details if possible:
- Run-time server console errors/warnings (if any).
- Client side errors/warnings (if any).
- Any edits to scripts or source mods (if any).
Please elaborate the problem you currently facing. Provide us with the following or more details if possible:
- Run-time server console errors/warnings (if any).
- Client side errors/warnings (if any).
- Any edits to scripts or source mods (if any).
it's caused by this.
for ( .@a = 0; .@a < .maxsize; .@a++ )
set .@fetch_name$, .@fetch_name$ + "char_id = "+ @char_id[.@a]+ " OR ";
the word "OR" is appended on the end of the string.
you can fix it by
create a new query that consist another sub query inside the SQL statement.
example
SELECT `a`,`b`,`c` FROM `tables1` WHERE `char_id` IN ( SELECT `char_id` FROM `char_bg` )
or
change the way to populate the string, example:
.@fetch_name$ = "char_id = "+@char_id[0];
for ( .@a = 1; .@a < .maxsize; .@a++ )
set .@fetch_name$, .@fetch_name$ + " OR " + " char_id = "+ @char_id[.@a];
anyway for your case that required to check more than one variables, it's better if you just use the IN Operator.
took a quick glance on the script.
if(@mob_ep > .r1po){
set .rank1_id,getcharid(0);
}else if(@mob_ep > .r2po){
set .rank2_id,getcharid(0);
}else if(@mob_ep > .r3po){
set .rank3_id,getcharid(0);
}
doesn't exist the part where the script will update the 3 variables to store latest top rank kill count ?