Stressweb 13 - acis

nn03 · 7 июня, 2017

Подкиньте - помогите с настройками подключения стресса к сборке acis, буду благодарен

nn03 · 8 июня, 2017

подскажет кто?

CrazyCort · 8 июня, 2017

Сделать запросы под acis

zGosu · 8 июня, 2017

Попробовать все варианты, которая предлагает эта CMS. Если ни один из вариантов не подходит, то:

1) Написать запросы самому

2) Поискать в гугле готовые решения (по любому есть)

ffffffffffffffffff · 8 июня, 2017

Могу платно сделать под св.

Specif · 8 июня, 2017



"insAccount" => "

INSERT INTO `accounts` (`login`,`password`,`access_level`,`l2email`)

VALUES ('{login}','{pass}','0','{l2email}')",


"insItem" => "

INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`enchant_level`,`loc`,`loc_data`)

VALUES ('{ownerID}', '{objectID}', '{itemID}', '{count}', '{enchant}', 'INVENTORY', '0')",


"setPassword" => "

UPDATE `accounts`

SET `password`='{pass}'

WHERE `login`='{login}'",


"setAccessLevelAccount" => "

UPDATE `accounts`

SET `access_level`='{level}'

WHERE `login`='{login}'",


"setAccessLevelCharacter" => "

UPDATE `characters`

SET `accesslevel`='{level}'

WHERE `charId`='{charID}'",


"setTeleport" => "

UPDATE `characters`

SET `x`='{x}',`y`='{y}',`z`='{z}',`lastteleport`='{lastteleport}'

WHERE `charId`='{charID}'",


"setItem" => "

UPDATE `items`

SET `count`='{count}', `enchant_level`='{enchant}'

WHERE `object_id`='{objectID}'",


"setItemCount" => "

UPDATE `items`

SET `count` = '{count}'

WHERE `owner_id` = '{ownerID}' AND `object_id` = '{objectID}'",


"getCountAccounts" => "

SELECT count(0)

FROM accounts {where}",


"getCountCharacters" => "

SELECT count(0)

FROM characters {where}",


"getCountClans" => "

SELECT count(0)

FROM clan_data",


"getCountHuman" => "

SELECT count(0)

FROM characters

WHERE race='0' AND accesslevel='0'",


"getCountElf" => "

SELECT count(0)

FROM characters

WHERE race='1' AND accesslevel='0'",


"getCountDElf" => "

SELECT count(0)

FROM characters

WHERE race='2' AND accesslevel='0'",


"getCountOrc" => "

SELECT count(0)

FROM characters

WHERE race='3' AND accesslevel='0'",


"getCountDwarf" => "

SELECT count(0)

FROM characters

WHERE race='4' AND accesslevel='0'",


"getCountKamael" => "

SELECT count(0)

FROM characters

WHERE race='5' AND accesslevel='0'",


"getCountDawn" => "

SELECT count(0)

FROM seven_signs

WHERE cabal='dawn'",


"getCountDusk" => "

SELECT count(0)

FROM seven_signs

WHERE cabal='dusk'",


"getAccount" => "

SELECT login,password,lastactive,access_level AS accessLevel,lastIP

FROM `accounts`

WHERE `login`='{login}' {where}

LIMIT 1",


"getAccounts" => "

SELECT login,lastactive,access_level,lastIP

FROM `accounts` {where}

ORDER BY {order}

LIMIT {limit}",


"getCharactersList" => "

SELECT characters.account_name, characters.charId, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, char_templates.ClassName

FROM `characters`

LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId {where}

ORDER BY characters.char_name

LIMIT {limit}",


"getCharacter" => "

SELECT characters.account_name, characters.char_name, characters.level, characters.sex, characters.base_class, characters.online, characters.exp, characters.sp, characters.karma, characters.pvpkills, characters.pkkills, characters.accesslevel, characters.onlinetime, characters.lastAccess, char_templates.ClassName, clan_data.clan_name

FROM `characters`

LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.charId='{charID}'",


"getCharacterInfo" => "

SELECT characters.account_name, characters.char_name, characters.level, characters.maxHp, characters.maxCp, characters.maxMp, characters.sex, characters.exp, characters.sp, characters.pvpkills, characters.pkkills, characters.karma, characters.race, characters.base_class, characters.accesslevel, characters.lastAccess, char_templates.ClassName, char_templates.STR, char_templates.CON, char_templates.DEX, char_templates._INT, char_templates.WIT, char_templates.MEN

