AAC Gesior Acc - Part of Guilds issues with querys

[Tampek]

Hello i have some problem with querys from my website, in guild section.

I explain it better:
- You can create good your Guild, but when all is done appear it: You dont have rank, and player/s dont appear in the list of your guild including you the Leader.

Im using Gesior acc tfs 1.0 for 1.2 and i think need changed in the php or something.

Here is a some errors i see on the website "Error-mode (True)"

SELECT `id`, `name`, `ownerid`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '48'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char`, `cast`, `castviewers`, `castdescription` FROM `players` WHERE `id` = '152'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `players`.`id`, `players`.`name`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`skill_fist`, `players`.`skill_fist_tries`, `players`.`skill_club`, `players`.`skill_club_tries`, `players`.`skill_sword`, `players`.`skill_sword_tries`, `players`.`skill_axe`, `players`.`skill_axe_tries`, `players`.`skill_dist`, `players`.`skill_dist_tries`, `players`.`skill_shielding`, `players`.`skill_shielding_tries`, `players`.`skill_fishing`, `players`.`skill_fishing_tries`, `players`.`deleted`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char`, `players`.`cast`, `players`.`castviewers`, `players`.`castdescription` FROM `players` WHERE `account_id` = '1' ORDER BY `name` ASC
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '721'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '687'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '689'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '776'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '688'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '686'
SQLSTATE:    00000
Driver code: 
Error message: 
Query:    SELECT `rank_id`, `nick` FROM `guild_membership` WHERE `player_id` = '152'
SQLSTATE:    00000
Driver code: 
Error message: 

SELECT `guild_ranks`.`id`, `guild_ranks`.`guild_id`, `guild_ranks`.`name`, `guild_ranks`.`level` FROM `guild_ranks` WHERE `guild_id` = '48' ORDER BY `level` DESC
SQLSTATE:    00000
Driver code: 
Error message: 


Query:    SELECT `players`.`id`, `players`.`name`, `players`.`group_id`, `players`.`account_id`, `players`.`level`, `players`.`vocation`, `players`.`health`, `players`.`healthmax`, `players`.`experience`, `players`.`lookbody`, `players`.`lookfeet`, `players`.`lookhead`, `players`.`looklegs`, `players`.`looktype`, `players`.`lookaddons`, `players`.`maglevel`, `players`.`mana`, `players`.`manamax`, `players`.`manaspent`, `players`.`soul`, `players`.`town_id`, `players`.`posx`, `players`.`posy`, `players`.`posz`, `players`.`conditions`, `players`.`cap`, `players`.`sex`, `players`.`lastlogin`, `players`.`lastip`, `players`.`save`, `players`.`skull`, `players`.`skulltime`, `players`.`lastlogout`, `players`.`blessings`, `players`.`balance`, `players`.`stamina`, `players`.`skill_fist`, `players`.`skill_fist_tries`, `players`.`skill_club`, `players`.`skill_club_tries`, `players`.`skill_sword`, `players`.`skill_sword_tries`, `players`.`skill_axe`, `players`.`skill_axe_tries`, `players`.`skill_dist`, `players`.`skill_dist_tries`, `players`.`skill_shielding`, `players`.`skill_shielding_tries`, `players`.`skill_fishing`, `players`.`skill_fishing_tries`, `players`.`deleted`, `players`.`create_ip`, `players`.`create_date`, `players`.`comment`, `players`.`hide_char`, `players`.`cast`, `players`.`castviewers`, `players`.`castdescription` FROM `players`, `guild_invites` WHERE `guild_invites`.`guild_id` = '48' AND `players`.`id` = `guild_invites`.`player_id` ORDER BY `players`.`name` ASC
SQLSTATE:    00000
Driver code: 
Error message:

Thnx anyway

 

[WibbenZ]

Please read the rules; #10 Rules for the Support board
Those are the queries that are executed, none of them have any errors so there isen't anything to go on there.
If you ment that you don't wanna see them just set DEBUG_DATABASE to false in your index.php.

Did you download Gesior from the github page or here on OTLand?
Check if the file you are using is this one; Gesior2012/guilds.php at TFS-1.0 · gesior/Gesior2012 · GitHub

There are some here on OTLand that has an updated layout but has alot of bugs in them, so try to use one from the github page; https://github.com/gesior/Gesior2012/archive/TFS-1.0.zip
And see if that fixes it.

 

[Tampek]

But this is serious TT i try to make guild wit znote engine and says it:

string(105) "INSERT INTO `guild_membership` (`player_id`, `guild_id`, `rank_id`, `nick`) VALUES ('776', '52', '', '');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Cannot add or update a child row: a foreign key constraint fails (`exilium`.`guild_membership`, CONSTRAINT `guild_membership_ibfk_3` FOREIGN KEY (`rank_id`) REFERENCES `guild_ranks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

 

[WibbenZ]

But this is serious TT i try to make guild wit znote engine and says it:

string(105) "INSERT INTO `guild_membership` (`player_id`, `guild_id`, `rank_id`, `nick`) VALUES ('776', '52', '', '');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Cannot add or update a child row: a foreign key constraint fails (`exilium`.`guild_membership`, CONSTRAINT `guild_membership_ibfk_3` FOREIGN KEY (`rank_id`) REFERENCES `guild_ranks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

Not sure why you mentioned Znote when you are using Gesior, since they are totally diffrent AACs.
About the query, you need to set rank_id to something, thats the problem.
Try setting it to 1 and run the query again.

 

[Tampek]

I tryed it with two engines and the problem is in rank_id what i can do to reset or just how i can inject 1 line like php with mysql injc

 

[WibbenZ]

Do 2 things to see where the problem is;
1. Replace the guilds.php file with this; Gesior2012/guilds.php at TFS-1.0 · gesior/Gesior2012 · GitHub
If that dosn't fix it, try this;
2. Try it on another database, without any modifications, clean schema installed and then reinstall gesior to ge the schema for it.

 

[Tampek]

fuck life its ok i think need make another new db and transfer all players and all shiets.. thnx anyway