emoline Mesaj: 1+
Kayıt: Jul 03, 2005 Mesajlar: 3 Konum: istanbul
|
Tarih: 2008-10-03, 01:39:30 Mesaj konusu: Veri Tabanından Üye Ve Puanlama Çagırma ???? |
|
|
Merhaba Sayın Yöneticiler ve Netopsiyon Ailesi Öncelikle Geçmiş Bayramınızı Kutlarım
Sizden İstedigim Bi kod war
Şimdi Bende Online Okey Tavla Batak Oyunları var Nukeye Monte Ettim Yanlız Ufak Bir Sorunum War
Nukeye Üye olanlar Otomatikmen Oyunlara girebiliyor
Ancak Okeyin Kullanmış Oldugu Üye Kayıt Tablosu ile Nukenin Üye Kayıt Tablosu Farklı Ben Okeyin Kullanmış oldugu Tablodan Üyelerin Puanlarını
Ve Üye Niklerini Hem okey hem Tavla Hem Batak Puanlarını Nasıl Çağırabilirim Tablo Kodlarını Aşşagıda Yazdım Eğer Hangi Kod İle Çagıracaksam Yazarsanız Sevinirim
xxxx Nukenin Kullanmış Oldugu Üye Tablosu XXXXXX
Kod:
|
CREATE TABLE `nuke_users` (
`user_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '0',
`user_rank` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_timezone` tinyint(4) NOT NULL default '10',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'english',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '0',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`points` int(10) default '0',
`last_ip` varchar(15) NOT NULL default '0',
`karma` tinyint(1) default '0',
`agreedtos` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`user_id`),
KEY `uid` (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`),
KEY `karma` (`karma`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Tablo döküm verisi `nuke_users`
--
INSERT INTO `nuke_users` VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', 'Nov 10, 2000', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 3, 0, 0, 1, 0, 0, 1, 0, 0, 0, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);
INSERT INTO `nuke_users` VALUES (2, '', 'Emrah', 'admin@msn.com', '', '', 'gallery/blank.gif', 'Sep 29, 2008', '', '', '', '', '', 0, NULL, '', '', '', '526165cfd30f197d79a1f5180f180d87', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 3, 1, 1, 2, 1, 0, 1, 1222896048, 0, 1222795302, 10, 1, 'turkish', 'D M d, Y g:i a', 0, 0, 1222896048, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, '', '', NULL, 0, '212.68.43.214', 0, 0);
INSERT INTO `nuke_users` VALUES (3, '', 'RooT', 'root@msn.com', '', '', 'blank.gif', 'Sep 29, 2008', '', '', '', '', '', 0, NULL, '', '', '', 'e10adc3949ba59abbe56e057f20f883e', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1222783477, 0, 1222783477, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '127.0.0.1', 0, 0);
INSERT INTO `nuke_users` VALUES (4, '', 'eMo', 'emrah.aydin@msn.com', '', '', 'gallery/blank.gif', 'Sep 29, 2008', NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, '526165cfd30f197d79a1f5180f180d87', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);
INSERT INTO `nuke_users` VALUES (5, 'Emrah', 'emoline', 'emrahs.aydin@msn.com', '', '', 'gallery/blank.gif', 'Sep 29, 2008', NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);
INSERT INTO `nuke_users` VALUES (6, 'Emrah', 'Kemal', 'emrash.aydin@msn.com', '', '', 'gallery/blank.gif', 'Sep 29, 2008', NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, '526165cfd30f197d79a1f5180f180d87', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);
INSERT INTO `nuke_users` VALUES (7, '', 'Erkan', 'erkan_48@windowslive.com', '', '', 'blank.gif', 'Sep 30, 2008', '', '', '', '', '', 0, NULL, '', '', '', 'c2610f901735286e712ef0a11df1535b', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 9, 0, 0, 1, 1, 0, 1, 1222938464, 0, 1222938447, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 1222879689, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '78.167.109.238', 0, 0);
INSERT INTO `nuke_users` VALUES (8, 'demo', 'demo', 'demo', 'demo@demo.com', '', 'blank.gif', 'Oct 01, 2008', '', '', '', '', '', 0, NULL, '', '', '', 'fe01ce2a7fbac8fafaed7c982a04e229', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1222969624, 0, 1222969624, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 1222969624, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '212.68.43.214', 0, 0);
INSERT INTO `nuke_users` VALUES (9, '', 'Esra', 'esra@esra.com', '', '', 'gallery/blank.gif', 'Oct 02, 2008', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 10, NULL, 'turkish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '0', 0, 0);
INSERT INTO `nuke_users` VALUES (10, '', 'Dogukan', 'farzet@msn.com', '', '', 'gallery/blank.gif', 'Oct 02, 2008', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '9f2b8dc2e421deb72da3453f54e968d3', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 10, NULL, 'turkish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '212.68.43.214', 0, 0);
|
XXXXX Buda Okey tavla batak Oyunlarının Kullanmış Olduğu Tablo XXXXX
Kod:
|
CREATE TABLE `preferences` (
`LOGIN` varchar(50) NOT NULL default '',
`PASSWORD` varchar(50) NOT NULL default '',
`NAME` varchar(50) NOT NULL default '',
`SURNAME` varchar(50) NOT NULL default '',
`EMAIL` varchar(50) NOT NULL default '',
`GENDER` enum('0','1','2') NOT NULL default '0',
`BIRTHDATE` int(4) default NULL,
`CITY` int(4) default NULL,
`JOB` int(4) default NULL,
`EDUCATION` int(2) default NULL,
`INTERESTS` varchar(50) default NULL,
`REGISTRATION_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
`REGISTERED_FROM` varchar(20) default NULL,
`USER_LEVEL` enum('0','1','2','3','4','5') NOT NULL default '0',
`ONLINE_GAME` int(1) default '0',
`MUTE_LIST` text,
`LAST_LOGIN_DATE` datetime default NULL,
`IMAGE` int(2) default '1',
`OK` int(1) default NULL,
`GENERAL_OPTIONS` varchar(20) default NULL,
`BATAK_OPTIONS` varchar(20) default NULL,
`OKEY_OPTIONS` varchar(20) default '2',
`TAVLA_OPTIONS` varchar(20) default NULL,
`CHAT_OPTIONS` varchar(20) default NULL,
`BATAK_STATS` varchar(50) default NULL,
`OKEY_STATS` varchar(50) default NULL,
`OTAVLA_STATS` varchar(50) default NULL,
`LAST_LOGIN_LOBBY` varchar(20) default NULL,
`TAVLA_STATS` varchar(50) default NULL,
`LOGIN_AMOUNT` int(6) NOT NULL default '0',
PRIMARY KEY (`LOGIN`),
FULLTEXT KEY `LOGIN` (`LOGIN`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Tablo döküm verisi `preferences`
--
INSERT INTO `preferences` VALUES ('Emrah', '526165cfd30f197d79a1f5180f180d87', '', '', '', '0', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', NULL, '5', 0, ' ', '2008-10-02 21:29:00', 1, 1, '1:1:1:1:1:1', '1:0', '2', '1:0:0', NULL, '1500:0:0:0:0:0', '1500:0:0:0:0:0', NULL, NULL, '1500:0:0:0:0', 0);
INSERT INTO `preferences` VALUES ('RooT', 'e10adc3949ba59abbe56e057f20f883e', '', '', '', '0', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', NULL, '0', 0, ' ', '2008-09-30 02:27:00', 1, 1, '1:1:1:1:1:1', '1:0', '2', '1:0:0', NULL, '1500:0:0:0:0:0', '1480:1:0:0:0:1', NULL, NULL, '1500:0:0:0:0', 0);
INSERT INTO `preferences` VALUES ('Erkan', 'c2610f901735286e712ef0a11df1535b', '', '', '', '0', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', NULL, '0', 0, ' ', '2008-10-02 12:05:00', 12, 1, '1:1:1:1:1:1', '1:0', '2', '1:0:0', NULL, '1500:0:0:0:0:0', '1440:3:0:0:0:3', NULL, NULL, '1500:0:0:0:0', 0);
INSERT INTO `preferences` VALUES ('demo', 'fe01ce2a7fbac8fafaed7c982a04e229', '', '', '', '0', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', NULL, '0', 0, ' ', '2008-10-02 21:50:00', 1, 1, '1:1:1:1:1:1', '1:0', '2', '1:0:0', NULL, '1500:0:0:0:0:0', '1500:0:0:0:0:0', NULL, NULL, '1500:0:0:0:0', 0);
INSERT INTO `preferences` VALUES ('Dogukan', '9f2b8dc2e421deb72da3453f54e968d3', '', '', '', '0', NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', NULL, '1', 0, ' ', '2008-10-02 01:09:00', 1, 1, '1:1:1:1:1:1', '1:0', '2', '1:0:0', NULL, '28000:0:0:0:0:0', '28000:0:0:0:0:0', NULL, NULL, '28000:0:0:0:0', 0);
|
Yapmak İstedigim Olayın Demosuda Burdadır
http://www.sanalkahve.com/modules/games/30.php
Eğer Cevap Yazarsanız Çok Sevinirim Teşekkürler Kolay Gelsin
Hee Bu arada Kullandıgım Nuke Sürümü 7.5
Cevap Yazarsanız Çok Sevinirim
Saygılarımla Emrah AYDIN |
|