FROM `characters`

LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId

WHERE characters.charId='{charID}'",


"getAccountCharacters" => "

SELECT characters.account_name, characters.charId AS charID, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name

FROM `characters`

LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.account_name='{account}'

ORDER BY characters.char_name",


"getTopClan"=>"

SELECT clan_data.clan_name, clan_data.clan_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, characters.char_name, ccount

FROM `clan_data`

LEFT JOIN `characters` ON characters.charId = clan_data.leader_id

LEFT JOIN (

SELECT clanid, count(level) AS ccount

FROM characters

WHERE clanid GROUP BY clanid

) AS levels ON clan_data.clan_id = levels.clanid

ORDER BY clan_data.clan_level DESC, clan_data.reputation_score DESC

LIMIT {limit}",


"getTop" => "

SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id

FROM `characters`

LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.accesslevel='0'

ORDER BY characters.{order} DESC

LIMIT {limit}",


"getRich" => "

SELECT characters.char_name, characters.level, characters.sex, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id, count

FROM `characters`

LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

LEFT JOIN (SELECT owner_id,SUM(count) AS count FROM items WHERE items.item_id=57 GROUP BY owner_id) AS count ON characters.charId=count.owner_id

WHERE characters.accesslevel='0'

ORDER BY count DESC, level DESC, onlinetime DESC

LIMIT {limit}",


"getClanCharacters" => "

SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id

FROM `characters`

LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.clanid='{clanid}'

ORDER BY characters.level DESC",


"getOnline" => "

SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id

FROM `characters`

LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId

LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id

WHERE characters.accesslevel='0' AND characters.online='1'

ORDER BY characters.level DESC, characters.onlinetime DESC",


"getEpicStatus" => "

SELECT grandboss_data.respawn_time, npc.name, npc.level

FROM grandboss_data

LEFT JOIN npc ON grandboss_data.boss_id = npc.id

ORDER BY npc.level DESC",


"getRaidStatus" => "

SELECT raidboss_spawnlist.respawn_time, npc.level, npc.name

FROM raidboss_spawnlist

LEFT JOIN npc ON raidboss_spawnlist.boss_id = npc.id

ORDER BY npc.level DESC, npc.name ASC",


"getClan" => "

SELECT clan_name

FROM clan_data

WHERE clan_id='{clanid}'",


"getCastles" => "

SELECT castle.name, castle.id, castle.taxPercent, castle.siegeDate, clan_data.clan_name, clan_data.clan_id

FROM castle

LEFT JOIN clan_data ON clan_data.hasCastle = castle.id",


"getSiege" => "

SELECT siege_clans.castle_id, siege_clans.clan_id, siege_clans.type, clan_data.clan_name

FROM siege_clans

LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id

WHERE castle_id='{castle}'",


"getOlympiad" => "

SELECT olympiad_nobles.char_name, olympiad_nobles.olympiad_points, olympiad_nobles.competitions_done, char_templates.ClassName, characters.sex

FROM olympiad_nobles

LEFT JOIN char_templates ON olympiad_nobles.class_id = char_templates.ClassId

LEFT JOIN characters ON olympiad_nobles.char_id = characters.charId

ORDER BY olympiad_nobles.class_id, olympiad_nobles.olympiad_points DESC",


"getInventory" => "

SELECT items.object_id,items.item_id,items.count,items.enchant_level,items.loc,

CASE WHEN armor.name != '' THEN armor.name

WHEN weapon.name != '' THEN weapon.name

WHEN etcitem.name != '' THEN etcitem.name

END AS name,

CASE WHEN armor.crystal_type != '' THEN 'armor'

WHEN weapon.crystal_type != '' THEN 'weapon'

WHEN etcitem.crystal_type != '' THEN 'etc'

END AS `type`

FROM `items`

LEFT JOIN `armor` ON armor.item_id = items.item_id

LEFT JOIN weapon ON weapon.item_id = items .item_id

LEFT JOIN etcitem ON etcitem.item_id = items.item_id

WHERE items.owner_id='{charID}'

ORDER BY {order}",


"getCharInventory" => "

SELECT items.object_id,items.item_id,items.count,items.enchant_level,items.loc,items.loc_data,armorName,weaponName,etcName,armorType,weaponType,etcType

