Merhaba Arkdaşlar;
Öncelikle Kendi Serverim İçin EditledigimBir Kaç Özelik Ekledigim Paneli Pvp-Kenti Üyeleriyle Paylaşmaktan Gurur Duyarım.
-ÖZELİKLER-
Ticket Ve Şifre Degişimi
Admin Panel
User Detay Görüntülü
Np Bağış Sistemi
Server oylama sistemi her accounta giriş yapmadan oy atmaz
Yetkili Listesi
Server Bilgileri
PANELDEN RESİMLER
Gelelim Kurulumuna
Şimdi arkadaslar panel kurulumunda Appserver degilde
Xampp kullanıcaz.
Xampp serverin kurulumunu yaptıkdan sonra Xampp Control Panel'i Çalıstırın
Aşşagıdakı resme bakarak aynısını yapın
Not : Eger oto patch kullanıyorsanız Filezilla seçenegini işaretlemeniz yeterli olucaktır.
Query Analyzr Sql Kod
Tablo İçerikleri
Egerki bi sorunla karsılasırsanız enq-w0se@hotmail.com adrese ulaşın
Öncelikle Kendi Serverim İçin EditledigimBir Kaç Özelik Ekledigim Paneli Pvp-Kenti Üyeleriyle Paylaşmaktan Gurur Duyarım.
-ÖZELİKLER-
Ticket Ve Şifre Degişimi
Admin Panel
User Detay Görüntülü
Np Bağış Sistemi
Server oylama sistemi her accounta giriş yapmadan oy atmaz
Yetkili Listesi
Server Bilgileri
PANELDEN RESİMLER
Gelelim Kurulumuna
Şimdi arkadaslar panel kurulumunda Appserver degilde
Xampp kullanıcaz.
Xampp serverin kurulumunu yaptıkdan sonra Xampp Control Panel'i Çalıstırın
Aşşagıdakı resme bakarak aynısını yapın
Not : Eger oto patch kullanıyorsanız Filezilla seçenegini işaretlemeniz yeterli olucaktır.
Query Analyzr Sql Kod
- Kod:
[color=#000000][color=#0000BB]ALTER TABLE TB_USER ADD nVotePoints int [/color][color=#007700]DEFAULT [/color][color=#0000BB]1[/color][color=#007700];
[/color][color=#0000BB]CREATE TABLE [/color][color=#007700][[/color][color=#0000BB]dbo[/color][color=#007700]].[[/color][color=#0000BB]VOTE_BUTTONS[/color][color=#007700]](
[[/color][color=#0000BB]id[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]IDENTITY[/color][color=#007700]([/color][color=#0000BB]1[/color][color=#007700],[/color][color=#0000BB]1[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]url[/color][color=#007700]] [[/color][color=#0000BB]varchar[/color][color=#007700]]([/color][color=#0000BB]256[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]button[/color][color=#007700]] [[/color][color=#0000BB]varchar[/color][color=#007700]]([/color][color=#0000BB]256[/color][color=#007700]) [/color][color=#0000BB]NOT NULL
[/color][color=#007700]) [/color][color=#0000BB]ON [/color][color=#007700][[/color][color=#0000BB]PRIMARY[/color][color=#007700]]
[/color][color=#0000BB]CREATE TABLE [/color][color=#007700][[/color][color=#0000BB]dbo[/color][color=#007700]].[[/color][color=#0000BB]VOTE_REWARD_LOGS[/color][color=#007700]](
[[/color][color=#0000BB]id[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]IDENTITY[/color][color=#007700]([/color][color=#0000BB]1[/color][color=#007700],[/color][color=#0000BB]1[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]strAccountID[/color][color=#007700]] [[/color][color=#0000BB]varchar[/color][color=#007700]]([/color][color=#0000BB]21[/color][color=#007700]) [/color][color=#0000BB]NULL[/color][color=#007700],
[[/color][color=#0000BB]nPrizeID[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]redeemTime[/color][color=#007700]] [[/color][color=#0000BB]datetime[/color][color=#007700]] [/color][color=#0000BB]NOT NULL
[/color][color=#007700]) [/color][color=#0000BB]ON [/color][color=#007700][[/color][color=#0000BB]PRIMARY[/color][color=#007700]]
[/color][color=#0000BB]CREATE TABLE [/color][color=#007700][[/color][color=#0000BB]dbo[/color][color=#007700]].[[/color][color=#0000BB]VOTE_REWARDS[/color][color=#007700]](
[[/color][color=#0000BB]id[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]IDENTITY[/color][color=#007700]([/color][color=#0000BB]1[/color][color=#007700],[/color][color=#0000BB]1[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]nCost[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]bItem[/color][color=#007700]] [[/color][color=#0000BB]tinyint[/color][color=#007700]] [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]bGold[/color][color=#007700]] [[/color][color=#0000BB]tinyint[/color][color=#007700]] [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]nPrize[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]NOT NULL[/color][color=#007700],
) [/color][color=#0000BB]ON [/color][color=#007700][[/color][color=#0000BB]PRIMARY[/color][color=#007700]]
[/color][color=#0000BB]CREATE TABLE [/color][color=#007700][[/color][color=#0000BB]dbo[/color][color=#007700]].[[/color][color=#0000BB]SITE_NEWS[/color][color=#007700]](
[[/color][color=#0000BB]id[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]IDENTITY[/color][color=#007700]([/color][color=#0000BB]1[/color][color=#007700],[/color][color=#0000BB]1[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]dDate[/color][color=#007700]] [[/color][color=#0000BB]datetime[/color][color=#007700]] [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]strTitle[/color][color=#007700]] [[/color][color=#0000BB]varchar[/color][color=#007700]]([/color][color=#0000BB]50[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]strMessage[/color][color=#007700]] [[/color][color=#0000BB]text[/color][color=#007700]] [/color][color=#0000BB]NOT NULL
[/color][color=#007700]) [/color][color=#0000BB]ON [/color][color=#007700][[/color][color=#0000BB]PRIMARY[/color][color=#007700]]
[/color][color=#0000BB]CREATE TABLE [/color][color=#007700][[/color][color=#0000BB]dbo[/color][color=#007700]].[[/color][color=#0000BB]VOTE_LOGS[/color][color=#007700]](
[[/color][color=#0000BB]id[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]IDENTITY[/color][color=#007700]([/color][color=#0000BB]1[/color][color=#007700],[/color][color=#0000BB]1[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]strClientIP[/color][color=#007700]] [[/color][color=#0000BB]varchar[/color][color=#007700]]([/color][color=#0000BB]15[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]buttonID[/color][color=#007700]] [[/color][color=#0000BB]int[/color][color=#007700]] [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]strAccountID[/color][color=#007700]] [[/color][color=#0000BB]varchar[/color][color=#007700]]([/color][color=#0000BB]21[/color][color=#007700]) [/color][color=#0000BB]NOT NULL[/color][color=#007700],
[[/color][color=#0000BB]voteTime[/color][color=#007700]] [[/color][color=#0000BB]datetime[/color][color=#007700]] [/color][color=#0000BB]NOT NULL
[/color][color=#007700]) [/color][color=#0000BB]ON [/color][color=#007700][[/color][color=#0000BB]PRIMARY[/color][color=#007700]]
[/color][/color]
Tablo İçerikleri
- Kod:
[color=#000000][color=#0000BB]insert into SITE_NEWS values [/color][color=#007700]([/color][color=#DD0000]'1' [/color][color=#007700], [/color][color=#DD0000]'01.05.2010' [/color][color=#007700], [/color][color=#DD0000]'Baþlýk1' [/color][color=#007700], [/color][color=#DD0000]'Ýçerik1'[/color][color=#007700])
[/color][color=#0000BB]insert into SITE_NEWS values [/color][color=#007700]([/color][color=#DD0000]'2' [/color][color=#007700], [/color][color=#DD0000]'01.05.2010' [/color][color=#007700], [/color][color=#DD0000]'Baþlýk2' [/color][color=#007700], [/color][color=#DD0000]'Ýçerik2'[/color][color=#007700])
[/color][color=#0000BB]insert into SITE_NEWS values [/color][color=#007700]([/color][color=#DD0000]'3' [/color][color=#007700], [/color][color=#DD0000]'01.05.2010' [/color][color=#007700], [/color][color=#DD0000]'Baþlýk3' [/color][color=#007700], [/color][color=#DD0000]'Ýçerik3'[/color][color=#007700])
[/color][color=#0000BB]insert into SITE_NEWS values [/color][color=#007700]([/color][color=#DD0000]'4' [/color][color=#007700], [/color][color=#DD0000]'01.05.2010' [/color][color=#007700], [/color][color=#DD0000]'Baþlýk4' [/color][color=#007700], [/color][color=#DD0000]'Ýçerik4'[/color][color=#007700])
[/color][color=#0000BB]insert into SITE_NEWS values [/color][color=#007700]([/color][color=#DD0000]'5' [/color][color=#007700], [/color][color=#DD0000]'01.05.2010' [/color][color=#007700], [/color][color=#DD0000]'Baþlýk5' [/color][color=#007700], [/color][color=#DD0000]'Ýçerik5'[/color][color=#007700])
[/color][color=#0000BB]insert into SITE_NEWS values [/color][color=#007700]([/color][color=#DD0000]'6' [/color][color=#007700], [/color][color=#DD0000]'01.05.2010' [/color][color=#007700], [/color][color=#DD0000]'Baþlýk6' [/color][color=#007700], [/color][color=#DD0000]'Ýçerik6'[/color][color=#007700])
[/color][color=#0000BB]insert into VOTE_BUTTONS values [/color][color=#007700]([/color][color=#DD0000]'1' [/color][color=#007700], [/color][color=#DD0000]'Test1' [/color][color=#007700], [/color][color=#DD0000]'Buton Adý1'[/color][color=#007700])
[/color][color=#0000BB]insert into VOTE_REWARDS values [/color][color=#007700]([/color][color=#DD0000]'1' [/color][color=#007700], [/color][color=#DD0000]'10' [/color][color=#007700], [/color][color=#DD0000]'100010000' [/color][color=#007700], [/color][color=#DD0000]'100000000' [/color][color=#007700], [/color][color=#DD0000]'10'[/color][color=#007700]) [/color][/color]
Egerki bi sorunla karsılasırsanız enq-w0se@hotmail.com adrese ulaşın