| 00:58.51 | *** mode/#wowroster [+o Zeryl] by ChanServ |
| 05:06.41 | *** join/#wowroster Anaxent (n=Anaxent@ip72-208-134-254.ph.ph.cox.net) |
| 05:06.41 | *** mode/#wowroster [+o Anaxent] by ChanServ |
| 06:40.18 | *** join/#wowroster weather23232 (n=weather2@72.22.91.18) |
| 06:42.53 | *** join/#wowroster weather23232 (n=weather2@72.22.91.18) |
| 06:43.56 | *** join/#wowroster weather23232 (n=weather2@72.22.91.18) |
| 07:19.09 | *** join/#wowroster Zeryl (n=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) |
| 07:19.10 | *** mode/#wowroster [+o Zeryl] by ChanServ |
| 08:16.57 | *** join/#wowroster Vecna (i=Vecnah@vecna.aenix.net) |
| 11:03.08 | *** join/#wowroster Guest (n=Guest@72.168.183.174) |
| 11:03.54 | Guest | hello, anyone around? |
| 11:06.55 | Zanix | yeah |
| 11:07.01 | Zanix | whats up? |
| 11:08.18 | Guest | i think my mind has left me, |
| 11:08.36 | Guest | i am trying to download the wowroster...when i do, it takes me right back to the same page... |
| 11:08.44 | Guest | and thanks for responding |
| 11:10.39 | PleegWat | did you read the topic? |
| 11:10.47 | PleegWat | You're probably on the wrong url |
| 11:10.59 | Guest | oh, i did .net |
| 11:11.00 | Zanix | we have 3 urls, bu tonly one works right |
| 11:11.14 | Zanix | wowroster.net is the right one |
| 11:12.06 | Guest | i will try that thanks, |
| 11:12.17 | Guest | this is a very snappy site, looks wise and features btw, |
| 11:12.26 | Guest | not sure if you are "in" with them or not, but it looks very nice |
| 11:13.10 | Zanix | "in" with whom? |
| 11:14.00 | Zanix | i think you just confused me |
| 11:14.01 | Zanix | lol |
| 11:15.31 | Guest | not sure if you are staff, or just a helpful fellow |
| 11:17.59 | Guest | well have a good night, i got it now so i am off to destroy my server, good luck to you |
| 11:18.48 | Zanix | hehe |
| 11:19.02 | Zanix | I am THE All powerfull ZANIX |
| 11:19.10 | Zanix | too bad he left before I coudl say that |
| 11:19.12 | Zanix | :( |
| 12:07.31 | *** join/#wowroster Guest (n=Guest@72.168.183.174) |
| 12:08.39 | dumbgnome | good morning, anyone ava to help with a quick question? i have read the forums but havnt found a solution |
| 12:10.37 | dumbgnome | i have the package installed and working. i can log into admin. when i do i get a "could not find guild"name" for server "Dalaran" and it tells me to load my guild, or finish config. i am at a loss as to how to do this. |
| 12:11.37 | PleegWat | You haven't entered your guildname correctly in the config |
| 12:14.19 | dumbgnome | ok let me try that. again i copied it out of the profiler, |
| 12:22.30 | dumbgnome | ok i ran the guild profiler, saved it. when i goto the upload profile, iput in my admin pw, and the guild profile file. says "not accepted" |
| 12:24.51 | dumbgnome | ok, got that! |
| 12:24.54 | dumbgnome | bingo bango! |
| 12:26.25 | dumbgnome | is it possible to remove people from this list i dont want displayed? only show X Y Z charcters? |
| 12:27.43 | dumbgnome | say to show only characters who have uploaded a profile? |
| 15:10.23 | dracula | hmm good point from dumbgnome.. reminds me of a thing I wanted to do: |
| 15:11.38 | dracula | our roster is currently 'polluted' with old pre-2.0 profiles |
| 15:11.52 | dracula | people who uploaded their profile in the past but never again after |
| 15:13.24 | dracula | so how would I remove those profiles? |
| 15:13.53 | dracula | eg. delete all profiles where upload date <= 01-11-2006 |
| 15:14.34 | dracula | it's easy to do this with SQL, but I don't know what tables are linked |
| 15:26.08 | *** join/#wowroster Anax (n=chatzill@209-250-16-194.convergentaz.net) |
| 15:28.13 | *** mode/#wowroster [+o Anaxent] by ChanServ |
| 15:32.31 | Anaxent | good morning |
| 16:04.29 | PleegWat | It's all on member ID |
| 16:04.44 | PleegWat | There's some code in wowdb for throwing away guild members of old guilds |
| 16:05.18 | PleegWat | Easy way to trigger it might be to do a sql statement that sets the guildID to a different value if the profiles are old |
| 16:06.43 | *** join/#wowroster Promethee (n=Promethe@m93.net81-64-199.noos.fr) |
| 16:06.56 | Promethee | hi there |
| 16:07.33 | Promethee | first I applogize for my bad english |
| 16:07.53 | Promethee | Can anybody help me ? |
| 16:10.08 | Promethee | I've installed wowroster for my guild this morning and I've a problem with guild bank apparence, I've already patch with files given in the forum |
| 16:10.51 | Promethee | but guild bank page only show me bag content and not bank content of my guild bank |
| 16:11.53 | Promethee | someone to help me ? |
| 16:28.14 | dracula | PleegWat: would that delete their profile, or remove their name from the roster entirely? |
| 16:30.48 | PleegWat | That should remove them on the next update, then readd them |
| 16:59.38 | Anaxent | hi PleegWat |
| 17:09.17 | PleegWat | hi anax |
| 17:09.21 | PleegWat | I just dinged 70 |
| 17:09.45 | PleegWat | You happen to know where to get the flying mount? |
| 17:13.37 | PleegWat | Never mind, found out on alla. Shadowmoon. |
| 17:20.30 | Anaxent | oh nice work man |
| 17:35.38 | Anaxent | oh boy.. I think I have found my self a function to insert a forum post |
| 17:35.53 | Anaxent | just needs to be modifies a little bit |
| 18:09.38 | Anaxent | hey PleegWat does line 46 look right? |
| 18:09.40 | Anaxent | http://wowroster.net/pastebin/index.php?show=46 |
| 18:10.54 | Anaxent | man if this works this will be hot |
| 18:11.26 | Anaxent | then I will make a query in the admin panel to choose the forum you want to post to by forum # |
| 18:11.35 | Anaxent | all posts will be new topics |
| 18:12.08 | Anaxent | and im sure if i really wanted to I could set a switch if druid post here if hunter post here etc... |
| 18:12.21 | Anaxent | oh and how do you like your flying mount |
| 18:38.46 | *** join/#wowroster Vecna (i=Vecnah@vecna.aenix.net) |
| 19:06.04 | PleegWat | Looks fine |
| 19:06.13 | PleegWat | Bit short on quoting inside the SQL though |
| 19:07.33 | PleegWat | Well, flying mount is kinda fun |
| 19:07.38 | PleegWat | But FP mount is faster |
| 19:07.50 | PleegWat | So now I'm saving up for my epic flying mount |
| 19:10.58 | Anaxent | so close now |
| 19:11.10 | Anaxent | modules/Application/functions_insert_post.php |
| 19:11.12 | Anaxent | <PROTECTED> |
| 19:11.14 | Anaxent | <PROTECTED> |
| 19:11.15 | Anaxent | <PROTECTED> |
| 19:11.17 | Anaxent | <PROTECTED> |
| 19:11.18 | Anaxent | <PROTECTED> |
| 19:11.20 | Anaxent | <PROTECTED> |
| 19:11.33 | Anaxent | so the first query is not getting the topic_description |
| 19:12.32 | PleegWat | The values in the first two queries aren't quoted |
| 19:12.37 | PleegWat | String values need to be quoted |
| 19:12.43 | PleegWat | unless the DB layer is doing that but I doubt it |
| 19:23.14 | Anaxent | http://wowroster.net/pastebin/index.php?show=47 |
| 19:23.20 | Anaxent | is what it looks like now |
| 19:23.30 | Anaxent | should it be http://wowroster.net/pastebin/index.php?show=48 |
| 19:35.31 | Anaxent | 0.0003 - FAILED LINE 121: INSERT INTO cms_fpro_topics (topic_title, topic_description, topic_descmod, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('Anax Application', 'Application', 0, 2, 1171135954, 3 , 0, 0, 0, ) |
| 19:35.43 | Anaxent | $sql = "INSERT INTO " . $forumspro_prefix . "topics (topic_title, topic_description, topic_descmod, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('$subject', 'Application', ".intval($desc4mod).", ".$userinfo['user_id'].", $current_time, $forum_id , 0, 0, $topic_vote, $topic_icon)"; |
| 19:41.40 | Anaxent | im running the querys in phpmyadmin now to figure this out |
| 19:41.50 | Anaxent | I think it has to do with the order of my insertc |
| 20:08.16 | Anaxent | damn almost got it |