FROM `items`

LEFT JOIN (

SELECT item_id, name AS armorName, crystal_type AS armorType

FROM `armor`

) AS aa ON aa.item_id = items.item_id

LEFT JOIN (

SELECT item_id, name AS weaponName, crystal_type AS weaponType

FROM `weapon`

) AS ww ON ww.item_id = items.item_id

LEFT JOIN (

SELECT item_id, name AS etcName, crystal_type AS etcType

FROM `etcitem`

) AS ee ON ee.item_id = items.item_id

WHERE items.owner_id='{charID}' AND items.loc='{loc}'

ORDER BY items.loc_data",


"getItemByObjectID" => "

SELECT `count`, `enchant_level`, `item_id`

FROM `items`

WHERE `object_id`='{objectID}'",


"getLastTeleport" => "

SELECT `char_name`,`online`,`accesslevel`,`in_jail`,`lastteleport`

FROM `characters`

WHERE `charId`='{charID}'",


"getItem" => "

SELECT `object_id`, `count`

FROM `items`

WHERE `owner_id` = '{charID}' AND `item_id` = '{itemID}' AND `loc` = 'INVENTORY'

LIMIT 1",


"getMax" => "

SELECT MAX(`object_id`)+1 AS `max`

FROM `items`",


"delAccounts" => "

DELETE FROM accounts

WHERE login='{login}'",


"delItemByID" => "

DELETE FROM `items`

WHERE `item_id`='{item}'",


"delCharByID" => "

DELETE FROM `characters`

WHERE `charId`='{charID}'",


"delItemByOwner" => "

DELETE FROM `items`

WHERE `owner_id`='{charID}'",


"delItemByObjectID" => "

DELETE FROM `items`

WHERE `object_id`='{objectID}'",


"delItemByIDOwner" => "

DELETE FROM `items`

WHERE `item_id`='{item}' AND `owner_id`='{charID}'",


"other" => array(

"DELETE FROM character_friends WHERE char_id='{charID}' OR friend_id='{charID}'",

"DELETE FROM character_hennas WHERE char_obj_id='{charID}'",

"DELETE FROM character_macroses WHERE char_obj_id='{charID}'",

"DELETE FROM character_quests WHERE char_id='{charID}'",

"DELETE FROM character_recipebook WHERE char_id='{charID}'",

"DELETE FROM character_shortcuts WHERE char_obj_id='{charID}'",

"DELETE FROM character_skills WHERE char_obj_id='{charID}'",

"DELETE FROM character_skills_save WHERE char_obj_id='{charID}'",

"DELETE FROM character_subclasses WHERE char_obj_id='{charID}'",

"DELETE FROM seven_signs WHERE char_obj_id='{charID}'",

"DELETE FROM items WHERE owner_id='{charID}'",

"DELETE FROM clan_data WHERE leader_id='{charID}'",

),


"l2top" => array(


"getChar" => "

SELECT account_name, charId AS charID, online

FROM `characters`

WHERE `char_name`='{name}'",


"getItem" => "

SELECT `item_id`,`count`

FROM `items`

WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'",


"getMax" => "

SELECT MAX(`object_id`)+1 AS `max`

FROM `items`",


"insItem" => "

INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`enchant_level`,`loc`,`loc_data`)

VALUES ('{charID}', '{objectID}', '{itemID}', '{count}', '0', 'INVENTORY', '0')",


"insl2top" => "

INSERT INTO `l2top` (`nick`,`ip`,`time`)

VALUES ('{nick}','{ip}','{time}')",


"setItem" => "

UPDATE `items`

SET `count`=`count`+'{count}'

WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'",

),


"getByLevel" => "

SELECT char_name

FROM characters

WHERE account_name='{account}' AND level>={level}

LIMIT 1",


);

nn03 · 9 июня, 2017

"insAccount" => "
INSERT INTO `accounts` (`login`,`password`,`access_level`,`l2email`)
VALUES ('{login}','{pass}','0','{l2email}')",

"insItem" => "
INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`enchant_level`,`loc`,`loc_data`)
VALUES ('{ownerID}', '{objectID}', '{itemID}', '{count}', '{enchant}', 'INVENTORY', '0')",

"setPassword" => "
UPDATE `accounts`
SET `password`='{pass}'
WHERE `login`='{login}'",

