1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
584:
585:
586:
587:
588:
589:
590:
591:
592:
593:
594:
595:
596:
597:
598:
599:
600:
601:
602:
603:
604:
605:
606:
607:
608:
609:
610:
611:
612:
613:
614:
615:
616:
617:
618:
619:
620:
621:
622:
623:
624:
625:
626:
627:
628:
629:
630:
631:
632:
633:
634:
635:
636:
637:
638:
639:
640:
641:
642:
643:
644:
645:
646:
647:
648:
649:
650:
651:
652:
653:
654:
655:
656:
657:
658:
659:
660:
661:
662:
663:
664:
665:
666:
667:
668:
669:
670:
671:
672:
673:
674:
675:
676:
677:
678:
679:
680:
681:
682:
683:
684:
685:
686:
687:
688:
689:
690:
691:
692:
693:
694:
695:
696:
697:
698:
699:
700:
701:
702:
703:
704:
705:
706:
707:
708:
709:
710:
711:
712:
713:
714:
715:
716:
717:
718:
719:
720:
721:
722:
723:
724:
725:
726:
727:
|
<?php
require_once("common.php");
//Helpfunction for Status of Guild/Clan
function StateToText($State){
switch ($State){
case 0 : return "`%Schwebend";
case 1 : return "`@Aktiv";
case -999: return "`4Abgelehnt";
default: return "`~Unbekannt";
}
}
function gce_mkinfoarray(){
global $_POST;
$clan['Status']=$_POST['status'];
$clan['Name']=$_POST['gildname'];
$clan['GuildPrefix']['display']=$_POST['shortcut'];
$clan['GuildPrefix']['pre']=$_POST['prefix'];
$clan['PublicText']=$_POST['txdescr'];
$clan['ApplyText']=$_POST['txapply'];
$clan['RulesText']=$_POST['txrules'];
$clan['ExternalPagesLink']=$_POST['externallink'];
$clan['avatar']=$_POST['avatar'];
$clan['avatarbig']=$_POST['avatarbig'];
$clan['gold']=$_POST['gold'];
$clan['gems']=$_POST['gems'];
$clan['SitePoints']=$_POST['sitepoints'];
return $clan;
}
function gce_getimagesize($image){
$erg=FALSE;
$org=$image;
$hlp=@getimagesize($org);
if ($hlp){
$erg=array(0=>$hlp[0],1=>$hlp[1]);
}else{
if (strpos($org," ")>0){
$org=substr($org,0,strpos($org," "));
}
if ($org{strlen($org)-1}=="\""){
$org=substr($org,0,strlen($org)-1);
}
$chk=strpos($org,"http");
if ((!$chk) && ($chk!=0)) {
$org="http://".$org;
}
$hlp=@getimagesize($org);
if ($hlp){
$erg=array(0=>$hlp[0],1=>$hlp[1]);
}else{
$pi=pathinfo($org);
$dst="temp/".$pi['basename'];
if (@copy($org,$dst)){
$hlp=@getimagesize($dst);
if ($hlp) $erg=array(0=>$hlp[0],1=>$hlp[1]);
unlink($dst);
}
}
}
return $erg;
}
function gce_calcrealtivsize($size){
$erg=array(0=>0,1=>0);
//Differenz berechnen
if ($size[0]>200){
$tmp1=$size[0]-200;
}
if ($size[1]>200){
$tmp2=$size[1]-200;
}
if ($tmp1 > $tmp2){
$erg[0]=$size[0]-$tmp1;
$erg[1]=$size[1]-$tmp1;
}else{
$erg[0]=$size[0]-$tmp2;
$erg[1]=$size[1]-$tmp2;
}
if (($erg[0] < 0) || ($erg[1] < 0)){
$erg[0]=200;
$erg[1]=200;
}
return $erg;
}
function gce_makepic($image,$imagebig=FALSE){
$erg=array('LINK'=>"",'TAG'=>"",'oversize'=>FALSE);
$size=gce_getimagesize($image);
$resize=gce_calcrealtivsize($size);
if (is_array($size)){
$erg['TAG']='<IMG src="'.$image.'" border="0"';
if (($size[0] >200) || ($size[1] > 200)){
$erg['TAG'].=' width="'.$resize[0].'" height="'.$resize[1].'"';
$erg['oversize']=$size;
}
$erg['TAG'].='">';
if ($imagebig){
$erg['LINK']='<a href="'.$imagebig.'" target="_blank">'.$erg['TAG'].'</a>';
}
}
return $erg;
}
//Overview of all Guild/Clans
function ViewGuildsClans(){
$sql="SELECT Status,ID,Name, IsGuild FROM lotbd_guilds ORDER BY NOT(IsGuild),ID;";
$result = db_query($sql) or die(db_error(LINK));
$ClanDone=FALSE;
output('<FORM name="work" method="post">',true);
output("<TABLE>",true);
output("<tr class='trmainhead'>",true);
output('<td colspan="4" align="center">Gilden</td>',true);
output('</tr>',true);
output("<tr class='trmainsub'>",true);
output('<TD>Aktion</TD><Td>ID</Td><Td>Name</Td><TD>Status</TD></TR>',true);
$first='checked="checked"';
for ($i=0;$i<db_num_rows($result);$i++){
$row = db_fetch_assoc($result);
if ((!$ClanDone) && ($row['IsGuild']==0)){
output("</TABLE><BR><BR><TABLE>",true);
output("<tr class='trmainhead'>",true);
output('<td colspan="4" align="center">Clans</td>',true);
output('</tr>',true);
output("<tr class='trmainsub'>",true);
output('<TD>Aktion</TD><Td>ID</Td><Td>Name</Td><TD>Status</TD></TR>',true);
$ClanDone=TRUE;
}
output("<tr class='trlightrow'>",true);
output('<TD align="center">',true);
output('<input type="radio" name="id" value="'.$row['ID'].'" '.$first.'>',true);
$first="";
output('</TD><TD align="center">',true);
output($row['ID']);
output('</TD><TD align="center">',true);
output($row['Name']);
output("</TD><TD>".StateToText($row['Status'])."</td>",TRUE);
output("</TR>",true);
}
output("</TABLE></form>",true);
db_free_result($result);
addnav("Aktionen");
addnav("Aktiv-Check","guildclanedit.php?op=active",FALSE,FALSE,"work");
addnav("Bearbeiten","guildclanedit.php?op=edit",FALSE,FALSE,"work");
addnav("Löschen","guildclanedit.php?op=del",FALSE,FALSE,"work");
addnav("Details","guildclanedit.php?op=details",FALSE,FALSE,"work");
addnav("Mitglieder","guildclanedit.php?op=members",FALSE,FALSE,"work");
addnav("Taube an alle Vorstände","guildclandedit.php?op=chefmail");
}
//Gets the amount of Members, where the Members must be active in the last $day - days
function GetGuildMemberCountDate($guildid,$isclan,$days){
$sql="SELECT count(acctid) as count from `accounts` WHERE ((";
if ($isclan){
$sql.="clanID=".$guildid.") AND (";
}else{
$sql.="guildID=".$guildid.") AND(";
}
$sql.="laston >= DATE_SUB(CURDATE(),INTERVAL ".$days." DAY)));";
$result = db_query($sql) or die(db_error(LINK));
$row=db_fetch_assoc($result);
$erg=$row['count'];
db_free_result($result);
return $erg;
}
//Get the total amount of Members
function GetGuildMemberCount($guildid,$isclan=FALSE){
if ($isclan){
$sql="SELECT count( acctid ) AS count FROM `accounts` WHERE (clanID =".$guildid." );";
}else{
$sql="SELECT count( acctid ) AS count FROM `accounts` WHERE (guildID =".$guildid." );";
}
$result = db_query($sql) or die(db_error(LINK));
$row=db_fetch_assoc($result);
$erg = $row['count'];
db_free_result($result);
return($erg);
}
function gce_GetMemberName($id,$bount=FALSE){
if ($bount){
$erg=array('name'=>"Unbekannt",'bounty'=>0);
}else{
$erg="Unbekannt";
}
if ($id >0){
$sql="SELECT name,bounty FROM accounts WHERE (acctid=".$id.");";
$res=db_query($sql);
if (($res) && (db_num_rows($res)>0)){
$row=db_fetch_assoc($res);
if ($bount){
$erg=array('name'=>$row['name'],'bounty'=>$row['bounty']);
}else{
$erg=$row['name'];
}
}
db_free_result($res);
}
return $erg;
}
//Get needed Data for a Member
function GetGuildHeadDates($id){
$sql="SELECT acctid,Name,laston,loggedin FROM accounts WHERE (acctid=".$id.");";
$result = db_query($sql) or die(db_error(LINK));
if (db_num_rows($result)>0){
$row=db_fetch_assoc($result);
$erg[0]=$row['laston'];
$erg[1]=$row['Name'];
$erg[2]=$row['acctid'];
$erg[3]=$row['loggedin'];
}else{
$erg[0]='*';
$erg[1]='`$`bnicht<BR> besetzt !`b';
$erg[2]=-1;
$erg[3]=0;
}
db_free_result($result);
return $erg;
}
//Calculation of Days aktive
function GetLastActive($laston,$loggedin){
if ($laston=='*'){
$erg=' ';
}else{
$loggedin=(date("U") - strtotime($laston) < getsetting("LOGINTIMEOUT",900) && $loggedin);
$erg=round((strtotime("0 days")-strtotime($laston)) / 86400,0)." Tage";
if (substr($erg,0,2)=="1 ") $erg="1 Tag";
if (date("Y-m-d",strtotime($laston)) == date("Y-m-d")) $erg="Heute";
if (date("Y-m-d",strtotime($laston)) == date("Y-m-d",strtotime("-1 day"))) $erg="Gestern";
if ($loggedin) $erg="Jetzt";
}
return $erg;
}
function GetFullGuildInfo($id){
$erg=FALSE;
$sql="SELECT * FROM lotbd_guilds WHERE (ID=".$id.");";
$result=db_query($sql);
if (($result) && (db_num_rows($result)>0)){
$row=db_fetch_assoc($result);
$erg=array();
while (list($key,$val) = each($row)){
if (($key=="GuildPrefix") || ($key=="PercentOfFightsEarned") || ($key=="Hitlist") || ($key=="OtherSitepoints")){
$erg[$key]=unserialize($val);
}else{
$erg[$key]=$val;
}
}
}
db_free_result($result);
return $erg;
}
//Check-Aktive-View
function ViewGuildClanactive($id){
global $session;
$row = GetFullGuildInfo($id);
$memcount = GetGuildMemberCount($row['ID'],($row['IsGuild']==0));
$memcount2 = GetGuildMemberCountDate($row['ID'],($row['IsGuild']==0),5);
$memcount3 = GetGuildMemberCountDate($row['ID'],($row['IsGuild']==0),10);
$memcount4 = $memcount-$memcount3;
$memcount3 = $memcount3-$memcount2;
if ($memcount4 < 0) $memcount4=0;
if ($memcount3 < 0) $memcount3=0;
if ($row['IsGuild']==1){
$chefs[0]=GetGuildHeadDates($row['GuildLeader']);
$chefs[1]=GetGuildHeadDates($row['HeadOfMembership']);
$chefs[2]=GetGuildHeadDates($row['HeadOfWar']);
$chefid[]=$chefs[0][2];
$chefid[]=$chefs[1][2];
$chefid[]=$chefs[2][2];
}else{
$chefs[0]=GetGuildHeadDates($row['GuildLeader']);
$chefid[]=$chefs[0][2];
}
output("<TABLE>",TRUE);
output("<TR class='trmainhead'>",true);
output("<TD>ID</TD><TD>Name</TD><TD>Anzahl<BR> Mitglieder</TD><TD>in den letzten <BR>5 Tagen <BR> aktiv</TD>",true);
output("<TD>in den letzten <BR>10 Tagen <BR>aktiv</TD>",true);
output("<TD>länger als<BR>10 Tage <BR>inaktiv</TD>",true);
if ($row['IsGuild']==0){
output("<TD>Clan-Vorsitzender <BR>zuletzt aktiv:</TD>",true);
}else{
output("<TD>Vorsitzender<BR>zuletzt aktiv:</TD>",true);
output("<TD>Verwaltung<BR> zuletzt aktiv:</TD>",true);
output("<TD>Befehlshaber<BR>zuletzt aktiv:</TD>",true);
}
output("</TR><TR class='trlightrow'>",true);
output("<TD align='center'>".$row['ID']."</TD>",true);
output("<TD align='center'>",true);
output($row['Name']);
output("</TD>",true);
output("<TD align='center'>".$memcount."</TD>",true);
output("<TD align='center'>".$memcount2."</TD>",true);
output("<TD align='center'>".$memcount3."</TD>",true);
output("<TD align='center'>".$memcount4."</TD>",true);
if ($row['IsGuild']==0){
output('<td align="center">'.$chefs[0][1]."<BR>".GetLastActive($chefs[0][0],$chefs[0][3]).'</td>',true);
}else{
output('<td align="center">'.$chefs[0][1]."<BR>".GetLastActive($chefs[0][0],$chefs[0][3]).'</td>',true);
output('<td align="center">'.$chefs[1][1]."<BR>".GetLastActive($chefs[1][0],$chefs[1][3]).'</td>',true);
output('<td align="center">'.$chefs[2][1]."<BR>".GetLastActive($chefs[2][0],$chefs[2][3]).'</td>',true);
}
output("</TR></TABLE><BR><BR>",true);
if (trim($row['avatar'])<> ""){
output('Avatar:<BR><img src="'.$row['avatar'].'"><BR>',true);
}
//Mail an den Vorsitz
ShowMassMailForm('<B>`$Taube an die Vorstandschaft:</B><BR>',"guildclanedit.php?op=mail",$chefid);
addnav("Mitgliederliste","guildclanedit.php?op=members&id=".$id);
addnav("zurück","guildclanedit.php");
}
function Make_Pre_Select($selected){
$result='<SELECT name="prefix">';
$result.='<OPTION value="0"';
if ($selected==0) $result.=' selected="selected"';
$result.='>Als Suffix zum Namen</option>';
$result.='<OPTION value="1"';
if ($selected==1) $result.=' selected="selected"';
$result.='>Als Prefix zum Namen</option>';
$result.='<OPTION value="2"';
if ($selected==2) $result.=' selected="selected"';
$result.='>Ohne Kennzeichnung</option>';
$result.='</SELECT>';
return $result;
}
function Make_Status_Select($selected){
if (($selected<>0) && ($selected <> 1) && ($selected <>-999)) $selected=0;
$result='<SELECT name="status">';
$result.='<OPTION value="0"';
if ($selected==0) $result.=' selected="seleted"';
$result.='>Schwebend</option>';
$result.='<OPTION value="1"';
if ($selected==1) $result.=' selected="selected"';
$result.='>Aktiv</option>';
$result.='<OPTION value="-999"';
if ($selected==-999) $result.=' selected="selected"';
$result.='>Abgelehnt</option>';
$result.='</SELECT>';
return $result;
}
function EditGuildClan($id,$isnew=TRUE){
$data = GetFullGuildInfo($id);
$hitlist=gce_gethitlistinfo($data['Hitlist']);
if (!isset($data[PercentOfFightsEarned][Bank])){
$data[PercentOfFightsEarned][Bank]=0;
}
$pre="";
switch ($data['GuildPrefix']['pre']){
case 0 : $pre="Suffix";
break;
case 1 : $pre="Prefix";
break;
case 2 : $pre="Ohne";
break;
}
$avatar=gce_makepic($data['avatar']);
if (!$isnew){
output('`c`b Details zu '.$data[Name].'`b`c`n`n');
}
$chef=gce_GetMemberName($data[GuildLeader]);
if ($data['IsGuild']){
$general=gce_GetMemberName($data[HeadOfWar]);
$organ=gce_GetMemberName($data[HeadOfMembership]);
}
$avext="";
if ($avatar['oversize']){
$avext='<BR>`$Ist zu Groß:<BR>Breite:'.$avatar['oversize'][0].' Höhe:'.$avatar['oversize'][1].'`0';
}
if ($data['IsGuild']){
$loctemp=LoadTemplate("gildtable.html");
}else{
$loctemp=LoadTemplate("clantable.html");
}
$avatarinp=$loctemp['avatarinput'];
$avatarinp=str_replace("{avatarlink}",SafeDisplayString($data['avatar']),$avatarinp);
$avatarinp=str_replace("{avatarlinkbig}",SafeDisplayString($data['avatarbig']),$avatarinp);
$avatarinp=str_replace("{extrainfo}",$avext,$avatarinp);
$linkinp=str_replace("{externallink}",SafeDisplayString($data['ExternalPagesLink']),$loctemp['externalinput']);
$rep=array("{name}"=>'<input type="text" name="gildname" value="'.SafeDisplayString($data[Name]).'" size="50">',
"{status}"=>Make_Status_Select($data['Status']),
"{description}"=>'<Textarea name="txdescr" cols="70" rows="10">'.SafeDisplayString($data[PublicText]).'</textarea>',
"{chef}"=>$chef,
"{general}"=>$general,
"{Organisator}"=>$organ,
"{Bewerbertext}"=>'<TEXTAREA name="txapply" cols="70" rows="10">'.SafeDisplayString($data['ApplyText']).'</TEXTAREA>',
"{Regeln}"=>'<TEXTAREA name="txrules" cols="70" rows="10">'.SafeDisplayString($data['RulesText']).'</TEXTAREA>',
"{prefixtext}"=>'<INPUT TYPE="TEXT" name="shortcut" size="9" maxlength="9" value="'.SafeDisplayString($data['GuildPrefix']['display']).'">',
"{prefixtyp}"=>Make_Pre_Select($data['GuildPrefix']['pre']),
"{avatarext}"=>$avatarinp,
"{externlinktext}"=>$linkinp,
"{GPCP}"=>'<INPUT TYPE="TEXT" name="sitepoints" size="10" value="'.$data['SitePoints'].'">',
"{gold}"=>'<INPUT TYPE="TEXT" name="gold" size="10" value="'.$data['gold'].'">',
"{edeltsteine}"=>'<INPUT TYPE="TEXT" name="gems" size="10" value="'.$data['gems'].'">',
"{Kredit}"=>'<INPUT TYPE="TEXT" name="credit" size="10" value="'.$data['creditlimit'].'">',
"{pheiler}"=>$data[HealDiscount],
"{ptraining}"=>$data[TrainDiscount],
"{pgems}"=>$data[GemPurchaseDiscount],
"{ptrank}"=>$data[PotionDiscount],
"{pwaffe}"=>$data[WeaponDiscount],
"{pruestung}"=>$data[ArmourDiscount],
"{phaus}"=>$data[OtherSitepoints][house],
"{ptier}"=>$data[OtherSitepoints][mount],
"{pbank}"=>$data[PercentOfFightsEarned][Bank],
"{tff}"=>$data[ PercentOfFightsEarned][FF],
"{tpvp}"=>$data[ PercentOfFightsEarned][PvP],
"{additionalinput}"=>'<TR class="trlightrow"><TD colspan="4" align="center"><input type="submit" value="Speichern" class="button"></TD></TR>'
);
$myout=ReplaceTemplate($loctemp['main'],$rep);
output('<FORM method="POST" action="guildclanedit.php?op=submit">',true);
output('<INPUT TYPE="hidden" name="ID" value="'.$id.'">',true);
output($myout,true);
output('</FORM>',true);
addnav("","guildclanedit.php?op=submit");
addnav("Zurück","guildclanedit.php");
}
//Request for delete of a Guild/Clan
function DeleteGuildClan($id){
global $session;
$clan=$session['guilds'][$id];
addnav("zurück","guildclanedit.php");
addnav("","guildclanedit.php?op=DelDo&id=".$id);
output('<FORM method="POST" action="guildclanedit.php?op=DelDo&id='.$id.'">',true);
if ($clan['IsGuild']==0){
output("Den Clan ".$clan['Name'].'<FONT color="#CCCCCC"> wirklich löschen ?</FONT>',true);
}else{
output("Die Gilde ".$clan['Name'].'<FONT color="#CCCCCC"> wirklich löschen ?</FONT>',true);
}
output('<INPUT TYPE="SUBMIT" NAME="ok" VALUE="JA"> <INPUT TYPE="SUBMIT" name="ok" VALUE="NEIN"></FORM>',true);
}
//Update Guildinfos
function SubmitChanges(){
global $_POST,$session;
$id = $_POST['ID'];
$clan=&$session['guilds'][$id];
$clan['Status']=$_POST['status'];
$clan['Name']=$_POST['gildname'];
$clan['GuildPrefix']['display']=$_POST['shortcut'];
$clan['GuildPrefix']['pre']=$_POST['prefix'];
$clan['PublicText']=$_POST['txdescr'];
$clan['ApplyText']=$_POST['txapply'];
$clan['RulesText']=$_POST['txrules'];
$clan['ExternalPagesLink']=$_POST['externallink'];
$clan['avatar']=$_POST['avatar'];
$clan['avatarbig']=$_POST['avatarbig'];
$clan['gold']=$_POST['gold'];
$clan['gems']=$_POST['gems'];
$clan['SitePoints']=$_POST['sitepoints'];
update_guild_info($clan);
output('Änderungen gespeichert !');
addnav("Zurück",'guildclanedit.php');
}
//Do deleting of a Guild/Clan an all referenzes
function DeleteGuildClansDo($id){
global $_POST,$session;
if ($_POST['ok']=='JA'){
$clan=$session['guilds'][$id];
if ($clan['IsGuild']){
$was='Gilde';
$sub='der';
$sub2='die';
}else{
$was='Clan';
$sub='des';
$sub2='den';
}
output("`nLösche alle Ränge $sub $was");
$sql="delete from lotbd_guildranks where GuildID=".$id;
db_query($sql);
output("`nAlle Ränge gelöscht.");
output("`nAktualisiere Mitglieder-Accounts...");
$sql="select count(*) as affected from accounts where guildID=".$id." OR clanID=".$id;
$result=db_query($sql);
$row=db_fetch_assoc($result);
output("`n ......".$row['affected']." Spieler betroffen.");
db_free_result($result);
$sql="update accounts set goldafterdk=0, clanID=0, guildID=0, guildrank=0 where guildID=".$id." OR clanID = ".$id;
db_query($sql);
output("`nSpieler aktualisiert!");
output("`nLösche Informationen über $sub2 $was");
$sql="delete from lotbd_guilds where ID=".$id;
db_query($sql);
output("`n$sub2 $was ist gelöscht.");
}
addnav("Zurück",'guildclanedit.php');
}
//Little helpfunction for viewing current aktion in the header
function GetNavOptionText($option){
switch($option){
case "active" : return " -> Aktiv-Check";
case "edit" : return " -> Ändern";
case "mail" : return " -> Mail(s) an den Vorstand";
case "del" : return " -> Löschen";
case "details": return " -> Detailansicht";
default : return "";
}
}
function GetGuildClanInfo($id){
$sql="SELECT Name,isGuild,GuildLeader,HeadOfMembership,HeadOfWar FROM lotbd_guilds WHERE (ID=".$id.");";
$result=db_query($sql);
$row=db_fetch_assoc($result);
db_free_result($result);
return $row;
}
function GetMemberlist($id,$isguild,$chefs){
$sql="SELECT acctid FROM accounts WHERE ((";
if ($isguild){
$sql.="guildID=".$id;
}else{
$sql.="clanID=".$id;
}
$sql.=") AND NOT(acctid ";
if ($isguild){
$sql.="IN (".implode(",",$chefs)."))) ORDER BY dragonkills DESC;";
}else{
$sql.="=".$chefs[0].")) ORDER BY dragonkills DESC;";
}
$result=db_query($sql);
while ($row=db_fetch_assoc($result)) $uid[]=$row['acctid'];
db_free_result($result);
return $uid;
}
function GetMemberInfo($id){
$erg=array();
$sql="SELECT acctid,name,laston,loggedin,dragonkills FROM accounts WHERE (acctid=".$id.");";
$result=db_query($sql);
$row=db_fetch_assoc($result);
db_free_result($result);
return $row;
}
function ViewMembers($id){
$guild=GetGuildClanInfo($id);
if ($guild['isGuild']){
$chefs[]=$guild['GuildLeader'];
$chefs[]=$guild['HeadOfMembership'];
$chefs[]=$guild['HeadOfWar'];
}else{
$chefs[]=$guild['GuildLeader'];
}
output("<CENTER><B>".$guild['Name']."</B></CENTER><BR><BR>",true);
output('<TABLE width="70%"><TR class="trhead"><TD width="45%">Name</TD><TD width="10%">Drachenkills</TD><TD>Zuletzt Online</TD><TD>Tage</TD></TR>',true);
$max=count($chefs);
for ($i=0;$i<$max;$i++){
$info=GetMemberInfo($chefs[$i]);
output('<TR class="trdarkrow">',true);
output('<TD>'.$info['name'].'</TD>',true);
output('<TD>'.$info['dragonkills'].'</TD>',true);
output('<TD>'.date('d.m.Y H:i:s',strtotime($info['laston'])).'</TD>',true);
output('<TD>'.GetLastLoggin($info['laston'],$info['loggedin']).'</TD>',true);
output('</TR>',true);
}
output('<TR class="trhead"><TD width="45%">Name</TD><TD width="10%">Drachenkills</TD><TD>Zuletzt Online</TD><TD>Tage</TD></TR>',true);
$list=GetMemberlist($id,$guild['isGuild'],$chefs);
$max=count($list);
for ($i=0;$i<$max;$i++){
$info=GetMemberInfo($list[$i]);
output('<TR class="trlightrow">',true);
output('<TD>'.$info['name'].'</TD>',true);
output('<TD>'.$info['dragonkills'].'</TD>',true);
output('<TD>'.date('d.m.Y H:i:s',strtotime($info['laston'])).'</TD>',true);
output('<TD>'.GetLastLoggin($info['laston'],$info['loggedin']).'</TD>',true);
output('</TR>',true);
}
output('</TABLE><BR><BR>',true);
addnav("Mail an die Mitglieder","guildclanedit.php?op=membermail&id=".$id);
addnav("Zurück",'guildclanedit.php');
}
function MailToMembers($id){
$info=GetGuildClanInfo($id);
$users=GetMemberlist($id,$info['isGuild'],array(0=>0));
ShowMassMailForm('Mitglieder von '.$info['Name'].'<BR><BR>',"guildclanedit.php?op=mail",$users);
}
function MailToAllChefs(){
$sql="SELECT GuildLeader,HeadOfMembership,HeadOfWar, IsGuild FROM lotbd_guilds;";
$res=db_query($sql);
$chefs=array();
while($row=db_fetch_assoc($res)){
if ($row['IsGuild']){
if ($row['GuildLeader'] > 0) $chefs[]=$row['GuildLeader'];
if ($row['GuildLeader'] > 0) $chefs[]=$row['HeadOfMembership'];
if ($row['GuildLeader'] > 0) $chefs[]=$row['HeadOfWar'];
}else{
if ($row['GuildLeader'] > 0) $chefs[]=$row['GuildLeader'];
}
}
db_free_result($res);
ShowMassMailForm('<B>`$Taube alle Vorstände</B><BR>',"guildclanedit.php?op=chefmail2",$chefs);
}
function gce_gethitlistinfo($orglist){
$erg=FALSE;
if (is_array($orglist)){
$max=count($orglist);
if ($max>0){
$erg=array();
while (list($key,$val)=each($orglist)){
$erg[]=gce_GetMemberName($key,TRUE);
}
}
}
return $erg;
}
function ViewGuildClanDetails($id){
$data = GetFullGuildInfo($id);
$hitlist=gce_gethitlistinfo($data['Hitlist']);
if (!isset($data[PercentOfFightsEarned][Bank])){
$data[PercentOfFightsEarned][Bank]=0;
}
$pre="";
switch ($data['GuildPrefix']['pre']){
case 0 : $pre="Suffix";
break;
case 1 : $pre="Prefix";
break;
case 2 : $pre="Ohne";
break;
}
$avatar=gce_makepic($data['avatar']);
output('`c`b Details zu '.$data[Name].'`b`c`n`n');
$chef=gce_GetMemberName($data[GuildLeader]);
if ($data['IsGuild']){
$general=gce_GetMemberName($data[HeadOfWar]);
$organ=gce_GetMemberName($data[HeadOfMembership]);
}
$avext="";
if ($avatar['oversize']){
$avext='<BR>`$Ist zu Groß:<BR>Breite:'.$avatar['oversize'][0].' Höhe:'.$avatar['oversize'][1].'`0';
}
if ($data['IsGuild']){
$loctemp=LoadTemplate("gildtable.html");
}else{
$loctemp=LoadTemplate("clantable.html");
}
$outavatar=$loctemp['avatarlink'];
if ($data['avatarbig'] <> ""){
$outavatar=str_replace("{avatarlink}",$data['avatarbig'],$outavatar);
}else{
$outavatar=str_replace("{avatarlink}",$data['avatar'],$outavatar);
}
$outavatar=str_replace("{avatarbild}",$avatar['TAG'],$outavatar);
$outexternal=$loctemp['externallink'];
$outexternal=str_replace("{externallink}",$data['ExternalPagesLink'],$outexternal);
$outexternal=str_replace("{externlinktext}",$data['ExternalPagesLink'],$outexternal);
$rep=array("{name}"=>$data[Name],
"{status}"=>StateToText($data[Status]),
"{description}"=>$data[PublicText],
"{chef}"=>$chef,
"{general}"=>$general,
"{Organisator}"=>$organ,
"{Bewerbertext}"=>$data[ApplyText],
"{Regeln}"=>$data[RulesText],
"{prefixtext}"=>$data['GuildPrefix']['display'],
"{prefixtyp}"=>$pre,
"{avatarext}"=>$outavatar.$avext,
"{externlinktext}"=>$outexternal,
"{GPCP}"=>$data['SitePoints'],
"{gold}"=>$data['gold'],
"{edeltsteine}"=>$data['gems'],
"{Kredit}"=>$data['creditlimit'],
"{pheiler}"=>$data[HealDiscount],
"{ptraining}"=>$data[TrainDiscount],
"{pgems}"=>$data[GemPurchaseDiscount],
"{ptrank}"=>$data[PotionDiscount],
"{pwaffe}"=>$data[WeaponDiscount],
"{pruestung}"=>$data[ArmourDiscount],
"{phaus}"=>$data[OtherSitepoints][house],
"{ptier}"=>$data[OtherSitepoints][mount],
"{pbank}"=>$data[PercentOfFightsEarned][Bank],
"{tff}"=>$data[ PercentOfFightsEarned][FF],
"{tpvp}"=>$data[ PercentOfFightsEarned][PvP],
"{additionalinput}"=>""
);
$myout=ReplaceTemplate($loctemp['main'],$rep);
output($myout,true);
output('`c`b Hitliste '.$data[Name].'`b`c`n`n');
output('<TABLE>',true);
output('<TR class="trhead"><TD>Name</TD><TD>Kopfgeld</TD>',true);
$max=count($hitlist);
for ($i=0;$i<$max;$i++){
output('<TR class="trlightrow">',true);
output('<TD>'.$hitlist[$i]['name'].'</TD>',true);
output('<TD>'.$hitlist[$i]['bounty'].' Goldstücke</TD></TR>',true);
}
output('</TABLE>',true);
addnav("Zurück",'guildclanedit.php');
}
?>
|