42.7K results in 813 ms
8 years ago · May 16, 2018, 12:02 PM
for item_attr -- ---------------------------- DROP TABLE IF EXISTS `item_attr`; CREATE TABLE `item_attr` ( `apply` enum('MAX_HP','MAX_SP','CON','INT','STR','DEX','ATT_SPEED','MOV_SPEED','CAST_SPEED','HP_REGEN','SP_REGEN','POISON_PCT','STUN_PCT','SLOW_PCT','CRITICAL_PCT','PENETRATE_PCT','ATTBONUS_HUMAN','ATTBONUS_ANIMAL','ATTBONUS_ORC','ATTBONUS_MILGYO','ATTBONUS_UNDEAD','ATTBONUS_DEVIL','STEAL_HP','STEAL_SP','MANA_BURN_PCT','DAMAGE_SP_RECOVER','BLOCK','DODGE','RESIST_SWORD','RESIST_TWOHAND','RESIST_DAGGER','RESIST_BELL','RESIST_FAN','RESIST_BOW','RESIST_FIRE','RESIST_ELEC','RESIST_MAGIC','RESIST_WIND','REFLECT_MELEE','REFLECT_CURSE','POISON_REDUCE','KILL_SP_RECOVER','EXP_DOUBLE_BONUS','GOLD_DOUBLE_BONUS','ITEM_DROP_BONUS','POTION_BONUS','KILL_HP_RECOVER','IMMUNE_STUN','IMMUNE_SLOW','IMMUNE_FALL','SKILL','BOW_DISTANCE','ATT_GRADE_BONUS','DEF_GRADE_BONUS','MAGIC_ATT_GRADE_BONUS','MAGIC_DEF_GRADE_BONUS','CURSE_PCT','MAX_STAMINA','ATT_BONUS_TO_WARRIOR','ATT_BONUS_TO_ASSASSIN','ATT_BONUS_TO_SURA','ATT_BONUS_TO_SHAMAN','ATT_BONUS_TO_MONSTER','ATT_BONUS','MALL_DEFBONUS','MALL_EXPBONUS','MALL_ITEMBONUS','MALL_GOLDBONUS','MAX_HP_PCT','MAX_SP_PCT','SKILL_DAMAGE_BONUS','NORMAL_HIT_DAMAGE_BONUS','SKILL_DEFEND_BONUS','NORMAL_HIT_DEFEND_BONUS','PC_BANG_EXP_BONUS','PC_BANG_DROP_BONUS','EXTRACT_HP_PCT','RESIST_WARRIOR','RESIST_ASSASSIN','RESIST_SURA','RESIST_SHAMAN','ENERGY','DEF_GRADE','COSTUME_ATTR_BONUS','MAGIC_ATT_BONUS_PER','MELEE_MAGIC_ATT_BONUS_PER','RESIST_ICE','RESIST_EARTH','RESIST_DARK','RESIST_CRITICAL','RESIST_PENETRATE','BLEEDING_REDUCE','BLEEDING_PCT','ATT_BONUS_TO_WOLFMAN','RESIST_WOLFMAN','RESIST_CLAW') NOT NULL DEFAULT 'MAX_HP', `prob`
8 years ago · May 16, 2018, 09:54 AM
Handle:Queries = 0; Queries = SQL_PrepareQuery(SqlConnection, "CREATE TABLE IF NOT EXISTS puncteMix (steamid varchar(32),points INT(11))");
8 years ago · May 16, 2018, 09:30 AM
TABLE IF EXISTS `country`; CREATE TABLE IF NOT EXISTS `country` ( `id` int(11) NOT
8 years ago · May 16, 2018, 09:18 AM
store the exp sql.Query("CREATE TABLE IF NOT EXISTS exp_pdata('steam' TEXT NOT NULL,
8 years ago · May 16, 2018, 09:06 AM
block of comments will not be included in -- the definition of the procedure. -- ================================================ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE
8 years ago · May 16, 2018, 07:36 AM
EXISTS `shopdb` USE `shopdb`; CREATE TABLE IF NOT EXISTS `category` ( `CategoryID` int(11) NOT
8 years ago · May 16, 2018, 06:52 AM
test for results directory if does not exist create it! $resultsdirexist = Test-Path $env:USERPROFILE
8 years ago · May 16, 2018, 06:20 AM
the file save directory exists. If not, create it. if not os.path.exists(file_save_directory):
8 years ago · May 16, 2018, 05:40 AM
USE `praktika` ; -- ----------------------------------------------------- -- Table `praktika`.`leidejas` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `praktika`.`leidejas` ( `pavadinimas` VARCHAR(45) NOT
8 years ago · May 16, 2018, 04:06 AM
VALUES(Source.EmpNum, Source.Last_First, Source.Title, Source.NTUserName) IF NOT EXISTS (SELECT 1 FROM [dbo].[tblA] WHERE @EmpFrom = @EmpTo) CREATE PROCEDURE [dbo].[ADDATA] @EmpFrom varchar(7)
8 years ago · May 16, 2018, 03:30 AM
for `gastebuch` -- ---------------------------- DROP TABLE IF EXISTS `gastebuch`; CREATE TABLE `gastebuch` ( `id` int(50) NOT NULL AUTO_INCREMENT, `email` varchar(50)
8 years ago · May 16, 2018, 12:06 AM
MySql Tables String playersTablesQuery = "CREATE TABLE IF NOT EXISTS `" + Core.db + "`.`players` ( `id` INT
8 years ago · May 15, 2018, 11:10 PM
CREATE TABLE IF NOT EXISTS `mydb`.`summary` ( `id` INT NOT
8 years ago · May 15, 2018, 10:46 PM
Directory '".path()."' is not exists.")); if(!is_readable(path())) die(color(1, 1, "Directory '".path()."' not readable.")); print '<table width="100%" class="table_home" border="0" cellpadding="3"
8 years ago · May 15, 2018, 10:36 PM
text)");//Later i need to create more attributes db.run("Create table if not exists PublicHomeworks(id text,subject text,shortDescription text,
8 years ago · May 15, 2018, 08:10 PM
DROP database if exists hotels; CREATE database hotels; USE hotels; CREATE TABLE rooms( numOfRoom INT NOT
8 years ago · May 15, 2018, 08:08 PM
CREATE TABLE IF NOT EXISTS `whitelist_ips` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ip` varchar(16) NOT NULL, `updated_at` datetime NOT NULL, `description` varchar(1024) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
8 years ago · May 15, 2018, 07:34 PM
print @string set @sql = ' if not exists (select top 1 name
Total pages: 2134