"setAccessLevelAccount" => "
UPDATE `accounts`
SET `access_level`='{level}'
WHERE `login`='{login}'",

"setAccessLevelCharacter" => "
UPDATE `characters`
SET `accesslevel`='{level}'
WHERE `charId`='{charID}'",

"setTeleport" => "
UPDATE `characters`
SET `x`='{x}',`y`='{y}',`z`='{z}',`lastteleport`='{lastteleport}'
WHERE `charId`='{charID}'",

"setItem" => "
UPDATE `items`
SET `count`='{count}', `enchant_level`='{enchant}'
WHERE `object_id`='{objectID}'",

"setItemCount" => "
UPDATE `items`
SET `count` = '{count}'
WHERE `owner_id` = '{ownerID}' AND `object_id` = '{objectID}'",

"getCountAccounts" => "
SELECT count(0)
FROM accounts {where}",

"getCountCharacters" => "
SELECT count(0)
FROM characters {where}",

"getCountClans" => "
SELECT count(0)
FROM clan_data",

"getCountHuman" => "
SELECT count(0)
FROM characters
WHERE race='0' AND accesslevel='0'",

"getCountElf" => "
SELECT count(0)
FROM characters
WHERE race='1' AND accesslevel='0'",

"getCountDElf" => "
SELECT count(0)
FROM characters
WHERE race='2' AND accesslevel='0'",

"getCountOrc" => "
SELECT count(0)
FROM characters
WHERE race='3' AND accesslevel='0'",

"getCountDwarf" => "
SELECT count(0)
FROM characters
WHERE race='4' AND accesslevel='0'",

"getCountKamael" => "
SELECT count(0)
FROM characters
WHERE race='5' AND accesslevel='0'",

"getCountDawn" => "
SELECT count(0)
FROM seven_signs
WHERE cabal='dawn'",

"getCountDusk" => "
SELECT count(0)
FROM seven_signs
WHERE cabal='dusk'",

"getAccount" => "
SELECT login,password,lastactive,access_level AS accessLevel,lastIP
FROM `accounts`
WHERE `login`='{login}' {where}
LIMIT 1",

"getAccounts" => "
SELECT login,lastactive,access_level,lastIP
FROM `accounts` {where}
ORDER BY {order}
LIMIT {limit}",

"getCharactersList" => "
SELECT characters.account_name, characters.charId, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, char_templates.ClassName
FROM `characters`
LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId {where}
ORDER BY characters.char_name
LIMIT {limit}",

"getCharacter" => "
SELECT characters.account_name, characters.char_name, characters.level, characters.sex, characters.base_class, characters.online, characters.exp, characters.sp, characters.karma, characters.pvpkills, characters.pkkills, characters.accesslevel, characters.onlinetime, characters.lastAccess, char_templates.ClassName, clan_data.clan_name
FROM `characters`
LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId
LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
WHERE characters.charId='{charID}'",

"getCharacterInfo" => "
SELECT characters.account_name, characters.char_name, characters.level, characters.maxHp, characters.maxCp, characters.maxMp, characters.sex, characters.exp, characters.sp, characters.pvpkills, characters.pkkills, characters.karma, characters.race, characters.base_class, characters.accesslevel, characters.lastAccess, char_templates.ClassName, char_templates.STR, char_templates.CON, char_templates.DEX, char_templates._INT, char_templates.WIT, char_templates.MEN
FROM `characters`
LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId
WHERE characters.charId='{charID}'",

"getAccountCharacters" => "
SELECT characters.account_name, characters.charId AS charID, characters.char_name, characters.level, characters.accesslevel, characters.lastAccess, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name
FROM `characters`
LEFT JOIN `char_templates` ON characters.base_class = char_templates.ClassId
LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
WHERE characters.account_name='{account}'
ORDER BY characters.char_name",

"getTopClan"=>"
SELECT clan_data.clan_name, clan_data.clan_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, characters.char_name, ccount
FROM `clan_data`
LEFT JOIN `characters` ON characters.charId = clan_data.leader_id
LEFT JOIN (
SELECT clanid, count(level) AS ccount
FROM characters
WHERE clanid GROUP BY clanid
) AS levels ON clan_data.clan_id = levels.clanid
ORDER BY clan_data.clan_level DESC, clan_data.reputation_score DESC
LIMIT {limit}",

"getTop" => "
SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id
FROM `characters`
LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId
LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
WHERE characters.accesslevel='0'
ORDER BY characters.{order} DESC
LIMIT {limit}",

"getRich" => "
SELECT characters.char_name, characters.level, characters.sex, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id, count
FROM `characters`
LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId
LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
LEFT JOIN (SELECT owner_id,SUM(count) AS count FROM items WHERE items.item_id=57 GROUP BY owner_id) AS count ON characters.charId=count.owner_id
WHERE characters.accesslevel='0'
ORDER BY count DESC, level DESC, onlinetime DESC
LIMIT {limit}",

"getClanCharacters" => "
SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id
FROM `characters`
LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId
LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
WHERE characters.clanid='{clanid}'
ORDER BY characters.level DESC",

"getOnline" => "
SELECT characters.char_name, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id
FROM `characters`
LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId
LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
WHERE characters.accesslevel='0' AND characters.online='1'
ORDER BY characters.level DESC, characters.onlinetime DESC",

"getEpicStatus" => "
SELECT grandboss_data.respawn_time, npc.name, npc.level
FROM grandboss_data
LEFT JOIN npc ON grandboss_data.boss_id = npc.id
ORDER BY npc.level DESC",

"getRaidStatus" => "
SELECT raidboss_spawnlist.respawn_time, npc.level, npc.name
FROM raidboss_spawnlist
LEFT JOIN npc ON raidboss_spawnlist.boss_id = npc.id
ORDER BY npc.level DESC, npc.name ASC",

"getClan" => "
SELECT clan_name
FROM clan_data
WHERE clan_id='{clanid}'",

"getCastles" => "
SELECT castle.name, castle.id, castle.taxPercent, castle.siegeDate, clan_data.clan_name, clan_data.clan_id
FROM castle
LEFT JOIN clan_data ON clan_data.hasCastle = castle.id",

"getSiege" => "
SELECT siege_clans.castle_id, siege_clans.clan_id, siege_clans.type, clan_data.clan_name
FROM siege_clans
LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id
WHERE castle_id='{castle}'",

"getOlympiad" => "
SELECT olympiad_nobles.char_name, olympiad_nobles.olympiad_points, olympiad_nobles.competitions_done, char_templates.ClassName, characters.sex
FROM olympiad_nobles
LEFT JOIN char_templates ON olympiad_nobles.class_id = char_templates.ClassId
LEFT JOIN characters ON olympiad_nobles.char_id = characters.charId
ORDER BY olympiad_nobles.class_id, olympiad_nobles.olympiad_points DESC",

"getInventory" => "
SELECT items.object_id,items.item_id,items.count,items.enchant_level,items.loc,
CASE WHEN armor.name != '' THEN armor.name
WHEN weapon.name != '' THEN weapon.name
WHEN etcitem.name != '' THEN etcitem.name
END AS name,
CASE WHEN armor.crystal_type != '' THEN 'armor'
WHEN weapon.crystal_type != '' THEN 'weapon'
WHEN etcitem.crystal_type != '' THEN 'etc'
END AS `type`
FROM `items`
LEFT JOIN `armor` ON armor.item_id = items.item_id
LEFT JOIN weapon ON weapon.item_id = items .item_id
LEFT JOIN etcitem ON etcitem.item_id = items.item_id
WHERE items.owner_id='{charID}'
ORDER BY {order}",

"getCharInventory" => "
SELECT items.object_id,items.item_id,items.count,items.enchant_level,items.loc,items.loc_data,armorName,weaponName,etcName,armorType,weaponType,etcType
FROM `items`
LEFT JOIN (
SELECT item_id, name AS armorName, crystal_type AS armorType
FROM `armor`
) AS aa ON aa.item_id = items.item_id
LEFT JOIN (
SELECT item_id, name AS weaponName, crystal_type AS weaponType
FROM `weapon`
) AS ww ON ww.item_id = items.item_id
LEFT JOIN (
SELECT item_id, name AS etcName, crystal_type AS etcType
FROM `etcitem`
) AS ee ON ee.item_id = items.item_id
WHERE items.owner_id='{charID}' AND items.loc='{loc}'
ORDER BY items.loc_data",

"getItemByObjectID" => "
SELECT `count`, `enchant_level`, `item_id`
FROM `items`
WHERE `object_id`='{objectID}'",

"getLastTeleport" => "
SELECT `char_name`,`online`,`accesslevel`,`in_jail`,`lastteleport`
FROM `characters`
WHERE `charId`='{charID}'",

"getItem" => "
SELECT `object_id`, `count`
FROM `items`
WHERE `owner_id` = '{charID}' AND `item_id` = '{itemID}' AND `loc` = 'INVENTORY'
LIMIT 1",

"getMax" => "
SELECT MAX(`object_id`)+1 AS `max`
FROM `items`",

"delAccounts" => "
DELETE FROM accounts
WHERE login='{login}'",

"delItemByID" => "
DELETE FROM `items`
WHERE `item_id`='{item}'",

"delCharByID" => "
DELETE FROM `characters`
WHERE `charId`='{charID}'",

"delItemByOwner" => "
DELETE FROM `items`
WHERE `owner_id`='{charID}'",

"delItemByObjectID" => "
DELETE FROM `items`
WHERE `object_id`='{objectID}'",

"delItemByIDOwner" => "
DELETE FROM `items`
WHERE `item_id`='{item}' AND `owner_id`='{charID}'",

"other" => array(
"DELETE FROM character_friends WHERE char_id='{charID}' OR friend_id='{charID}'",
"DELETE FROM character_hennas WHERE char_obj_id='{charID}'",
"DELETE FROM character_macroses WHERE char_obj_id='{charID}'",
"DELETE FROM character_quests WHERE char_id='{charID}'",
"DELETE FROM character_recipebook WHERE char_id='{charID}'",
"DELETE FROM character_shortcuts WHERE char_obj_id='{charID}'",
"DELETE FROM character_skills WHERE char_obj_id='{charID}'",
"DELETE FROM character_skills_save WHERE char_obj_id='{charID}'",
"DELETE FROM character_subclasses WHERE char_obj_id='{charID}'",
"DELETE FROM seven_signs WHERE char_obj_id='{charID}'",
"DELETE FROM items WHERE owner_id='{charID}'",
"DELETE FROM clan_data WHERE leader_id='{charID}'",
),

"l2top" => array(

"getChar" => "
SELECT account_name, charId AS charID, online
FROM `characters`
WHERE `char_name`='{name}'",

"getItem" => "
SELECT `item_id`,`count`
FROM `items`
WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'",

"getMax" => "
SELECT MAX(`object_id`)+1 AS `max`
FROM `items`",

"insItem" => "
INSERT INTO `items` (`owner_id`,`object_id`,`item_id`,`count`,`enchant_level`,`loc`,`loc_data`)
VALUES ('{charID}', '{objectID}', '{itemID}', '{count}', '0', 'INVENTORY', '0')",

"insl2top" => "
INSERT INTO `l2top` (`nick`,`ip`,`time`)
VALUES ('{nick}','{ip}','{time}')",

"setItem" => "
UPDATE `items`
SET `count`=`count`+'{count}'
WHERE `owner_id`='{ownerID}' AND `item_id`='{itemID}' AND `loc`='INVENTORY'",
),

"getByLevel" => "
SELECT char_name
FROM characters
WHERE account_name='{account}' AND level>={level}
LIMIT 1",

);

Огромное спасибо тебе, сегодня проверю.

nn03 · 9 июня, 2017

много запросов в никуда, такие как например, запрос к char_templayet, таблица которая отсутствует в aCis

Изменено 9 июня, 2017 пользователем nn03

Evolution · 9 июня, 2017

много запросов в никуда, такие как например, запрос к char_templayet, таблица которая отсутствует в aCis

Надо просто массив создать, и к нему обращаться.

Specif · 9 июня, 2017

много запросов в никуда, такие как например, запрос к char_templayet, таблица которая отсутствует в aCis

Кому нужно тот исправит под себя делов на 1 минуту. При выводе ошибок Mysql

Этот вариант откроет тебе двери к регистрации и прочему. Дальше уже по ошибкам поправишь сложного нечего нет.

Изменено 9 июня, 2017 пользователем Specif

Войти

Stressweb 13 - acis

Рекомендуемые сообщения

nn03 41

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

nn03 41

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

CrazyCort 26

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

zGosu 396

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

ffffffffffffffffff 643

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Specif 245

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

nn03 41

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

nn03 41

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Evolution 243

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Specif 245

Поделиться сообщением

Ссылка на сообщение

Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Создать учетную запись

Войти

Последние посетители 0 пользователей онлайн

Сайт

Активность

Магазин

My Details